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

From Jakub Ouhrabka
Subject ERROR: syscache lookup for index 245488730 failed
Date
Msg-id Pine.LNX.4.44.0301280851390.3759-100000@server
Whole thread Raw
Responses Re: ERROR: syscache lookup for index 245488730 failed
List pgsql-general
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


pgsql-general by date:

Previous
From: "Shridhar Daithankar"
Date:
Subject: Re: how much memory to allot to postgres?
Next
From: frbn
Date:
Subject: Re: question regarding regular expressions