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