bugzilla-daemon at main.slony.info bugzilla-daemon at main.slony.info
Tue May 18 07:41:24 PDT 2010
http://www.slony.info/bugzilla/show_bug.cgi?id=124

           Summary: EXECUTE SCRIPT, ONLY ON != EVENT NODE is wrong
           Product: Slony-I
           Version: 2.0
          Platform: All
        OS/Version: All
            Status: NEW
          Severity: normal
          Priority: low
         Component: slonik
        AssignedTo: slony1-bugs at lists.slony.info
        ReportedBy: ssinger at ca.afilias.info
                CC: slony1-bugs at lists.slony.info
   Estimated Hours: 0.0


A slonik command like

EXECUTE SCRIPT( SET ID=1, FILENAME='/tmp/executeScript5718113975686807087.sql'
, EVENT NODE=1, EXECUTE ONLY ON=5);

Where the EVENT NODE != the EXECUTE ONLY ON node tries to execute the DDL
against node 1 (the event node).  This essentially ignores the node id
specified in the ONLY ON syntax.

We could either:

1) Submit the ddl script into the replication queue on the event node but only
execute it on the ONLY ON node.

2) Change EXECUTE ONLY ON to be a boolean so when it is true we only execute on
the EVENT NODE

3) Generate an error if event node != ONLY ON and let the user fix their
script.

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