0
votes
0answers
379 views

mysql deadlock while updating: ERROR 1213 (40001): Deadlock found when trying to get lock; try restarting transaction update

I am using the mysql version 5.5.29 in my production server. while executing set of update statement inside the procedure it is throughing the following error: ERROR 1213 (40001): Deadlock found when ...