Re: ERROR: syscache lookup for index 245488730 failed

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jakub Ouhrabka <jouh8664(at)ss1000(dot)ms(dot)mff(dot)cuni(dot)cz>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: ERROR: syscache lookup for index 245488730 failed
Date: 2003-01-28 16:03:46
Message-ID: 13532.1043769826@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Jakub Ouhrabka <jouh8664(at)ss1000(dot)ms(dot)mff(dot)cuni(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ryan VanderBijl 2003-01-28 16:08:37 serialization errors
Previous Message Travis Bauer 2003-01-28 16:01:12 Re: Status of tablespaces