I have 2 sql queries one is update and the other is insert query and both are in one transaction.I am using .net connector 188.8.131.52 and myengine is innodb. The problem is that some times I find the update query is not executed but the insert query is executed. What do you think can be the cause ? Can it be due to command time out ? Thanks.
What do you mean under “not executed”? Is it failing with some error, or what?
Suprisingly there is no error but that part of the code is not executed meaning is not running and generating the result.