On 9/26/13 12:43 PM, Juha Heinanen wrote:
Daniel-Constantin Mierla writes:
i have not yet tried to generate debian package after the commit.
Looks like this commit is the reason -- I see 'lock tables' statement but no 'unlock tables'.
yes, this commit caused the errors. i verified by generating debian package from april 3 master and started to get the errors.
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.
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.
Can anyone read the details provided at the links above and share his/her understanding?
Cheers, Daniel