Dear All,
I have an application based on C# and I am using innodb in mysql. I have a problem as below is my log file from my db server. I have this particular query “3112 Query Update tblStockCentral Set tblStockCentral.stockStatus = ‘b’ Where tblStockCentral.stockSIQ=‘355694008189111’ And tblStockCentral.stockID=2143 And tblStockCentral.outletID=11” is not updated but the rest those other queries numbered as 3112 have been committed and the values are all accurate according to the queries. Why this query alone was not updated ? Any ideas? Thank you.
100121 17:33:59 3111 Connect root@60.48.90.43 on mpcms6
3111 Query SHOW VARIABLES
3111 Query SHOW COLLATION
3111 Query SET character_set_results=NULL
3111 Init DB mpcms6
3111 Query SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ
3111 Query BEGIN
3112 Connect root@60.48.90.43 on mpcms
3112 Query SHOW VARIABLES
100121 17:34:00 3112 Query SHOW COLLATION
3112 Query SET character_set_results=NULL
3112 Init DB mpcms
3112 Query SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ
3112 Query BEGIN
3113 Connect root@60.48.90.43 on mpcms11
3113 Query SHOW VARIABLES
3113 Query SHOW COLLATION
3113 Query SET character_set_results=NULL
100121 17:34:01 3113 Init DB mpcms11
3113 Query SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ
3113 Query BEGIN
3112 Query Select tblProduct.productID, tblFranchiseTransferDetails.stockID , tblFranchiseTransferDetails.franchiseTransferDetailsID , tblProduct.productType , tblFranchiseTransferDetails.costPrice , tblFranchiseTransferDetails.franchiseTransferPrice , tblFranchiseTransferDetails.stockSIQ From tblFranchiseTransferDetails Inner Join tblFranchiseTransfer On tblFranchiseTransfer.franchiseTransferID = tblFranchiseTransferDetails.franchiseTransferID Inner Join tblProduct On tblProduct.productID = tblFranchiseTransferDetails.productID Where tblFranchiseTransfer.outletFromID = 11 And tblFranchiseTransfer.franchiseTransferID = 109 And tblFranchiseTransferDetails.franchiseTransferID = 109 And tblFranchiseTransferDetails.outletID = 11
3111 Query Update tblID Set tblID.lastValue = lastValue + 1 Where tblID.tableName=‘tblStock’
3111 Query Insert into tblStock Set receiveOrderID= 109,receiveOrderDetailsID = 122, stockID = 2123,outletFromID = 11,outletID = 6,productID = 85, productType=‘Imei’, stockSIQ = ‘355694008189111’, stockBalance = 1 ,costPrice = 136.67, stockPrice = 136.67, stockDate=‘2010:01:21’, stockTime=‘17:34:08’, transactionType=‘t’
3112 Query Insert into tblStockCentral Set receiveOrderID=109,receiveOrderDetailsID = 122, stockID = 2123,outletFromID = 11,outletID = 6,productID = 85, stockSIQ = ‘355694008189111’, transactionType = ‘t’
3112 Query Update tblStockCentral Set tblStockCentral.stockStatus = ‘b’ Where tblStockCentral.stockSIQ=‘355694008189111’ And tblStockCentral.stockID=2143 And tblStockCentral.outletID=11
3111 Query Update tblProduct Set tblProduct.productTotalStock = 1, tblProduct.productPrice = 136.67, tblProduct.productTotalAmount = 136.67 Where tblProduct.productID=85
3112 Query Update tblProduct Set tblProduct.branch6TotalStock = 1, tblProduct.branch6TotalAmount = 136.67 Where tblProduct.productID=85
3111 Query Insert into tblTransaction Set transactionID = 109, transactionDetailsID=122, stockID = 2123, productID= 85, outletFromID = 11, outletToID = 6, totalAmountBefore = 0, totalAmountAfter = 136.67, totalQuantityBefore = 0, totalQuantityAfter = 1, averageCostBefore = 0, averageCostAfter = 136.67, quantity = 1, costPrice = 136.67, transactionPrice = 136.67, transactionEmployeeID = 86, transactionDate=‘2010:01:21’, transactionTime=‘17:34:08’, transactionType = ‘ti’
3112 Query Insert into tblTransaction Set transactionID = 109, transactionDetailsID=122, stockID = 2123, productID= 85, outletFromID = 11, outletToID = 6, totalAmountBefore = 0, totalAmountAfter = 136.67, totalQuantityBefore = 0, totalQuantityAfter = 1, averageCostBefore = 0, averageCostAfter = 136.67, quantity = 1, costPrice = 136.67, transactionPrice = 136.67, transactionEmployeeID = 86, transactionDate=‘2010:01:21’, transactionTime=‘17:34:08’, transactionType = ‘ti’
3112 Query Update tblFranchiseTransfer Set employeeToID=‘86’,franchiseTransferStatus =‘y’,franchiseTransferToDate=‘2010:01:21’, franchiseTransferToTime=‘17:34:08’ Where franchiseTransferID=109 And outletFromID =11
3113 Query Update tblFranchiseTransfer Set employeeToID=‘86’,franchiseTransferStatus =‘y’,franchiseTransferToDate=‘2010:01:21’, franchiseTransferToTime=‘17:34:08’ Where franchiseTransferID=109 And outletFromID =11
3111 Query COMMIT
3112 Query COMMIT
3113 Query COMMIT
3111 Quit
3112 Quit
3113 Quit