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 -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
