mysql 事务未提交导致死锁 Lock wait timeout exceeded; try restarting transaction 解决办法
来源:互联网 发布:windows 1511 编辑:程序博客网 时间:2024/05/20 00:48
近日在学习mybatis的时候,再执行一个查询操作的事务sqlSession未提交,导致数据库事务死锁。控制台报的是: Lock wait timeout exceeded; try restarting transaction 挣扎了我一个多小时........
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
如何解决呢:
1.先用这条命令查询数据库阻塞的进程
SELECT * FROM information_schema.innodb_trx
主要看着几个字段,如果有阻塞数据就不是0,找到后在根据下图这个字段杀死进程
2 SHOW PROCESSLIST; 这条语句可以查所有的进程
kill id ;(杀死对应id的进程)
3.另外再补充一点
mybatis 对 jdbc 的代码做过封装,它的事务提交时手动的,所以我们每次要sqlSession.submit();
阅读全文
1 0
- 【Mysql】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
- 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
- lock wait timeout exceeded try restarting transaction mysql
- zz: Windbg: debugging commands
- 接口回调最简单的使用方式
- 安卓桌面消息获取,角标数量显示
- Batch Normalization详解
- shell判断文件/文件夹是否存在
- mysql 事务未提交导致死锁 Lock wait timeout exceeded; try restarting transaction 解决办法
- java中StringBuffer介绍
- ORACLE触发器
- JavaScript基础知识(一、二的补充)
- POI(excel)
- javaee 验证
- 使用nginx实现LB集群
- C#类继承中构造函数用法小结
- 解决python安装selenium报错问题ImportError: No module named 'selenium'