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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Anderson Valadares <andervalbh(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: failed to re-find parent key in index "22723655" for split pages 370836/370837
Date: 2010-11-30 00:02:12
Message-ID: 7753.1291075332@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Anderson Valadares <andervalbh(at)gmail(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2010-11-30 00:09:41 Re: Diagnosing Postgres Segfault
Previous Message Michael Holt 2010-11-29 23:41:28 Diagnosing Postgres Segfault