Re: pg_upgrade from Postgresql-12 to Postgresql-13 fails with "Creating dump of database schemas postgres *failure*"

From: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
To: "Yoong S(dot) Chow" <chowy1026(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org>, Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: pg_upgrade from Postgresql-12 to Postgresql-13 fails with "Creating dump of database schemas postgres *failure*"
Date: 2022-02-18 16:07:18
Message-ID: CAMkU=1zsmM=cuDtxDCFbDgSg4g4frxiuPs-8J8pEU-97-h0XOA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

On Fri, Feb 18, 2022 at 8:35 AM Yoong S. Chow <chowy1026(at)gmail(dot)com> wrote:

>
> Here are the logs: pg_upgrade_server.log <https://pastebin.com/ePDpmheE>,
> pg_upgrade_dump_13427.log <https://pastebin.com/YTsU4hYh> and
> tail_postgresql-12-2022-02-16_190344.log <https://pastebin.com/KP8ePVct>.
>

From that last log file we have:

1. 2022-02-16 19:04:35 +08 [303982]: [4957-1] session=620cda42.4a36e,user
=postgres,db=postgis_raster,app=pg_dump,client=[local] | LOG:
disconnection: session time: 0:00:01.101 user=postgres
database=postgis_raster
host=[local]
2. free(): invalid pointer

and then a little later:

1. 2022-02-16 19:04:35 +08 [303791]: [7-1] session=620cda0f.4a2af,user=,
db=,app=,client= | LOG: server process (PID 303982) was terminated by
signal 6: Aborted

Do you get any core files for 303982? Do you have core dumps enabled?
What do you get if you run a manual pg_dump -s on db postgis_raster?

Cheers,

Jeff

>

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Yoong S. Chow 2022-02-19 06:46:24 Re: pg_upgrade from Postgresql-12 to Postgresql-13 fails with "Creating dump of database schemas postgres *failure*"
Previous Message Marcia Rocha 2022-02-18 15:51:19 linux - postgresql14-contrib- did not work with lipython3.7

Browse pgsql-general by date

  From Date Subject
Next Message Carsten Klein 2022-02-18 17:07:35 Re: Strange results when casting string to double
Previous Message Pavel Stehule 2022-02-18 15:40:07 Re: 2 phase commit with FDW