pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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/



Message-ID: <m3y7uwvy8h.fsf@prod01.jerrysievers.com>
Permalink:  ../m3y7uwvy8h.fsf@prod01.jerrysievers.com/
Also on:    postgresql.org/message-id/m3y7uwvy8h.fsf@prod01.jerrysievers.com

 · 

reply

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