--解决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