[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-admin
Subject:    Re: [ADMIN] failed to re-find parent key in index "22723655" for
From:       Anderson Valadares <andervalbh () gmail ! com>
Date:       2010-11-30 0:42:37
Message-ID: AANLkTi=veNdOm_o_Meif+Pr7CLP0H-ao+E==oZwfELXZ () mail ! gmail ! com
[Download RAW message or body]

2010/11/29 Tom Lane <tgl@sss.pgh.pa.us>

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

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

[Attachment #3 (text/html)]

<div class="gmail_quote">2010/11/29 Tom Lane <span dir="ltr">&lt;<a \
href="mailto:tgl@sss.pgh.pa.us">tgl@sss.pgh.pa.us</a>&gt;</span><br><blockquote \
class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, \
204, 204); padding-left: 1ex;"> <div class="im">Anderson Valadares &lt;<a \
href="mailto:andervalbh@gmail.com">andervalbh@gmail.com</a>&gt; writes:<br> &gt;  I \
am facing problems starting the database. Following is the error message.<br> &gt; \
Can anyone help me?<br> <br>
</div><div class="im">&gt; 2010-11-29 18:12:41 BRST [] - [5011]: [14-1] FATAL:  \
XX000: failed to<br> &gt; re-find parent key in index &quot;22723655&quot; for split \
pages 370836/370837<br> <br>
</div>The only way you&#39;re going to get out of that is with pg_resetxlog,<br>
which is a fairly blunt instrument :-(.  It&#39;s possible that you will<br>
have database corruption afterwards.  I&#39;d recommend doing a dump and<br>
reload to see if any problems appear.  It&#39;d also be a good idea to save<br>
a tarball copy of the $PGDATA file tree beforehand, so at least you can<br>
get back to where you are in case things turn into a complete mess.<br>
<br>
Can you tell us anything about how you got into this state?<br>
<br>
                        regards, tom lane<br>
</blockquote></div><br><span id="result_box" class="long_text" lang="en"><span \
style="" title="">Thanks Tom,<br></span><span style="" title="">is strange because \
the database was shut down normally. </span><span style="" title="">I wanted to \
understand why this error. </span><span style="" title="">I noticed that this table \
has an index GIST.<br> <br></span><span style="" title="">27/11/2010 13:16:49 PDT [] \
- [13019]: [3-1] LOG: received smart shutdown request<br></span><span style="" \
title="">27/11/2010 13:16:49 PDT [] - [3891]: [1-1] FATAL: terminating connection due \
to administrator command<br> </span><span style="" title="">27/11/2010 13:16:49 PDT \
[] - [28117]: [1-1] FATAL: terminating connection due to administrator \
command<br></span><span style="" title="">27/11/2010 13:16:49 PDT [] - [25348]: \
[8597-1] FATAL: terminating connection due to administrator command<br> </span><span \
style="" title="">27/11/2010 13:16:49 EDT [- [3557]: [8-1] FATAL: terminating \
connection due to administrator command<br></span><span style="" title="">27/11/2010 \
13:16:49 PDT [] - [26900]: [1-1] FATAL: terminating connection due to administrator \
command<br> </span><span style="" title="">27/11/2010 13:16:49 PDT [] - [27051]: \
[1-1] FATAL: terminating connection due to administrator \
command</span></span><br><br><br>



[prev in list] [next in list] [prev in thread] [next in thread]