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=fe977df...
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