Re: Commit but not data in the database.
Posted by:
Rick James
Date: March 28, 2011 12:24AM
Here's a _guess_...
C# is emitting this preamble when ever you connect:
110320 17:14:50 136 Query SHOW VARIABLES
110320 17:14:55 136 Query SHOW COLLATION
110320 17:15:06 136 Query SET character_set_results=NULL
110320 17:15:07 136 Init DB mpcms
110320 17:15:12 136 Query SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ
And... (again guessing)
When you reconnect within the same program, and you give the same connection arguments, it kills the old connection and starts a new one.
Do you have more than one Connect() in the program? Or are "136" and "137" coming from different programs (or different instances of the same program)?
An aside... Recommend you create a user other than "root" for your application. "root" has "SUPER" which is useful for admin stuff.
Subject
Views
Written By
Posted
1751
March 26, 2011 11:13AM
708
March 27, 2011 01:42PM
910
March 27, 2011 08:25PM
Re: Commit but not data in the database.
861
March 28, 2011 12:24AM
610
March 28, 2011 10:10AM
663
March 28, 2011 08:30PM
1038
March 28, 2011 08:39PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.