[Koha-bugs] [Bug 35220] New: Merging patrons can cause lock timeouts
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Wed Nov 1 19:49:42 CET 2023
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 at lists.koha-community.org
Reporter: nick at bywatersolutions.com
QA Contact: testopia at bugs.koha-community.org
CC: gmcharlt at gmail.com, kyle.m.hall at 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.
More information about the Koha-bugs
mailing list