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