[Koha-bugs] [Bug 18364] LOCK and UNLOCK are not transaction-safe
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Wed Apr 12 13:23:07 CEST 2017
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18364
--- Comment #9 from Marcel de Rooy <m.de.rooy at 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.
More information about the Koha-bugs
mailing list