Lock wait timeout exceeded； try restarting transaction

-- 查看进程，删除trx_state=LOCK的进程
select * from information_schema.innodb_trx;
 
kill trx_id;
 
 
-- 删除耗时较长的线程
SELECT * from information_schema.`PROCESSLIST` WHERE Time > 1000 AND USER = 'root' ORDER BY TIME desc;
 
kill id;