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)
committerJonathan Druart <jonathan.druart@bugs.koha-community.org>
Mon, 1 Mar 2021 09:51:15 +0000 (10:51 +0100)
commit3beeb020ef7d8ef733f34ffef5202bb328a8b867
treee0152a735207e5ab7bc74be2e3febb025817ed10
parente05ad0c1f827c9670f7bfb7f2112c380f0da5c04
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>
C4/Circulation.pm