Dear All,
I have a scenario where I notice in my log file for few different instances there
is one query running and another one is called and kills the former running query.My application is based on C# and using .net connector.I have attached two sample cases but I have many samples to be shown.
Sample 1
If you see this statement 320 Query KILL QUERY 319
thereafter the next statement is only missing not in the database butthe rest are in the
database.
319 Query Insert into tblReceiptDetails Set receiptID=2162,receiptDetailsID = 3687,
outletID = 11,stockID = 3120, productID= 3007,productType = 'Imei', productQuantity = 1 ,
productSIQ ='359478030011584', costPrice = 257, sellingPrice = 290, profitAmount =33,
profit = 'y'
Sample 2
100612 14:15:49 780 Query KILL QUERY 766
Then the query 766 is never run successfully and the delete neverhappen. I am very sure
I never code a KILL QUERY statement in my program. So what bug is this can anyone help me
on this? Thank you.