MySQL 1205-Lock wait timeout exceeded; try restarting transaction
程序员文章站
2022-06-02 08:14:53
...
在操作数据库的时候,遇到了这个错误,第一次遇到了,google一下,是MySQL的innodb的事务开启后,没有主动commit,导致资源被占用,其它资源抢不过,形成了lock锁.
错误截图:
解决办法是找到出错process id,然后kill掉.
两种方法找到process
第一种:是直接查看事物表,找出被锁线程的id:SELECT * FROM information_schema.INNODB_TRX;
SELECT * FROM information_schema.INNODB_TRX;
没有权限,所以用不了
第二种:查看所有process
SHOW FULL PROCESSLIST;
SHOW FULL PROCESSLIST;
找到之后,使用kill命令
KIll 123456;
ps: 我把所有我操作的数据库表全都kill掉了,但还是有错误,说明占用事务的是同事操作的sql process,坑爹啊啊啊啊啊啊啊啊啊啊啊啊啊,好在后面好了????.
推荐阅读
-
Lock wait timeout exceeded; try restarting transaction
-
Mysql出现“ Lock wait timeout exceeded; try restarting trans
-
[Err] 1205 - Lock wait timeout exceeded; try restarting transaction
-
[Err] 1205 - Lock wait timeout exceeded; try restarting transaction
-
mysql 1205 - Lock wait timeout exceeded; try restarting transaction
-
MySQL 1205-Lock wait timeout exceeded; try restarting transaction
-
1205 - Lock wait timeout exceeded; try restarting transaction(解决备忘)
-
Lock wait timeout exceeded try restarting transaction
-
1205 - Lock wait timeout exceeded; try restarting transaction
-
Lock wait timeout exceeded; try restarting transaction