重复add或update导致ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction
来源:互联网 发布:mac 切换 输入法 编辑:程序博客网 时间:2024/06/18 04:35
产生这个问题的原因是因为在mysql中产生了事务A,执行了修改的语句,比如: update t1 set aget=18 where id=1;此时事务并未进行提交,事务B开始运行,也同样需要修改id为1的用户的年龄: update t1 set aget=20 where id=1; 那么此时事务B会等待事务A结束释放写锁才能执行成功,否则则会等待一段时间,产生报错:
ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction
解决方法:
http://blog.csdn.net/mchdba/article/details/38313881
阅读全文
0 0
- 重复add或update导致ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction
- ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction
- ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction
- ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction
- ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction
- ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction
- ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction
- ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction
- ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction
- ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction
- ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction
- ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction
- ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction
- ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction
- ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction
- ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction
- ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction
- mysql执行update提示ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction的应急解决方法
- 通过修改hosts访问外网
- 10个方法让你的私人时间妥妥的
- 时间戳毫秒数转换日期 日期转换时间戳毫秒数
- WPF DateTimePicker
- 【腾讯TMQ】像google一样测试系列之五:流程与覆盖率篇
- 重复add或update导致ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction
- 大小堆之堆排序
- HTML 注册表单form
- Servlet 工程 web.xml 中的 servlet 和 servlet-mapping 标签
- Android获取手机双IMEI号
- Linux裸机下搭建各种服务(第一篇)
- U盘安装Ubuntu
- 重写滑动监听的 WebView
- navicate11下无法显示Mysql中的json列