报错信息:
Cause: com.mysql.cj.jdbc.exceptions.MySQLTransactionRollbackException: Lock wait timeout exceeded; try restarting transaction
解决方案:
首先我们查看被锁表的进程
SELECT * FROM INFORMATION_SCHEMA.INNODB_TRX;
(此图片为处理后截图,所以trx_state为RUNNING,被锁时为LOCK WAIT。)
然后找到进程号,即 trx_mysql_thread_id
执行 kill 进程号;