[Bug 1193177] sqlite3_drv bad memory free and severe performance bug - with patch
https://bugzilla.redhat.com/show_bug.cgi?id=1193177 Fedora Update System upda...@fedoraproject.org changed: What|Removed |Added Fixed In Version|dspam-3.10.2-10.el7 |dspam-3.10.2-6.el6 --- Comment #16 from Fedora Update System upda...@fedoraproject.org --- dspam-3.10.2-6.el6 has been pushed to the Fedora EPEL 6 stable repository. If problems still persist, please make note of it in this bug report. -- You are receiving this mail because: You are on the CC list for the bug. Unsubscribe from this bug https://bugzilla.redhat.com/token.cgi?t=qgHyAWCFnsa=cc_unsubscribe -- Fedora Extras Perl SIG http://www.fedoraproject.org/wiki/Extras/SIGs/Perl perl-devel mailing list perl-devel@lists.fedoraproject.org https://admin.fedoraproject.org/mailman/listinfo/perl-devel
[Bug 1193177] sqlite3_drv bad memory free and severe performance bug - with patch
https://bugzilla.redhat.com/show_bug.cgi?id=1193177 Fedora Update System upda...@fedoraproject.org changed: What|Removed |Added Fixed In Version|dspam-3.10.2-16.fc20|dspam-3.10.2-10.el7 --- Comment #15 from Fedora Update System upda...@fedoraproject.org --- dspam-3.10.2-10.el7 has been pushed to the Fedora EPEL 7 stable repository. If problems still persist, please make note of it in this bug report. -- You are receiving this mail because: You are on the CC list for the bug. Unsubscribe from this bug https://bugzilla.redhat.com/token.cgi?t=VCdTtXfnKla=cc_unsubscribe -- Fedora Extras Perl SIG http://www.fedoraproject.org/wiki/Extras/SIGs/Perl perl-devel mailing list perl-devel@lists.fedoraproject.org https://admin.fedoraproject.org/mailman/listinfo/perl-devel
[Bug 1193177] sqlite3_drv bad memory free and severe performance bug - with patch
https://bugzilla.redhat.com/show_bug.cgi?id=1193177 Fedora Update System upda...@fedoraproject.org changed: What|Removed |Added Fixed In Version|dspam-3.10.2-16.fc21|dspam-3.10.2-16.fc20 --- Comment #14 from Fedora Update System upda...@fedoraproject.org --- dspam-3.10.2-16.fc20 has been pushed to the Fedora 20 stable repository. If problems still persist, please make note of it in this bug report. -- You are receiving this mail because: You are on the CC list for the bug. Unsubscribe from this bug https://bugzilla.redhat.com/token.cgi?t=6J2ZFMov6Da=cc_unsubscribe -- Fedora Extras Perl SIG http://www.fedoraproject.org/wiki/Extras/SIGs/Perl perl-devel mailing list perl-devel@lists.fedoraproject.org https://admin.fedoraproject.org/mailman/listinfo/perl-devel
[Bug 1193177] sqlite3_drv bad memory free and severe performance bug - with patch
https://bugzilla.redhat.com/show_bug.cgi?id=1193177 Fedora Update System upda...@fedoraproject.org changed: What|Removed |Added Status|ON_QA |CLOSED Fixed In Version||dspam-3.10.2-16.fc21 Resolution|--- |ERRATA Last Closed||2015-03-04 05:34:10 --- Comment #13 from Fedora Update System upda...@fedoraproject.org --- dspam-3.10.2-16.fc21 has been pushed to the Fedora 21 stable repository. If problems still persist, please make note of it in this bug report. -- You are receiving this mail because: You are on the CC list for the bug. Unsubscribe from this bug https://bugzilla.redhat.com/token.cgi?t=zWsDS9iXmsa=cc_unsubscribe -- Fedora Extras Perl SIG http://www.fedoraproject.org/wiki/Extras/SIGs/Perl perl-devel mailing list perl-devel@lists.fedoraproject.org https://admin.fedoraproject.org/mailman/listinfo/perl-devel
[Bug 1193177] sqlite3_drv bad memory free and severe performance bug - with patch
https://bugzilla.redhat.com/show_bug.cgi?id=1193177 --- Comment #11 from Nathanael Noblet nathan...@gnat.ca --- So I don't use the sqlite driver so don't have any skin in this game. It looks like they've committed your patch upstream however you don't seem to be sure its the best way forward. If I push these builds to stable this bug will be closed. Can you let me know if you have a revised patch for the transaction mode? -- You are receiving this mail because: You are on the CC list for the bug. Unsubscribe from this bug https://bugzilla.redhat.com/token.cgi?t=bvbN11ZvKAa=cc_unsubscribe -- Fedora Extras Perl SIG http://www.fedoraproject.org/wiki/Extras/SIGs/Perl perl-devel mailing list perl-devel@lists.fedoraproject.org https://admin.fedoraproject.org/mailman/listinfo/perl-devel
[Bug 1193177] sqlite3_drv bad memory free and severe performance bug - with patch
https://bugzilla.redhat.com/show_bug.cgi?id=1193177 --- Comment #12 from Stuart D Gathman stu...@gathman.org --- Short answer: I do not have a revised patch Long answer: My reading of the docs is that because there is only one table involved, the existing patch should work. If there is a lock failure, it will fail on the first insert or update - both of which already have a ROLLBACK. Changing the transaction mode to IMMEDIATE would merely cause the failure on the BEGIN instead. So I don't think a revised patch is needed. This is not really a correct transaction anyway, because it is updating with data collected from outside the transaction. It is purely a (necessary) performance hack. -- You are receiving this mail because: You are on the CC list for the bug. Unsubscribe from this bug https://bugzilla.redhat.com/token.cgi?t=gUewrah42Oa=cc_unsubscribe -- Fedora Extras Perl SIG http://www.fedoraproject.org/wiki/Extras/SIGs/Perl perl-devel mailing list perl-devel@lists.fedoraproject.org https://admin.fedoraproject.org/mailman/listinfo/perl-devel
[Bug 1193177] sqlite3_drv bad memory free and severe performance bug - with patch
https://bugzilla.redhat.com/show_bug.cgi?id=1193177 --- Comment #7 from Stuart D Gathman stu...@gathman.org --- After doing some more reading on sqlite3 transactions, I believe the BEGIN should be a BEGIN IMMEDIATE. With the plain BEGIN, locks are deferred until the actual query or update - and the COMMIT may fail with SQLITE_BUSY, and need to be retried (with potential deadlock). With BEGIN IMMEDIATE, RESERVED locks (allow others to read, but not write) are acquired on the database immediately. The BEGIN IMMEDIATE may then fail, and should return an error (or does it need to loop?), but the COMMIT should be ok once the BEGIN IMMEDIATE succeeds. -- You are receiving this mail because: You are on the CC list for the bug. Unsubscribe from this bug https://bugzilla.redhat.com/token.cgi?t=1OkL0RlBr6a=cc_unsubscribe -- Fedora Extras Perl SIG http://www.fedoraproject.org/wiki/Extras/SIGs/Perl perl-devel mailing list perl-devel@lists.fedoraproject.org https://admin.fedoraproject.org/mailman/listinfo/perl-devel
[Bug 1193177] sqlite3_drv bad memory free and severe performance bug - with patch
https://bugzilla.redhat.com/show_bug.cgi?id=1193177 --- Comment #9 from Stuart D Gathman stu...@gathman.org --- https://www.sqlite.org/lang_transaction.html -- You are receiving this mail because: You are on the CC list for the bug. Unsubscribe from this bug https://bugzilla.redhat.com/token.cgi?t=aYRArAe4Rpa=cc_unsubscribe -- Fedora Extras Perl SIG http://www.fedoraproject.org/wiki/Extras/SIGs/Perl perl-devel mailing list perl-devel@lists.fedoraproject.org https://admin.fedoraproject.org/mailman/listinfo/perl-devel
[Bug 1193177] sqlite3_drv bad memory free and severe performance bug - with patch
https://bugzilla.redhat.com/show_bug.cgi?id=1193177 --- Comment #10 from Stuart D Gathman stu...@gathman.org --- However, there is just one table immediately updated (no reads between BEGIN and UPDATE/INSERT). If that update fails to obtain the lock, we error out correctly with a rollback. There can be no deadlock with just one table locked, so it is equivalent to IMMEDIATE MODE in this instance. I'm also noticing that the update uses data fetched from a previous _get_all_spam_records(), that was NOT in the transaction. So correctness depends on the dspam lock file. So this transaction is purely an efficiency issue. With that, I'll quit pontificating until I have an actual test case that breaks it. -- You are receiving this mail because: You are on the CC list for the bug. Unsubscribe from this bug https://bugzilla.redhat.com/token.cgi?t=W6X7aC3ux8a=cc_unsubscribe -- Fedora Extras Perl SIG http://www.fedoraproject.org/wiki/Extras/SIGs/Perl perl-devel mailing list perl-devel@lists.fedoraproject.org https://admin.fedoraproject.org/mailman/listinfo/perl-devel
[Bug 1193177] sqlite3_drv bad memory free and severe performance bug - with patch
https://bugzilla.redhat.com/show_bug.cgi?id=1193177 --- Comment #8 from Stuart D Gathman stu...@gathman.org --- I have not seen this potential problem, and multiprocess test cases are hard to construct. Dspam has its own lock file, which may prevent other dspam processes from tripping up the transaction. -- You are receiving this mail because: You are on the CC list for the bug. Unsubscribe from this bug https://bugzilla.redhat.com/token.cgi?t=gJ23Hjle53a=cc_unsubscribe -- Fedora Extras Perl SIG http://www.fedoraproject.org/wiki/Extras/SIGs/Perl perl-devel mailing list perl-devel@lists.fedoraproject.org https://admin.fedoraproject.org/mailman/listinfo/perl-devel
[Bug 1193177] sqlite3_drv bad memory free and severe performance bug - with patch
https://bugzilla.redhat.com/show_bug.cgi?id=1193177 Stevan Bajić ste...@bajic.ch changed: What|Removed |Added CC||ste...@bajic.ch --- Comment #6 from Stevan Bajić ste...@bajic.ch --- Thanks for the patch. Committed: http://sourceforge.net/p/dspam/code/ci/f53478286089caaa7fb21489550273ff35c6f442/ -- You are receiving this mail because: You are on the CC list for the bug. Unsubscribe from this bug https://bugzilla.redhat.com/token.cgi?t=mpWNrN1z5Oa=cc_unsubscribe -- Fedora Extras Perl SIG http://www.fedoraproject.org/wiki/Extras/SIGs/Perl perl-devel mailing list perl-devel@lists.fedoraproject.org https://admin.fedoraproject.org/mailman/listinfo/perl-devel
[Bug 1193177] sqlite3_drv bad memory free and severe performance bug - with patch
https://bugzilla.redhat.com/show_bug.cgi?id=1193177 Fedora Update System upda...@fedoraproject.org changed: What|Removed |Added Status|MODIFIED|ON_QA --- Comment #5 from Fedora Update System upda...@fedoraproject.org --- Package dspam-3.10.2-10.el7: * should fix your issue, * was pushed to the Fedora EPEL 7 testing repository, * should be available at your local mirror within two days. Update it with: # su -c 'yum update --enablerepo=epel-testing dspam-3.10.2-10.el7' as soon as you are able to. Please go to the following url: https://admin.fedoraproject.org/updates/FEDORA-EPEL-2015-0884/dspam-3.10.2-10.el7 then log in and leave karma (feedback). -- You are receiving this mail because: You are on the CC list for the bug. Unsubscribe from this bug https://bugzilla.redhat.com/token.cgi?t=yWWfttJg7Qa=cc_unsubscribe -- Fedora Extras Perl SIG http://www.fedoraproject.org/wiki/Extras/SIGs/Perl perl-devel mailing list perl-devel@lists.fedoraproject.org https://admin.fedoraproject.org/mailman/listinfo/perl-devel
[Bug 1193177] sqlite3_drv bad memory free and severe performance bug - with patch
https://bugzilla.redhat.com/show_bug.cgi?id=1193177 --- Comment #1 from Fedora Update System upda...@fedoraproject.org --- dspam-3.10.2-16.fc20 has been submitted as an update for Fedora 20. https://admin.fedoraproject.org/updates/dspam-3.10.2-16.fc20 -- You are receiving this mail because: You are on the CC list for the bug. Unsubscribe from this bug https://bugzilla.redhat.com/token.cgi?t=kJyFuzHusBa=cc_unsubscribe -- Fedora Extras Perl SIG http://www.fedoraproject.org/wiki/Extras/SIGs/Perl perl-devel mailing list perl-devel@lists.fedoraproject.org https://admin.fedoraproject.org/mailman/listinfo/perl-devel
[Bug 1193177] sqlite3_drv bad memory free and severe performance bug - with patch
https://bugzilla.redhat.com/show_bug.cgi?id=1193177 --- Comment #2 from Fedora Update System upda...@fedoraproject.org --- dspam-3.10.2-16.fc21 has been submitted as an update for Fedora 21. https://admin.fedoraproject.org/updates/dspam-3.10.2-16.fc21 -- You are receiving this mail because: You are on the CC list for the bug. Unsubscribe from this bug https://bugzilla.redhat.com/token.cgi?t=tTlXwe0j18a=cc_unsubscribe -- Fedora Extras Perl SIG http://www.fedoraproject.org/wiki/Extras/SIGs/Perl perl-devel mailing list perl-devel@lists.fedoraproject.org https://admin.fedoraproject.org/mailman/listinfo/perl-devel
[Bug 1193177] sqlite3_drv bad memory free and severe performance bug - with patch
https://bugzilla.redhat.com/show_bug.cgi?id=1193177 --- Comment #4 from Fedora Update System upda...@fedoraproject.org --- dspam-3.10.2-6.el6 has been submitted as an update for Fedora EPEL 6. https://admin.fedoraproject.org/updates/dspam-3.10.2-6.el6 -- You are receiving this mail because: You are on the CC list for the bug. Unsubscribe from this bug https://bugzilla.redhat.com/token.cgi?t=Tz7GbQ8vF6a=cc_unsubscribe -- Fedora Extras Perl SIG http://www.fedoraproject.org/wiki/Extras/SIGs/Perl perl-devel mailing list perl-devel@lists.fedoraproject.org https://admin.fedoraproject.org/mailman/listinfo/perl-devel
[Bug 1193177] sqlite3_drv bad memory free and severe performance bug - with patch
https://bugzilla.redhat.com/show_bug.cgi?id=1193177 --- Comment #3 from Fedora Update System upda...@fedoraproject.org --- dspam-3.10.2-10.el7 has been submitted as an update for Fedora EPEL 7. https://admin.fedoraproject.org/updates/dspam-3.10.2-10.el7 -- You are receiving this mail because: You are on the CC list for the bug. Unsubscribe from this bug https://bugzilla.redhat.com/token.cgi?t=3ssSFnJHY4a=cc_unsubscribe -- Fedora Extras Perl SIG http://www.fedoraproject.org/wiki/Extras/SIGs/Perl perl-devel mailing list perl-devel@lists.fedoraproject.org https://admin.fedoraproject.org/mailman/listinfo/perl-devel
