26 Sep
2013
26 Sep
'13
4:22 p.m.
On 9/26/13 12:43 PM, Juha Heinanen wrote:
Daniel-Constantin Mierla writes:
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 -
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'.