[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 #28 from Marcel de Rooy <m.de.rooy at rijksmuseum.nl> ---
I came across this remark:

https://stackoverflow.com/questions/64789956/mariadb-innodb-deadlock-while-doing-many-inserts
An InnoDB table with both a PRIMARY KEY and a secondary UNIQUE KEY has a large
chance of causing a deadlock. Example of such a case is described clearly in
this bug report: https://bugs.mysql.com/bug.php?id=86812

Note that items has PK on itemnumber and UNIQUE key on barcode.
When you temporarily remove the unique constraint, can you still reproduce?

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