Lock wait timeout exceeded; try restarting transaction

select * from information_schema.innodb_trx ;
SELECT * from information_schema.processlist WHERE id = 196089;

 

https://www.jianshu.com/p/0b4aaa93e7f6