--解决Lock wait timeout exceeded; try restarting transaction

--解决Lock wait timeout exceeded; try restarting transaction

select * from information_schema.innodb_trx; 

--pid是上面sql的trx_mysql_thread_id
kill pid

https://blog.csdn.net/wanderlustLee/article/details/79235005