一次MYSQL死锁

UPDATE shop_info SET service_provider_id ='12', service_provider_name = '12', WHERE route_no ='12' and channel_id = 1001

UPDATE shop_bill SET service_provider_id ='12', service_provider_name = '12', WHERE route_no ='12' and channel_id = 1001

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

LATEST DETECTED DEADLOCK

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

2020-01-17 23:17:04 0x7ef7fafe1700

*** (1) TRANSACTION:

TRANSACTION 13106137432, ACTIVE 0 sec starting index read

mysql tables in use 1, locked 1

LOCK WAIT 5 lock struct(s), heap size 1136, 3 row lock(s), undo log entries 1

MySQL thread id 11333715, OS thread handle 139603339040512, query id 10202316979 10.32.103.57 cctv_8fd8 updating

/*id:8c197bed*/UPDATE shop_bill SET service_provider_id = 1073, service_provider_name = '', last_modify_by = '', last_modify_time = '2020-01-17 23:10:13' WHERE (route_no = 'PX202001171040029') AND (channel_id = 1001)

*** (1) WAITING FOR THIS LOCK TO BE GRANTED:

RECORD LOCKS space id 7888 page no 43896 n bits 472 index index_route_no of table `cctv`.`shop_bill` trx id 13106137432 lock_mode X waiting

==========================================================================================================================================================

*** (2) TRANSACTION:

TRANSACTION 13106137419, ACTIVE 0 sec starting index read

mysql tables in use 1, locked 1

10 lock struct(s), heap size 1136, 4 row lock(s), undo log entries 62

MySQL thread id 11333748, OS thread handle 139603532977920, query id 10202316999 10.32.104.101 cctv_8fd8 updating

/*id:ebb95443*/UPDATE shop_info SET last_modify_time = '2020-01-17 23:17:04.959', last_modify_by = '', is_pick = 1 WHERE ((istatus = 1 AND route_no IN ('PX202001171040029'))) AND (channel_id = 1001)

*** (2) HOLDS THE LOCK(S):

RECORD LOCKS space id 7888 page no 43896 n bits 472 index index_route_no of table `cctv`.`shop_bill` trx id 13106137419 lock_mode X locks rec but not gap

*** (2) WAITING FOR THIS LOCK TO BE GRANTED:

RECORD LOCKS space id 8033 page no 61151 n bits 592 index unique_routeNo of table `cctv`.`shop_info` trx id 13106137419 lock_mode X locks rec but not gap waiting

*** WE ROLL BACK TRANSACTION (1)