Getting “Lock wait timeout exceeded; try restarting transaction” even though I’m not using a transaction

by

HOW TO FORCE UNLOCK for locked tables in MySQL:

Breaking locks like this may cause atomicity in the database to not be enforced on the sql statements that caused the lock.

This is hackish, and the proper solution is to fix your application that caused the locks. However, when dollars are on the line, a swift kick will get things moving again.

1) Enter MySQL

mysql -u your_user -p

2) Let’s see the list of locked tables

mysql> show open tables where in_use>0;

3) Let’s see the list of the current processes, one of them is locking your table(s)

mysql> show processlist;

4) Kill one of these processes

mysql> kill <put_process_id_here>;

More Related Contents:

  1. Which DB technology is sued to solve the following search issue? [closed]
  2. MySQL pivot row into dynamic number of columns
  3. Delete all Duplicate Rows except for One in MySQL? [duplicate]
  4. Count the number of occurrences of a string in a VARCHAR field?
  5. UPDATE multiple rows with different values in one query in MySQL
  6. Unknown Column In Where Clause
  7. Multiple Updates in MySQL
  8. SQL split comma separated row [duplicate]
  9. Storing JSON in database vs. having a new column for each key
  10. MySQL – Subtracting value from previous row, group by
  11. How do I restore a dump file from mysqldump?
  12. How do I create a sequence in MySQL?
  13. MySQL – Conditional Foreign Key Constraints
  14. How to count items in comma separated list MySQL
  15. Groupwise maximum
  16. Filter by COUNT(*)?
  17. Error Code: 1406. Data too long for column – MySQL
  18. MySQL order by “best match”
  19. How to select rows that have current day’s timestamp?
  20. MySQL concatenation operator
  21. SQL Group By with an Order By
  22. Checking a table for time overlap?
  23. Does mysql have the equivalent of Oracle’s “analytic functions”?
  24. MySql – Way to update portion of a string?
  25. Using reserved words in column names
  26. MySQL INNER JOIN select only one row from second table
  27. Storing IPv6 Addresses in MySQL
  28. Insert/ Update random date in MySQL
  29. Replace null with 0 in MySQL
  30. Get total hours worked in a day mysql

Leave a Comment