GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

Commit statement being repeated

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Commit statement being repeated

    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

  • #2
    Hi there,

    I think you should debug your code because that two different number means two different connection id.

    Bests,
    Istvan

    Comment

    Working...
    X