bugzilla-daemon at main.slony.info bugzilla-daemon at main.slony.info
Tue May 10 08:42:58 PDT 2011
http://www.slony.info/bugzilla/show_bug.cgi?id=207

           Summary: create set in a try block rollsback
           Product: Slony-I
           Version: devel
          Platform: PC
        OS/Version: Linux
            Status: NEW
          Severity: enhancement
          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


In 2.1.0.b1

include<test.preamble>
try {
create set(id=2, origin=2);
set add sequence(set id=2, sequences='public.a*');
subscribe set(id=2,provider=2,receiver=3);
subscribe set(id=2,provider=2,receiver=1);
merge set(id=1,add id=2,origin=2);
}
on error {
echo 'error';
}

goes to the on error block with

tmp/x:4: PGRES_FATAL_ERROR select "_test".setAddSequence(2, 1,
'public.a_a_seq', 'replicated sequence');  - ERROR:  Slony-I: setAddSequence():
set 2 not found
/tmp/x:2 Error: waiting operation not allowed inside of inside of a try
block/tmp/x:9: erorr


After the storeSet function is called but before the setAddSequence() function
is invoked the database transaction is rolledback (for some unknown reason)

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