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


---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Michael Guerin <guerin (AT) rentec (DOT) com> writes:
"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

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo (AT) postgresql (DOT) org)

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:


---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org