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

From: Arne Henrik Segtnan <arne(at)basis-consulting(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Cc: Arne Henrik Segtnan <arne(at)basis-consulting(dot)com>
Subject: PostgreSQL upgrade from 10 to 12 fails with "ERROR: column r.relhasoids does not exist at character 1616"
Date: 2021-05-04 16:29:17
Message-ID: 701D76CE-2EF0-4955-AC16-36E86B85E4F6@basis-consulting.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)zabbix_db ERROR: column r.relhasoids does not exist at character 1616
2021-05-04 13:06:05.614 CEST [12890] postgres(at)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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2021-05-04 16:38:20 Re: PostgreSQL upgrade from 10 to 12 fails with "ERROR: column r.relhasoids does not exist at character 1616"
Previous Message Hans Buschmann 2021-05-04 15:50:39 AW: Huge performance penalty with parallel queries in Windows x64 v. Linux x64