cache lookup failed for index

From: Nathan Robertson <nathan(dot)robertson(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: cache lookup failed for index
Date: 2010-06-30 02:21:25
Message-ID: AANLkTilzUWnxCjomBRHkByi6tHeS8fDIRNqvU9WCsv1G@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi Everyone,

So I have a small web cluster that I'm running PSQL on. today, Apache failed
which caused PSQL to fail which at some point caused some data in the
database to become corrupt. So, now when I try to connect to the data in the
database in question I get: FATAL: cache lookup failed for index 2662. I
get this when I try to connect on the standalone console or when I try to
connect to the running server. So, this is going to sound terrible but there
is no current backup of this database. As the admin this is really
embarrassing and I know I messed up.

That said, could someone point me in the right direction for restoring this?
I've tried to reindex which doesn't work because I can't even connect to the
database in question. If I try to connect through the standalone console to
the system and reindex the entire system the same error message pops up in
the list.

What information can I provide that would help?

CentOS 5.5
PostgreSQL 8.1.21

This is the information from postgresql-Tue.log:
LOG: database system was interrupted at 2010-06-29 17:08:49 EDT
LOG: checkpoint record is at 0/3788A208
LOG: redo record is at 0/3788A208; undo record is at 0/0; shutdown TRUE
LOG: next transaction ID: 610809; next OID: 28328
LOG: next MultiXactId: 8; next MultiXactOffset: 15
LOG: database system was not properly shut down; automatic recovery in
progress
LOG: record with zero length at 0/3788A258
LOG: redo is not required
LOG: database system is ready
LOG: transaction ID wrap limit is 2147484146, limited by database
"postgres"
LOG: database system was interrupted at 2010-06-29 19:52:08 EDT
LOG: checkpoint record is at 0/3788A258
LOG: redo record is at 0/3788A258; undo record is at 0/0; shutdown TRUE
LOG: next transaction ID: 610809; next OID: 28328
LOG: next MultiXactId: 8; next MultiXactOffset: 15
LOG: database system was not properly shut down; automatic recovery in
progress
LOG: record with zero length at 0/3788A2A8
LOG: redo is not required
LOG: database system is ready
LOG: transaction ID wrap limit is 2147484146, limited by database
"postgres"
FATAL: cache lookup failed for index 2662

Any help in this matter would be GREATLY appreciated.

Nate Robertson

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Kevin Grittner 2010-06-30 13:36:20 Re: cache lookup failed for index
Previous Message Vibhor Kumar 2010-06-29 09:55:58 Re: [NOVICE] Prepared statement issue in Pgpool-II