Re: PANIC: failed to re-find parent key in "100924" for split pages 1606/1673 - Mailing list pgsql-bugs

From Tom Lane
Subject Re: PANIC: failed to re-find parent key in "100924" for split pages 1606/1673
Date
Msg-id 24700.1231183507@sss.pgh.pa.us
Whole thread Raw
In response to PANIC: failed to re-find parent key in "100924" for split pages 1606/1673  (val <valiouk@yahoo.co.uk>)
Responses Re: PANIC: failed to re-find parent key in "100924" for split pages 1606/1673
Re: PANIC: failed to re-find parent key in "100924" for split pages 1606/1673
List pgsql-bugs
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

pgsql-bugs by date:

Previous
From: "Pavel Stehule"
Date:
Subject: Re: Problem with instalation
Next
From: Jeff Davis
Date:
Subject: Re: Status of issue 4593