Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

Next:From: Martin PittDate: 2009-01-05 12:47:07
Subject: Re: Bug#506196: Debian Bug#506196: postgresql: consume toomuch power when idle (>10 wakeups/second)
Previous:From: Simon RiggsDate: 2009-01-05 12:13:09
Subject: Re: Bug#506196: Debian Bug#506196: postgresql: consume toomuch power when idle (>10 wakeups/second)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group