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

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.  


Some background.  This is a Debian Sarge system running PG 7.4.5 on i386 dual XEON system with 4G of memory.  I just 
rebooted the system because a fan had failed and was replaced. 

Thanks
Jim

"Jim Buttafuoco" <jim@contactbda.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

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@sss.pgh.pa.us>
To: jim@contactbda.com
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" <jim@contactbda.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@postgresql.org)
------- End of Original Message -------