Thread: ERROR: syscache lookup for index 245488730 failed

ERROR: syscache lookup for index 245488730 failed

From
Jakub Ouhrabka
Date:
Hi,

I've found this message in my server log:
ERROR:  syscache lookup for index 245488730 failed

What is cause of this error and how can I avoid it?

I think that this is caused by issuing commands like "reindex table xxx;"
from cron and simoultaneously running pl/pgsql functions using these
indexes. But this error occures only sometimes. How can I do regular
reindex safely?

I was thinking about wrapping the reindex command and recreation of
pl/pgsql functions in a transaction but it's not possible...

This is on 7.2.

Thanks               kuba


Re: ERROR: syscache lookup for index 245488730 failed

From
Tom Lane
Date:
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