https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18364
--- Comment #10 from Jonathan Druart <[email protected]> --- (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. _______________________________________________ Koha-bugs mailing list [email protected] http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
