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

Posted on 2008-11-18
Last Modified: 2012-05-05
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?

Question by:Octalys
    LVL 26

    Accepted Solution

    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;


    Author Comment




    Thanks for the link. I am reading it now

    Author Comment

    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.
    LVL 26

    Expert Comment

    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;

    Featured Post

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    A lot of articles have been written on splitting mysqldump and grabbing the required tables. A long while back, when Shlomi ( had suggested a “sed” way, I actually shell …
    As a database administrator, you may need to audit your table(s) to determine whether the data types are optimal for your real-world data needs.  This Article is intended to be a resource for such a task. Preface The other day, I was involved …
    Need more eyes on your posted question? Go ahead and follow the quick steps in this video to learn how to Request Attention to your question. *Log into your Experts Exchange account *Find the question you want to Request Attention for *Go to the e…
    Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

    732 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now