https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33972
--- Comment #28 from Marcel de Rooy <[email protected]> --- 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. _______________________________________________ Koha-bugs mailing list [email protected] https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
