2025-11-03 18:36:13 0x2d4
*** (1) TRANSACTION:
TRANSACTION 29363911, ACTIVE 0 sec starting index read
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 1136, 1 row lock(s)
MySQL thread id 13883408, OS thread handle 3444, query id 361503965 localhost ::1 aitech updating
DELETE FROM `wp_ai4todayoptions` WHERE `option_name` = 'wcfm_updated_end_point_wc_listings'
*** (1) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 500 page no 25 n bits 296 index option_name of table `aifortoday`.`wp_ai4todayoptions` trx id 29363911 lock_mode X locks rec but not gap waiting
Record lock, heap no 221 PHYSICAL RECORD: n_fields 2; compact format; info bits 32
 0: len 30; hex 7763666d5f757064617465645f656e645f706f696e745f77635f6c697374; asc wcfm_updated_end_point_wc_list; (total 34 bytes);
 1: len 8; hex 0000000000056296; asc       b ;;

*** (2) TRANSACTION:
TRANSACTION 29363901, ACTIVE 1 sec starting index read, thread declared inside InnoDB 1
mysql tables in use 1, locked 1
3 lock struct(s), heap size 1136, 2 row lock(s)
MySQL thread id 13883364, OS thread handle 724, query id 361503306 localhost ::1 aitech updating
DELETE FROM `wp_ai4todayoptions` WHERE `option_name` = 'wcfm_updated_end_point_wc_listings'
*** (2) HOLDS THE LOCK(S):
RECORD LOCKS space id 500 page no 25 n bits 296 index option_name of table `aifortoday`.`wp_ai4todayoptions` trx id 29363901 lock_mode X locks rec but not gap
Record lock, heap no 221 PHYSICAL RECORD: n_fields 2; compact format; info bits 32
 0: len 30; hex 7763666d5f757064617465645f656e645f706f696e745f77635f6c697374; asc wcfm_updated_end_point_wc_list; (total 34 bytes);
 1: len 8; hex 0000000000056296; asc       b ;;

*** (2) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 500 page no 25 n bits 296 index option_name of table `aifortoday`.`wp_ai4todayoptions` trx id 29363901 lock_mode X waiting
Record lock, heap no 221 PHYSICAL RECORD: n_fields 2; compact format; info bits 32
 0: len 30; hex 7763666d5f757064617465645f656e645f706f696e745f77635f6c697374; asc wcfm_updated_end_point_wc_list; (total 34 bytes);
 1: len 8; hex 0000000000056296; asc       b ;;

*** WE ROLL BACK TRANSACTION (1)

 _site_transient_timeout_wp_the; (total 80 bytes);
 1: len 8; hex 0000000000027a9e; asc       z ;;

*** WE ROLL BACK TRANSACTION (1)
"286\";i:19;s:3:\"287\";i:20;s:3:\"288\";i:21;s:3:\"289\";i:22;s:3:\"290\";i:23;s:3:\"291\";}}', 'off') ON DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`)
*** (2) HOLDS THE LOCK(S):
RECORD LOCKS space id 571 page no 224 n bits 280 index option_name of table `toppersdrinks`.`wp_tops_options` trx id 28898947 lock_mode X
Record lock, heap no 68 PHYSICAL RECORD: n_fields 2; compact format; info bits 32
 0: len 27; hex 5f7472616e7369656e745f77635f72656c617465645f3135383436; asc _transient_wc_related_15846;;
 1: len 8; hex 00000000000b6322; asc       c";;

Record lock, heap no 69 PHYSICAL RECORD: n_fields 2; compact format; info bits 32
 0: len 27; hex 5f7472616e7369656e745f77635f72656c617465645f3135383530; asc _transient_wc_related_15850;;
 1: len 8; hex 00000000000b6430; asc       d0;;

*** (2) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 571 page no 224 n bits 280 index option_name of table `toppersdrinks`.`wp_tops_options` trx id 28898947 lock_mode X locks gap before rec insert intention waiting
Record lock, heap no 69 PHYSICAL RECORD: n_fields 2; compact format; info bits 32
 0: len 27; hex 5f7472616e7369656e745f77635f72656c617465645f3135383530; asc _transient_wc_related_15850;;
 1: len 8; hex 00000000000b6430; asc       d0;;

*** WE ROLL BACK TRANSACTION (1)
ICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 30; hex 5f7472616e7369656e745f74696d656f75745f6a65747061636b5f73796e; asc _transient_timeout_jetpack_syn; (total 61 bytes);
 1: len 8; hex 000000000004f6d6; asc         ;;

*** (2) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 500 page no 23 n bits 432 index option_name of table `aifortoday`.`wp_ai4todayoptions` trx id 26749743 lock_mode X waiting
Record lock, heap no 360 PHYSICAL RECORD: n_fields 2; compact format; info bits 32
 0: len 30; hex 5f7472616e7369656e745f74696d656f75745f6a65747061636b5f757064; asc _transient_timeout_jetpack_upd; (total 59 bytes);
 1: len 8; hex 000000000004f755; asc        U;;

*** WE ROLL BACK TRANSACTION (1)

 2: len 5; hex 99b79d6bfa; asc    k ;;
 3: len 8; hex 0000000000004421; asc       D!;;

*** WE ROLL BACK TRANSACTION (2)