select * from information_schema.INNODB_TRX;
show full processlist;//找出目前连接的列表
kill ID//根据ID kill掉
相关文章
- 04-04Lock wait timeout exceeded; try restarting transaction（死锁问题）
- 04-04SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction 解决方法
- 04-04Mysql错误: Lock wait timeout exceeded 解决办法
- 04-04Lock wait timeout exceeded; try restarting transaction
- 04-04mysql死锁，等待资源，事务锁，Lock wait timeout exceeded; try restarting transaction解决
- 04-04mysql Lock wait timeout exceeded; try restarting transaction解决
- 04-04Mysql Lock wait timeout exceeded; try restarting transaction的问题
- 04-04Mysql错误: ERROR 1205: Lock wait timeout exceeded; try restarting transaction
- 04-04ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction解决办法
- 04-04pymysql.err.InternalError: (1205, 'Lock wait timeout exceeded; try restarting transaction')错误处理