Dear All,
I have an exception case where I notice the same query set is being repeated twice when I have check in my whole application there is no one place of repeated code which causes this to happen.How I justify this is because this happen first time and only for this one case? I have given my the snippet of my log file below: Look at the 650 and 651 both are the same and being repeated. Any reason for this?
100204 11:44:02 648 Connect root@localhost on mpcms12
648 Query SHOW VARIABLES
648 Query SHOW COLLATION
648 Query SET character_set_results=NULL
648 Init DB mpcms12
648 Query Select tblProduct.productTotalStock, tblProduct.productBooked, tblProduct.productPrice, tblProduct.productTotalAmount From tblProduct Where productID=3833
649 Connect root@localhost on mpcms12
649 Query SHOW VARIABLES
649 Query SHOW COLLATION
649 Query SET character_set_results=NULL
649 Init DB mpcms12
649 Query SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ
649 Query BEGIN
649 Query Update tblProduct Set tblProduct.productBooked = tblProduct.productBooked + 4 Where tblProduct.productID=3833
649 Query Insert into tblTempTransfer Set productType=‘Accessory’, productID=3833, stockID =‘1’, stockSIQ =‘4’, employeeID = ‘2’, tempTransferTimeStamp=‘2010:02:04 11:44:02’
649 Query COMMIT
649 Quit
648 Quit
100204 11:44:21 650 Connect root@localhost on mpcms12
650 Query SHOW VARIABLES
650 Query SHOW COLLATION
650 Query SET character_set_results=NULL
650 Init DB mpcms12
650 Query SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ
650 Query BEGIN
650 Query Update tblProduct Set tblProduct.productBooked = tblProduct.productBooked - 4 Where tblProduct.productID=3833
650 Query Delete From tblTempTransfer Where tblTempTransfer.stockID=1
650 Query COMMIT
650 Quit
100204 11:44:27 651 Connect root@localhost on mpcms12
651 Query SHOW VARIABLES
651 Query SHOW COLLATION
651 Query SET character_set_results=NULL
651 Init DB mpcms12
651 Query SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ
651 Query BEGIN
651 Query Update tblProduct Set tblProduct.productBooked = tblProduct.productBooked - 4 Where tblProduct.productID=3833
651 Query Delete From tblTempTransfer Where tblTempTransfer.stockID=1
651 Query COMMIT
651 Quit