LATESTDETECTEDDEADLOCK
------------------------
2017-11-2711:26:222b80ab881700
***(1)TRANSACTION:
TRANSACTION84983140,ACTIVE3.138secinserting
mysqltablesinuse1,locked1
LOCKWAIT13lockstruct(s),heapsize2936,9rowlock(s),undologentries102
LOCKBLOCKINGMySQLthreadid:4188408block4188409
MySQLthreadid4188409,OSthreadhandle0x2b80c834c700,queryid1119236930119.23.142.11
all5update
INSERTINTOt_flow_real_time(`spot`,`group_quantity`,`booking`,`statistics_time`)
values(1,1,'2017-11-24','2017-11-2711:26:21.007')
ONDUPLICATEKEYUPDATE
`group_quantity`=group_quantity+1
***(1)WAITINGFORTHISLOCKTOBEGRANTED:
RECORDLOCKSspaceid1258pageno4nbits104index`idx_unique`oftable`a_analysis`.`t_flow_real_time`trxid84983140lock_modeXwaiting
Recordlock,heapno33PHYSICALRECORD:n_fields3;compactformat;infobits0
0:len4;hex80000001;asc;;
1:len3;hex8fc378;ascx;;
2:len4;hex8000984d;ascM;;
***(2)TRANSACTION:
TRANSACTION84983143,ACTIVE1.554secinserting
mysqltablesinuse1,locked1
13lockstruct(s),heapsize2936,9rowlock(s),undologentries46
MySQLthreadid4188408,OSthreadhandle0x2b80ab881700,queryid1119237503119.23.142.11
all580update
INSERTINTOt_flow_real_time(`spot`,`group_quantity`,`booking`,`statistics_time`)
values(1,1,'2017-11-26','2017-11-2711:26:22.407')
ONDUPLICATEKEYUPDATE
`group_quantity`=group_quantity+1
***(2)HOLDSTHELOCK(S):
RECORDLOCKSspaceid1258pageno4nbits104index`idx_unique`oftable`a_analysis`.`t_flow_real_time`trxid84983143lock_modeX
Recordlock,heapno33PHYSICALRECORD:n_fields3;compactformat;infobits0
0:len4;hex80000001;asc;;
1:len3;hex8fc378;ascx;;
2:len4;hex8000984d;ascM;;
***(2)WAITINGFORTHISLOCKTOBEGRANTED:
RECORDLOCKSspaceid1258pageno4nbits104index`idx_unique`oftable`a_analysis`.`t_flow_real_time`trxid84983143lock_modeXwaiting
Recordlock,heapno34PHYSICALRECORD:n_fields3;compactformat;infobits0
0:len4;hex80000001;asc;;
1:len3;hex8fc37a;ascz;;
2:len4;hex8000987b;asc{;;
***WEROLLBACKTRANSACTION(2)
分 -->
|