[Koha-bugs] [Bug 33972] Possible deadlock in C4::ImportBatch::SetimportBatchStatus from BatchCommitRecords

[bugzilla-daemon at bugs.koha-community.org]

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

--- Comment #23 from Nick Clemens <nick at bywatersolutions.com> ---
(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

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