Daniel-Constantin Mierla writes:
I pushed a commit trying to fix it -- can you test it? I don't have an environment for it, as these functions are used only in some cases from presence modules. I coded it looking at mysql docs.
i build new debian package and don't anymore get the errors.
Provided that, it seems transactions and locking tables are not working together in mysql: -http://dev.mysql.com/doc/refman/5.6/en/lock-tables-and-transactions.html
BEGIN is an alias to START TRANSACTION according to:
-http://dev.mysql.com/doc/refman/5.6/en/commit.html
Apparently, set autocommit=0 should be used instead of START TRANSACTION, but then is not clear if we have to set autocommit back to one after COMMIT or ROLLBACK.
my understanding is that there is no need to set autocommit=0 if START TRANSACTION is used to start transaction, because START TRANSACTION implicitly does that and autocommit=0 stays in effect until COMMIT or ROLLBACK is executed.
-- juha