MySQL Forums
Forum List  »  InnoDB

Deadlock Issue
Posted by: Jessica Here
Date: August 08, 2017 02:29AM

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;

Options: ReplyQuote


Subject
Views
Written By
Posted
Deadlock Issue
303
August 08, 2017 02:29AM
93
August 08, 2017 09:44AM
92
August 09, 2017 12:48AM
96
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.