couple of weeks ago there was discussion on this list regarding db_mysql transaction implementation, but there has been no comments from authors of the current code.
based on the earlier discussion, transactions in mysql should be started with command
SET autocommit=0
instead of BEGIN or START TRANSACTION and ending or aborting of transaction with COMMIT or ROLLBACK should be followed by command
SET autocommit=1
if authors agree, please commit the necessary changes.
-- juha
2 okt 2013 kl. 12:13 skrev Juha Heinanen jh@tutpro.com:
couple of weeks ago there was discussion on this list regarding db_mysql transaction implementation, but there has been no comments from authors of the current code.
based on the earlier discussion, transactions in mysql should be started with command
SET autocommit=0
instead of BEGIN or START TRANSACTION and ending or aborting of transaction with COMMIT or ROLLBACK should be followed by command
SET autocommit=1
if authors agree, please commit the necessary changes.
I wonder if the author is on the mailing list. I'll see if I can track him down. It wasn't me - I just relayed.
/O
On 10/2/13 12:13 PM, Juha Heinanen wrote:
couple of weeks ago there was discussion on this list regarding db_mysql transaction implementation, but there has been no comments from authors of the current code.
based on the earlier discussion, transactions in mysql should be started with command
SET autocommit=0
instead of BEGIN or START TRANSACTION and ending or aborting of transaction with COMMIT or ROLLBACK should be followed by command
SET autocommit=1
if authors agree, please commit the necessary changes.
You can go ahead and commit such update if you want. What you proposed seems to be what I found reading the docs of MySQL. Other updates can be done later if someone else shows up with them.
Cheers, Daniel
Daniel-Constantin Mierla writes:
You can go ahead and commit such update if you want. What you proposed seems to be what I found reading the docs of MySQL. Other updates can be done later if someone else shows up with them.
i just commit the changes. it would nice if someone could refer the code. i have been running rls for a while with two notifier processes and have not yet seen problems.
-- juha
-
Daniel-Constantin Mierla -
Juha Heinanen -
Olle E. Johansson