MySQL Bugs: #83094: Auto-commit value getting changed at runtime

Bug #83094	Auto-commit value getting changed at runtime
Submitted:	22 Sep 2016 9:40	Modified:	23 Sep 2016 10:44
Reporter:	Amit Kumar	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Server	Severity:	S1 (Critical)
Version:	15.1	OS:	Red Hat
Assigned to:		CPU Architecture:	Any
Tags:	autocommit

Description:
Hi,

I am using database connection pooling to create 25 DB connection.

During formation of DB connections, I'm setting autocommit  = 0 for each connection.

I start my application in daemon mode and it establishes the DB connections.
Once the application has started, when certain operation happen it processes over one DB session.
Now, on top of this running application as daemon, I run the same application in foreground for processing some other operation.
So, it again connects to DB processes the operations and exits.

After this, if I try to do certain operation on my application running as daemon then I have found that my autocommit gets set to 1 and becasue of this I'm not getting desired result. 

How to repeat:
It's random.

Suggested fix:
Autocommit must not be set to 1 unless done.

We're sorry, but the bug system is not the appropriate forum for asking help on using MySQL products. Your problem is not the result of a bug.

Support on using our products is available both free in our forums at http://forums.mysql.com/ and for a reasonable fee direct from our skilled support engineers at http://www.mysql.com/support/

Thank you for your interest in MySQL.