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 <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Cc: "pgsql-hackers" <pgsql-hackers@postgresql.org> Sent: Wed, 12 Jan 2005 16:45:11 -0500 Subject: Re: [HACKERS] PANIC: right sibling's left-link doesn't match > "Jim Buttafuoco" <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED]) ------- End of Original Message ------- ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
