查看innodb的事务表INNODB_TRX,看下里面是否有正在锁定的事务线程,看看ID是否在show full processlist里面的sleep线程中,如果是,就证明这个线程事务一直没有commit或者rollback而是卡住了,我们需要手动kill掉。
mysql> SELECT * FROM information_schema.INNODB_TRX\G;
trx_mysql_thread_id: 86200
现在杀死进程:
mysql> kill 86200;
Query OK, 0 rows affected (0.00 sec)
相关文章
- 10-22Lock wait timeout exceeded; try restarting transaction(死锁问题)
- 10-22SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction 解决方法
- 10-22mysql_提示 Lock wait timeout exceeded解决办法
- 10-22Mysql错误: Lock wait timeout exceeded 解决办法
- 10-22mysql提示 Lock wait timeout exceeded解决办法 事务锁死
- 10-22MySQL error : Deadlock found when trying to get lock; try restarting transaction
- 10-22mysql死锁com.mysql.cj.jdbc.exception.MYSQLTransactionRollbackException Deadlock found when trying to get lock;try restarting transaction
- 10-22MySQL事务锁问题-Lock wait timeout exceeded
- 10-22【MySQL】关于MySQL出现lock wait timeout exceeded 的解决方案
- 10-22Lock wait timeout exceeded; try restarting transaction