From: Tom Lane <tgl@sss.pgh.pa.us>
To: Anderson Valadares <andervalbh@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: failed to re-find parent key in index "22723655" for split pages 370836/370837
Date: Mon, 29 Nov 2010 19:02:12 -0500
Message-ID: <7753.1291075332@sss.pgh.pa.us> (raw)
In-Reply-To: <AANLkTik-zUw1KdtKHvK362FauXe8uOUAyRuiN=9vmB4z@mail.gmail.com>
References: <AANLkTik-zUw1KdtKHvK362FauXe8uOUAyRuiN=9vmB4z@mail.gmail.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, andervalbh@gmail.com
Subject: Re: failed to re-find parent key in index "22723655" for split pages 370836/370837
In-Reply-To: <7753.1291075332@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox