2007. 12. 3, hétfő keltezéssel 10.01-kor Loïc Vernet ezt írta: > Hi, > > I have a little problem, i sometimes have 500 errors due to a "lock > wait timeout" > > Unable to execute UPDATE statement. [wrapped: Could not execute update > [Native Error: Lock wait timeout exceeded; try restarting transaction] > [User Info: UPDATE products SET COUNT_ORDERS = 1,UPDATED_AT = > '2007-12-03 10:39:21' WHERE products.ID=1184]] > What is quiet weird, is that it is a very basic query as you can see.
the problem is not with this query. some other query executed before this locks the table 'products' for a long time, so this update has to wait until that one finishes... and it does not finish quick enough, so this query times out. check the query executed before this one. greets Zoltán Németh > > >>>>>>>>>>>>>>>>> > I think i have found the problem while writing this email, i was > lauchung thi query without retrieving the ongoing transaction. > > $this->getShopOrder()->getOrder($con)->getState()->update($con); > $this->updateProductsStats(); /// ** NO CON *** > $con->commit(); > > > If it can helps. > > COil. > > > > ______________________________________________________________________ > Ne gardez plus qu'une seule adresse mail ! Copiez vos mails vers > Yahoo! Mail > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "symfony users" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en -~----------~----~----~----~------~----~------~--~---
