Re: Deadlock apparently on a single resource: How to avoid?
Posted by:
Ali Rizvi
Date: January 19, 2006 04:37AM
So basically it is still unknown why the deadlock is occuring, even the innodb status output is not helping in indicating that.
I am sure of one thing that the two tasks that the two processes were doing were both in transactions and both have a code flow of first acquiring exclusive lock on the specific row and then doing all operations and then committing the transaction and leaving the locks. Implicit locking is not being relied upon, the resource is explicitly being locked. Triggers are not being used at all.
Still wondering what to do.
Ali Rizvi
Kolachi Advanced Technologies
Subject
Views
Written By
Posted
2787
January 18, 2006 03:47AM
1796
January 18, 2006 10:25PM
1764
January 19, 2006 12:47AM
1705
January 19, 2006 01:21AM
Re: Deadlock apparently on a single resource: How to avoid?
1670
January 19, 2006 04:37AM
1473
January 19, 2006 04:44AM
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.