errorlog: 2023-02-16T19:50:39.792317+08:00 353 [Warning] [MY-010584] [Repl] Slave SQL for channel 'group_replication_applier': Worker 5 failed executing transaction 'e8f1472a-3a6c-11ed-85f1-5254004717be:525515356'; Could not execute Update_rows event on table smartxma_report.stat_call_task_robot_day; Deadlock found when trying to get lock; try restarting transaction, Error_code: 1213; handler error HA_ERR_LOCK_DEADLOCK, Error_code: MY-001213 index: +--------------------------+------------+-----------------------+--------------+----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+---------+------------+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment | Visible | Expression | +--------------------------+------------+-----------------------+--------------+----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+---------+------------+ | stat_call_task_robot_day | 0 | PRIMARY | 1 | id | A | 119262 | NULL | NULL | | BTREE | | | YES | NULL | | stat_call_task_robot_day | 0 | udx1 | 1 | robot_id | A | 116239 | NULL | NULL | YES | BTREE | | | YES | NULL | | stat_call_task_robot_day | 0 | udx1 | 2 | time_dimension | A | 115570 | NULL | NULL | | BTREE | | | YES | NULL | | stat_call_task_robot_day | 0 | udx1 | 3 | task_id | A | 119919 | NULL | NULL | | BTREE | | | YES | NULL | | stat_call_task_robot_day | 0 | udx1 | 4 | tenant_id | A | 119919 | NULL | NULL | | BTREE | | | YES | NULL | | stat_call_task_robot_day | 1 | idx_time_tenant_robot | 1 | time_dimension | A | 51 | NULL | NULL | | BTREE | | | YES | NULL | | stat_call_task_robot_day | 1 | idx_time_tenant_robot | 2 | tenant_id | A | 51 | NULL | NULL | | BTREE | | | YES | NULL | | stat_call_task_robot_day | 1 | idx_time_tenant_robot | 3 | robot_id | A | 117198 | NULL | NULL | YES | BTREE | | | YES | NULL | +--------------------------+------------+-----------------------+--------------+----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+---------+------------+ engine status; ------------------------ LATEST DETECTED DEADLOCK ------------------------ 2023-02-16 19:50:39 139949563180800 *** (1) TRANSACTION: TRANSACTION 1106522308, ACTIVE 0 sec updating or deleting mysql tables in use 1, locked 1 LOCK WAIT 37 lock struct(s), heap size 8312, 115 row lock(s), undo log entries 46 MySQL thread id 363, OS thread handle 139964751423232, query id 386064383 Applying batch of row changes (update) *** (1) HOLDS THE LOCK(S): RECORD LOCKS space id 1312 page no 2081 n bits 256 index udx1 of table `smartxma_report`.`stat_call_task_robot_day` trx id 1106522308 lock mode S locks gap before rec Record lock, heap no 11 PHYSICAL RECORD: n_fields 5; compact format; info bits 0 0: len 25; hex 32303233303231363136333233333530303131353030343132; asc 2023021616323350011500412;; 1: len 8; hex 800000000134b048; asc 4 H;; 2: len 8; hex 8000000029b94271; asc ) Bq;; 3: len 30; hex 73756e696e6762616e6b3136363339383933373434333736633566383263; asc suningbank16639893744376c5f82c; (total 31 bytes); 4: len 8; hex 800000002c034621; asc , F!;; Record lock, heap no 52 PHYSICAL RECORD: n_fields 5; compact format; info bits 32 0: len 25; hex 32303233303231363136333031333333363131353030333430; asc 2023021616301333611500340;; 1: len 8; hex 800000000134b048; asc 4 H;; 2: len 8; hex 8000000029b94271; asc ) Bq;; 3: len 30; hex 73756e696e6762616e6b3136363339383933373434333736633566383263; asc suningbank16639893744376c5f82c; (total 31 bytes); 4: len 8; hex 800000002c031aec; asc , ;; Record lock, heap no 53 PHYSICAL RECORD: n_fields 5; compact format; info bits 0 0: len 25; hex 32303233303231363136333031353239303131343030383833; asc 2023021616301529011400883;; 1: len 8; hex 800000000134b048; asc 4 H;; 2: len 8; hex 8000000029b94271; asc ) Bq;; 3: len 30; hex 73756e696e6762616e6b3136363339383933373434333736633566383263; asc suningbank16639893744376c5f82c; (total 31 bytes); 4: len 8; hex 800000002c031d41; asc , A;; Record lock, heap no 67 PHYSICAL RECORD: n_fields 5; compact format; info bits 0 0: len 25; hex 32303233303231363136333232363239323131343030393834; asc 2023021616322629211400984;; 1: len 8; hex 800000000134b048; asc 4 H;; 2: len 8; hex 8000000029b94271; asc ) Bq;; 3: len 30; hex 73756e696e6762616e6b3136363339383933373434333736633566383263; asc suningbank16639893744376c5f82c; (total 31 bytes); 4: len 8; hex 800000002c034ab0; asc , J ;; Record lock, heap no 76 PHYSICAL RECORD: n_fields 5; compact format; info bits 32 0: len 25; hex 32303233303231363136333232363239323131343030393834; asc 2023021616322629211400984;; 1: len 8; hex 800000000134b048; asc 4 H;; 2: len 8; hex 8000000029b94271; asc ) Bq;; 3: len 30; hex 73756e696e6762616e6b3136363339383933373434333736633566383263; asc suningbank16639893744376c5f82c; (total 31 bytes); 4: len 8; hex 800000002c031ae7; asc , ;; Record lock, heap no 101 PHYSICAL RECORD: n_fields 5; compact format; info bits 0 0: len 25; hex 32303233303231363136333031333333363131353030333430; asc 2023021616301333611500340;; 1: len 8; hex 800000000134b048; asc 4 H;; 2: len 8; hex 8000000029b94271; asc ) Bq;; 3: len 30; hex 73756e696e6762616e6b3136363339383933373434333736633566383263; asc suningbank16639893744376c5f82c; (total 31 bytes); 4: len 8; hex 800000002c034ab5; asc , J ;; *** (1) WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 1312 page no 2058 n bits 256 index udx1 of table `smartxma_report`.`stat_call_task_robot_day` trx id 1106522308 lock_mode X locks gap before rec insert intention waiting Record lock, heap no 11 PHYSICAL RECORD: n_fields 5; compact format; info bits 32 0: len 25; hex 32303233303231363131303733303237393131353030323533; asc 2023021611073027911500253;; 1: len 8; hex 800000000134b048; asc 4 H;; 2: len 8; hex 8000000029b94270; asc ) Bp;; 3: len 30; hex 73756e696e6762616e6b3136363339383933373434333736633566383263; asc suningbank16639893744376c5f82c; (total 31 bytes); 4: len 8; hex 800000002c0319c1; asc , ;; *** (2) TRANSACTION: TRANSACTION 1106522307, ACTIVE 0 sec updating or deleting mysql tables in use 1, locked 1 LOCK WAIT 114 lock struct(s), heap size 24696, 2467 row lock(s), undo log entries 996 MySQL thread id 353, OS thread handle 139964732544768, query id 386064381 Applying batch of row changes (update) *** (2) HOLDS THE LOCK(S): RECORD LOCKS space id 1312 page no 2058 n bits 256 index udx1 of table `smartxma_report`.`stat_call_task_robot_day` trx id 1106522307 lock mode S locks gap before rec Record lock, heap no 6 PHYSICAL RECORD: n_fields 5; compact format; info bits 32 0: len 25; hex 32303233303231363131303731333839383131353030323430; asc 2023021611071389811500240;; 1: len 8; hex 800000000134b048; asc 4 H;; 2: len 8; hex 8000000029b94270; asc ) Bp;; 3: len 30; hex 73756e696e6762616e6b3136363339383933373434333736633566383263; asc suningbank16639893744376c5f82c; (total 31 bytes); 4: len 8; hex 800000002c031910; asc , ;; Record lock, heap no 8 PHYSICAL RECORD: n_fields 5; compact format; info bits 0 0: len 25; hex 32303233303231363131303732323137323131353030323531; asc 2023021611072217211500251;; 1: len 8; hex 800000000134b048; asc 4 H;; 2: len 8; hex 8000000029b94270; asc ) Bp;; 3: len 30; hex 73756e696e6762616e6b3136363339383933373434333736633566383263; asc suningbank16639893744376c5f82c; (total 31 bytes); 4: len 8; hex 800000002c032c4c; asc , ,L;; Record lock, heap no 9 PHYSICAL RECORD: n_fields 5; compact format; info bits 32 0: len 25; hex 32303233303231363131303732333030323131353030323532; asc 2023021611072300211500252;; 1: len 8; hex 800000000134b048; asc 4 H;; 2: len 8; hex 8000000029b94270; asc ) Bp;; 3: len 30; hex 73756e696e6762616e6b3136363339383933373434333736633566383263; asc suningbank16639893744376c5f82c; (total 31 bytes); 4: len 8; hex 800000002c03194b; asc , K;; Record lock, heap no 10 PHYSICAL RECORD: n_fields 5; compact format; info bits 32 0: len 25; hex 32303233303231363131303732373438323131343030303734; asc 2023021611072748211400074;; 1: len 8; hex 800000000134b048; asc 4 H;; 2: len 8; hex 8000000029b94270; asc ) Bp;; 3: len 30; hex 73756e696e6762616e6b3136363339383933373434333736633566383263; asc suningbank16639893744376c5f82c; (total 31 bytes); 4: len 8; hex 800000002c031af5; asc , ;; Record lock, heap no 11 PHYSICAL RECORD: n_fields 5; compact format; info bits 32 0: len 25; hex 32303233303231363131303733303237393131353030323533; asc 2023021611073027911500253;; 1: len 8; hex 800000000134b048; asc 4 H;; 2: len 8; hex 8000000029b94270; asc ) Bp;; 3: len 30; hex 73756e696e6762616e6b3136363339383933373434333736633566383263; asc suningbank16639893744376c5f82c; (total 31 bytes); 4: len 8; hex 800000002c0319c1; asc , ;; Record lock, heap no 12 PHYSICAL RECORD: n_fields 5; compact format; info bits 0 0: len 25; hex 32303233303231363131303733313135393131343030303739; asc 2023021611073115911400079;; 1: len 8; hex 800000000134b048; asc 4 H;; 2: len 8; hex 8000000029b94270; asc ) Bp;; 3: len 30; hex 73756e696e6762616e6b3136363339383933373434333736633566383263; asc suningbank16639893744376c5f82c; (total 31 bytes); 4: len 8; hex 800000002c031e22; asc , ";; " Record lock, heap no 13 PHYSICAL RECORD: n_fields 5; compact format; info bits 0 0: len 25; hex 32303233303231363131313433333935303131353030343739; asc 2023021611143395011500479;; 1: len 8; hex 800000000134b048; asc 4 H;; 2: len 8; hex 8000000029b94270; asc ) Bp;; 3: len 30; hex 73756e696e6762616e6b3136363339383933373434333736633566383263; asc suningbank16639893744376c5f82c; (total 31 bytes); 4: len 8; hex 800000002c034684; asc , F ;; Record lock, heap no 17 PHYSICAL RECORD: n_fields 5; compact format; info bits 32 0: len 25; hex 32303233303231363131303735333539323131353030323738; asc 2023021611075359211500278;; 1: len 8; hex 800000000134b048; asc 4 H;; 2: len 8; hex 8000000029b94270; asc ) Bp;; 3: len 30; hex 73756e696e6762616e6b3136363339383933373434333736633566383263; asc suningbank16639893744376c5f82c; (total 31 bytes); 4: len 8; hex 800000002c031a0b; asc , ;; Record lock, heap no 18 PHYSICAL RECORD: n_fields 5; compact format; info bits 0 0: len 25; hex 32303233303231363131303830303230363131353030323739; asc 2023021611080020611500279;; 1: len 8; hex 800000000134b048; asc 4 H;; 2: len 8; hex 8000000029b94270; asc ) Bp;; 3: len 30; hex 73756e696e6762616e6b3136363339383933373434333736633566383263; asc suningbank16639893744376c5f82c; (total 31 bytes); 4: len 8; hex 800000002c031c05; asc , ;; Record lock, heap no 27 PHYSICAL RECORD: n_fields 5; compact format; info bits 0 0: len 25; hex 32303233303231363131313133373135373131343030323334; asc 2023021611113715711400234;; 1: len 8; hex 800000000134b048; asc 4 H;; 2: len 8; hex 8000000029b94270; asc ) Bp;; 3: len 30; hex 73756e696e6762616e6b3136363339383933373434333736633566383263; asc suningbank16639893744376c5f82c; (total 31 bytes); 4: len 8; hex 800000002c03497d; asc , I};; Record lock, heap no 33 PHYSICAL RECORD: n_fields 5; compact format; info bits 0 0: len 25; hex 32303233303231363131303732333030323131353030323532; asc 2023021611072300211500252;; 1: len 8; hex 800000000134b048; asc 4 H;; 2: len 8; hex 8000000029b94270; asc ) Bp;; 3: len 30; hex 73756e696e6762616e6b3136363339383933373434333736633566383263; asc suningbank16639893744376c5f82c; (total 31 bytes); 4: len 8; hex 800000002c034914; asc , I ;; Record lock, heap no 34 PHYSICAL RECORD: n_fields 5; compact format; info bits 32 0: len 25; hex 32303233303231363131303932363336333131343030313430; asc 2023021611092636311400140;; 1: len 8; hex 800000000134b048; asc 4 H;; 2: len 8; hex 8000000029b94270; asc ) Bp;; 3: len 30; hex 73756e696e6762616e6b3136363339383933373434333736633566383263; asc suningbank16639893744376c5f82c; (total 31 bytes); 4: len 8; hex 800000002c0319f5; asc , ;; Record lock, heap no 35 PHYSICAL RECORD: n_fields 5; compact format; info bits 0 0: len 25; hex 32303233303231363131303932383434323131353030333332; asc 2023021611092844211500332;; 1: len 8; hex 800000000134b048; asc 4 H;; 2: len 8; hex 8000000029b94270; asc ) Bp;; 3: len 30; hex 73756e696e6762616e6b3136363339383933373434333736633566383263; asc suningbank16639893744376c5f82c; (total 31 bytes); 4: len 8; hex 800000002c03297d; asc , )};; Record lock, heap no 36 PHYSICAL RECORD: n_fields 5; compact format; info bits 32 0: len 25; hex 32303233303231363131303932393736353131353030333333; asc 2023021611092976511500333;; 1: len 8; hex 800000000134b048; asc 4 H;; 2: len 8; hex 8000000029b94270; asc ) Bp;; 3: len 30; hex 73756e696e6762616e6b3136363339383933373434333736633566383263; asc suningbank16639893744376c5f82c; (total 31 bytes); 4: len 8; hex 800000002c0318f1; asc , ;; Record lock, heap no 37 PHYSICAL RECORD: n_fields 5; compact format; info bits 0 0: len 25; hex 32303233303231363131303934303338383131353030333338; asc 2023021611094038811500338;; 1: len 8; hex 800000000134b048; asc 4 H;; 2: len 8; hex 8000000029b94270; asc ) Bp;; 3: len 30; hex 73756e696e6762616e6b3136363339383933373434333736633566383263; asc suningbank16639893744376c5f82c; (total 31 bytes); 4: len 8; hex 800000002c0321a5; asc , ! ;; Record lock, heap no 45 PHYSICAL RECORD: n_fields 5; compact format; info bits 32 0: len 25; hex 32303233303231363131313033333135373131343030313935; asc 2023021611103315711400195;; 1: len 8; hex 800000000134b048; asc 4 H;; 2: len 8; hex 8000000029b94270; asc ) Bp;; 3: len 30; hex 73756e696e6762616e6b3136363339383933373434333736633566383263; asc suningbank16639893744376c5f82c; (total 31 bytes); 4: len 8; hex 800000002c031a55; asc , U;; Record lock, heap no 46 PHYSICAL RECORD: n_fields 5; compact format; info bits 0 0: len 25; hex 32303233303231363131313033333536373131353030333532; asc 2023021611103356711500352;; 1: len 8; hex 800000000134b048; asc 4 H;; 2: len 8; hex 8000000029b94270; asc ) Bp;; 3: len 30; hex 73756e696e6762616e6b3136363339383933373434333736633566383263; asc suningbank16639893744376c5f82c; (total 31 bytes); 4: len 8; hex 800000002c032685; asc , & ;; Record lock, heap no 56 PHYSICAL RECORD: n_fields 5; compact format; info bits 0 0: len 25; hex 32303233303231363131303932393736353131353030333333; asc 2023021611092976511500333;; 1: len 8; hex 800000000134b048; asc 4 H;; 2: len 8; hex 8000000029b94270; asc ) Bp;; 3: len 30; hex 73756e696e6762616e6b3136363339383933373434333736633566383263; asc suningbank16639893744376c5f82c; (total 31 bytes); 4: len 8; hex 800000002c0348ba; asc , H ;; Record lock, heap no 57 PHYSICAL RECORD: n_fields 5; compact format; info bits 32 0: len 25; hex 32303233303231363131313133373135373131343030323334; asc 2023021611113715711400234;; 1: len 8; hex 800000000134b048; asc 4 H;; 2: len 8; hex 8000000029b94270; asc ) Bp;; 3: len 30; hex 73756e696e6762616e6b3136363339383933373434333736633566383263; asc suningbank16639893744376c5f82c; (total 31 bytes); 4: len 8; hex 800000002c0319b4; asc , ;; Record lock, heap no 58 PHYSICAL RECORD: n_fields 5; compact format; info bits 0 0: len 25; hex 32303233303231363131313134323234353131353030333935; asc 2023021611114224511500395;; 1: len 8; hex 800000000134b048; asc 4 H;; 2: len 8; hex 8000000029b94270; asc ) Bp;; 3: len 30; hex 73756e696e6762616e6b3136363339383933373434333736633566383263; asc suningbank16639893744376c5f82c; (total 31 bytes); 4: len 8; hex 800000002c0323d9; asc , # ;; Record lock, heap no 59 PHYSICAL RECORD: n_fields 5; compact format; info bits 32 0: len 25; hex 32303233303231363131313230393134323131343030323539; asc 2023021611120914211400259;; 1: len 8; hex 800000000134b048; asc 4 H;; 2: len 8; hex 8000000029b94270; asc ) Bp;; 3: len 30; hex 73756e696e6762616e6b3136363339383933373434333736633566383263; asc suningbank16639893744376c5f82c; (total 31 bytes); 4: len 8; hex 800000002c031a6a; asc , j;; Record lock, heap no 60 PHYSICAL RECORD: n_fields 5; compact format; info bits 0 0: len 25; hex 32303233303231363131313231313038343131343030323630; asc 2023021611121108411400260;; 1: len 8; hex 800000000134b048; asc 4 H;; 2: len 8; hex 8000000029b94270; asc ) Bp;; 3: len 30; hex 73756e696e6762616e6b3136363339383933373434333736633566383263; asc suningbank16639893744376c5f82c; (total 31 bytes); 4: len 8; hex 800000002c0321fc; asc , ! ;; Record lock, heap no 77 PHYSICAL RECORD: n_fields 5; compact format; info bits 0 0: len 25; hex 32303233303231363131313033333135373131343030313935; asc 2023021611103315711400195;; 1: len 8; hex 800000000134b048; asc 4 H;; 2: len 8; hex 8000000029b94270; asc ) Bp;; 3: len 30; hex 73756e696e6762616e6b3136363339383933373434333736633566383263; asc suningbank16639893744376c5f82c; (total 31 bytes); 4: len 8; hex 800000002c034a1e; asc , J ;; Record lock, heap no 79 PHYSICAL RECORD: n_fields 5; compact format; info bits 32 0: len 25; hex 32303233303231363131313432373331343131343030333630; asc 2023021611142731411400360;; 1: len 8; hex 800000000134b048; asc 4 H;; 2: len 8; hex 8000000029b94270; asc ) Bp;; 3: len 30; hex 73756e696e6762616e6b3136363339383933373434333736633566383263; asc suningbank16639893744376c5f82c; (total 31 bytes); 4: len 8; hex 800000002c031a92; asc , ;; Record lock, heap no 87 PHYSICAL RECORD: n_fields 5; compact format; info bits 0 0: len 25; hex 32303233303231363131303733303237393131353030323533; asc 2023021611073027911500253;; 1: len 8; hex 800000000134b048; asc 4 H;; 2: len 8; hex 8000000029b94270; asc ) Bp;; 3: len 30; hex 73756e696e6762616e6b3136363339383933373434333736633566383263; asc suningbank16639893744376c5f82c; (total 31 bytes); 4: len 8; hex 800000002c03498a; asc , I ;; Record lock, heap no 88 PHYSICAL RECORD: n_fields 5; compact format; info bits 0 0: len 25; hex 32303233303231363131303932363336333131343030313430; asc 2023021611092636311400140;; 1: len 8; hex 800000000134b048; asc 4 H;; 2: len 8; hex 8000000029b94270; asc ) Bp;; 3: len 30; hex 73756e696e6762616e6b3136363339383933373434333736633566383263; asc suningbank16639893744376c5f82c; (total 31 bytes); 4: len 8; hex 800000002c0349be; asc , I ;; Record lock, heap no 89 PHYSICAL RECORD: n_fields 5; compact format; info bits 0 0: len 25; hex 32303233303231363131303731333839383131353030323430; asc 2023021611071389811500240;; 1: len 8; hex 800000000134b048; asc 4 H;; 2: len 8; hex 8000000029b94270; asc ) Bp;; 3: len 30; hex 73756e696e6762616e6b3136363339383933373434333736633566383263; asc suningbank16639893744376c5f82c; (total 31 bytes); 4: len 8; hex 800000002c0348d9; asc , H ;; Record lock, heap no 90 PHYSICAL RECORD: n_fields 5; compact format; info bits 0 0: len 25; hex 32303233303231363131313432373331343131343030333630; asc 2023021611142731411400360;; 1: len 8; hex 800000000134b048; asc 4 H;; 2: len 8; hex 8000000029b94270; asc ) Bp;; 3: len 30; hex 73756e696e6762616e6b3136363339383933373434333736633566383263; asc suningbank16639893744376c5f82c; (total 31 bytes); 4: len 8; hex 800000002c034a5b; asc , J[;; Record lock, heap no 91 PHYSICAL RECORD: n_fields 5; compact format; info bits 0 0: len 25; hex 32303233303231363131303735333539323131353030323738; asc 2023021611075359211500278;; 1: len 8; hex 800000000134b048; asc 4 H;; 2: len 8; hex 8000000029b94270; asc ) Bp;; 3: len 30; hex 73756e696e6762616e6b3136363339383933373434333736633566383263; asc suningbank16639893744376c5f82c; (total 31 bytes); 4: len 8; hex 800000002c0349d4; asc , I ;; Record lock, heap no 92 PHYSICAL RECORD: n_fields 5; compact format; info bits 0 0: len 25; hex 32303233303231363131313230393134323131343030323539; asc 2023021611120914211400259;; 1: len 8; hex 800000000134b048; asc 4 H;; 2: len 8; hex 8000000029b94270; asc ) Bp;; 3: len 30; hex 73756e696e6762616e6b3136363339383933373434333736633566383263; asc suningbank16639893744376c5f82c; (total 31 bytes); 4: len 8; hex 800000002c034a33; asc , J3;; *** (2) WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 1312 page no 2081 n bits 256 index udx1 of table `smartxma_report`.`stat_call_task_robot_day` trx id 1106522307 lock_mode X locks gap before rec insert intention waiting Record lock, heap no 52 PHYSICAL RECORD: n_fields 5; compact format; info bits 32 0: len 25; hex 32303233303231363136333031333333363131353030333430; asc 2023021616301333611500340;; 1: len 8; hex 800000000134b048; asc 4 H;; 2: len 8; hex 8000000029b94271; asc ) Bq;; 3: len 30; hex 73756e696e6762616e6b3136363339383933373434333736633566383263; asc suningbank16639893744376c5f82c; (total 31 bytes); 4: len 8; hex 800000002c031aec; asc , ;; *** WE ROLL BACK TRANSACTION (2) ------------ TRANSACTIONS ------------