[sr-dev] continuous rls related db_mysql errors

[Daniel-Constantin Mierla]

On 9/26/13 12:03 PM, Juha Heinanen wrote:
> Peter Dunkley writes:
>
>> We have only ever used it with PostgreSQL here.  I do know some work was
>> done to the MySQL DB driver some months back to support transactions, etc
>> (needed for separate notifier processes in presence).  Has anybody tested
>> those changes with RLS before, or were they just tested with presence?
> i generated new debian package from master of april 1, 2013 and it
> worked fine.  next day there was big commit on db_mysql module by olle:
>
> http://git.sip-router.org/cgi-bin/gitweb.cgi?p=sip-router;a=commit;h=fe977dfcb940b1c48dd26fe5fe61a25aed23b96a
>
> 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'.

Docs for mysql shows some examples where this case can occur:

- http://dev.mysql.com/doc/refman/5.6/en/lock-tables.html

and I guess it is the case here when a table was locked and a new query 
is done on a different table.

I can look deeper at it later if no one else is getting to it before.

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 -