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?

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

http://dev.mysql.com/doc/refman/5.0/en/innodb-lock-modes.html

BTW, Whats your tx_isolation?

Please gimme the output of

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


0
 
OctalysAuthor Commented:
@@global.tx_isolation  
REPEATABLE-READ

@@tx_isolation  
REPEATABLE-READ

Hi,

Thanks for the link. I am reading it now
0
 
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.
0
 
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;
0
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.