MySQL出现错误1205-Lock wait timeout exceeded; try restarting transaction
来源:互联网 发布:域名没备案能解析吗 编辑:程序博客网 时间:2024/06/05 02:23
今天在清空mysql数据库中的表格数据时,报了如下错误,导致操作失败:
上网查找了一下,了解到了该类问题出现的主要原因是:Mysql的 InnoDB存储引擎是支持事务的,事务开启后没有被主动Commit,导致该资源被长期占用,其他事务在抢占该资源时,因上一个事务的锁而导致抢占失败!因此出现 Lock wait timeout exceeded。
解决办法:
方法一:
1. 查看事物表,找出被锁线程的id:SELECT * FROM information_schema.INNODB_TRX;
2. 根据id,kill掉被锁住的线程:kill 65
方法二:
1. 执行MySQL命令:SHOW FULL PROCESSLIST; 找到被锁住的线程ID(如下图中的65)
2. 根据id,kill掉被锁住的线程:kill 64
阅读全文
0 0
- Mysql出现“ Lock wait timeout exceeded; try restarting transaction”错误
- MySQL出现错误1205-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 ERROR 1205:Lock wait timeout exceeded; try restarting transaction
- MYSQL:Lock wait timeout exceeded; try restarting transaction ;ERROR 1205
- mysql Error 1205: Lock wait timeout exceeded; try restarting transaction
- Mysql 错误ERROR 1205 (HY000): 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
- MyBatis foreach语句批量插入数据
- web级mysql
- Linux 下如何安装禅道
- Android okhttp 三种请求方式 get put post
- 关于安卓手机 的调试
- MySQL出现错误1205-Lock wait timeout exceeded; try restarting transaction
- 组合数学-- 放回取样基础公式证明
- List调用remove(object);方法无法删除!
- mysql5.7在centos上安装的完整教程以及相关的“坑”
- The most simple and easy to use Qt GUI library plug-in FTStyle (1)
- 代码重构(三):数据重构规则
- Median of Two Sorted Arrays
- MYSQL中limit以及oder by混用产生的一些错误
- Python中常用的字符串内建函数