From: | PG Bug reporting form <noreply(at)postgresql(dot)org> |
---|---|
To: | pgsql-bugs(at)lists(dot)postgresql(dot)org |
Cc: | franz-josef(dot)faerber(at)stmuk(dot)bayern(dot)de |
Subject: | BUG #18154: Corrupt DB: pg_dump segfaults or returns empty |
Date: | 2023-10-11 07:16:49 |
Message-ID: | 18154-06f6f7a2806eb226@postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 18154
Logged by: Franz-Josef Färber
Email address: franz-josef(dot)faerber(at)stmuk(dot)bayern(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Robert Haas | 2023-10-11 14:44:06 | Re: BUG #18146: Rows reappearing in Tables after Auto-Vacuum Failure in PostgreSQL on Windows |
Previous Message | Bruce Momjian | 2023-10-10 20:05:11 | Re: FW: Query execution failure |