MySQL Forums
Forum List  »  InnoDB

Re: Deadlock information incomplete
Posted by: Rick James
Date: August 29, 2015 11:53AM

True, I failed to 'explain' the deadlock. Instead, my answer was aimed at _avoiding_ the deadlock by (1) simplifying the sequence handling (as you did) and (2) moving it out of the transaction.

#2, I think, will guarantee that it will no longer be part of any deadlock. (Other things could cause deadlocks, but the 'sequence' seemed to be the villain this time.)

Options: ReplyQuote


Subject
Views
Written By
Posted
963
August 27, 2015 11:35AM
Re: Deadlock information incomplete
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.