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

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33972 --- Comment #28 from Marcel de Rooy <m.de.rooy@rijksmuseum.nl> --- I came across this remark: https://stackoverflow.com/questions/64789956/mariadb-innodb-deadlock-while-d... 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.