slony1-bugs at lists.slony.info slony1-bugs at lists.slony.info
Sun Jul 19 20:20:50 PDT 2009
http://www.slony.info/bugzilla/show_bug.cgi?id=93

           Summary: compress_actionseq converting large log_actionseq values
                    incorrectly
           Product: Slony-I
           Version: devel
          Platform: Other
        OS/Version: Linux
            Status: NEW
          Severity: major
          Priority: urgent
         Component: slon
        AssignedTo: slony1-bugs at lists.slony.info
        ReportedBy: gordon at collectiveintellect.com
                CC: slony1-bugs at lists.slony.info
   Estimated Hours: 0.0


The "log_actionseq" column in the sl_log_1/2 tables is a bigint.  The
compress_actionseq() function in remote_worker.c is converting a list of these
8-byte bigints in string form to 4-byte integers, which hold a maximum of
2,147,483,647. Larger values are losing precision. 

Sample log snippet:

14 0719 18:33:27 DEBUG4 compress_actionseq(list,subquery) Action list:
'4832430056','4832430057' ...
14 0719 18:33:27 DEBUG4 Finished number: 537462760
14 0719 18:33:27 DEBUG4 Finished number: 537462761
...

>From remote_worker.c, lines 5516-5518:

        int                     curr_number,
                                curr_min,
                                curr_max;


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