Thread: Panic error on attempted update
One of the servers I am responsible for maintaining was apparently having problems earlier today. The servers are all running SuSE 9.2, Apache 2 (not sure what version), and Postgres 8.1.4. Our main server is running Slony 1.1, I think, creating Log-Shipping records that the rest of the servers are then updated off of by means of an hourly cron script.
When I went into the server to take a look at the cause of the problems, I noticed that there were numerous copies of the updating cron script running, all of them trying to do a select on that server's local database. (There was a VACUUM command running at the same time; I do not know whether that had anything to do with this or not.)
I disabled the script so it wouldn't be able to run again and create more overhead to deal with, then attempted to let the backlogged copies finish. They have since dissappeared, but attempting to run the script manually produces the following error messages:
slony1_log_1_00000000000003476171.sql
ERROR: Slony-I: set 11 is on sync 3475773, this archive log expects 3476170
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: Slony-I: set 11 is on sync 3475773, this archive log expects 3476170
ERROR: current transaction is aborted, commands ignored until end of transaction block
...
...
ERROR: current transaction is aborted, commands ignored until end of transaction block
PANIC: right sibling's left-link doesn't match
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
connection to server was lost
PANIC: right sibling's left-link doesn't match
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
connection to server was lost
Any clue what's causing the panic message to occur? I understand the aborted transactions, since I'm giving it archive logs later than the one it expects, but I have no clue why I'm getting the Panic call, nor do I understand what it means completely. Would someone please explain to me?
Building a website is a piece of cake.
Yahoo! Small Business gives you all the tools to get online.
Andrew Edson <cheighlund@yahoo.com> writes:
> PANIC: right sibling's left-link doesn't match
> Any clue what's causing the panic message to occur?
Corrupt btree index. If you can determine which table is being
inserted/updated when this happens (admittedly the message is not being
helpful), REINDEX should fix it.
Did you have a system crash before this started?
Running something newer than 8.1.4 would be advisable anyway. I seem to
recall that we fixed at least one bug that could produce this symptom,
though I don't see anything specifically about it in the 8.1 CVS logs.
regards, tom lane