Question:
I have a simple query to the base
UPDATE users SET username='test' WHERE id='3'
After that, the request hangs for 120 seconds and the error “Lock wait timeout exceeded; try restarting transaction” appears. This only applies to one user, in all other cases everything is fine
show full processlist;
command show full processlist;
killed all the updates that hung to this user and re-launched this update and still the same.
How can I unlock it?
Answer:
In my case, if you wait a few seconds (for this there is a sleep
function in php
) and then run the request again, then everything goes fine.
And if an error also occurs, we wait until it works out.