异常:Lock wait timeout exceeded; try restarting transaction
来源:互联网 发布:知乎搞笑问答 编辑:程序博客网 时间:2024/06/06 00:00
异常:Lock wait timeout exceeded; try restarting transaction
mysql事务没有提交,导致锁等待,直至超时报错。
解决办法:
在sql工具中输入
select * from information_schema.innodb_trx 执行,找到了一个一直没有提交的只读事务, 找到对应的线程后,执行 kill thread id,再确认一下没有提交的只读事物被干掉了就OK了。线程的id是trx_mysql_thread_id对应的值。例如:kill 456723。show processlist可查看所有线程id
阅读全文
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
- 1205 Lock wait timeout exceeded try restarting transaction
- mysql错误:Lock wait timeout exceeded; try restarting transaction
- mysql : Lock wait timeout exceeded; try restarting transaction
- ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction
- 多播地址基础
- element ui 对话框el-dialog关闭事件
- uva11997 K Smallest Sums(优先队列)
- [PAT乙级]1038. 统计同成绩学生(20)
- windows下编译可在visual studio中调试的FFmpeg
- 异常:Lock wait timeout exceeded; try restarting transaction
- 让我们谈谈虚拟机的那些事儿
- 问题 C: 背包问题
- Hiveserver2 的简单配置说明
- Android FaceDetector实现人脸检测,人脸追踪(框出人脸)(MVP模式)
- 怎样将PDF文件中的图片进行修改
- 使用openssl_encrypt方法替代mcrypt_encrypt做AES加密
- iptables学习笔记:使用NAT实现简单的无线AP
- 网络流总结(持续更新中)