Deadlock Issue
Hi Forum,
Please guide me for the below issue.
We have recently upgraded the mysql DB to version 5.5 and one of the application is throwing the exception of "Deadlock found when trying to get lock; try restarting transaction" with Mysql version 5.5. The procedure has multiple UPDATE statement as per below:
start transaction;
CASE
when condition_1 then
update table_1 ......
when condition_2 then
update table_1 .......
when condition_3 then
update table_1 ......
when condition_4 then
update table_1 .......
when condition_5 then
update table_1 ......
END CASE;
Subject
Views
Written By
Posted
Deadlock Issue
1190
August 08, 2017 02:29AM
413
August 08, 2017 09:44AM
544
August 09, 2017 12:48AM
578
August 09, 2017 04:55AM
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.