MySQL Forums
Forum List  »  InnoDB

Re: Simple transactions cause deadlocks for each other by UPDATE queries locking the primary key
Posted by: Rick James
Date: December 10, 2015 12:45AM

Xaction #1 is an autocommitted UPDATE on `member`.

Xaction #2 has 3 actions on `order`, then tries to UPDATE the same row of `member`.
It got a Shared lock and wants to escalate it to eXclusive.

Suggest filing a bug with
http://bugs.mysql.com

Options: ReplyQuote




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.