Re: Deadlock on UPDATE foo SET bar = ( SELECT ... )
Deadlock always involved multiple statements that are being executed at the same time.
If you look at the deadlock information in the show innodb status, you should be able to see which statements cause the deadlock or lock wait timeout, this is a concurrency problem that will occur sometimes, you just need to write your application to retry the transaction when it happens.
Subject
Views
Written By
Posted
2862
November 04, 2008 02:24AM
Re: Deadlock on UPDATE foo SET bar = ( SELECT ... )
1754
November 08, 2008 06:30AM
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.