Обсуждение: 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.

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

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.
>>
>>
>
>

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