报错内容:
com.mysql.cj.jdbc.exceptions.MySQLTransactionRollbackException: Lock wait timeout exceeded; try restarting transaction
解决方法:
执行 SELECT * FROM information_schema.innodb_trx 找到对应LOCK的线程
执行kill [trx_mysql_thread_id] 括号为上面查询的列名
报错内容:
com.mysql.cj.jdbc.exceptions.MySQLTransactionRollbackException: Lock wait timeout exceeded; try restarting transaction
解决方法:
执行 SELECT * FROM information_schema.innodb_trx 找到对应LOCK的线程
执行kill [trx_mysql_thread_id] 括号为上面查询的列名