Re: FATAL: cache lookup failed for access method 6881280

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: FATAL: cache lookup failed for access method 6881280
Дата
Msg-id 26599.1123037702@sss.pgh.pa.us
обсуждение исходный текст
Ответ на FATAL: cache lookup failed for access method 6881280  (Brock Williams <brock@cotcomsol.com>)
Ответы Re: FATAL: cache lookup failed for access method 6881280  (Brock Williams <brock@cotcomsol.com>)
Список pgsql-admin
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

В списке pgsql-admin по дате отправления:

Предыдущее
От: Brock Williams
Дата:
Сообщение: Re: FATAL: cache lookup failed for access method 6881280
Следующее
От: Brock Williams
Дата:
Сообщение: Re: FATAL: cache lookup failed for access method 6881280