MySQL Forums
Forum List  »  InnoDB

Re: Deadlock information incomplete
Posted by: Vasudevan Sankaran
Date: August 27, 2015 11:50AM

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?

Options: ReplyQuote


Subject
Views
Written By
Posted
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.