Re: Large Database \d: ERROR: cache lookup failed for relation ... - Mailing list pgsql-general

From Tom Lane
Subject Re: Large Database \d: ERROR: cache lookup failed for relation ...
Date
Msg-id 20669.1180039152@sss.pgh.pa.us
Whole thread Raw
In response to Large Database \d: ERROR: cache lookup failed for relation ...  ("Thomas F. O'Connell" <tf@o.ptimized.com>)
List pgsql-general
"Thomas F. O'Connell" <tf@o.ptimized.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

pgsql-general by date:

Previous
From: "Cyril VELTER"
Date:
Subject: [Re] Re: [Re] Re: [Re] Re: Winsock error 10035 while trying to upgrade from 8.0 to 8.2
Next
From: Raymond O'Donnell
Date:
Subject: Re: postgres - oid question