2025-02-06T03:54:53.083241+08:00 222512 [Note] InnoDB: *** (1) TRANSACTION:TRANSACTION 945697160,

2025-02-06T03:54:53.083241+08:00 222512 [Note] InnoDB: 
*** (1) TRANSACTION:

TRANSACTION 945697160, ACTIVE 1 sec updating or deleting
mysql tables in use 1, locked 1
LOCK WAIT 3 lock struct(s), heap size 1136, 2 row lock(s), undo log entries 1
MySQL thread id 222499, OS thread handle 140678818617088, query id 226783703 172.21.197.250 mysql updating
DELETE FROM job_registry
        WHERE id in
         (  
            152
         )
2025-02-06T03:54:53.083276+08:00 222512 [Note] InnoDB: *** (1) WAITING FOR THIS LOCK TO BE GRANTED:

RECORD LOCKS space id 527 page no 4 n bits 80 index IDX_G_K_V of table `evo_job`.`job_registry` trx id 945697160 lock_mode X locks rec but not gap waiting
Record lock, heap no 3 PHYSICAL RECORD: n_fields 4; compact format; info bits 0
 0: len 8; hex 4558454355544f52; asc EXECUTOR;;
 1: len 8; hex 65766f2d786d7879; asc evo-xmxy;;
 2: len 20; hex 3137322e32312e3139372e3235303a3231303038; asc 172.21.197.250:21008;;
 3: len 4; hex 80000098; asc     ;;

2025-02-06T03:54:53.155930+08:00 222512 [Note] InnoDB: *** 
(2) TRANSACTION:

TRANSACTION 945697145, ACTIVE 1 sec starting index read
mysql tables in use 1, locked 1
3 lock struct(s), heap size 1136, 2 row lock(s)
MySQL thread id 222512, OS thread handle 140680593917696, query id 226783649 172.21.197.250 mysql updating
UPDATE job_registry
        SET `update_time` = '2025-02-06 03:53:34.476'
        WHERE `registry_group` = 'EXECUTOR'
          AND `registry_key` = 'evo-xmxy'
          AND `registry_value` = '172.21.197.250:21008'
2025-02-06T03:54:53.155967+08:00 222512 [Note] InnoDB: *** (2) HOLDS THE LOCK(S):

RECORD LOCKS space id 527 page no 4 n bits 80 index IDX_G_K_V of table `evo_job`.`job_registry` trx id 945697145 lock_mode X
Record lock, heap no 3 PHYSICAL RECORD: n_fields 4; compact format; info bits 0
 0: len 8; hex 4558454355544f52; asc EXECUTOR;;
 1: len 8; hex 65766f2d786d7879; asc evo-xmxy;;
 2: len 20; hex 3137322e32312e3139372e3235303a3231303038; asc 172.21.197.250:21008;;
 3: len 4; hex 80000098; asc     ;;

2025-02-06T03:54:53.156169+08:00 222512 [Note] InnoDB: *** (2) WAITING FOR THIS LOCK TO BE GRANTED:

RECORD LOCKS space id 527 page no 3 n bits 80 index PRIMARY of table `evo_job`.`job_registry` trx id 945697145 lock_mode X locks rec but not gap waiting
Record lock, heap no 3 PHYSICAL RECORD: n_fields 7; compact format; info bits 32
 0: len 4; hex 80000098; asc     ;;
 1: len 6; hex 0000385e3188; asc   8^1 ;;
 2: len 7; hex 2c000004db07f8; asc ,      ;;
 3: len 8; hex 4558454355544f52; asc EXECUTOR;;
 4: len 8; hex 65766f2d786d7879; asc evo-xmxy;;
 5: len 20; hex 3137322e32312e3139372e3235303a3231303038; asc 172.21.197.250:21008;;
 6: len 5; hex 99b5cc3d8e; asc    = ;;

2025-02-06T03:54:53.156468+08:00 222512 [Note] InnoDB: *** WE ROLL BACK TRANSACTION (2)