系统无法登陆,查询日志发现执行update语句时有如下报错
### Cause: com.mysql.cj.jdbc.exceptions.MySQLTransactionRollbackException: Lock wait timeout exceeded; try restarting transaction
; Lock wait timeout exceeded; try restarting transaction; nested exception is com.mysql.cj.jdbc.exceptions.MySQLTransactionRollbackException: Lock wait timeout exceeded; try restarting transaction
这条语句被锁住了
进入mysql使用
SELECT * FROM information_schema.innodb_trx where trx_state = 'LOCK WAIT'\G
查询被锁的语句,结果如下
这个线程的id是trx_mysql_thread_id: 25039
kill掉这个锁住的线程
kill 对应的trx_mysql_thread_id
恢复正常