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

From val
Subject Re: PANIC: failed to re-find parent key in "100924" for split pages 1606/1673
Date
Msg-id 459401.89785.qm@web25808.mail.ukl.yahoo.com
Whole thread Raw
In response to Re: PANIC: failed to re-find parent key in "100924" for split pages 1606/1673  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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.
>=20
> > Jan  5 10:36:29 db2 postgres[17111]: [11-1] PANIC:=20
> failed to re-find parent key in "100924" for split
> pages 1606/1673
>=20=20
> 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)?
>=20

I solved my problem by reseting the next transaction ID with the pg_resetxl=
og utility.

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

thanks,
val

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #4602: child processes inherit database socket
Next
From: Peter Eisentraut
Date:
Subject: Re: Status of issue 4593