How to resolve mysql Lock wait timeout exceeded; try restarting transaction error?
To resolve mysql lock timeout run below queries.

Run this:

SET GLOBAL innodb_lock_wait_timeout = 5000; 
And then this:

SET innodb_lock_wait_timeout = 5000;
Write
×