[Bug 35220] New: Merging patrons can cause lock timeouts
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=35220 Bug ID: 35220 Summary: Merging patrons can cause lock timeouts Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Patrons Assignee: koha-bugs@lists.koha-community.org Reporter: nick@bywatersolutions.com QA Contact: testopia@bugs.koha-community.org CC: gmcharlt@gmail.com, kyle.m.hall@gmail.com The code to merge patrons uses a transaction to update all of the related patron tables. On systems with a long history (i.e. a big statistics table) this operation can take 30 seconds or more, which begins to cause issues writing to the tables. We need to find a way to speed this up, or to defer the merging of patrons. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=35220 Rebecca Coert <rcoert@arlingtonva.us> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |rcoert@arlingtonva.us -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=35220 --- Comment #1 from Nick Clemens <nick@bywatersolutions.com> --- I was able to recreate this by adding a Sleep 100; after the update statement in merge with, and reducing the table updates ot only Statistics - then checkouts failed while waiting for the lock It seems the best idea here is to defer patron merges and handle them via a nightly cronjob -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=35220 Brenda <bowens@washoecounty.us> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |bowens@washoecounty.us -- You are receiving this mail because: You are watching all bug changes.
participants (1)
-
bugzilla-daemon@bugs.koha-community.org