bugzilla-daemon at main.slony.info bugzilla-daemon at main.slony.info
Wed Mar 19 13:26:38 PDT 2014
http://www.slony.info/bugzilla/show_bug.cgi?id=336

           Summary: Review transaction isolation level requirements for
                    slon database connections.
           Product: Slony-I
           Version: devel
          Platform: All
        OS/Version: All
            Status: NEW
          Severity: normal
          Priority: low
         Component: slon
        AssignedTo: slony1-bugs at lists.slony.info
        ReportedBy: janwieck at yahoo.com
                CC: slony1-bugs at lists.slony.info
   Estimated Hours: 0.0


slon currently uses READ ONLY ISOLATION LEVEL SERIALIZABLE DEFERRABLE for some
transactions, in particular the remote listener. This causes event propagation
to stall during another long running, serializable transaction.

I believe that only event creation and copy_set done against the origin require
serializable. The copy_set can use serializable deferrable. All other slon
transaction should work fine with isolation level repeatable read.

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