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

【推广】免费学中医，健康全家人

原文地址：https://www.cnblogs.com/vanoraxnc/p/9777039.html