[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
Mon Jun 26 11:07:58 CEST 2023


https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33972

--- Comment #27 from Marcel de Rooy <m.de.rooy at rijksmuseum.nl> ---
(In reply to Nick Clemens from comment #23)
> (In reply to Marcel de Rooy from comment #22)
> > Nick, what did your DBA find ?
> 
> We are still investigating - we have now seen it both in our mariadb
> cluster, and on a local mariadb on a self hosted server
> 
> In both cases the problem is now occurring in _batchCommitItems ->
> AddItemFromMarc -> Koha::Item->store -> Koha::Object->store
> 
> The INSERT call on items is hanging and then failing:
> DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::mysql::st
> execute failed: Lock wait timeout exceeded; try restarting transaction at
> /usr/share/koha/lib/Koha/Object.pm line 170

Thats interesting. Will try to reproduce this first with two processes
inserting items.

-- 
You are receiving this mail because:
You are watching all bug changes.


More information about the Koha-bugs mailing list