Postgres Pro
Downloads
Home   >   mailing lists

Thread: PANIC: right sibling's left-link doesn't match

PANIC: right sibling's left-link doesn't match

From
"Marc G. Fournier"
Date:
The above error refers to a btree index, correct?  Do/will a REINDEX fix 
that, or do I have to physically DROP/CREATE the INDEX?

This is a 7.4 database, if that matters ...

Thanks ...

----
Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
Email: scrappy@hub.org           Yahoo!: yscrappy              ICQ: 7615664

Re: PANIC: right sibling's left-link doesn't match

From
Tom Lane
Date:
"Marc G. Fournier" <scrappy@postgresql.org> writes:
> The above error refers to a btree index, correct?  Do/will a REINDEX fix 
> that, or do I have to physically DROP/CREATE the INDEX?

REINDEX should fix it --- but how did it get that way?
        regards, tom lane

Re: PANIC: right sibling's left-link doesn't match

From
"Marc G. Fournier"
Date:
On Fri, 27 Aug 2004, Tom Lane wrote:

> "Marc G. Fournier" <scrappy@postgresql.org> writes:
>> The above error refers to a btree index, correct?  Do/will a REINDEX fix
>> that, or do I have to physically DROP/CREATE the INDEX?
>
> REINDEX should fix it --- but how did it get that way?

For lack of a better way of saying it, 'sporatic hardware failure' :(

But, REINDEX did fix it ...

----
Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
Email: scrappy@hub.org           Yahoo!: yscrappy              ICQ: 7615664