com.mysql.cj.jdbc.exceptions.MySQLTransactionRollbackException: Lock wait timeout exceeded; try restarting transaction
1:select * from information_schema.innodb_trx;
查询出来的trx_mysql_thread_id这个字段是被锁线程id
2:kill trx_mysql_thread_id的值就可以
com.mysql.cj.jdbc.exceptions.MySQLTransactionRollbackException: Lock wait timeout exceeded; try restarting transaction
1:select * from information_schema.innodb_trx;
查询出来的trx_mysql_thread_id这个字段是被锁线程id
2:kill trx_mysql_thread_id的值就可以