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

           Summary: store trigger runs against all nodes upon subscription
           Product: Slony-I
           Version: 1.2
          Platform: PC
        OS/Version: Linux
            Status: ASSIGNED
          Severity: major
          Priority: high
         Component: slon
        AssignedTo: slony1-bugs at lists.slony.info
        ReportedBy: cbbrowne at ca.afilias.info
                CC: slony1-bugs at lists.slony.info
   Estimated Hours: 0.0


As part of COPY SET, the new subscriber node is supposed to copy the contents
of sl_trigger from its provider, and run StoreTrigger() against each entry so
that any triggers that are to run on subscribers are configured to run.

Unfortunately, what is run is StoreTrigger(), rather than StoreTrigger_int().

StoreTrigger_int() runs only against the local node, which is what we want.

StoreTrigger() starts by generating a STORE TRIGGER event, so that this action
winds up being run against all nodes.  This means that, as part of COPY_SET,
you've got a table alteration running against all nodes.  This has the
potential to lead to Unexpected Locking of a provider node.


-- 
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.