[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 15:33:51 CEST 2017


https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18364

--- Comment #10 from Jonathan Druart <jonathan.druart at bugs.koha-community.org> ---
(In reply to Marcel de Rooy from comment #9)
> (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..

Do you mean 'SELECT FOR UPDATE'?
I tried it yes, see commit message for bug 15854.

-- 
You are receiving this mail because:
You are watching all bug changes.


More information about the Koha-bugs mailing list