Re: Panic error on attempted update - Mailing list pgsql-general

From Tom Lane
Subject Re: Panic error on attempted update
Date
Msg-id 23552.1184260610@sss.pgh.pa.us
Whole thread Raw
In response to Panic error on attempted update  (Andrew Edson <cheighlund@yahoo.com>)
List pgsql-general
Andrew Edson <cheighlund@yahoo.com> writes:
> PANIC:  right sibling's left-link doesn't match

>   Any clue what's causing the panic message to occur?

Corrupt btree index.  If you can determine which table is being
inserted/updated when this happens (admittedly the message is not being
helpful), REINDEX should fix it.

Did you have a system crash before this started?

Running something newer than 8.1.4 would be advisable anyway.  I seem to
recall that we fixed at least one bug that could produce this symptom,
though I don't see anything specifically about it in the 8.1 CVS logs.

            regards, tom lane

pgsql-general by date:

Previous
From: imageguy
Date:
Subject: Updates/Changes to a database
Next
From: "Benjamin Arai"
Date:
Subject: Re: Big table with UNION ALL or partitioning with Tsearch2