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

From: val <valiouk(at)yahoo(dot)co(dot)uk>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
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-06 14:00:06
Message-ID: 459401.89785.qm@web25808.mail.ukl.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

> > 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
>
> 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)?
>

I solved my problem by reseting the next transaction ID with the pg_resetxlog utility.

Sorry I cannot send you the database since it is proprietary and is also quiet big, but if there is anything else I can do just let me know.

thanks,
val

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Peter Eisentraut 2009-01-06 14:31:09 Re: Status of issue 4593
Previous Message Tom Lane 2009-01-06 13:15:14 Re: BUG #4602: child processes inherit database socket