26 Feb
2021
26 Feb
'21
10:54 a.m.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26457 --- Comment #36 from Marcel de Rooy <m.de.rooy@rijksmuseum.nl> --- Created attachment 117373 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=117373&action=edit Bug 26457: (QA follow-up) Switch to PK index in UPDATE on issues The deadlock reports tell us that multiple transactions are waiting for a X lock on a record but using a secondary index on borrowernumber and itemnumber. Since we have the issue_id at hand already, we should use that and benefit from the clustered index (on PK) instead of using a secondary index. Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl> -- You are receiving this mail because: You are watching all bug changes.