Skip navigation links

MySQL Forums :: InnoDB :: Commit but not data in the database.


Advanced Search

Commit but not data in the database.
Posted by: newbie Shai ()
Date: March 26, 2011 11:13AM

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

Options: ReplyQuote


Subject Views Written By Posted
Commit but not data in the database. 1107 newbie Shai 03/26/2011 11:13AM
Re: Commit but not data in the database. 454 Rick James 03/27/2011 01:42PM
Re: Commit but not data in the database. 615 newbie Shai 03/27/2011 08:25PM
Re: Commit but not data in the database. 537 Rick James 03/28/2011 12:24AM
Re: Commit but not data in the database. 418 newbie Shai 03/28/2011 10:10AM
Re: Commit but not data in the database. 418 Rick James 03/28/2011 08:30PM
Re: Commit but not data in the database. 764 newbie Shai 03/28/2011 08:39PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.