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

It did print the query right after the PANIC message, so I do have the table name. I just completed the reindex.

Thanks

---------- Original Message -----------
From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: jim(at)contactbda(dot)com
Cc: "pgsql-hackers" <pgsql-hackers(at)postgresql(dot)org>
Sent: Wed, 12 Jan 2005 16:45:11 -0500
Subject: Re: [HACKERS] PANIC: right sibling's left-link doesn't match

> "Jim Buttafuoco" <jim(at)contactbda(dot)com> writes:
> > Postgres on one of my big database servers just crashed with the following message
> > PANIC: right sibling's left-link doesn't match
>
> > Does any one have any idea's what might cause this.
>
> Corrupted btree index. REINDEX should help, though I'm afraid the error
> message isn't very helpful about identifying which index is busted.
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
------- End of Original Message -------