Cause: java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction

出现之后查看相应的线程

命令：select * from information_schema.innodb_trx

找到对应的线程之后kill了，就ok!