mysql
以下是用show innodb status 查看的死锁信息，都是通过主键索引userid去更新记录，没有其他索引的影响，不应该会产生死锁啊，请大神帮忙分析下原因。
表索引如下
(....
primary key (userid),
unique key userid_unique (userid),
unique key username_unique using btree (username)
) engine=innodb auto_increment=1 default charset=utf8;latest detected deadlock140626 11:12:09
*** (1) transaction:
transaction 0 168550, active 13 sec, process no 21006, os thread id 139721036994304 starting index read
mysql tables in use 1, locked 1
lock wait 6 lock struct(s), heap size 1216, 2 row lock(s), undo log entries 2
mysql thread id 168698, query id 1710850 localhost 127.0.0.1 root updating
update users set imei='a00000455a4cfe',last_address='上海市闸北区秣陵路303号',lat=31.254289,lon=121.46208,last_login='2014-06-26 11:11:56',userstatus=11,deviceid='2b54f8edd4a2dc4150bc5d8a4e0fb340',platform='android',updated='2014-06-26 11:11:56' where userid=15
*** (1) waiting for this lock to be granted:
record locks space id 0 page no 382 n bits 120 index primary of table microbiz_new.users trx id 0 168550 lock_mode x locks rec but not gap waiting
record lock, heap no 51 physical record: n_fields 35; compact format; info bits 0
0: len 4; hex 8000000f; asc ;; 1: len 6; hex 000000029264; asc d;; 2: len 7; hex 000000002d2a40; asc -*@;; 3: len 10; hex 7a686f757a696a69616e; asc zhouzijian;; 4: len 9; hex e591a8e5ad90e5bbba; asc ;; 5: sql null; 6: sql null; 7: len 30; hex 653130616463333934396261353961626265353665303537663230663838; asc e10adc3949ba59abbe56e057f20f88;...(truncated); 8: len 4; hex 80000004; asc ;; 9: len 11; hex 3138363538313533393030; asc 18658153900;; 10: len 14; hex 4130303030303435354134434645; asc a00000455a4cfe;; 11: sql null; 12: len 19; hex 7a7a686f7540706c696e6b636861742e636f6d; asc zzhou@plinkchat.com;; 13: len 12; hex e4b88ae6b5b7e5bca0e6b19f; asc ;; 14: len 30; hex 687474703a2f2f3131352e32382e3136302e37313a383038302f6d696372; asc http://115.28.160.71:8080/micr;...(truncated); 15: sql null; 16: sql null; 17: sql null; 18: sql null; 19: sql null; 20: sql null; 21: sql null; 22: len 1; hex 5a; asc z;; 23: len 30; hex e4b88ae6b5b7e5b882e997b8e58c97e58cbae7a7a3e999b5e8b7af333033; asc 303;...(truncated); 24: len 8; hex 88bb7a1519413f40; asc z a?@;; 25: len 8; hex af08feb7925d5e40; asc ]^@;; 26: len 8; hex 800012515ab079e1; asc qz y ;; 27: len 8; hex 800012515add6aa0; asc qz j ;; 28: len 8; hex 800012515add6aa0; asc qz j ;; 29: len 4; hex 80000001; asc ;; 30: len 4; hex 8000000b; asc ;; 31: len 4; hex 80000001; asc ;; 32: len 4; hex 80000003; asc ;; 33: len 30; hex 324235344638454444344132444334313530424335443841344530464233; asc 2b54f8edd4a2dc4150bc5d8a4e0fb3;...(truncated); 34: len 7; hex 616e64726f6964; asc android;;
*** (2) transaction:
transaction 0 168551, active 1 sec, process no 21006, os thread id 139720929810176 starting index read, thread declared inside innodb 500
mysql tables in use 1, locked 1
6 lock struct(s), heap size 1216, 2 row lock(s), undo log entries 2
mysql thread id 168699, query id 1710851 localhost 127.0.0.1 root updating
update users set imei='a00000455a4cfe',last_address='上海市闸北区秣陵路303号',lat=31.254289,lon=121.46208,last_login='2014-06-26 11:12:08',userstatus=11,deviceid='2b54f8edd4a2dc4150bc5d8a4e0fb340',platform='android',updated='2014-06-26 11:12:08' where userid=15
*** (2) holds the lock(s):
record locks space id 0 page no 382 n bits 120 index primary of table microbiz_new.users trx id 0 168551 lock mode s locks rec but not gap
record lock, heap no 51 physical record: n_fields 35; compact format; info bits 0
0: len 4; hex 8000000f; asc ;; 1: len 6; hex 000000029264; asc d;; 2: len 7; hex 000000002d2a40; asc -*@;; 3: len 10; hex 7a686f757a696a69616e; asc zhouzijian;; 4: len 9; hex e591a8e5ad90e5bbba; asc ;; 5: sql null; 6: sql null; 7: len 30; hex 653130616463333934396261353961626265353665303537663230663838; asc e10adc3949ba59abbe56e057f20f88;...(truncated); 8: len 4; hex 80000004; asc ;; 9: len 11; hex 3138363538313533393030; asc 18658153900;; 10: len 14; hex 4130303030303435354134434645; asc a00000455a4cfe;; 11: sql null; 12: len 19; hex 7a7a686f7540706c696e6b636861742e636f6d; asc zzhou@plinkchat.com;; 13: len 12; hex e4b88ae6b5b7e5bca0e6b19f; asc ;; 14: len 30; hex 687474703a2f2f3131352e32382e3136302e37313a383038302f6d696372; asc http://115.28.160.71:8080/micr;...(truncated); 15: sql null; 16: sql null; 17: sql null; 18: sql null; 19: sql null; 20: sql null; 21: sql null; 22: len 1; hex 5a; asc z;; 23: len 30; hex e4b88ae6b5b7e5b882e997b8e58c97e58cbae7a7a3e999b5e8b7af333033; asc 303;...(truncated); 24: len 8; hex 88bb7a1519413f40; asc z a?@;; 25: len 8; hex af08feb7925d5e40; asc ]^@;; 26: len 8; hex 800012515ab079e1; asc qz y ;; 27: len 8; hex 800012515add6aa0; asc qz j ;; 28: len 8; hex 800012515add6aa0; asc qz j ;; 29: len 4; hex 80000001; asc ;; 30: len 4; hex 8000000b; asc ;; 31: len 4; hex 80000001; asc ;; 32: len 4; hex 80000003; asc ;; 33: len 30; hex 324235344638454444344132444334313530424335443841344530464233; asc 2b54f8edd4a2dc4150bc5d8a4e0fb3;...(truncated); 34: len 7; hex 616e64726f6964; asc android;;
*** (2) waiting for this lock to be granted:
record locks space id 0 page no 382 n bits 120 index primary of table microbiz_new.users trx id 0 168551 lock_mode x locks rec but not gap waiting
record lock, heap no 51 physical record: n_fields 35; compact format; info bits 0
0: len 4; hex 8000000f; asc ;; 1: len 6; hex 000000029264; asc d;; 2: len 7; hex 000000002d2a40; asc -*@;; 3: len 10; hex 7a686f757a696a69616e; asc zhouzijian;; 4: len 9; hex e591a8e5ad90e5bbba; asc ;; 5: sql null; 6: sql null; 7: len 30; hex 653130616463333934396261353961626265353665303537663230663838; asc e10adc3949ba59abbe56e057f20f88;...(truncated); 8: len 4; hex 80000004; asc ;; 9: len 11; hex 3138363538313533393030; asc 18658153900;; 10: len 14; hex 4130303030303435354134434645; asc a00000455a4cfe;; 11: sql null; 12: len 19; hex 7a7a686f7540706c696e6b636861742e636f6d; asc zzhou@plinkchat.com;; 13: len 12; hex e4b88ae6b5b7e5bca0e6b19f; asc ;; 14: len 30; hex 687474703a2f2f3131352e32382e3136302e37313a383038302f6d696372; asc http://115.28.160.71:8080/micr;...(truncated); 15: sql null; 16: sql null; 17: sql null; 18: sql null; 19: sql null; 20: sql null; 21: sql null; 22: len 1; hex 5a; asc z;; 23: len 30; hex e4b88ae6b5b7e5b882e997b8e58c97e58cbae7a7a3e999b5e8b7af333033; asc 303;...(truncated); 24: len 8; hex 88bb7a1519413f40; asc z a?@;; 25: len 8; hex af08feb7925d5e40; asc ]^@;; 26: len 8; hex 800012515ab079e1; asc qz y ;; 27: len 8; hex 800012515add6aa0; asc qz j ;; 28: len 8; hex 800012515add6aa0; asc qz j ;; 29: len 4; hex 80000001; asc ;; 30: len 4; hex 8000000b; asc ;; 31: len 4; hex 80000001; asc ;; 32: len 4; hex 80000003; asc ;; 33: len 30; hex 324235344638454444344132444334313530424335443841344530464233; asc 2b54f8edd4a2dc4150bc5d8a4e0fb3;...(truncated); 34: len 7; hex 616e64726f6964; asc android;;
*** we roll back transaction (2)