------------
TRANSACTIONS
------------
Trx id counter 761976
Purge done for trx's n:o < 761976 undo n:o < 0 state: running but idle
History list length 0
Total number of lock structs in row lock hash table 20
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 422212024706184, not started
0 lock struct(s), heap size 1200, 0 row lock(s)
---TRANSACTION 422212024705144, not started
0 lock struct(s), heap size 1200, 0 row lock(s)
---TRANSACTION 422212024718664, not started
0 lock struct(s), heap size 1200, 0 row lock(s)
---TRANSACTION 422212024703064, not started
0 lock struct(s), heap size 1200, 0 row lock(s)
---TRANSACTION 422212024702024, not started
0 lock struct(s), heap size 1200, 0 row lock(s)
---TRANSACTION 761970, ACTIVE (PREPARED) 366 sec
6 lock struct(s), heap size 1200, 6 row lock(s), undo log entries 3
MySQL thread id 116, OS thread handle 140736484505344, query id 41884 Waiting for preceding transaction to commit
TABLE LOCK table `test`.`testpri2` trx id 761970 lock mode IX
RECORD LOCKS space id 184 page no 49 n bits 528 index PRIMARY of table `test`.`testpri2` trx id 761970 lock_mode X locks rec but not gap
Record lock, heap no 10 PHYSICAL RECORD: n_fields 6; compact format; info bits 32
 0: len 4; hex 80002b89; asc   + ;;
 1: len 6; hex 0000000ba072; asc      r;;
 2: len 7; hex 010000012a1001; asc     *  ;;
 3: len 4; hex 800000d0; asc     ;;
 4: len 4; hex 800000d0; asc     ;;
 5: len 4; hex 800000d0; asc     ;;

RECORD LOCKS space id 184 page no 33 n bits 952 index a of table `test`.`testpri2` trx id 761970 lock_mode X locks rec but not gap
Record lock, heap no 649 PHYSICAL RECORD: n_fields 3; compact format; info bits 32
 0: len 4; hex 800000d0; asc     ;;
 1: len 4; hex 800000d0; asc     ;;
 2: len 4; hex 80002b89; asc   + ;;

RECORD LOCKS space id 184 page no 33 n bits 952 index a of table `test`.`testpri2` trx id 761970 lock mode S locks rec but not gap
Record lock, heap no 650 PHYSICAL RECORD: n_fields 3; compact format; info bits 0
 0: len 4; hex 800000d1; asc     ;;
 1: len 4; hex 800000d1; asc     ;;
 2: len 4; hex 80002b8c; asc   + ;;

TABLE LOCK table `mysql`.`slave_worker_info` trx id 761970 lock mode IX
RECORD LOCKS space id 4294967294 page no 432 n bits 120 index PRIMARY of table `mysql`.`slave_worker_info` trx id 761970 lock_mode X locks rec but not gap
Record lock, heap no 49 PHYSICAL RECORD: n_fields 15; compact format; info bits 0
 0: len 30; hex 67726f75705f7265706c69636174696f6e5f6170706c6965722020202020; asc group_replication_applier     ; (total 64 bytes);
 1: len 4; hex 00000002; asc     ;;
 2: len 6; hex 0000000ba072; asc      r;;
 3: len 7; hex 010000012a1031; asc     * 1;;
 4: len 30; hex 2f6e6577646174612f6d7973716c2f6d7973716c383032332f72656c6179; asc /newdata/mysql/mysql8023/relay; (total 76 bytes);
 5: len 8; hex 000000000002a737; asc        7;;
 6: len 0; hex ; asc ;;
 7: len 8; hex 0000000000000000; asc         ;;
 8: len 30; hex 2f6e6577646174612f6d7973716c2f6d7973716c383032332f72656c6179; asc /newdata/mysql/mysql8023/relay; (total 76 bytes);
 9: len 8; hex 0000000000028729; asc        );;
 10: len 0; hex ; asc ;;
 11: len 8; hex 0000000000000000; asc         ;;
 12: len 4; hex 00000015; asc     ;;
 13: len 4; hex 00000040; asc    @;;
 14: len 30; hex 242222000000000000000000000000000000000000000000000000000000; asc $""                           ; (total 64 bytes);

---TRANSACTION 761969, ACTIVE 366 sec updating or deleting
mysql tables in use 1, locked 1
LOCK WAIT 6 lock struct(s), heap size 1200, 4 row lock(s), undo log entries 2
MySQL thread id 115, OS thread handle 140736484800256, query id 41882 Applying batch of row changes (update)
replace into test.testpri2(a,b,c) values(144,144,144)
------- TRX HAS BEEN WAITING 366 SEC FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 184 page no 33 n bits 952 index a of table `test`.`testpri2` trx id 761969 lock mode S waiting
Record lock, heap no 586 PHYSICAL RECORD: n_fields 3; compact format; info bits 32
 0: len 4; hex 80000091; asc     ;;
 1: len 4; hex 80000091; asc     ;;
 2: len 4; hex 80002ac7; asc   * ;;

------------------
TABLE LOCK table `test`.`testpri2` trx id 761969 lock mode IX
RECORD LOCKS space id 184 page no 104 n bits 424 index PRIMARY of table `test`.`testpri2` trx id 761969 lock_mode X locks rec but not gap
Record lock, heap no 355 PHYSICAL RECORD: n_fields 6; compact format; info bits 32
 0: len 4; hex 8000a8f0; asc     ;;
 1: len 6; hex 0000000ba071; asc      q;;
 2: len 7; hex 02000001f22217; asc      " ;;
 3: len 4; hex 80000090; asc     ;;
 4: len 4; hex 80000090; asc     ;;
 5: len 4; hex 80000090; asc     ;;

RECORD LOCKS space id 184 page no 33 n bits 952 index a of table `test`.`testpri2` trx id 761969 lock mode S
RECORD LOCKS space id 184 page no 33 n bits 952 index a of table `test`.`testpri2` trx id 761969 lock_mode X locks rec but not gap
Record lock, heap no 22 PHYSICAL RECORD: n_fields 3; compact format; info bits 32
 0: len 4; hex 80000090; asc     ;;
 1: len 4; hex 80000090; asc     ;;
 2: len 4; hex 8000a8f0; asc     ;;

RECORD LOCKS space id 184 page no 33 n bits 952 index a of table `test`.`testpri2` trx id 761969 lock mode S locks gap before rec
Record lock, heap no 22 PHYSICAL RECORD: n_fields 3; compact format; info bits 32
 0: len 4; hex 80000090; asc     ;;
 1: len 4; hex 80000090; asc     ;;
 2: len 4; hex 8000a8f0; asc     ;;

RECORD LOCKS space id 184 page no 33 n bits 952 index a of table `test`.`testpri2` trx id 761969 lock mode S waiting
Record lock, heap no 586 PHYSICAL RECORD: n_fields 3; compact format; info bits 32
 0: len 4; hex 80000091; asc     ;;
 1: len 4; hex 80000091; asc     ;;
 2: len 4; hex 80002ac7; asc   * ;;

---TRANSACTION 761967, ACTIVE (PREPARED) 366 sec
6 lock struct(s), heap size 1200, 6 row lock(s), undo log entries 3
MySQL thread id 117, OS thread handle 140736529712896, query id 41880 Waiting for preceding transaction to commit
TABLE LOCK table `test`.`testpri2` trx id 761967 lock mode IX
RECORD LOCKS space id 184 page no 49 n bits 528 index PRIMARY of table `test`.`testpri2` trx id 761967 lock_mode X locks rec but not gap
Record lock, heap no 393 PHYSICAL RECORD: n_fields 6; compact format; info bits 32
 0: len 4; hex 80002ac7; asc   * ;;
 1: len 6; hex 0000000ba06f; asc      o;;
 2: len 7; hex 01000001231786; asc     #  ;;
 3: len 4; hex 80000091; asc     ;;
 4: len 4; hex 80000091; asc     ;;
 5: len 4; hex 80000091; asc     ;;

RECORD LOCKS space id 184 page no 33 n bits 952 index a of table `test`.`testpri2` trx id 761967 lock_mode X locks rec but not gap
Record lock, heap no 586 PHYSICAL RECORD: n_fields 3; compact format; info bits 32
 0: len 4; hex 80000091; asc     ;;
 1: len 4; hex 80000091; asc     ;;
 2: len 4; hex 80002ac7; asc   * ;;

RECORD LOCKS space id 184 page no 33 n bits 952 index a of table `test`.`testpri2` trx id 761967 lock mode S locks rec but not gap
Record lock, heap no 587 PHYSICAL RECORD: n_fields 3; compact format; info bits 0
 0: len 4; hex 80000092; asc     ;;
 1: len 4; hex 80000092; asc     ;;
 2: len 4; hex 8000a840; asc    @;;

TABLE LOCK table `mysql`.`slave_worker_info` trx id 761967 lock mode IX
RECORD LOCKS space id 4294967294 page no 432 n bits 120 index PRIMARY of table `mysql`.`slave_worker_info` trx id 761967 lock_mode X locks rec but not gap
Record lock, heap no 51 PHYSICAL RECORD: n_fields 15; compact format; info bits 0
 0: len 30; hex 67726f75705f7265706c69636174696f6e5f6170706c6965722020202020; asc group_replication_applier     ; (total 64 bytes);
 1: len 4; hex 00000003; asc     ;;
 2: len 6; hex 0000000ba06f; asc      o;;
 3: len 7; hex 010000012317b6; asc     #  ;;
 4: len 30; hex 2f6e6577646174612f6d7973716c2f6d7973716c383032332f72656c6179; asc /newdata/mysql/mysql8023/relay; (total 76 bytes);
 5: len 8; hex 000000000002a44d; asc        M;;
 6: len 0; hex ; asc ;;
 7: len 8; hex 0000000000000000; asc         ;;
 8: len 30; hex 2f6e6577646174612f6d7973716c2f6d7973716c383032332f72656c6179; asc /newdata/mysql/mysql8023/relay; (total 76 bytes);
 9: len 8; hex 0000000000028729; asc        );;
 10: len 0; hex ; asc ;;
 11: len 8; hex 0000000000000000; asc         ;;
 12: len 4; hex 00000013; asc     ;;
 13: len 4; hex 00000040; asc    @;;
 14: len 30; hex 898808000000000000000000000000000000000000000000000000000000; asc                               ; (total 64 bytes);

---TRANSACTION 761964, ACTIVE 366 sec updating or deleting
mysql tables in use 1, locked 1
LOCK WAIT 8 lock struct(s), heap size 1200, 5 row lock(s), undo log entries 2
MySQL thread id 118, OS thread handle 140736485095168, query id 41878 Applying batch of row changes (update)
replace into test.testpri2(a,b,c) values(143,143,143)
------- TRX HAS BEEN WAITING 366 SEC FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 184 page no 33 n bits 952 index a of table `test`.`testpri2` trx id 761964 lock mode S waiting
Record lock, heap no 22 PHYSICAL RECORD: n_fields 3; compact format; info bits 32
 0: len 4; hex 80000090; asc     ;;
 1: len 4; hex 80000090; asc     ;;
 2: len 4; hex 8000a8f0; asc     ;;

------------------
TABLE LOCK table `test`.`testpri2` trx id 761964 lock mode IX
RECORD LOCKS space id 184 page no 104 n bits 424 index PRIMARY of table `test`.`testpri2` trx id 761964 lock_mode X locks rec but not gap
Record lock, heap no 352 PHYSICAL RECORD: n_fields 6; compact format; info bits 32
 0: len 4; hex 8000a8ed; asc     ;;
 1: len 6; hex 0000000ba06c; asc      l;;
 2: len 7; hex 02000001da2834; asc      (4;;
 3: len 4; hex 8000008f; asc     ;;
 4: len 4; hex 8000008f; asc     ;;
 5: len 4; hex 8000008f; asc     ;;

RECORD LOCKS space id 184 page no 33 n bits 952 index a of table `test`.`testpri2` trx id 761964 lock mode S
RECORD LOCKS space id 184 page no 33 n bits 952 index a of table `test`.`testpri2` trx id 761964 lock_mode X locks rec but not gap
Record lock, heap no 20 PHYSICAL RECORD: n_fields 3; compact format; info bits 32
 0: len 4; hex 8000008f; asc     ;;
 1: len 4; hex 8000008f; asc     ;;
 2: len 4; hex 8000a8ed; asc     ;;

RECORD LOCKS space id 184 page no 33 n bits 952 index a of table `test`.`testpri2` trx id 761964 lock mode S locks gap before rec
Record lock, heap no 20 PHYSICAL RECORD: n_fields 3; compact format; info bits 32
 0: len 4; hex 8000008f; asc     ;;
 1: len 4; hex 8000008f; asc     ;;
 2: len 4; hex 8000a8ed; asc     ;;

Record lock, heap no 22 PHYSICAL RECORD: n_fields 3; compact format; info bits 32
 0: len 4; hex 80000090; asc     ;;
 1: len 4; hex 80000090; asc     ;;
 2: len 4; hex 8000a8f0; asc     ;;

RECORD LOCKS space id 184 page no 33 n bits 952 index a of table `test`.`testpri2` trx id 761964 lock mode S
RECORD LOCKS space id 184 page no 33 n bits 952 index a of table `test`.`testpri2` trx id 761964 lock_mode X locks gap before rec insert intention
RECORD LOCKS space id 184 page no 33 n bits 952 index a of table `test`.`testpri2` trx id 761964 lock mode S waiting
Record lock, heap no 22 PHYSICAL RECORD: n_fields 3; compact format; info bits 32
 0: len 4; hex 80000090; asc     ;;
 1: len 4; hex 80000090; asc     ;;
 2: len 4; hex 8000a8f0; asc     ;;