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

Started by Marc G. Fournierover 21 years ago3 messages
#1Marc G. Fournier
scrappy@postgresql.org

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

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Marc G. Fournier (#1)
Re: PANIC: right sibling's left-link doesn't match

"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

#3Marc G. Fournier
scrappy@postgresql.org
In reply to: Tom Lane (#2)
Re: PANIC: right sibling's left-link doesn't match

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