Sun Jul 19 20:20:50 PDT 2009
- Previous message: [Slony1-bugs] SlonyI-2.0.2 giving warning for PostgreSQL 8.4
- Next message: [Slony1-bugs] [Bug 93] compress_actionseq converting large log_actionseq values incorrectly
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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.
- Previous message: [Slony1-bugs] SlonyI-2.0.2 giving warning for PostgreSQL 8.4
- Next message: [Slony1-bugs] [Bug 93] compress_actionseq converting large log_actionseq values incorrectly
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-bugs mailing list