Re: ERROR: syscache lookup for index 245488730 failed - Mailing list pgsql-general

From Tom Lane
Subject Re: ERROR: syscache lookup for index 245488730 failed
Date
Msg-id 13532.1043769826@sss.pgh.pa.us
Whole thread Raw
In response to ERROR: syscache lookup for index 245488730 failed  (Jakub Ouhrabka <jouh8664@ss1000.ms.mff.cuni.cz>)
List pgsql-general
Jakub Ouhrabka <jouh8664@ss1000.ms.mff.cuni.cz> writes:
> I've found this message in my server log:
> ERROR:  syscache lookup for index 245488730 failed

Grepping the sources says that the only occurrence of that error string
is in pg_get_indexdef().  I think you must have been doing
pg_get_indexdef() on an index that just got dropped; perhaps someone
was selecting from the pg_indexes view while tables were being modified?

            regards, tom lane

pgsql-general by date:

Previous
From: Travis Bauer
Date:
Subject: Re: Status of tablespaces
Next
From: Ryan VanderBijl
Date:
Subject: serialization errors