[Koha-bugs] [Bug 33972] Possible deadlock in C4::ImportBatch::SetimportBatchStatus from BatchCommitRecords
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Fri Jun 16 14:32:47 CEST 2023
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33972
Katrin Fischer <katrin.fischer at bsz-bw.de> changed:
What |Removed |Added
----------------------------------------------------------------------------
Attachment #152400|0 |1
is obsolete| |
--- Comment #16 from Katrin Fischer <katrin.fischer at bsz-bw.de> ---
Created attachment 152409
-->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=152409&action=edit
Bug 33972: Set importing status to batch outside of transaction
This patch moves the setting of the 'importing' status for the batch
outside fo the transaction.
This prevents a scenario seen on some setups where a deadlock is created:
background_jobs_worker.pl: C4::ImportBatch::SetImportBatchStatus(): DBI
Exception: DBD::mysql::db do failed: Lock wait timeout exceeded; try restarting
transaction at /usr/share/koha/lib/C4/ImportBatch.pm line 717
To test:
1 - Apply patch
2 - Stage and import some files
3 - Confirm the imports successfully complete
Signed-off-by: Marcel de Rooy <m.de.rooy at rijksmuseum.nl>
--
You are receiving this mail because:
You are watching all bug changes.
More information about the Koha-bugs
mailing list