https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18364 --- Comment #10 from Jonathan Druart <jonathan.druart@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.