X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id EBDE39FAD5A for ; Fri, 14 Jul 2006 15:36:26 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 34992-02 for ; Fri, 14 Jul 2006 15:36:22 -0300 (ADT) X-Greylist: delayed 00:09:26.275493 by SQLgrey- Received: from prod01.jerrysievers.com (adsl-64-118-249-70.netrox.net [64.118.249.70]) by postgresql.org (Postfix) with ESMTP id 0B8BF9FAC76 for ; Fri, 14 Jul 2006 15:36:21 -0300 (ADT) Received: (from gsievers@localhost) by prod01.jerrysievers.com (8.11.0/8.11.0) id k6EIQsk09733; Fri, 14 Jul 2006 14:26:54 -0400 To: pgsql-admin@postgresql.org Subject: OID cache lookups failing From: Jerry Sievers Date: 14 Jul 2006 14:26:54 -0400 Message-ID: Lines: 45 X-Mailer: Gnus v5.7/Emacs 20.7 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200607/121 X-Sequence-Number: 22367 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/