MYSQL error: Deadlock found when trying to get lock; try restarting transaction. What does this mean?

MySQL Error - 1213 Deadlock found when trying to get lock; try restarting transaction
DELETE FROM upsl WHERE ipaddress = '100.x.x.x'

I saw this error this morning, I have no idea what it means. Upsl is a innodb table, with lotsa updates. Anyone have an idea?

Who is Participating?
UmeshConnect With a Mentor MySQL Principle Technical Support EngineerCommented:
Below link may explain you very clearly about the error..

BTW, Whats your tx_isolation?

Please gimme the output of

SELECT @@global.tx_isolation;
SELECT @@tx_isolation;

OctalysAuthor Commented:



Thanks for the link. I am reading it now
OctalysAuthor Commented:
I still dont fully understand it. Been using MySQL over 5 years, I never had any locking problem. And I am doing pretty simple things with this table.

Update, Update, Update etc etc, Sleep 1 second then Delete row.
UmeshMySQL Principle Technical Support EngineerCommented:
Which versions you were using earlier? which engines your were using?

Can you post the output of below commands

show global status;
show global variables;
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.