Skip site navigation (1) Skip section navigation (2)

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

From: Anderson Valadares <andervalbh(at)gmail(dot)com>
To: 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:42:37
Message-ID: AANLkTi=veNdOm_o_Meif+Pr7CLP0H-ao+E==oZwfELXZ@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
2010/11/29 Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>

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

Thanks Tom,
is strange because the database was shut down normally. I wanted to
understand why this error. I noticed that this table has an index GIST.

27/11/2010 13:16:49 PDT [] - [13019]: [3-1] LOG: received smart shutdown
request
27/11/2010 13:16:49 PDT [] - [3891]: [1-1] FATAL: terminating connection due
to administrator command
27/11/2010 13:16:49 PDT [] - [28117]: [1-1] FATAL: terminating connection
due to administrator command
27/11/2010 13:16:49 PDT [] - [25348]: [8597-1] FATAL: terminating connection
due to administrator command
27/11/2010 13:16:49 EDT [- [3557]: [8-1] FATAL: terminating connection due
to administrator command
27/11/2010 13:16:49 PDT [] - [26900]: [1-1] FATAL: terminating connection
due to administrator command
27/11/2010 13:16:49 PDT [] - [27051]: [1-1] FATAL: terminating connection
due to administrator command

In response to

pgsql-admin by date

Next:From: Samuel StearnsDate: 2010-11-30 05:16:07
Subject: Setting Schema on Restore
Previous:From: Michael HoltDate: 2010-11-30 00:21:27
Subject: Re: Diagnosing Postgres Segfault

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group