http://www.slony.info/bugzilla/show_bug.cgi?id=255

           Summary: SSI issues with 9.1
           Product: Slony-I
           Version: 2.0
          Platform: PC
        OS/Version: Linux
            Status: NEW
          Severity: enhancement
          Priority: low
         Component: slon
        AssignedTo: slony1-bugs at lists.slony.info
        ReportedBy: ssinger at ca.afilias.info
                CC: slony1-bugs at lists.slony.info
   Estimated Hours: 0.0


As reported on the mailing list
http://lists.slony.info/pipermail/slony1-general/2011-November/011939.htmllony
2.0.7 replication just stalled on big update on master (like
300.000 in batch.. nothing crazy).

Slony log on slave show repeatable (like each 5 minute) error:

2011-11-18 08:46:03 MSKERROR  remoteWorkerThread_4: "insert into
"_sports".sl_event     (ev_origin, ev_seqno, ev_timestamp,
ev_snapshot, ev_type     ) values ('4', '5000054127', '2011-11-18
06:18:44.863299', '922722:922722:', 'SYNC'); insert into
"_sports".sl_confirm     (con_origin, con_received, con_seqno,
con_timestamp)    values (4, 3, '5000054127', now()); insert into
"_sports".sl_event     (ev_origin, ev_seqno, ev_timestamp,
ev_snapshot, ev_type     ) values ('4', '5000054128', '2011-11-18
06:18:45.890297', '922731:922731:', 'SYNC'); insert into
"_sports".sl_confirm   (con_origin, con_received, con_seqno,
con_timestamp)    values (4, 3, '5000054128', now()); insert into
"_sports".sl_event     (ev_origin, ev_seqno, ev_timestamp,
ev_snapshot, ev_type     ) values ('4', '5000054129', '2011-11-18
06:18:46.921278', '922736:922736:', 'SYNC'); insert into
"_sports".sl_confirm      (con_origin, con_received, con_seqno,
con_timestamp)    values (4, 3, '5000054129', now()); commit
transaction;"
PGRES_FATAL_ERROR ERROR:  could not serialize access due to read/write
dependencies among transactions
DETAIL:  Reason code: Canceled on identification as a pivot, during write.
HINT:  The transaction might succeed if retried.
In that case slony just terminate without commiting batch (and
returned to the life only by watchdog).

-- 
Configure bugmail: http://www.slony.info/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are on the CC list for the bug.
You are the assignee for the bug.