Fixing “Lock wait timeout exceeded; try restarting transaction” for a ‘stuck” Mysql table?

by

I had a similar problem and solved it by checking the threads that are running.
To see the running threads use the following command in mysql command line interface:

SHOW PROCESSLIST;

It can also be sent from phpMyAdmin if you don’t have access to mysql command line interface.
This will display a list of threads with corresponding ids and execution time, so you can KILL the threads that are taking too much time to execute.
In phpMyAdmin you will have a button for stopping threads by using KILL, if you are using command line interface just use the KILL command followed by the thread id, like in the following example:

KILL 115;

This will terminate the connection for the corresponding thread.

More Related Contents:

  1. How to debug Lock wait timeout exceeded on MySQL?
  2. MySQL AUTO_INCREMENT does not ROLLBACK
  3. Are nested transactions allowed in MySQL?
  4. mysql transaction – roll back on any exception
  5. MySQL : transaction within a stored procedure
  6. When to use SELECT … FOR UPDATE?
  7. How to enable INNODB in mysql
  8. How to display open transactions in MySQL
  9. How can I use transactions in my MySQL stored procedure?
  10. Difference between SET autocommit=1 and START TRANSACTION in mysql (Have I missed something?)
  11. MySQL ‘select for update’ behaviour
  12. Automatic Rollback if COMMIT TRANSACTION is not reached
  13. how to delete data from table A besides the customer service and director data in table B?
  14. Get records with max value for each group of grouped SQL results
  15. How to properly create composite primary keys – MYSQL
  16. MySQL: multiple tables or one table with many columns? [closed]
  17. Add 2 hours to current time in MySQL?
  18. How can I Insert many rows into a MySQL table and return the new IDs?
  19. What is cardinality in MySQL?
  20. How to prepend a string to a column value in MySQL?
  21. How to get first day of every corresponding month in mysql?
  22. How can I import a large (14 GB) MySQL dump file into a new MySQL database?
  23. MySql: Tinyint (2) vs tinyint(1) – what is the difference?
  24. MySQL Enum performance advantage?
  25. Dynamic table name at sql statement
  26. MySQL Inner Join Query Multiple Tables
  27. Select all months within given date span, including the ones with 0 values
  28. ERROR 1356 (HY000): View ‘mysql.user’ references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
  29. Use Composite Primary Key as Foreign Key
  30. Mysql stored procedure don’t take table name as parameter

Leave a Comment