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

From: "Yoong S(dot) Chow" <chowy1026(at)gmail(dot)com>
To: Jeff Janes <jeff(dot)janes(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-19 06:54:41
Message-ID: CACdHDuqynHWfg7_9ri=-PyhxZ9orM5mSATf9kaHyNOMrWuzfig@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

Hi Jeff,

Could you please clarify what core files are? I am truly a newbie to
postgresql.

The pg_dump on both `postgres` and `postgis_raster` databases ran without
error. Attached is the posgtresql log.

Thank you,
Chow

On Sat, Feb 19, 2022 at 12:07 AM Jeff Janes <jeff(dot)janes(at)gmail(dot)com> wrote:

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

Attachment Content-Type Size
postgresql-12-2022-02-19_144631.log application/octet-stream 2.8 MB

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message liam saffioti 2022-02-20 11:49:09 Re: pg_upgrade from Postgresql-12 to Postgresql-13 fails with "Creating dump of database schemas postgres *failure*"
Previous 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*"

Browse pgsql-general by date

  From Date Subject
Next Message Tomas Pospisek 2022-02-19 14:35:36 Re: Strange results when casting string to double
Previous 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*"