Re: pg 8.4 crashing. - Mailing list pgsql-general

From Tom Lane
Subject Re: pg 8.4 crashing.
Date
Msg-id 2170.1285273061@sss.pgh.pa.us
Whole thread Raw
In response to pg 8.4 crashing.  (Scott Marlowe <scott.marlowe@gmail.com>)
Responses Re: pg 8.4 crashing.  (Scott Marlowe <scott.marlowe@gmail.com>)
List pgsql-general
Scott Marlowe <scott.marlowe@gmail.com> writes:
> I've got a problem with pg 8.4.4 crashing with a sig 6 abort due to a
> panic on failing to add a right sibling in an index.  Log output:

> PANIC:  failed to add item to the right sibling in index "logged_in_uid"
> STATEMENT:  INSERT INTO logged_in ...

If you can apply this patch:
http://archives.postgresql.org/pgsql-committers/2010-08/msg00365.php
it should tell you which index page is causing the problem.  Then
please dump that page with pg_filedump and send it in.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Visualize GiST Index
Next
From: kongsgar@stud.ntnu.no
Date:
Subject: Restore/dump from "/usr/local/pgsql/data" directory