Re: Large Database \d: ERROR: cache lookup failed for relation ...

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Thomas F(dot) O'Connell" <tf(at)o(dot)ptimized(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Large Database \d: ERROR: cache lookup failed for relation ...
Date: 2007-05-24 20:39:12
Message-ID: 20669.1180039152@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Thomas F. O'Connell" <tf(at)o(dot)ptimized(dot)com> writes:
> I'm dealing with a database where there are ~150,000 rows in
> information_schema.tables. I just tried to do a \d, and it came back
> with this:

> ERROR: cache lookup failed for relation [oid]

> Is this indicative of corruption, or is it possibly a resource issue?

It'd not be unexpected if other transactions were concurrently dropping
tables. If it's persistent (with the same OID mentioned) then you need
to worry.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Raymond O'Donnell 2007-05-24 20:59:18 Re: postgres - oid question
Previous Message Cyril VELTER 2007-05-24 20:37:50 [Re] Re: [Re] Re: [Re] Re: Winsock error 10035 while trying to upgrade from 8.0 to 8.2