========= show engine innodb status *************************** 1. row *************************** Type: InnoDB Name: Status: ===================================== 2021-03-07 14:43:55 0x7f596c4d4700 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 15 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 9668992 srv_active, 0 srv_shutdown, 52375 srv_idle srv_master_thread log flush and writes: 9717840 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 9378986672 --Thread 139956104328960 has waited at row0ins.cc line 1982 for 49.00 seconds the semaphore: S-lock on RW-latch at 0x55865ee04de0 created in file dict0dict.cc line 920 a writer (thread id 139953379993344) has reserved it in mode wait exclusive number of readers 4, waiters flag 1, lock_word: fffffffc Last time write locked in file srv0srv.cc line 2029 --Thread 139956114601728 has waited at row0ins.cc line 1982 for 73.00 seconds the semaphore: S-lock on RW-latch at 0x55865ee04de0 created in file dict0dict.cc line 920 a writer (thread id 139953379993344) has reserved it in mode wait exclusive number of readers 4, waiters flag 1, lock_word: fffffffc Last time write locked in file srv0srv.cc line 2029 --Thread 139955999954688 has waited at row0mysql.cc line 1795 for 154.00 seconds the semaphore: S-lock on RW-latch at 0x55865ee04de0 created in file dict0dict.cc line 920 a writer (thread id 139953379993344) has reserved it in mode wait exclusive number of readers 4, waiters flag 1, lock_word: fffffffc Last time write locked in file srv0srv.cc line 2029 --Thread 139956078376704 has waited at row0ins.cc line 1982 for 34.00 seconds the semaphore: S-lock on RW-latch at 0x55865ee04de0 created in file dict0dict.cc line 920 a writer (thread id 139953379993344) has reserved it in mode wait exclusive number of readers 4, waiters flag 1, lock_word: fffffffc Last time write locked in file srv0srv.cc line 2029 --Thread 139956063778560 has waited at row0ins.cc line 1982 for 157.00 seconds the semaphore: S-lock on RW-latch at 0x55865ee04de0 created in file dict0dict.cc line 920 a writer (thread id 139953379993344) has reserved it in mode wait exclusive number of readers 4, waiters flag 1, lock_word: fffffffc Last time write locked in file srv0srv.cc line 2029 --Thread 139954996066048 has waited at btr0cur.cc line 1357 for 192.00 seconds the semaphore: SX-lock on RW-latch at 0x7f49c0010830 created in file dict0dict.cc line 2130 a writer (thread id 139955038029568) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time write locked in file dict0stats.cc line 1969 --Thread 139956092974848 has waited at row0upd.cc line 181 for 36.00 seconds the semaphore: S-lock on RW-latch at 0x55865ee04de0 created in file dict0dict.cc line 920 a writer (thread id 139953379993344) has reserved it in mode wait exclusive number of readers 4, waiters flag 1, lock_word: fffffffc Last time write locked in file srv0srv.cc line 2029 --Thread 139956074051328 has waited at row0mysql.cc line 1795 for 165.00 seconds the semaphore: S-lock on RW-latch at 0x55865ee04de0 created in file dict0dict.cc line 920 a writer (thread id 139953379993344) has reserved it in mode wait exclusive number of readers 4, waiters flag 1, lock_word: fffffffc Last time write locked in file srv0srv.cc line 2029 --Thread 139956074592000 has waited at row0mysql.cc line 1795 for 20.00 seconds the semaphore: S-lock on RW-latch at 0x55865ee04de0 created in file dict0dict.cc line 920 a writer (thread id 139953379993344) has reserved it in mode wait exclusive number of readers 4, waiters flag 1, lock_word: fffffffc Last time write locked in file srv0srv.cc line 2029 --Thread 139956079998720 has waited at row0upd.cc line 181 for 71.00 seconds the semaphore: S-lock on RW-latch at 0x55865ee04de0 created in file dict0dict.cc line 920 a writer (thread id 139953379993344) has reserved it in mode wait exclusive number of readers 4, waiters flag 1, lock_word: fffffffc Last time write locked in file srv0srv.cc line 2029 --Thread 139954594662144 has waited at row0mysql.cc line 1795 for 44.00 seconds the semaphore: S-lock on RW-latch at 0x55865ee04de0 created in file dict0dict.cc line 920 a writer (thread id 139953379993344) has reserved it in mode wait exclusive number of readers 4, waiters flag 1, lock_word: fffffffc Last time write locked in file srv0srv.cc line 2029 --Thread 139956071077632 has waited at row0upd.cc line 181 for 30.00 seconds the semaphore: S-lock on RW-latch at 0x55865ee04de0 created in file dict0dict.cc line 920 a writer (thread id 139953379993344) has reserved it in mode wait exclusive number of readers 4, waiters flag 1, lock_word: fffffffc Last time write locked in file srv0srv.cc line 2029 --Thread 139956092704512 has waited at row0upd.cc line 181 for 136.00 seconds the semaphore: S-lock on RW-latch at 0x55865ee04de0 created in file dict0dict.cc line 920 a writer (thread id 139953379993344) has reserved it in mode wait exclusive number of readers 4, waiters flag 1, lock_word: fffffffc Last time write locked in file srv0srv.cc line 2029 --Thread 139956094596864 has waited at row0mysql.cc line 1795 for 164.00 seconds the semaphore: S-lock on RW-latch at 0x55865ee04de0 created in file dict0dict.cc line 920 a writer (thread id 139953379993344) has reserved it in mode wait exclusive number of readers 4, waiters flag 1, lock_word: fffffffc Last time write locked in file srv0srv.cc line 2029 --Thread 139956100544256 has waited at row0mysql.cc line 1795 for 162.00 seconds the semaphore: S-lock on RW-latch at 0x55865ee04de0 created in file dict0dict.cc line 920 a writer (thread id 139953379993344) has reserved it in mode wait exclusive number of readers 4, waiters flag 1, lock_word: fffffffc Last time write locked in file srv0srv.cc line 2029 --Thread 139956109195008 has waited at row0ins.cc line 1982 for 21.00 seconds the semaphore: S-lock on RW-latch at 0x55865ee04de0 created in file dict0dict.cc line 920 a writer (thread id 139953379993344) has reserved it in mode wait exclusive number of readers 4, waiters flag 1, lock_word: fffffffc Last time write locked in file srv0srv.cc line 2029 --Thread 139956108924672 has waited at row0mysql.cc line 1795 for 163.00 seconds the semaphore: S-lock on RW-latch at 0x55865ee04de0 created in file dict0dict.cc line 920 a writer (thread id 139953379993344) has reserved it in mode wait exclusive number of readers 4, waiters flag 1, lock_word: fffffffc Last time write locked in file srv0srv.cc line 2029 --Thread 139956066752256 has waited at row0ins.cc line 1982 for 33.00 seconds the semaphore: S-lock on RW-latch at 0x55865ee04de0 created in file dict0dict.cc line 920 a writer (thread id 139953379993344) has reserved it in mode wait exclusive number of readers 4, waiters flag 1, lock_word: fffffffc Last time write locked in file srv0srv.cc line 2029 --Thread 139956114872064 has waited at row0upd.cc line 181 for 28.00 seconds the semaphore: S-lock on RW-latch at 0x55865ee04de0 created in file dict0dict.cc line 920 a writer (thread id 139953379993344) has reserved it in mode wait exclusive number of readers 4, waiters flag 1, lock_word: fffffffc Last time write locked in file srv0srv.cc line 2029 --Thread 139956116494080 has waited at row0ins.cc line 1982 for 55.00 seconds the semaphore: S-lock on RW-latch at 0x55865ee04de0 created in file dict0dict.cc line 920 a writer (thread id 139953379993344) has reserved it in mode wait exclusive number of readers 4, waiters flag 1, lock_word: fffffffc Last time write locked in file srv0srv.cc line 2029 --Thread 139956115412736 has waited at row0mysql.cc line 1795 for 164.00 seconds the semaphore: S-lock on RW-latch at 0x55865ee04de0 created in file dict0dict.cc line 920 a writer (thread id 139953379993344) has reserved it in mode wait exclusive number of readers 4, waiters flag 1, lock_word: fffffffc Last time write locked in file srv0srv.cc line 2029 --Thread 139956088649472 has waited at row0upd.cc line 181 for 30.00 seconds the semaphore: S-lock on RW-latch at 0x55865ee04de0 created in file dict0dict.cc line 920 a writer (thread id 139953379993344) has reserved it in mode wait exclusive number of readers 4, waiters flag 1, lock_word: fffffffc Last time write locked in file srv0srv.cc line 2029 --Thread 139956091352832 has waited at btr0cur.cc line 1357 for 59.00 seconds the semaphore: SX-lock on RW-latch at 0x7f49c0010830 created in file dict0dict.cc line 2130 a writer (thread id 139955038029568) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time write locked in file dict0stats.cc line 1969 --Thread 139956082431744 has waited at row0mysql.cc line 1795 for 164.00 seconds the semaphore: S-lock on RW-latch at 0x55865ee04de0 created in file dict0dict.cc line 920 a writer (thread id 139953379993344) has reserved it in mode wait exclusive number of readers 4, waiters flag 1, lock_word: fffffffc Last time write locked in file srv0srv.cc line 2029 --Thread 139956112709376 has waited at row0mysql.cc line 1795 for 3.00 seconds the semaphore: S-lock on RW-latch at 0x55865ee04de0 created in file dict0dict.cc line 920 a writer (thread id 139953379993344) has reserved it in mode wait exclusive number of readers 4, waiters flag 1, lock_word: fffffffc Last time write locked in file srv0srv.cc line 2029 --Thread 139956112979712 has waited at row0upd.cc line 181 for 33.00 seconds the semaphore: S-lock on RW-latch at 0x55865ee04de0 created in file dict0dict.cc line 920 a writer (thread id 139953379993344) has reserved it in mode wait exclusive number of readers 4, waiters flag 1, lock_word: fffffffc Last time write locked in file srv0srv.cc line 2029 --Thread 139956104869632 has waited at row0upd.cc line 181 for 50.00 seconds the semaphore: S-lock on RW-latch at 0x55865ee04de0 created in file dict0dict.cc line 920 a writer (thread id 139953379993344) has reserved it in mode wait exclusive number of readers 4, waiters flag 1, lock_word: fffffffc Last time write locked in file srv0srv.cc line 2029 --Thread 139956090271488 has waited at row0upd.cc line 181 for 138.00 seconds the semaphore: S-lock on RW-latch at 0x55865ee04de0 created in file dict0dict.cc line 920 a writer (thread id 139953379993344) has reserved it in mode wait exclusive number of readers 4, waiters flag 1, lock_word: fffffffc Last time write locked in file srv0srv.cc line 2029 --Thread 139953379993344 has waited at srv0srv.cc line 2029 for 166.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x55865ee04de0 created in file dict0dict.cc line 920 a writer (thread id 139953379993344) has reserved it in mode wait exclusive number of readers 4, waiters flag 1, lock_word: fffffffc Last time write locked in file srv0srv.cc line 2029 --Thread 139956089730816 has waited at row0upd.cc line 181 for 166.00 seconds the semaphore: S-lock on RW-latch at 0x55865ee04de0 created in file dict0dict.cc line 920 a writer (thread id 139953379993344) has reserved it in mode wait exclusive number of readers 4, waiters flag 1, lock_word: fffffffc Last time write locked in file srv0srv.cc line 2029 --Thread 140022041876224 has waited at btr0cur.cc line 1357 for 180.00 seconds the semaphore: SX-lock on RW-latch at 0x7f49c0010830 created in file dict0dict.cc line 2130 a writer (thread id 139955038029568) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time write locked in file dict0stats.cc line 1969 --Thread 140022041335552 has waited at row0upd.cc line 181 for 38.00 seconds the semaphore: S-lock on RW-latch at 0x55865ee04de0 created in file dict0dict.cc line 920 a writer (thread id 139953379993344) has reserved it in mode wait exclusive number of readers 4, waiters flag 1, lock_word: fffffffc Last time write locked in file srv0srv.cc line 2029 --Thread 139956067833600 has waited at row0ins.cc line 1982 for 48.00 seconds the semaphore: S-lock on RW-latch at 0x55865ee04de0 created in file dict0dict.cc line 920 a writer (thread id 139953379993344) has reserved it in mode wait exclusive number of readers 4, waiters flag 1, lock_word: fffffffc Last time write locked in file srv0srv.cc line 2029 --Thread 139956111628032 has waited at row0mysql.cc line 1795 for 163.00 seconds the semaphore: S-lock on RW-latch at 0x55865ee04de0 created in file dict0dict.cc line 920 a writer (thread id 139953379993344) has reserved it in mode wait exclusive number of readers 4, waiters flag 1, lock_word: fffffffc Last time write locked in file srv0srv.cc line 2029 --Thread 139956080809728 has waited at row0mysql.cc line 1795 for 17.00 seconds the semaphore: S-lock on RW-latch at 0x55865ee04de0 created in file dict0dict.cc line 920 a writer (thread id 139953379993344) has reserved it in mode wait exclusive number of readers 4, waiters flag 1, lock_word: fffffffc Last time write locked in file srv0srv.cc line 2029 --Thread 139956095407872 has waited at row0mysql.cc line 1795 for 79.00 seconds the semaphore: S-lock on RW-latch at 0x55865ee04de0 created in file dict0dict.cc line 920 a writer (thread id 139953379993344) has reserved it in mode wait exclusive number of readers 4, waiters flag 1, lock_word: fffffffc Last time write locked in file srv0srv.cc line 2029 --Thread 139956084594432 has waited at row0upd.cc line 181 for 14.00 seconds the semaphore: S-lock on RW-latch at 0x55865ee04de0 created in file dict0dict.cc line 920 a writer (thread id 139953379993344) has reserved it in mode wait exclusive number of readers 4, waiters flag 1, lock_word: fffffffc Last time write locked in file srv0srv.cc line 2029 --Thread 139956116764416 has waited at btr0cur.cc line 1357 for 187.00 seconds the semaphore: SX-lock on RW-latch at 0x7f49c0010830 created in file dict0dict.cc line 2130 a writer (thread id 139955038029568) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time write locked in file dict0stats.cc line 1969 --Thread 139954562504448 has waited at row0ins.cc line 1982 for 163.00 seconds the semaphore: S-lock on RW-latch at 0x55865ee04de0 created in file dict0dict.cc line 920 a writer (thread id 139953379993344) has reserved it in mode wait exclusive number of readers 4, waiters flag 1, lock_word: fffffffc Last time write locked in file srv0srv.cc line 2029 --Thread 139954593310464 has waited at row0mysql.cc line 1795 for 163.00 seconds the semaphore: S-lock on RW-latch at 0x55865ee04de0 created in file dict0dict.cc line 920 a writer (thread id 139953379993344) has reserved it in mode wait exclusive number of readers 4, waiters flag 1, lock_word: fffffffc Last time write locked in file srv0srv.cc line 2029 --Thread 139956064589568 has waited at row0ins.cc line 1982 for 74.00 seconds the semaphore: S-lock on RW-latch at 0x55865ee04de0 created in file dict0dict.cc line 920 a writer (thread id 139953379993344) has reserved it in mode wait exclusive number of readers 4, waiters flag 1, lock_word: fffffffc Last time write locked in file srv0srv.cc line 2029 --Thread 139956086486784 has waited at row0ins.cc line 1982 for 65.00 seconds the semaphore: S-lock on RW-latch at 0x55865ee04de0 created in file dict0dict.cc line 920 a writer (thread id 139953379993344) has reserved it in mode wait exclusive number of readers 4, waiters flag 1, lock_word: fffffffc Last time write locked in file srv0srv.cc line 2029 --Thread 140022042146560 has waited at row0upd.cc line 181 for 38.00 seconds the semaphore: S-lock on RW-latch at 0x55865ee04de0 created in file dict0dict.cc line 920 a writer (thread id 139953379993344) has reserved it in mode wait exclusive number of readers 4, waiters flag 1, lock_word: fffffffc Last time write locked in file srv0srv.cc line 2029 --Thread 139956093785856 has waited at row0mysql.cc line 1795 for 8.00 seconds the semaphore: S-lock on RW-latch at 0x55865ee04de0 created in file dict0dict.cc line 920 a writer (thread id 139953379993344) has reserved it in mode wait exclusive number of readers 4, waiters flag 1, lock_word: fffffffc Last time write locked in file srv0srv.cc line 2029 --Thread 139956088379136 has waited at btr0cur.cc line 1357 for 189.00 seconds the semaphore: SX-lock on RW-latch at 0x7f49c0010830 created in file dict0dict.cc line 2130 a writer (thread id 139955038029568) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time write locked in file dict0stats.cc line 1969 --Thread 139954558179072 has waited at row0ins.cc line 1982 for 124.00 seconds the semaphore: S-lock on RW-latch at 0x55865ee04de0 created in file dict0dict.cc line 920 a writer (thread id 139953379993344) has reserved it in mode wait exclusive number of readers 4, waiters flag 1, lock_word: fffffffc Last time write locked in file srv0srv.cc line 2029 --Thread 139955004458752 has waited at btr0cur.cc line 1357 for 192.00 seconds the semaphore: SX-lock on RW-latch at 0x7f49c0010830 created in file dict0dict.cc line 2130 a writer (thread id 139955038029568) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time write locked in file dict0stats.cc line 1969 --Thread 139955999684352 has waited at row0upd.cc line 181 for 109.00 seconds the semaphore: S-lock on RW-latch at 0x55865ee04de0 created in file dict0dict.cc line 920 a writer (thread id 139953379993344) has reserved it in mode wait exclusive number of readers 4, waiters flag 1, lock_word: fffffffc Last time write locked in file srv0srv.cc line 2029 --Thread 139956105139968 has waited at row0upd.cc line 181 for 30.00 seconds the semaphore: S-lock on RW-latch at 0x55865ee04de0 created in file dict0dict.cc line 920 a writer (thread id 139953379993344) has reserved it in mode wait exclusive number of readers 4, waiters flag 1, lock_word: fffffffc Last time write locked in file srv0srv.cc line 2029 --Thread 139956097840896 has waited at row0ins.cc line 1982 for 159.00 seconds the semaphore: S-lock on RW-latch at 0x55865ee04de0 created in file dict0dict.cc line 920 a writer (thread id 139953379993344) has reserved it in mode wait exclusive number of readers 4, waiters flag 1, lock_word: fffffffc Last time write locked in file srv0srv.cc line 2029 --Thread 139954581427968 has waited at row0mysql.cc line 1795 for 86.00 seconds the semaphore: S-lock on RW-latch at 0x55865ee04de0 created in file dict0dict.cc line 920 a writer (thread id 139953379993344) has reserved it in mode wait exclusive number of readers 4, waiters flag 1, lock_word: fffffffc Last time write locked in file srv0srv.cc line 2029 --Thread 139956105950976 has waited at row0ins.cc line 1982 for 73.00 seconds the semaphore: S-lock on RW-latch at 0x55865ee04de0 created in file dict0dict.cc line 920 a writer (thread id 139953379993344) has reserved it in mode wait exclusive number of readers 4, waiters flag 1, lock_word: fffffffc Last time write locked in file srv0srv.cc line 2029 --Thread 139956078917376 has waited at row0upd.cc line 181 for 68.00 seconds the semaphore: S-lock on RW-latch at 0x55865ee04de0 created in file dict0dict.cc line 920 a writer (thread id 139953379993344) has reserved it in mode wait exclusive number of readers 4, waiters flag 1, lock_word: fffffffc Last time write locked in file srv0srv.cc line 2029 --Thread 139956002117376 has waited at row0ins.cc line 1982 for 78.00 seconds the semaphore: S-lock on RW-latch at 0x55865ee04de0 created in file dict0dict.cc line 920 a writer (thread id 139953379993344) has reserved it in mode wait exclusive number of readers 4, waiters flag 1, lock_word: fffffffc Last time write locked in file srv0srv.cc line 2029 --Thread 139956079187712 has waited at row0mysql.cc line 1795 for 106.00 seconds the semaphore: S-lock on RW-latch at 0x55865ee04de0 created in file dict0dict.cc line 920 a writer (thread id 139953379993344) has reserved it in mode wait exclusive number of readers 4, waiters flag 1, lock_word: fffffffc Last time write locked in file srv0srv.cc line 2029 --Thread 139956114061056 has waited at row0upd.cc line 181 for 131.00 seconds the semaphore: S-lock on RW-latch at 0x55865ee04de0 created in file dict0dict.cc line 920 a writer (thread id 139953379993344) has reserved it in mode wait exclusive number of readers 4, waiters flag 1, lock_word: fffffffc Last time write locked in file srv0srv.cc line 2029 --Thread 139956085946112 has waited at row0upd.cc line 181 for 68.00 seconds the semaphore: S-lock on RW-latch at 0x55865ee04de0 created in file dict0dict.cc line 920 a writer (thread id 139953379993344) has reserved it in mode wait exclusive number of readers 4, waiters flag 1, lock_word: fffffffc Last time write locked in file srv0srv.cc line 2029 --Thread 139954547635968 has waited at row0upd.cc line 181 for 83.00 seconds the semaphore: S-lock on RW-latch at 0x55865ee04de0 created in file dict0dict.cc line 920 a writer (thread id 139953379993344) has reserved it in mode wait exclusive number of readers 4, waiters flag 1, lock_word: fffffffc Last time write locked in file srv0srv.cc line 2029 --Thread 139956090812160 has waited at row0upd.cc line 181 for 95.00 seconds the semaphore: S-lock on RW-latch at 0x55865ee04de0 created in file dict0dict.cc line 920 a writer (thread id 139953379993344) has reserved it in mode wait exclusive number of readers 4, waiters flag 1, lock_word: fffffffc Last time write locked in file srv0srv.cc line 2029 --Thread 139956082161408 has waited at row0mysql.cc line 1795 for 91.00 seconds the semaphore: S-lock on RW-latch at 0x55865ee04de0 created in file dict0dict.cc line 920 a writer (thread id 139953379993344) has reserved it in mode wait exclusive number of readers 4, waiters flag 1, lock_word: fffffffc Last time write locked in file srv0srv.cc line 2029 --Thread 139956004280064 has waited at row0mysql.cc line 1795 for 22.00 seconds the semaphore: S-lock on RW-latch at 0x55865ee04de0 created in file dict0dict.cc line 920 a writer (thread id 139953379993344) has reserved it in mode wait exclusive number of readers 4, waiters flag 1, lock_word: fffffffc Last time write locked in file srv0srv.cc line 2029 --Thread 139956005091072 has waited at row0upd.cc line 181 for 48.00 seconds the semaphore: S-lock on RW-latch at 0x55865ee04de0 created in file dict0dict.cc line 920 a writer (thread id 139953379993344) has reserved it in mode wait exclusive number of readers 4, waiters flag 1, lock_word: fffffffc Last time write locked in file srv0srv.cc line 2029 --Thread 139954578724608 has waited at btr0cur.cc line 1357 for 99.00 seconds the semaphore: SX-lock on RW-latch at 0x7f49c0010830 created in file dict0dict.cc line 2130 a writer (thread id 139955038029568) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time write locked in file dict0stats.cc line 1969 --Thread 139956099192576 has waited at row0upd.cc line 181 for 109.00 seconds the semaphore: S-lock on RW-latch at 0x55865ee04de0 created in file dict0dict.cc line 920 a writer (thread id 139953379993344) has reserved it in mode wait exclusive number of readers 4, waiters flag 1, lock_word: fffffffc Last time write locked in file srv0srv.cc line 2029 --Thread 139956111357696 has waited at row0mysql.cc line 1795 for 147.00 seconds the semaphore: S-lock on RW-latch at 0x55865ee04de0 created in file dict0dict.cc line 920 a writer (thread id 139953379993344) has reserved it in mode wait exclusive number of readers 4, waiters flag 1, lock_word: fffffffc Last time write locked in file srv0srv.cc line 2029 --Thread 139956096489216 has waited at row0mysql.cc line 1795 for 52.00 seconds the semaphore: S-lock on RW-latch at 0x55865ee04de0 created in file dict0dict.cc line 920 a writer (thread id 139953379993344) has reserved it in mode wait exclusive number of readers 4, waiters flag 1, lock_word: fffffffc Last time write locked in file srv0srv.cc line 2029 --Thread 139956085675776 has waited at row0upd.cc line 181 for 98.00 seconds the semaphore: S-lock on RW-latch at 0x55865ee04de0 created in file dict0dict.cc line 920 a writer (thread id 139953379993344) has reserved it in mode wait exclusive number of readers 4, waiters flag 1, lock_word: fffffffc Last time write locked in file srv0srv.cc line 2029 --Thread 139956110546688 has waited at row0mysql.cc line 1795 for 95.00 seconds the semaphore: S-lock on RW-latch at 0x55865ee04de0 created in file dict0dict.cc line 920 a writer (thread id 139953379993344) has reserved it in mode wait exclusive number of readers 4, waiters flag 1, lock_word: fffffffc Last time write locked in file srv0srv.cc line 2029 --Thread 139956110006016 has waited at row0mysql.cc line 1795 for 81.00 seconds the semaphore: S-lock on RW-latch at 0x55865ee04de0 created in file dict0dict.cc line 920 a writer (thread id 139953379993344) has reserved it in mode wait exclusive number of readers 4, waiters flag 1, lock_word: fffffffc Last time write locked in file srv0srv.cc line 2029 --Thread 139956003469056 has waited at row0mysql.cc line 1795 for 109.00 seconds the semaphore: S-lock on RW-latch at 0x55865ee04de0 created in file dict0dict.cc line 920 a writer (thread id 139953379993344) has reserved it in mode wait exclusive number of readers 4, waiters flag 1, lock_word: fffffffc Last time write locked in file srv0srv.cc line 2029 --Thread 139956094056192 has waited at row0upd.cc line 181 for 59.00 seconds the semaphore: S-lock on RW-latch at 0x55865ee04de0 created in file dict0dict.cc line 920 a writer (thread id 139953379993344) has reserved it in mode wait exclusive number of readers 4, waiters flag 1, lock_word: fffffffc Last time write locked in file srv0srv.cc line 2029 --Thread 139955021244160 has waited at btr0cur.cc line 1357 for 192.00 seconds the semaphore: SX-lock on RW-latch at 0x7f49c0010830 created in file dict0dict.cc line 2130 a writer (thread id 139955038029568) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time write locked in file dict0stats.cc line 1969 --Thread 139956098111232 has waited at row0ins.cc line 1982 for 108.00 seconds the semaphore: S-lock on RW-latch at 0x55865ee04de0 created in file dict0dict.cc line 920 a writer (thread id 139953379993344) has reserved it in mode wait exclusive number of readers 4, waiters flag 1, lock_word: fffffffc Last time write locked in file srv0srv.cc line 2029 --Thread 139956101895936 has waited at row0ins.cc line 1982 for 121.00 seconds the semaphore: S-lock on RW-latch at 0x55865ee04de0 created in file dict0dict.cc line 920 a writer (thread id 139953379993344) has reserved it in mode wait exclusive number of readers 4, waiters flag 1, lock_word: fffffffc Last time write locked in file srv0srv.cc line 2029 --Thread 139956086216448 has waited at row0mysql.cc line 1795 for 134.00 seconds the semaphore: S-lock on RW-latch at 0x55865ee04de0 created in file dict0dict.cc line 920 a writer (thread id 139953379993344) has reserved it in mode wait exclusive number of readers 4, waiters flag 1, lock_word: fffffffc Last time write locked in file srv0srv.cc line 2029 --Thread 139956079728384 has waited at row0mysql.cc line 1795 for 112.00 seconds the semaphore: S-lock on RW-latch at 0x55865ee04de0 created in file dict0dict.cc line 920 a writer (thread id 139953379993344) has reserved it in mode wait exclusive number of readers 4, waiters flag 1, lock_word: fffffffc Last time write locked in file srv0srv.cc line 2029 --Thread 139956095948544 has waited at row0ins.cc line 1982 for 70.00 seconds the semaphore: S-lock on RW-latch at 0x55865ee04de0 created in file dict0dict.cc line 920 a writer (thread id 139953379993344) has reserved it in mode wait exclusive number of readers 4, waiters flag 1, lock_word: fffffffc Last time write locked in file srv0srv.cc line 2029 --Thread 139956079458048 has waited at row0upd.cc line 181 for 148.00 seconds the semaphore: S-lock on RW-latch at 0x55865ee04de0 created in file dict0dict.cc line 920 a writer (thread id 139953379993344) has reserved it in mode wait exclusive number of readers 4, waiters flag 1, lock_word: fffffffc Last time write locked in file srv0srv.cc line 2029 --Thread 139956102166272 has waited at row0mysql.cc line 1795 for 109.00 seconds the semaphore: S-lock on RW-latch at 0x55865ee04de0 created in file dict0dict.cc line 920 a writer (thread id 139953379993344) has reserved it in mode wait exclusive number of readers 4, waiters flag 1, lock_word: fffffffc Last time write locked in file srv0srv.cc line 2029 --Thread 139956112439040 has waited at row0mysql.cc line 1795 for 105.00 seconds the semaphore: S-lock on RW-latch at 0x55865ee04de0 created in file dict0dict.cc line 920 a writer (thread id 139953379993344) has reserved it in mode wait exclusive number of readers 4, waiters flag 1, lock_word: fffffffc Last time write locked in file srv0srv.cc line 2029 --Thread 139956087027456 has waited at btr0cur.cc line 1357 for 167.00 seconds the semaphore: SX-lock on RW-latch at 0x7f49c0010830 created in file dict0dict.cc line 2130 a writer (thread id 139955038029568) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time write locked in file dict0stats.cc line 1969 --Thread 139956113520384 has waited at row0ins.cc line 1982 for 100.00 seconds the semaphore: S-lock on RW-latch at 0x55865ee04de0 created in file dict0dict.cc line 920 a writer (thread id 139953379993344) has reserved it in mode wait exclusive number of readers 4, waiters flag 1, lock_word: fffffffc Last time write locked in file srv0srv.cc line 2029 --Thread 139955012851456 has waited at btr0cur.cc line 1357 for 192.00 seconds the semaphore: SX-lock on RW-latch at 0x7f49c0010830 created in file dict0dict.cc line 2130 a writer (thread id 139955038029568) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time write locked in file dict0stats.cc line 1969 --Thread 139956067022592 has waited at row0ins.cc line 1982 for 132.00 seconds the semaphore: S-lock on RW-latch at 0x55865ee04de0 created in file dict0dict.cc line 920 a writer (thread id 139953379993344) has reserved it in mode wait exclusive number of readers 4, waiters flag 1, lock_word: fffffffc Last time write locked in file srv0srv.cc line 2029 --Thread 139956104058624 has waited at row0upd.cc line 181 for 121.00 seconds the semaphore: S-lock on RW-latch at 0x55865ee04de0 created in file dict0dict.cc line 920 a writer (thread id 139953379993344) has reserved it in mode wait exclusive number of readers 4, waiters flag 1, lock_word: fffffffc Last time write locked in file srv0srv.cc line 2029 --Thread 139956097570560 has waited at row0ins.cc line 1982 for 116.00 seconds the semaphore: S-lock on RW-latch at 0x55865ee04de0 created in file dict0dict.cc line 920 a writer (thread id 139953379993344) has reserved it in mode wait exclusive number of readers 4, waiters flag 1, lock_word: fffffffc Last time write locked in file srv0srv.cc line 2029 --Thread 139956068374272 has waited at row0ins.cc line 1982 for 117.00 seconds the semaphore: S-lock on RW-latch at 0x55865ee04de0 created in file dict0dict.cc line 920 a writer (thread id 139953379993344) has reserved it in mode wait exclusive number of readers 4, waiters flag 1, lock_word: fffffffc Last time write locked in file srv0srv.cc line 2029 --Thread 139956110817024 has waited at row0ins.cc line 1982 for 125.00 seconds the semaphore: S-lock on RW-latch at 0x55865ee04de0 created in file dict0dict.cc line 920 a writer (thread id 139953379993344) has reserved it in mode wait exclusive number of readers 4, waiters flag 1, lock_word: fffffffc Last time write locked in file srv0srv.cc line 2029 --Thread 139956099733248 has waited at row0upd.cc line 181 for 149.00 seconds the semaphore: S-lock on RW-latch at 0x55865ee04de0 created in file dict0dict.cc line 920 a writer (thread id 139953379993344) has reserved it in mode wait exclusive number of readers 4, waiters flag 1, lock_word: fffffffc Last time write locked in file srv0srv.cc line 2029 OS WAIT ARRAY INFO: signal count 19693285232 RW-shared spins 44645026191, rounds 196270951831, OS waits 3506864769 RW-excl spins 3771831158, rounds 33317833327, OS waits 810059696 RW-sx spins 202755070, rounds 2039386664, OS waits 23658312 Spin rounds per wait: 4.40 RW-shared, 8.83 RW-excl, 10.06 RW-sx ------------ TRANSACTIONS ------------ Trx id counter 28947429659 Purge done for trx's n:o < 28947428742 undo n:o < 0 state: running History list length 309 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 421497072330496, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421497072157640, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 28947429658, ACTIVE 1 sec starting index read mysql tables in use 1, locked 1 LOCK WAIT 2 lock struct(s), heap size 1128, 1 row lock(s) MySQL thread id 365008017, OS thread handle 139956078106368, query id 10737894432 xx.xx.52.183 seruser Updating UPDATE `cl_lo_se` SET ........ ------- TRX HAS BEEN WAITING 1 SEC FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 7209 page no 29506 n bits 136 index PRIMARY of table `sama`.`cl_lo_se` trx id 28947429658 lock_mode X locks rec but not gap waiting Record lock, heap no 67 PHYSICAL RECORD: n_fields 18; compact format; info bits 0 ------------------ ---TRANSACTION 28947429657, ACTIVE 1 sec starting index read mysql tables in use 1, locked 1 LOCK WAIT 2 lock struct(s), heap size 1128, 1 row lock(s) MySQL thread id 365008016, OS thread handle 139954568451840, query id 10737894421 xx.xx.52.183 seruser Updating UPDATE `cl_lo_se` SET ........ ------- TRX HAS BEEN WAITING 1 SEC FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 7209 page no 29506 n bits 136 index PRIMARY of table `sama`.`cl_lo_se` trx id 28947429657 lock_mode X locks rec but not gap waiting Record lock, heap no 67 PHYSICAL RECORD: n_fields 18; compact format; info bits 0 ------------------ ---TRANSACTION 28947429656, ACTIVE 3 sec updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 1128, 1 row lock(s) MySQL thread id 365008006, OS thread handle 139956112709376, query id 10737894345 xx.xx.52.146 seruser Updating UPDATE `clients` SET ........ ---TRANSACTION 28947429652, ACTIVE 7 sec starting index read mysql tables in use 1, locked 1 LOCK WAIT 2 lock struct(s), heap size 1128, 1 row lock(s) MySQL thread id 365007993, OS thread handle 139956081080064, query id 10737894240 xx.xx.52.146 seruser Updating UPDATE `clients` SET ........ ------- TRX HAS BEEN WAITING 7 SEC FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 7265 page no 7946 n bits 136 index PRIMARY of table `rtm`.`clients` trx id 28947429652 lock_mode X locks rec but not gap waiting Record lock, heap no 64 PHYSICAL RECORD: n_fields 45; compact format; info bits 0 ------------------ ---TRANSACTION 28947429653, ACTIVE 7 sec starting index read mysql tables in use 1, locked 1 LOCK WAIT 2 lock struct(s), heap size 1128, 1 row lock(s) MySQL thread id 365007992, OS thread handle 139956099462912, query id 10737894245 xx.xx.52.185 seruser Updating UPDATE `cl_lo_se` SET ........ ------- TRX HAS BEEN WAITING 7 SEC FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 7209 page no 41410 n bits 136 index PRIMARY of table `sama`.`cl_lo_se` trx id 28947429653 lock_mode X locks rec but not gap waiting Record lock, heap no 69 PHYSICAL RECORD: n_fields 18; compact format; info bits 0 ------------------ ---TRANSACTION 28947429651, ACTIVE 8 sec updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 1128, 1 row lock(s) MySQL thread id 365007990, OS thread handle 139956093785856, query id 10737894200 xx.xx.52.147 seruser Updating UPDATE `clients` SET ........ ---TRANSACTION 421497072440112, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 28947429646, ACTIVE 11 sec starting index read mysql tables in use 1, locked 1 LOCK WAIT 2 lock struct(s), heap size 1128, 1 row lock(s) MySQL thread id 365007934, OS thread handle 139956108654336, query id 10737893328 xx.xx.52.162 seruser Updating UPDATE `cl_lo_se` SET ........ ------- TRX HAS BEEN WAITING 11 SEC FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 7209 page no 40088 n bits 1000 index ix_cl_lo_se_client_id of table `sama`.`cl_lo_se` trx id 28947429646 lock_mode X locks rec but not gap waiting Record lock, heap no 382 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 ------------------ ---TRANSACTION 28947429643, ACTIVE 14 sec starting index read mysql tables in use 1, locked 1 LOCK WAIT 2 lock struct(s), heap size 1128, 1 row lock(s) MySQL thread id 365007879, OS thread handle 140022042416896, query id 10737892840 xx.xx.52.174 seruser Updating UPDATE `applications` SET ........ ------- TRX HAS BEEN WAITING 14 SEC FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 5911 page no 39601 n bits 80 index PRIMARY of table `sama`.`applications` trx id 28947429643 lock_mode X locks rec but not gap waiting Record lock, heap no 3 PHYSICAL RECORD: n_fields 24; compact format; info bits 0 ------------------ ---TRANSACTION 421497072587672, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 28947429642, ACTIVE 14 sec fetching rows mysql tables in use 1, locked 1 LOCK WAIT 19 lock struct(s), heap size 3488, 1 row lock(s) MySQL thread id 365007877, OS thread handle 139956068103936, query id 10737892832 xx.xx.52.161 seruser Updating UPDATE `cl_lo_se` SET ........ ------- TRX HAS BEEN WAITING 14 SEC FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 7209 page no 6894 n bits 1000 index ix_cl_lo_se_client_id of table `sama`.`cl_lo_se` trx id 28947429642 lock_mode X locks rec but not gap waiting Record lock, heap no 542 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 803a4ad9; asc :J ;; 1: len 8; hex 80000000004612cf; asc F ;; ------------------ ---TRANSACTION 28947429639, ACTIVE 14 sec starting index read mysql tables in use 1, locked 1 LOCK WAIT 2 lock struct(s), heap size 1128, 1 row lock(s) MySQL thread id 365007876, OS thread handle 139955999414016, query id 10737892805 xx.xx.52.182 seruser Updating UPDATE `clients` SET ........ ------- TRX HAS BEEN WAITING 14 SEC FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 7042 page no 22182 n bits 120 index PRIMARY of table `sama`.`clients` trx id 28947429639 lock_mode X locks rec but not gap waiting Record lock, heap no 54 PHYSICAL RECORD: n_fields 46; compact format; info bits 0 ------------------ ---TRANSACTION 28947429638, ACTIVE 14 sec updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 1128, 1 row lock(s) MySQL thread id 365007875, OS thread handle 139956084594432, query id 10737892796 xx.xx.52.182 seruser Updating UPDATE `cl_lo_se` SET ........ ---TRANSACTION 28947429637, ACTIVE 16 sec starting index read mysql tables in use 1, locked 1 LOCK WAIT 2 lock struct(s), heap size 1128, 1 row lock(s) MySQL thread id 365007871, OS thread handle 139956107843328, query id 10737892741 xx.xx.52.185 seruser Updating UPDATE `cl_lo_se` SET ........ ------- TRX HAS BEEN WAITING 16 SEC FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 7209 page no 29506 n bits 136 index PRIMARY of table `sama`.`cl_lo_se` trx id 28947429637 lock_mode X locks rec but not gap waiting Record lock, heap no 67 PHYSICAL RECORD: n_fields 18; compact format; info bits 0 ------------------ ---TRANSACTION 421497072562376, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 28947429636, ACTIVE 17 sec fetching rows mysql tables in use 1, locked 1 LOCK WAIT 13 lock struct(s), heap size 1128, 1 row lock(s) MySQL thread id 365007868, OS thread handle 139954557908736, query id 10737892717 xx.xx.52.162 seruser Updating UPDATE `cl_lo_se` SET ........ ------- TRX HAS BEEN WAITING 17 SEC FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 7209 page no 21433 n bits 1000 index ix_cl_lo_se_client_id of table `sama`.`cl_lo_se` trx id 28947429636 lock_mode X locks rec but not gap waiting Record lock, heap no 909 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 ------------------ ---TRANSACTION 28947429628, ACTIVE 20 sec updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 1128, 1 row lock(s) MySQL thread id 365007853, OS thread handle 139956074592000, query id 10737892593 xx.xx.52.146 seruser Updating UPDATE `clients` SET ........ ---TRANSACTION 421497072558160, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 28947429627, ACTIVE 21 sec inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 1128, 0 row lock(s), undo log entries 1 MySQL thread id 365007771, OS thread handle 139956109195008, query id 10737891953 xx.xx.52.161 seruser Update INSERT INTO `cl_lo_se` ........ ---TRANSACTION 28947429623, ACTIVE 22 sec updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 1128, 1 row lock(s) MySQL thread id 365007770, OS thread handle 139956004280064, query id 10737891923 xx.xx.52.175 seruser Updating UPDATE `applications` SET ........ ---TRANSACTION 28947429622, ACTIVE 24 sec starting index read mysql tables in use 1, locked 1 LOCK WAIT 2 lock struct(s), heap size 1128, 1 row lock(s) MySQL thread id 365007767, OS thread handle 139956074862336, query id 10737891905 xx.xx.52.185 seruser Updating UPDATE `cl_lo_se` SET ........ ------- TRX HAS BEEN WAITING 24 SEC FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 7209 page no 43989 n bits 144 index PRIMARY of table `sama`.`cl_lo_se` trx id 28947429622 lock_mode X locks rec but not gap waiting Record lock, heap no 72 PHYSICAL RECORD: n_fields 18; compact format; info bits 0 ------------------ ---TRANSACTION 28947429621, ACTIVE 28 sec updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 1128, 1 row lock(s) MySQL thread id 365007746, OS thread handle 139956114872064, query id 10737891696 xx.xx.52.185 seruser Updating UPDATE `cl_lo_se` SET ........ ---TRANSACTION 421497072545512, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 28947429620, ACTIVE 29 sec fetching rows mysql tables in use 1, locked 1 LOCK WAIT 6 lock struct(s), heap size 1128, 1 row lock(s) MySQL thread id 365007735, OS thread handle 139956095137536, query id 10737891570 xx.xx.52.162 seruser Updating UPDATE `cl_lo_se` SET ........ ------- TRX HAS BEEN WAITING 29 SEC FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 7209 page no 35911 n bits 1000 index ix_cl_lo_se_client_id of table `sama`.`cl_lo_se` trx id 28947429620 lock_mode X locks rec but not gap waiting Record lock, heap no 257 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 ------------------ ---TRANSACTION 28947429615, ACTIVE 30 sec updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 1128, 1 row lock(s) MySQL thread id 365007731, OS thread handle 139956071077632, query id 10737891523 xx.xx.52.183 seruser Updating UPDATE `cl_lo_se` SET ........ ---TRANSACTION 28947429614, ACTIVE 30 sec updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 1128, 1 row lock(s) MySQL thread id 365007729, OS thread handle 139956088649472, query id 10737891489 xx.xx.52.183 seruser Updating UPDATE `cl_lo_se` SET ........ ---TRANSACTION 28947429613, ACTIVE 30 sec updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 1128, 1 row lock(s) MySQL thread id 365007723, OS thread handle 139956105139968, query id 10737891403 xx.xx.52.185 seruser Updating UPDATE `cl_lo_se` SET ........ ---TRANSACTION 28947429612, ACTIVE 31 sec starting index read mysql tables in use 1, locked 1 LOCK WAIT 2 lock struct(s), heap size 1128, 1 row lock(s) MySQL thread id 365007718, OS thread handle 139956103788288, query id 10737891329 xx.xx.52.183 seruser Updating UPDATE `cl_lo_se` SET ........ ------- TRX HAS BEEN WAITING 31 SEC FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 7209 page no 29506 n bits 136 index PRIMARY of table `sama`.`cl_lo_se` trx id 28947429612 lock_mode X locks rec but not gap waiting Record lock, heap no 67 PHYSICAL RECORD: n_fields 18; compact format; info bits 0 ------------------ ---TRANSACTION 28947429611, ACTIVE 33 sec inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 1128, 0 row lock(s), undo log entries 1 MySQL thread id 365007714, OS thread handle 139956066752256, query id 10737891269 xx.xx.52.146 seruser Update INSERT INTO `documents` ........ ---TRANSACTION 421497072537080, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 28947429610, ACTIVE 33 sec updating or deleting mysql tables in use 1, locked 1 6 lock struct(s), heap size 1128, 2 row lock(s) MySQL thread id 365007685, OS thread handle 139956112979712, query id 10737891028 xx.xx.52.161 seruser Updating UPDATE `cl_lo_se` SET ........ ---TRANSACTION 421497072528648, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 28947429605, ACTIVE 34 sec inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 1128, 0 row lock(s), undo log entries 1 MySQL thread id 365007652, OS thread handle 139956078376704, query id 10737890819 xx.xx.52.162 seruser Update INSERT INTO `otp_codes` ........ ---TRANSACTION 421497072520216, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 28947429600, ACTIVE 36 sec updating or deleting mysql tables in use 1, locked 1 3 lock struct(s), heap size 1128, 2 row lock(s) MySQL thread id 365007646, OS thread handle 139956092974848, query id 10737890746 xx.xx.52.162 seruser Updating UPDATE `cl_lo_se` SET ........ ---TRANSACTION 421497072511784, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 28947429596, ACTIVE 38 sec updating or deleting mysql tables in use 1, locked 1 3 lock struct(s), heap size 1128, 2 row lock(s) MySQL thread id 365007641, OS thread handle 140022042146560, query id 10737890691 xx.xx.52.162 seruser Updating UPDATE `cl_lo_se` SET ........ ---TRANSACTION 28947429597, ACTIVE 38 sec starting index read mysql tables in use 1, locked 1 LOCK WAIT 2 lock struct(s), heap size 1128, 1 row lock(s) MySQL thread id 365007640, OS thread handle 139956114331392, query id 10737890694 xx.xx.52.183 seruser Updating UPDATE `pa_d_add` SET ........ ------- TRX HAS BEEN WAITING 38 SEC FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 7311 page no 110 n bits 200 index PRIMARY of table `sama`.`pa_d_add` trx id 28947429597 lock_mode X locks rec but not gap waiting Record lock, heap no 130 PHYSICAL RECORD: n_fields 35; compact format; info bits 0 ------------------ ---TRANSACTION 421497072499136, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 28947429593, ACTIVE 38 sec updating or deleting mysql tables in use 1, locked 1 19 lock struct(s), heap size 3488, 2 row lock(s) MySQL thread id 365007636, OS thread handle 140022041335552, query id 10737890637 xx.xx.52.161 seruser Updating UPDATE `cl_lo_se` SET ........ ---TRANSACTION 28947429590, ACTIVE 39 sec starting index read mysql tables in use 1, locked 1 LOCK WAIT 2 lock struct(s), heap size 1128, 1 row lock(s) MySQL thread id 365007635, OS thread handle 139956100003584, query id 10737890610 xx.xx.52.147 seruser Updating UPDATE `clients` SET ........ ------- TRX HAS BEEN WAITING 39 SEC FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 7265 page no 8785 n bits 136 index PRIMARY of table `rtm`.`clients` trx id 28947429590 lock_mode X locks rec but not gap waiting Record lock, heap no 8 PHYSICAL RECORD: n_fields 45; compact format; info bits 0 ------------------ ---TRANSACTION 28947429589, ACTIVE 44 sec updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 1128, 1 row lock(s) MySQL thread id 365007623, OS thread handle 139954594662144, query id 10737890505 xx.xx.52.174 seruser Updating UPDATE `applications` SET ........ ---TRANSACTION 28947429588, ACTIVE 45 sec starting index read mysql tables in use 1, locked 1 LOCK WAIT 2 lock struct(s), heap size 1128, 1 row lock(s) MySQL thread id 365007620, OS thread handle 139956081350400, query id 10737890488 xx.xx.52.185 seruser Updating UPDATE `pa_d_add` SET ........ ------- TRX HAS BEEN WAITING 45 SEC FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 7311 page no 110 n bits 200 index PRIMARY of table `sama`.`pa_d_add` trx id 28947429588 lock_mode X locks rec but not gap waiting Record lock, heap no 130 PHYSICAL RECORD: n_fields 35; compact format; info bits 0 ------------------ ---TRANSACTION 28947429587, ACTIVE 48 sec inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 1128, 0 row lock(s), undo log entries 1 MySQL thread id 365007613, OS thread handle 139956067833600, query id 10737890413 xx.xx.52.147 seruser Update INSERT INTO `documents` ........ ---TRANSACTION 28947429582, ACTIVE 48 sec updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 1128, 1 row lock(s) MySQL thread id 365007598, OS thread handle 139956005091072, query id 10737890301 xx.xx.52.183 seruser Updating UPDATE `cl_lo_se` SET ........ ---TRANSACTION 421497072482272, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 28947429576, ACTIVE 49 sec inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 1128, 0 row lock(s), undo log entries 1 MySQL thread id 365007585, OS thread handle 139956104328960, query id 10737890147 xx.xx.52.161 seruser Update INSERT INTO `cl_lo_se` ........ ---TRANSACTION 28947429572, ACTIVE 50 sec updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 1128, 1 row lock(s) MySQL thread id 365007582, OS thread handle 139956104869632, query id 10737890100 xx.xx.52.185 seruser Updating UPDATE `cl_lo_se` SET ........ ---TRANSACTION 28947429571, ACTIVE 50 sec starting index read mysql tables in use 1, locked 1 LOCK WAIT 2 lock struct(s), heap size 1128, 1 row lock(s) MySQL thread id 365007580, OS thread handle 139956092163840, query id 10737890084 xx.xx.52.183 seruser Updating UPDATE `clients` SET ........ ------- TRX HAS BEEN WAITING 50 SEC FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 7042 page no 43615 n bits 96 index PRIMARY of table `sama`.`clients` trx id 28947429571 lock_mode X locks rec but not gap waiting Record lock, heap no 29 PHYSICAL RECORD: n_fields 46; compact format; info bits 0 ------------------ ---TRANSACTION 421497072469624, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 28947429569, ACTIVE 52 sec updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 1128, 1 row lock(s) MySQL thread id 365007573, OS thread handle 139956096489216, query id 10737889997 xx.xx.52.185 seruser Updating UPDATE `clients` SET ........ ---TRANSACTION 28947429568, ACTIVE 55 sec inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 1128, 0 row lock(s), undo log entries 1 MySQL thread id 365007565, OS thread handle 139956116494080, query id 10737889921 xx.xx.52.146 seruser Update INSERT INTO `cl_pa_re` ........ ---TRANSACTION 421497072452760, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 28947429565, ACTIVE 59 sec updating or deleting mysql tables in use 1, locked 1 3 lock struct(s), heap size 1128, 2 row lock(s) MySQL thread id 365007534, OS thread handle 139956094056192, query id 10737889632 xx.xx.52.161 seruser Updating UPDATE `cl_lo_se` SET ........ ---TRANSACTION 28947429562, ACTIVE 59 sec inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 365007529, OS thread handle 139956091352832, query id 10737889585 xx.xx.52.162 seruser Update INSERT INTO `mailer_messages`........ ---TRANSACTION 28947429545, ACTIVE 65 sec inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 1128, 0 row lock(s), undo log entries 1 MySQL thread id 365007496, OS thread handle 139956086486784, query id 10737889163 xx.xx.52.183 seruser Update INSERT INTO `fi_bi` ........ ---TRANSACTION 28947429542, ACTIVE 68 sec updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 1128, 1 row lock(s) MySQL thread id 365007471, OS thread handle 139956085946112, query id 10737888877 xx.xx.52.183 seruser Updating UPDATE `cl_lo_se` SET ........ ---TRANSACTION 28947429541, ACTIVE 68 sec updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 1128, 1 row lock(s) MySQL thread id 365007469, OS thread handle 139956078917376, query id 10737888846 xx.xx.52.162 seruser Updating DELETE FROM `pu_no_to` WHERE ........ ---TRANSACTION 28947429540, ACTIVE 70 sec inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 1128, 0 row lock(s), undo log entries 1 MySQL thread id 365007449, OS thread handle 139956095948544, query id 10737888672 xx.xx.52.185 seruser Update INSERT INTO `otp_codes` ........ ---TRANSACTION 28947429539, ACTIVE 71 sec updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 1128, 1 row lock(s) MySQL thread id 365007447, OS thread handle 139956079998720, query id 10737888634 xx.xx.52.182 seruser Updating UPDATE `cl_lo_se` SET ........ ---TRANSACTION 421497072419032, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 28947429537, ACTIVE 73 sec inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 1128, 0 row lock(s), undo log entries 1 MySQL thread id 365007434, OS thread handle 139956114601728, query id 10737888492 xx.xx.52.162 seruser Update INSERT INTO `otp_codes` ........ ---TRANSACTION 28947429538, ACTIVE 73 sec inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 1128, 0 row lock(s), undo log entries 1 MySQL thread id 365007433, OS thread handle 139956105950976, query id 10737888525 xx.xx.52.161 seruser Update INSERT INTO `pu_no_me` ........ ---TRANSACTION 421497072402168, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 28947429532, ACTIVE 74 sec inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 1128, 0 row lock(s), undo log entries 1 MySQL thread id 365007431, OS thread handle 139956064589568, query id 10737887938 xx.xx.52.161 seruser Update INSERT INTO `otp_codes` ........ ---TRANSACTION 421497072393736, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 28947429529, ACTIVE 78 sec inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 1128, 0 row lock(s), undo log entries 1 MySQL thread id 365007414, OS thread handle 139956002117376, query id 10737887738 xx.xx.52.161 seruser Update INSERT INTO `otp_codes` ........ ---TRANSACTION 28947429525, ACTIVE 79 sec updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 1128, 1 row lock(s) MySQL thread id 365007408, OS thread handle 139956095407872, query id 10737887648 xx.xx.52.174 seruser Updating UPDATE `applications` SET ........ ---TRANSACTION 28947429522, ACTIVE 81 sec updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 1128, 1 row lock(s) MySQL thread id 365007399, OS thread handle 139956110006016, query id 10737887572 xx.xx.52.174 seruser Updating UPDATE `applications` SET ........ ---TRANSACTION 28947429520, ACTIVE 83 sec updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 1128, 1 row lock(s) MySQL thread id 365007393, OS thread handle 139954547635968, query id 10737887511 xx.xx.52.183 seruser Updating UPDATE `cl_lo_se` SET ........ ---TRANSACTION 28947429517, ACTIVE 86 sec updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 1128, 1 row lock(s) MySQL thread id 365007381, OS thread handle 139954581427968, query id 10737887353 xx.xx.52.147 seruser Updating UPDATE `clients` SET ........ ---TRANSACTION 28947429499, ACTIVE 91 sec updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 1128, 1 row lock(s) MySQL thread id 365007279, OS thread handle 139956082161408, query id 10737883914 xx.xx.52.174 seruser Updating UPDATE `applications` SET ........ ---TRANSACTION 28947429498, ACTIVE 95 sec updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 1128, 1 row lock(s) MySQL thread id 365007245, OS thread handle 139956110546688, query id 10737882739 xx.xx.52.183 seruser Updating UPDATE `clients` SET ........ ---TRANSACTION 28947429497, ACTIVE 95 sec updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 1128, 1 row lock(s) MySQL thread id 365007238, OS thread handle 139956090812160, query id 10737882490 xx.xx.52.183 seruser Updating UPDATE `pa_d_add` SET ........ ---TRANSACTION 28947429496, ACTIVE 98 sec updating or deleting mysql tables in use 1, locked 1 6 lock struct(s), heap size 1128, 2 row lock(s) MySQL thread id 365007220, OS thread handle 139956085675776, query id 10737881674 xx.xx.52.162 seruser Updating UPDATE `cl_lo_se` SET ........ ---TRANSACTION 28947429493, ACTIVE 99 sec inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 365007218, OS thread handle 139954578724608, query id 10737881504 xx.xx.52.161 seruser Update INSERT INTO `mailer_messages` ........ ---TRANSACTION 28947429490, ACTIVE 100 sec inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 1128, 0 row lock(s), undo log entries 1 MySQL thread id 365007200, OS thread handle 139956113520384, query id 10737881186 xx.xx.52.185 seruser Update INSERT INTO `otp_codes` ........ ---TRANSACTION 28947429488, ACTIVE 105 sec updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 1128, 1 row lock(s) MySQL thread id 365007153, OS thread handle 139956112439040, query id 10737880629 xx.xx.52.146 seruser Updating UPDATE `clients` SET ........ ---TRANSACTION 28947429485, ACTIVE 106 sec updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 1128, 1 row lock(s) MySQL thread id 365007133, OS thread handle 139956079187712, query id 10737880413 xx.xx.52.174 seruser Updating UPDATE `applications` SET ........ ---TRANSACTION 28947429484, ACTIVE 108 sec inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 1128, 0 row lock(s), undo log entries 1 MySQL thread id 365007118, OS thread handle 139956098111232, query id 10737880246 xx.xx.52.182 seruser Update INSERT INTO `documents` ........ ---TRANSACTION 28947429483, ACTIVE 109 sec updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 1128, 1 row lock(s) MySQL thread id 365007099, OS thread handle 139956003469056, query id 10737880014 xx.xx.52.175 seruser Updating UPDATE `applications` SET ........ ---TRANSACTION 28947429482, ACTIVE 109 sec updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 1128, 1 row lock(s) MySQL thread id 365007096, OS thread handle 139956102166272, query id 10737879991 xx.xx.52.182 seruser Updating UPDATE `client_profiles` SET ........ ---TRANSACTION 28947429481, ACTIVE 109 sec updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 1128, 1 row lock(s) MySQL thread id 365007092, OS thread handle 139956099192576, query id 10737879965 xx.xx.52.185 seruser Updating UPDATE `cl_lo_se` SET ........ ---TRANSACTION 28947429480, ACTIVE 109 sec updating or deleting mysql tables in use 1, locked 1 13 lock struct(s), heap size 1128, 2 row lock(s) MySQL thread id 365007084, OS thread handle 139955999684352, query id 10737879875 xx.xx.52.162 seruser Updating UPDATE `cl_lo_se` SET ........ ---TRANSACTION 28947429477, ACTIVE 112 sec updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 1128, 1 row lock(s) MySQL thread id 365007051, OS thread handle 139956079728384, query id 10737879515 xx.xx.52.147 seruser Updating UPDATE `clients` SET ........ ---TRANSACTION 28947429476, ACTIVE 116 sec inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 1128, 0 row lock(s), undo log entries 1 MySQL thread id 365007022, OS thread handle 139956097570560, query id 10737879194 xx.xx.52.146 seruser Update INSERT INTO `cl_pa_re` ........ ---TRANSACTION 28947429472, ACTIVE 117 sec inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 1128, 0 row lock(s), undo log entries 1 MySQL thread id 365006995, OS thread handle 139956068374272, query id 10737878938 xx.xx.52.185 seruser Update INSERT INTO `otp_codes` ........ ---TRANSACTION 28947429467, ACTIVE 121 sec inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 1128, 0 row lock(s), undo log entries 1 MySQL thread id 365006955, OS thread handle 139956101895936, query id 10737878560 xx.xx.52.185 seruser Update INSERT INTO `otp_codes` ........ ---TRANSACTION 28947429464, ACTIVE 121 sec updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 1128, 1 row lock(s) MySQL thread id 365006948, OS thread handle 139956104058624, query id 10737878470 xx.xx.52.162 seruser Updating DELETE FROM `pu_no_to` WHERE ........ ---TRANSACTION 28947429453, ACTIVE 124 sec inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 1128, 0 row lock(s), undo log entries 1 MySQL thread id 365006919, OS thread handle 139954558179072, query id 10737878142 xx.xx.52.183 seruser Update INSERT INTO `otp_codes` ........ ---TRANSACTION 28947429451, ACTIVE 125 sec inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 1128, 0 row lock(s), undo log entries 1 MySQL thread id 365006909, OS thread handle 139956110817024, query id 10737878035 xx.xx.52.146 seruser Update INSERT INTO `documents` ........ ---TRANSACTION 28947429433, ACTIVE 131 sec updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 1128, 1 row lock(s) MySQL thread id 365006801, OS thread handle 139956114061056, query id 10737876538 xx.xx.52.183 seruser Updating UPDATE `cl_lo_se` SET ........ ---TRANSACTION 28947429430, ACTIVE 132 sec inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 1128, 0 row lock(s), undo log entries 1 MySQL thread id 365006789, OS thread handle 139956067022592, query id 10737876388 xx.xx.52.162 seruser Update INSERT INTO `otp_codes` ........ ---TRANSACTION 28947429422, ACTIVE 134 sec updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 1128, 1 row lock(s) MySQL thread id 365006772, OS thread handle 139956086216448, query id 10737876144 xx.xx.52.174 seruser Updating UPDATE `applications` SET ........ ---TRANSACTION 28947429417, ACTIVE 136 sec updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 1128, 1 row lock(s) MySQL thread id 365006756, OS thread handle 139956092704512, query id 10737875926 xx.xx.52.162 seruser Updating UPDATE `otp_codes` SET ........ ---TRANSACTION 28947429409, ACTIVE 138 sec updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 1128, 1 row lock(s) MySQL thread id 365006732, OS thread handle 139956090271488, query id 10737875558 xx.xx.52.185 seruser Updating UPDATE `otp_codes` SET ........ ---TRANSACTION 28947429379, ACTIVE 147 sec updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 1128, 1 row lock(s) MySQL thread id 365006608, OS thread handle 139956111357696, query id 10737873969 xx.xx.52.147 seruser Updating UPDATE `clients` SET ........ ---TRANSACTION 28947429377, ACTIVE 148 sec updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 1128, 1 row lock(s) MySQL thread id 365006595, OS thread handle 139956079458048, query id 10737873830 xx.xx.52.185 seruser Updating UPDATE `otp_codes` SET ........ ---TRANSACTION 28947429372, ACTIVE 149 sec updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 1128, 1 row lock(s) MySQL thread id 365006577, OS thread handle 139956099733248, query id 10737873631 xx.xx.52.162 seruser Updating UPDATE `cl_lo_se` SET ........ ---TRANSACTION 28947429339, ACTIVE 157 sec inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 1128, 0 row lock(s), undo log entries 1 MySQL thread id 365006465, OS thread handle 139956063778560, query id 10737872192 xx.xx.52.174 seruser Update INSERT INTO `a_ac_lo` ........ ---TRANSACTION 28947429333, ACTIVE 159 sec inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 1128, 0 row lock(s), undo log entries 1 MySQL thread id 365006455, OS thread handle 139956097840896, query id 10737872049 xx.xx.52.174 seruser Update INSERT INTO `a_ac_lo` ........ ---TRANSACTION 28947429317, ACTIVE 162 sec updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 1128, 1 row lock(s) MySQL thread id 365006415, OS thread handle 139956100544256, query id 10737871526 xx.xx.52.146 seruser Updating UPDATE `accounts` SET ........ ---TRANSACTION 28947429310, ACTIVE 163 sec inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 1128, 0 row lock(s), undo log entries 1 MySQL thread id 365006383, OS thread handle 139954562504448, query id 10737871189 xx.xx.52.182 seruser Update INSERT INTO `fi_bi` ........ ---TRANSACTION 28947429307, ACTIVE 164 sec updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 1128, 1 row lock(s) MySQL thread id 365006379, OS thread handle 139956082431744, query id 10737871100 xx.xx.52.185 seruser Updating UPDATE `clients` SET ........ ---TRANSACTION 28947429274, ACTIVE 167 sec inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 365006328, OS thread handle 139956087027456, query id 10737870410 xx.xx.52.162 seruser Update INSERT INTO `mailer_messages` ........ ---TRANSACTION 28947429043, ACTIVE 180 sec inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 365006102, OS thread handle 140022041876224, query id 10737867022 xx.xx.52.161 seruser Update INSERT INTO `mailer_messages` ........ ---TRANSACTION 421497072073320, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 28947428892, ACTIVE 187 sec inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 365005927, OS thread handle 139956116764416, query id 10737864753 xx.xx.52.161 seruser Update NSERT INTO `mailer_messages` ........ ---TRANSACTION 28947428844, ACTIVE 189 sec inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 1128, 0 row lock(s), undo log entries 1 MySQL thread id 365005861, OS thread handle 139956088379136, query id 10737863479 xx.xx.52.162 seruser Update INSERT INTO `mailer_messages` ........ ---TRANSACTION 421497071989000, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421497072048024, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 28947429304, ACTIVE 164 sec updating or deleting mysql tables in use 1, locked 1 3 lock struct(s), heap size 1128, 2 row lock(s) MySQL thread id 365004941, OS thread handle 139956115412736, query id 10737871004 xx.xx.52.182 seruser Updating UPDATE `accounts` SET ........ ---TRANSACTION 28947429313, ACTIVE 163 sec updating or deleting mysql tables in use 1, locked 1 3 lock struct(s), heap size 1128, 2 row lock(s) MySQL thread id 365004668, OS thread handle 139954593310464, query id 10737871266 xx.xx.52.183 seruser Updating UPDATE `accounts` SET ........ ---TRANSACTION 28947429306, ACTIVE 164 sec updating or deleting mysql tables in use 1, locked 1 3 lock struct(s), heap size 1128, 2 row lock(s) MySQL thread id 365004414, OS thread handle 139956094596864, query id 10737871055 xx.xx.52.183 seruser Updating UPDATE `accounts` SET ........ ---TRANSACTION 421497072166072, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421497072052240, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421497072111264, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 28947429633, ACTIVE 17 sec updating or deleting mysql tables in use 1, locked 1 3 lock struct(s), heap size 1128, 2 row lock(s) MySQL thread id 365003278, OS thread handle 139956080809728, query id 10737892682 xx.xx.52.182 seruser Updating UPDATE `accounts` SET ........ ---TRANSACTION 28947429309, ACTIVE 163 sec updating or deleting mysql tables in use 1, locked 1 3 lock struct(s), heap size 1128, 2 row lock(s) MySQL thread id 365003210, OS thread handle 139956111628032, query id 10737871174 xx.xx.52.182 seruser Updating UPDATE `accounts` SET ........ ---TRANSACTION 28947429301, ACTIVE 165 sec updating or deleting mysql tables in use 1, locked 1 3 lock struct(s), heap size 1128, 2 row lock(s) MySQL thread id 365003188, OS thread handle 139956074051328, query id 10737870880 xx.xx.52.182 seruser Updating UPDATE `accounts` SET ........ ---TRANSACTION 421497072043808, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421497071993216, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 28947429311, ACTIVE 163 sec updating or deleting mysql tables in use 1, locked 1 3 lock struct(s), heap size 1128, 2 row lock(s) MySQL thread id 365003061, OS thread handle 139956108924672, query id 10737871218 xx.xx.52.182 seruser Updating UPDATE `accounts` SET ........ ---TRANSACTION 421497072144992, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421497072085968, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 28947429300, ACTIVE 166 sec updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 1128, 1 row lock(s) MySQL thread id 365002217, OS thread handle 139956089730816, query id 10737870877 xx.xx.52.162 seruser Updating UPDATE `part_cpa_calc` SET ........ ---TRANSACTION 421497072039592, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421497071997432, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 28947429347, ACTIVE 155 sec 1 lock struct(s), heap size 1128, 0 row lock(s), undo log entries 500 MySQL thread id 364683297, OS thread handle 139956084324096, query id 10737872352 xx.xx.201.18 seruser ---TRANSACTION 28947429348, ACTIVE 154 sec updating or deleting mysql tables in use 1, locked 1 3 lock struct(s), heap size 1128, 1 row lock(s) MySQL thread id 364683203, OS thread handle 139955999954688, query id 10737872405 xx.xx.201.18 seruser Updating DELETE FROM `mailer_messages` WHERE ........ ---TRANSACTION 421497072161856, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421497072153424, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421497072102832, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421497072107048, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421497072140776, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421497072094400, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421497072035376, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421497072081752, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421497072128128, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421497072064888, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421497072005864, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421497072001648, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421497072018512, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421497072014296, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421497071984784, not started 0 lock struct(s), heap size 1128, 0 row lock(s) -------- FILE I/O -------- I/O thread 0 state: waiting for completed aio requests (insert buffer thread) I/O thread 1 state: waiting for completed aio requests (log thread) I/O thread 2 state: waiting for completed aio requests (read thread) I/O thread 3 state: waiting for completed aio requests (read thread) I/O thread 4 state: waiting for completed aio requests (read thread) I/O thread 5 state: waiting for completed aio requests (read thread) I/O thread 6 state: waiting for completed aio requests (write thread) I/O thread 7 state: waiting for completed aio requests (write thread) I/O thread 8 state: waiting for completed aio requests (write thread) I/O thread 9 state: waiting for completed aio requests (write thread) Pending normal aio reads: [0, 0, 0, 0] , aio writes: [0, 0, 0, 0] , ibuf aio reads:, log i/o's:, sync i/o's: Pending flushes (fsync) log: 0; buffer pool: 0 988961291 OS file reads, 2116055401 OS file writes, 499922006 OS fsyncs 1 pending reads, 0 pending writes 2738.22 reads/s, 16384 avg bytes/read, 37.20 writes/s, 7.40 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 33606, seg size 33608, 30061294 merges merged operations: insert 70458758, delete mark 44687126, delete 5089827 discarded operations: insert 0, delete mark 0, delete 0 0.00 hash searches/s, 61704.35 non-hash searches/s --- LOG --- Log sequence number 21531692136741 Log flushed up to 21531692136741 Pages flushed up to 21531692136741 Last checkpoint at 21531494551865 0 pending log flushes, 0 pending chkp writes 809866292 log i/o's done, 0.67 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total large memory allocated 65810726912 Dictionary memory allocated 1713600 Buffer pool size 3932160 Free buffers 7121 Database pages 3925039 Old database pages 1449047 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 Pending reads 1 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 4341388230, not young 48629325024 10.40 youngs/s, 3673.82 non-youngs/s Pages read 988977606, created 61757490, written 1142004923 2738.22 reads/s, 0.00 creates/s, 33.66 writes/s Buffer pool hit rate 986 / 1000, young-making rate 0 / 1000 not 17 / 1000 Pages read ahead 59.60/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 3925039, unzip_LRU len: 0 I/O sum[1111360]:cur[13168], unzip sum[0]:cur[0] ---------------------- INDIVIDUAL BUFFER POOL INFO ---------------------- ---BUFFER POOL 0 Buffer pool size 491520 Free buffers 898 Database pages 490622 Old database pages 181128 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 582910864, not young 6232235621 0.80 youngs/s, 342.38 non-youngs/s Pages read 127084366, created 7661113, written 152639794 342.38 reads/s, 0.00 creates/s, 4.27 writes/s Buffer pool hit rate 985 / 1000, young-making rate 0 / 1000 not 14 / 1000 Pages read ahead 8.53/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 490622, unzip_LRU len: 0 I/O sum[138920]:cur[1646], unzip sum[0]:cur[0] ---BUFFER POOL 1 Buffer pool size 491520 Free buffers 869 Database pages 490651 Old database pages 181139 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 537727940, not young 6153840165 1.00 youngs/s, 1071.20 non-youngs/s Pages read 123153532, created 7719050, written 140138709 348.84 reads/s, 0.00 creates/s, 2.80 writes/s Buffer pool hit rate 985 / 1000, young-making rate 0 / 1000 not 45 / 1000 Pages read ahead 17.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 490651, unzip_LRU len: 0 I/O sum[138920]:cur[1646], unzip sum[0]:cur[0] ---BUFFER POOL 2 Buffer pool size 491520 Free buffers 892 Database pages 490628 Old database pages 181130 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 529203790, not young 6180677027 1.27 youngs/s, 395.51 non-youngs/s Pages read 122658649, created 7695703, written 138436003 345.24 reads/s, 0.00 creates/s, 11.13 writes/s Buffer pool hit rate 986 / 1000, young-making rate 0 / 1000 not 15 / 1000 Pages read ahead 4.27/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 490628, unzip_LRU len: 0 I/O sum[138920]:cur[1646], unzip sum[0]:cur[0] ---BUFFER POOL 3 Buffer pool size 491520 Free buffers 879 Database pages 490641 Old database pages 181135 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 540014591, not young 5956637961 0.73 youngs/s, 333.51 non-youngs/s Pages read 124234371, created 7822234, written 147085278 333.51 reads/s, 0.00 creates/s, 4.53 writes/s Buffer pool hit rate 981 / 1000, young-making rate 0 / 1000 not 18 / 1000 Pages read ahead 8.53/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 490641, unzip_LRU len: 0 I/O sum[138920]:cur[1646], unzip sum[0]:cur[0] ---BUFFER POOL 4 Buffer pool size 491520 Free buffers 891 Database pages 490629 Old database pages 181131 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 548000824, not young 5944392966 1.93 youngs/s, 416.31 non-youngs/s Pages read 121258651, created 7777689, written 145170375 347.31 reads/s, 0.00 creates/s, 1.60 writes/s Buffer pool hit rate 980 / 1000, young-making rate 0 / 1000 not 23 / 1000 Pages read ahead 4.27/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 490629, unzip_LRU len: 0 I/O sum[138920]:cur[1646], unzip sum[0]:cur[0] ---BUFFER POOL 5 Buffer pool size 491520 Free buffers 895 Database pages 490625 Old database pages 181129 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 525281027, not young 5804806963 1.73 youngs/s, 358.98 non-youngs/s Pages read 122223630, created 7653829, written 141891120 344.18 reads/s, 0.00 creates/s, 4.13 writes/s Buffer pool hit rate 992 / 1000, young-making rate 0 / 1000 not 7 / 1000 Pages read ahead 12.80/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 490625, unzip_LRU len: 0 I/O sum[138920]:cur[1646], unzip sum[0]:cur[0] ---BUFFER POOL 6 Buffer pool size 491520 Free buffers 878 Database pages 490642 Old database pages 181135 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 Pending reads 1 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 542959948, not young 6225416382 1.27 youngs/s, 336.98 non-youngs/s Pages read 124400843, created 7678135, written 138633145 344.31 reads/s, 0.00 creates/s, 3.60 writes/s Buffer pool hit rate 978 / 1000, young-making rate 0 / 1000 not 20 / 1000 Pages read ahead 4.20/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 490642, unzip_LRU len: 0 I/O sum[138920]:cur[1646], unzip sum[0]:cur[0] ---BUFFER POOL 7 Buffer pool size 491520 Free buffers 919 Database pages 490601 Old database pages 181120 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 535289246, not young 6131317939 1.67 youngs/s, 418.97 non-youngs/s Pages read 123963564, created 7749737, written 138010499 332.44 reads/s, 0.00 creates/s, 1.60 writes/s Buffer pool hit rate 991 / 1000, young-making rate 0 / 1000 not 11 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 490601, unzip_LRU len: 0 I/O sum[138920]:cur[1646], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 0 queries inside InnoDB, 0 queries in queue 0 read views open inside InnoDB Process ID=222457, Main thread ID=139953379993344, state: enforcing dict cache limit Number of rows inserted 4181715518, updated 1557472743, deleted 3954300629, read 4516056410519 0.13 inserts/s, 27.53 updates/s, 0.00 deletes/s, 61331.71 reads/s Number of system rows inserted 582, updated 0, deleted 582, read 584 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ ==============SHOW FULL PROCESSLIST *************************** 1. row *************************** Id: 1 User: system user Host: db: NULL Command: Daemon Time: NULL State: InnoDB purge worker Info: NULL Progress: 0.000 *************************** 2. row *************************** Id: 2 User: system user Host: db: NULL Command: Daemon Time: NULL State: InnoDB purge coordinator Info: NULL Progress: 0.000 *************************** 3. row *************************** Id: 4 User: system user Host: db: NULL Command: Daemon Time: NULL State: InnoDB purge worker Info: NULL Progress: 0.000 *************************** 4. row *************************** Id: 3 User: system user Host: db: NULL Command: Daemon Time: NULL State: InnoDB purge worker Info: NULL Progress: 0.000 *************************** 5. row *************************** Id: 5 User: system user Host: db: NULL Command: Daemon Time: NULL State: InnoDB shutdown handler Info: NULL Progress: 0.000 *************************** 10. row *************************** Id: 169032 User: system user Host: db: NULL Command: Slave_IO Time: 9737421 State: Waiting for master to send event Info: NULL Progress: 0.000 *************************** 11. row *************************** Id: 169033 User: system user Host: db: NULL Command: Slave_SQL Time: 53036 State: Slave has read all relay log; waiting for the slave I/O thread to update it Info: NULL Progress: 0.000 *************************** 12. row *************************** Id: 170558 User: event_scheduler Host: localhost db: NULL Command: Daemon Time: 9737215 State: Waiting on empty queue Info: NULL Progress: 0.000 *************************** 15. row *************************** Id: 221341071 User: replication Host: xx.xx.53.128:50350 db: NULL Command: Binlog Dump Time: 3218844 State: Master has sent all binlog to slave; waiting for binlog to be updated Info: NULL Progress: 0.000 *************************** 24. row *************************** Id: 364683203 User: seruser Host: xx.xx.201.18:63266 db: sama Command: Query Time: 154 State: Updating Info: DELETE FROM `mailer_messages` WHERE ........ Progress: 0.000 *************************** 28. row *************************** Id: 365002217 User: seruser Host: xx.xx.52.162:56728 db: sama Command: Query Time: 166 State: Updating Info: UPDATE `part_cpa_calc` SET ........ Progress: 0.000 *************************** 31. row *************************** Id: 365003061 User: seruser Host: xx.xx.52.182:45198 db: sama Command: Execute Time: 163 State: Updating Info: UPDATE `accounts` SET ........ Progress: 0.000 *************************** 34. row *************************** Id: 365003188 User: seruser Host: xx.xx.52.182:8544 db: sama Command: Execute Time: 165 State: Updating Info: UPDATE `accounts` SET ........ Progress: 0.000 *************************** 35. row *************************** Id: 365003210 User: seruser Host: xx.xx.52.182:47506 db: sama Command: Execute Time: 164 State: Updating Info: UPDATE `accounts` SET ........ Progress: 0.000 *************************** 37. row *************************** Id: 365003278 User: seruser Host: xx.xx.52.182:49032 db: sama Command: Execute Time: 17 State: Updating Info: UPDATE `accounts` SET ........ Progress: 0.000 *************************** 40. row *************************** Id: 365004414 User: seruser Host: xx.xx.52.183:53614 db: sama Command: Execute Time: 164 State: Updating Info: UPDATE `accounts` SET ........ Progress: 0.000 *************************** 41. row *************************** Id: 365004668 User: seruser Host: xx.xx.52.183:36178 db: rtm Command: Execute Time: 163 State: Updating Info: UPDATE `accounts` SET ........ Progress: 0.000 *************************** 42. row *************************** Id: 365004941 User: seruser Host: xx.xx.52.182:51236 db: sama Command: Execute Time: 164 State: Updating Info: UPDATE `accounts` SET ........ Progress: 0.000 *************************** 45. row *************************** Id: 365005861 User: seruser Host: xx.xx.52.162:59696 db: sama Command: Query Time: 189 State: Update Info: INSERT INTO `mailer_messages` ........ Progress: 0.000 *************************** 46. row *************************** Id: 365005927 User: seruser Host: xx.xx.52.161:54218 db: sama Command: Query Time: 187 State: Update Info: INSERT INTO `mailer_messages` ........ Progress: 0.000 *************************** 48. row *************************** Id: 365006102 User: seruser Host: xx.xx.52.161:54254 db: sama Command: Query Time: 180 State: Update Info: INSERT INTO `mailer_messages` ........ Progress: 0.000 *************************** 49. row *************************** Id: 365006328 User: seruser Host: xx.xx.52.162:60120 db: sama Command: Query Time: 167 State: Update Info: INSERT INTO `mailer_messages` ........ Progress: 0.000 *************************** 50. row *************************** Id: 365006379 User: seruser Host: xx.xx.52.185:34760 db: sama Command: Query Time: 164 State: Updating Info: UPDATE `clients` SET ........ Progress: 0.000 *************************** 51. row *************************** Id: 365006383 User: seruser Host: xx.xx.52.182:51540 db: sama Command: Query Time: 163 State: Update Info: INSERT INTO `fi_bi` ........ Progress: 0.000 *************************** 52. row *************************** Id: 365006415 User: seruser Host: xx.xx.52.146:35324 db: rtm Command: Query Time: 162 State: Updating Info: UPDATE `accounts` SET ........ Progress: 0.000 *************************** 53. row *************************** Id: 365006455 User: seruser Host: xx.xx.52.174:51076 db: sama Command: Query Time: 159 State: Update Info: INSERT INTO `a_ac_lo` ........ Progress: 0.000 *************************** 54. row *************************** Id: 365006465 User: seruser Host: xx.xx.52.174:51086 db: sama Command: Query Time: 157 State: Update Info: INSERT INTO `a_ac_lo`........ Progress: 0.000 *************************** 55. row *************************** Id: 365006577 User: seruser Host: xx.xx.52.162:60232 db: sama Command: Query Time: 149 State: Updating Info: UPDATE `cl_lo_se` SET ........ Progress: 0.000 *************************** 56. row *************************** Id: 365006595 User: seruser Host: xx.xx.52.185:39636 db: sama Command: Query Time: 148 State: Updating Info: UPDATE `otp_codes` SET ........ Progress: 0.000 *************************** 57. row *************************** Id: 365006608 User: seruser Host: xx.xx.52.147:40750 db: rtm Command: Query Time: 147 State: Updating Info: UPDATE `clients` SET ........ Progress: 0.000 *************************** 58. row *************************** Id: 365006732 User: seruser Host: xx.xx.52.185:36256 db: sama Command: Query Time: 138 State: Updating Info: UPDATE `otp_codes` SET ........ Progress: 0.000 *************************** 59. row *************************** Id: 365006756 User: seruser Host: xx.xx.52.162:60288 db: sama Command: Query Time: 136 State: Updating Info: UPDATE `otp_codes` SET ........ Progress: 0.000 *************************** 60. row *************************** Id: 365006772 User: seruser Host: xx.xx.52.174:51144 db: sama Command: Query Time: 134 State: Updating Info: UPDATE `applications` SET ........ Progress: 0.000 *************************** 61. row *************************** Id: 365006789 User: seruser Host: xx.xx.52.162:60300 db: sama Command: Query Time: 132 State: Update Info: INSERT INTO `otp_codes` ........ Progress: 0.000 *************************** 62. row *************************** Id: 365006801 User: seruser Host: xx.xx.52.183:45830 db: sama Command: Query Time: 131 State: Updating Info: UPDATE `cl_lo_se` SET ........69 Progress: 0.000 *************************** 63. row *************************** Id: 365006909 User: seruser Host: xx.xx.52.146:35568 db: rtm Command: Query Time: 125 State: Update Info: INSERT INTO `documents` ........ Progress: 0.000 *************************** 64. row *************************** Id: 365006919 User: seruser Host: xx.xx.52.183:39842 db: sama Command: Query Time: 124 State: Update Info: INSERT INTO `otp_codes` ........ Progress: 0.000 *************************** 65. row *************************** Id: 365006948 User: seruser Host: xx.xx.52.162:60346 db: sama Command: Query Time: 121 State: Updating Info: DELETE FROM `pu_no_to` ........ Progress: 0.000 *************************** 66. row *************************** Id: 365006955 User: seruser Host: xx.xx.52.185:36062 db: sama Command: Query Time: 121 State: Update Info: INSERT INTO `otp_codes` ........ Progress: 0.000 *************************** 67. row *************************** Id: 365006995 User: seruser Host: xx.xx.52.185:36168 db: sama Command: Query Time: 118 State: Update Info: INSERT INTO `otp_codes` ........ Progress: 0.000 *************************** 68. row *************************** Id: 365007022 User: seruser Host: xx.xx.52.146:35646 db: rtm Command: Query Time: 116 State: Update Info: INSERT INTO `cl_pa_re` ........ Progress: 0.000 *************************** 69. row *************************** Id: 365007051 User: seruser Host: xx.xx.52.147:40982 db: rtm Command: Query Time: 112 State: Updating Info: UPDATE `clients` SET ........ Progress: 0.000 *************************** 70. row *************************** Id: 365007084 User: seruser Host: xx.xx.52.162:60370 db: sama Command: Query Time: 109 State: Updating Info: UPDATE `cl_lo_se` SET ........ Progress: 0.000 *************************** 71. row *************************** Id: 365007092 User: seruser Host: xx.xx.52.185:37122 db: sama Command: Query Time: 109 State: Updating Info: UPDATE `cl_lo_se` SET ........ Progress: 0.000 *************************** 72. row *************************** Id: 365007096 User: seruser Host: xx.xx.52.182:53210 db: sama Command: Query Time: 109 State: Updating Info: UPDATE `client_profiles` SET ........ Progress: 0.000 *************************** 73. row *************************** Id: 365007099 User: seruser Host: xx.xx.52.175:37070 db: sama Command: Query Time: 109 State: Updating Info: UPDATE `applications` SET ........ Progress: 0.000 *************************** 74. row *************************** Id: 365007118 User: seruser Host: xx.xx.52.182:53254 db: sama Command: Query Time: 108 State: Update Info: INSERT INTO `documents` ........ Progress: 0.000 *************************** 75. row *************************** Id: 365007133 User: seruser Host: xx.xx.52.174:51226 db: sama Command: Query Time: 106 State: Updating Info: UPDATE `applications` SET ........ Progress: 0.000 *************************** 76. row *************************** Id: 365007153 User: seruser Host: xx.xx.52.146:35708 db: rtm Command: Query Time: 105 State: Updating Info: UPDATE `clients` SET ........ Progress: 0.000 *************************** 77. row *************************** Id: 365007200 User: seruser Host: xx.xx.52.185:37404 db: sama Command: Query Time: 100 State: Update Info: INSERT INTO `otp_codes` ........ Progress: 0.000 *************************** 78. row *************************** Id: 365007218 User: seruser Host: xx.xx.52.161:54690 db: sama Command: Query Time: 99 State: Update Info: INSERT INTO `mailer_messages` ........ Progress: 0.000 *************************** 79. row *************************** Id: 365007220 User: seruser Host: xx.xx.52.162:60466 db: sama Command: Query Time: 98 State: Updating Info: UPDATE `cl_lo_se` SET ........ Progress: 0.000 *************************** 80. row *************************** Id: 365007238 User: seruser Host: xx.xx.52.183:53826 db: sama Command: Query Time: 95 State: Updating Info: UPDATE `pa_d_add` SET ........ Progress: 0.000 *************************** 81. row *************************** Id: 365007245 User: seruser Host: xx.xx.52.183:53948 db: sama Command: Query Time: 95 State: Updating Info: UPDATE `clients` SET ........ Progress: 0.000 *************************** 82. row *************************** Id: 365007279 User: seruser Host: xx.xx.52.174:51268 db: sama Command: Query Time: 91 State: Updating Info: UPDATE `applications` SET ........ Progress: 0.000 *************************** 83. row *************************** Id: 365007381 User: seruser Host: xx.xx.52.147:41184 db: rtm Command: Query Time: 86 State: Updating Info: UPDATE `clients` SET ........ Progress: 0.000 *************************** 84. row *************************** Id: 365007393 User: seruser Host: xx.xx.52.183:49152 db: sama Command: Query Time: 83 State: Updating Info: UPDATE `cl_lo_se` SET ........ Progress: 0.000 *************************** 85. row *************************** Id: 365007399 User: seruser Host: xx.xx.52.174:51298 db: sama Command: Query Time: 81 State: Updating Info: UPDATE `applications` SET ........ Progress: 0.000 *************************** 86. row *************************** Id: 365007408 User: seruser Host: xx.xx.52.174:51308 db: sama Command: Query Time: 79 State: Updating Info: UPDATE `applications` SET ........ Progress: 0.000 *************************** 87. row *************************** Id: 365007414 User: seruser Host: xx.xx.52.161:54744 db: sama Command: Query Time: 78 State: Update Info: INSERT INTO `otp_codes` ........ Progress: 0.000 *************************** 88. row *************************** Id: 365007415 User: seruser Host: xx.xx.52.161:54746 db: sama_stats Command: Sleep Time: 78 State: Info: NULL Progress: 0.000 *************************** 89. row *************************** Id: 365007431 User: seruser Host: xx.xx.52.161:54756 db: sama Command: Query Time: 74 State: Update Info: INSERT INTO `otp_codes` ........ Progress: 0.000 *************************** 91. row *************************** Id: 365007433 User: seruser Host: xx.xx.52.161:54760 db: sama Command: Query Time: 73 State: Update Info: INSERT INTO `pu_no_me` ........ Progress: 0.000 *************************** 92. row *************************** Id: 365007434 User: seruser Host: xx.xx.52.162:60526 db: sama Command: Query Time: 73 State: Update Info: INSERT INTO `otp_codes` ........ Progress: 0.000 *************************** 94. row *************************** Id: 365007447 User: seruser Host: xx.xx.52.182:54284 db: sama Command: Query Time: 71 State: Updating Info: UPDATE `cl_lo_se` SET ........ Progress: 0.000 *************************** 95. row *************************** Id: 365007449 User: seruser Host: xx.xx.52.185:37476 db: sama Command: Query Time: 70 State: Update Info: INSERT INTO `otp_codes` ........ Progress: 0.000 *************************** 96. row *************************** Id: 365007469 User: seruser Host: xx.xx.52.162:60538 db: sama Command: Query Time: 68 State: Updating Info: DELETE FROM `pu_no_to` WHERE ........ Progress: 0.000 *************************** 97. row *************************** Id: 365007471 User: seruser Host: xx.xx.52.183:34246 db: sama Command: Query Time: 68 State: Updating Info: UPDATE `cl_lo_se` SET ........ Progress: 0.000 *************************** 98. row *************************** Id: 365007496 User: seruser Host: xx.xx.52.183:42312 db: sama Command: Query Time: 65 State: Update Info: INSERT INTO `fi_bi` ........ Progress: 0.000 *************************** 99. row *************************** Id: 365007529 User: seruser Host: xx.xx.52.162:60562 db: sama Command: Query Time: 60 State: Update Info: INSERT INTO `mailer_messages` ........ Progress: 0.000 *************************** 100. row *************************** Id: 365007534 User: seruser Host: xx.xx.52.161:54798 db: sama Command: Query Time: 59 State: Updating Info: UPDATE `cl_lo_se` SET ........ Progress: 0.000 *************************** 102. row *************************** Id: 365007565 User: seruser Host: xx.xx.52.146:35932 db: rtm Command: Query Time: 55 State: Update Info: INSERT INTO `cl_pa_re` ........ Progress: 0.000 *************************** 103. row *************************** Id: 365007573 User: seruser Host: xx.xx.52.185:42360 db: sama Command: Query Time: 52 State: Updating Info: UPDATE `clients` SET ........ Progress: 0.000 *************************** 105. row *************************** Id: 365007580 User: seruser Host: xx.xx.52.183:45428 db: sama Command: Query Time: 50 State: Updating Info: UPDATE `clients` SET ........ Progress: 0.000 *************************** 106. row *************************** Id: 365007582 User: seruser Host: xx.xx.52.185:42414 db: sama Command: Query Time: 50 State: Updating Info: UPDATE `cl_lo_se` SET ........ Progress: 0.000 *************************** 107. row *************************** Id: 365007585 User: seruser Host: xx.xx.52.161:54864 db: sama Command: Query Time: 49 State: Update Info: INSERT INTO `cl_lo_se` ........ Progress: 0.000 *************************** 109. row *************************** Id: 365007598 User: seruser Host: xx.xx.52.183:38556 db: sama Command: Query Time: 48 State: Updating Info: UPDATE `cl_lo_se` SET ........ Progress: 0.000 *************************** 110. row *************************** Id: 365007613 User: seruser Host: xx.xx.52.147:41278 db: rtm Command: Query Time: 48 State: Update Info: INSERT INTO `documents` ........ Progress: 0.000 *************************** 111. row *************************** Id: 365007620 User: seruser Host: xx.xx.52.185:38922 db: sama Command: Query Time: 45 State: Updating Info: UPDATE `pa_d_add` SET ........ Progress: 0.000 *************************** 112. row *************************** Id: 365007623 User: seruser Host: xx.xx.52.174:51396 db: sama Command: Query Time: 44 State: Updating Info: UPDATE `applications` SET ........ Progress: 0.000 *************************** 113. row *************************** Id: 365007635 User: seruser Host: xx.xx.52.147:41304 db: rtm Command: Query Time: 39 State: Updating Info: UPDATE `clients` SET ........ Progress: 0.000 *************************** 114. row *************************** Id: 365007636 User: seruser Host: xx.xx.52.161:54878 db: sama Command: Query Time: 38 State: Updating Info: UPDATE `cl_lo_se` SET ........ Progress: 0.000 *************************** 116. row *************************** Id: 365007640 User: seruser Host: xx.xx.52.183:37916 db: sama Command: Query Time: 38 State: Updating Info: UPDATE `pa_d_add` SET ........ Progress: 0.000 *************************** 117. row *************************** Id: 365007641 User: seruser Host: xx.xx.52.162:60648 db: sama Command: Query Time: 38 State: Updating Info: UPDATE `cl_lo_se` SET ........ Progress: 0.000 *************************** 119. row *************************** Id: 365007646 User: seruser Host: xx.xx.52.162:60662 db: sama Command: Query Time: 36 State: Updating Info: UPDATE `cl_lo_se` SET ........ Progress: 0.000 *************************** 121. row *************************** Id: 365007652 User: seruser Host: xx.xx.52.162:60668 db: sama Command: Query Time: 34 State: Update Info: INSERT INTO `otp_codes` ........ Progress: 0.000 *************************** 123. row *************************** Id: 365007685 User: seruser Host: xx.xx.52.161:54894 db: sama Command: Query Time: 33 State: Updating Info: UPDATE `cl_lo_se` SET ........ Progress: 0.000 *************************** 125. row *************************** Id: 365007714 User: seruser Host: xx.xx.52.146:36044 db: rtm Command: Query Time: 33 State: Update Info: INSERT INTO `documents` ........ Progress: 0.000 *************************** 126. row *************************** Id: 365007718 User: seruser Host: xx.xx.52.183:60198 db: sama Command: Query Time: 31 State: Updating Info: UPDATE `cl_lo_se` SET ........ Progress: 0.000 *************************** 127. row *************************** Id: 365007723 User: seruser Host: xx.xx.52.185:43036 db: sama Command: Query Time: 30 State: Updating Info: UPDATE `cl_lo_se` SET ........ Progress: 0.000 *************************** 128. row *************************** Id: 365007729 User: seruser Host: xx.xx.52.183:60458 db: sama Command: Query Time: 30 State: Updating Info: UPDATE `cl_lo_se` SET ........ Progress: 0.000 *************************** 129. row *************************** Id: 365007731 User: seruser Host: xx.xx.52.183:42504 db: sama Command: Query Time: 30 State: Updating Info: UPDATE `cl_lo_se` SET ........ Progress: 0.000 *************************** 130. row *************************** Id: 365007735 User: seruser Host: xx.xx.52.162:60682 db: sama Command: Query Time: 29 State: Updating Info: UPDATE `cl_lo_se` SET ........ Progress: 0.000 *************************** 132. row *************************** Id: 365007746 User: seruser Host: xx.xx.52.185:38752 db: sama Command: Query Time: 28 State: Updating Info: UPDATE `cl_lo_se` SET ........ Progress: 0.000 *************************** 133. row *************************** Id: 365007767 User: seruser Host: xx.xx.52.185:38876 db: sama Command: Query Time: 24 State: Updating Info: UPDATE `cl_lo_se` SET ........ Progress: 0.000 *************************** 134. row *************************** Id: 365007770 User: seruser Host: xx.xx.52.175:37340 db: sama Command: Query Time: 22 State: Updating Info: UPDATE `applications` SET ........ Progress: 0.000 *************************** 135. row *************************** Id: 365007771 User: seruser Host: xx.xx.52.161:54912 db: sama Command: Query Time: 21 State: Update Info: INSERT INTO `cl_lo_se` ........ Progress: 0.000 *************************** 137. row *************************** Id: 365007853 User: seruser Host: xx.xx.52.146:36184 db: rtm Command: Query Time: 20 State: Updating Info: UPDATE `clients` SET ........ Progress: 0.000 *************************** 138. row *************************** Id: 365007868 User: seruser Host: xx.xx.52.162:60714 db: sama Command: Query Time: 17 State: Updating Info: UPDATE `cl_lo_se` SET ........ Progress: 0.000 *************************** 140. row *************************** Id: 365007871 User: seruser Host: xx.xx.52.185:39788 db: sama Command: Query Time: 16 State: Updating Info: UPDATE `cl_lo_se` SET ........ Progress: 0.000 *************************** 141. row *************************** Id: 365007875 User: seruser Host: xx.xx.52.182:55978 db: sama Command: Query Time: 14 State: Updating Info: UPDATE `cl_lo_se` SET ........ Progress: 0.000 *************************** 142. row *************************** Id: 365007876 User: seruser Host: xx.xx.52.182:55980 db: sama Command: Query Time: 14 State: Updating Info: UPDATE `clients` SET ........ Progress: 0.000 *************************** 143. row *************************** Id: 365007877 User: seruser Host: xx.xx.52.161:54920 db: sama Command: Query Time: 14 State: Updating Info: UPDATE `cl_lo_se` SET........ Progress: 0.000 *************************** 145. row *************************** Id: 365007879 User: seruser Host: xx.xx.52.174:51482 db: sama Command: Query Time: 14 State: Updating Info: UPDATE `applications` SET ........ Progress: 0.000 *************************** 146. row *************************** Id: 365007934 User: seruser Host: xx.xx.52.162:60722 db: sama Command: Query Time: 11 State: Updating Info: UPDATE `cl_lo_se` SET ........ Progress: 0.000 *************************** 148. row *************************** Id: 365007990 User: seruser Host: xx.xx.52.147:41544 db: rtm Command: Query Time: 8 State: Updating Info: UPDATE `clients` SET ........ Progress: 0.000 *************************** 149. row *************************** Id: 365007992 User: seruser Host: xx.xx.52.185:40002 db: sama Command: Query Time: 7 State: Updating Info: UPDATE `cl_lo_se` SET ........ Progress: 0.000 *************************** 150. row *************************** Id: 365007993 User: seruser Host: xx.xx.52.146:36328 db: rtm Command: Query Time: 7 State: Updating Info: UPDATE `clients` SET ........ Progress: 0.000 *************************** 151. row *************************** Id: 365008006 User: seruser Host: xx.xx.52.146:36334 db: rtm Command: Query Time: 3 State: Updating Info: UPDATE `clients` SET ........ Progress: 0.000 *************************** 152. row *************************** Id: 365008016 User: seruser Host: xx.xx.52.183:45796 db: sama Command: Query Time: 1 State: Updating Info: UPDATE `cl_lo_se` SET ........ Progress: 0.000 *************************** 153. row *************************** Id: 365008017 User: seruser Host: xx.xx.52.183:45818 db: sama Command: Query Time: 1 State: Updating Info: UPDATE `cl_lo_se` SET ........ Progress: 0.000 *************************** 155. row *************************** Id: 365008029 User: root Host: localhost db: NULL Command: Query Time: 0 State: Init Info: SHOW FULL PROCESSLIST Progress: 0.000 ============innodb_trx *************************** 1. row *************************** trx_id: 28947429658 trx_state: LOCK WAIT trx_started: 2021-03-07 14:43:54 trx_requested_lock_id: 28947429658:7209:29506:67 trx_wait_started: 2021-03-07 14:43:54 trx_weight: 2 trx_mysql_thread_id: 365008017 trx_query: UPDATE `cl_lo_se` SET ........ trx_operation_state: starting index read trx_tables_in_use: 1 trx_tables_locked: 1 trx_lock_structs: 2 trx_lock_memory_bytes: 1128 trx_rows_locked: 1 trx_rows_modified: 0 trx_concurrency_tickets: 0 trx_isolation_level: READ COMMITTED trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 *************************** 2. row *************************** trx_id: 28947429657 trx_state: LOCK WAIT trx_started: 2021-03-07 14:43:54 trx_requested_lock_id: 28947429657:7209:29506:67 trx_wait_started: 2021-03-07 14:43:54 trx_weight: 2 trx_mysql_thread_id: 365008016 trx_query: UPDATE `cl_lo_se` SET ........ trx_operation_state: starting index read trx_tables_in_use: 1 trx_tables_locked: 1 trx_lock_structs: 2 trx_lock_memory_bytes: 1128 trx_rows_locked: 1 trx_rows_modified: 0 trx_concurrency_tickets: 0 trx_isolation_level: READ COMMITTED trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 *************************** 3. row *************************** trx_id: 28947429656 trx_state: RUNNING trx_started: 2021-03-07 14:43:52 trx_requested_lock_id: NULL trx_wait_started: NULL trx_weight: 2 trx_mysql_thread_id: 365008006 trx_query: UPDATE `clients` SET ........ trx_operation_state: updating or deleting trx_tables_in_use: 1 trx_tables_locked: 1 trx_lock_structs: 2 trx_lock_memory_bytes: 1128 trx_rows_locked: 1 trx_rows_modified: 0 trx_concurrency_tickets: 0 trx_isolation_level: READ COMMITTED trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 *************************** 4. row *************************** trx_id: 28947429652 trx_state: LOCK WAIT trx_started: 2021-03-07 14:43:48 trx_requested_lock_id: 28947429652:7265:7946:64 trx_wait_started: 2021-03-07 14:43:48 trx_weight: 2 trx_mysql_thread_id: 365007993 trx_query: UPDATE `clients` SET ........ trx_operation_state: starting index read trx_tables_in_use: 1 trx_tables_locked: 1 trx_lock_structs: 2 trx_lock_memory_bytes: 1128 trx_rows_locked: 1 trx_rows_modified: 0 trx_concurrency_tickets: 0 trx_isolation_level: READ COMMITTED trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 *************************** 5. row *************************** trx_id: 28947429653 trx_state: LOCK WAIT trx_started: 2021-03-07 14:43:48 trx_requested_lock_id: 28947429653:7209:41410:69 trx_wait_started: 2021-03-07 14:43:48 trx_weight: 2 trx_mysql_thread_id: 365007992 trx_query: UPDATE `cl_lo_se` SET ........ trx_operation_state: starting index read trx_tables_in_use: 1 trx_tables_locked: 1 trx_lock_structs: 2 trx_lock_memory_bytes: 1128 trx_rows_locked: 1 trx_rows_modified: 0 trx_concurrency_tickets: 0 trx_isolation_level: READ COMMITTED trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 *************************** 6. row *************************** trx_id: 28947429651 trx_state: RUNNING trx_started: 2021-03-07 14:43:47 trx_requested_lock_id: NULL trx_wait_started: NULL trx_weight: 2 trx_mysql_thread_id: 365007990 trx_query: UPDATE `clients` SET ........ trx_operation_state: updating or deleting trx_tables_in_use: 1 trx_tables_locked: 1 trx_lock_structs: 2 trx_lock_memory_bytes: 1128 trx_rows_locked: 1 trx_rows_modified: 0 trx_concurrency_tickets: 0 trx_isolation_level: READ COMMITTED trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 *************************** 7. row *************************** trx_id: 28947429646 trx_state: LOCK WAIT trx_started: 2021-03-07 14:43:44 trx_requested_lock_id: 28947429646:7209:40088:382 trx_wait_started: 2021-03-07 14:43:44 trx_weight: 2 trx_mysql_thread_id: 365007934 trx_query: UPDATE `cl_lo_se` SET ........ trx_operation_state: starting index read trx_tables_in_use: 1 trx_tables_locked: 1 trx_lock_structs: 2 trx_lock_memory_bytes: 1128 trx_rows_locked: 1 trx_rows_modified: 0 trx_concurrency_tickets: 0 trx_isolation_level: READ COMMITTED trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 *************************** 8. row *************************** trx_id: 28947429643 trx_state: LOCK WAIT trx_started: 2021-03-07 14:43:41 trx_requested_lock_id: 28947429643:5911:39601:3 trx_wait_started: 2021-03-07 14:43:41 trx_weight: 2 trx_mysql_thread_id: 365007879 trx_query: UPDATE `applications` SET ........ trx_operation_state: starting index read trx_tables_in_use: 1 trx_tables_locked: 1 trx_lock_structs: 2 trx_lock_memory_bytes: 1128 trx_rows_locked: 1 trx_rows_modified: 0 trx_concurrency_tickets: 0 trx_isolation_level: REPEATABLE READ trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 *************************** 9. row *************************** trx_id: 28947429642 trx_state: LOCK WAIT trx_started: 2021-03-07 14:43:41 trx_requested_lock_id: 28947429642:7209:6894:542 trx_wait_started: 2021-03-07 14:43:41 trx_weight: 19 trx_mysql_thread_id: 365007877 trx_query: UPDATE `cl_lo_se` SET ........ trx_operation_state: fetching rows trx_tables_in_use: 1 trx_tables_locked: 1 trx_lock_structs: 19 trx_lock_memory_bytes: 3488 trx_rows_locked: 1 trx_rows_modified: 0 trx_concurrency_tickets: 0 trx_isolation_level: READ COMMITTED trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 *************************** 10. row *************************** trx_id: 28947429639 trx_state: LOCK WAIT trx_started: 2021-03-07 14:43:41 trx_requested_lock_id: 28947429639:7042:22182:54 trx_wait_started: 2021-03-07 14:43:41 trx_weight: 2 trx_mysql_thread_id: 365007876 trx_query: UPDATE `clients`........ trx_operation_state: starting index read trx_tables_in_use: 1 trx_tables_locked: 1 trx_lock_structs: 2 trx_lock_memory_bytes: 1128 trx_rows_locked: 1 trx_rows_modified: 0 trx_concurrency_tickets: 0 trx_isolation_level: READ COMMITTED trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 *************************** 11. row *************************** trx_id: 28947429638 trx_state: RUNNING trx_started: 2021-03-07 14:43:41 trx_requested_lock_id: NULL trx_wait_started: NULL trx_weight: 2 trx_mysql_thread_id: 365007875 trx_query: UPDATE `cl_lo_se` SET ........ trx_operation_state: updating or deleting trx_tables_in_use: 1 trx_tables_locked: 1 trx_lock_structs: 2 trx_lock_memory_bytes: 1128 trx_rows_locked: 1 trx_rows_modified: 0 trx_concurrency_tickets: 0 trx_isolation_level: READ COMMITTED trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 *************************** 12. row *************************** trx_id: 28947429637 trx_state: LOCK WAIT trx_started: 2021-03-07 14:43:39 trx_requested_lock_id: 28947429637:7209:29506:67 trx_wait_started: 2021-03-07 14:43:39 trx_weight: 2 trx_mysql_thread_id: 365007871 trx_query: UPDATE `cl_lo_se` SET ........ trx_operation_state: starting index read trx_tables_in_use: 1 trx_tables_locked: 1 trx_lock_structs: 2 trx_lock_memory_bytes: 1128 trx_rows_locked: 1 trx_rows_modified: 0 trx_concurrency_tickets: 0 trx_isolation_level: READ COMMITTED trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 *************************** 13. row *************************** trx_id: 28947429636 trx_state: LOCK WAIT trx_started: 2021-03-07 14:43:38 trx_requested_lock_id: 28947429636:7209:21433:909 trx_wait_started: 2021-03-07 14:43:38 trx_weight: 13 trx_mysql_thread_id: 365007868 trx_query: UPDATE `cl_lo_se` SET ........ trx_operation_state: fetching rows trx_tables_in_use: 1 trx_tables_locked: 1 trx_lock_structs: 13 trx_lock_memory_bytes: 1128 trx_rows_locked: 1 trx_rows_modified: 0 trx_concurrency_tickets: 0 trx_isolation_level: READ COMMITTED trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 *************************** 14. row *************************** trx_id: 28947429628 trx_state: RUNNING trx_started: 2021-03-07 14:43:35 trx_requested_lock_id: NULL trx_wait_started: NULL trx_weight: 2 trx_mysql_thread_id: 365007853 trx_query: UPDATE `clients` ........ trx_operation_state: updating or deleting trx_tables_in_use: 1 trx_tables_locked: 1 trx_lock_structs: 2 trx_lock_memory_bytes: 1128 trx_rows_locked: 1 trx_rows_modified: 0 trx_concurrency_tickets: 0 trx_isolation_level: READ COMMITTED trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 *************************** 15. row *************************** trx_id: 28947429627 trx_state: RUNNING trx_started: 2021-03-07 14:43:34 trx_requested_lock_id: NULL trx_wait_started: NULL trx_weight: 2 trx_mysql_thread_id: 365007771 trx_query: INSERT INTO `cl_lo_se` SET ........ trx_operation_state: inserting trx_tables_in_use: 1 trx_tables_locked: 1 trx_lock_structs: 1 trx_lock_memory_bytes: 1128 trx_rows_locked: 0 trx_rows_modified: 1 trx_concurrency_tickets: 0 trx_isolation_level: READ COMMITTED trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 *************************** 16. row *************************** trx_id: 28947429623 trx_state: RUNNING trx_started: 2021-03-07 14:43:33 trx_requested_lock_id: NULL trx_wait_started: NULL trx_weight: 2 trx_mysql_thread_id: 365007770 trx_query: UPDATE `applications` SET ........ trx_operation_state: updating or deleting trx_tables_in_use: 1 trx_tables_locked: 1 trx_lock_structs: 2 trx_lock_memory_bytes: 1128 trx_rows_locked: 1 trx_rows_modified: 0 trx_concurrency_tickets: 0 trx_isolation_level: REPEATABLE READ trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 *************************** 17. row *************************** trx_id: 28947429622 trx_state: LOCK WAIT trx_started: 2021-03-07 14:43:31 trx_requested_lock_id: 28947429622:7209:43989:72 trx_wait_started: 2021-03-07 14:43:31 trx_weight: 2 trx_mysql_thread_id: 365007767 trx_query: UPDATE `cl_lo_se` SET ........ trx_operation_state: starting index read trx_tables_in_use: 1 trx_tables_locked: 1 trx_lock_structs: 2 trx_lock_memory_bytes: 1128 trx_rows_locked: 1 trx_rows_modified: 0 trx_concurrency_tickets: 0 trx_isolation_level: READ COMMITTED trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 *************************** 18. row *************************** trx_id: 28947429621 trx_state: RUNNING trx_started: 2021-03-07 14:43:27 trx_requested_lock_id: NULL trx_wait_started: NULL trx_weight: 2 trx_mysql_thread_id: 365007746 trx_query: UPDATE `cl_lo_se` SET ........ trx_operation_state: updating or deleting trx_tables_in_use: 1 trx_tables_locked: 1 trx_lock_structs: 2 trx_lock_memory_bytes: 1128 trx_rows_locked: 1 trx_rows_modified: 0 trx_concurrency_tickets: 0 trx_isolation_level: READ COMMITTED trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 *************************** 19. row *************************** trx_id: 28947429620 trx_state: LOCK WAIT trx_started: 2021-03-07 14:43:26 trx_requested_lock_id: 28947429620:7209:35911:257 trx_wait_started: 2021-03-07 14:43:26 trx_weight: 6 trx_mysql_thread_id: 365007735 trx_query: UPDATE `cl_lo_se` SET ........ trx_operation_state: fetching rows trx_tables_in_use: 1 trx_tables_locked: 1 trx_lock_structs: 6 trx_lock_memory_bytes: 1128 trx_rows_locked: 1 trx_rows_modified: 0 trx_concurrency_tickets: 0 trx_isolation_level: READ COMMITTED trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 *************************** 20. row *************************** trx_id: 28947429615 trx_state: RUNNING trx_started: 2021-03-07 14:43:25 trx_requested_lock_id: NULL trx_wait_started: NULL trx_weight: 2 trx_mysql_thread_id: 365007731 trx_query: UPDATE `cl_lo_se` SET ........ trx_operation_state: updating or deleting trx_tables_in_use: 1 trx_tables_locked: 1 trx_lock_structs: 2 trx_lock_memory_bytes: 1128 trx_rows_locked: 1 trx_rows_modified: 0 trx_concurrency_tickets: 0 trx_isolation_level: READ COMMITTED trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 *************************** 21. row *************************** trx_id: 28947429614 trx_state: RUNNING trx_started: 2021-03-07 14:43:25 trx_requested_lock_id: NULL trx_wait_started: NULL trx_weight: 2 trx_mysql_thread_id: 365007729 trx_query: UPDATE `cl_lo_se` SET ........ trx_operation_state: updating or deleting trx_tables_in_use: 1 trx_tables_locked: 1 trx_lock_structs: 2 trx_lock_memory_bytes: 1128 trx_rows_locked: 1 trx_rows_modified: 0 trx_concurrency_tickets: 0 trx_isolation_level: READ COMMITTED trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 *************************** 22. row *************************** trx_id: 28947429613 trx_state: RUNNING trx_started: 2021-03-07 14:43:25 trx_requested_lock_id: NULL trx_wait_started: NULL trx_weight: 2 trx_mysql_thread_id: 365007723 trx_query: UPDATE `cl_lo_se` SET ........ trx_operation_state: updating or deleting trx_tables_in_use: 1 trx_tables_locked: 1 trx_lock_structs: 2 trx_lock_memory_bytes: 1128 trx_rows_locked: 1 trx_rows_modified: 0 trx_concurrency_tickets: 0 trx_isolation_level: READ COMMITTED trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 *************************** 23. row *************************** trx_id: 28947429612 trx_state: LOCK WAIT trx_started: 2021-03-07 14:43:24 trx_requested_lock_id: 28947429612:7209:29506:67 trx_wait_started: 2021-03-07 14:43:24 trx_weight: 2 trx_mysql_thread_id: 365007718 trx_query: UPDATE `cl_lo_se` SET ........ trx_operation_state: starting index read trx_tables_in_use: 1 trx_tables_locked: 1 trx_lock_structs: 2 trx_lock_memory_bytes: 1128 trx_rows_locked: 1 trx_rows_modified: 0 trx_concurrency_tickets: 0 trx_isolation_level: READ COMMITTED trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 *************************** 24. row *************************** trx_id: 28947429611 trx_state: RUNNING trx_started: 2021-03-07 14:43:22 trx_requested_lock_id: NULL trx_wait_started: NULL trx_weight: 2 trx_mysql_thread_id: 365007714 trx_query: INSERT INTO `documents` ........ trx_operation_state: inserting trx_tables_in_use: 1 trx_tables_locked: 1 trx_lock_structs: 1 trx_lock_memory_bytes: 1128 trx_rows_locked: 0 trx_rows_modified: 1 trx_concurrency_tickets: 0 trx_isolation_level: READ COMMITTED trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 *************************** 25. row *************************** trx_id: 28947429610 trx_state: RUNNING trx_started: 2021-03-07 14:43:22 trx_requested_lock_id: NULL trx_wait_started: NULL trx_weight: 6 trx_mysql_thread_id: 365007685 trx_query: UPDATE `cl_lo_se` SET ........ trx_operation_state: updating or deleting trx_tables_in_use: 1 trx_tables_locked: 1 trx_lock_structs: 6 trx_lock_memory_bytes: 1128 trx_rows_locked: 2 trx_rows_modified: 0 trx_concurrency_tickets: 0 trx_isolation_level: READ COMMITTED trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 *************************** 26. row *************************** trx_id: 28947429605 trx_state: RUNNING trx_started: 2021-03-07 14:43:21 trx_requested_lock_id: NULL trx_wait_started: NULL trx_weight: 2 trx_mysql_thread_id: 365007652 trx_query: INSERT INTO `otp_codes` ........ trx_operation_state: inserting trx_tables_in_use: 1 trx_tables_locked: 1 trx_lock_structs: 1 trx_lock_memory_bytes: 1128 trx_rows_locked: 0 trx_rows_modified: 1 trx_concurrency_tickets: 0 trx_isolation_level: READ COMMITTED trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 *************************** 27. row *************************** trx_id: 28947429600 trx_state: RUNNING trx_started: 2021-03-07 14:43:19 trx_requested_lock_id: NULL trx_wait_started: NULL trx_weight: 3 trx_mysql_thread_id: 365007646 trx_query: UPDATE `cl_lo_se` SET ........ trx_operation_state: updating or deleting trx_tables_in_use: 1 trx_tables_locked: 1 trx_lock_structs: 3 trx_lock_memory_bytes: 1128 trx_rows_locked: 2 trx_rows_modified: 0 trx_concurrency_tickets: 0 trx_isolation_level: READ COMMITTED trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 *************************** 28. row *************************** trx_id: 28947429596 trx_state: RUNNING trx_started: 2021-03-07 14:43:17 trx_requested_lock_id: NULL trx_wait_started: NULL trx_weight: 3 trx_mysql_thread_id: 365007641 trx_query: UPDATE `cl_lo_se` SET ........ trx_operation_state: updating or deleting trx_tables_in_use: 1 trx_tables_locked: 1 trx_lock_structs: 3 trx_lock_memory_bytes: 1128 trx_rows_locked: 2 trx_rows_modified: 0 trx_concurrency_tickets: 0 trx_isolation_level: READ COMMITTED trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 *************************** 29. row *************************** trx_id: 28947429597 trx_state: LOCK WAIT trx_started: 2021-03-07 14:43:17 trx_requested_lock_id: 28947429597:7311:110:130 trx_wait_started: 2021-03-07 14:43:17 trx_weight: 2 trx_mysql_thread_id: 365007640 trx_query: UPDATE `pa_d_add` SET ........ trx_operation_state: starting index read trx_tables_in_use: 1 trx_tables_locked: 1 trx_lock_structs: 2 trx_lock_memory_bytes: 1128 trx_rows_locked: 1 trx_rows_modified: 0 trx_concurrency_tickets: 0 trx_isolation_level: READ COMMITTED trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 *************************** 30. row *************************** trx_id: 28947429593 trx_state: RUNNING trx_started: 2021-03-07 14:43:17 trx_requested_lock_id: NULL trx_wait_started: NULL trx_weight: 19 trx_mysql_thread_id: 365007636 trx_query: UPDATE `cl_lo_se` SET ........ trx_operation_state: updating or deleting trx_tables_in_use: 1 trx_tables_locked: 1 trx_lock_structs: 19 trx_lock_memory_bytes: 3488 trx_rows_locked: 2 trx_rows_modified: 0 trx_concurrency_tickets: 0 trx_isolation_level: READ COMMITTED trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 *************************** 31. row *************************** trx_id: 28947429590 trx_state: LOCK WAIT trx_started: 2021-03-07 14:43:16 trx_requested_lock_id: 28947429590:7265:8785:8 trx_wait_started: 2021-03-07 14:43:16 trx_weight: 2 trx_mysql_thread_id: 365007635 trx_query: UPDATE `clients` ........ trx_operation_state: starting index read trx_tables_in_use: 1 trx_tables_locked: 1 trx_lock_structs: 2 trx_lock_memory_bytes: 1128 trx_rows_locked: 1 trx_rows_modified: 0 trx_concurrency_tickets: 0 trx_isolation_level: READ COMMITTED trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 *************************** 32. row *************************** trx_id: 28947429589 trx_state: RUNNING trx_started: 2021-03-07 14:43:11 trx_requested_lock_id: NULL trx_wait_started: NULL trx_weight: 2 trx_mysql_thread_id: 365007623 trx_query: UPDATE `applications` SET ........ trx_operation_state: updating or deleting trx_tables_in_use: 1 trx_tables_locked: 1 trx_lock_structs: 2 trx_lock_memory_bytes: 1128 trx_rows_locked: 1 trx_rows_modified: 0 trx_concurrency_tickets: 0 trx_isolation_level: REPEATABLE READ trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 *************************** 33. row *************************** trx_id: 28947429588 trx_state: LOCK WAIT trx_started: 2021-03-07 14:43:10 trx_requested_lock_id: 28947429588:7311:110:130 trx_wait_started: 2021-03-07 14:43:10 trx_weight: 2 trx_mysql_thread_id: 365007620 trx_query: UPDATE `pa_d_add` SET ........ trx_operation_state: starting index read trx_tables_in_use: 1 trx_tables_locked: 1 trx_lock_structs: 2 trx_lock_memory_bytes: 1128 trx_rows_locked: 1 trx_rows_modified: 0 trx_concurrency_tickets: 0 trx_isolation_level: READ COMMITTED trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 *************************** 34. row *************************** trx_id: 28947429587 trx_state: RUNNING trx_started: 2021-03-07 14:43:07 trx_requested_lock_id: NULL trx_wait_started: NULL trx_weight: 2 trx_mysql_thread_id: 365007613 trx_query: INSERT INTO `documents` ........ trx_operation_state: inserting trx_tables_in_use: 1 trx_tables_locked: 1 trx_lock_structs: 1 trx_lock_memory_bytes: 1128 trx_rows_locked: 0 trx_rows_modified: 1 trx_concurrency_tickets: 0 trx_isolation_level: READ COMMITTED trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 *************************** 35. row *************************** trx_id: 28947429582 trx_state: RUNNING trx_started: 2021-03-07 14:43:07 trx_requested_lock_id: NULL trx_wait_started: NULL trx_weight: 2 trx_mysql_thread_id: 365007598 trx_query: UPDATE `cl_lo_se` SET ........ trx_operation_state: updating or deleting trx_tables_in_use: 1 trx_tables_locked: 1 trx_lock_structs: 2 trx_lock_memory_bytes: 1128 trx_rows_locked: 1 trx_rows_modified: 0 trx_concurrency_tickets: 0 trx_isolation_level: READ COMMITTED trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 *************************** 36. row *************************** trx_id: 28947429576 trx_state: RUNNING trx_started: 2021-03-07 14:43:06 trx_requested_lock_id: NULL trx_wait_started: NULL trx_weight: 2 trx_mysql_thread_id: 365007585 trx_query: INSERT INTO `cl_lo_se` ........ trx_operation_state: inserting trx_tables_in_use: 1 trx_tables_locked: 1 trx_lock_structs: 1 trx_lock_memory_bytes: 1128 trx_rows_locked: 0 trx_rows_modified: 1 trx_concurrency_tickets: 0 trx_isolation_level: READ COMMITTED trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 *************************** 37. row *************************** trx_id: 28947429572 trx_state: RUNNING trx_started: 2021-03-07 14:43:05 trx_requested_lock_id: NULL trx_wait_started: NULL trx_weight: 2 trx_mysql_thread_id: 365007582 trx_query: UPDATE `cl_lo_se` SET ........ trx_operation_state: updating or deleting trx_tables_in_use: 1 trx_tables_locked: 1 trx_lock_structs: 2 trx_lock_memory_bytes: 1128 trx_rows_locked: 1 trx_rows_modified: 0 trx_concurrency_tickets: 0 trx_isolation_level: READ COMMITTED trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 *************************** 38. row *************************** trx_id: 28947429571 trx_state: LOCK WAIT trx_started: 2021-03-07 14:43:05 trx_requested_lock_id: 28947429571:7042:43615:29 trx_wait_started: 2021-03-07 14:43:05 trx_weight: 2 trx_mysql_thread_id: 365007580 trx_query: UPDATE `clients` SET ........ trx_operation_state: starting index read trx_tables_in_use: 1 trx_tables_locked: 1 trx_lock_structs: 2 trx_lock_memory_bytes: 1128 trx_rows_locked: 1 trx_rows_modified: 0 trx_concurrency_tickets: 0 trx_isolation_level: READ COMMITTED trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 *************************** 39. row *************************** trx_id: 28947429569 trx_state: RUNNING trx_started: 2021-03-07 14:43:03 trx_requested_lock_id: NULL trx_wait_started: NULL trx_weight: 2 trx_mysql_thread_id: 365007573 trx_query: UPDATE `clients` SET ........ trx_operation_state: updating or deleting trx_tables_in_use: 1 trx_tables_locked: 1 trx_lock_structs: 2 trx_lock_memory_bytes: 1128 trx_rows_locked: 1 trx_rows_modified: 0 trx_concurrency_tickets: 0 trx_isolation_level: READ COMMITTED trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 *************************** 40. row *************************** trx_id: 28947429568 trx_state: RUNNING trx_started: 2021-03-07 14:43:00 trx_requested_lock_id: NULL trx_wait_started: NULL trx_weight: 2 trx_mysql_thread_id: 365007565 trx_query: INSERT INTO `cl_pa_re` ........ trx_operation_state: inserting trx_tables_in_use: 1 trx_tables_locked: 1 trx_lock_structs: 1 trx_lock_memory_bytes: 1128 trx_rows_locked: 0 trx_rows_modified: 1 trx_concurrency_tickets: 0 trx_isolation_level: READ COMMITTED trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 *************************** 41. row *************************** trx_id: 28947429565 trx_state: RUNNING trx_started: 2021-03-07 14:42:56 trx_requested_lock_id: NULL trx_wait_started: NULL trx_weight: 3 trx_mysql_thread_id: 365007534 trx_query: UPDATE `cl_lo_se` SET ........ trx_operation_state: updating or deleting trx_tables_in_use: 1 trx_tables_locked: 1 trx_lock_structs: 3 trx_lock_memory_bytes: 1128 trx_rows_locked: 2 trx_rows_modified: 0 trx_concurrency_tickets: 0 trx_isolation_level: READ COMMITTED trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 *************************** 42. row *************************** trx_id: 28947429562 trx_state: RUNNING trx_started: 2021-03-07 14:42:56 trx_requested_lock_id: NULL trx_wait_started: NULL trx_weight: 1 trx_mysql_thread_id: 365007529 trx_query: INSERT INTO `mailer_messages` ........ trx_operation_state: inserting trx_tables_in_use: 1 trx_tables_locked: 1 trx_lock_structs: 1 trx_lock_memory_bytes: 1128 trx_rows_locked: 0 trx_rows_modified: 0 trx_concurrency_tickets: 0 trx_isolation_level: READ COMMITTED trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 *************************** 43. row *************************** trx_id: 28947429545 trx_state: RUNNING trx_started: 2021-03-07 14:42:50 trx_requested_lock_id: NULL trx_wait_started: NULL trx_weight: 2 trx_mysql_thread_id: 365007496 trx_query: INSERT INTO `fi_bi` ........ trx_operation_state: inserting trx_tables_in_use: 1 trx_tables_locked: 1 trx_lock_structs: 1 trx_lock_memory_bytes: 1128 trx_rows_locked: 0 trx_rows_modified: 1 trx_concurrency_tickets: 0 trx_isolation_level: READ COMMITTED trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 *************************** 44. row *************************** trx_id: 28947429542 trx_state: RUNNING trx_started: 2021-03-07 14:42:47 trx_requested_lock_id: NULL trx_wait_started: NULL trx_weight: 2 trx_mysql_thread_id: 365007471 trx_query: UPDATE `cl_lo_se` SET ........ trx_operation_state: updating or deleting trx_tables_in_use: 1 trx_tables_locked: 1 trx_lock_structs: 2 trx_lock_memory_bytes: 1128 trx_rows_locked: 1 trx_rows_modified: 0 trx_concurrency_tickets: 0 trx_isolation_level: READ COMMITTED trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 *************************** 45. row *************************** trx_id: 28947429541 trx_state: RUNNING trx_started: 2021-03-07 14:42:47 trx_requested_lock_id: NULL trx_wait_started: NULL trx_weight: 2 trx_mysql_thread_id: 365007469 trx_query: DELETE FROM `pu_no_to` WHERE ........ trx_operation_state: updating or deleting trx_tables_in_use: 1 trx_tables_locked: 1 trx_lock_structs: 2 trx_lock_memory_bytes: 1128 trx_rows_locked: 1 trx_rows_modified: 0 trx_concurrency_tickets: 0 trx_isolation_level: READ COMMITTED trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 *************************** 46. row *************************** trx_id: 28947429540 trx_state: RUNNING trx_started: 2021-03-07 14:42:45 trx_requested_lock_id: NULL trx_wait_started: NULL trx_weight: 2 trx_mysql_thread_id: 365007449 trx_query: INSERT INTO `otp_codes` ........ trx_operation_state: inserting trx_tables_in_use: 1 trx_tables_locked: 1 trx_lock_structs: 1 trx_lock_memory_bytes: 1128 trx_rows_locked: 0 trx_rows_modified: 1 trx_concurrency_tickets: 0 trx_isolation_level: READ COMMITTED trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 *************************** 47. row *************************** trx_id: 28947429539 trx_state: RUNNING trx_started: 2021-03-07 14:42:44 trx_requested_lock_id: NULL trx_wait_started: NULL trx_weight: 2 trx_mysql_thread_id: 365007447 trx_query: UPDATE `cl_lo_se` SET ........ trx_operation_state: updating or deleting trx_tables_in_use: 1 trx_tables_locked: 1 trx_lock_structs: 2 trx_lock_memory_bytes: 1128 trx_rows_locked: 1 trx_rows_modified: 0 trx_concurrency_tickets: 0 trx_isolation_level: READ COMMITTED trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 *************************** 48. row *************************** trx_id: 28947429537 trx_state: RUNNING trx_started: 2021-03-07 14:42:42 trx_requested_lock_id: NULL trx_wait_started: NULL trx_weight: 2 trx_mysql_thread_id: 365007434 trx_query: INSERT INTO `otp_codes` ........ trx_operation_state: inserting trx_tables_in_use: 1 trx_tables_locked: 1 trx_lock_structs: 1 trx_lock_memory_bytes: 1128 trx_rows_locked: 0 trx_rows_modified: 1 trx_concurrency_tickets: 0 trx_isolation_level: READ COMMITTED trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 *************************** 49. row *************************** trx_id: 28947429538 trx_state: RUNNING trx_started: 2021-03-07 14:42:42 trx_requested_lock_id: NULL trx_wait_started: NULL trx_weight: 2 trx_mysql_thread_id: 365007433 trx_query: INSERT INTO `pu_no_me` ........ trx_operation_state: inserting trx_tables_in_use: 1 trx_tables_locked: 1 trx_lock_structs: 1 trx_lock_memory_bytes: 1128 trx_rows_locked: 0 trx_rows_modified: 1 trx_concurrency_tickets: 0 trx_isolation_level: READ COMMITTED trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 *************************** 50. row *************************** trx_id: 28947429532 trx_state: RUNNING trx_started: 2021-03-07 14:42:41 trx_requested_lock_id: NULL trx_wait_started: NULL trx_weight: 2 trx_mysql_thread_id: 365007431 trx_query: INSERT INTO `otp_codes` ........ trx_operation_state: inserting trx_tables_in_use: 1 trx_tables_locked: 1 trx_lock_structs: 1 trx_lock_memory_bytes: 1128 trx_rows_locked: 0 trx_rows_modified: 1 trx_concurrency_tickets: 0 trx_isolation_level: READ COMMITTED trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 *************************** 51. row *************************** trx_id: 28947429529 trx_state: RUNNING trx_started: 2021-03-07 14:42:37 trx_requested_lock_id: NULL trx_wait_started: NULL trx_weight: 2 trx_mysql_thread_id: 365007414 trx_query: INSERT INTO `otp_codes` ........ trx_operation_state: inserting trx_tables_in_use: 1 trx_tables_locked: 1 trx_lock_structs: 1 trx_lock_memory_bytes: 1128 trx_rows_locked: 0 trx_rows_modified: 1 trx_concurrency_tickets: 0 trx_isolation_level: READ COMMITTED trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 *************************** 52. row *************************** trx_id: 28947429525 trx_state: RUNNING trx_started: 2021-03-07 14:42:36 trx_requested_lock_id: NULL trx_wait_started: NULL trx_weight: 2 trx_mysql_thread_id: 365007408 trx_query: UPDATE `applications` SET ........ trx_operation_state: updating or deleting trx_tables_in_use: 1 trx_tables_locked: 1 trx_lock_structs: 2 trx_lock_memory_bytes: 1128 trx_rows_locked: 1 trx_rows_modified: 0 trx_concurrency_tickets: 0 trx_isolation_level: REPEATABLE READ trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 *************************** 53. row *************************** trx_id: 28947429522 trx_state: RUNNING trx_started: 2021-03-07 14:42:34 trx_requested_lock_id: NULL trx_wait_started: NULL trx_weight: 2 trx_mysql_thread_id: 365007399 trx_query: UPDATE `applications` SET ........ trx_operation_state: updating or deleting trx_tables_in_use: 1 trx_tables_locked: 1 trx_lock_structs: 2 trx_lock_memory_bytes: 1128 trx_rows_locked: 1 trx_rows_modified: 0 trx_concurrency_tickets: 0 trx_isolation_level: REPEATABLE READ trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 *************************** 54. row *************************** trx_id: 28947429520 trx_state: RUNNING trx_started: 2021-03-07 14:42:32 trx_requested_lock_id: NULL trx_wait_started: NULL trx_weight: 2 trx_mysql_thread_id: 365007393 trx_query: UPDATE `cl_lo_se` SET ........ trx_operation_state: updating or deleting trx_tables_in_use: 1 trx_tables_locked: 1 trx_lock_structs: 2 trx_lock_memory_bytes: 1128 trx_rows_locked: 1 trx_rows_modified: 0 trx_concurrency_tickets: 0 trx_isolation_level: READ COMMITTED trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 *************************** 55. row *************************** trx_id: 28947429517 trx_state: RUNNING trx_started: 2021-03-07 14:42:29 trx_requested_lock_id: NULL trx_wait_started: NULL trx_weight: 2 trx_mysql_thread_id: 365007381 trx_query: UPDATE `clients` SET ........ trx_operation_state: updating or deleting trx_tables_in_use: 1 trx_tables_locked: 1 trx_lock_structs: 2 trx_lock_memory_bytes: 1128 trx_rows_locked: 1 trx_rows_modified: 0 trx_concurrency_tickets: 0 trx_isolation_level: READ COMMITTED trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 *************************** 56. row *************************** trx_id: 28947429499 trx_state: RUNNING trx_started: 2021-03-07 14:42:24 trx_requested_lock_id: NULL trx_wait_started: NULL trx_weight: 2 trx_mysql_thread_id: 365007279 trx_query: UPDATE `applications` SET ........ trx_operation_state: updating or deleting trx_tables_in_use: 1 trx_tables_locked: 1 trx_lock_structs: 2 trx_lock_memory_bytes: 1128 trx_rows_locked: 1 trx_rows_modified: 0 trx_concurrency_tickets: 0 trx_isolation_level: REPEATABLE READ trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 *************************** 57. row *************************** trx_id: 28947429498 trx_state: RUNNING trx_started: 2021-03-07 14:42:20 trx_requested_lock_id: NULL trx_wait_started: NULL trx_weight: 2 trx_mysql_thread_id: 365007245 trx_query: UPDATE `clients` SET ........ trx_operation_state: updating or deleting trx_tables_in_use: 1 trx_tables_locked: 1 trx_lock_structs: 2 trx_lock_memory_bytes: 1128 trx_rows_locked: 1 trx_rows_modified: 0 trx_concurrency_tickets: 0 trx_isolation_level: READ COMMITTED trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 *************************** 58. row *************************** trx_id: 28947429497 trx_state: RUNNING trx_started: 2021-03-07 14:42:20 trx_requested_lock_id: NULL trx_wait_started: NULL trx_weight: 2 trx_mysql_thread_id: 365007238 trx_query: UPDATE `pa_d_add` SET ........ trx_operation_state: updating or deleting trx_tables_in_use: 1 trx_tables_locked: 1 trx_lock_structs: 2 trx_lock_memory_bytes: 1128 trx_rows_locked: 1 trx_rows_modified: 0 trx_concurrency_tickets: 0 trx_isolation_level: READ COMMITTED trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 *************************** 59. row *************************** trx_id: 28947429496 trx_state: RUNNING trx_started: 2021-03-07 14:42:17 trx_requested_lock_id: NULL trx_wait_started: NULL trx_weight: 6 trx_mysql_thread_id: 365007220 trx_query: UPDATE `cl_lo_se` SET ........ trx_operation_state: updating or deleting trx_tables_in_use: 1 trx_tables_locked: 1 trx_lock_structs: 6 trx_lock_memory_bytes: 1128 trx_rows_locked: 2 trx_rows_modified: 0 trx_concurrency_tickets: 0 trx_isolation_level: READ COMMITTED trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 *************************** 60. row *************************** trx_id: 28947429493 trx_state: RUNNING trx_started: 2021-03-07 14:42:16 trx_requested_lock_id: NULL trx_wait_started: NULL trx_weight: 1 trx_mysql_thread_id: 365007218 trx_query: INSERT INTO `mailer_messages` ........ trx_operation_state: inserting trx_tables_in_use: 1 trx_tables_locked: 1 trx_lock_structs: 1 trx_lock_memory_bytes: 1128 trx_rows_locked: 0 trx_rows_modified: 0 trx_concurrency_tickets: 0 trx_isolation_level: READ COMMITTED trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 *************************** 61. row *************************** trx_id: 28947429490 trx_state: RUNNING trx_started: 2021-03-07 14:42:15 trx_requested_lock_id: NULL trx_wait_started: NULL trx_weight: 2 trx_mysql_thread_id: 365007200 trx_query: INSERT INTO `otp_codes` ........ trx_operation_state: inserting trx_tables_in_use: 1 trx_tables_locked: 1 trx_lock_structs: 1 trx_lock_memory_bytes: 1128 trx_rows_locked: 0 trx_rows_modified: 1 trx_concurrency_tickets: 0 trx_isolation_level: READ COMMITTED trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 *************************** 62. row *************************** trx_id: 28947429488 trx_state: RUNNING trx_started: 2021-03-07 14:42:10 trx_requested_lock_id: NULL trx_wait_started: NULL trx_weight: 2 trx_mysql_thread_id: 365007153 trx_query: UPDATE `clients` SET ........ trx_operation_state: updating or deleting trx_tables_in_use: 1 trx_tables_locked: 1 trx_lock_structs: 2 trx_lock_memory_bytes: 1128 trx_rows_locked: 1 trx_rows_modified: 0 trx_concurrency_tickets: 0 trx_isolation_level: READ COMMITTED trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 *************************** 63. row *************************** trx_id: 28947429485 trx_state: RUNNING trx_started: 2021-03-07 14:42:09 trx_requested_lock_id: NULL trx_wait_started: NULL trx_weight: 2 trx_mysql_thread_id: 365007133 trx_query: UPDATE `applications` SET ........ trx_operation_state: updating or deleting trx_tables_in_use: 1 trx_tables_locked: 1 trx_lock_structs: 2 trx_lock_memory_bytes: 1128 trx_rows_locked: 1 trx_rows_modified: 0 trx_concurrency_tickets: 0 trx_isolation_level: REPEATABLE READ trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 *************************** 64. row *************************** trx_id: 28947429484 trx_state: RUNNING trx_started: 2021-03-07 14:42:07 trx_requested_lock_id: NULL trx_wait_started: NULL trx_weight: 2 trx_mysql_thread_id: 365007118 trx_query: INSERT INTO `documents` ........ trx_operation_state: inserting trx_tables_in_use: 1 trx_tables_locked: 1 trx_lock_structs: 1 trx_lock_memory_bytes: 1128 trx_rows_locked: 0 trx_rows_modified: 1 trx_concurrency_tickets: 0 trx_isolation_level: READ COMMITTED trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 *************************** 65. row *************************** trx_id: 28947429483 trx_state: RUNNING trx_started: 2021-03-07 14:42:06 trx_requested_lock_id: NULL trx_wait_started: NULL trx_weight: 2 trx_mysql_thread_id: 365007099 trx_query: UPDATE `applications` SET ........ trx_operation_state: updating or deleting trx_tables_in_use: 1 trx_tables_locked: 1 trx_lock_structs: 2 trx_lock_memory_bytes: 1128 trx_rows_locked: 1 trx_rows_modified: 0 trx_concurrency_tickets: 0 trx_isolation_level: REPEATABLE READ trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 *************************** 66. row *************************** trx_id: 28947429482 trx_state: RUNNING trx_started: 2021-03-07 14:42:06 trx_requested_lock_id: NULL trx_wait_started: NULL trx_weight: 2 trx_mysql_thread_id: 365007096 trx_query: UPDATE `client_profiles` SET ........ trx_operation_state: updating or deleting trx_tables_in_use: 1 trx_tables_locked: 1 trx_lock_structs: 2 trx_lock_memory_bytes: 1128 trx_rows_locked: 1 trx_rows_modified: 0 trx_concurrency_tickets: 0 trx_isolation_level: READ COMMITTED trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 *************************** 67. row *************************** trx_id: 28947429481 trx_state: RUNNING trx_started: 2021-03-07 14:42:06 trx_requested_lock_id: NULL trx_wait_started: NULL trx_weight: 2 trx_mysql_thread_id: 365007092 trx_query: UPDATE `cl_lo_se` SET ........ trx_operation_state: updating or deleting trx_tables_in_use: 1 trx_tables_locked: 1 trx_lock_structs: 2 trx_lock_memory_bytes: 1128 trx_rows_locked: 1 trx_rows_modified: 0 trx_concurrency_tickets: 0 trx_isolation_level: READ COMMITTED trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 *************************** 68. row *************************** trx_id: 28947429480 trx_state: RUNNING trx_started: 2021-03-07 14:42:06 trx_requested_lock_id: NULL trx_wait_started: NULL trx_weight: 13 trx_mysql_thread_id: 365007084 trx_query: UPDATE `cl_lo_se` SET ........ trx_operation_state: updating or deleting trx_tables_in_use: 1 trx_tables_locked: 1 trx_lock_structs: 13 trx_lock_memory_bytes: 1128 trx_rows_locked: 2 trx_rows_modified: 0 trx_concurrency_tickets: 0 trx_isolation_level: READ COMMITTED trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 *************************** 69. row *************************** trx_id: 28947429477 trx_state: RUNNING trx_started: 2021-03-07 14:42:03 trx_requested_lock_id: NULL trx_wait_started: NULL trx_weight: 2 trx_mysql_thread_id: 365007051 trx_query: UPDATE `clients` SET ........ trx_operation_state: updating or deleting trx_tables_in_use: 1 trx_tables_locked: 1 trx_lock_structs: 2 trx_lock_memory_bytes: 1128 trx_rows_locked: 1 trx_rows_modified: 0 trx_concurrency_tickets: 0 trx_isolation_level: READ COMMITTED trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 *************************** 70. row *************************** trx_id: 28947429476 trx_state: RUNNING trx_started: 2021-03-07 14:41:59 trx_requested_lock_id: NULL trx_wait_started: NULL trx_weight: 2 trx_mysql_thread_id: 365007022 trx_query: INSERT INTO `cl_pa_re` ........ trx_operation_state: inserting trx_tables_in_use: 1 trx_tables_locked: 1 trx_lock_structs: 1 trx_lock_memory_bytes: 1128 trx_rows_locked: 0 trx_rows_modified: 1 trx_concurrency_tickets: 0 trx_isolation_level: READ COMMITTED trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 *************************** 71. row *************************** trx_id: 28947429472 trx_state: RUNNING trx_started: 2021-03-07 14:41:58 trx_requested_lock_id: NULL trx_wait_started: NULL trx_weight: 2 trx_mysql_thread_id: 365006995 trx_query: INSERT INTO `otp_codes` ........ trx_operation_state: inserting trx_tables_in_use: 1 trx_tables_locked: 1 trx_lock_structs: 1 trx_lock_memory_bytes: 1128 trx_rows_locked: 0 trx_rows_modified: 1 trx_concurrency_tickets: 0 trx_isolation_level: READ COMMITTED trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 *************************** 72. row *************************** trx_id: 28947429467 trx_state: RUNNING trx_started: 2021-03-07 14:41:54 trx_requested_lock_id: NULL trx_wait_started: NULL trx_weight: 2 trx_mysql_thread_id: 365006955 trx_query: INSERT INTO `otp_codes` ........ trx_operation_state: inserting trx_tables_in_use: 1 trx_tables_locked: 1 trx_lock_structs: 1 trx_lock_memory_bytes: 1128 trx_rows_locked: 0 trx_rows_modified: 1 trx_concurrency_tickets: 0 trx_isolation_level: READ COMMITTED trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 *************************** 73. row *************************** trx_id: 28947429464 trx_state: RUNNING trx_started: 2021-03-07 14:41:54 trx_requested_lock_id: NULL trx_wait_started: NULL trx_weight: 2 trx_mysql_thread_id: 365006948 trx_query: DELETE FROM `pu_no_to` WHERE ........ trx_operation_state: updating or deleting trx_tables_in_use: 1 trx_tables_locked: 1 trx_lock_structs: 2 trx_lock_memory_bytes: 1128 trx_rows_locked: 1 trx_rows_modified: 0 trx_concurrency_tickets: 0 trx_isolation_level: READ COMMITTED trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 *************************** 74. row *************************** trx_id: 28947429453 trx_state: RUNNING trx_started: 2021-03-07 14:41:51 trx_requested_lock_id: NULL trx_wait_started: NULL trx_weight: 2 trx_mysql_thread_id: 365006919 trx_query: INSERT INTO `otp_codes` ........ trx_operation_state: inserting trx_tables_in_use: 1 trx_tables_locked: 1 trx_lock_structs: 1 trx_lock_memory_bytes: 1128 trx_rows_locked: 0 trx_rows_modified: 1 trx_concurrency_tickets: 0 trx_isolation_level: READ COMMITTED trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 *************************** 75. row *************************** trx_id: 28947429451 trx_state: RUNNING trx_started: 2021-03-07 14:41:50 trx_requested_lock_id: NULL trx_wait_started: NULL trx_weight: 2 trx_mysql_thread_id: 365006909 trx_query: INSERT INTO `documents` ........ trx_operation_state: inserting trx_tables_in_use: 1 trx_tables_locked: 1 trx_lock_structs: 1 trx_lock_memory_bytes: 1128 trx_rows_locked: 0 trx_rows_modified: 1 trx_concurrency_tickets: 0 trx_isolation_level: READ COMMITTED trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 *************************** 76. row *************************** trx_id: 28947429433 trx_state: RUNNING trx_started: 2021-03-07 14:41:44 trx_requested_lock_id: NULL trx_wait_started: NULL trx_weight: 2 trx_mysql_thread_id: 365006801 trx_query: UPDATE `cl_lo_se` SET ........ trx_operation_state: updating or deleting trx_tables_in_use: 1 trx_tables_locked: 1 trx_lock_structs: 2 trx_lock_memory_bytes: 1128 trx_rows_locked: 1 trx_rows_modified: 0 trx_concurrency_tickets: 0 trx_isolation_level: READ COMMITTED trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 *************************** 77. row *************************** trx_id: 28947429430 trx_state: RUNNING trx_started: 2021-03-07 14:41:43 trx_requested_lock_id: NULL trx_wait_started: NULL trx_weight: 2 trx_mysql_thread_id: 365006789 trx_query: INSERT INTO `otp_codes` ........ trx_operation_state: inserting trx_tables_in_use: 1 trx_tables_locked: 1 trx_lock_structs: 1 trx_lock_memory_bytes: 1128 trx_rows_locked: 0 trx_rows_modified: 1 trx_concurrency_tickets: 0 trx_isolation_level: READ COMMITTED trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 *************************** 78. row *************************** trx_id: 28947429422 trx_state: RUNNING trx_started: 2021-03-07 14:41:41 trx_requested_lock_id: NULL trx_wait_started: NULL trx_weight: 2 trx_mysql_thread_id: 365006772 trx_query: UPDATE `applications` SET ........ trx_operation_state: updating or deleting trx_tables_in_use: 1 trx_tables_locked: 1 trx_lock_structs: 2 trx_lock_memory_bytes: 1128 trx_rows_locked: 1 trx_rows_modified: 0 trx_concurrency_tickets: 0 trx_isolation_level: REPEATABLE READ trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 *************************** 79. row *************************** trx_id: 28947429417 trx_state: RUNNING trx_started: 2021-03-07 14:41:39 trx_requested_lock_id: NULL trx_wait_started: NULL trx_weight: 2 trx_mysql_thread_id: 365006756 trx_query: UPDATE `otp_codes` SET ........ trx_operation_state: updating or deleting trx_tables_in_use: 1 trx_tables_locked: 1 trx_lock_structs: 2 trx_lock_memory_bytes: 1128 trx_rows_locked: 1 trx_rows_modified: 0 trx_concurrency_tickets: 0 trx_isolation_level: READ COMMITTED trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 *************************** 80. row *************************** trx_id: 28947429409 trx_state: RUNNING trx_started: 2021-03-07 14:41:37 trx_requested_lock_id: NULL trx_wait_started: NULL trx_weight: 2 trx_mysql_thread_id: 365006732 trx_query: UPDATE `otp_codes` SET ........ trx_operation_state: updating or deleting trx_tables_in_use: 1 trx_tables_locked: 1 trx_lock_structs: 2 trx_lock_memory_bytes: 1128 trx_rows_locked: 1 trx_rows_modified: 0 trx_concurrency_tickets: 0 trx_isolation_level: READ COMMITTED trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 *************************** 81. row *************************** trx_id: 28947429379 trx_state: RUNNING trx_started: 2021-03-07 14:41:28 trx_requested_lock_id: NULL trx_wait_started: NULL trx_weight: 2 trx_mysql_thread_id: 365006608 trx_query: UPDATE `clients` SET ........ trx_operation_state: updating or deleting trx_tables_in_use: 1 trx_tables_locked: 1 trx_lock_structs: 2 trx_lock_memory_bytes: 1128 trx_rows_locked: 1 trx_rows_modified: 0 trx_concurrency_tickets: 0 trx_isolation_level: READ COMMITTED trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 *************************** 82. row *************************** trx_id: 28947429377 trx_state: RUNNING trx_started: 2021-03-07 14:41:27 trx_requested_lock_id: NULL trx_wait_started: NULL trx_weight: 2 trx_mysql_thread_id: 365006595 trx_query: UPDATE `otp_codes` SET ........ trx_operation_state: updating or deleting trx_tables_in_use: 1 trx_tables_locked: 1 trx_lock_structs: 2 trx_lock_memory_bytes: 1128 trx_rows_locked: 1 trx_rows_modified: 0 trx_concurrency_tickets: 0 trx_isolation_level: READ COMMITTED trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 *************************** 83. row *************************** trx_id: 28947429372 trx_state: RUNNING trx_started: 2021-03-07 14:41:26 trx_requested_lock_id: NULL trx_wait_started: NULL trx_weight: 2 trx_mysql_thread_id: 365006577 trx_query: UPDATE `cl_lo_se` SET ........ trx_operation_state: updating or deleting trx_tables_in_use: 1 trx_tables_locked: 1 trx_lock_structs: 2 trx_lock_memory_bytes: 1128 trx_rows_locked: 1 trx_rows_modified: 0 trx_concurrency_tickets: 0 trx_isolation_level: READ COMMITTED trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 *************************** 84. row *************************** trx_id: 28947429339 trx_state: RUNNING trx_started: 2021-03-07 14:41:18 trx_requested_lock_id: NULL trx_wait_started: NULL trx_weight: 2 trx_mysql_thread_id: 365006465 trx_query: INSERT INTO `a_ac_lo` ........ trx_operation_state: inserting trx_tables_in_use: 1 trx_tables_locked: 1 trx_lock_structs: 1 trx_lock_memory_bytes: 1128 trx_rows_locked: 0 trx_rows_modified: 1 trx_concurrency_tickets: 0 trx_isolation_level: REPEATABLE READ trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 *************************** 85. row *************************** trx_id: 28947429333 trx_state: RUNNING trx_started: 2021-03-07 14:41:16 trx_requested_lock_id: NULL trx_wait_started: NULL trx_weight: 2 trx_mysql_thread_id: 365006455 trx_query: INSERT INTO `a_ac_lo` ........ trx_operation_state: inserting trx_tables_in_use: 1 trx_tables_locked: 1 trx_lock_structs: 1 trx_lock_memory_bytes: 1128 trx_rows_locked: 0 trx_rows_modified: 1 trx_concurrency_tickets: 0 trx_isolation_level: REPEATABLE READ trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 *************************** 86. row *************************** trx_id: 28947429317 trx_state: RUNNING trx_started: 2021-03-07 14:41:13 trx_requested_lock_id: NULL trx_wait_started: NULL trx_weight: 2 trx_mysql_thread_id: 365006415 trx_query: UPDATE `accounts` SET ........ trx_operation_state: updating or deleting trx_tables_in_use: 1 trx_tables_locked: 1 trx_lock_structs: 2 trx_lock_memory_bytes: 1128 trx_rows_locked: 1 trx_rows_modified: 0 trx_concurrency_tickets: 0 trx_isolation_level: READ COMMITTED trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 *************************** 87. row *************************** trx_id: 28947429310 trx_state: RUNNING trx_started: 2021-03-07 14:41:12 trx_requested_lock_id: NULL trx_wait_started: NULL trx_weight: 2 trx_mysql_thread_id: 365006383 trx_query: INSERT INTO `fi_bi` ........ trx_operation_state: inserting trx_tables_in_use: 1 trx_tables_locked: 1 trx_lock_structs: 1 trx_lock_memory_bytes: 1128 trx_rows_locked: 0 trx_rows_modified: 1 trx_concurrency_tickets: 0 trx_isolation_level: READ COMMITTED trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 *************************** 88. row *************************** trx_id: 28947429307 trx_state: RUNNING trx_started: 2021-03-07 14:41:11 trx_requested_lock_id: NULL trx_wait_started: NULL trx_weight: 2 trx_mysql_thread_id: 365006379 trx_query: UPDATE `clients` ........ trx_operation_state: updating or deleting trx_tables_in_use: 1 trx_tables_locked: 1 trx_lock_structs: 2 trx_lock_memory_bytes: 1128 trx_rows_locked: 1 trx_rows_modified: 0 trx_concurrency_tickets: 0 trx_isolation_level: READ COMMITTED trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 *************************** 89. row *************************** trx_id: 28947429274 trx_state: RUNNING trx_started: 2021-03-07 14:41:08 trx_requested_lock_id: NULL trx_wait_started: NULL trx_weight: 1 trx_mysql_thread_id: 365006328 trx_query: INSERT INTO `mailer_messages` ........ trx_operation_state: inserting trx_tables_in_use: 1 trx_tables_locked: 1 trx_lock_structs: 1 trx_lock_memory_bytes: 1128 trx_rows_locked: 0 trx_rows_modified: 0 trx_concurrency_tickets: 0 trx_isolation_level: READ COMMITTED trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 *************************** 90. row *************************** trx_id: 28947429043 trx_state: RUNNING trx_started: 2021-03-07 14:40:55 trx_requested_lock_id: NULL trx_wait_started: NULL trx_weight: 1 trx_mysql_thread_id: 365006102 trx_query: INSERT INTO `mailer_messages` ........ trx_operation_state: inserting trx_tables_in_use: 1 trx_tables_locked: 1 trx_lock_structs: 1 trx_lock_memory_bytes: 1128 trx_rows_locked: 0 trx_rows_modified: 0 trx_concurrency_tickets: 0 trx_isolation_level: READ COMMITTED trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 *************************** 91. row *************************** trx_id: 28947428892 trx_state: RUNNING trx_started: 2021-03-07 14:40:48 trx_requested_lock_id: NULL trx_wait_started: NULL trx_weight: 1 trx_mysql_thread_id: 365005927 trx_query: INSERT INTO `mailer_messages` ........ trx_operation_state: inserting trx_tables_in_use: 1 trx_tables_locked: 1 trx_lock_structs: 1 trx_lock_memory_bytes: 1128 trx_rows_locked: 0 trx_rows_modified: 0 trx_concurrency_tickets: 0 trx_isolation_level: READ COMMITTED trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 *************************** 92. row *************************** trx_id: 28947428844 trx_state: RUNNING trx_started: 2021-03-07 14:40:46 trx_requested_lock_id: NULL trx_wait_started: NULL trx_weight: 2 trx_mysql_thread_id: 365005861 trx_query: INSERT INTO `mailer_messages` ........ trx_operation_state: inserting trx_tables_in_use: 1 trx_tables_locked: 1 trx_lock_structs: 1 trx_lock_memory_bytes: 1128 trx_rows_locked: 0 trx_rows_modified: 1 trx_concurrency_tickets: 0 trx_isolation_level: READ COMMITTED trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 *************************** 93. row *************************** trx_id: 28947429304 trx_state: RUNNING trx_started: 2021-03-07 14:41:11 trx_requested_lock_id: NULL trx_wait_started: NULL trx_weight: 3 trx_mysql_thread_id: 365004941 trx_query: UPDATE `accounts` SET ........ trx_operation_state: updating or deleting trx_tables_in_use: 1 trx_tables_locked: 1 trx_lock_structs: 3 trx_lock_memory_bytes: 1128 trx_rows_locked: 2 trx_rows_modified: 0 trx_concurrency_tickets: 0 trx_isolation_level: REPEATABLE READ trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 *************************** 94. row *************************** trx_id: 28947429313 trx_state: RUNNING trx_started: 2021-03-07 14:41:12 trx_requested_lock_id: NULL trx_wait_started: NULL trx_weight: 3 trx_mysql_thread_id: 365004668 trx_query: UPDATE `accounts` SET ........ trx_operation_state: updating or deleting trx_tables_in_use: 1 trx_tables_locked: 1 trx_lock_structs: 3 trx_lock_memory_bytes: 1128 trx_rows_locked: 2 trx_rows_modified: 0 trx_concurrency_tickets: 0 trx_isolation_level: REPEATABLE READ trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 *************************** 95. row *************************** trx_id: 28947429306 trx_state: RUNNING trx_started: 2021-03-07 14:41:11 trx_requested_lock_id: NULL trx_wait_started: NULL trx_weight: 3 trx_mysql_thread_id: 365004414 trx_query: UPDATE `accounts` SET ........ trx_operation_state: updating or deleting trx_tables_in_use: 1 trx_tables_locked: 1 trx_lock_structs: 3 trx_lock_memory_bytes: 1128 trx_rows_locked: 2 trx_rows_modified: 0 trx_concurrency_tickets: 0 trx_isolation_level: REPEATABLE READ trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 *************************** 96. row *************************** trx_id: 28947429633 trx_state: RUNNING trx_started: 2021-03-07 14:43:38 trx_requested_lock_id: NULL trx_wait_started: NULL trx_weight: 3 trx_mysql_thread_id: 365003278 trx_query: UPDATE `accounts` SET ........ trx_operation_state: updating or deleting trx_tables_in_use: 1 trx_tables_locked: 1 trx_lock_structs: 3 trx_lock_memory_bytes: 1128 trx_rows_locked: 2 trx_rows_modified: 0 trx_concurrency_tickets: 0 trx_isolation_level: REPEATABLE READ trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 *************************** 97. row *************************** trx_id: 28947429309 trx_state: RUNNING trx_started: 2021-03-07 14:41:12 trx_requested_lock_id: NULL trx_wait_started: NULL trx_weight: 3 trx_mysql_thread_id: 365003210 trx_query: UPDATE `accounts` SET ........ trx_operation_state: updating or deleting trx_tables_in_use: 1 trx_tables_locked: 1 trx_lock_structs: 3 trx_lock_memory_bytes: 1128 trx_rows_locked: 2 trx_rows_modified: 0 trx_concurrency_tickets: 0 trx_isolation_level: REPEATABLE READ trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 *************************** 98. row *************************** trx_id: 28947429301 trx_state: RUNNING trx_started: 2021-03-07 14:41:10 trx_requested_lock_id: NULL trx_wait_started: NULL trx_weight: 3 trx_mysql_thread_id: 365003188 trx_query: UPDATE `accounts` SET ........ trx_operation_state: updating or deleting trx_tables_in_use: 1 trx_tables_locked: 1 trx_lock_structs: 3 trx_lock_memory_bytes: 1128 trx_rows_locked: 2 trx_rows_modified: 0 trx_concurrency_tickets: 0 trx_isolation_level: REPEATABLE READ trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 *************************** 99. row *************************** trx_id: 28947429311 trx_state: RUNNING trx_started: 2021-03-07 14:41:12 trx_requested_lock_id: NULL trx_wait_started: NULL trx_weight: 3 trx_mysql_thread_id: 365003061 trx_query: UPDATE `accounts` SET ........ trx_operation_state: updating or deleting trx_tables_in_use: 1 trx_tables_locked: 1 trx_lock_structs: 3 trx_lock_memory_bytes: 1128 trx_rows_locked: 2 trx_rows_modified: 0 trx_concurrency_tickets: 0 trx_isolation_level: REPEATABLE READ trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 *************************** 100. row *************************** trx_id: 28947429300 trx_state: RUNNING trx_started: 2021-03-07 14:41:09 trx_requested_lock_id: NULL trx_wait_started: NULL trx_weight: 2 trx_mysql_thread_id: 365002217 trx_query: UPDATE `part_cpa_calc` SET ........ trx_operation_state: updating or deleting trx_tables_in_use: 1 trx_tables_locked: 1 trx_lock_structs: 2 trx_lock_memory_bytes: 1128 trx_rows_locked: 1 trx_rows_modified: 0 trx_concurrency_tickets: 0 trx_isolation_level: READ COMMITTED trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 *************************** 101. row *************************** trx_id: 28947429347 trx_state: RUNNING trx_started: 2021-03-07 14:41:20 trx_requested_lock_id: NULL trx_wait_started: NULL trx_weight: 501 trx_mysql_thread_id: 364683297 trx_query: NULL trx_operation_state: NULL trx_tables_in_use: 0 trx_tables_locked: 1 trx_lock_structs: 1 trx_lock_memory_bytes: 1128 trx_rows_locked: 0 trx_rows_modified: 500 trx_concurrency_tickets: 0 trx_isolation_level: READ COMMITTED trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 *************************** 102. row *************************** trx_id: 28947429348 trx_state: RUNNING trx_started: 2021-03-07 14:41:21 trx_requested_lock_id: NULL trx_wait_started: NULL trx_weight: 3 trx_mysql_thread_id: 364683203 trx_query: DELETE FROM `mailer_messages` WHERE ........ trx_operation_state: updating or deleting trx_tables_in_use: 1 trx_tables_locked: 2 trx_lock_structs: 3 trx_lock_memory_bytes: 1128 trx_rows_locked: 1 trx_rows_modified: 0 trx_concurrency_tickets: 0 trx_isolation_level: READ COMMITTED trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 ============INNODB_LOCKS *************************** 1. row *************************** lock_id: 28947429658:7209:29506:67 lock_trx_id: 28947429658 lock_mode: X lock_type: RECORD lock_table: `sama`.`cl_lo_se` lock_index: PRIMARY lock_space: 7209 lock_page: 29506 lock_rec: 67 lock_data: 4369595 *************************** 2. row *************************** lock_id: 28947429657:7209:29506:67 lock_trx_id: 28947429657 lock_mode: X lock_type: RECORD lock_table: `sama`.`cl_lo_se` lock_index: PRIMARY lock_space: 7209 lock_page: 29506 lock_rec: 67 lock_data: 4369595 *************************** 3. row *************************** lock_id: 28947429637:7209:29506:67 lock_trx_id: 28947429637 lock_mode: X lock_type: RECORD lock_table: `sama`.`cl_lo_se` lock_index: PRIMARY lock_space: 7209 lock_page: 29506 lock_rec: 67 lock_data: 4369595 *************************** 4. row *************************** lock_id: 28947429612:7209:29506:67 lock_trx_id: 28947429612 lock_mode: X lock_type: RECORD lock_table: `sama`.`cl_lo_se` lock_index: PRIMARY lock_space: 7209 lock_page: 29506 lock_rec: 67 lock_data: 4369595 *************************** 5. row *************************** lock_id: 28947429520:7209:29506:67 lock_trx_id: 28947429520 lock_mode: X lock_type: RECORD lock_table: `sama`.`cl_lo_se` lock_index: PRIMARY lock_space: 7209 lock_page: 29506 lock_rec: 67 lock_data: 4369595 *************************** 6. row *************************** lock_id: 28947429652:7265:7946:64 lock_trx_id: 28947429652 lock_mode: X lock_type: RECORD lock_table: `rtm`.`clients` lock_index: PRIMARY lock_space: 7265 lock_page: 7946 lock_rec: 64 lock_data: 5857635 *************************** 7. row *************************** lock_id: 28947429517:7265:7946:64 lock_trx_id: 28947429517 lock_mode: X lock_type: RECORD lock_table: `rtm`.`clients` lock_index: PRIMARY lock_space: 7265 lock_page: 7946 lock_rec: 64 lock_data: 5857635 *************************** 8. row *************************** lock_id: 28947429653:7209:41410:69 lock_trx_id: 28947429653 lock_mode: X lock_type: RECORD lock_table: `sama`.`cl_lo_se` lock_index: PRIMARY lock_space: 7209 lock_page: 41410 lock_rec: 69 lock_data: 4543789 *************************** 9. row *************************** lock_id: 28947429596:7209:41410:69 lock_trx_id: 28947429596 lock_mode: X lock_type: RECORD lock_table: `sama`.`cl_lo_se` lock_index: PRIMARY lock_space: 7209 lock_page: 41410 lock_rec: 69 lock_data: 4543789 *************************** 10. row *************************** lock_id: 28947429646:7209:40088:382 lock_trx_id: 28947429646 lock_mode: X lock_type: RECORD lock_table: `sama`.`cl_lo_se` lock_index: ix_cl_lo_se_client_id lock_space: 7209 lock_page: 40088 lock_rec: 382 lock_data: 524797, 4543789 *************************** 11. row *************************** lock_id: 28947429596:7209:40088:382 lock_trx_id: 28947429596 lock_mode: X lock_type: RECORD lock_table: `sama`.`cl_lo_se` lock_index: ix_cl_lo_se_client_id lock_space: 7209 lock_page: 40088 lock_rec: 382 lock_data: 524797, 4543789 *************************** 12. row *************************** lock_id: 28947429643:5911:39601:3 lock_trx_id: 28947429643 lock_mode: X lock_type: RECORD lock_table: `sama`.`applications` lock_index: PRIMARY lock_space: 5911 lock_page: 39601 lock_rec: 3 lock_data: 2485861 *************************** 13. row *************************** lock_id: 28947429485:5911:39601:3 lock_trx_id: 28947429485 lock_mode: X lock_type: RECORD lock_table: `sama`.`applications` lock_index: PRIMARY lock_space: 5911 lock_page: 39601 lock_rec: 3 lock_data: 2485861 *************************** 14. row *************************** lock_id: 28947429642:7209:6894:542 lock_trx_id: 28947429642 lock_mode: X lock_type: RECORD lock_table: `sama`.`cl_lo_se` lock_index: ix_cl_lo_se_client_id lock_space: 7209 lock_page: 6894 lock_rec: 542 lock_data: 3820249, 4592335 *************************** 15. row *************************** lock_id: 28947429593:7209:6894:542 lock_trx_id: 28947429593 lock_mode: X lock_type: RECORD lock_table: `sama`.`cl_lo_se` lock_index: ix_cl_lo_se_client_id lock_space: 7209 lock_page: 6894 lock_rec: 542 lock_data: 3820249, 4592335 *************************** 16. row *************************** lock_id: 28947429639:7042:22182:54 lock_trx_id: 28947429639 lock_mode: X lock_type: RECORD lock_table: `sama`.`clients` lock_index: PRIMARY lock_space: 7042 lock_page: 22182 lock_rec: 54 lock_data: 2730565 *************************** 17. row *************************** lock_id: 28947429498:7042:22182:54 lock_trx_id: 28947429498 lock_mode: X lock_type: RECORD lock_table: `sama`.`clients` lock_index: PRIMARY lock_space: 7042 lock_page: 22182 lock_rec: 54 lock_data: 2730565 *************************** 18. row *************************** lock_id: 28947429636:7209:21433:909 lock_trx_id: 28947429636 lock_mode: X lock_type: RECORD lock_table: `sama`.`cl_lo_se` lock_index: ix_cl_lo_se_client_id lock_space: 7209 lock_page: 21433 lock_rec: 909 lock_data: 3780249, 4580011 *************************** 19. row *************************** lock_id: 28947429480:7209:21433:909 lock_trx_id: 28947429480 lock_mode: X lock_type: RECORD lock_table: `sama`.`cl_lo_se` lock_index: ix_cl_lo_se_client_id lock_space: 7209 lock_page: 21433 lock_rec: 909 lock_data: 3780249, 4580011 *************************** 20. row *************************** lock_id: 28947429622:7209:43989:72 lock_trx_id: 28947429622 lock_mode: X lock_type: RECORD lock_table: `sama`.`cl_lo_se` lock_index: PRIMARY lock_space: 7209 lock_page: 43989 lock_rec: 72 lock_data: 4146103 *************************** 21. row *************************** lock_id: 28947429613:7209:43989:72 lock_trx_id: 28947429613 lock_mode: X lock_type: RECORD lock_table: `sama`.`cl_lo_se` lock_index: PRIMARY lock_space: 7209 lock_page: 43989 lock_rec: 72 lock_data: 4146103 *************************** 22. row *************************** lock_id: 28947429620:7209:35911:257 lock_trx_id: 28947429620 lock_mode: X lock_type: RECORD lock_table: `sama`.`cl_lo_se` lock_index: ix_cl_lo_se_client_id lock_space: 7209 lock_page: 35911 lock_rec: 257 lock_data: 2418625, 4586599 *************************** 23. row *************************** lock_id: 28947429496:7209:35911:257 lock_trx_id: 28947429496 lock_mode: X lock_type: RECORD lock_table: `sama`.`cl_lo_se` lock_index: ix_cl_lo_se_client_id lock_space: 7209 lock_page: 35911 lock_rec: 257 lock_data: 2418625, 4586599 *************************** 24. row *************************** lock_id: 28947429597:7311:110:130 lock_trx_id: 28947429597 lock_mode: X lock_type: RECORD lock_table: `sama`.`pa_d_add` lock_index: PRIMARY lock_space: 7311 lock_page: 110 lock_rec: 130 lock_data: 23265 *************************** 25. row *************************** lock_id: 28947429588:7311:110:130 lock_trx_id: 28947429588 lock_mode: X lock_type: RECORD lock_table: `sama`.`pa_d_add` lock_index: PRIMARY lock_space: 7311 lock_page: 110 lock_rec: 130 lock_data: 23265 *************************** 26. row *************************** lock_id: 28947429497:7311:110:130 lock_trx_id: 28947429497 lock_mode: X lock_type: RECORD lock_table: `sama`.`pa_d_add` lock_index: PRIMARY lock_space: 7311 lock_page: 110 lock_rec: 130 lock_data: 23265 *************************** 27. row *************************** lock_id: 28947429590:7265:8785:8 lock_trx_id: 28947429590 lock_mode: X lock_type: RECORD lock_table: `rtm`.`clients` lock_index: PRIMARY lock_space: 7265 lock_page: 8785 lock_rec: 8 lock_data: 6004755 *************************** 28. row *************************** lock_id: 28947429379:7265:8785:8 lock_trx_id: 28947429379 lock_mode: X lock_type: RECORD lock_table: `rtm`.`clients` lock_index: PRIMARY lock_space: 7265 lock_page: 8785 lock_rec: 8 lock_data: 6004755 *************************** 29. row *************************** lock_id: 28947429571:7042:43615:29 lock_trx_id: 28947429571 lock_mode: X lock_type: RECORD lock_table: `sama`.`clients` lock_index: PRIMARY lock_space: 7042 lock_page: 43615 lock_rec: 29 lock_data: 3477919 *************************** 30. row *************************** lock_id: 28947429569:7042:43615:29 lock_trx_id: 28947429569 lock_mode: X lock_type: RECORD lock_table: `sama`.`clients` lock_index: PRIMARY lock_space: 7042 lock_page: 43615 lock_rec: 29 lock_data: 3477919