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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: valiouk(at)yahoo(dot)co(dot)uk
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: PANIC: failed to re-find parent key in "100924" for split pages 1606/1673
Date: 2009-01-05 19:25:07
Message-ID: 24700.1231183507@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

val <valiouk(at)yahoo(dot)co(dot)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 Etch box.

> 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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Jeff Davis 2009-01-05 20:08:22 Re: Status of issue 4593
Previous Message Pavel Stehule 2009-01-05 17:26:57 Re: Problem with instalation