Bug 32990: Prevent deadlock in _update_batch_record_counts
authorMarcel de Rooy <m.de.rooy@rijksmuseum.nl>
Fri, 17 Feb 2023 08:33:41 +0000 (08:33 +0000)
committerMartin Renvoize <martin.renvoize@ptfs-europe.com>
Fri, 12 May 2023 15:20:25 +0000 (16:20 +0100)
commit5e838f4327aa0d9da51f607691db5adea260b20f
tree973221e2a82c77e568cec0f4f1867b86d27f54c5
parent71f20a1c3513759393a9bae3654eb295fcb4016e
Bug 32990: Prevent deadlock in _update_batch_record_counts

Resolves:
C4::ImportBatch::_update_batch_record_counts(): DBI Exception: DBD::mysql::st execute failed: Deadlock found when trying to get lock; try restarting transaction at /usr/share/koha/C4/ImportBatch.pm line 392

See also bug 32558.

Test plan:
If you apply 32558 first, run multiple processes that stage a marc import.
Without this patch, you can trigger the deadlock.
With this patch, it works.

Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl>
Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com>
Signed-off-by: Nick Clemens <nick@bywatersolutions.com>
Signed-off-by: Tomas Cohen Arazi <tomascohen@theke.io>
(cherry picked from commit 9a6d10dc312cd6fe5e33a72af6259ac9b05f6db7)
Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>
C4/ImportBatch.pm