val <valiouk@yahoo.co.uk> writes:
> I have a database that refuses to start due to the afformentioned error. I am running POstgreSQL 8.1.11 on a Debian
Etchbox.
> Jan 5 10:36:29 db2 postgres[17111]: [11-1] PANIC: failed to re-find parent key in "100924" for split pages
1606/1673
Hmm ... I wonder if this is telling us that our patch here was
incomplete?
http://archives.postgresql.org/pgsql-committers/2006-11/msg00004.php
At the time we thought this failure could only occur during _bt_pagedel
but you have evidently got a case where a split is failing. It might
just be garden-variety index corruption, or it might be a real bug.
Is this database sufficiently small and non-proprietary that you could
send me a filesystem copy of it (a tarball of all of $PGDATA including
the WAL files)?
regards, tom lane