[sr-dev] continuous rls related db_mysql errors

[Daniel-Constantin Mierla]

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

-- 
Daniel-Constantin Mierla - http://www.asipto.com
http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda
Kamailio Advanced Trainings - Berlin, Nov 25-28; Miami, Nov 18-20, 2013
   - more details about Kamailio trainings at http://www.asipto.com -