MySql deadlock

执行SHOW ENGINE INNODB STATUS

遍历 LATEST DETECTED DEADLOCK

------------------------
2017-09-02 12:16:36 7f425dd25700
*** (1) TRANSACTION:
TRANSACTION 464821461, ACTIVE 0 sec starting index read
mysql tables in use 6, locked 6
LOCK WAIT 5 lock struct(s), heap size 1184, 3 row lock(s), undo log entries 2
MySQL thread id 55261, OS thread handle 0x7f442714a700, query id 2500508350 192.168.13.109 root updating
UPDATE dh_busoperatrecordt set mileage = @dbmileage, gpsmileage = @dbgpsmileage, tripno = @dbcount, runtimegroup = @runtimegroup, stationdateb =  NAME_CONST('dbBeginDate',NULL), stationdatee =  NAME_CONST('dbEndDate',NULL), enables =  NAME_CONST('dbenable',-1) where if( NAME_CONST('sdriverid',_utf8'170520105807572' COLLATE 'utf8_general_ci') IS NULL, DriverId is null, DriverId =  NAME_CONST('sdriverid',_utf8'170520105807572' COLLATE 'utf8_general_ci')) and if( NAME_CONST('sbustid',_utf8'40288dee5b476aa5015b5c8b57e004e1' COLLATE 'utf8_general_ci') IS NULL, BusTID is null, BusTID =  NAME_CONST('sbustid',_utf8'40288dee5b476aa5015b5c8b57e004e1' COLLATE 'utf8_general_ci')) and if( NAME_CONST('sroadid',_utf8'40288dee5b476aa5015b55a778ed016c' COLLATE 'utf8_general_ci') IS NULL, roadid is null, roadid =  NAME_CONST('sroadid',_utf8'40288dee5b476aa5015b55a778ed016c' COLLATE 'utf8_general_ci')) and DATE_FORMAT(runda
*** (1) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 246 page no 8 n bits 128 index `PRIMARY` of table `td_busonlinedisp845`.`dh_busoperatrecordt` trx id 464821461 lock_mode X waiting
*** (2) TRANSACTION:
TRANSACTION 464821495, ACTIVE 0 sec fetching rows
mysql tables in use 6, locked 6
2927 lock struct(s), heap size 276008, 161124 row lock(s), undo log entries 2
MySQL thread id 55250, OS thread handle 0x7f425dd25700, query id 2500508320 192.168.13.109 root updating
UPDATE dh_busoperatrecordt set mileage = @dbmileage, gpsmileage = @dbgpsmileage, tripno = @dbcount, runtimegroup = @runtimegroup, stationdateb =  NAME_CONST('dbBeginDate',_latin1'2017-09-02 10:11:55' COLLATE 'latin1_swedish_ci'), stationdatee =  NAME_CONST('dbEndDate',_latin1'2017-09-02 11:05:00' COLLATE 'latin1_swedish_ci'), enables =  NAME_CONST('dbenable',0) where if( NAME_CONST('sdriverid',_utf8'170522223610640' COLLATE 'utf8_general_ci') IS NULL, DriverId is null, DriverId =  NAME_CONST('sdriverid',_utf8'170522223610640' COLLATE 'utf8_general_ci')) and if( NAME_CONST('sbustid',_utf8'170828120259275' COLLATE 'utf8_general_ci') IS NULL, BusTID is null, BusTID =  NAME_CONST('sbustid',_utf8'170828120259275' COLLATE 'utf8_general_ci')) and if( NAME_CONST('sroadid',_utf8'40288dee5b476aa5015b55abcf24018c' COLLATE 'utf8_general_ci') IS NULL, roadid is null, roadid =  NAME_CONST('sroadid',_utf8'40288dee5b476a
*** (2) HOLDS THE LOCK(S):
RECORD LOCKS space id 246 page no 8 n bits 128 index `PRIMARY` of table `td_busonlinedisp845`.`dh_busoperatrecordt` trx id 464821495 lock_mode X
*** (2) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 246 page no 5510 n bits 80 index `PRIMARY` of table `td_busonlinedisp845`.`dh_busoperatrecordt` trx id 464821495 lock_mode X waiting
*** WE ROLL BACK TRANSACTION (1)