ERROR: syscache lookup for index 245488730 failed

From: Jakub Ouhrabka <jouh8664(at)ss1000(dot)ms(dot)mff(dot)cuni(dot)cz>
To: pgsql-general(at)postgresql(dot)org
Subject: ERROR: syscache lookup for index 245488730 failed
Date: 2003-01-28 08:21:08
Message-ID: Pine.LNX.4.44.0301280851390.3759-100000@server
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message frbn 2003-01-28 08:27:28 Re: question regarding regular expressions
Previous Message Shridhar Daithankar 2003-01-28 07:53:03 Re: how much memory to allot to postgres?