Mon Apr 3 14:22:15 PDT 2006
- Previous message: [Slony1-general] sequencesetvalue() fails after power outage
- Next message: [Slony1-general] sequencesetvalue() fails after power outage
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Chris Mount <chris at asi-web.com> writes:
> 2006-04-03 10:09:09 CDT ERROR remoteWorkerThread_1: "select
> "_cpc_replic".sequenceSetValue(111,1,'106076','380399');
> " PGRES_FATAL_ERROR PANIC: right sibling's left-link doesn't match
> CONTEXT: SQL statement "insert into "_cpc_replic".sl_seqlog (seql_seqid,
> seql_origin, seql_ev_seqno, seql_last_value)
> values ( $1 , $2 , $3 , $4 )"
Searching for "right sibling's left-link doesn't match", I find
suggestions from Tom Lane to reindex tables.
It sounds to me as though the failure corrupted an index on one of the
tables, probably _cpc_replic.sl_seqlog.
Try reindexing it on the failing node, and see if that helps.
Of course, where there's one corruption, there could be more...
I'd suggest doing a vacuum of the whole thing via "VACUUM VERBOSE"; if
that runs into problems, you'll know...
--
output = reverse("ofni.sailifa.ac" "@" "enworbbc")
<http://dba2.int.libertyrms.com/>
Christopher Browne
(416) 673-4124 (land)
- Previous message: [Slony1-general] sequencesetvalue() fails after power outage
- Next message: [Slony1-general] sequencesetvalue() fails after power outage
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list