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
Import Notes
Reply to msg id not found: 200501122044.j0CKiHXC001774@bda1.spectrumtelecorp.comReference msg id not found: 200501122044.j0CKiHXC001774@bda1.spectrumtelecorp.com
"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 matchDoes 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 -------