MariaDB [information_schema]> show engine innodb status\G *************************** 1. row *************************** Type: InnoDB Name: Status: ===================================== 2023-10-18 18:09:53 0x7f5192ff0700 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 638 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 0 srv_active, 0 srv_shutdown, 74284 srv_idle srv_master_thread log flush and writes: 74283 ---------- SEMAPHORES ---------- ------------------------ LATEST DETECTED DEADLOCK ------------------------ 2023-10-18 10:25:01 0x7f50a9440700 *** (1) TRANSACTION: TRANSACTION 1337417, ACTIVE 0 sec inserting mysql tables in use 1, locked 1 LOCK WAIT 3 lock struct(s), heap size 1128, 2 row lock(s) MariaDB thread id 6019, OS thread handle 139984413918976, query id 6293412 10.49.40.220 admin Update INSERT INTO QRTZ_SCHEDULER_STATE (SCHED_NAME, INSTANCE_NAME, LAST_CHECKIN_TIME, CHECKIN_INTERVAL) VALUES('xxxxxxxxxxxxxxxx-x', 'xxxxxxxxxxxxxxxx169753456364554', 111112312415123123, 7500) *** WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 1716 page no 3 n bits 8 index PRIMARY of table `iam`.`qrtz_scheduler_state` trx id 1337417 lock_mode X locks gap before rec insert intention waiting Record lock, heap no 4 PHYSICAL RECORD: n_fields 6; compact format; info bits 0 0: len 17; hex 5363686564756c65722d434c5553544552; asc Scheduler-CLUSTER;; 1: len 30; hex 7461636d656469756d317a746e613333762e6d786c2e73686a74322e7169; asc tacmedium1ztna33v.mxl.shjt2.qi; (total 55 bytes); 2: len 6; hex 000000000000; asc ;; 3: len 7; hex 80000000000000; asc ;; 4: len 8; hex 8000018b409854c8; asc @ T ;; 5: len 8; hex 8000000000001d4c; asc L;; *** CONFLICTING WITH: RECORD LOCKS space id 1716 page no 3 n bits 8 index PRIMARY of table `iam`.`qrtz_scheduler_state` trx id 1337416 lock_mode X locks gap before rec Record lock, heap no 4 PHYSICAL RECORD: n_fields 6; compact format; info bits 0 0: len 17; hex 5363686564756c65722d434c5553544552; asc Scheduler-CLUSTER;; 1: len 30; hex 7461636d656469756d317a746e613333762e6d786c2e73686a74322e7169; asc tacmedium1ztna33v.mxl.shjt2.qi; (total 55 bytes); 2: len 6; hex 000000000000; asc ;; 3: len 7; hex 80000000000000; asc ;; 4: len 8; hex 8000018b409854c8; asc @ T ;; 5: len 8; hex 8000000000001d4c; asc L;; RECORD LOCKS space id 1716 page no 3 n bits 8 index PRIMARY of table `iam`.`qrtz_scheduler_state` trx id 1337417 lock_mode X locks gap before rec Record lock, heap no 4 PHYSICAL RECORD: n_fields 6; compact format; info bits 0 0: len 17; hex 5363686564756c65722d434c5553544552; asc Scheduler-CLUSTER;; 1: len 30; hex 7461636d656469756d317a746e613333762e6d786c2e73686a74322e7169; asc tacmedium1ztna33v.mxl.shjt2.qi; (total 55 bytes); 2: len 6; hex 000000000000; asc ;; 3: len 7; hex 80000000000000; asc ;; 4: len 8; hex 8000018b409854c8; asc @ T ;; 5: len 8; hex 8000000000001d4c; asc L;; *** (2) TRANSACTION: TRANSACTION 1337416, ACTIVE 0 sec inserting mysql tables in use 1, locked 1 LOCK WAIT 3 lock struct(s), heap size 1128, 2 row lock(s) MariaDB thread id 9689, OS thread handle 139984454874880, query id 6293409 10.49.40.62 admin Update INSERT INTO QRTZ_SCHEDULER_STATE (SCHED_NAME, INSTANCE_NAME, LAST_CHECKIN_TIME, CHECKIN_INTERVAL) VALUES('Scheduler-ADMIN', 'xxxxxxxxxxxxxxxxxxxxxxxx16234235340', 34564675523, 7500) *** WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 1716 page no 3 n bits 8 index PRIMARY of table `iam`.`qrtz_scheduler_state` trx id 1337416 lock_mode X locks gap before rec insert intention waiting Record lock, heap no 4 PHYSICAL RECORD: n_fields 6; compact format; info bits 0 0: len 17; hex 5363686564756c65722d434c5553544552; asc Scheduler-CLUSTER;; 1: len 30; hex 7461636d656469756d317a746e613333762e6d786c2e73686a74322e7169; asc tacmedium1ztna33v.mxl.shjt2.qi; (total 55 bytes); 2: len 6; hex 000000000000; asc ;; 3: len 7; hex 80000000000000; asc ;; 4: len 8; hex 8000018b409854c8; asc @ T ;; 5: len 8; hex 8000000000001d4c; asc L;; *** CONFLICTING WITH: RECORD LOCKS space id 1716 page no 3 n bits 8 index PRIMARY of table `iam`.`qrtz_scheduler_state` trx id 1337416 lock_mode X locks gap before rec Record lock, heap no 4 PHYSICAL RECORD: n_fields 6; compact format; info bits 0 0: len 17; hex 5363686564756c65722d434c5553544552; asc Scheduler-CLUSTER;; 1: len 30; hex 7461636d656469756d317a746e613333762e6d786c2e73686a74322e7169; asc tacmedium1ztna33v.mxl.shjt2.qi; (total 55 bytes); 2: len 6; hex 000000000000; asc ;; 3: len 7; hex 80000000000000; asc ;; 4: len 8; hex 8000018b409854c8; asc @ T ;; 5: len 8; hex 8000000000001d4c; asc L;; RECORD LOCKS space id 1716 page no 3 n bits 8 index PRIMARY of table `iam`.`qrtz_scheduler_state` trx id 1337417 lock_mode X locks gap before rec Record lock, heap no 4 PHYSICAL RECORD: n_fields 6; compact format; info bits 0 0: len 17; hex 5363686564756c65722d434c5553544552; asc Scheduler-CLUSTER;; 1: len 30; hex 7461636d656469756d317a746e613333762e6d786c2e73686a74322e7169; asc tacmedium1ztna33v.mxl.shjt2.qi; (total 55 bytes); 2: len 6; hex 000000000000; asc ;; 3: len 7; hex 80000000000000; asc ;; 4: len 8; hex 8000018b409854c8; asc @ T ;; 5: len 8; hex 8000000000001d4c; asc L;; *** WE ROLL BACK TRANSACTION (1) ------------ TRANSACTIONS ------------ Trx id counter 3569667 Purge done for trx's n:o < 1691005 undo n:o < 0 state: running History list length 572213 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION (0x7f52a3844480), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f52a37fd780), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f52a3843980), ACTIVE 122 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20720, OS thread handle 139988335879936, query id 27839212 127.0.0.1 admin Sending data SELECT count(c_id) from TD_DM_USER where c_isDelete=0 Trx read view will not see trx with id >= 3568226, sees < 3508622 ---TRANSACTION (0x7f52a3842e80), ACTIVE 182 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20719, OS thread handle 139988336187136, query id 27836065 127.0.0.1 admin Sending data SELECT count(c_id) from TD_DM_USER where c_isDelete=0 Trx read view will not see trx with id >= 3567524, sees < 3508622 ---TRANSACTION (0x7f52a3842380), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f52a3841880), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f52a3840d80), ACTIVE 242 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20710, OS thread handle 139988336801536, query id 27832994 127.0.0.1 admin Sending data SELECT count(c_id) from TD_DM_USER where c_isDelete=0 Trx read view will not see trx with id >= 3566840, sees < 3508622 ---TRANSACTION (0x7f52a3840280), ACTIVE 302 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20707, OS thread handle 139988339873536, query id 27829840 127.0.0.1 admin Sending data SELECT count(c_id) from TD_DM_USER where c_isDelete=0 Trx read view will not see trx with id >= 3566140, sees < 3508622 ---TRANSACTION (0x7f52a383f780), ACTIVE 482 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20704, OS thread handle 139988337415936, query id 27820318 127.0.0.1 admin Sending data SELECT count(c_id) from TD_DM_USER where c_isDelete=0 Trx read view will not see trx with id >= 3564023, sees < 3508622 ---TRANSACTION (0x7f52a37db180), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f52a383ec80), ACTIVE 362 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20684, OS thread handle 139984407467776, query id 27826629 127.0.0.1 admin Sending data SELECT count(c_id) from TD_DM_USER where c_isDelete=0 Trx read view will not see trx with id >= 3565424, sees < 3508622 ---TRANSACTION (0x7f52a383e180), ACTIVE 542 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20680, OS thread handle 139988337723136, query id 27817163 127.0.0.1 admin Sending data SELECT count(c_id) from TD_DM_USER where c_isDelete=0 Trx read view will not see trx with id >= 3563323, sees < 3508622 ---TRANSACTION (0x7f52a3827680), ACTIVE 422 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20677, OS thread handle 139988306179840, query id 27823468 127.0.0.1 admin Sending data SELECT count(c_id) from TD_DM_USER where c_isDelete=0 Trx read view will not see trx with id >= 3564723, sees < 3508622 ---TRANSACTION (0x7f52a37da680), ACTIVE 662 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20670, OS thread handle 139988295943936, query id 27810020 127.0.0.1 admin Sending data SELECT count(c_id) from TD_DM_USER where c_isDelete=0 Trx read view will not see trx with id >= 3561822, sees < 3508622 ---TRANSACTION (0x7f52a383d680), ACTIVE 842 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20666, OS thread handle 139988338030336, query id 27800611 127.0.0.1 admin Sending data SELECT count(c_id) from TD_DM_USER where c_isDelete=0 Trx read view will not see trx with id >= 3559734, sees < 3508622 ---TRANSACTION (0x7f52a383cb80), ACTIVE 782 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20662, OS thread handle 139988338644736, query id 27803676 127.0.0.1 admin Sending data SELECT count(c_id) from TD_DM_USER where c_isDelete=0 Trx read view will not see trx with id >= 3560418, sees < 3508622 ---TRANSACTION (0x7f52a383c080), ACTIVE 906 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20657, OS thread handle 139988338951936, query id 27797192 127.0.0.1 admin Sending data SELECT count(c_id) from TD_DM_USER where c_isDelete=0 Trx read view will not see trx with id >= 3558983, sees < 3508622 ---TRANSACTION (0x7f52a383b580), ACTIVE 722 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20656, OS thread handle 139988339259136, query id 27806838 127.0.0.1 admin Sending data SELECT count(c_id) from TD_DM_USER where c_isDelete=0 Trx read view will not see trx with id >= 3561118, sees < 3508622 ---TRANSACTION (0x7f52a383aa80), ACTIVE 1022 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20653, OS thread handle 139988340180736, query id 27790893 127.0.0.1 admin Sending data SELECT count(c_id) from TD_DM_USER where c_isDelete=0 Trx read view will not see trx with id >= 3557614, sees < 3508622 ---TRANSACTION (0x7f52a3839f80), ACTIVE 962 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20649, OS thread handle 139988342945536, query id 27794154 127.0.0.1 admin Sending data SELECT count(c_id) from TD_DM_USER where c_isDelete=0 Trx read view will not see trx with id >= 3558315, sees < 3508622 ---TRANSACTION (0x7f52a3839480), ACTIVE 1142 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20645, OS thread handle 139988339566336, query id 27784117 127.0.0.1 admin Sending data SELECT count(c_id) from TD_DM_USER where c_isDelete=0 Trx read view will not see trx with id >= 3556008, sees < 3508622 ---TRANSACTION (0x7f52a3838980), ACTIVE 602 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20627, OS thread handle 139984451802880, query id 27813236 127.0.0.1 admin Sending data SELECT count(c_id) from TD_DM_USER where c_isDelete=0 Trx read view will not see trx with id >= 3562538, sees < 3508622 ---TRANSACTION (0x7f52a3831080), ACTIVE 1202 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20624, OS thread handle 139988340487936, query id 27781589 127.0.0.1 admin Sending data SELECT count(c_id) from TD_DM_USER where c_isDelete=0 Trx read view will not see trx with id >= 3555454, sees < 3508622 ---TRANSACTION (0x7f52a3837e80), ACTIVE 1082 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20620, OS thread handle 139988341716736, query id 27787701 127.0.0.1 admin Sending data SELECT count(c_id) from TD_DM_USER where c_isDelete=0 Trx read view will not see trx with id >= 3556838, sees < 3508622 ---TRANSACTION (0x7f52a3836880), ACTIVE 1322 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20616, OS thread handle 139988341102336, query id 27775078 127.0.0.1 admin Sending data SELECT count(c_id) from TD_DM_USER where c_isDelete=0 Trx read view will not see trx with id >= 3553880, sees < 3508622 ---TRANSACTION (0x7f52a3837380), ACTIVE 1442 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20610, OS thread handle 139988340795136, query id 27768663 127.0.0.1 admin Sending data SELECT count(c_id) from TD_DM_USER where c_isDelete=0 Trx read view will not see trx with id >= 3552327, sees < 3508622 ---TRANSACTION (0x7f52a37ff880), ACTIVE 1164 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20606, OS thread handle 139988341409536, query id 27783578 127.0.0.1 admin Sending data SELECT count(c_id) from TD_DM_USER where c_isDelete=0 Trx read view will not see trx with id >= 3555936, sees < 3508622 ---TRANSACTION (0x7f52a3835d80), ACTIVE 1558 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20599, OS thread handle 139988342023936, query id 27762401 127.0.0.1 admin Sending data SELECT count(c_id) from TD_DM_USER where c_isDelete=0 Trx read view will not see trx with id >= 3550889, sees < 3508622 ---TRANSACTION (0x7f52a3835280), ACTIVE 1502 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20595, OS thread handle 139984452417280, query id 27765336 127.0.0.1 admin Sending data SELECT count(c_id) from TD_DM_USER where c_isDelete=0 Trx read view will not see trx with id >= 3551557, sees < 3508622 ---TRANSACTION (0x7f52a3834780), ACTIVE 1562 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20591, OS thread handle 139988297479936, query id 27761951 127.0.0.1 admin Sending data SELECT count(c_id) from TD_DM_USER where c_isDelete=0 Trx read view will not see trx with id >= 3550759, sees < 3508622 ---TRANSACTION (0x7f52a3833c80), ACTIVE 1622 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20589, OS thread handle 139984453338880, query id 27758499 127.0.0.1 admin Sending data SELECT count(c_id) from TD_DM_USER where c_isDelete=0 Trx read view will not see trx with id >= 3550075, sees < 3508622 ---TRANSACTION (0x7f52a3833180), ACTIVE 1262 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20586, OS thread handle 139988342331136, query id 27778300 127.0.0.1 admin Sending data SELECT count(c_id) from TD_DM_USER where c_isDelete=0 Trx read view will not see trx with id >= 3554656, sees < 3508622 ---TRANSACTION (0x7f52a3832680), ACTIVE 1640 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20583, OS thread handle 139988342638336, query id 27757473 127.0.0.1 admin Sending data SELECT count(c_id) from TD_DM_USER where c_isDelete=0 Trx read view will not see trx with id >= 3549831, sees < 3508622 ---TRANSACTION (0x7f52a3831b80), ACTIVE 1806 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20569, OS thread handle 139988343252736, query id 27748258 127.0.0.1 admin Sending data SELECT count(c_id) from TD_DM_USER where c_isDelete=0 Trx read view will not see trx with id >= 3547687, sees < 3508622 ---TRANSACTION (0x7f52a3830580), ACTIVE 1683 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20564, OS thread handle 139984410846976, query id 27755114 127.0.0.1 admin Sending data SELECT count(c_id) from TD_DM_USER where c_isDelete=0 Trx read view will not see trx with id >= 3549280, sees < 3508622 ---TRANSACTION (0x7f52a382fa80), ACTIVE 1926 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20560, OS thread handle 139984455489280, query id 27741251 127.0.0.1 admin Sending data SELECT count(c_id) from TD_DM_USER where c_isDelete=0 Trx read view will not see trx with id >= 3546103, sees < 3508622 ---TRANSACTION (0x7f52a382ef80), ACTIVE 1382 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20552, OS thread handle 139988292871936, query id 27771870 127.0.0.1 admin Sending data SELECT count(c_id) from TD_DM_USER where c_isDelete=0 Trx read view will not see trx with id >= 3553104, sees < 3508622 ---TRANSACTION (0x7f52a382e480), ACTIVE 1866 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20550, OS thread handle 139984444122880, query id 27744838 127.0.0.1 admin Sending data SELECT count(c_id) from TD_DM_USER where c_isDelete=0 Trx read view will not see trx with id >= 3546883, sees < 3508622 ---TRANSACTION (0x7f52a3828c80), ACTIVE 1995 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20549, OS thread handle 139984404088576, query id 27737366 127.0.0.1 admin Sending data SELECT count(c_id) from TD_DM_USER where c_isDelete=0 Trx read view will not see trx with id >= 3545227, sees < 3508622 ---TRANSACTION (0x7f52a3826b80), ACTIVE 1746 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20538, OS thread handle 139984453646080, query id 27751866 127.0.0.1 admin Sending data SELECT count(c_id) from TD_DM_USER where c_isDelete=0 Trx read view will not see trx with id >= 3548490, sees < 3508622 ---TRANSACTION (0x7f52a382d980), ACTIVE 2591 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20504, OS thread handle 139988288571136, query id 27705264 127.0.0.1 admin Sending data select count(*) from td_dm_user Trx read view will not see trx with id >= 3537561, sees < 3508622 ---TRANSACTION (0x7f52a382ce80), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f52a382c380), ACTIVE 1999 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20499, OS thread handle 139984451188480, query id 27737156 127.0.0.1 admin Sending data SELECT count(c_id) from TD_DM_USER where c_isDelete=0 Trx read view will not see trx with id >= 3545205, sees < 3508622 ---TRANSACTION (0x7f52a382b880), ACTIVE 2642 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20498, OS thread handle 139984403781376, query id 27702075 127.0.0.1 admin Sending data SELECT count(c_id) from TD_DM_USER where c_isDelete=0 Trx read view will not see trx with id >= 3536851, sees < 3508622 ---TRANSACTION (0x7f52a382ad80), ACTIVE 1998 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20497, OS thread handle 139984450266880, query id 27737180 127.0.0.1 admin Sending data SELECT count(c_id) from TD_DM_USER where c_isDelete=0 Trx read view will not see trx with id >= 3545205, sees < 3508622 ---TRANSACTION (0x7f52a382a280), ACTIVE 2005 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20495, OS thread handle 139984401938176, query id 27736774 127.0.0.1 admin Sending data SELECT count(c_id) from TD_DM_USER where c_isDelete=0 Trx read view will not see trx with id >= 3545145, sees < 3508622 ---TRANSACTION (0x7f52a3829780), ACTIVE 2472 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20491, OS thread handle 139984405624576, query id 27711661 127.0.0.1 admin Sending data SELECT count(c_id) from TD_DM_USER where c_isDelete=0 Trx read view will not see trx with id >= 3539124, sees < 3508622 ---TRANSACTION 3536936, ACTIVE 2635 sec inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20485, OS thread handle 139984458561280, query id 27702553 127.0.0.1 admin Update insert into TD_FRAMEWORK_MODEL_PROCESS_RECORD ( object_type,object_id,object_code,object_name,ou_orignal_path,ou_cur_path,object_detail,action,record_time ) values ( 'xxxxxxxxxxxxxxxxxxx', 'xxxxxxxxxxxxxxx', 'xxxxxxxxxxxxxxxxxx', 'ad-119', null, null, '{"attrs":{"path":"/xxxxxxxxxxxx","code":"xxxxxxxxxx","orderNo":100,"level":0,"mainOu":false,"name":"ad-119","description":"","id":"xxxxxxxxxxxxxxxxx"},"metaDataTypeID":"OU","relationContent":{},"relationId":"","results":[]}', 'UPDATE', now() ---TRANSACTION (0x7f52a381a580), ACTIVE 2664 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20479, OS thread handle 139988289185536, query id 27701215 127.0.0.1 admin Sending data SELECT count(c_id) from TD_DM_USER where c_isDelete=0 Trx read view will not see trx with id >= 3536725, sees < 3508622 ---TRANSACTION (0x7f52a3824a80), ACTIVE 2653 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20476, OS thread handle 139988286420736, query id 27701943 127.0.0.1 admin Sending data SELECT count(c_id) from TD_DM_USER where c_isDelete=0 Trx read view will not see trx with id >= 3536834, sees < 3508622 ---TRANSACTION (0x7f52a3826080), ACTIVE 2979 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20465, OS thread handle 139984415762176, query id 27683907 127.0.0.1 admin Sending data SELECT count(c_id) from TD_DM_USER where c_isDelete=0 Trx read view will not see trx with id >= 3532741, sees < 3508622 ---TRANSACTION (0x7f52a3825580), ACTIVE 2882 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20464, OS thread handle 139984455796480, query id 27687978 127.0.0.1 admin Sending data SELECT count(c_id) from TD_DM_USER where c_isDelete=0 Trx read view will not see trx with id >= 3533527, sees < 3508622 ---TRANSACTION (0x7f52a3823f80), ACTIVE 2983 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20461, OS thread handle 139992854046464, query id 27683511 127.0.0.1 admin Sending data SELECT count(c_id) from TD_DM_USER where c_isDelete=0 Trx read view will not see trx with id >= 3532631, sees < 3508622 ---TRANSACTION (0x7f52a3823480), ACTIVE 2983 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20459, OS thread handle 139984440436480, query id 27683631 127.0.0.1 admin Sending data SELECT count(c_id) from TD_DM_USER where c_isDelete=0 Trx read view will not see trx with id >= 3532648, sees < 3508622 ---TRANSACTION (0x7f52a3822980), ACTIVE 2983 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20456, OS thread handle 139984401630976, query id 27683484 127.0.0.1 admin Sending data SELECT count(c_id) from TD_DM_USER where c_isDelete=0 Trx read view will not see trx with id >= 3532631, sees < 3508622 ---TRANSACTION (0x7f52a3821e80), ACTIVE 2984 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20447, OS thread handle 139988293793536, query id 27683416 127.0.0.1 admin Sending data SELECT count(c_id) from TD_DM_USER where c_isDelete=0 Trx read view will not see trx with id >= 3532631, sees < 3508622 ---TRANSACTION (0x7f52a3821380), ACTIVE 3002 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20444, OS thread handle 139984412382976, query id 27682226 127.0.0.1 admin Sending data SELECT count(c_id) from TD_DM_USER where c_isDelete=0 Trx read view will not see trx with id >= 3532410, sees < 3508622 ---TRANSACTION 3531762, ACTIVE 3077 sec inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20443, OS thread handle 139992854660864, query id 27679053 127.0.0.1 admin Update insert into TD_FRAMEWORK_MODEL_PROCESS_RECORD ( object_type,object_id,object_code,object_name,ou_orignal_path,ou_cur_path,object_detail,action,record_time ) values ( 'xxxxxxxxxxxxxxxx', 'xxxxxxxxxxxxxx', 'xxxxxxxxxxxxxxxxx', 'ad-119', null, null, '{"attrs":{"path":"/xxxxxxxxxxxxxxxxxx","code":"xxxxxxxxxxxxxxx","orderNo":100,"level":0,"mainOu":false,"name":"xxxxxxx-xxxxxxx","description":"","id":"xxxxxxxx"},"metaDataTypeID":"OU","relationContent":{},"relationId":"","results":[]}', 'UPDATE', now() ---TRANSACTION (0x7f52a381fd80), ACTIVE 3062 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20442, OS thread handle 139988295329536, query id 27679772 127.0.0.1 admin Sending data SELECT count(c_id) from TD_DM_USER where c_isDelete=0 Trx read view will not see trx with id >= 3531940, sees < 3508622 ---TRANSACTION (0x7f52a381f280), ACTIVE 3085 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20437, OS thread handle 139984452110080, query id 27678744 127.0.0.1 admin Sending data SELECT count(c_id) from TD_DM_USER where c_isDelete=0 Trx read view will not see trx with id >= 3531720, sees < 3508622 ---TRANSACTION (0x7f52a381e780), ACTIVE 3121 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20435, OS thread handle 139984453031680, query id 27677179 127.0.0.1 admin Sending data SELECT count(c_id) from TD_DM_USER where c_isDelete=0 Trx read view will not see trx with id >= 3531408, sees < 3508622 ---TRANSACTION (0x7f52a381dc80), ACTIVE 3096 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20434, OS thread handle 139984451495680, query id 27678175 127.0.0.1 admin Sending data SELECT count(c_id) from TD_DM_USER where c_isDelete=0 Trx read view will not see trx with id >= 3531644, sees < 3508622 ---TRANSACTION (0x7f52a381d180), ACTIVE 2984 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20429, OS thread handle 139992854353664, query id 27683333 127.0.0.1 admin Sending data SELECT count(c_id) from TD_DM_USER where c_isDelete=0 Trx read view will not see trx with id >= 3532631, sees < 3508622 ---TRANSACTION (0x7f52a3800e80), ACTIVE 3182 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20424, OS thread handle 139984459175680, query id 27674705 127.0.0.1 admin Sending data SELECT count(c_id) from TD_DM_USER where c_isDelete=0 Trx read view will not see trx with id >= 3530902, sees < 3508622 ---TRANSACTION (0x7f52a381c680), ACTIVE 3242 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20420, OS thread handle 139988306487040, query id 27672196 127.0.0.1 admin Sending data SELECT count(c_id) from TD_DM_USER where c_isDelete=0 Trx read view will not see trx with id >= 3530355, sees < 3508622 ---TRANSACTION (0x7f52a381bb80), ACTIVE 3302 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20417, OS thread handle 139984450574080, query id 27669558 127.0.0.1 admin Sending data SELECT count(c_id) from TD_DM_USER where c_isDelete=0 Trx read view will not see trx with id >= 3529802, sees < 3508622 ---TRANSACTION (0x7f52a381b080), ACTIVE 3362 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20413, OS thread handle 139984405010176, query id 27666989 127.0.0.1 admin Sending data SELECT count(c_id) from TD_DM_USER where c_isDelete=0 Trx read view will not see trx with id >= 3529242, sees < 3508622 ---TRANSACTION (0x7f52a3819a80), ACTIVE 3122 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20411, OS thread handle 139984411461376, query id 27677057 127.0.0.1 admin Sending data SELECT count(c_id) from TD_DM_USER where c_isDelete=0 Trx read view will not see trx with id >= 3531408, sees < 3508622 ---TRANSACTION (0x7f52a3818f80), ACTIVE 3422 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20408, OS thread handle 139988293179136, query id 27664461 127.0.0.1 admin Sending data SELECT count(c_id) from TD_DM_USER where c_isDelete=0 Trx read view will not see trx with id >= 3528696, sees < 3508622 ---TRANSACTION (0x7f52a3818480), ACTIVE 3453 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20407, OS thread handle 139984440743680, query id 27663252 127.0.0.1 admin Sending data SELECT count(c_id) from TD_DM_USER where c_isDelete=0 Trx read view will not see trx with id >= 3528497, sees < 3508622 ---TRANSACTION (0x7f52a37fc180), ACTIVE 3454 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20404, OS thread handle 139988291028736, query id 27663249 127.0.0.1 admin Sending data SELECT count(c_id) from TD_DM_USER where c_isDelete=0 Trx read view will not see trx with id >= 3528497, sees < 3508622 ---TRANSACTION 3528537, ACTIVE 3446 sec inserting mysql tables in use 1, locked 1 2 lock struct(s), heap size 1128, 0 row lock(s), undo log entries 1 MariaDB thread id 20401, OS thread handle 139984459790080, query id 27663536 127.0.0.1 admin Update insert into TD_FRAMEWORK_MODEL_PROCESS_RECORD ( object_type,object_id,object_code,object_name,ou_orignal_path,ou_cur_path,object_detail,action,record_time ) values ( 'xxxxxxxxxxx', 'xxxxxxxxxxxxx', 'xxxxxxxxxxxx', 'test', null, null, '{"attrs":{"code":"xxxxxxxxxxxxxx","orderNo":100,"level":0,"isDelete":false,"creatorName":"admin","description":"","updateTime":45653452456,"path":"/xxxxxxxxx","createTime":1697620347843,"sourceType":"xxxxxxxxx","mainOu":false,"name":"test","identitySourceType Trx read view will not see trx with id >= 3528537, sees < 3508622 ---TRANSACTION (0x7f52a3816e80), ACTIVE 3472 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20399, OS thread handle 139988298401536, query id 27661897 127.0.0.1 admin Sending data SELECT count(c_id) from TD_DM_USER where c_isDelete=0 Trx read view will not see trx with id >= 3528207, sees < 3508622 ---TRANSACTION (0x7f52a3816380), ACTIVE 3473 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20398, OS thread handle 139984456718080, query id 27661751 127.0.0.1 admin Sending data SELECT count(c_id) from TD_DM_USER where c_isDelete=0 Trx read view will not see trx with id >= 3528207, sees < 3508622 ---TRANSACTION (0x7f52a3815880), ACTIVE 3473 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20397, OS thread handle 139988294100736, query id 27661653 127.0.0.1 admin Sending data SELECT count(c_id) from TD_DM_USER where c_isDelete=0 Trx read view will not see trx with id >= 3528188, sees < 3508622 ---TRANSACTION (0x7f52a3814d80), ACTIVE 3474 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20395, OS thread handle 139984416376576, query id 27661601 127.0.0.1 admin Sending data SELECT count(c_id) from TD_DM_USER where c_isDelete=0 Trx read view will not see trx with id >= 3528188, sees < 3508622 ---TRANSACTION (0x7f52a3814280), ACTIVE 3475 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20393, OS thread handle 139988292564736, query id 27661537 127.0.0.1 admin Sending data SELECT count(c_id) from TD_DM_USER where c_isDelete=0 Trx read view will not see trx with id >= 3528188, sees < 3508622 ---TRANSACTION (0x7f52a3813780), ACTIVE 3475 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20391, OS thread handle 139984410232576, query id 27661582 127.0.0.1 admin Sending data SELECT count(c_id) from TD_DM_USER where c_isDelete=0 Trx read view will not see trx with id >= 3528188, sees < 3508622 ---TRANSACTION (0x7f52a3812c80), ACTIVE 3477 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20390, OS thread handle 139988291335936, query id 27661385 127.0.0.1 admin Sending data SELECT count(c_id) from TD_DM_USER where c_isDelete=0 Trx read view will not see trx with id >= 3528169, sees < 3508622 ---TRANSACTION (0x7f52a3812180), ACTIVE 3476 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20389, OS thread handle 139984412690176, query id 27661504 127.0.0.1 admin Sending data SELECT count(c_id) from TD_DM_USER where c_isDelete=0 Trx read view will not see trx with id >= 3528188, sees < 3508622 ---TRANSACTION (0x7f52a3811680), ACTIVE 3478 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20387, OS thread handle 139984417298176, query id 27661361 127.0.0.1 admin Sending data SELECT count(c_id) from TD_DM_USER where c_isDelete=0 Trx read view will not see trx with id >= 3528167, sees < 3508622 ---TRANSACTION (0x7f52a3810b80), ACTIVE 3479 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20386, OS thread handle 139984456103680, query id 27661241 127.0.0.1 admin Sending data SELECT count(c_id) from TD_DM_USER where c_isDelete=0 Trx read view will not see trx with id >= 3528148, sees < 3508622 ---TRANSACTION (0x7f52a3810080), ACTIVE 3480 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20385, OS thread handle 139988291950336, query id 27661230 127.0.0.1 admin Sending data SELECT count(c_id) from TD_DM_USER where c_isDelete=0 Trx read view will not see trx with id >= 3528148, sees < 3508622 ---TRANSACTION (0x7f52a380f580), ACTIVE 3481 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20383, OS thread handle 139984407160576, query id 27661215 127.0.0.1 admin Sending data SELECT count(c_id) from TD_DM_USER where c_isDelete=0 Trx read view will not see trx with id >= 3528148, sees < 3508622 ---TRANSACTION (0x7f52a380ea80), ACTIVE 3484 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20381, OS thread handle 139988291643136, query id 27660985 127.0.0.1 admin Sending data SELECT count(c_id) from TD_DM_USER where c_isDelete=0 Trx read view will not see trx with id >= 3528131, sees < 3508622 ---TRANSACTION (0x7f52a380df80), ACTIVE 3485 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20380, OS thread handle 139988288878336, query id 27660885 127.0.0.1 admin Sending data SELECT count(c_id) from TD_DM_USER where c_isDelete=0 Trx read view will not see trx with id >= 3528125, sees < 3508622 ---TRANSACTION (0x7f52a380d480), ACTIVE 3484 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20378, OS thread handle 139984426514176, query id 27661030 127.0.0.1 admin Sending data SELECT count(c_id) from TD_DM_USER where c_isDelete=0 Trx read view will not see trx with id >= 3528131, sees < 3508622 ---TRANSACTION (0x7f52a380c980), ACTIVE 3487 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20377, OS thread handle 139988287342336, query id 27660765 127.0.0.1 admin Sending data SELECT count(c_id) from TD_DM_USER where c_isDelete=0 Trx read view will not see trx with id >= 3528108, sees < 3508622 ---TRANSACTION (0x7f52a380be80), ACTIVE 3487 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20375, OS thread handle 139992853432064, query id 27660754 127.0.0.1 admin Sending data SELECT count(c_id) from TD_DM_USER where c_isDelete=0 Trx read view will not see trx with id >= 3528108, sees < 3508622 ---TRANSACTION (0x7f52a380b380), ACTIVE 3488 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20374, OS thread handle 139988419593984, query id 27660636 127.0.0.1 admin Sending data SELECT count(c_id) from TD_DM_USER where c_isDelete=0 Trx read view will not see trx with id >= 3528091, sees < 3508622 ---TRANSACTION (0x7f52a380a880), ACTIVE 3489 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20371, OS thread handle 139984416069376, query id 27660625 127.0.0.1 admin Sending data SELECT count(c_id) from TD_DM_USER where c_isDelete=0 Trx read view will not see trx with id >= 3528091, sees < 3508622 ---TRANSACTION (0x7f52a3809d80), ACTIVE 3497 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20370, OS thread handle 139984408082176, query id 27660208 127.0.0.1 admin Sending data SELECT count(c_id) from TD_DM_USER where c_isDelete=0 Trx read view will not see trx with id >= 3528032, sees < 3508622 ---TRANSACTION (0x7f52a37f8a80), ACTIVE 3490 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20369, OS thread handle 139984415454976, query id 27660578 127.0.0.1 admin Sending data SELECT count(c_id) from TD_DM_USER where c_isDelete=0 Trx read view will not see trx with id >= 3528091, sees < 3508622 ---TRANSACTION (0x7f52a3809280), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f52a3808780), ACTIVE 3502 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20366, OS thread handle 139988286727936, query id 27659951 127.0.0.1 admin Sending data SELECT count(c_id) from TD_DM_USER where c_isDelete=0 Trx read view will not see trx with id >= 3528009, sees < 3508622 ---TRANSACTION (0x7f52a3800380), ACTIVE 3530 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20364, OS thread handle 139984439514880, query id 27658710 127.0.0.1 admin Sending data SELECT count(c_id) from TD_DM_USER where c_isDelete=0 Trx read view will not see trx with id >= 3527678, sees < 3508622 ---TRANSACTION (0x7f52a3807c80), ACTIVE 3519 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20363, OS thread handle 139984414840576, query id 27659254 127.0.0.1 admin Sending data SELECT count(c_id) from TD_DM_USER where c_isDelete=0 Trx read view will not see trx with id >= 3527893, sees < 3508622 ---TRANSACTION (0x7f52a3807180), ACTIVE 3572 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20355, OS thread handle 139984414533376, query id 27656589 127.0.0.1 admin Sending data SELECT count(c_id) from TD_DM_USER where c_isDelete=0 Trx read view will not see trx with id >= 3527344, sees < 3508622 ---TRANSACTION (0x7f52a3806680), ACTIVE 3579 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20332, OS thread handle 139988305258240, query id 27656408 127.0.0.1 admin Sending data SELECT count(c_id) from TD_DM_USER where c_isDelete=0 Trx read view will not see trx with id >= 3527338, sees < 3508622 ---TRANSACTION 3527482, ACTIVE 3555 sec inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 1128, 0 row lock(s), undo log entries 1 MariaDB thread id 20327, OS thread handle 139984452724480, query id 27657471 127.0.0.1 admin Update INSERT IGNORE INTO TD_DM_USER(c_ouId,c_code,c_psw,c_pswGenerate,c_name,c_labels,c_status,c_orderNo,c_pswStatus,c_createType,c_startTime,c_endTime,c_isPredefined,c_isMaster,c_id,c_psw_info,c_offset,c_pswUpdateTime,c_sourceType,c_updaterName,c_creatorName,c_updateTime,c_createTime,c_isDelete,c_validTime) values ('local','xxx','xxxxxxxxxxxxxxxxxxx','manual','bb','[]','ENABLE',100,'init','manual',null,null,0,1,'xxxxxxxxxxxxxxxxxxxxx','{"historyEncryptAlgorithm":"xxxxxxxxxxxxxxxxxxx","historyPsws":["xxxxxxxxxxxxxx/xxxxxxxxxxxxxxxxx+1 Trx read view will not see trx with id >= 3527482, sees < 3508622 ---TRANSACTION (0x7f52a3805080), ACTIVE 3640 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20312, OS thread handle 139988296251136, query id 27653326 127.0.0.1 admin Sending data SELECT count(c_id) from TD_DM_USER where c_isDelete=0 Trx read view will not see trx with id >= 3526779, sees < 3508622 ---TRANSACTION (0x7f52a3804580), ACTIVE 3699 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20297, OS thread handle 139988287649536, query id 27650672 127.0.0.1 admin Sending data SELECT count(c_id) from TD_DM_USER where c_isDelete=0 Trx read view will not see trx with id >= 3526233, sees < 3508622 ---TRANSACTION (0x7f52a3803a80), ACTIVE 3759 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20282, OS thread handle 139984401323776, query id 27647981 127.0.0.1 admin Sending data SELECT count(c_id) from TD_DM_USER where c_isDelete=0 Trx read view will not see trx with id >= 3525679, sees < 3508622 ---TRANSACTION (0x7f52a3802f80), ACTIVE 3765 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20281, OS thread handle 139988288263936, query id 27647683 127.0.0.1 admin Sending data select t0.c_id as t0___id from TD_DM_USER t0 where t0.c_isDelete = 0 limit 999999 offset 0 Trx read view will not see trx with id >= 3525579, sees < 3508622 ---TRANSACTION (0x7f52a3802480), ACTIVE 3819 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20280, OS thread handle 139988286113536, query id 27643964 127.0.0.1 admin Sending data SELECT count(c_id) from TD_DM_USER where c_isDelete=0 Trx read view will not see trx with id >= 3525100, sees < 3508622 ---TRANSACTION (0x7f52a3801980), ACTIVE 3619 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20272, OS thread handle 139984453953280, query id 27654274 127.0.0.1 admin Sending data SELECT count(c_id) from TD_DM_USER where c_isDelete=0 Trx read view will not see trx with id >= 3526916, sees < 3508622 ---TRANSACTION (0x7f52a37fed80), ACTIVE 3843 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20261, OS thread handle 139988297172736, query id 27642829 127.0.0.1 admin Sending data select t0.c_id as t0___id from TD_DM_USER t0 where t0.c_isDelete = 0 limit 999999 offset 0 Trx read view will not see trx with id >= 3524860, sees < 3508622 ---TRANSACTION (0x7f52a37fe280), ACTIVE 3819 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20246, OS thread handle 139988295636736, query id 27643933 127.0.0.1 admin Sending data SELECT count(c_id) from TD_DM_USER where c_isDelete=0 Trx read view will not see trx with id >= 3525100, sees < 3508622 ---TRANSACTION (0x7f52a37fcc80), ACTIVE 4000 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20243, OS thread handle 139988289799936, query id 27634895 127.0.0.1 admin Sending data SELECT count(c_id) from TD_DM_USER where c_isDelete=0 Trx read view will not see trx with id >= 3523450, sees < 3508622 ---TRANSACTION (0x7f52a37fab80), ACTIVE 3879 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20237, OS thread handle 139988296865536, query id 27639882 127.0.0.1 admin Sending data SELECT count(c_id) from TD_DM_USER where c_isDelete=0 Trx read view will not see trx with id >= 3524509, sees < 3508622 ---TRANSACTION (0x7f52a37fb680), ACTIVE 4060 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20233, OS thread handle 139984413918976, query id 27632351 127.0.0.1 admin Sending data SELECT count(c_id) from TD_DM_USER where c_isDelete=0 Trx read view will not see trx with id >= 3522904, sees < 3508622 ---TRANSACTION (0x7f52a37fa080), ACTIVE 4069 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20232, OS thread handle 139984458868480, query id 27631920 127.0.0.1 admin Sending data SELECT count(c_id) from TD_DM_USER where c_isDelete=0 Trx read view will not see trx with id >= 3522771, sees < 3508622 ---TRANSACTION (0x7f52a37f9580), ACTIVE 3939 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20231, OS thread handle 139988294715136, query id 27637262 127.0.0.1 admin Sending data SELECT count(c_id) from TD_DM_USER where c_isDelete=0 Trx read view will not see trx with id >= 3523962, sees < 3508622 ---TRANSACTION (0x7f52a37dd280), ACTIVE 4075 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20224, OS thread handle 139988289492736, query id 27631533 127.0.0.1 admin Sending data SELECT count(c_id) from TD_DM_USER where c_isDelete=0 Trx read view will not see trx with id >= 3522731, sees < 3508622 ---TRANSACTION (0x7f52a37f7f80), ACTIVE 4119 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20215, OS thread handle 139988298094336, query id 27629613 127.0.0.1 admin Sending data SELECT count(c_id) from TD_DM_USER where c_isDelete=0 Trx read view will not see trx with id >= 3522359, sees < 3508622 ---TRANSACTION (0x7f52a37f7480), ACTIVE 4239 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20214, OS thread handle 139984412997376, query id 27624293 127.0.0.1 admin Sending data SELECT count(c_id) from TD_DM_USER where c_isDelete=0 Trx read view will not see trx with id >= 3521335, sees < 3508622 ---TRANSACTION 3520810, ACTIVE 4295 sec inserting mysql tables in use 1, locked 1 2 lock struct(s), heap size 1128, 0 row lock(s), undo log entries 1 MariaDB thread id 20211, OS thread handle 139984454260480, query id 27621874 127.0.0.1 admin Update insert into TD_FRAMEWORK_MODEL_PROCESS_RECORD ( object_type,object_id,object_code,object_name,ou_orignal_path,ou_cur_path,object_detail,action,record_time ) values ( 'xxxxxxxxxx', 'xxxxxxxxxxx', 'xxxxxxxxxxx', 'sssssss', null, null, '{"attrs":{"code":"xxxxxxxxxxxxxx","orderNo":100,"level":0,"isDelete":false,"creatorName":"admin","description":"","updateTime":34552345346,"path":"/xxxxxxxxxx","createTime":2354234534,"sourceType":"xxxxxxxxx","mainOu":false,"name":"sssssss","id Trx read view will not see trx with id >= 3520810, sees < 3508622 ---TRANSACTION (0x7f52a37f5e80), ACTIVE 4179 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20210, OS thread handle 139984406238976, query id 27627091 127.0.0.1 admin Sending data SELECT count(c_id) from TD_DM_USER where c_isDelete=0 Trx read view will not see trx with id >= 3521830, sees < 3508622 ---TRANSACTION (0x7f52a37f5380), ACTIVE 4299 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20208, OS thread handle 139988285806336, query id 27621750 127.0.0.1 admin Sending data SELECT count(c_id) from TD_DM_USER where c_isDelete=0 Trx read view will not see trx with id >= 3520788, sees < 3508622 ---TRANSACTION (0x7f52a37f4880), ACTIVE 4305 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20205, OS thread handle 139988293486336, query id 27621395 127.0.0.1 admin Sending data SELECT count(c_id) from TD_DM_USER where c_isDelete=0 Trx read view will not see trx with id >= 3520672, sees < 3508622 ---TRANSACTION (0x7f52a37f3d80), ACTIVE 4306 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20202, OS thread handle 139984402245376, query id 27621391 127.0.0.1 admin Sending data SELECT count(c_id) from TD_DM_USER where c_isDelete=0 Trx read view will not see trx with id >= 3520671, sees < 3508622 ---TRANSACTION (0x7f52a37f3280), ACTIVE 4359 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20198, OS thread handle 139984454874880, query id 27619135 127.0.0.1 admin Sending data SELECT count(c_id) from TD_DM_USER where c_isDelete=0 Trx read view will not see trx with id >= 3520242, sees < 3508622 ---TRANSACTION (0x7f52a37f2780), ACTIVE 4419 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20195, OS thread handle 139984450881280, query id 27616602 127.0.0.1 admin Sending data SELECT count(c_id) from TD_DM_USER where c_isDelete=0 Trx read view will not see trx with id >= 3519695, sees < 3508622 ---TRANSACTION (0x7f52a37f1c80), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f52a37f1180), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f52a37f0680), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f52a37efb80), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f52a37ef080), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f52a37ee580), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f52a37eda80), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f52a37ecf80), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f52a37ec480), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f52a37eb980), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f52a37eae80), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f52a37e9880), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f52a37ea380), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f52a37e8d80), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f52a37e8280), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f52a37e7780), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f52a37de880), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f52a37e6180), ACTIVE 4600 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20074, OS thread handle 139984449959680, query id 27608815 127.0.0.1 admin Sending data SELECT count(c_id) from TD_DM_USER where c_isDelete=0 Trx read view will not see trx with id >= 3518047, sees < 3508622 ---TRANSACTION (0x7f52a37dc780), ACTIVE 4855 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20073, OS thread handle 139984402859776, query id 27597200 127.0.0.1 admin Sending data SELECT count(c_id) from TD_DM_USER where c_isDelete=0 Trx read view will not see trx with id >= 3515664, sees < 3508622 ---TRANSACTION (0x7f52a37e5680), ACTIVE 4696 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20063, OS thread handle 139984455182080, query id 27604722 127.0.0.1 admin Sending data SELECT count(c_id) from TD_DM_USER where c_isDelete=0 Trx read view will not see trx with id >= 3517187, sees < 3508622 ---TRANSACTION (0x7f52a37e4b80), ACTIVE 4539 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20062, OS thread handle 139984406853376, query id 27611489 127.0.0.1 admin Sending data SELECT count(c_id) from TD_DM_USER where c_isDelete=0 Trx read view will not see trx with id >= 3518595, sees < 3508622 ---TRANSACTION (0x7f52a37e4080), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f52a37e3580), ACTIVE 4720 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20047, OS thread handle 139988290721536, query id 27603596 127.0.0.1 admin Sending data SELECT count(c_id) from TD_DM_USER where c_isDelete=0 Trx read view will not see trx with id >= 3516953, sees < 3508622 ---TRANSACTION 3508622, ACTIVE 5640 sec inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 1128, 0 row lock(s), undo log entries 8 MariaDB thread id 20046, OS thread handle 139984416683776, query id 27286166 127.0.0.1 admin Update INSERT IGNORE INTO TD_DM_USER(c_code,c_creatorName,c_description,c_sourceUniqueID,c_createType,c_psw_info,c_ouId,c_psw,c_isMaster,c_startTime,c_id,c_sourceID,c_isPredefined,c_orderNo,c_offset,c_isDelete,c_pswStatus,c_updateTime,c_createTime,c_sourceType,c_pswGenerate,c_pswUpdateTime,c_name,c_updaterName,c_validTime,c_endTime,c_status) values ('xxxxxxxxxxxxxxxxxxx','admin','xxxxxxxxxxxxxxxxxxxx','xxxxxxxxxxxxx','sync','{"historyEncryptAlgorithm":"xxxxxxxxxx","historyPsws":["xxxxxxxx+xxxxxxxxxxxxxxx+xxxxxxxxx+xxxxxxxxxxx/xxxxxxxx/xxxxxxxxxxxxxxxxxxxx Trx read view will not see trx with id >= 3508622, sees < 3508622 ---TRANSACTION (0x7f52a37e1f80), ACTIVE 4699 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20045, OS thread handle 139984412075776, query id 27604548 127.0.0.1 admin Sending data SELECT count(c_id) from TD_DM_USER where c_isDelete=0 Trx read view will not see trx with id >= 3517170, sees < 3508622 ---TRANSACTION 3515856, ACTIVE 4838 sec inserting mysql tables in use 1, locked 1 2 lock struct(s), heap size 1128, 0 row lock(s), undo log entries 1 MariaDB thread id 20044, OS thread handle 139984456410880, query id 27597917 127.0.0.1 admin Update insert into TD_FRAMEWORK_MODEL_PROCESS_RECORD ( object_type,object_id,object_code,object_name,ou_orignal_path,ou_cur_path,object_detail,action,record_time ) values ( 'xxxxxxxxxxx', 'xxxxxxxxxxx', 'xxxxxxxxxxxxxxx', 'xxxxxxxxxxxx', null, null, '{"attrs":{"code":"xxxxxxxxxxxxxx","orderNo":100,"level":0,"isDelete":false,"creatorName":"admin","description":"","updateTime":xxxxxxxxxxxxx,"path":"/xxxxxxxxxxxxxx","createTime":1697618955627,"sourceType":"xxxxxxxxxxxx","mainOu":false,"name":"xxxxxxxxxxxx","id Trx read view will not see trx with id >= 3515856, sees < 3508622 ---TRANSACTION (0x7f52a37df380), ACTIVE 4660 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20043, OS thread handle 139984459482880, query id 27606299 127.0.0.1 admin Sending data SELECT count(c_id) from TD_DM_USER where c_isDelete=0 Trx read view will not see trx with id >= 3517501, sees < 3508622 ---TRANSACTION 3517229, ACTIVE 4688 sec inserting mysql tables in use 1, locked 1 2 lock struct(s), heap size 1128, 0 row lock(s), undo log entries 1 MariaDB thread id 20034, OS thread handle 139984403474176, query id 27605009 127.0.0.1 admin Update insert into TD_FRAMEWORK_MODEL_PROCESS_RECORD ( object_type,object_id,object_code,object_name,ou_orignal_path,ou_cur_path,object_detail,action,record_time ) values ( 'xxxxxxxxxxxx', 'xxxxxxxxxxx', 'xxxxxxxxx', 'xxxxxxxxxxx', null, null, '{"attrs":{"code":"xxxxxxxxxxxxxxxxxxxxx","orderNo":100,"level":0,"isDelete":false,"creatorName":"admin","description":"","updateTime":123423452,"path":"/zvcegOKB8ZWguebo","createTime":32453456,"sourceType":"xxxxxxxxxxxxx","mainOu":false,"name":"xxxxxxxxxx","id Trx read view will not see trx with id >= 3517229, sees < 3508622 ---TRANSACTION (0x7f52a37dbc80), ACTIVE 4779 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 20012, OS thread handle 139988290414336, query id 27600647 127.0.0.1 admin Sending data SELECT count(c_id) from TD_DM_USER where c_isDelete=0 Trx read view will not see trx with id >= 3516405, sees < 3508622 ---TRANSACTION (0x7f52a37dfe80), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f52a37e0980), ACTIVE 4480 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 19092, OS thread handle 139984457946880, query id 27614031 127.0.0.1 admin Sending data SELECT count(c_id) from TD_DM_USER where c_isDelete=0 Trx read view will not see trx with id >= 3519147, sees < 3508622 ---TRANSACTION (0x7f52a37e6c80), ACTIVE 4695 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 19065, OS thread handle 139984445966080, query id 27604803 127.0.0.1 admin Sending data SELECT count(c_id) from TD_DM_USER where c_isDelete=0 Trx read view will not see trx with id >= 3517188, sees < 3508622 ---TRANSACTION (0x7f52a37d9b80), not started 0 lock struct(s), heap size 1128, 0 row lock(s) -------- FILE I/O -------- Pending flushes (fsync) log: 0; buffer pool: 0 186 OS file reads, 1964195 OS file writes, 86730 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 5.63 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 0, seg size 2, 0 merges merged operations: insert 0, delete mark 0, delete 0 discarded operations: insert 0, delete mark 0, delete 0 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 3068917311 Log flushed up to 2265878877 Pages flushed up to 1523778135 Last checkpoint at 1523778135 0 pending log flushes, 0 pending chkp writes 1937516 log i/o's done, 5.63 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total large memory allocated 4328521728 Dictionary memory allocated 27627432 Buffer pool size 259584 Free buffers 149027 Database pages 110557 Old database pages 40791 Modified db pages 97856 Percent of dirty pages(LRU & free pages): 37.697 Max dirty pages percent: 90.000 Pending reads 0 Pending writes: LRU 0, flush list 1 Pages made young 28279, not young 0 0.11 youngs/s, 0.00 non-youngs/s Pages read 171, created 147589, written 26675 0.00 reads/s, 0.21 creates/s, 0.00 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 110557, unzip_LRU len: 0 I/O sum[0]:cur[26931], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 127 read views open inside InnoDB Process ID=0, Main thread ID=0, state: sleeping Number of rows inserted 5269299, updated 409606, deleted 312130, read 323633362 1.06 inserts/s, 2.76 updates/s, 0.36 deletes/s, 1656.05 reads/s Number of system rows inserted 42257, updated 0, deleted 42050, read 42885 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ 1 row in set (0.001 sec)