今天遇到这个问题是因为mysql 里有个事务一直没结束,
导致其他线程进来后一直等待锁
模块报错Caused by: com.mysql.cj.jdbc.exceptions.MySQLTransactionRollbackException: Lock wait timeout exceeded; try restarting transaction
解决:
//获取事务
SELECT * FROM information_schema.innodb_trx;
//获取锁
SELECT * FROM information_schema.innodb_locks;
//获取当前正在工作线程与锁的关系
SELECT * FROM information_schema.innodb_lock_waits ;
杀掉对应的进程
kill 3774;