X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id C7FA952A97 for ; Tue, 2 Aug 2005 23:55:14 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 86842-07 for ; Wed, 3 Aug 2005 02:55:06 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 0AA7252A03 for ; Tue, 2 Aug 2005 23:55:05 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id j732t2le026600; Tue, 2 Aug 2005 22:55:03 -0400 (EDT) To: Brock Williams Cc: pgsql-admin@postgresql.org Subject: Re: FATAL: cache lookup failed for access method 6881280 In-reply-to: <42F008F2.60509@cotcomsol.com> References: <42F008F2.60509@cotcomsol.com> Comments: In-reply-to Brock Williams message dated "Tue, 02 Aug 2005 17:59:46 -0600" Date: Tue, 02 Aug 2005 22:55:02 -0400 Message-ID: <26599.1123037702@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.567 tagged_above=0 required=5 tests=AWL, SUBJ_HAS_UNIQ_ID X-Spam-Level: X-Archive-Number: 200508/24 X-Sequence-Number: 18343 Brock Williams writes: > I'm getting this message when I try to access one of the databases in > my cluster: > FATAL: cache lookup failed for access method 6881280 Unless you are using a custom index access method you didn't tell us about, this is pretty strong evidence of data corruption in the pg_class system catalog (specifically some pg_class.relam entry). If the corruption extends only as far as those four bytes, it'd be pretty easy to poke the correct value back in ... but it seems likely that this is just the tip of the iceberg :-( Please get a copy of pg_filedump from http://sources.redhat.com/rhdb/utilities.html and show us a dump of the pg_class file from that database (I like the format it produces with -i -f options; note pg_class is file 1259 in all known PG versions). regards, tom lane