Re: "PANIC: could not open critical system index 2662" - twice - Mailing list pgsql-general

From Evgeny Morozov
Subject Re: "PANIC: could not open critical system index 2662" - twice
Date
Msg-id 01020187eae42315-1cc83aed-2b4f-4c9e-ae36-ee82778f7154-000000@eu-west-1.amazonses.com
Whole thread Raw
In response to Re: "PANIC: could not open critical system index 2662" - twice  (Thomas Munro <thomas.munro@gmail.com>)
Responses Re: "PANIC: could not open critical system index 2662" - twice
List pgsql-general
On 5/05/2023 2:02 am, Thomas Munro wrote:
On Fri, May 5, 2023 at 11:15 AM Thomas Munro <thomas.munro@gmail.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.


pgsql-general by date:

Previous
From: Luca Ferrari
Date:
Subject: connecting to localhost -> ::1 client_addr ?
Next
From: Andrew Gierth
Date:
Subject: Re: "PANIC: could not open critical system index 2662" - twice