PANIC: failed to re-find parent key in "100924" for split pages 1606/1673

From: val <valiouk(at)yahoo(dot)co(dot)uk>
To: pgsql-bugs(at)postgresql(dot)org
Subject: PANIC: failed to re-find parent key in "100924" for split pages 1606/1673
Date: 2009-01-05 12:37:22
Message-ID: 328443.42038.qm@web25805.mail.ukl.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hi All,

I have a database that refuses to start due to the afformentioned error. I am running POstgreSQL 8.1.11 on a Debian Etch box.

Does anyone know what this error means and how to recover from it?

Any help will be very much appreciated.

Thanks,
Val

P.S. Here is the complete output I get

Jan 5 10:36:29 db2 postgres[17111]: [2-1] LOG: database system was interrupted while in recovery at 2009-01-05 10:24:37 GMT
Jan 5 10:36:29 db2 postgres[17111]: [2-2] HINT: This probably means that some data is corrupted and you will have to use the last backup for recovery.
Jan 5 10:36:29 db2 postgres[17111]: [3-1] LOG: checkpoint record is at 122/D080660
Jan 5 10:36:29 db2 postgres[17111]: [4-1] LOG: redo record is at 122/D00060C; undo record is at 0/0; shutdown FALSE
Jan 5 10:36:29 db2 postgres[17111]: [5-1] LOG: next transaction ID: 2664007622; next OID: 521067
Jan 5 10:36:29 db2 postgres[17111]: [6-1] LOG: next MultiXactId: 1; next MultiXactOffset: 0
Jan 5 10:36:29 db2 postgres[17111]: [7-1] LOG: database system was not properly shut down; automatic recovery in progress
Jan 5 10:36:29 db2 postgres[17111]: [8-1] LOG: redo starts at 122/D00060C
Jan 5 10:36:29 db2 postgres[17112]: [2-1] LOG: incomplete startup packet
Jan 5 10:36:29 db2 postgres[17111]: [9-1] LOG: record with zero length at 122/E914B48
Jan 5 10:36:29 db2 postgres[17111]: [10-1] LOG: redo done at 122/E914B20
Jan 5 10:36:29 db2 postgres[17111]: [11-1] PANIC: failed to re-find parent key in "100924" for split pages 1606/1673
Jan 5 10:36:29 db2 postgres[17110]: [2-1] LOG: startup process (PID 17111) was terminated by signal 6
Jan 5 10:36:29 db2 postgres[17110]: [3-1] LOG: aborting startup due to startup process failure

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Martin Pitt 2009-01-05 12:47:07 Re: Bug#506196: Debian Bug#506196: postgresql: consume too much power when idle (>10 wakeups/second)
Previous Message Simon Riggs 2009-01-05 12:13:09 Re: Bug#506196: Debian Bug#506196: postgresql: consume too much power when idle (>10 wakeups/second)