Thread: pg_upgrade fails: "Mismatch of relation OID in database" - 9.2.4 to 9.3.2
I've tried to upgrade a large production database from 9.2.4 to 9.3.2 using pg_upgradecluster (using pg_upgrade method) and it fails with the error below. Upgrade using dump/restore seems to work on a test system but would require a too long downtime on the production system. # pg_upgradecluster --method=upgrade 9.2 main /data/postgresql/9.3/main [...] Removing support functions from new cluster ok Copying user relation files /data/postgresql/9.2/main/base/12034/7174572 Mismatch of relation OID in database "rg_www": old OID 22046, new OID 17671 Failure, exiting Error: pg_upgrade run failed [...] Any thoughts? How can this be fixed? Regards, SW.
Re: pg_upgrade fails: "Mismatch of relation OID in database" - 9.2.4 to 9.3.2
From
Adrian Klaver
Date:
On 01/21/2014 05:42 AM, Stefan Warten wrote: > I've tried to upgrade a large production database from 9.2.4 to 9.3.2 > using pg_upgradecluster (using pg_upgrade method) and it fails with the > error below. Upgrade using dump/restore seems to work on a test system > but would require a too long downtime on the production system. > > # pg_upgradecluster --method=upgrade 9.2 main /data/postgresql/9.3/main > [...] > Removing support functions from new cluster ok > Copying user relation files > /data/postgresql/9.2/main/base/12034/7174572 > Mismatch of relation OID in database "rg_www": old OID 22046, new OID 17671 > Failure, exiting > Error: pg_upgrade run failed > [...] > > Any thoughts? How can this be fixed? Not sure, but it would help if you provided information on what distribution you are running and the version of said distribution. I ask because a quick search on pg_upgradecluster did not show the --method switch. > > Regards, SW. > > -- Adrian Klaver adrian.klaver@gmail.com
Re: pg_upgrade fails: "Mismatch of relation OID in database" - 9.2.4 to 9.3.2
From
Stefan Warten
Date:
Ubuntu 12.04.2 LTS with packages from apt.postgresql.org repo. pg_upgradecluster is the one from postgresql-common=151.pgdg12.4+1. On 21.01.2014 16:36, Adrian Klaver wrote: > On 01/21/2014 05:42 AM, Stefan Warten wrote: >> I've tried to upgrade a large production database from 9.2.4 to 9.3.2 >> using pg_upgradecluster (using pg_upgrade method) and it fails with the >> error below. Upgrade using dump/restore seems to work on a test system >> but would require a too long downtime on the production system. >> >> # pg_upgradecluster --method=upgrade 9.2 main /data/postgresql/9.3/main >> [...] >> Removing support functions from new cluster ok >> Copying user relation files >> /data/postgresql/9.2/main/base/12034/7174572 >> Mismatch of relation OID in database "rg_www": old OID 22046, new OID 17671 >> Failure, exiting >> Error: pg_upgrade run failed >> [...] >> >> Any thoughts? How can this be fixed? > > Not sure, but it would help if you provided information on what > distribution you are running and the version of said distribution. I ask > because a quick search on pg_upgradecluster did not show the --method > switch. > >> >> Regards, SW. >> >> > >
Re: pg_upgrade fails: "Mismatch of relation OID in database" - 9.2.4 to 9.3.2
From
Adrian Klaver
Date:
On 01/21/2014 08:13 AM, Stefan Warten wrote: > Ubuntu 12.04.2 LTS with packages from apt.postgresql.org repo. > pg_upgradecluster is the one from postgresql-common=151.pgdg12.4+1. Alright I see --method is there, just not in the man pages I was looking at. Reading through the script I see it will not work for installations with user created tablespaces. In the low hanging fruit category, is that by any chance the case here? Should not that be the case. log into the database rg_www and: select * from pg_class where oid = 22046; This should return the relation that pg_upgrade is having a problem with. See below for details on the information returned: http://www.postgresql.org/docs/9.2/interactive/catalog-pg-class.html This might narrow down where the problem is. > > > On 21.01.2014 16:36, Adrian Klaver wrote: >> On 01/21/2014 05:42 AM, Stefan Warten wrote: >>> I've tried to upgrade a large production database from 9.2.4 to 9.3.2 >>> using pg_upgradecluster (using pg_upgrade method) and it fails with the >>> error below. Upgrade using dump/restore seems to work on a test system >>> but would require a too long downtime on the production system. >>> >>> # pg_upgradecluster --method=upgrade 9.2 main /data/postgresql/9.3/main >>> [...] >>> Removing support functions from new cluster ok >>> Copying user relation files >>> /data/postgresql/9.2/main/base/12034/7174572 >>> Mismatch of relation OID in database "rg_www": old OID 22046, new OID 17671 >>> Failure, exiting >>> Error: pg_upgrade run failed >>> [...] >>> >>> Any thoughts? How can this be fixed? >> >> Not sure, but it would help if you provided information on what >> distribution you are running and the version of said distribution. I ask >> because a quick search on pg_upgradecluster did not show the --method >> switch. >> >>> >>> Regards, SW. >>> >>> >> >> > > -- Adrian Klaver adrian.klaver@gmail.com