Working around MySQL error “Deadlock found when trying to get lock; try restarting transaction”

by

If you are using InnoDB or any row-level transactional RDBMS, then it is possible that any write transaction can cause a deadlock, even in perfectly normal situations. Larger tables, larger writes, and long transaction blocks will often increase the likelihood of deadlocks occurring. In your situation, it’s probably a combination of these.

The only way to truly handle deadlocks is to write your code to expect them. This generally isn’t very difficult if your database code is well written. Often you can just put a try/catch around the query execution logic and look for a deadlock when errors occur. If you catch one, the normal thing to do is just attempt to execute the failed query again.

I highly recommend you read this page in the MySQL manual. It has a list of things to do to help cope with deadlocks and reduce their frequency.

More Related Contents:

  1. How to avoid MySQL ‘Deadlock found when trying to get lock; try restarting transaction’
  2. i have an error which i dont understand. can you help me? [closed]
  3. mysql error 1364 Field doesn’t have a default values
  4. SQL: What is the default Order By of queries?
  5. How to group by week in MySQL?
  6. Can I use a function for a default value in MySql?
  7. Access Denied for User ‘root’@’localhost’ (using password: YES) – No Privileges?
  8. Mysql order by specific ID values
  9. How do I check if a column is empty or null in MySQL?
  10. MySQL versus PDO [duplicate]
  11. Mysql string split [duplicate]
  12. What is this operator in MySQL?
  13. SELECT * WHERE NOT EXISTS
  14. Increment a database field by 1
  15. Measuring actual MySQL query time
  16. How can I suppress column header output for a single SQL statement?
  17. Use a trigger to stop an insert or update
  18. mysql query show multiple tables from one ID column
  19. MySQL: ALTER IGNORE TABLE gives “Integrity constraint violation”
  20. What is the difference between SQL and MySQL? [closed]
  21. How to get the mysql table columns data type?
  22. how to use a like with a join in sql?
  23. Escaping the colon character ‘:’ in JPA queries
  24. How to export / dump a MySql table into a text file including the field names (aka headers or column names)
  25. Xampp-mysql – “Table doesn’t exist in engine” #1932
  26. Unserialize through query at database level itself
  27. MySQL throws Incorrect string value error
  28. ORDER BY alphabet first then follow by number
  29. mysql create table dynamically
  30. Errno 121, duplicate key on write or update?

Leave a Comment