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=fe977d…
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 -