Magento SQL error SQLSTATE[HY000]

SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction

I have been receiving this error for a few days and couldn’t figure out what the problem was.  It wouldn’t let me update products and save to SQL.

I found this site which gave the following instructions:

Login to cpanel and phpMyAdmin, click on SQL for the command line interface (CLI):

If you login to MySQL from CLI and run the command
SHOW PROCESSLIST;
You can see as an example
6794372 the command is sleep and time is 3800. This is preventing other operations
These processes should be killed 1 by 1 using the command.
KILL 6794372;
Once you have killed all the sleeping connections, things should start working as normal again
Once I killed the sleep line I could save my inventory again.

 

Leave a Comment

Your email address will not be published. Required fields are marked *

Subscribe To Our Newsletter

Subscribe To Our Newsletter

Join our mailing list to receive the latest DEALS, OFFERS and News before anyone else.

You are almost done - please check your inbox for confirmation!

Pin It on Pinterest

Share This
Scroll to Top