Bug #50516 No commit and query statements
Submitted: 21 Jan 2010 17:18 Modified: 25 Jan 2010 13:03
Reporter: newbie Shai Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server: InnoDB storage engine Severity:S1 (Critical)
Version:5.0.67 OS:Windows (Windows XP)
Assigned to: CPU Architecture:Any

[21 Jan 2010 17:18] newbie Shai
Description:
Dear All,
        I have a problem here where first my application will do a select statement then immediately it will run begin and commit statement. I have attached my log file too. The problem now is that if you notice for all the Id such 76,78,80,82, 84 and 86 you have proper begin and commit. I dont understand why for 88 there is a begin statement but no other statement like commit. Is something very suprising because if there is problem with my application then all should fail but I am puzzled why is it not committed.

How to repeat:
Is difficult to repeat a first such case happening.
[25 Jan 2010 8:54] Sveta Smirnova
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.
[25 Jan 2010 13:03] newbie Shai
Dear Sveta,
          Thank you for your help. But from your perspective if this a database bug then why there is a begin transaction statemetn but not closing commit statement and why just for one single query of so many queries?