Re: failed to re-find parent key in index "22723655" for split pages 370836/370837 - Mailing list pgsql-admin

From Tom Lane
Subject Re: failed to re-find parent key in index "22723655" for split pages 370836/370837
Date
Msg-id 7753.1291075332@sss.pgh.pa.us
Whole thread Raw
In response to failed to re-find parent key in index "22723655" for split pages 370836/370837  (Anderson Valadares <andervalbh@gmail.com>)
Responses Re: failed to re-find parent key in index "22723655" for split pages 370836/370837  (Anderson Valadares <andervalbh@gmail.com>)
List pgsql-admin
Anderson Valadares <andervalbh@gmail.com> writes:
>  I am facing problems starting the database. Following is the error message.
> Can anyone help me?

> 2010-11-29 18:12:41 BRST [] - [5011]: [14-1] FATAL:  XX000: failed to
> re-find parent key in index "22723655" for split pages 370836/370837

The only way you're going to get out of that is with pg_resetxlog,
which is a fairly blunt instrument :-(.  It's possible that you will
have database corruption afterwards.  I'd recommend doing a dump and
reload to see if any problems appear.  It'd also be a good idea to save
a tarball copy of the $PGDATA file tree beforehand, so at least you can
get back to where you are in case things turn into a complete mess.

Can you tell us anything about how you got into this state?

            regards, tom lane

pgsql-admin by date:

Previous
From: Michael Holt
Date:
Subject: Diagnosing Postgres Segfault
Next
From: Tom Lane
Date:
Subject: Re: Diagnosing Postgres Segfault