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 interr=
upted 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 recover=
y.
Jan 5 10:36:29 db2 postgres[17111]: [3-1] LOG: checkpoint record is at 12=
2/D080660
Jan 5 10:36:29 db2 postgres[17111]: [4-1] LOG: redo record is at 122/D000=
60C; undo record is at 0/0; shutdown FALSE
Jan 5 10:36:29 db2 postgres[17111]: [5-1] LOG: next transaction ID: 26640=
07622; 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 pr=
operly 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 paren=
t 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 st=
artup process failure