pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Brock Williams <brock@cotcomsol.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: FATAL: cache lookup failed for access method 6881280
Date: Tue, 02 Aug 2005 22:11:04 -0600
Message-ID: <42F043D8.5030707@cotcomsol.com> (raw)
In-Reply-To: <26599.1123037702@sss.pgh.pa.us>
References: <42F008F2.60509@cotcomsol.com>
	<26599.1123037702@sss.pgh.pa.us>

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Tried to post directy to the list but I got a bounce back.  Must be too
big...

Here it is posted to my web site:
http://www.cotcomsol.com/~brock/postgresql_debug.txt

Thanks for the help,
Brock

Tom Lane wrote:
> Brock Williams <brock@cotcomsol.com> 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
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.0 (FreeBSD)

iD8DBQFC8EPYgMCVEEcrWuIRAhCcAJ9RZEMrKFpbRfjHOVW1Vfj6eys+VgCfaKhA
2EV6MSgumAvDv+Lv0k2WrdI=
=IZnE
-----END PGP SIGNATURE-----



view thread (7+ messages)  latest in thread

Message-ID: <42F043D8.5030707@cotcomsol.com>
Permalink:  ../42F043D8.5030707@cotcomsol.com/
Also on:    postgresql.org/message-id/42F043D8.5030707@cotcomsol.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: brock@cotcomsol.com
  Subject: Re: FATAL: cache lookup failed for access method 6881280
  In-Reply-To: <42F043D8.5030707@cotcomsol.com>
  References: <42F008F2.60509@cotcomsol.com> <26599.1123037702@sss.pgh.pa.us> <42F043D8.5030707@cotcomsol.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