Skip to content

[PG15 Online Upgrade] Upgrade from 2024, 2025 to 2.29.0.0-b192 is failing at pg_restore step #29458

@massifcoder-yb

Description

@massifcoder-yb

Jira Link: DB-19252

Description

Upgrade is failing at pg_restore step with error:
pg_restore: creating ACL "SCHEMA "public"" pg_restore: creating ACL "pg_catalog.TABLE "pg_stat_statements"" pg_restore: while PROCESSING TOC: pg_restore: from TOC entry 3048; 0 0 STATISTICS DATA bankaccounts_1_pkey (no owner) pg_restore: error: could not execute query: ERROR: Restarting a DDL transaction not supported Command was: SELECT * FROM pg_catalog.pg_restore_relation_stats( 'version', '110002'::integer, 'schemaname', 'public', 'relname', 'bankaccounts_1_pkey', 'relpages', '0'::integer, 'reltuples', '-1'::real, 'relallvisible', '0'::integer );

It is failing in 1 out of 3 runs.

Issue Type

kind/bug

Warning: Please confirm that this issue does not contain any sensitive information

  • I confirm this issue does not contain any sensitive information.

Metadata

Metadata

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions