Mysql 错误ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction
来源:互联网 发布:中国知网软件下载 编辑:程序博客网 时间:2024/06/10 18:53
1,查看数据库的隔离级别:
mysql> select @@tx_isolation;
+-----------------+
| @@tx_isolation |
+-----------------+
| REPEATABLE-READ |
+-----------------+
1 row in set (0.00 sec)
2,去查看先当前库的线程情况:
mysql> show full processlist;
mysql> SELECT * FROM information_schema.INNODB_TRX;
mysql> kill 156665;
mysql> SELECT * FROM INNODB_TRX;
Empty set (0.00 sec)
0 0
- Mysql 错误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 ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction
- Android增量更新
- 用opencv+freetype在图片中显示中文
- 弹道解算(三)
- 九、文件操作与输入输出流、缓冲流
- SQL Server 2000/2005 常用sql查询整理
- Mysql 错误ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction
- Tensorflow
- 虚函数
- 20170310随便写写
- 继承中子类和父类构造方法的关系
- Callable与Future的介绍
- BadgeView简单使用
- 南宁领取房产证流程以及寻找房产评估公司的方法
- stm32f103 usb 修改成自定义复合设备教程