bugzilla-daemon at main.slony.info bugzilla-daemon at main.slony.info
Wed Sep 4 09:01:22 PDT 2013
http://www.slony.info/bugzilla/show_bug.cgi?id=313

           Summary: EXECUTE SCRIPT error with sequences not replicated
                    everywhere
           Product: Slony-I
           Version: devel
          Platform: PC
        OS/Version: Linux
            Status: NEW
          Severity: enhancement
          Priority: low
         Component: stored procedures
        AssignedTo: slony1-bugs at lists.slony.info
        ReportedBy: ssinger at ca.afilias.info
                CC: slony1-bugs at lists.slony.info
   Estimated Hours: 0.0


This bug is present in 2.2.0 rc1 and appears to be a caused by the fix for
bug304

The LogShipping disorder test is failing, for reasons unrelated to logshipping.

The EXECUTE SCRIPT command now captures the current value of each replicated
sequence and stores it along with each row of sl_log_script

The problem is that a particular sequence might not be replicated to all nodes
since it might be part of a set that doesn't get replicated to some nodes.

The current execute script apply logic tries to make all sequence updates for
all sequences to  a node that the DDL/SCRIPT gets executed on.  This fails when
a sequence is missing.

 error at end of COPY IN: ERROR:  Slony-I: sequenceSetValue(): sequence 1 not
found

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


More information about the Slony1-bugs mailing list