[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