From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: franz-josef.faerber@stmuk.bayern.de
Subject: BUG #18154: Corrupt DB: pg_dump segfaults or returns empty
Date: Wed, 11 Oct 2023 07:16:49 +0000
Message-ID: <18154-06f6f7a2806eb226@postgresql.org> (raw)
The following bug has been logged on the website:
Bug reference: 18154
Logged by: Franz-Josef Färber
Email address: franz-josef.faerber@stmuk.bayern.de
PostgreSQL version: 15.4
Operating system: Ubuntu, Debian, Windows
Description:
Hello,
somehow I had managed to corrupt my database (postgres 15.4). At least I can
say I could still access many database objects, but
* VACCUM FULL fails with error "uncommitted xmin 4518 from before xid cutoff
7279 needs to be frozen"
* Further investigating, at least the table pg_statistic seems to be
corrupt, I cannot query it with SELECT.
* The tips in https://gist.github.com/supix/80f9a6111dc954cf38ee99b9dedf187a
didn't work.
But this is is not the reason I file this bug report. The reason is the
behaviour of pg_dump.
pg_dump 15.4 on Ubuntu segfaults. Shouldn't it at least print a meaningful
error message and exit cleanly?
By the way, pg_dump 16 on Windows seems to exit cleanly, dumping exactly
nothing onto stdout.
These behaviours were observed using a command line like "psql --host=myhost
--username=myuser mydb".
Regards,
fjf2002
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: noreply@postgresql.org, pgsql-bugs@lists.postgresql.org, franz-josef.faerber@stmuk.bayern.de
Subject: Re: BUG #18154: Corrupt DB: pg_dump segfaults or returns empty
In-Reply-To: <18154-06f6f7a2806eb226@postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox