大量AUTO-INC LOCK 导致的DeadLOCK

最新推荐文章于 2024-05-19 20:57:00 发布
最新推荐文章于 2024-05-19 20:57:00 发布
阅读量3.3k 收藏
点赞数
分类专栏： 数据库 文章标签： thread table user struct action login

原文链接：http://steven1981.itpub.net/post/7967/494087

官方文档关于AUTO_INC锁说明

 

今天发现数据库报检查到死锁，而且有大量的回滚。
当时状态见：< show engine innodb status G 结果>

这个库压力比较大，但从STATUS看，都 是 lock mode AUTO-INC waiting.
而且从应用开发了解到，都是简单的INSERT和select。 没有交叉更新的事务。
如果是等待AUTO-INC锁，也不应该会产生死锁。因为AUTO-INC锁在某一时刻只会被一个事务/INSERT操作 占有。INSERT一旦完成就会释放AUTO-INC锁。

那怎么会有死锁呢?

 

于是上bugs.mysql.com 报了个BUG：http://bugs.mysql.com/bug.php?id=49084

得到回复：
[25 Nov 5:38] Valeriy Kravchuk
Looks like a duplicate of bug #49001. Please, check.


http://bugs.mysql.com/bug.php?id=49084
===============================================
Description:
InnoDB aborts deadlock detection when it finds more than 200 locks in that section of the
lock graph. However, when it does this it records incorrect information in the LATEST
DETECTED DEADLOCK section.

How to repeat:
CREATE TABLE test.t1 (a int) ENGINE=InnoDB;
INSERT INTO test.t1 VALUES (5);
SET GLOBAL max_connections = 500;

for i in {1..200}; do ( yes "UPDATE test.t1 SET a=$i where a=5 ;" | mysql -uroot -h127.0.0.1 -S /tmp/mysql.sock test & ) ; done

In another connection do:

SHOW INNODB STATUSG
SHOW PROCESSLIST;
===============================================

虽然锁的类型不一样，但MYSQL的处理机制是一样的。
只要有超过200个锁的等待，MYSQL会把它当作死锁来处理，然 后KILL掉某个进程。

关于AUTO-INC锁：
--------------------
innodb 在MySQL5.0里有时候的行为也是表锁：比如说当表里有一个auto_increment字段的时候，
innodb会在内存里保存一个计数器 用来记录auto_increment的值，当插入一个新行数据时，
就会用一个表锁来锁住这个计数器，直到插入结束。
如果一行一行的插入 数据则没有什么问题，但是如果大量的并发插入就废了，表锁会引起SQL堵塞，
不但影响效率，而且可能会瞬间达到max_connections而 崩溃。

有一个方法就是使用MySQL5.1（推荐5.1.40），在这个版本里，虽然上面的问题仍然存在。
但他出现了一个新的 配置选项：innodb_autoinc_lock_mode，它是专门用来在使用auto_increment的情况下调整锁策略的，目前有三种选择：
innodb_autoinc_lock_mode = 0 (“traditional” lock mode)
innodb_autoinc_lock_mode = 1 (“consecutive” lock mode)
innodb_autoinc_lock_mode = 2 (“interleaved” lock mode)
关于这个参数的具体含义见： http://dev.mysql.com/doc/refman/5.1/en/innodb-auto-increment-handling.html


---------------------------------------------------------------------------------------

(root@im_newlog4a:)[(none )]> show engine innodb status G
*************************** 1. row ***************************
Status:
=====================================
091124 18:07:27 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 55 seconds
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 568544859, signal count 410475613
--Thread 1211971936 has waited at ../include/log0log.ic line 315 for 0.00 seconds the semaphore:
Mutex at 0x2ac9b0b910 created file log0log.c line 744, lock var 1
waiters flag 0
--Thread 1247648096 has waited at ../include/log0log.ic line 315 for 0.00 seconds the semaphore:
Mutex at 0x2ac9b0b910 created file log0log.c line 744, lock var 1
waiters flag 0
Mutex spin waits 0, rounds 35626241599, OS waits 371074456
RW-shared spins 180954456, OS waits 88191643; RW-excl spins 91992164, OS waits 71197598
------------------------
LATEST DETECTED DEADLOCK
------------------------
091124 18:04:58
*** (1) TRANSACTION:
TRANSACTION 2 1757811763, ACTIVE 1 sec, process no 2289, OS thread id 1169373536 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 1 lock struct(s), heap size 368
MySQL thread id 1074298, query id 10176734566 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:41:33','cnalichnshowcorp','-1958381443','6.16.04','0')
*** (1) WAITING FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757811763 lock mode AUTO-INC waiting

*** (2) TRANSACTION:
TRANSACTION 2 1757809862, ACTIVE 13 sec, process no 2289, OS thread id 1273739616 inserting, thread declared inside InnoDB 500
mysql tables in use 1, locked 1
2 lock struct(s), heap size 3024, undo log entries 13
MySQL thread id 1071849, query id 10176734567 172.18.8.220 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 16:10:22','cntaobaosgf130','-212660782','6.16.04','0')
*** (2) HOLDS THE LOCK(S):
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757809862 lock mode AUTO-INC
*** (2) WAITING FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757811877 lock mode AUTO-INC waiting
TOO DEEP OR LONG SEARCH IN THE LOCK TABLE WAITS-FOR GRAPH
*** WE ROLL BACK TRANSACTION (2)
------------
TRANSACTIONS
------------
Trx id counter 2 1757836657
Purge done for trx's n:o < 2 1750646447 undo n:o < 0 0
History list length 7
Total number of lock structs in row lock hash table 0
... truncated...
process no 2289, OS thread id 1186679136 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 1216, undo log entries 2
MySQL thread id 1074214, query id 10176886677 172.18.8.158 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 18:07:20','cntaobao????????','0','','1')
------- TRX HAS BEEN WAITING 1 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757835228 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757835217, ACTIVE 6 sec, process no 2289, OS thread id 1244186976 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 1216, undo log entries 2
MySQL thread id 1074334, query id 10176886545 172.18.57.110 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 18:07:21','cntaobao????jj','0','','1')
------- TRX HAS BEEN WAITING 1 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757835217 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757835117, ACTIVE 7 sec, process no 2289, OS thread id 1176295776 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 1216, undo log entries 2
MySQL thread id 1074412, query id 10176885581 172.18.8.220 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 18:07:20','cnalichnshzhongxin888','0','','1')
------- TRX HAS BEEN WAITING 1 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757835117 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757835047, ACTIVE 7 sec, process no 2289, OS thread id 1171237216 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 1216, undo log entries 2
MySQL thread id 1074246, query id 10176884932 172.18.8.158 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 18:07:20','cntaobaotaylor1971','-956313635','1.00.00IMWEB_TB','0')
------- TRX HAS BEEN WAITING 2 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757835047 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757835042, ACTIVE 7 sec, process no 2289, OS thread id 1214368096 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 1216, undo log entries 2
MySQL thread id 1074305, query id 10176884888 172.18.57.110 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 18:07:20','cntaobaodatoubao1985','0','','1')
------- TRX HAS BEEN WAITING 2 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757835042 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757834979, ACTIVE 7 sec, process no 2289, OS thread id 1196796256 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 1216, undo log entries 2
MySQL thread id 1074253, query id 10176883881 172.18.8.158 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 18:07:19','cntaobao????????1','0','','1')
------- TRX HAS BEEN WAITING 2 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757834979 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757834889, ACTIVE 8 sec, process no 2289, OS thread id 1276135776 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 1216, undo log entries 3
MySQL thread id 1074344, query id 10176888615 172.18.57.110 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 18:07:18','cntaobao?3????','0','','1')
------- TRX HAS BEEN WAITING 0 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757834889 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757834850, ACTIVE 8 sec, process no 2289, OS thread id 1268414816 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 1216, undo log entries 3
MySQL thread id 1074254, query id 10176888485 172.18.8.158 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 18:07:19','cntaobao????????','613460700','6.16.04','0')
------- TRX HAS BEEN WAITING 0 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757834850 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757834819, ACTIVE 8 sec, process no 2289, OS thread id 1275070816 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 1216, undo log entries 3
MySQL thread id 1074417, query id 10176887838 172.18.8.220 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 18:07:19','cntaobaoroselight','-1829982403','6.16.04','0')
------- TRX HAS BEEN WAITING 0 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757834819 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757834761, ACTIVE 8 sec, process no 2289, OS thread id 1218095456 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 1216, undo log entries 3
MySQL thread id 1071978, query id 10176887394 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:55:53','cntaobaomenqy','0','','1')
------- TRX HAS BEEN WAITING 1 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757834761 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757834715, ACTIVE 8 sec, process no 2289, OS thread id 1184815456 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 1216, undo log entries 3
MySQL thread id 1074216, query id 10176886842 172.18.8.158 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 18:07:18','cntaobaofencysun','0','','1')
------- TRX HAS BEEN WAITING 1 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757834715 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757834650, ACTIVE 9 sec, process no 2289, OS thread id 1291045216 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 1216, undo log entries 3
MySQL thread id 1074333, query id 10176886458 172.18.57.110 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 18:07:17','cntaobao??????','0','','1')
------- TRX HAS BEEN WAITING 1 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757834650 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757834636, ACTIVE 9 sec, process no 2289, OS thread id 1221024096 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 1216, undo log entries 3
MySQL thread id 1074355, query id 10176886082 172.18.57.110 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 18:07:18','cntaobao0o????o0','1329517130','6.16.04','0')
------- TRX HAS BEEN WAITING 1 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757834636 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757834571, ACTIVE 9 sec, process no 2289, OS thread id 1163250016 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 1216, undo log entries 3
MySQL thread id 1074251, query id 10176885595 172.18.8.158 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 18:07:18','cnalichnzslabb','-650218883','6.16.04','0')
------- TRX HAS BEEN WAITING 1 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757834571 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757834529, ACTIVE 9 sec, process no 2289, OS thread id 1287317856 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 1216, undo log entries 3
MySQL thread id 1074231, query id 10176885508 172.18.8.158 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 18:07:18','cntaobaolaokai0954','0','','1')
------- TRX HAS BEEN WAITING 1 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757834529 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757834525, ACTIVE 9 sec, process no 2289, OS thread id 1197062496 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 1216, undo log entries 3
MySQL thread id 1074268, query id 10176885490 172.18.8.158 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 18:07:17','cntaobaoyuelinxiyin','0','','1')
------- TRX HAS BEEN WAITING 1 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757834525 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757834486, ACTIVE 9 sec, process no 2289, OS thread id 1207179616 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 1216, undo log entries 3
MySQL thread id 1071938, query id 10176885270 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:59:31','cntaobaolove_????','0','','1')
------- TRX HAS BEEN WAITING 1 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757834486 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757834479, ACTIVE 10 sec, process no 2289, OS thread id 1233271136 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 1216, undo log entries 3
MySQL thread id 1074392, query id 10176885120 172.18.8.220 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 18:07:17','cnalichnyp5188','0','','1')
------- TRX HAS BEEN WAITING 2 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757834479 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757834457, ACTIVE 10 sec, process no 2289, OS thread id 1289980256 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 1216, undo log entries 3
MySQL thread id 1074244, query id 10176884998 172.18.8.158 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 18:07:17','cntaobaozhouzhan_009','-267734306','6.16.04','0')
------- TRX HAS BEEN WAITING 2 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757834457 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757834387, ACTIVE 10 sec, process no 2289, OS thread id 1256167776 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 1216, undo log entries 3
MySQL thread id 1074224, query id 10176884323 172.18.8.158 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 18:07:16','cnalichnjury627','0','','1')
------- TRX HAS BEEN WAITING 2 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757834387 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757834372, ACTIVE 10 sec, process no 2289, OS thread id 1191737696 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 1216, undo log entries 3
MySQL thread id 1074261, query id 10176884142 172.18.8.158 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 18:07:16','cntaobaozhyh0517','0','','1')
------- TRX HAS BEEN WAITING 2 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757834372 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757834335, ACTIVE 10 sec, process no 2289, OS thread id 1166444896 inserting, thread declared inside InnoDB 500
mysql tables in use 1, locked 1
2 lock struct(s), heap size 1216, undo log entries 4
MySQL thread id 1074388, query id 10176883681 172.18.8.220 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 18:07:16','cntaobaorenxidong','0','','1')
---TRANSACTION 2 1757834327, ACTIVE 10 sec, process no 2289, OS thread id 1258830176 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 1216, undo log entries 4
MySQL thread id 1071974, query id 10176888983 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:55:01','cntaobao??????','744614779','6.16.20','0')
------- TRX HAS BEEN WAITING 0 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757834327 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757834295, ACTIVE 10 sec, process no 2289, OS thread id 1254037856 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 1216, undo log entries 4
MySQL thread id 1074219, query id 10176888857 172.18.8.158 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 18:07:17','enaliintwzbest','0','','1')
------- TRX HAS BEEN WAITING 0 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757834295 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757834227, ACTIVE 10 sec, process no 2289, OS thread id 1269746016 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 1216, undo log entries 4
MySQL thread id 1071975, query id 10176888551 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:59:39','cnalichnlijun85418','-939162917','6.16.04','0')
------- TRX HAS BEEN WAITING 0 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757834227 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757834224, ACTIVE 10 sec, process no 2289, OS thread id 1182951776 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 1216, undo log entries 4
MySQL thread id 1074320, query id 10176888474 172.18.57.110 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 18:07:16','cntaobaogracesubi','0','','1')
------- TRX HAS BEEN WAITING 0 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757834224 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757834042, ACTIVE 11 sec, process no 2289, OS thread id 1198127456 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 1216, undo log entries 4
MySQL thread id 1071930, query id 10176886257 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:59:25','cntaobaosunnyjj2003','1307566964','1.00.00IMWEB_TB','0')
------- TRX HAS BEEN WAITING 1 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757834042 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757833897, ACTIVE 12 sec, process no 2289, OS thread id 1280928096 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 1216, undo log entries 4
MySQL thread id 1071960, query id 10176885137 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:59:11','cntaobao????????2008','0','','1')
------- TRX HAS BEEN WAITING 2 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757833897 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757833870, ACTIVE 12 sec, process no 2289, OS thread id 1182153056 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 1216, undo log entries 4
MySQL thread id 1074270, query id 10176884804 172.18.8.158 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 18:07:14','cntaobao????cisy','0','','1')
------- TRX HAS BEEN WAITING 2 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757833870 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757833796, ACTIVE 12 sec, process no 2289, OS thread id 1206380896 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 1216, undo log entries 4
MySQL thread id 1071958, query id 10176884171 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:58:56','cntaobao????_2005','-1705637155','6.16.04','0')
------- TRX HAS BEEN WAITING 2 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757833796 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757833795, ACTIVE 12 sec, process no 2289, OS thread id 1167243616 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 1216, undo log entries 4
MySQL thread id 1074225, query id 10176884090 172.18.8.158 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 18:07:14','cntaobaomanymary','-111284614','6.16.04','0')
------- TRX HAS BEEN WAITING 2 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757833795 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757833753, ACTIVE 12 sec, process no 2289, OS thread id 1282259296 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 1216, undo log entries 5
MySQL thread id 1074341, query id 10176889058 172.18.57.110 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 18:07:14','cnalichncenxelectang','-1911086471','6.16.04','0')
------- TRX HAS BEEN WAITING 0 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757833753 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757833735, ACTIVE 12 sec, process no 2289, OS thread id 1205582176 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 1216, undo log entries 5
MySQL thread id 1074259, query id 10176888881 172.18.8.158 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 18:07:13','cnalichncdhfjjc','-586780042','6.10.30','0')
------- TRX HAS BEEN WAITING 0 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757833735 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757833647, ACTIVE 13 sec, process no 2289, OS thread id 1212770656 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 1216, undo log entries 5
MySQL thread id 1074241, query id 10176888559 172.18.8.158 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 18:07:13','cntaobaoyuki197388','34834549','6.16.04','0')
------- TRX HAS BEEN WAITING 0 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757833647 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757833185, ACTIVE 15 sec, process no 2289, OS thread id 1164048736 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 1216, undo log entries 5
MySQL thread id 1074394, query id 10176884347 172.18.8.220 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 18:07:12','cntaobao????','753955965','6.16.04','0')
------- TRX HAS BEEN WAITING 2 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757833185 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757832975, ACTIVE 16 sec, process no 2289, OS thread id 1250842976 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 1216, undo log entries 6
MySQL thread id 1074250, query id 10176887178 172.18.8.158 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 18:07:10','cntaobaohuiyuan?????','-1448426275','6.16.20','0')
------- TRX HAS BEEN WAITING 1 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757832975 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757832590, ACTIVE 18 sec, process no 2289, OS thread id 1286252896 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 1216, undo log entries 7
MySQL thread id 1074032, query id 10176888702 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:45:46','cntaobaomwx????','-1890845322','6.10.30','0')
------- TRX HAS BEEN WAITING 0 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757832590 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757832536, ACTIVE 18 sec, process no 2289, OS thread id 1277999456 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 1216, undo log entries 7
MySQL thread id 1071977, query id 10176888123 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:54:48','cntaobao???????2008','446636665','6.10.36','0')
------- TRX HAS BEEN WAITING 0 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757832536 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757832321, ACTIVE 19 sec, process no 2289, OS thread id 1272408416 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 1216, undo log entries 7
MySQL thread id 1074281, query id 10176885418 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:44:21','cntaobaosongyao77','0','','1')
------- TRX HAS BEEN WAITING 1 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757832321 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757831621, ACTIVE 22 sec, process no 2289, OS thread id 1181886816 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 1216, undo log entries 9
MySQL thread id 1074291, query id 10176888415 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:46:25','cntaobaojqiy9oxl','0','','1')
------- TRX HAS BEEN WAITING 0 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757831621 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757831549, ACTIVE 22 sec, process no 2289, OS thread id 1235933536 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 1216, undo log entries 9
MySQL thread id 1071942, query id 10176886762 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:58:08','cntaobao????','-273410444','6.16.04','0')
------- TRX HAS BEEN WAITING 1 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757831549 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757831428, ACTIVE 22 sec, process no 2289, OS thread id 1264687456 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 1216, undo log entries 9
MySQL thread id 1074294, query id 10176884436 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:50:08','cntaobaoc68331','-2055936547','6.16.05','0')
------- TRX HAS BEEN WAITING 2 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757831428 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757831046, ACTIVE 24 sec, process no 2289, OS thread id 1227680096 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 1216, undo log entries 10
MySQL thread id 1074292, query id 10176885535 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:53:05','cntaobaotiantian176896513','675419196','6.16.05','0')
------- TRX HAS BEEN WAITING 1 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757831046 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757831036, ACTIVE 24 sec, process no 2289, OS thread id 1181354336 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 1216, undo log entries 10
MySQL thread id 1074289, query id 10176885482 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:47:14','cntaobao????99','0','','1')
------- TRX HAS BEEN WAITING 1 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757831036 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757830982, ACTIVE 25 sec, process no 2289, OS thread id 1170438496 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 1216, undo log entries 10
MySQL thread id 1071952, query id 10176884416 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:57:54','cnalichnluaidong888','967320957','6.16.04','0')
------- TRX HAS BEEN WAITING 2 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757830982 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757830715, ACTIVE 26 sec, process no 2289, OS thread id 1162185056 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 1216, undo log entries 11
MySQL thread id 1071961, query id 10176885915 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:57:46','cntaobaoilovexk11','383272829','6.10.30','0')
------- TRX HAS BEEN WAITING 1 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757830715 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757830483, ACTIVE 27 sec, process no 2289, OS thread id 1237530976 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 3024, undo log entries 12
MySQL thread id 1074300, query id 10176887664 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:44:00','cntaobaofangshengwen','-415282470','6.16.04','0')
------- TRX HAS BEEN WAITING 0 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757830483 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757830220, ACTIVE 28 sec, process no 2289, OS thread id 1274804576 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 3024, undo log entries 13
MySQL thread id 1071950, query id 10176888733 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:57:40','cntaobaochenfeiangle','0','','1')
------- TRX HAS BEEN WAITING 0 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757830220 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757830145, ACTIVE 28 sec, process no 2289, OS thread id 1189341536 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 3024, undo log entries 13
MySQL thread id 1074299, query id 10176886906 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:43:48','cntaobao???rose','0','','1')
------- TRX HAS BEEN WAITING 1 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757830145 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757830022, ACTIVE 29 sec, process no 2289, OS thread id 1273207136 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 3024, undo log entries 13
MySQL thread id 1071946, query id 10176885388 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:57:33','cntaobao?????????','-1855880836','6.10.01','0')
------- TRX HAS BEEN WAITING 1 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757830022 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757829820, ACTIVE 30 sec, process no 2289, OS thread id 1243122016 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 3024, undo log entries 14
MySQL thread id 1071971, query id 10176887970 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:57:27','cntaobao????????????','0','','1')
------- TRX HAS BEEN WAITING 0 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757829820 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757829740, ACTIVE 30 sec, process no 2289, OS thread id 1234602336 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 3024, undo log entries 14
MySQL thread id 1074287, query id 10176887033 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:44:08','cntaobaocatchan','-972288135','6.10.30','0')
------- TRX HAS BEEN WAITING 1 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757829740 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757829276, ACTIVE 32 sec, process no 2289, OS thread id 1219692896 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 3024, undo log entries 15
MySQL thread id 1071934, query id 10176885823 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:57:20','cntaobaoyanling1980','343956338','6.10.30','0')
------- TRX HAS BEEN WAITING 1 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757829276 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757828890, ACTIVE 34 sec, process no 2289, OS thread id 1206114656 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 3024, undo log entries 16
MySQL thread id 1071976, query id 10176886822 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:57:14','cntaobaozcmlp320425','0','','1')
------- TRX HAS BEEN WAITING 1 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757828890 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757828475, ACTIVE 36 sec, process no 2289, OS thread id 1261226336 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 3024, undo log entries 17
MySQL thread id 1071927, query id 10176887045 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:57:07','cntaobao??????????','-217026186','6.16.04','0')
------- TRX HAS BEEN WAITING 1 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757828475 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757828367, ACTIVE 36 sec, process no 2289, OS thread id 1223154016 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 3024, undo log entries 17
MySQL thread id 1071973, query id 10176885066 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:57:01','cntaobao?????520','45857597','6.16.04','0')
------- TRX HAS BEEN WAITING 2 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757828367 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757828259, ACTIVE 37 sec, process no 2289, OS thread id 1187211616 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 3024, undo log entries 18
MySQL thread id 1074099, query id 10176888646 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:53:32','cntaobaoningqinl','-455241411','6.16.04','0')
------- TRX HAS BEEN WAITING 0 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757828259 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757827272, ACTIVE 42 sec, process no 2289, OS thread id 1188542816 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 3024, undo log entries 21
MySQL thread id 1071936, query id 10176888935 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:56:54','cntaobaomc????','0','','1')
------- TRX HAS BEEN WAITING 0 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757827272 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757827197, ACTIVE 42 sec, process no 2289, OS thread id 1225017696 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 3024, undo log entries 21
MySQL thread id 1071939, query id 10176888405 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:56:47','cntaobaosarabowa2918','0','','1')
------- TRX HAS BEEN WAITING 0 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757827197 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757826835, ACTIVE 44 sec, process no 2289, OS thread id 1248979296 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 3024, undo log entries 22
MySQL thread id 1071944, query id 10176888573 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:56:15','cntaobao??????0204','0','','1')
------- TRX HAS BEEN WAITING 0 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757826835 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757826259, ACTIVE 47 sec, process no 2289, OS thread id 1172035936 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 3024, undo log entries 23
MySQL thread id 1071981, query id 10176885013 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:56:08','cntaobao??????','-442508579','6.16.04','0')
------- TRX HAS BEEN WAITING 2 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757826259 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757825938, ACTIVE 49 sec, process no 2289, OS thread id 1239394656 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 3024, undo log entries 24
MySQL thread id 1071926, query id 10176885835 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:56:00','cntaobao???????','-1540062597','6.16.04','0')
------- TRX HAS BEEN WAITING 1 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757825938 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757825933, ACTIVE 49 sec, process no 2289, OS thread id 1191471456 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 3024, undo log entries 24
MySQL thread id 1074290, query id 10176885607 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:44:29','cntaobaoshenchunling1','-412189059','6.10.08','0')
------- TRX HAS BEEN WAITING 1 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757825933 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757825031, ACTIVE 53 sec, process no 2289, OS thread id 1266817376 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 3024, undo log entries 27
MySQL thread id 1073729, query id 10176888688 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:44:42','cntaobao???????2008','0','','1')
------- TRX HAS BEEN WAITING 0 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757825031 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757824799, ACTIVE 54 sec, process no 2289, OS thread id 1171769696 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 3024, undo log entries 28
MySQL thread id 1071943, query id 10176888995 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:55:49','cntaobaotl19860311','1764006011','6.16.04','0')
------- TRX HAS BEEN WAITING 0 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757824799 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757824780, ACTIVE 55 sec, process no 2289, OS thread id 1208777056 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 3024, undo log entries 28
MySQL thread id 1071945, query id 10176888867 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:55:42','cntaobao?????????','1527457149','6.10.08','0')
------- TRX HAS BEEN WAITING 0 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757824780 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757824664, ACTIVE 55 sec, process no 2289, OS thread id 1284655456 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 3024, undo log entries 28
MySQL thread id 1073752, query id 10176886988 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:47:35','cnalichntiancifu88888','0','','1')
------- TRX HAS BEEN WAITING 1 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757824664 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757824063, ACTIVE 59 sec, process no 2289, OS thread id 1172568416 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 3024, undo log entries 30
MySQL thread id 1074272, query id 10176887292 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:47:09','cntaobao??????','600904410','6.16.04','0')
------- TRX HAS BEEN WAITING 1 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757824063 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757823856, ACTIVE 60 sec, process no 2289, OS thread id 1185081696 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 3024, undo log entries 31
MySQL thread id 1071947, query id 10176888876 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:55:35','cntaobaoxuguoqiang1971','-1358609283','6.16.20','0')
------- TRX HAS BEEN WAITING 0 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757823856 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757823078, ACTIVE 64 sec, process no 2289, OS thread id 1275603296 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 3024, undo log entries 33
MySQL thread id 1071937, query id 10176885356 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:55:24','cntaobaojaniceguo','193122172','6.10.30','0')
------- TRX HAS BEEN WAITING 1 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757823078 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757822575, ACTIVE 67 sec, process no 2289, OS thread id 1190406496 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 6752, undo log entries 35
MySQL thread id 1074297, query id 10176885408 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:48:16','cntaobaosleepapple','-1475923909','6.05.11','0')
------- TRX HAS BEEN WAITING 1 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757822575 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757822498, ACTIVE 68 sec, process no 2289, OS thread id 1273473376 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 6752, undo log entries 35
MySQL thread id 1071948, query id 10176883717 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:55:16','cnalichnwokun1973','0','','1')
------- TRX HAS BEEN WAITING 2 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757822498 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757821868, ACTIVE 72 sec, process no 2289, OS thread id 1239660896 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 6752, undo log entries 38
MySQL thread id 1071928, query id 10176885520 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:55:09','cntaobao??????','0','','1')
------- TRX HAS BEEN WAITING 1 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757821868 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757821588, ACTIVE 74 sec, process no 2289, OS thread id 1234868576 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 6752, undo log entries 39
MySQL thread id 1071963, query id 10176885083 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:54:57','cntaobao????????','0','','1')
------- TRX HAS BEEN WAITING 2 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757821588 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757821346, ACTIVE 75 sec, process no 2289, OS thread id 1284389216 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 6752, undo log entries 40
MySQL thread id 1074279, query id 10176884682 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:50:34','cntaobaozlnczg','-482971532','1.00.00IMWEB_TB','0')
------- TRX HAS BEEN WAITING 2 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757821346 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757820983, ACTIVE 77 sec, process no 2289, OS thread id 1214634336 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 6752, undo log entries 42
MySQL thread id 1073462, query id 10176887630 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:44:16','cntaobao???_78','1210026101','6.10.08','0')
------- TRX HAS BEEN WAITING 0 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757820983 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757820473, ACTIVE 80 sec, process no 2289, OS thread id 1280129376 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 6752, undo log entries 44
MySQL thread id 1071951, query id 10176887811 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:54:41','cntaobaobj100600','0','','1')
------- TRX HAS BEEN WAITING 0 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757820473 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757820386, ACTIVE 81 sec, process no 2289, OS thread id 1186412896 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 6752, undo log entries 44
MySQL thread id 1074296, query id 10176885646 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:43:35','cntaobaointex???????','-359772803','6.16.04','0')
------- TRX HAS BEEN WAITING 1 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757820386 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757820095, ACTIVE 82 sec, process no 2289, OS thread id 1269479776 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 6752, undo log entries 45
MySQL thread id 1071984, query id 10176886570 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:54:35','cntaobao????????','0','','1')
------- TRX HAS BEEN WAITING 1 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757820095 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757820065, ACTIVE 83 sec, process no 2289, OS thread id 1278265696 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 6752, undo log entries 45
MySQL thread id 1071957, query id 10176885804 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:54:29','cntaobaolele8829','-1012372361','6.16.04','0')
------- TRX HAS BEEN WAITING 1 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757820065 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757816626, ACTIVE 109 sec, process no 2289, OS thread id 1288116576 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 6752, undo log entries 60
MySQL thread id 1074030, query id 10176885945 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:49:53','cntaobaoy00050488','244902109','6.16.05','0')
------- TRX HAS BEEN WAITING 1 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757816626 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757814414, ACTIVE 128 sec, process no 2289, OS thread id 1199724896 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 6752, undo log entries 70
MySQL thread id 1071972, query id 10176885629 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:54:23','cntaobaohdjd1','0','','1')
------- TRX HAS BEEN WAITING 1 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757814414 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757811914, ACTIVE 149 sec, process no 2289, OS thread id 1218627936 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 14320, undo log entries 90
MySQL thread id 1074363, query id 10176884564 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:46:12','cntaobaokaxi88','0','','1')
------- TRX HAS BEEN WAITING 2 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757811914 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757811913, ACTIVE 149 sec, process no 2289, OS thread id 1262557536 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 14320, undo log entries 90
MySQL thread id 1074293, query id 10176884186 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:43:06','cntaobaorobert588','-192688263','6.10.30','0')
------- TRX HAS BEEN WAITING 2 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757811913 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757811912, ACTIVE 149 sec, process no 2289, OS thread id 1286785376 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 14320, undo log entries 90
MySQL thread id 1074282, query id 10176883850 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:46:18','cntaobaoswpccy','-1763694467','6.16.04','0')
------- TRX HAS BEEN WAITING 2 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757811912 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757811896, ACTIVE 149 sec, process no 2289, OS thread id 1262291296 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 14320, undo log entries 91
MySQL thread id 1074288, query id 10176887281 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:45:45','cntaobaoeyesneverdie','0','','1')
------- TRX HAS BEEN WAITING 1 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757811896 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757811893, ACTIVE 149 sec, process no 2289, OS thread id 1220757856 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 14320, undo log entries 91
MySQL thread id 1074284, query id 10176887222 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:51:22','cntaobaoyiwunews','-1968783812','6.16.04','0')
------- TRX HAS BEEN WAITING 1 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757811893 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757811892, ACTIVE 149 sec, process no 2289, OS thread id 1241258336 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 14320, undo log entries 91
MySQL thread id 1074362, query id 10176887191 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:53:24','cntaobao??????','0','','1')
------- TRX HAS BEEN WAITING 1 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757811892 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757811891, ACTIVE 149 sec, process no 2289, OS thread id 1190672736 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 14320, undo log entries 91
MySQL thread id 1074276, query id 10176887266 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:47:32','cntaobaojxhzzcat','0','','1')
------- TRX HAS BEEN WAITING 1 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757811891 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757811887, ACTIVE 149 sec, process no 2289, OS thread id 1168042336 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 14320, undo log entries 91
MySQL thread id 1074285, query id 10176886054 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:42:32','cntaobaoyanfu2004','575292797','6.16.04','0')
------- TRX HAS BEEN WAITING 1 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757811887 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757811883, ACTIVE 149 sec, process no 2289, OS thread id 1291577696 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 14320, undo log entries 91
MySQL thread id 1074278, query id 10176885545 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:51:01','cntaobao??????15','0','','1')
------- TRX HAS BEEN WAITING 1 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757811883 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757811876, ACTIVE 149 sec, process no 2289, OS thread id 1239927136 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 14320, undo log entries 91
MySQL thread id 1071967, query id 10176884708 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:47:45','cntaobaocggyfjtg','382157790','6.10.11','0')
------- TRX HAS BEEN WAITING 2 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757811876 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757811821, ACTIVE 149 sec, process no 2289, OS thread id 1291843936 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 14320, undo log entries 92
MySQL thread id 1074286, query id 10176888660 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:43:59','cntaobao????????','-2076636195','6.16.04','0')
------- TRX HAS BEEN WAITING 0 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757811821 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757811801, ACTIVE 150 sec, process no 2289, OS thread id 1169107296 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 14320, undo log entries 92
MySQL thread id 1074274, query id 10176887057 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:51:43','cntaobao??????','0','','1')
------- TRX HAS BEEN WAITING 1 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757811801 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757811796, ACTIVE 150 sec, process no 2289, OS thread id 1253771616 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 14320, undo log entries 92
MySQL thread id 1074283, query id 10176886975 172.18.

曾经的阿飞
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 1
    评论
专栏目录
Deadlock found when trying to get lock（死锁）问题解决
山间明月江上清风的专栏
09-25 5万+
今天压测用户中心的登录接口。发现这个接口在并发下几乎不可用，错误率70%。 查看后台日志全是： 登录接口出现死锁了。 看了下代码，登录中做了更新用户登录时间，插入用户log。查询数据库，发行用户更新和插入log都会lock wait 判断可能是在压测同一个用户登录时，某个请求中的事务读取到了另一个请求里事务未提交的数据。从而需要等待之前的事务提交。（幻读） 然后将事务隔离机制改成...
OS-Job-Scheduling-and-Deadlock-Experiments:所有操作系统实验
05-02
总的来说，"OS-Job-Scheduling-and-Deadlock-Experiments"这个实验旨在通过实际操作加深对操作系统核心概念的理解。通过使用Jupyter Notebook和Python，你可以动态地探索不同的调度策略和死锁解决方案，这不仅能够...
Waiting Auto-INC LOCK导致死锁【转】
weixin_34358365的博客
01-14 402
转自:http://hidba.org/?p=593 今天下午在看死锁相关的文档，到线上查看一生产数据库的时候，正好发现了show engine innodb status有一个死锁的信息： LATEST DETECTED DEADLOCK ------------------------ 120626 20:00:30 *** (1) TRANSACTION: TRANSAC...
mysql中的锁
最新发布
qq_59395271的博客
05-19 442
有的，如果数据库的引擎支持的事务支持可重复读的隔离级别，那么在备份数据库之前先开启事务，会先创建 Read View，然后整个事务执行期间都在用这个 Read View，而且由于 MVCC 的支持，备份期间业务依然可以对数据进行更新操作。当一个事务对一条记录加了X型记录锁后，其他事务即不可以对该记录加s型锁记录（s型与x锁不兼容），也不可以对该记录加x型记录锁（x型与x锁不兼容）当一个事务对一条记录加了S型记录锁后，其他事务也可以继续对该记录加S型锁记录（s型和s锁兼容）,但是不可以对该记录加x型记录锁。
AUTO-INC锁和AUTO_INCREMENT在InnoDB中处理方式
FaN()
12-22 8559
AUTO-INC Locks An AUTO-INC lock is a special table-level lock taken by transactions inserting into tables with AUTO_INCREMENT columns. In the simplest case, if one transaction is inserting values i
MySQL InnoDB中的锁-自增锁（AUTO-INC Locks）
fofcn的专栏
03-02 2108
MySQL InnoDB 锁 自增锁AUTO-INC Locks
philosophers-problem-deadlock
03-18
哲学家问题陷入僵局五位哲学家想在一张圆桌旁吃饭。在每一个旁边有两个斗杆，与下一个晚餐者共享-餐桌上的客人。演示：Philo1 <-> stick1 <-> Philo2 <-> stick2 <-> Philo3 ......但是，如果他拿起stick1...
go-deadlock:go (golang) 中的在线死锁检测
08-04
go (golang) 中的在线死锁检测。为什么死锁发生并且调试起来很痛苦。什么go-deadlock 为 sync.... Lock ()defer mu . Unlock ()// Orvar rw deadlock. RWMutexrw . RLock ()defer rw . RUnlock ()死锁最常见的死锁来源
some-hints-on-how-to-encure-deadlock-in-SOA-and-Cloud-Computing
03-15
阵列服务器集群中的死锁问题比较讨厌；而其与性能之间的PK是个人类无奈的话题。需找一些相应的适中机制比较好玩。
mysql报错：Deadlock found when trying to get lock; try restarting transaction的解决方法
09-09
在描述的场景中，程序在尝试更新数据时遇到了"Deadlock found when trying to get lock; try restarting transaction"的错误，这表明存在一个死锁情况。在InnoDB存储引擎中，这种错误会导致其中一个事务被回滚，以便...
浅谈innodb_autoinc_lock_mode的表现形式和选值参考方法
12-16
前提条件，percona 5.6版本，事务隔离级别为RR mysql> show create table test_autoinc_lock\G *************************** 1. row *************************** Table: test_autoinc_lock Create Table: CREATE TABLE `test_autoinc_lock` ( `id` int(11) NOT NULL AUTO_INCREMENT, `a` int(11) DEFAULT NULL, PRIMARY KEY (`id`
Waiting Auto-INC LOCK导致死锁
weixin_34080903的博客
03-25 225
今天下午在看死锁相关的文档，到线上查看一生产数据库的时候，正好发现了show engine innodb status有一个死锁的信息： LATEST DETECTED DEADLOCK ------------------------ 120626 20:00:30 *** (1) TRANSACTION: TRANSACTION 3 3052385...
AUTO-INC锁与innodb_autoinc_lock_mode
李兆龙的博客
03-13 909
文章目录引言insert 类型innodb_autoinc_lock_mode测试AUTO-INC锁总结 引言 AUTO-INC锁其实是innodb对于auto_increment的一种处理方法,它是在对有auto_increment关键字的索引进行插入的时候获取的一种特殊的表级锁.为什么需要AUTO-INC锁呢?原因是为了当数据插入到具有AUTO_INCREMENT列的表中时,给定序列的插入 s...
【 58沈剑 架构师之路】InnoDB七种锁——自增锁（Auto-inc Locks）
weixin_33897722的博客
12-07 360
2019独角兽企业重金招聘Python工程师标准>>> ...
mysql innodbautoinclockmode_innodb_autoinc_lock_mode的表现形式和选值参考
weixin_32694271的博客
02-07 209
前提条件，percona 5.6版本，事务隔离级别为RR mysql> show create table test_autoinc_lock\G*************************** 1. row ***************************Table: test_autoinc_lockCreate Table: CREATE TABLE `test_autoi...
MySql InnoDB引擎下的锁
weixin_45714229的博客
04-06 1308
在innodb中，锁的种类如下： Shared and Exclusive Locks（共享锁和排他锁） Intention Locks（意向锁） Record Locks（记录锁） Gap Locks（间隙锁） Next-key Locks（Gap Lock + Record Lock） Insert Intention Locks（插入意向锁） AUTO-INC Locks（自增锁） Predicate Locks for Spatial Indexes
mysql innodb 死锁_mysql innodb 死锁
weixin_29461699的博客
01-19 107
innodb大量AUTO-INCLOCK导致的DeadLOCK1.现象今天发现数据库报检查到死锁，show innodb status \G但从STATUS看，都是lock mode AUTO-INC waiting.而且从应用开发了解，都是简单的INSERT和select。没有交叉更新的事务。如果是等待AUTO-INC锁，也不应该会产生死锁。因为AUTO-INC锁在某一时刻只会被一个事务/INS...
MySQL自增字段并发插入导致死锁
gb4215287的博客
09-27 1431
MySQL带自增字段的表在并发插入时发生死锁 问题 'int' object has no attribute 'encode'", <class 'mysql.connector.errors.InternalError'>, (1213, '1213 (40001): Deadlock found when trying to get lock; try restarting transaction', u'40001')) 1 tbl_a有一个自增字段id（PRI，auto_in
1213 - Deadlock found when trying to get lock; try restarting transaction
10-18
这个错误通常是由于数据库中的事务互相等待而导致的。当一个事务持有一个锁并等待另一个事务持有的锁时，就会发生死锁。为了解决这个问题，可以尝试以下几种方法： 1. 重启事务：这是最简单的方法，但可能会导致数据丢失或不一致。 2. 优化查询：如果查询语句不够优化，可能会导致锁定表格的时间过长，从而导致死锁。可以通过优化查询语句来减少锁定表格的时间。 3. 减少事务的持续时间：如果事务持续时间过长，可能会导致死锁。可以尝试将事务拆分成更小的部分，以减少事务持续时间。 4. 使用合适的隔离级别：如果使用的隔离级别不合适，可能会导致死锁。可以尝试使用更低的隔离级别，如 READ COMMITTED。
评论 1
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值