From: | Evgeny Morozov <postgresql3(at)realityexists(dot)net> |
---|---|
To: | Thomas Munro <thomas(dot)munro(at)gmail(dot)com> |
Cc: | PostgreSQL General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: "PANIC: could not open critical system index 2662" - twice |
Date: | 2023-05-05 07:50:32 |
Message-ID: | 01020187eae42315-1cc83aed-2b4f-4c9e-ae36-ee82778f7154-000000@eu-west-1.amazonses.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 5/05/2023 2:02 am, Thomas Munro wrote:
> On Fri, May 5, 2023 at 11:15 AM Thomas Munro <thomas(dot)munro(at)gmail(dot)com> wrote:
>> What does select
>> pg_relation_filepath('pg_class_oid_index') show in the corrupted
>> database, base/5/2662 or something else?
> Oh, you can't get that far, but perhaps you could share the
> pg_filenode.map file?
Hi Thomas, thanks very much for looking into this!
Indeed, I cannot get that far due to the same error. I read about
ignore_system_indexes, but...
# sudo -u postgres psql -w -p 5434 -c "set ignore_system_indexes=on";
ERROR: parameter "ignore_system_indexes" cannot be set after connection
start
I'm not sure how to set it BEFORE connection start, but without
restarting the server (which I'd rather avoid if I can).
The OID of the bad DB ('test_behavior_638186279733138190') is 1414389
and I've uploaded base/1414389/pg_filenode.map and also base/5/2662 (in
case that's helpful) as
https://objective.realityexists.net/temp/pgstuff1.zip
> Maybe you still have enough WAL if it happened recently?
Maybe! What should I do with pg_waldump? I've never used it before.
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Gierth | 2023-05-05 08:38:48 | Re: "PANIC: could not open critical system index 2662" - twice |
Previous Message | Luca Ferrari | 2023-05-05 07:23:09 | connecting to localhost -> ::1 client_addr ? |