# Why only a single query is executed on commit?

**URL:** <https://forums.percona.com/t/why-only-a-single-query-is-executed-on-commit/831>\
**Category:** Other MySQL® Questions\
**Created:** [July 7, 2008, 9:55am UTC](https://forums.percona.com/t/why-only-a-single-query-is-executed-on-commit/831 "2008-07-07T09:55:39Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![newtomysql](https://avatars.discourse-cdn.com/v4/letter/n/a183cd/32.png) [@newtomysql](https://forums.percona.com/u/newtomysql)\
**Post date:** [July 7, 2008, 9:55am UTC](https://forums.percona.com/t/why-only-a-single-query-is-executed-on-commit/831/1 "2008-07-07T09:55:39Z")

</div>

Dear All,  
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 5.0.8.1 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.

---

<div class="post-metadata">

**Author:** ![debug](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/debug/32/772_2.png) [@debug](https://forums.percona.com/u/debug)\
**Post date:** [July 14, 2008, 4:43am UTC](https://forums.percona.com/t/why-only-a-single-query-is-executed-on-commit/831/2 "2008-07-14T04:43:11Z")

</div>

What do you mean under “not executed”? Is it failing with some error, or what?

---

<div class="post-metadata">

**Author:** ![newtomysql](https://avatars.discourse-cdn.com/v4/letter/n/a183cd/32.png) [@newtomysql](https://forums.percona.com/u/newtomysql)\
**Post date:** [July 14, 2008, 10:45am UTC](https://forums.percona.com/t/why-only-a-single-query-is-executed-on-commit/831/3 "2008-07-14T10:45:07Z")

</div>

Dear Debug,  
Suprisingly there is no error but that part of the code is not executed meaning is not running and generating the result.