[338] MySQL error: error 1205: lock wait timeout exceeded solution

Solutions:
Execute mysql command: Show Full ProcessList;

Then find the system ID of the query statement: kill the thread ID that is being locked

Select * from information_schema.innodb_trx; select * from information_schema.innodb_trx;

Refer to the article: http://my.oschina.net/quanzhong/blog/222091
http://blog.sina.com.cn/s/blog_53e68b3b0101bjxi.html


Read More: