Re: Deadlock information incomplete
I have already changed the sequence table to have a single row as you have suggested, but that was not my question. My question was why the information about the deadlock is incomplete?
Transaction 1
WAITING for record lock mode X on index `PRIMARY` of table `pangaea`.`systemsequence`
Transaction 2
HOLDS record lock mode X on index `PRIMARY` of table `pangaea`.`systemsequence`
WAITING FOR record lock mode X insert intention on index `PartID` of table `pangaea`.`customsystem`
Where is the cycle to cause deadlock?
Subject
Views
Written By
Posted
2230
August 26, 2015 09:52AM
963
August 27, 2015 11:35AM
Re: Deadlock information incomplete
904
August 27, 2015 11:50AM
800
August 29, 2015 11:53AM
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.