Innodb commit bug complete with no updates

[Frwa Onto]

We have been using lots of transaction based statement. Suddenly while doing some audit on the data we found something funny out of many query one of it is not updated accordingly. Below is the query log. The one does not show up the results is

130116 18:07:32 276 Query Update tblProduct Set tblProduct.productTotalStock = tblProduct.productTotalStock -7, tblProduct.productBooked = tblProduct.productBooked -7, tblProduct.productTotalAmount = tblProduct.productTotalAmount -44.03 Where tblProduct.productID=7921 . Even though this query is run but the -7 is not reflected at it is not minus ?

Below is log which show not commit error at the end.

    
279 Query       Select tblID.lastValue From tblID Where tblID.tableName='tblTransfer'
            279 Quit       
            276 Query       Update tblID Set tblID.lastValue = lastValue + 1 Where tblID.tableName='tblTransfer'
            276 Query       Select tblID.lastValue From tblID Where tblID.tableName='tblTransferDetails'
            276 Query       Update tblID Set tblID.lastValue = lastValue + 1 Where tblID.tableName='tblTransferDetails'
            276 Query       Select tblProduct.productTotalStock, tblProduct.productTotalAmount, tblProduct.productBooked, tblProduct.productPrice From tblProduct Where tblProduct.productID=6495
            276 Query       Select  tblStock.stockID, tblStock.stockBalance, tblStock.stockBooked From tblStock Where tblStock.stockBalance > 0 And tblStock.productID=6495 Order By tblStock.stockID
            276 Query       Update tblStock Set tblStock.stockBooked = tblStock.stockBooked +1, tblStock.stockBalance = tblStock.stockBalance -1 Where tblStock.stockID=19058
            276 Query       Update tblStock Set tblStock.stockBooked = tblStock.stockBooked +7, tblStock.stockBalance = tblStock.stockBalance -7 Where tblStock.stockID=19275
            276 Query       Insert into tblTransferDetails Set transferDetailsID = 9299, transferID=3491, outletID = 12, stockID = 19058, productID= 6495, productType = 'Accessory', stockQuantity = 8, stockSIQ = '8', costPrice = 16.16, transferPrice = 16.16
130116 18:07:26     276 Query       Update tblProduct Set tblProduct.productTotalStock = tblProduct.productTotalStock -8,  tblProduct.productBooked = tblProduct.productBooked -8,  tblProduct.productTotalAmount = tblProduct.productTotalAmount -129.28 Where tblProduct.productID=6495
            276 Query       Select tblProduct.productTotalStock, tblProduct.productTotalAmount, tblProduct.productBooked, tblProduct.productPrice From tblProduct Where tblProduct.productID=6495
            276 Query       Insert into tblTransaction Set transactionID = 3491, transactionDetailsID=9299, stockID = 19058, productID= 6495, outletFromID = 12, outletToID = 4, totalAmountBefore = 695.01, totalAmountAfter = 565.73, totalQuantityBefore = 43, totalQuantityAfter = 35, averageCostBefore = 16.16, averageCostAfter = 16.16, quantity = 8, costPrice = 16.16, transactionPrice = 16.16, transactionEmployeeID = 68, transactionDate='2013:01:16', transactionTime='18:07:26', transactionType = 'to'
            276 Query       Select tblID.lastValue From tblID Where tblID.tableName='tblTransferDetails'
            276 Query       Update tblID Set tblID.lastValue = lastValue + 1 Where tblID.tableName='tblTransferDetails'
            276 Query       Select tblProduct.productTotalStock, tblProduct.productTotalAmount, tblProduct.productBooked, tblProduct.productPrice From tblProduct Where tblProduct.productID=7901
            276 Query       Select  tblStock.stockID, tblStock.stockBalance, tblStock.stockBooked From tblStock Where tblStock.stockBalance > 0 And tblStock.productID=7901 Order By tblStock.stockID
            276 Query       Update tblStock Set tblStock.stockBooked = tblStock.stockBooked +4, tblStock.stockBalance = tblStock.stockBalance -4 Where tblStock.stockID=19495
            276 Query       Insert into tblTransferDetails Set transferDetailsID = 9300, transferID=3491, outletID = 12, stockID = 19495, productID= 7901, productType = 'Accessory', stockQuantity = 4, stockSIQ = '4', costPrice = 21, transferPrice = 21
            276 Query       Update tblProduct Set tblProduct.productTotalStock = tblProduct.productTotalStock -4,  tblProduct.productBooked = tblProduct.productBooked -4,  tblProduct.productTotalAmount = tblProduct.productTotalAmount -84 Where tblProduct.productID=7901
            276 Query       Select tblProduct.productTotalStock, tblProduct.productTotalAmount, tblProduct.productBooked, tblProduct.productPrice From tblProduct Where tblProduct.productID=7901
            276 Query       Insert into tblTransaction Set transactionID = 3491, transactionDetailsID=9300, stockID = 19495, productID= 7901, outletFromID = 12, outletToID = 4, totalAmountBefore = 168, totalAmountAfter = 84, totalQuantityBefore = 8, totalQuantityAfter = 4, averageCostBefore = 21, averageCostAfter = 21, quantity = 4, costPrice = 21, transactionPrice = 21, transactionEmployeeID = 68, transactionDate='2013:01:16', transactionTime='18:07:26', transactionType = 'to'
            276 Query       Select tblID.lastValue From tblID Where tblID.tableName='tblTransferDetails'
            276 Query       Update tblID Set tblID.lastValue = lastValue + 1 Where tblID.tableName='tblTransferDetails'
            276 Query       Select tblProduct.productTotalStock, tblProduct.productTotalAmount, tblProduct.productBooked, tblProduct.productPrice From tblProduct Where tblProduct.productID=6498
            276 Query       Select  tblStock.stockID, tblStock.stockBalance, tblStock.stockBooked From tblStock Where tblStock.stockBalance > 0 And tblStock.productID=6498 Order By tblStock.stockID
            276 Query       Update tblStock Set tblStock.stockBooked = tblStock.stockBooked +6, tblStock.stockBalance = tblStock.stockBalance -6 Where tblStock.stockID=19297
            276 Query       Update tblStock Set tblStock.stockBooked = tblStock.stockBooked +2, tblStock.stockBalance = tblStock.stockBalance -2 Where tblStock.stockID=19494
            276 Query       Insert into tblTransferDetails Set transferDetailsID = 9301, transferID=3491, outletID = 12, stockID = 19297, productID= 6498, productType = 'Accessory', stockQuantity = 8, stockSIQ = '8', costPrice = 7.56, transferPrice = 7.56
            276 Query       Update tblProduct Set tblProduct.productTotalStock = tblProduct.productTotalStock -8,  tblProduct.productBooked = tblProduct.productBooked -8,  tblProduct.productTotalAmount = tblProduct.productTotalAmount -60.48 Where tblProduct.productID=6498
            276 Query       Select tblProduct.productTotalStock, tblProduct.productTotalAmount, tblProduct.productBooked, tblProduct.productPrice From tblProduct Where tblProduct.productID=6498
            276 Query       Insert into tblTransaction Set transactionID = 3491, transactionDetailsID=9301, stockID = 19297, productID= 6498, outletFromID = 12, outletToID = 4, totalAmountBefore = 377.97, totalAmountAfter = 317.49, totalQuantityBefore = 50, totalQuantityAfter = 42, averageCostBefore = 7.56, averageCostAfter = 7.56, quantity = 8, costPrice = 7.56, transactionPrice = 7.56, transactionEmployeeID = 68, transactionDate='2013:01:16', transactionTime='18:07:26', transactionType = 'to'
            276 Query       Select tblID.lastValue From tblID Where tblID.tableName='tblTransferDetails'
            276 Query       Update tblID Set tblID.lastValue = lastValue + 1 Where tblID.tableName='tblTransferDetails'
            276 Query       Select tblProduct.productTotalStock, tblProduct.productTotalAmount, tblProduct.productBooked, tblProduct.productPrice From tblProduct Where tblProduct.productID=7791
            276 Query       Select  tblStock.stockID, tblStock.stockBalance, tblStock.stockBooked From tblStock Where tblStock.stockBalance > 0 And tblStock.productID=7791 Order By tblStock.stockID
            276 Query       Update tblStock Set tblStock.stockBooked = tblStock.stockBooked +4, tblStock.stockBalance = tblStock.stockBalance -4 Where tblStock.stockID=19138
            276 Query       Insert into tblTransferDetails Set transferDetailsID = 9302, transferID=3491, outletID = 12, stockID = 19138, productID= 7791, productType = 'Accessory', stockQuantity = 4, stockSIQ = '4', costPrice = 9.13, transferPrice = 9.13
130116 18:07:27     276 Query       Update tblProduct Set tblProduct.productTotalStock = tblProduct.productTotalStock -4,  tblProduct.productBooked = tblProduct.productBooked -4,  tblProduct.productTotalAmount = tblProduct.productTotalAmount -36.52 Where tblProduct.productID=7791
            276 Query       Select tblProduct.productTotalStock, tblProduct.productTotalAmount, tblProduct.productBooked, tblProduct.productPrice From tblProduct Where tblProduct.productID=7791
            276 Query       Insert into tblTransaction Set transactionID = 3491, transactionDetailsID=9302, stockID = 19138, productID= 7791, outletFromID = 12, outletToID = 4, totalAmountBefore = 301.28, totalAmountAfter = 264.76, totalQuantityBefore = 33, totalQuantityAfter = 29, averageCostBefore = 9.13, averageCostAfter = 9.13, quantity = 4, costPrice = 9.13, transactionPrice = 9.13, transactionEmployeeID = 68, transactionDate='2013:01:16', transactionTime='18:07:27', transactionType = 'to'
            276 Query       Select tblID.lastValue From tblID Where tblID.tableName='tblTransferDetails'
            276 Query       Update tblID Set tblID.lastValue = lastValue + 1 Where tblID.tableName='tblTransferDetails'
            276 Query       Select tblProduct.productTotalStock, tblProduct.productTotalAmount, tblProduct.productBooked, tblProduct.productPrice From tblProduct Where tblProduct.productID=7923
            276 Query       Select  tblStock.stockID, tblStock.stockBalance, tblStock.stockBooked From tblStock Where tblStock.stockBalance > 0 And tblStock.productID=7923 Order By tblStock.stockID
            276 Query       Update tblStock Set tblStock.stockBooked = tblStock.stockBooked +4, tblStock.stockBalance = tblStock.stockBalance -4 Where tblStock.stockID=19504
            276 Query       Insert into tblTransferDetails Set transferDetailsID = 9303, transferID=3491, outletID = 12, stockID = 19504, productID= 7923, productType = 'Accessory', stockQuantity = 4, stockSIQ = '4', costPrice = 7, transferPrice = 7
            276 Query       Update tblProduct Set tblProduct.productTotalStock = tblProduct.productTotalStock -4,  tblProduct.productBooked = tblProduct.productBooked -4,  tblProduct.productTotalAmount = tblProduct.productTotalAmount -28 Where tblProduct.productID=7923
            276 Query       Select tblProduct.productTotalStock, tblProduct.productTotalAmount, tblProduct.productBooked, tblProduct.productPrice From tblProduct Where tblProduct.productID=7923
            276 Query       Insert into tblTransaction Set transactionID = 3491, transactionDetailsID=9303, stockID = 19504, productID= 7923, outletFromID = 12, outletToID = 4, totalAmountBefore = 77, totalAmountAfter = 49, totalQuantityBefore = 11, totalQuantityAfter = 7, averageCostBefore = 7, averageCostAfter = 7, quantity = 4, costPrice = 7, transactionPrice = 7, transactionEmployeeID = 68, transactionDate='2013:01:16', transactionTime='18:07:27', transactionType = 'to'
            276 Query       Select tblID.lastValue From tblID Where tblID.tableName='tblTransferDetails'
            276 Query       Update tblID Set tblID.lastValue = lastValue + 1 Where tblID.tableName='tblTransferDetails'
            276 Query       Select tblProduct.productTotalStock, tblProduct.productTotalAmount, tblProduct.productBooked, tblProduct.productPrice From tblProduct Where tblProduct.productID=7922
            276 Query       Select  tblStock.stockID, tblStock.stockBalance, tblStock.stockBooked From tblStock Where tblStock.stockBalance > 0 And tblStock.productID=7922 Order By tblStock.stockID
            276 Query       Update tblStock Set tblStock.stockBooked = tblStock.stockBooked +6, tblStock.stockBalance = tblStock.stockBalance -6 Where tblStock.stockID=19506
            276 Query       Insert into tblTransferDetails Set transferDetailsID = 9304, transferID=3491, outletID = 12, stockID = 19506, productID= 7922, productType = 'Accessory', stockQuantity = 6, stockSIQ = '6', costPrice = 5, transferPrice = 5
130116 18:07:28     276 Query       Update tblProduct Set tblProduct.productTotalStock = tblProduct.productTotalStock -6,  tblProduct.productBooked = tblProduct.productBooked -6,  tblProduct.productTotalAmount = tblProduct.productTotalAmount -30 Where tblProduct.productID=7922
            276 Query       Select tblProduct.productTotalStock, tblProduct.productTotalAmount, tblProduct.productBooked, tblProduct.productPrice From tblProduct Where tblProduct.productID=7922
            276 Query       Insert into tblTransaction Set transactionID = 3491, transactionDetailsID=9304, stockID = 19506, productID= 7922, outletFromID = 12, outletToID = 4, totalAmountBefore = 60, totalAmountAfter = 30, totalQuantityBefore = 12, totalQuantityAfter = 6, averageCostBefore = 5, averageCostAfter = 5, quantity = 6, costPrice = 5, transactionPrice = 5, transactionEmployeeID = 68, transactionDate='2013:01:16', transactionTime='18:07:28', transactionType = 'to'
            276 Query       Select tblID.lastValue From tblID Where tblID.tableName='tblTransferDetails'
            276 Query       Update tblID Set tblID.lastValue = lastValue + 1 Where tblID.tableName='tblTransferDetails'
            276 Query       Select tblProduct.productTotalStock, tblProduct.productTotalAmount, tblProduct.productBooked, tblProduct.productPrice From tblProduct Where tblProduct.productID=7921
            276 Query       Select  tblStock.stockID, tblStock.stockBalance, tblStock.stockBooked From tblStock Where tblStock.stockBalance > 0 And tblStock.productID=7921 Order By tblStock.stockID
            276 Query       Update tblStock Set tblStock.stockBooked = tblStock.stockBooked +7, tblStock.stockBalance = tblStock.stockBalance -7 Where tblStock.stockID=19505
            276 Query       Insert into tblTransferDetails Set transferDetailsID = 9305, transferID=3491, outletID = 12, stockID = 19505, productID= 7921, productType = 'Accessory', stockQuantity = 7, stockSIQ = '7', costPrice = 6.29, transferPrice = 6.29
130116 18:07:29     276 Query       Update tblProduct Set tblProduct.productTotalStock = tblProduct.productTotalStock -7,  tblProduct.productBooked = tblProduct.productBooked -7,  tblProduct.productTotalAmount = tblProduct.productTotalAmount -44.03 Where tblProduct.productID=7921
            276 Query       Select tblProduct.productTotalStock, tblProduct.productTotalAmount, tblProduct.productBooked, tblProduct.productPrice From tblProduct Where tblProduct.productID=7921
            276 Query       Insert into tblTransaction Set transactionID = 3491, transactionDetailsID=9305, stockID = 19505, productID= 7921, outletFromID = 12, outletToID = 4, totalAmountBefore = 176.12, totalAmountAfter = 132.09, totalQuantityBefore = 28, totalQuantityAfter = 21, averageCostBefore = 6.29, averageCostAfter = 6.29, quantity = 7, costPrice = 6.29, transactionPrice = 6.29, transactionEmployeeID = 68, transactionDate='2013:01:16', transactionTime='18:07:29', transactionType = 'to'
            276 Query       Select tblID.lastValue From tblID Where tblID.tableName='tblTransferDetails'
            276 Query       Update tblID Set tblID.lastValue = lastValue + 1 Where tblID.tableName='tblTransferDetails'
            276 Query       Select tblProduct.productTotalStock, tblProduct.productTotalAmount, tblProduct.productBooked, tblProduct.productPrice From tblProduct Where tblProduct.productID=7926
            276 Query       Select  tblStock.stockID, tblStock.stockBalance, tblStock.stockBooked From tblStock Where tblStock.stockBalance > 0 And tblStock.productID=7926 Order By tblStock.stockID
            276 Query       Update tblStock Set tblStock.stockBooked = tblStock.stockBooked +5, tblStock.stockBalance = tblStock.stockBalance -5 Where tblStock.stockID=19503
            276 Query       Insert into tblTransferDetails Set transferDetailsID = 9306, transferID=3491, outletID = 12, stockID = 19503, productID= 7926, productType = 'Accessory', stockQuantity = 5, stockSIQ = '5', costPrice = 9, transferPrice = 9
130116 18:07:30     276 Query       Update tblProduct Set tblProduct.productTotalStock = tblProduct.productTotalStock -5,  tblProduct.productBooked = tblProduct.productBooked -5,  tblProduct.productTotalAmount = tblProduct.productTotalAmount -45 Where tblProduct.productID=7926
            276 Query       Select tblProduct.productTotalStock, tblProduct.productTotalAmount, tblProduct.productBooked, tblProduct.productPrice From tblProduct Where tblProduct.productID=7926
130116 18:07:31     276 Query       Insert into tblTransaction Set transactionID = 3491, transactionDetailsID=9306, stockID = 19503, productID= 7926, outletFromID = 12, outletToID = 4, totalAmountBefore = 135, totalAmountAfter = 90, totalQuantityBefore = 15, totalQuantityAfter = 10, averageCostBefore = 9, averageCostAfter = 9, quantity = 5, costPrice = 9, transactionPrice = 9, transactionEmployeeID = 68, transactionDate='2013:01:16', transactionTime='18:07:31', transactionType = 'to'
            276 Query       Select tblID.lastValue From tblID Where tblID.tableName='tblTransferDetails'
            276 Query       Update tblID Set tblID.lastValue = lastValue + 1 Where tblID.tableName='tblTransferDetails'
            276 Query       Select tblProduct.productTotalStock, tblProduct.productTotalAmount, tblProduct.productBooked, tblProduct.productPrice From tblProduct Where tblProduct.productID=7921
            276 Query       Select  tblStock.stockID, tblStock.stockBalance, tblStock.stockBooked From tblStock Where tblStock.stockBalance > 0 And tblStock.productID=7921 Order By tblStock.stockID
            276 Query       Update tblStock Set tblStock.stockBooked = tblStock.stockBooked +7, tblStock.stockBalance = tblStock.stockBalance -7 Where tblStock.stockID=19505
            276 Query       Insert into tblTransferDetails Set transferDetailsID = 9307, transferID=3491, outletID = 12, stockID = 19505, productID= 7921, productType = 'Accessory', stockQuantity = 7, stockSIQ = '7', costPrice = 6.29, transferPrice = 6.29
130116 18:07:32     276 Query       Update tblProduct Set tblProduct.productTotalStock = tblProduct.productTotalStock -7,  tblProduct.productBooked = tblProduct.productBooked -7,  tblProduct.productTotalAmount = tblProduct.productTotalAmount -44.03 Where tblProduct.productID=7921
            276 Query       Select tblProduct.productTotalStock, tblProduct.productTotalAmount, tblProduct.productBooked, tblProduct.productPrice From tblProduct Where tblProduct.productID=7921
            276 Query       Insert into tblTransaction Set transactionID = 3491, transactionDetailsID=9307, stockID = 19505, productID= 7921, outletFromID = 12, outletToID = 4, totalAmountBefore = 132.09, totalAmountAfter = 88.06, totalQuantityBefore = 21, totalQuantityAfter = 14, averageCostBefore = 6.29, averageCostAfter = 6.29, quantity = 7, costPrice = 6.29, transactionPrice = 6.29, transactionEmployeeID = 68, transactionDate='2013:01:16', transactionTime='18:07:32', transactionType = 'to'
        276 Query       Delete From tblTempTransfer
            276 Query       COMMIT
            276 Quit