]> git.koha-community.org Git - koha.git/commit
Bug 26457: (QA follow-up) Switch to PK index in UPDATE on issues
authorMarcel de Rooy <m.de.rooy@rijksmuseum.nl>
Fri, 26 Feb 2021 10:26:27 +0000 (10:26 +0000)
committerFridolin Somers <fridolin.somers@biblibre.com>
Tue, 2 Mar 2021 07:11:47 +0000 (08:11 +0100)
commit1be7d9ce609c7722d328dca25a7c070d7b987d65
tree2a117802273e311d8d3ed4c0ab5aec8c4706a21f
parentdf53867563e232ca080ed198b9ed64d0e44e8522
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>
Signed-off-by: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
(cherry picked from commit 3beeb020ef7d8ef733f34ffef5202bb328a8b867)
Signed-off-by: Fridolin Somers <fridolin.somers@biblibre.com>
C4/Circulation.pm