[sr-dev] continuous rls related db_mysql errors

[Juha Heinanen]

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