LATEST DETECTED DEADLOCK

2021-04-07 11:24:14 0x7fafe7e72700----------------------------死锁发生时间
*** (1) TRANSACTION:
TRANSACTION 30447466639, ACTIVE 0 sec fetching rows
mysql tables in use 3, locked 3
LOCK WAIT 293 lock struct(s), heap size 41168, 4 row lock(s)
MySQL thread id 2537849, OS thread handle 140393384199936, query id 687284947 10.192.6.106 hkop_huida Searching rows for update
UPDATE p_renewal_policy SET order_no=‘1586162863306741391’,
policy_no=‘86000020201200099922’,
period_num=202104,
period_order_no=‘1586162863306741391_202104’,
channel_code=‘jd’,
due_pay_premium=32521,

due_pay_time=‘2021-04-07 00:00:00.0’,

end_of_grace_time=‘2021-06-06 00:00:00.0’,
renewal_status=‘1’,
status=‘0’,
unlock_status=null,
charge_mode=‘1’,
create_time=‘2021-04-04 12:26:08.0’,
update_time=‘2021-04-07 11:24:14.824’,
lock_status=‘0’,
lock_time=‘2021-04-07 11:24:14.0’

WHERE (channel_code = ‘jd’ AND period_num = 202104 AND policy_no = ‘86000020201200099922’)-------------死锁第一个事务

*** (1) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 1318 page no 11882 n bits 176 index PRIMARY of table huida_platform.p_renewal_policy trx id 30447466639 lock_mode X locks rec but not gap waiting
Record lock, heap no 60 PHYSICAL RECORD: n_fields 23; compact format; info bits 0---------------------------事务1等待p_renewal_policy主键上的X（排他）锁
0: len 8; hex 00000000000789f2; asc ;;
1: len 6; hex 000715d26af0; asc j ;;
2: len 7; hex 820000400d0110; asc @ ;;
3: len 19; hex 31353836313734303136383133323430373332; asc 1586174016813240732;;
4: len 20; hex 3836303030303230323031323030303939393436; asc 86000020201200099946;;
5: len 4; hex 00031578; asc x;;
6: len 26; hex 313538363137343031363831333234303733325f323032313034; asc 1586174016813240732_202104;;
7: len 2; hex 6a64; asc jd;;
8: len 11; hex 800000000000000001488c; asc H ;;
9: SQL NULL;
10: len 5; hex 99a94e0000; asc N ;;
11: SQL NULL;
12: len 5; hex 99a9cc0000; asc ;;
13: len 2; hex 3120; asc 1 ;;
14: len 2; hex 3020; asc 0 ;;
15: SQL NULL;
16: len 2; hex 3120; asc 1 ;;
17: len 5; hex 99a948c686; asc H ;;
18: len 5; hex 99a948c686; asc H ;;
19: len 1; hex 80; asc ;;
20: SQL NULL;
21: SQL NULL;
22: SQL NULL;

*** (2) TRANSACTION:
TRANSACTION 30447466644, ACTIVE 0 sec fetching rows
mysql tables in use 3, locked 3
293 lock struct(s), heap size 41168, 3 row lock(s)
MySQL thread id 2548397, OS thread handle 140393486690048, query id 687284949 10.192.6.58 hkop_huida Searching rows for update
UPDATE p_renewal_policy SET order_no=‘1586174016813240732’,
policy_no=‘86000020201200099946’,
period_num=202104,
period_order_no=‘1586174016813240732_202104’,
channel_code=‘jd’,
due_pay_premium=84108,

due_pay_time=‘2021-04-07 00:00:00.0’,

end_of_grace_time=‘2021-06-06 00:00:00.0’,
renewal_status=‘1’,
status=‘0’,
unlock_status=null,
charge_mode=‘1’,
create_time=‘2021-04-04 12:26:06.0’,
update_time=‘2021-04-07 11:24:14.827’,
lock_status=‘0’,
lock_time=‘2021-04-07 11:24:14.0’

WHERE (channel_code = ‘jd’ AND period_num = 202104 AND policy_no = ‘86000020201200099946’)
*** (2) HOLDS THE LOCK(S):
RECORD LOCKS space id 1318 page no 11882 n bits 176 index PRIMARY of table huida_platform.p_renewal_policy trx id 30447466644 lock_mode X locks rec but not gap
Record lock, heap no 60 PHYSICAL RECORD: n_fields 23; compact format; info bits 0--------------------事务2获得p_renewal_policy主键的X锁
0: len 8; hex 00000000000789f2; asc ;;
1: len 6; hex 000715d26af0; asc j ;;
2: len 7; hex 820000400d0110; asc @ ;;
3: len 19; hex 31353836313734303136383133323430373332; asc 1586174016813240732;;
4: len 20; hex 3836303030303230323031323030303939393436; asc 86000020201200099946;;
5: len 4; hex 00031578; asc x;;
6: len 26; hex 313538363137343031363831333234303733325f323032313034; asc 1586174016813240732_202104;;
7: len 2; hex 6a64; asc jd;;
8: len 11; hex 800000000000000001488c; asc H ;;
9: SQL NULL;
10: len 5; hex 99a94e0000; asc N ;;
11: SQL NULL;
12: len 5; hex 99a9cc0000; asc ;;
13: len 2; hex 3120; asc 1 ;;
14: len 2; hex 3020; asc 0 ;;
15: SQL NULL;
16: len 2; hex 3120; asc 1 ;;
17: len 5; hex 99a948c686; asc H ;;
18: len 5; hex 99a948c686; asc H ;;
19: len 1; hex 80; asc ;;
20: SQL NULL;
21: SQL NULL;
22: SQL NULL;

*** (2) WAITING FOR THIS LOCK TO BE GRANTED: period_num
RECORD LOCKS space id 1318 page no 8575 n bits 1000 index uk_renewal_policy_02 of table huida_platform.p_renewal_policy trx id 30447466644 lock_mode X locks rec but not gap waiting
Record lock, heap no 209 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
0: len 4; hex 00031578; asc x;;
1: len 8; hex 00000000000789f2; asc ;;