Commit but not data in the database.
Dear All,
Below is the snippet from my log file. If you notice first this happened 110320 17:16:14 137 Init DB mpcms
110320 17:16:16 137 Query KILL QUERY 136?
Can anyone explain to me how can it automatically kill another query when I never inniate the query is this a bug? What I notice all the queries link to 136 is in the db even the first which was killed except for this one
"110320 17:17:30 136 Query Insert into tblReceiptDetails Set
receiptID=5186, receiptDetailsID = 10672, outletID = 3,stockID = 9886, productID= 5387,
productType = 'Imei', productQuantity = 1 , productSIQ = '356785040505824', costPrice =
641.58, sellingPrice = 700, profitAmount = 58.42, profit = 'y'". What bug is this?
##Snippet of the log file.
110320 17:14:48 136 Connect
root@175.141.14.162 on mpcms
136 Query SET autocommit=0
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
110320 17:15:22 136 Query BEGIN
110320 17:15:40 136 Query Insert into tblReceipt Set receiptID=5186, outletID=3,
employeeID=68, customerName='siti farahiyah', customerPhone='0194513125',
totalCostAmount=641.58, totalSellingAmount=700, totalProfitAmount=58.42, changeAmount=0,
profit='y', receiptDate = '2011:03:20', receiptTime = '16:52:29'
110320 17:15:59 137 Connect
root@175.141.14.162 on mpcms
137 Query SET autocommit=0
110320 17:16:01 137 Query SHOW VARIABLES
110320 17:16:09 137 Query SHOW COLLATION
110320 17:16:12 137 Query SET character_set_results=NULL
110320 17:16:14 137 Init DB mpcms
110320 17:16:16 137 Query KILL QUERY 136
110320 17:16:17 137 Quit
110320 17:17:30 136 Query Insert into tblReceiptDetails Set receiptID=5186,
receiptDetailsID = 10672, outletID = 3,stockID = 9886, productID= 5387, productType =
'Imei', productQuantity = 1 , productSIQ = '356785040505824', costPrice = 641.58,
sellingPrice = 700, profitAmount = 58.42, profit = 'y'
136 Query Insert into tblTransaction Set transactionID = 5186,
transactionDetailsID=10672, stockID = 9886, productID= 5387, outletFromID = 3, outletToID
= 3, totalAmountBefore = 641.58, totalAmountAfter = 0, totalQuantityBefore = 1,
totalQuantityAfter = 0, averageCostBefore = 641.59, averageCostAfter = 641.59, quantity =
1, costPrice = 641.58, transactionPrice = 700, transactionEmployeeID = 68,
transactionDate='2011:03:20', transactionTime='16:52:29', transactionType = 's'
136 Query Update tblProduct Set tblProduct.branch3TotalStock =
tblProduct.branch3TotalStock -1, tblProduct.branch3TotalAmount =
tblProduct.branch3TotalAmount -641.58 Where tblProduct.productID=5387
136 Query Update tblStockCentral Set tblStockCentral.stockStatus = 's' Where
tblStockCentral.stockSIQ='356785040505824' And tblStockCentral.stockID=9886 And
tblStockCentral.outletID=3
136 Query Insert into tblPaymentDetails Set paymentDetailsID=5475, outletID =
3,receiptID = 5186, paymentTypeID= 1, amount = 700
136 Query COMMIT
110320 17:17:31 136 Quit