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

2007-06-07 Thread Erik Jones
"Thomas F. O'Connell" 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?

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

2007-06-05 Thread Jim Nasby
I'm working with these guys to resolve the immediate issue, but I suspect there's a race condition somewhere in the code. What's happened is that OIDs have been changed in the system. There's not a lot of table DDL that happens, but there is a substantial amount of view DDL that can take pl

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

2007-06-05 Thread Erik Jones
I originally sent this message from my gmail account yesterday as we were having issues with our work mail servers yesterday, but seeing that it hasn't made it to the lists yet, I'm resending from my registered address. You have my apologies if you receive this twice. "Thomas F. O'Connell"

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

2007-05-24 Thread Tom Lane
"Thomas F. O'Connell" <[EMAIL PROTECTED]> 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 po

[GENERAL] Large Database \d: ERROR: cache lookup failed for relation ...

2007-05-24 Thread Thomas F. O'Connell
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? I don't see a lot of evidence of