[Koha-bugs] [Bug 18364] LOCK and UNLOCK are not transaction-safe

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18364 --- Comment #9 from Marcel de Rooy <m.de.rooy@rijksmuseum.nl> --- (In reply to Jonathan Druart from comment #6)

The correct way to use LOCK TABLES and UNLOCK TABLES with transactional tables, such as InnoDB tables, is to begin a transaction with SET autocommit = 0 (not START TRANSACTION) followed by LOCK TABLES, and to not call UNLOCK TABLES until you commit the transaction explicitly.

Did you consider record locking instead of table locks here? Not sure if it would resolve the problem.. -- You are receiving this mail because: You are watching all bug changes.