Re: MySQL locking in Duplicate Key Error
Exactly. I just want to understand so as to why the third one deadlocks? The doc says that they acquire shared locks. But I am unable to understand that because how can share locks come into picture with insert query?
Also, the second one runs because the third transaction rollbacks with the error.
Subject
Views
Written By
Posted
1598
June 22, 2016 10:58AM
688
June 22, 2016 01:04PM
Re: MySQL locking in Duplicate Key Error
833
June 22, 2016 01:21PM
652
July 12, 2016 02:50AM
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.