From: Jerry Sievers <jerry@jerrysievers.com>
To: pgsql-admin@postgresql.org
Subject: OID cache lookups failing
Date: 14 Jul 2006 14:26:54 -0400
Message-ID: <m3y7uwvy8h.fsf@prod01.jerrysievers.com> (raw)
Admins; we have a few corrupt objects after a disk array event
yesterday. One of the problems was resolved by simply dropping and
reloading a table from backup.
I have another table however that's going to b a stinker. I can't
drop, rename or re-schema it.
We have 2 tabs with same name in different schemas and the active one
was being thrashed at the same time as the disk array went wonky.
Of particular interest, I notice that I can't get the pg_class record
that corresponds to the OID in question however the one for the other
version of the table does come up.
= drop table reports.problem_table;
ERROR: cache lookup failed for relation 104140413
= select oid from pg_class where relname = 'problem_table';
oid
-----------
19296
104140413
(2 rows)
= select relname from pg_class where oid in (select oid from pg_class where relname = 'problem_table');
relname
-----------------------
problem_table
(1 row)
The low numbered OID rec is the one showing above.
Any ideas how to fix? This is on a busy prod system. Reindexing
pg_class worth a try?
Thanks
--
-------------------------------------------------------------------------------
Jerry Sievers 305 854-3001 (home) WWW ECommerce Consultant
305 321-1144 (mobile http://www.JerrySievers.com/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: jerry@jerrysievers.com
Subject: Re: OID cache lookups failing
In-Reply-To: <m3y7uwvy8h.fsf@prod01.jerrysievers.com>
References: <m3y7uwvy8h.fsf@prod01.jerrysievers.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox