MySQL 事务没有提交导致 锁等待 Lock wait timeout exceeded
来源:互联网 发布:mp4转avi软件 编辑:程序博客网 时间:2024/05/08 19:06
Lock wait timeout exceeded
当一个SQL执行完了,但未COMMIT,后面的SQL想要执行就是被锁,超时结束;
select * from information_schema.innodb_trx 之后找到了一个一直没有提交的只读事务,
kill 到了对应的线程后ok 了。
mysql> select * from information_schema.innodb_trx;
+--------+-----------+---------------------+-----------------------+------------------+------------+---------------------+-----------+---------------------+-------------------+-------------------+------------------+-----------------------+-----------------+-------------------+-------------------------+---------------------+-------------------+------------------------+----------------------------+---------------------------+---------------------------+| trx_id | trx_state | trx_started | trx_requested_lock_id | trx_wait_started | trx_weight | trx_mysql_thread_id | trx_query | trx_operation_state | trx_tables_in_use | trx_tables_locked | trx_lock_structs | trx_lock_memory_bytes | trx_rows_locked | trx_rows_modified | trx_concurrency_tickets | trx_isolation_level | trx_unique_checks | trx_foreign_key_checks | trx_last_foreign_key_error | trx_adaptive_hash_latched | trx_adaptive_hash_timeout |
+--------+-----------+---------------------+-----------------------+------------------+------------+---------------------+-----------+---------------------+-------------------+-------------------+------------------+-----------------------+-----------------+-------------------+-------------------------+---------------------+-------------------+------------------------+----------------------------+---------------------------+---------------------------+
| F663B | RUNNING | 2016-11-09 10:15:52 | NULL | NULL | 10 | 14310 | NULL | NULL | 0 | 0 | 7 | 1248 | 4 | 3 | 0 | REPEATABLE READ | 1 | 1 | NULL | 0 | 9999 |
+--------+-----------+---------------------+-----------------------+------------------+------------+---------------------+-----------+---------------------+-------------------+-------------------+------------------+-----------------------+-----------------+-------------------+-------------------------+---------------------+-------------------+------------------------+----------------------------+---------------------------+---------------------------+
1 row in set
mysql> kill 14310 ;
Query OK, 0 rows affected
mysql>
0 0
- MySQL 事务没有提交导致 锁等待 Lock wait timeout exceeded 事物锁
- MySQL 事务没有提交导致 锁等待 Lock wait timeout exceeded
- MySQL 事务没有提交导致 锁等待 Lock wait timeout exceeded
- MySQL 事务没有提交导致 锁等待 Lock wait timeout exceeded
- MySQL 事务没有提交导致 锁等待 Lock wait timeout exceeded
- MySQL 事务没有提交导致 锁等待 Lock wait timeout exceeded
- mysql事务没有提交导致 锁等待Lock wait timeout exceeded异常
- MySQL 事务没有提交导致 锁等待 Lock wait timeout exceeded
- 【MySQL】事务没有提交导致 锁等待Lock wait timeout exceeded异常的处理办法
- 【MySQL】事务没有提交导致 锁等待Lock wait timeout exceeded异常
- MySQL 事务没有提交导致 锁等待 Lock wait timeout exceeded
- MySQL 事务没有提交导致 锁等待 Lock wait timeout exceeded
- MySQL 事务没有提交导致 锁等待 Lock wait timeout exceeded
- MySQL 事务没有提交导致 锁等待 Lock wait timeout exceeded
- 【Mysql】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
- iBATIS工作原理浅析
- redis集群操作
- xshell无法连接本地虚拟机上的linux: Connection failed
- git分支上传文件步骤解读
- JavaBean链接MySQL数据库错误aq.executeQuery.Can not issue data manipulation statements with executeQuery()解决
- MySQL 事务没有提交导致 锁等待 Lock wait timeout exceeded
- Restful接口传入多参数的问题和解决方案
- Android 应用商店评分+APP分享
- Word Ladder
- 数位DP(数字和与倍数,uva 11361)
- 深度学习资源
- 素数筛选(《编程珠玑》学习之路)
- git error setting certificate verify locations
- ECMAScript6笔记:数组的扩展