Mysql: Lock wait timeout exceeded; try restarting transaction异常处理
来源:互联网 发布:php微信创建菜单 编辑:程序博客网 时间:2024/06/04 18:20
Mysql: Lock wait timeout exceeded; try restarting transaction异常处理
错误信息如上
select * from information_schema.innodb_trx 之后找到了一个一直没有提交的只读事务,
kill 到了对应的线程后ok 了。
MySQL 5.5 -- innodb_lock_wait 锁 等待
当出现:ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction,
要解决是一件麻烦的事情 ;
特别是当一个SQL执行完了,但未COMMIT,后面的SQL想要执行就是被锁,超时结束;
DBA光从数据库无法着手找出源头是哪个SQL锁住了;
有时候看看show engine innodb status , 并结合 show full processlist; 能暂时解决问题;但一直不能精确定位;
在5.5中,information_schema 库中增加了三个关于锁的表(MEMORY引擎);
innodb_trx ## 当前运行的所有事务
innodb_locks ## 当前出现的锁
innodb_lock_waits ## 锁等待的对应关系
0 0
- Mysql: Lock wait timeout exceeded; try restarting transaction异常处理
- mysql异常Lock wait timeout exceeded; try restarting transaction
- 异常:Lock wait timeout exceeded; try restarting transaction
- Lock wait timeout exceeded; try restarting transaction
- Lock wait timeout exceeded; try restarting transaction
- Lock wait timeout exceeded; try restarting transaction
- Lock wait timeout exceeded; try restarting transaction
- Lock wait timeout exceeded; try restarting transaction
- Lock wait timeout exceeded; try restarting transaction
- Lock wait timeout exceeded; try restarting transaction
- Lock wait timeout exceeded; try restarting transaction
- Lock wait timeout exceeded; try restarting transaction
- Lock wait timeout exceeded; try restarting transaction
- mysql : Lock wait timeout exceeded; try restarting transaction
- mysql错误:Lock wait timeout exceeded; try restarting transaction
- mysql : Lock wait timeout exceeded; try restarting transaction
- mysql : Lock wait timeout exceeded; try restarting transaction
- mysql : Lock wait timeout exceeded; try restarting transaction
- SpringAOP快速使用
- hrbust 哈理工 1013
- PHP中@的用法
- 【Dongle】【Java】规范之EJB
- jstl表达式分页 Mvc后台
- Mysql: Lock wait timeout exceeded; try restarting transaction异常处理
- work record 1
- 算法提高 夺宝奇兵
- Linux Shell的 & 、&& 、 ||
- YOLO install
- RN1_React Native准备热身(react native 学习)
- windows系统下git的安装
- OKHTTP
- spark core 2.0 LongArray