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)
committerTomas Cohen Arazi <tomascohen@theke.io>
Fri, 5 May 2023 15:13:55 +0000 (12:13 -0300)
commit9a6d10dc312cd6fe5e33a72af6259ac9b05f6db7
treeb87becb88f60411b08a8bac0d4c1d4213aef0bb2
parent2504a282b5890168616c1a87206f8762c38a660d
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>
C4/ImportBatch.pm