PostgreSQL upgrade from 10 to 12 fails with "ERROR: column r.relhasoids does not exist at character 1616" - Mailing list pgsql-general

From Arne Henrik Segtnan
Subject PostgreSQL upgrade from 10 to 12 fails with "ERROR: column r.relhasoids does not exist at character 1616"
Date
Msg-id 701D76CE-2EF0-4955-AC16-36E86B85E4F6@basis-consulting.com
Whole thread Raw
Responses Re: PostgreSQL upgrade from 10 to 12 fails with "ERROR: column r.relhasoids does not exist at character 1616"
Re: PostgreSQL upgrade from 10 to 12 fails with "ERROR: column r.relhasoids does not exist at character 1616"
List pgsql-general
Hi, 

When trying to upgrade from PostgreSQL 10 to 12, the installation fails as shown below. 

# pg_upgradecluster --link --method=upgrade 10 main /dbdata/zabbix


From PosgreSQL log: 
2021-05-04 13:06:04.780 CEST [12861] LOG:  database system is ready to accept connections
 done
server started
.
.
2021-05-04 13:06:05.614 CEST [12890] postgres@zabbix_db ERROR:  column r.relhasoids does not exist at character 1616
2021-05-04 13:06:05.614 CEST [12890] postgres@zabbix_db STATEMENT:
-- For binary upgrade, must preserve pg_type oid

SELECT pg_catalog.binary_upgrade_set_next_pg_type_oid('162222'::pg_catalog.oid);
-- For binary upgrade, must preserve pg_type array oid
SELECT pg_catalog.binary_upgrade_set_next_array_pg_type_oid('162221'::pg_catalog.oid);


-- For binary upgrade, must preserve pg_class oids
SELECT pg_catalog.binary_upgrade_set_next_heap_pg_class_oid('162220'::pg_catalog.oid);


CREATE VIEW "repack"."tables" AS
SELECT ("r"."oid")::"regclass" AS "relname",
    "r"."oid" AS "relid",
    "r"."reltoastrelid",
        CASE
.
.
.
command: "/usr/lib/postgresql/12/bin/pg_ctl" -w -D "/etc/postgresql/12/main" -o "" -m fast stop >> "pg_upgrade_server.log" 2>&1
2021-05-04 13:06:05.641 CEST [12861] LOG:  received fast shutdown request
2021-05-04 13:06:05.641 CEST [12861] LOG:  aborting any active transactions
waiting for server to shut down....2021-05-04 13:06:05.644 CEST [12861] LOG:  background worker "logical replication launcher" (PID 12867) exited with exit code 1
2021-05-04 13:06:05.645 CEST [12863] LOG:  shutting down
2021-05-04 13:06:05.657 CEST [12861] LOG:  database system is shut down
 done
server stopped

- Other upgrade methods (clone/dump) fails with the same errors. 

OS info: 
NAME="Ubuntu"
VERSION="20.04.2 LTS (Focal Fossa)"

Linux <server> 5.4.0-72-generic #80-Ubuntu SMP  x86_64 x86_64 x86_64 GNU/Linux


Anyone seen similar issue? 
Please advise. 


Best regards, 

Arne Segtnan


pgsql-general by date:

Previous
From: Hans Buschmann
Date:
Subject: AW: Huge performance penalty with parallel queries in Windows x64 v. Linux x64
Next
From: Bruce Momjian
Date:
Subject: Re: PostgreSQL upgrade from 10 to 12 fails with "ERROR: column r.relhasoids does not exist at character 1616"