26 Sep
2013
26 Sep
'13
5:02 p.m.
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