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