Cache lookup failed !!!

Started by Sivaraman K.Gover 20 years ago2 messagesbugs
Jump to latest
#1Sivaraman K.G
Ganapathy.Sivaraman@alcatel.com

Hi all,

I have the following problem in my testbed :

PostgreSQL version: 8.0
Operating system: Solaris 8.0
Description: Cache lookup failed.

I am running PostgreSQL ver. 8.0 with table space setup'ed for
CTBLISTDB.

\d command used to give the existing relations in the database.
But now it is saying :
ERROR : Cache lookup failed for relation 17233.
I could not able to proceed further. Any help ??

$ psql CTBLISTDB
Welcome to psql 8.0.0, the PostgreSQL interactive terminal.

Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit

CTBLISTDB=# \d
ERROR : Cache lookup failed for relation 17233

Thanks
Siva

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Sivaraman K.G (#1)
Re: Cache lookup failed !!!

"Sivaraman K.G" <Ganapathy.Sivaraman@alcatel.com> writes:

\d command used to give the existing relations in the database.
But now it is saying :
ERROR : Cache lookup failed for relation 17233.

Not a lot of information to go on here. What do you get from

select * from pg_class where oid = 17233;

Can you do other operations besides \d?

regards, tom lane