Thread: cache lookup failed for relation

Last night our server crashed and  now we're getting these cache lookup
errors.  I've rebuilt the indexes on pg_attribute and pg_class, plus all
the user tables.  Vacuum comes back clean,  is there someplace else that
I should look?  I'm assuming a pg_dump/restore will resolve my issues,
but I'm trying to understand whats going on.  (version 7.4.2)

Thanks
Micahel

Michael Guerin <guerin@rentec.com> writes:
> Last night our server crashed and  now we're getting these cache lookup
> errors.

"These" being what exactly?  Let's see verbose error output (psql
\set VERBOSITY verbose), or even better a stack traceback from
errfinish.

            regards, tom lane

The error jdbc is catching is:

Caused by: org.postgresql.util.PSQLException: ERROR: cache lookup failed for relation 357272221

when executing:

select * into temp table t from fnGetCompositeIds2(4130059995);

The unfortunate thing is that its not reproducible in psql, and only
shows up when a number of clients are going against the database.  I'll
dig further for more information.

thanks
michael


Tom Lane wrote:

>Michael Guerin <guerin@rentec.com> writes:
>
>
>>Last night our server crashed and  now we're getting these cache lookup
>>errors.
>>
>>
>
>"These" being what exactly?  Let's see verbose error output (psql
>\set VERBOSITY verbose), or even better a stack traceback from
>errfinish.
>
>            regards, tom lane
>
>