2018-03-28 5:25:50 2440 [Warning] InnoDB: A long semaphore wait: --Thread 1564 has waited at ibuf0ibuf.cc line 4394 for 241.00 seconds the semaphore: Mutex at 01F93E20, Mutex IBUF created ibuf0ibuf.cc:516, lock var 2 2018-03-28 5:25:50 2440 [Warning] InnoDB: A long semaphore wait: --Thread 908 has waited at ibuf0ibuf.cc line 4578 for 241.00 seconds the semaphore: S-lock on RW-latch at 0431E114 created in file buf0buf.cc line 1471 a writer (thread id 1460) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file ibuf0ibuf.cc line 4578 Last time write locked in file mtr0mtr.ic line 147 2018-03-28 5:25:50 2440 [Warning] InnoDB: A long semaphore wait: --Thread 4860 has waited at buf0buf.cc line 4136 for 241.00 seconds the semaphore: S-lock on RW-latch at 04280A54 created in file buf0buf.cc line 1471 a writer (thread id 0) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file buf0buf.cc line 4136 Last time write locked in file buf0buf.cc line 5363 2018-03-28 5:25:50 2440 [Warning] InnoDB: A long semaphore wait: --Thread 1480 has waited at ibuf0ibuf.cc line 4394 for 241.00 seconds the semaphore: Mutex at 01F93E20, Mutex IBUF created ibuf0ibuf.cc:516, lock var 2 2018-03-28 5:25:50 2440 [Warning] InnoDB: A long semaphore wait: --Thread 1460 has waited at buf0buf.cc line 4136 for 241.00 seconds the semaphore: S-lock on RW-latch at 0CB3065C created in file buf0buf.cc line 1471 a writer (thread id 0) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file row0sel.cc line 3568 Last time write locked in file buf0buf.cc line 5363 2018-03-28 5:25:50 2440 [Note] InnoDB: A semaphore wait: --Thread 2448 has waited at ibuf0ibuf.cc line 2532 for 240.00 seconds the semaphore: S-lock on RW-latch at 0431E114 created in file buf0buf.cc line 1471 a writer (thread id 1460) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file ibuf0ibuf.cc line 4578 Last time write locked in file mtr0mtr.ic line 147 2018-03-28 5:25:50 2440 [Note] InnoDB: A semaphore wait: --Thread 1688 has waited at buf0flu.cc line 1246 for 232.00 seconds the semaphore: SX-lock on RW-latch at 0431E114 created in file buf0buf.cc line 1471 a writer (thread id 1460) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file ibuf0ibuf.cc line 4578 Last time write locked in file mtr0mtr.ic line 147 2018-03-28 5:25:50 2440 [Note] InnoDB: A semaphore wait: --Thread 1564 has waited at ibuf0ibuf.cc line 4394 for 241.00 seconds the semaphore: Mutex at 01F93E20, Mutex IBUF created ibuf0ibuf.cc:516, lock var 2 2018-03-28 5:25:50 2440 [Note] InnoDB: A semaphore wait: --Thread 908 has waited at ibuf0ibuf.cc line 4578 for 241.00 seconds the semaphore: S-lock on RW-latch at 0431E114 created in file buf0buf.cc line 1471 a writer (thread id 1460) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file ibuf0ibuf.cc line 4578 Last time write locked in file mtr0mtr.ic line 147 2018-03-28 5:25:50 2440 [Note] InnoDB: A semaphore wait: --Thread 4860 has waited at buf0buf.cc line 4136 for 241.00 seconds the semaphore: S-lock on RW-latch at 04280A54 created in file buf0buf.cc line 1471 a writer (thread id 0) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file buf0buf.cc line 4136 Last time write locked in file buf0buf.cc line 5363 2018-03-28 5:25:50 2440 [Note] InnoDB: A semaphore wait: --Thread 1480 has waited at ibuf0ibuf.cc line 4394 for 241.00 seconds the semaphore: Mutex at 01F93E20, Mutex IBUF created ibuf0ibuf.cc:516, lock var 2 2018-03-28 5:25:50 2440 [Note] InnoDB: A semaphore wait: --Thread 1460 has waited at buf0buf.cc line 4136 for 241.00 seconds the semaphore: S-lock on RW-latch at 0CB3065C created in file buf0buf.cc line 1471 a writer (thread id 0) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file row0sel.cc line 3568 Last time write locked in file buf0buf.cc line 5363 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending reads 0, writes 0 ===================================== 2018-03-28 05:25:59 0x98c INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 64 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 37468 srv_active, 0 srv_shutdown, 56188 srv_idle srv_master_thread log flush and writes: 93655 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 626368 --Thread 2448 has waited at ibuf0ibuf.cc line 2532 for 249.00 seconds the semaphore: S-lock on RW-latch at 0431E114 created in file buf0buf.cc line 1471 a writer (thread id 1460) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file ibuf0ibuf.cc line 4578 Last time write locked in file mtr0mtr.ic line 147 --Thread 1688 has waited at buf0flu.cc line 1246 for 241.00 seconds the semaphore: SX-lock on RW-latch at 0431E114 created in file buf0buf.cc line 1471 a writer (thread id 1460) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file ibuf0ibuf.cc line 4578 Last time write locked in file mtr0mtr.ic line 147 --Thread 1564 has waited at ibuf0ibuf.cc line 4394 for 250.00 seconds the semaphore: Mutex at 01F93E20, Mutex IBUF created ibuf0ibuf.cc:516, lock var 2 --Thread 908 has waited at ibuf0ibuf.cc line 4578 for 250.00 seconds the semaphore: S-lock on RW-latch at 0431E114 created in file buf0buf.cc line 1471 a writer (thread id 1460) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file ibuf0ibuf.cc line 4578 Last time write locked in file mtr0mtr.ic line 147 --Thread 4860 has waited at buf0buf.cc line 4136 for 250.00 seconds the semaphore: S-lock on RW-latch at 04280A54 created in file buf0buf.cc line 1471 a writer (thread id 0) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file buf0buf.cc line 4136 Last time write locked in file buf0buf.cc line 5363 --Thread 1480 has waited at ibuf0ibuf.cc line 4394 for 250.00 seconds the semaphore: Mutex at 01F93E20, Mutex IBUF created ibuf0ibuf.cc:516, lock var 2 --Thread 1460 has waited at buf0buf.cc line 4136 for 250.00 seconds the semaphore: S-lock on RW-latch at 0CB3065C created in file buf0buf.cc line 1471 a writer (thread id 0) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file row0sel.cc line 3568 Last time write locked in file buf0buf.cc line 5363 OS WAIT ARRAY INFO: signal count 520921 RW-shared spins 0, rounds 798992, OS waits 390861 RW-excl spins 0, rounds 1141727, OS waits 14298 RW-sx spins 2663, rounds 33568, OS waits 503 Spin rounds per wait: 798992.00 RW-shared, 1141727.00 RW-excl, 12.61 RW-sx ------------ TRANSACTIONS ------------ Trx id counter 137843677 Purge done for trx's n:o < 137843524 undo n:o < 0 state: running but idle History list length 15 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 281475041773368, not started 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041772808, not started 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041772248, not started 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041771688, not started 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041771128, not started 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041770568, not started 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041769448, not started 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041768888, not started 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041768328, not started 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041759368, not started 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041755448, not started 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041753768, not started 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041753208, not started 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041739208, not started 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041738088, not started 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041725208, not started 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041724088, not started 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041767768, not started 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041767208, not started 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041766648, not started 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041766088, not started 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041765528, not started 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041764968, not started 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041764408, not started 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041763848, not started 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041763288, not started 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041762728, not started 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041757128, not started 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041756568, not started 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041752088, not started 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041756008, not started 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041762168, not started 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041761608, not started 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041751528, not started 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041743128, not started 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041761048, not started 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041760488, not started 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041759928, not started 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041742568, not started 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041742008, not started 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041758808, not started 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041758248, not started 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041757688, not started 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041754888, not started 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041754328, not started 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041752648, not started 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041750968, not started 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041750408, not started 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041749848, not started 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041749288, not started 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041748728, not started 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041748168, not started 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041747608, not started 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041747048, not started 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041746488, not started 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041745928, not started 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041745368, not started 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041744808, not started 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041744248, not started 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041743688, not started 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041737528, not started 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041736968, not started 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041726328, not started 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041725768, not started 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041736408, not started 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041735848, not started 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041735288, not started 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041734728, not started 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041734168, not started 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041733608, not started 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041733048, not started 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041732488, not started 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041731928, not started 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041731368, not started 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041730808, not started 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041724648, not started 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041741448, not started 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041740888, not started 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041740328, not started 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041739768, not started 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041738648, not started 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041730248, not started 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041729688, not started 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041729128, not started 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041728568, not started 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041728008, not started 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041727448, not started 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041726888, not started 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041723528, not started 0 lock struct(s), heap size 1080, 0 row lock(s) -------- FILE I/O -------- I/O thread 0 state: complete io for buf page (insert buffer thread) I/O thread 1 state: complete io for buf page (log thread) I/O thread 2 state: complete io for buf page (read thread) I/O thread 3 state: complete io for buf page (read thread) I/O thread 4 state: native aio handle (read thread) I/O thread 5 state: native aio handle (read thread) I/O thread 6 state: native aio handle (write thread) I/O thread 7 state: native aio handle (write thread) I/O thread 8 state: native aio handle (write thread) I/O thread 9 state: native aio handle (write thread) Pending normal aio reads: [14, 14, 71, 2] , 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 1743821 OS file reads, 1225365 OS file writes, 667439 OS fsyncs 0.08 reads/s, 16384 avg bytes/read, 0.52 writes/s, 0.52 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- InnoDB: ###### Diagnostic info printed to the standard error stream 2018-03-28 5:26:21 2440 [Warning] InnoDB: A long semaphore wait: --Thread 2448 has waited at ibuf0ibuf.cc line 2532 for 271.00 seconds the semaphore: S-lock on RW-latch at 0431E114 created in file buf0buf.cc line 1471 a writer (thread id 1460) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file ibuf0ibuf.cc line 4578 Last time write locked in file mtr0mtr.ic line 147 2018-03-28 5:26:21 2440 [Warning] InnoDB: A long semaphore wait: --Thread 1688 has waited at buf0flu.cc line 1246 for 263.00 seconds the semaphore: SX-lock on RW-latch at 0431E114 created in file buf0buf.cc line 1471 a writer (thread id 1460) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file ibuf0ibuf.cc line 4578 Last time write locked in file mtr0mtr.ic line 147 2018-03-28 5:26:21 2440 [Warning] InnoDB: A long semaphore wait: --Thread 1564 has waited at ibuf0ibuf.cc line 4394 for 272.00 seconds the semaphore: Mutex at 01F93E20, Mutex IBUF created ibuf0ibuf.cc:516, lock var 2 2018-03-28 5:26:21 2440 [Warning] InnoDB: A long semaphore wait: --Thread 908 has waited at ibuf0ibuf.cc line 4578 for 272.00 seconds the semaphore: S-lock on RW-latch at 0431E114 created in file buf0buf.cc line 1471 a writer (thread id 1460) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file ibuf0ibuf.cc line 4578 Last time write locked in file mtr0mtr.ic line 147 2018-03-28 5:26:21 2440 [Warning] InnoDB: A long semaphore wait: --Thread 4860 has waited at buf0buf.cc line 4136 for 272.00 seconds the semaphore: S-lock on RW-latch at 04280A54 created in file buf0buf.cc line 1471 a writer (thread id 0) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file buf0buf.cc line 4136 Last time write locked in file buf0buf.cc line 5363 2018-03-28 5:26:21 2440 [Warning] InnoDB: A long semaphore wait: --Thread 1480 has waited at ibuf0ibuf.cc line 4394 for 272.00 seconds the semaphore: Mutex at 01F93E20, Mutex IBUF created ibuf0ibuf.cc:516, lock var 2 2018-03-28 5:26:21 2440 [Warning] InnoDB: A long semaphore wait: --Thread 1460 has waited at buf0buf.cc line 4136 for 272.00 seconds the semaphore: S-lock on RW-latch at 0CB3065C created in file buf0buf.cc line 1471 a writer (thread id 0) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file row0sel.cc line 3568 Last time write locked in file buf0buf.cc line 5363 2018-03-28 5:26:21 2440 [Note] InnoDB: A semaphore wait: --Thread 2448 has waited at ibuf0ibuf.cc line 2532 for 271.00 seconds the semaphore: S-lock on RW-latch at 0431E114 created in file buf0buf.cc line 1471 a writer (thread id 1460) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file ibuf0ibuf.cc line 4578 Last time write locked in file mtr0mtr.ic line 147 2018-03-28 5:26:21 2440 [Note] InnoDB: A semaphore wait: --Thread 1688 has waited at buf0flu.cc line 1246 for 263.00 seconds the semaphore: SX-lock on RW-latch at 0431E114 created in file buf0buf.cc line 1471 a writer (thread id 1460) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file ibuf0ibuf.cc line 4578 Last time write locked in file mtr0mtr.ic line 147 2018-03-28 5:26:21 2440 [Note] InnoDB: A semaphore wait: --Thread 1564 has waited at ibuf0ibuf.cc line 4394 for 272.00 seconds the semaphore: Mutex at 01F93E20, Mutex IBUF created ibuf0ibuf.cc:516, lock var 2 2018-03-28 5:26:21 2440 [Note] InnoDB: A semaphore wait: --Thread 908 has waited at ibuf0ibuf.cc line 4578 for 272.00 seconds the semaphore: S-lock on RW-latch at 0431E114 created in file buf0buf.cc line 1471 a writer (thread id 1460) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file ibuf0ibuf.cc line 4578 Last time write locked in file mtr0mtr.ic line 147 2018-03-28 5:26:21 2440 [Note] InnoDB: A semaphore wait: --Thread 4860 has waited at buf0buf.cc line 4136 for 272.00 seconds the semaphore: S-lock on RW-latch at 04280A54 created in file buf0buf.cc line 1471 a writer (thread id 0) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file buf0buf.cc line 4136 Last time write locked in file buf0buf.cc line 5363 2018-03-28 5:26:21 2440 [Note] InnoDB: A semaphore wait: --Thread 1480 has waited at ibuf0ibuf.cc line 4394 for 272.00 seconds the semaphore: Mutex at 01F93E20, Mutex IBUF created ibuf0ibuf.cc:516, lock var 2 2018-03-28 5:26:21 2440 [Note] InnoDB: A semaphore wait: --Thread 1460 has waited at buf0buf.cc line 4136 for 272.00 seconds the semaphore: S-lock on RW-latch at 0CB3065C created in file buf0buf.cc line 1471 a writer (thread id 0) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file row0sel.cc line 3568 Last time write locked in file buf0buf.cc line 5363 2018-03-28 5:26:21 2440 [Note] InnoDB: A semaphore wait: --Thread 2444 has waited at ibuf0ibuf.cc line 4921 for 22.00 seconds the semaphore: Mutex at 01F93E20, Mutex IBUF created ibuf0ibuf.cc:516, lock var 2 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending reads 0, writes 0 InnoDB: ###### Diagnostic info printed to the standard error stream 2018-03-28 5:26:52 2440 [Warning] InnoDB: A long semaphore wait: --Thread 2448 has waited at ibuf0ibuf.cc line 2532 for 302.00 seconds the semaphore: S-lock on RW-latch at 0431E114 created in file buf0buf.cc line 1471 a writer (thread id 1460) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file ibuf0ibuf.cc line 4578 Last time write locked in file mtr0mtr.ic line 147 2018-03-28 5:26:52 2440 [Warning] InnoDB: A long semaphore wait: --Thread 1688 has waited at buf0flu.cc line 1246 for 294.00 seconds the semaphore: SX-lock on RW-latch at 0431E114 created in file buf0buf.cc line 1471 a writer (thread id 1460) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file ibuf0ibuf.cc line 4578 Last time write locked in file mtr0mtr.ic line 147 2018-03-28 5:26:52 2440 [Warning] InnoDB: A long semaphore wait: --Thread 1564 has waited at ibuf0ibuf.cc line 4394 for 303.00 seconds the semaphore: Mutex at 01F93E20, Mutex IBUF created ibuf0ibuf.cc:516, lock var 2 2018-03-28 5:26:52 2440 [Warning] InnoDB: A long semaphore wait: --Thread 908 has waited at ibuf0ibuf.cc line 4578 for 303.00 seconds the semaphore: S-lock on RW-latch at 0431E114 created in file buf0buf.cc line 1471 a writer (thread id 1460) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file ibuf0ibuf.cc line 4578 Last time write locked in file mtr0mtr.ic line 147 2018-03-28 5:26:52 2440 [Warning] InnoDB: A long semaphore wait: --Thread 4860 has waited at buf0buf.cc line 4136 for 303.00 seconds the semaphore: S-lock on RW-latch at 04280A54 created in file buf0buf.cc line 1471 a writer (thread id 0) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file buf0buf.cc line 4136 Last time write locked in file buf0buf.cc line 5363 2018-03-28 5:26:52 2440 [Warning] InnoDB: A long semaphore wait: --Thread 1480 has waited at ibuf0ibuf.cc line 4394 for 303.00 seconds the semaphore: Mutex at 01F93E20, Mutex IBUF created ibuf0ibuf.cc:516, lock var 2 2018-03-28 5:26:52 2440 [Warning] InnoDB: A long semaphore wait: --Thread 1460 has waited at buf0buf.cc line 4136 for 303.00 seconds the semaphore: S-lock on RW-latch at 0CB3065C created in file buf0buf.cc line 1471 a writer (thread id 0) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file row0sel.cc line 3568 Last time write locked in file buf0buf.cc line 5363 2018-03-28 5:26:52 2440 [Note] InnoDB: A semaphore wait: --Thread 2448 has waited at ibuf0ibuf.cc line 2532 for 302.00 seconds the semaphore: S-lock on RW-latch at 0431E114 created in file buf0buf.cc line 1471 a writer (thread id 1460) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file ibuf0ibuf.cc line 4578 Last time write locked in file mtr0mtr.ic line 147 2018-03-28 5:26:52 2440 [Note] InnoDB: A semaphore wait: --Thread 1688 has waited at buf0flu.cc line 1246 for 294.00 seconds the semaphore: SX-lock on RW-latch at 0431E114 created in file buf0buf.cc line 1471 a writer (thread id 1460) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file ibuf0ibuf.cc line 4578 Last time write locked in file mtr0mtr.ic line 147 2018-03-28 5:26:52 2440 [Note] InnoDB: A semaphore wait: --Thread 1564 has waited at ibuf0ibuf.cc line 4394 for 303.00 seconds the semaphore: Mutex at 01F93E20, Mutex IBUF created ibuf0ibuf.cc:516, lock var 2 2018-03-28 5:26:52 2440 [Note] InnoDB: A semaphore wait: --Thread 908 has waited at ibuf0ibuf.cc line 4578 for 303.00 seconds the semaphore: S-lock on RW-latch at 0431E114 created in file buf0buf.cc line 1471 a writer (thread id 1460) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file ibuf0ibuf.cc line 4578 Last time write locked in file mtr0mtr.ic line 147 2018-03-28 5:26:52 2440 [Note] InnoDB: A semaphore wait: --Thread 4860 has waited at buf0buf.cc line 4136 for 303.00 seconds the semaphore: S-lock on RW-latch at 04280A54 created in file buf0buf.cc line 1471 a writer (thread id 0) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file buf0buf.cc line 4136 Last time write locked in file buf0buf.cc line 5363 2018-03-28 5:26:52 2440 [Note] InnoDB: A semaphore wait: --Thread 1480 has waited at ibuf0ibuf.cc line 4394 for 303.00 seconds the semaphore: Mutex at 01F93E20, Mutex IBUF created ibuf0ibuf.cc:516, lock var 2 2018-03-28 5:26:52 2440 [Note] InnoDB: A semaphore wait: --Thread 1460 has waited at buf0buf.cc line 4136 for 303.00 seconds the semaphore: S-lock on RW-latch at 0CB3065C created in file buf0buf.cc line 1471 a writer (thread id 0) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file row0sel.cc line 3568 Last time write locked in file buf0buf.cc line 5363 2018-03-28 5:26:52 2440 [Note] InnoDB: A semaphore wait: --Thread 2444 has waited at ibuf0ibuf.cc line 4921 for 53.00 seconds the semaphore: Mutex at 01F93E20, Mutex IBUF created ibuf0ibuf.cc:516, lock var 2 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending reads 0, writes 0 InnoDB: ###### Diagnostic info printed to the standard error stream 2018-03-28 6:16:46 7004 [Warning] Aborted connection 2722 to db: 'datafactorydb' user: 'root' host: '127.0.0.1' (Got an error reading communication packets) 2018-03-28 6:17:52 2504 [Note] D:\mariadb\bin\mysqld.exe (unknown): Normal shutdown 2018-03-28 6:18:10 2504 [Note] Event Scheduler: Purging the queue. 0 events 2018-03-28 6:18:10 2456 [Note] InnoDB: FTS optimize thread exiting. 2018-03-28 6:18:41 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2724 user: 'liverjis' 2018-03-28 6:18:41 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2723 user: 'liverjis' 2018-03-28 6:18:41 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2721 user: 'liverjis' 2018-03-28 6:18:41 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2720 user: 'liverjis' 2018-03-28 6:18:41 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2719 user: 'liverjis' 2018-03-28 6:18:41 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2718 user: 'liverjis' 2018-03-28 6:18:41 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2717 user: 'liverjis' 2018-03-28 6:18:41 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2716 user: 'liverjis' 2018-03-28 6:18:41 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2715 user: 'liverjis' 2018-03-28 6:18:41 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2714 user: 'liverjis' 2018-03-28 6:18:41 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2713 user: 'liverjis' 2018-03-28 6:18:41 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2712 user: 'liverjis' 2018-03-28 6:18:41 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2711 user: 'liverjis' 2018-03-28 6:18:41 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2710 user: 'liverjis' 2018-03-28 6:18:41 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2708 user: 'liverjis' 2018-03-28 6:18:41 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2706 user: 'liverjis' 2018-03-28 6:18:41 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2705 user: 'liverjis' 2018-03-28 6:18:41 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2704 user: 'liverjis' 2018-03-28 6:18:41 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2702 user: 'liverjis' 2018-03-28 6:18:41 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2701 user: 'liverjis' 2018-03-28 6:18:41 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2700 user: 'liverjis' 2018-03-28 6:18:41 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2698 user: 'liverjis' 2018-03-28 6:18:41 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2697 user: 'liverjis' 2018-03-28 6:18:41 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2696 user: 'liverjis' 2018-03-28 6:18:41 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2695 user: 'liverjis' 2018-03-28 6:18:41 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2693 user: 'liverjis' 2018-03-28 6:18:41 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2690 user: 'liverjis' 2018-03-28 6:18:41 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2689 user: 'liverjis' 2018-03-28 6:18:41 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2687 user: 'liverjis' 2018-03-28 6:18:41 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2686 user: 'liverjis' 2018-03-28 6:18:41 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2685 user: 'liverjis' 2018-03-28 6:18:41 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2683 user: 'liverjis' 2018-03-28 6:18:41 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2682 user: 'liverjis' 2018-03-28 6:18:41 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2681 user: 'liverjis' 2018-03-28 6:18:41 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2680 user: 'liverjis' 2018-03-28 6:18:41 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2679 user: 'liverjis' 2018-03-28 6:18:41 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2676 user: 'liverjis' 2018-03-28 6:18:41 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2675 user: 'liverjis' 2018-03-28 6:18:41 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2674 user: 'liverjis' 2018-03-28 6:18:41 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2673 user: 'liverjis' 2018-03-28 6:18:41 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2669 user: 'liverjis' 2018-03-28 6:18:41 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2668 user: 'liverjis' 2018-03-28 6:18:41 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2667 user: 'liverjis' 2018-03-28 6:18:41 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2664 user: 'liverjis' 2018-03-28 6:18:41 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2663 user: 'liverjis' 2018-03-28 6:18:41 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2662 user: 'liverjis' 2018-03-28 6:18:41 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2661 user: 'liverjis' 2018-03-28 6:18:41 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2660 user: 'liverjis' 2018-03-28 6:18:41 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2659 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2658 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2655 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2654 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2653 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2652 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2651 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2650 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2649 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2648 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2646 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2645 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2644 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2643 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2642 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2641 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2640 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2639 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2638 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2637 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2636 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2634 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2633 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2632 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2630 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2629 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2628 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2627 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2625 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2624 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2623 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2622 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2621 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2620 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2619 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2618 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2617 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2616 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2615 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2614 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2613 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2612 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2611 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2610 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2609 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2608 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2607 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2606 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2605 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2604 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2603 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2602 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2601 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2600 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2599 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2598 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2596 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2595 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2594 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2593 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2592 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2591 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2590 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2589 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2588 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2587 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2586 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2585 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2584 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2583 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2582 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2581 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2580 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2579 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2578 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2577 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2576 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2575 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2574 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2573 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2572 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2571 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2570 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2568 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2566 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2564 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2563 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2562 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2561 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2560 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2559 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2558 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2557 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2556 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2555 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2554 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2553 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2552 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2551 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2550 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2549 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2548 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2547 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2546 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2543 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2542 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2541 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2540 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2538 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2537 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2536 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2535 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2534 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2533 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2532 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2531 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2530 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2529 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2528 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2526 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2525 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2524 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2523 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2522 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2521 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2520 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2519 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2518 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2517 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2516 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2515 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2514 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2513 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2512 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2511 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2510 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2509 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2508 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2507 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2506 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2505 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2504 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2503 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2502 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2501 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2500 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2499 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2498 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2497 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2496 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2495 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2494 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2492 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2491 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2490 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2489 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2488 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2487 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2486 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2485 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2484 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2483 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2482 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2481 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2480 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2479 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2478 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2477 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2476 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2475 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2474 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2473 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2471 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2470 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2469 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2468 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2467 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2466 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2465 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2464 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2463 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2462 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2461 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2460 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2459 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2458 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2457 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2456 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2455 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2454 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2453 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2452 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2451 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2450 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2449 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2448 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2447 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2446 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2445 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2444 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2443 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2442 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2441 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2440 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2439 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2438 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2437 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2436 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2435 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2434 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2433 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2432 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2431 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2430 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2429 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2428 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2427 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2426 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2425 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2424 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2423 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2422 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2421 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2420 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2419 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2418 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2417 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2416 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2415 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2414 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2413 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2412 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2411 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2410 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2409 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2408 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2407 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2406 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2405 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2404 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2403 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2400 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2399 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2398 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2397 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2396 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2395 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2394 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2393 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2392 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2391 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2390 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2389 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2388 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2387 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2386 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2385 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2384 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2383 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2382 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2381 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2380 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2379 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2378 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2377 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2376 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2375 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2374 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2373 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2372 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2371 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2370 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2369 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2368 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2367 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2366 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2365 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2364 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2363 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2362 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2361 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2360 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2359 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2358 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2357 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2356 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2355 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2354 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2353 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2352 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2351 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2350 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2349 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2348 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2347 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2346 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2345 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2344 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2343 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2342 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2341 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2340 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2339 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2337 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2336 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2335 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2334 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2333 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2332 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2331 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2330 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2329 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2328 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2327 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2326 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2325 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2324 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2323 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2322 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2321 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2320 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2319 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2318 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2317 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2314 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2313 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2312 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2311 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2310 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2309 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2308 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2307 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2306 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2305 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2304 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2303 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2302 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2301 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2300 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2299 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2298 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2297 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2296 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2295 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2294 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2293 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2292 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2291 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2290 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2289 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2288 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2287 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2286 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2285 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2284 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2283 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2282 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2281 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2280 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2279 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2278 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2277 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2276 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2275 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2274 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2273 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2272 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2271 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2270 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2269 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2268 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2267 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2266 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2265 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2264 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2263 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2262 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2261 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2259 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2258 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2257 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2256 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2255 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2254 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2253 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2252 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2251 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2250 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2249 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2248 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2247 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2246 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2245 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2244 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2243 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2242 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2241 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2240 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2239 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2238 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2237 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2236 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2235 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2234 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2233 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2232 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2231 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2230 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2229 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2228 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2227 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2226 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2225 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2224 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2223 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2222 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2221 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2220 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2219 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2218 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2217 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2216 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2215 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2214 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2213 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2212 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2211 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2210 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2209 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2208 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2207 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2206 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2205 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2204 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2203 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2202 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2201 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2200 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2199 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2198 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2197 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2196 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2195 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2194 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2193 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2192 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2191 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2190 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2189 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2188 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2187 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2186 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2185 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2184 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2183 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2182 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2181 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2180 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2179 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2178 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2177 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2176 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2175 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2174 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2173 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2172 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2171 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2168 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2167 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2166 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2165 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2164 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2163 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2162 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2161 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2160 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2159 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2158 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2157 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2156 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2155 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2154 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2153 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2152 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2151 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2150 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2149 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2148 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2147 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2146 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2145 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2144 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2143 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2142 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2141 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2140 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2138 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2137 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2136 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2135 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2134 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2133 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2132 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2131 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2130 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2129 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2128 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2127 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2126 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2123 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2120 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2119 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2112 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2104 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2090 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2082 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2081 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2079 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2078 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2072 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2071 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2069 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2068 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2054 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2053 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2049 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2045 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2044 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2038 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2037 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2034 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2026 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2025 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2023 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2022 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2018 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2006 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2005 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 2001 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 1996 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 1993 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 1992 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 1991 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 1989 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 1966 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 1961 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 1945 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 1669 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 1668 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 1667 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 1666 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 1665 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 1664 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 1663 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 1662 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 1661 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 1660 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 1659 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 1658 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 1657 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 1656 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 1640 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 1639 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 1638 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 1637 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 1636 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 1635 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 1634 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 1633 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 1632 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 1631 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 1630 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 1629 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 1628 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 1627 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 1625 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 1624 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 1619 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 1618 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 1617 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 1616 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 1615 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 1614 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 1613 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 1612 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 1610 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 1609 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 1608 user: 'liverjis' 2018-03-28 6:18:42 2504 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 1607 user: 'liverjis' 2018-03-28 6:26:14 8004 [Warning] option 'innodb-autoextend-increment': unsigned value 67108864 adjusted to 1000 2018-03-28 6:26:14 8004 [Warning] InnoDB: Using innodb_file_format is deprecated and the parameter may be removed in future releases. See http://dev.mysql.com/doc/refman/5.7/en/innodb-file-format.html 2018-03-28 6:26:14 8004 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2018-03-28 6:26:14 8004 [Note] InnoDB: Uses event mutexes 2018-03-28 6:26:14 8004 [Note] InnoDB: Compressed tables use zlib 1.2.3 2018-03-28 6:26:14 8004 [Note] InnoDB: Adjusting innodb_buffer_pool_instances from 8 to 1 since innodb_buffer_pool_size is less than 1024 MiB 2018-03-28 6:26:14 8004 [Note] InnoDB: Number of pools: 1 2018-03-28 6:26:14 8004 [Note] InnoDB: Using SSE2 crc32 instructions 2018-03-28 6:26:14 8004 [Note] InnoDB: Initializing buffer pool, total size = 256M, instances = 1, chunk size = 128M 2018-03-28 6:26:15 8004 [Note] InnoDB: Completed initialization of buffer pool 2018-03-28 6:26:15 8004 [Note] InnoDB: Highest supported file format is Barracuda. 2018-03-28 6:26:15 8004 [Note] InnoDB: Starting crash recovery from checkpoint LSN=63081030345 2018-03-28 6:26:20 8004 [Note] InnoDB: Transaction 137845522 was in the XA prepared state. 2018-03-28 6:26:20 8004 [Note] InnoDB: 8 transaction(s) which must be rolled back or cleaned up in total 7 row operations to undo 2018-03-28 6:26:20 8004 [Note] InnoDB: Trx id counter is 137846016 2018-03-28 6:26:20 8004 [Note] InnoDB: Starting final batch to recover 2124 pages from redo log. 2018-03-28 6:26:25 8004 [Note] InnoDB: Last binlog file 'd:\MariaDB\master\logbin\Master-bin.000298', position 172616734 2018-03-28 6:26:29 8004 [Note] InnoDB: 128 out of 128 rollback segments are active. 2018-03-28 6:26:29 7364 [Note] InnoDB: Starting in background the rollback of recovered transactions 2018-03-28 6:26:29 7364 [Note] InnoDB: Rolling back trx with id 137845450, 1 rows to undo 2018-03-28 6:26:29 8004 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2018-03-28 6:26:29 8004 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-03-28 6:26:29 8004 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2018-03-28 6:26:29 8004 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB. 2018-03-28 6:26:29 8004 [Note] InnoDB: 5.7.20 started; log sequence number 63081812719 2018-03-28 6:26:29 8148 [Note] InnoDB: Loading buffer pool(s) from D:\MariaDB\data\ib_buffer_pool 2018-03-28 6:26:29 8004 [Note] Plugin 'FEEDBACK' is disabled. 2018-03-28 6:26:29 7364 [Note] InnoDB: Rollback of trx with id 137845450 completed 2018-03-28 6:26:29 7364 [Note] InnoDB: Rolling back trx with id 137845380, 1 rows to undo 2018-03-28 6:26:29 8004 [Note] Recovering after a crash using d:/MariaDB/master/logbin/Master-bin 2018-03-28 6:26:29 7364 [Note] InnoDB: Rollback of trx with id 137845380 completed 2018-03-28 6:26:29 7364 [Note] InnoDB: Rolling back trx with id 137845163, 1 rows to undo 2018-03-28 6:26:29 7364 [Note] InnoDB: Rollback of trx with id 137845163 completed 2018-03-28 6:26:29 7364 [Note] InnoDB: Rolling back trx with id 137844898, 1 rows to undo 2018-03-28 6:26:29 7364 [Note] InnoDB: Rollback of trx with id 137844898 completed 2018-03-28 6:26:29 7364 [Note] InnoDB: Rolling back trx with id 137844820, 1 rows to undo 2018-03-28 6:26:29 7364 [Note] InnoDB: Rollback of trx with id 137844820 completed 2018-03-28 6:26:29 7364 [Note] InnoDB: Rolling back trx with id 137844716, 1 rows to undo 2018-03-28 6:26:29 7364 [Note] InnoDB: Rollback of trx with id 137844716 completed 2018-03-28 6:26:29 7364 [Note] InnoDB: Rolling back trx with id 137844614, 1 rows to undo 2018-03-28 6:26:29 7364 [Note] InnoDB: Rollback of trx with id 137844614 completed 2018-03-28 6:26:29 7364 [Note] InnoDB: Rollback of non-prepared transactions completed 2018-03-28 6:26:34 8148 [Note] InnoDB: Buffer pool(s) load completed at 180328 6:26:34 2018-03-28 6:26:46 8004 [Note] Starting crash recovery... 2018-03-28 6:26:46 8004 [Note] InnoDB: Starting recovery for XA transactions... 2018-03-28 6:26:46 8004 [Note] InnoDB: Transaction 137845522 in prepared state after recovery 2018-03-28 6:26:46 8004 [Note] InnoDB: Transaction contains changes to 1 rows 2018-03-28 6:26:46 8004 [Note] InnoDB: 1 transactions in prepared state after recovery 2018-03-28 6:26:46 8004 [Note] Found 1 prepared transaction(s) in InnoDB 2018-03-28 6:26:46 8004 [Note] Crash recovery finished. 2018-03-28 6:26:46 8004 [Note] Server socket created on IP: '::'. 2018-03-28 6:26:46 8004 [Warning] 'user' entry 'root@jpdpt3' ignored in --skip-name-resolve mode. 2018-03-28 6:26:46 8004 [Warning] 'proxies_priv' entry '@% root@jpdpt3' ignored in --skip-name-resolve mode. 2018-03-28 6:26:46 8004 [Note] Reading of all Master_info entries succeded 2018-03-28 6:26:46 8004 [Note] Added new Master_info '' to hash table 2018-03-28 6:26:46 8004 [Note] D:\mariadb\bin\mysqld.exe: ready for connections. Version: '10.2.11-MariaDB-log' socket: '' port: 3306 mariadb.org binary distribution 2018-03-28 6:26:48 3056 [Note] InnoDB: DeviceIoControl(IOCTL_STORAGE_QUERY_PROPERTY) unsupported on volume \\.\D: 2018-03-28 6:27:20 8120 [Note] Start binlog_dump to slave_server(2), pos(Master-bin.000298, 172616965) 2018-03-28 6:29:49 7080 [Note] D:\mariadb\bin\mysqld.exe (unknown): Normal shutdown 2018-03-28 6:29:50 7080 [Note] Event Scheduler: Purging the queue. 0 events 2018-03-28 6:29:50 7900 [Note] InnoDB: FTS optimize thread exiting. 2018-03-28 6:30:21 7080 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 168 user: 'liverjis' 2018-03-28 6:30:21 7080 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 166 user: 'liverjis' 2018-03-28 6:30:21 7080 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 164 user: 'liverjis' 2018-03-28 6:30:21 7080 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 162 user: 'liverjis' 2018-03-28 6:30:21 7080 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 160 user: 'liverjis' 2018-03-28 6:30:21 7080 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 158 user: 'liverjis' 2018-03-28 6:30:21 7080 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 156 user: 'liverjis' 2018-03-28 6:30:21 7080 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 154 user: 'liverjis' 2018-03-28 6:30:21 7080 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 152 user: 'liverjis' 2018-03-28 6:30:21 7080 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 150 user: 'liverjis' 2018-03-28 6:30:21 7080 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 146 user: 'liverjis' 2018-03-28 6:30:21 7080 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 145 user: 'liverjis' 2018-03-28 6:30:21 7080 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 144 user: 'liverjis' 2018-03-28 6:30:21 7080 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 140 user: 'liverjis' 2018-03-28 6:30:21 7080 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 139 user: 'liverjis' 2018-03-28 6:30:21 7080 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 138 user: 'liverjis' 2018-03-28 6:30:21 7080 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 136 user: 'liverjis' 2018-03-28 6:30:21 7080 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 135 user: 'liverjis' 2018-03-28 6:30:21 7080 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 134 user: 'liverjis' 2018-03-28 6:30:21 7080 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 133 user: 'liverjis' 2018-03-28 6:30:21 7080 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 132 user: 'liverjis' 2018-03-28 6:30:21 7080 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 130 user: 'liverjis' 2018-03-28 6:30:21 7080 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 129 user: 'liverjis' 2018-03-28 6:30:21 7080 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 128 user: 'liverjis' 2018-03-28 6:30:21 7080 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 127 user: 'liverjis' 2018-03-28 6:30:21 7080 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 126 user: 'liverjis' 2018-03-28 6:30:21 7080 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 125 user: 'liverjis' 2018-03-28 6:30:21 7080 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 124 user: 'liverjis' 2018-03-28 6:30:21 7080 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 123 user: 'liverjis' 2018-03-28 6:30:21 7080 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 122 user: 'liverjis' 2018-03-28 6:30:21 7080 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 121 user: 'liverjis' 2018-03-28 6:30:21 7080 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 120 user: 'liverjis' 2018-03-28 6:30:21 7080 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 118 user: 'liverjis' 2018-03-28 6:30:21 7080 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 117 user: 'liverjis' 2018-03-28 6:30:21 7080 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 116 user: 'liverjis' 2018-03-28 6:30:21 7080 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 115 user: 'liverjis' 2018-03-28 6:30:21 7080 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 114 user: 'liverjis' 2018-03-28 6:30:21 7080 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 113 user: 'liverjis' 2018-03-28 6:30:21 7080 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 112 user: 'liverjis' 2018-03-28 6:30:21 7080 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 110 user: 'liverjis' 2018-03-28 6:30:21 7080 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 109 user: 'liverjis' 2018-03-28 6:30:21 7080 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 108 user: 'liverjis' 2018-03-28 6:30:21 7080 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 103 user: 'liverjis' 2018-03-28 6:30:21 7080 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 102 user: 'liverjis' 2018-03-28 6:30:21 7080 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 101 user: 'liverjis' 2018-03-28 6:30:21 7080 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 100 user: 'liverjis' 2018-03-28 6:30:21 7080 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 99 user: 'liverjis' 2018-03-28 6:30:21 7080 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 98 user: 'liverjis' 2018-03-28 6:30:21 7080 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 97 user: 'liverjis' 2018-03-28 6:30:21 7080 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 96 user: 'liverjis' 2018-03-28 6:30:21 7080 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 95 user: 'liverjis' 2018-03-28 6:30:21 7080 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 94 user: 'liverjis' 2018-03-28 6:30:21 7080 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 93 user: 'liverjis' 2018-03-28 6:30:21 7080 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 92 user: 'liverjis' 2018-03-28 6:30:21 7080 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 90 user: 'liverjis' 2018-03-28 6:30:21 7080 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 88 user: 'liverjis' 2018-03-28 6:30:21 7080 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 87 user: 'liverjis' 2018-03-28 6:30:21 7080 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 85 user: 'liverjis' 2018-03-28 6:30:21 7080 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 83 user: 'liverjis' 2018-03-28 6:30:21 7080 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 82 user: 'liverjis' 2018-03-28 6:30:21 7080 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 81 user: 'liverjis' 2018-03-28 6:30:21 7080 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 80 user: 'liverjis' 2018-03-28 6:30:21 7080 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 77 user: 'liverjis' 2018-03-28 6:30:21 7080 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 76 user: 'liverjis' 2018-03-28 6:30:21 7080 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 75 user: 'liverjis' 2018-03-28 6:30:21 7080 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 74 user: 'liverjis' 2018-03-28 6:30:21 7080 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 73 user: 'liverjis' 2018-03-28 6:30:21 7080 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 72 user: 'liverjis' 2018-03-28 6:30:21 7080 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 71 user: 'liverjis' 2018-03-28 6:30:21 7080 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 70 user: 'liverjis' 2018-03-28 6:30:21 7080 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 69 user: 'liverjis' 2018-03-28 6:30:21 7080 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 68 user: 'liverjis' 2018-03-28 6:30:21 7080 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 65 user: 'liverjis' 2018-03-28 6:30:21 7080 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 62 user: 'liverjis' 2018-03-28 6:30:21 7080 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 61 user: 'liverjis' 2018-03-28 6:30:21 7080 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 60 user: 'liverjis' 2018-03-28 6:30:21 7080 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 59 user: 'liverjis' 2018-03-28 6:30:21 7080 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 58 user: 'liverjis' 2018-03-28 6:30:21 7080 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 57 user: 'liverjis' 2018-03-28 6:30:21 7080 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 55 user: 'liverjis' 2018-03-28 6:30:21 7080 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 53 user: 'liverjis' 2018-03-28 6:30:21 7080 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 52 user: 'liverjis' 2018-03-28 6:30:21 7080 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 51 user: 'liverjis' 2018-03-28 6:30:21 7080 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 50 user: 'liverjis' 2018-03-28 6:30:21 7080 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 49 user: 'liverjis' 2018-03-28 6:30:21 7080 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 47 user: 'liverjis' 2018-03-28 6:30:21 7080 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 45 user: 'liverjis' 2018-03-28 6:30:21 7080 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 44 user: 'liverjis' 2018-03-28 6:30:21 7080 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 43 user: 'liverjis' 2018-03-28 6:30:21 7080 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 42 user: 'liverjis' 2018-03-28 6:30:21 7080 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 41 user: 'liverjis' 2018-03-28 6:30:21 7080 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 40 user: 'liverjis' 2018-03-28 6:30:21 7080 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 39 user: 'liverjis' 2018-03-28 6:30:21 7080 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 38 user: 'liverjis' 2018-03-28 6:30:21 7080 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 37 user: 'liverjis' 2018-03-28 6:30:21 7080 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 36 user: 'liverjis' 2018-03-28 6:30:21 7080 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 34 user: 'liverjis' 2018-03-28 6:30:21 7080 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 32 user: 'liverjis' 2018-03-28 6:30:21 7080 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 31 user: 'liverjis' 2018-03-28 6:30:21 7080 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 30 user: 'liverjis' 2018-03-28 6:30:21 7080 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 29 user: 'liverjis' 2018-03-28 6:30:21 7080 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 28 user: 'liverjis' 2018-03-28 6:30:21 7080 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 27 user: 'liverjis' 2018-03-28 6:30:21 7080 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 25 user: 'liverjis' 2018-03-28 6:30:21 7080 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 23 user: 'liverjis' 2018-03-28 6:30:21 7080 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 22 user: 'liverjis' 2018-03-28 6:30:21 7080 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 21 user: 'liverjis' 2018-03-28 6:30:21 7080 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 20 user: 'liverjis' 2018-03-28 6:30:21 7080 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 19 user: 'liverjis' 2018-03-28 6:30:21 7080 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 18 user: 'liverjis' 2018-03-28 6:30:21 7080 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 16 user: 'liverjis' 2018-03-28 6:30:21 7080 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 15 user: 'liverjis' 2018-03-28 6:30:21 7080 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 14 user: 'liverjis' 2018-03-28 6:30:21 7080 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 13 user: 'liverjis' 2018-03-28 6:30:21 7080 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 12 user: 'liverjis' 2018-03-28 6:30:21 7080 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 11 user: 'liverjis' 2018-03-28 6:30:21 7080 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 10 user: 'liverjis' 2018-03-28 6:30:32 8140 [Warning] InnoDB: A long semaphore wait: --Thread 4528 has waited at buf0buf.cc line 4136 for 241.00 seconds the semaphore: S-lock on RW-latch at 042BF50C created in file buf0buf.cc line 1471 a writer (thread id 0) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file not yet reserved line 0 Last time write locked in file buf0buf.cc line 5363 2018-03-28 6:30:32 8140 [Warning] InnoDB: A long semaphore wait: --Thread 4172 has waited at ibuf0ibuf.cc line 4394 for 241.00 seconds the semaphore: Mutex at 01F93E20, Mutex IBUF created ibuf0ibuf.cc:516, lock var 2 2018-03-28 6:30:32 8140 [Warning] InnoDB: A long semaphore wait: --Thread 4776 has waited at ibuf0ibuf.cc line 4394 for 241.00 seconds the semaphore: Mutex at 01F93E20, Mutex IBUF created ibuf0ibuf.cc:516, lock var 2 2018-03-28 6:30:32 8140 [Warning] InnoDB: A long semaphore wait: --Thread 6032 has waited at ibuf0ibuf.cc line 4394 for 241.00 seconds the semaphore: Mutex at 01F93E20, Mutex IBUF created ibuf0ibuf.cc:516, lock var 2 2018-03-28 6:30:32 8140 [Warning] InnoDB: A long semaphore wait: --Thread 8096 has waited at ibuf0ibuf.cc line 2532 for 241.00 seconds the semaphore: S-lock on RW-latch at 04313E64 created in file buf0buf.cc line 1471 a writer (thread id 4528) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file ibuf0ibuf.cc line 2532 Last time write locked in file mtr0mtr.ic line 147 2018-03-28 6:30:32 8140 [Note] InnoDB: A semaphore wait: --Thread 4528 has waited at buf0buf.cc line 4136 for 241.00 seconds the semaphore: S-lock on RW-latch at 042BF50C created in file buf0buf.cc line 1471 a writer (thread id 0) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file not yet reserved line 0 Last time write locked in file buf0buf.cc line 5363 2018-03-28 6:30:32 8140 [Note] InnoDB: A semaphore wait: --Thread 4172 has waited at ibuf0ibuf.cc line 4394 for 241.00 seconds the semaphore: Mutex at 01F93E20, Mutex IBUF created ibuf0ibuf.cc:516, lock var 2 2018-03-28 6:30:32 8140 [Note] InnoDB: A semaphore wait: --Thread 4776 has waited at ibuf0ibuf.cc line 4394 for 241.00 seconds the semaphore: Mutex at 01F93E20, Mutex IBUF created ibuf0ibuf.cc:516, lock var 2 2018-03-28 6:30:32 8140 [Note] InnoDB: A semaphore wait: --Thread 6032 has waited at ibuf0ibuf.cc line 4394 for 241.00 seconds the semaphore: Mutex at 01F93E20, Mutex IBUF created ibuf0ibuf.cc:516, lock var 2 2018-03-28 6:30:32 8140 [Note] InnoDB: A semaphore wait: --Thread 8096 has waited at ibuf0ibuf.cc line 2532 for 241.00 seconds the semaphore: S-lock on RW-latch at 04313E64 created in file buf0buf.cc line 1471 a writer (thread id 4528) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file ibuf0ibuf.cc line 2532 Last time write locked in file mtr0mtr.ic line 147 2018-03-28 6:30:32 8140 [Note] InnoDB: A semaphore wait: --Thread 7944 has waited at buf0flu.cc line 1246 for 240.00 seconds the semaphore: SX-lock on RW-latch at 0435D294 created in file buf0buf.cc line 1471 a writer (thread id 4528) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file not yet reserved line 0 Last time write locked in file btr0cur.cc line 293 2018-03-28 6:30:32 8140 [Note] InnoDB: A semaphore wait: --Thread 6356 has waited at buf0buf.cc line 4136 for 224.00 seconds the semaphore: S-lock on RW-latch at 044376EC created in file buf0buf.cc line 1471 a writer (thread id 0) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file not yet reserved line 0 Last time write locked in file buf0buf.cc line 5363 2018-03-28 6:30:32 8140 [Note] InnoDB: A semaphore wait: --Thread 7736 has waited at ibuf0ibuf.cc line 3460 for 224.00 seconds the semaphore: S-lock on RW-latch at 04313E64 created in file buf0buf.cc line 1471 a writer (thread id 4528) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file ibuf0ibuf.cc line 2532 Last time write locked in file mtr0mtr.ic line 147 2018-03-28 6:30:32 8140 [Note] InnoDB: A semaphore wait: --Thread 788 has waited at row0ins.cc line 2944 for 224.00 seconds the semaphore: S-lock on RW-latch at 042B771C created in file buf0buf.cc line 1471 a writer (thread id 6356) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file row0ins.cc line 2944 Last time write locked in file mtr0mtr.ic line 147 2018-03-28 6:30:32 8140 [Note] InnoDB: A semaphore wait: --Thread 3056 has waited at row0ins.cc line 2944 for 223.00 seconds the semaphore: S-lock on RW-latch at 042B771C created in file buf0buf.cc line 1471 a writer (thread id 6356) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file row0ins.cc line 2944 Last time write locked in file mtr0mtr.ic line 147 2018-03-28 6:30:32 8140 [Note] InnoDB: A semaphore wait: --Thread 5500 has waited at row0ins.cc line 2944 for 223.00 seconds the semaphore: S-lock on RW-latch at 042B771C created in file buf0buf.cc line 1471 a writer (thread id 6356) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file row0ins.cc line 2944 Last time write locked in file mtr0mtr.ic line 147 2018-03-28 6:30:32 8140 [Note] InnoDB: A semaphore wait: --Thread 7948 has waited at row0ins.cc line 2944 for 224.00 seconds the semaphore: S-lock on RW-latch at 042B771C created in file buf0buf.cc line 1471 a writer (thread id 6356) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file row0ins.cc line 2944 Last time write locked in file mtr0mtr.ic line 147 2018-03-28 6:30:32 8140 [Note] InnoDB: A semaphore wait: --Thread 6180 has waited at row0ins.cc line 2944 for 220.00 seconds the semaphore: S-lock on RW-latch at 042B771C created in file buf0buf.cc line 1471 a writer (thread id 6356) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file row0ins.cc line 2944 Last time write locked in file mtr0mtr.ic line 147 2018-03-28 6:30:32 8140 [Note] InnoDB: A semaphore wait: --Thread 6200 has waited at row0ins.cc line 2944 for 220.00 seconds the semaphore: S-lock on RW-latch at 042B771C created in file buf0buf.cc line 1471 a writer (thread id 6356) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file row0ins.cc line 2944 Last time write locked in file mtr0mtr.ic line 147 2018-03-28 6:30:32 8140 [Note] InnoDB: A semaphore wait: --Thread 6196 has waited at row0ins.cc line 2944 for 220.00 seconds the semaphore: S-lock on RW-latch at 042B771C created in file buf0buf.cc line 1471 a writer (thread id 6356) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file row0ins.cc line 2944 Last time write locked in file mtr0mtr.ic line 147 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending reads 0, writes 0 ===================================== 2018-03-28 06:30:49 0x1fd0 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 77 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 1 srv_active, 0 srv_shutdown, 1 srv_idle srv_master_thread log flush and writes: 1 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 793 --Thread 4528 has waited at buf0buf.cc line 4136 for 258.00 seconds the semaphore: S-lock on RW-latch at 042BF50C created in file buf0buf.cc line 1471 a writer (thread id 0) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file not yet reserved line 0 Last time write locked in file buf0buf.cc line 5363 --Thread 4172 has waited at ibuf0ibuf.cc line 4394 for 258.00 seconds the semaphore: Mutex at 01F93E20, Mutex IBUF created ibuf0ibuf.cc:516, lock var 2 --Thread 4776 has waited at ibuf0ibuf.cc line 4394 for 258.00 seconds the semaphore: Mutex at 01F93E20, Mutex IBUF created ibuf0ibuf.cc:516, lock var 2 --Thread 6032 has waited at ibuf0ibuf.cc line 4394 for 258.00 seconds the semaphore: Mutex at 01F93E20, Mutex IBUF created ibuf0ibuf.cc:516, lock var 2 --Thread 8096 has waited at ibuf0ibuf.cc line 2532 for 258.00 seconds the semaphore: S-lock on RW-latch at 04313E64 created in file buf0buf.cc line 1471 a writer (thread id 4528) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file ibuf0ibuf.cc line 2532 Last time write locked in file mtr0mtr.ic line 147 --Thread 7944 has waited at buf0flu.cc line 1246 for 257.00 seconds the semaphore: SX-lock on RW-latch at 0435D294 created in file buf0buf.cc line 1471 a writer (thread id 4528) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file not yet reserved line 0 Last time write locked in file btr0cur.cc line 293 --Thread 6356 has waited at buf0buf.cc line 4136 for 241.00 seconds the semaphore: S-lock on RW-latch at 044376EC created in file buf0buf.cc line 1471 a writer (thread id 0) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file not yet reserved line 0 Last time write locked in file buf0buf.cc line 5363 --Thread 7736 has waited at ibuf0ibuf.cc line 3460 for 241.00 seconds the semaphore: S-lock on RW-latch at 04313E64 created in file buf0buf.cc line 1471 a writer (thread id 4528) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file ibuf0ibuf.cc line 2532 Last time write locked in file mtr0mtr.ic line 147 --Thread 788 has waited at row0ins.cc line 2944 for 241.00 seconds the semaphore: S-lock on RW-latch at 042B771C created in file buf0buf.cc line 1471 a writer (thread id 6356) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file row0ins.cc line 2944 Last time write locked in file mtr0mtr.ic line 147 --Thread 3056 has waited at row0ins.cc line 2944 for 240.00 seconds the semaphore: S-lock on RW-latch at 042B771C created in file buf0buf.cc line 1471 a writer (thread id 6356) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file row0ins.cc line 2944 Last time write locked in file mtr0mtr.ic line 147 --Thread 5500 has waited at row0ins.cc line 2944 for 240.00 seconds the semaphore: S-lock on RW-latch at 042B771C created in file buf0buf.cc line 1471 a writer (thread id 6356) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file row0ins.cc line 2944 Last time write locked in file mtr0mtr.ic line 147 --Thread 7948 has waited at row0ins.cc line 2944 for 241.00 seconds the semaphore: S-lock on RW-latch at 042B771C created in file buf0buf.cc line 1471 a writer (thread id 6356) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file row0ins.cc line 2944 Last time write locked in file mtr0mtr.ic line 147 --Thread 6180 has waited at row0ins.cc line 2944 for 237.00 seconds the semaphore: S-lock on RW-latch at 042B771C created in file buf0buf.cc line 1471 a writer (thread id 6356) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file row0ins.cc line 2944 Last time write locked in file mtr0mtr.ic line 147 --Thread 6200 has waited at row0ins.cc line 2944 for 237.00 seconds the semaphore: S-lock on RW-latch at 042B771C created in file buf0buf.cc line 1471 a writer (thread id 6356) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file row0ins.cc line 2944 Last time write locked in file mtr0mtr.ic line 147 --Thread 6196 has waited at row0ins.cc line 2944 for 237.00 seconds the semaphore: S-lock on RW-latch at 042B771C created in file buf0buf.cc line 1471 a writer (thread id 6356) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file row0ins.cc line 2944 Last time write locked in file mtr0mtr.ic line 147 OS WAIT ARRAY INFO: signal count 446 RW-shared spins 0, rounds 80, OS waits 37 RW-excl spins 0, rounds 961, OS waits 10 RW-sx spins 20, rounds 213, OS waits 4 Spin rounds per wait: 80.00 RW-shared, 961.00 RW-excl, 10.65 RW-sx ------------ TRANSACTIONS ------------ Trx id counter 137848872 Purge done for trx's n:o < 137848179 undo n:o < 0 state: exited History list length 0 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 281475041268120, not started sleeping before entering InnoDB mysql tables in use 1, locked 0 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041267560, not started sleeping before entering InnoDB mysql tables in use 1, locked 0 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041267000, not started sleeping before entering InnoDB mysql tables in use 1, locked 0 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041266440, not started sleeping before entering InnoDB mysql tables in use 1, locked 0 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041265880, not started sleeping before entering InnoDB mysql tables in use 1, locked 0 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041265320, not started sleeping before entering InnoDB mysql tables in use 1, locked 0 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041264760, not started sleeping before entering InnoDB mysql tables in use 1, locked 0 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041264200, not started sleeping before entering InnoDB mysql tables in use 1, locked 0 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041263640, not started sleeping before entering InnoDB mysql tables in use 1, locked 0 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041263080, not started sleeping before entering InnoDB mysql tables in use 1, locked 0 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041262520, not started sleeping before entering InnoDB mysql tables in use 1, locked 0 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041261960, not started sleeping before entering InnoDB mysql tables in use 1, locked 0 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041261400, not started sleeping before entering InnoDB mysql tables in use 31, locked 31 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041260840, not started sleeping before entering InnoDB mysql tables in use 1, locked 0 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041260280, not started sleeping before entering InnoDB mysql tables in use 1, locked 0 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041259720, not started sleeping before entering InnoDB mysql tables in use 1, locked 0 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041259160, not started sleeping before entering InnoDB mysql tables in use 31, locked 31 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041258600, not started sleeping before entering InnoDB mysql tables in use 31, locked 31 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041258040, not started sleeping before entering InnoDB mysql tables in use 31, locked 31 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041257480, not started sleeping before entering InnoDB mysql tables in use 31, locked 31 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041256920, not started sleeping before entering InnoDB mysql tables in use 31, locked 31 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041256360, not started sleeping before entering InnoDB mysql tables in use 1, locked 0 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041255800, not started sleeping before entering InnoDB mysql tables in use 1, locked 0 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041255240, not started sleeping before entering InnoDB mysql tables in use 31, locked 31 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041254680, not started sleeping before entering InnoDB mysql tables in use 1, locked 0 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041254120, not started sleeping before entering InnoDB mysql tables in use 1, locked 0 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041253560, not started sleeping before entering InnoDB mysql tables in use 1, locked 0 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041253000, not started sleeping before entering InnoDB mysql tables in use 1, locked 0 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041252440, not started sleeping before entering InnoDB mysql tables in use 1, locked 0 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041251880, not started sleeping before entering InnoDB mysql tables in use 31, locked 31 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041251320, not started sleeping before entering InnoDB mysql tables in use 31, locked 31 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041250760, not started sleeping before entering InnoDB mysql tables in use 1, locked 0 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041250200, not started sleeping before entering InnoDB mysql tables in use 31, locked 31 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041249640, not started sleeping before entering InnoDB mysql tables in use 31, locked 31 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041249080, not started sleeping before entering InnoDB mysql tables in use 1, locked 0 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041248520, not started sleeping before entering InnoDB mysql tables in use 31, locked 31 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041247960, not started sleeping before entering InnoDB mysql tables in use 1, locked 0 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041247400, not started sleeping before entering InnoDB mysql tables in use 31, locked 31 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041246840, not started sleeping before entering InnoDB mysql tables in use 1, locked 0 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041246280, not started sleeping before entering InnoDB mysql tables in use 1, locked 0 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041245720, not started sleeping before entering InnoDB mysql tables in use 1, locked 0 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041245160, not started sleeping before entering InnoDB mysql tables in use 1, locked 0 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041244600, not started sleeping before entering InnoDB mysql tables in use 31, locked 31 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041244040, not started sleeping before entering InnoDB mysql tables in use 1, locked 0 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041243480, not started sleeping before entering InnoDB mysql tables in use 1, locked 0 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041242920, not started sleeping before entering InnoDB mysql tables in use 31, locked 31 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041242360, not started sleeping before entering InnoDB mysql tables in use 31, locked 31 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041241800, not started sleeping before entering InnoDB mysql tables in use 1, locked 0 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041241240, not started sleeping before entering InnoDB mysql tables in use 31, locked 31 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041240680, not started sleeping before entering InnoDB mysql tables in use 1, locked 0 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041240120, not started sleeping before entering InnoDB mysql tables in use 1, locked 0 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041239560, not started sleeping before entering InnoDB mysql tables in use 1, locked 0 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041239000, not started sleeping before entering InnoDB mysql tables in use 1, locked 0 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041237880, not started sleeping before entering InnoDB mysql tables in use 1, locked 0 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041237320, not started sleeping before entering InnoDB mysql tables in use 1, locked 0 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041236760, not started sleeping before entering InnoDB mysql tables in use 31, locked 31 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041236200, not started sleeping before entering InnoDB mysql tables in use 1, locked 0 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041235640, not started sleeping before entering InnoDB mysql tables in use 1, locked 0 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041235080, not started sleeping before entering InnoDB mysql tables in use 1, locked 0 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041234520, not started sleeping before entering InnoDB mysql tables in use 1, locked 0 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041233960, not started sleeping before entering InnoDB mysql tables in use 5, locked 5 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041233400, not started sleeping before entering InnoDB mysql tables in use 1, locked 0 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041232840, not started sleeping before entering InnoDB mysql tables in use 1, locked 0 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041232280, not started sleeping before entering InnoDB mysql tables in use 1, locked 0 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041231720, not started sleeping before entering InnoDB mysql tables in use 1, locked 0 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041231160, not started sleeping before entering InnoDB mysql tables in use 1, locked 0 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041230600, not started sleeping before entering InnoDB mysql tables in use 1, locked 0 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041230040, not started sleeping before entering InnoDB mysql tables in use 1, locked 0 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041229480, not started sleeping before entering InnoDB mysql tables in use 1, locked 0 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041228920, not started sleeping before entering InnoDB mysql tables in use 1, locked 0 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041228360, not started sleeping before entering InnoDB mysql tables in use 1, locked 0 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041227800, not started sleeping before entering InnoDB mysql tables in use 31, locked 0 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041227240, not started sleeping before entering InnoDB mysql tables in use 1, locked 0 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041226680, not started sleeping before entering InnoDB mysql tables in use 1, locked 0 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041226120, not started sleeping before entering InnoDB mysql tables in use 1, locked 0 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041225560, not started sleeping before entering InnoDB mysql tables in use 1, locked 0 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041225000, not started sleeping before entering InnoDB mysql tables in use 1, locked 0 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041224440, not started sleeping before entering InnoDB mysql tables in use 1, locked 0 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041223880, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041223320, not started sleeping before entering InnoDB mysql tables in use 1, locked 0 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041222760, not started sleeping before entering InnoDB mysql tables in use 1, locked 0 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041222200, not started sleeping before entering InnoDB mysql tables in use 1, locked 0 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041221640, not started sleeping before entering InnoDB mysql tables in use 1, locked 0 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041221080, not started sleeping before entering InnoDB mysql tables in use 1, locked 0 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041220520, not started sleeping before entering InnoDB mysql tables in use 1, locked 0 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041219960, not started sleeping before entering InnoDB mysql tables in use 31, locked 31 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041219400, not started sleeping before entering InnoDB mysql tables in use 31, locked 31 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041218840, not started sleeping before entering InnoDB mysql tables in use 31, locked 31 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041218280, not started sleeping before entering InnoDB mysql tables in use 31, locked 31 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041217720, not started sleeping before entering InnoDB mysql tables in use 31, locked 31 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041217160, not started sleeping before entering InnoDB mysql tables in use 31, locked 31 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041216600, not started sleeping before entering InnoDB mysql tables in use 31, locked 31 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041216040, not started sleeping before entering InnoDB mysql tables in use 31, locked 31 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041215480, not started sleeping before entering InnoDB mysql tables in use 1, locked 0 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041214920, not started sleeping before entering InnoDB mysql tables in use 31, locked 31 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041210440, not started sleeping before entering InnoDB mysql tables in use 31, locked 31 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041208760, not started sleeping before entering InnoDB mysql tables in use 31, locked 31 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041208200, not started sleeping before entering InnoDB mysql tables in use 1, locked 0 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041207080, not started sleeping before entering InnoDB mysql tables in use 1, locked 0 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041206520, not started sleeping before entering InnoDB mysql tables in use 31, locked 31 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041205400, not started sleeping before entering InnoDB mysql tables in use 31, locked 31 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041204280, not started sleeping before entering InnoDB mysql tables in use 1, locked 0 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041203720, not started sleeping before entering InnoDB mysql tables in use 1, locked 0 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041203160, not started sleeping before entering InnoDB mysql tables in use 31, locked 31 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041202600, not started sleeping before entering InnoDB mysql tables in use 31, locked 31 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041201480, not started sleeping before entering InnoDB mysql tables in use 1, locked 0 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041200920, not started sleeping before entering InnoDB mysql tables in use 31, locked 31 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475041200360, not started sleeping before entering InnoDB mysql tables in use 31, locked 31 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 137848748, ACTIVE 237 sec inserting, thread declared inside InnoDB 5000 mysql tables in use 31, locked 31 1 lock struct(s), heap size 1080, 0 row lock(s), undo log entries 1 MySQL thread id 38, OS thread handle 0, query id 6196 192.168.25.7 liverjis INSERT INTO RJIS_JQI_PERF (USER_ID, MACHINE_ID, INPUT_TIME, OUTPUT_TIME, TYPE_1, TOTAL_RESPONSE_TIME, IJQ_TIME, CTR_TIME, EXTERNAL_TIME, SERVER_NODE_NAME, QUERY_DETAILS, IP_ADDRESS, NRS_TIMEOUT, TRANSLATED_USER_ID, PORT) VALUES ('ZZMON01','','2018-03-28 06:10:00','2018-03-28 06:10:00',3203,15,15,0,0,'RIBSCLK3','','192.168.25.7',0,null,6002) ---TRANSACTION 137848747, ACTIVE 237 sec inserting, thread declared inside InnoDB 5000 mysql tables in use 31, locked 31 1 lock struct(s), heap size 1080, 0 row lock(s), undo log entries 1 MySQL thread id 37, OS thread handle 0, query id 6200 192.168.25.7 liverjis INSERT INTO RJIS_JQI_PERF (USER_ID, MACHINE_ID, INPUT_TIME, OUTPUT_TIME, TYPE_1, TOTAL_RESPONSE_TIME, IJQ_TIME, CTR_TIME, EXTERNAL_TIME, SERVER_NODE_NAME, QUERY_DETAILS, IP_ADDRESS, NRS_TIMEOUT, TRANSLATED_USER_ID, PORT) VALUES ('CKJQ0001','','2018-03-28 06:06:43','2018-03-28 06:06:43',3203,250,234,0,0,'RIBSCLK3','O','192.168.25.17',0,null,6004) ---TRANSACTION 137848746, ACTIVE 237 sec inserting, thread declared inside InnoDB 5000 mysql tables in use 31, locked 31 1 lock struct(s), heap size 1080, 0 row lock(s), undo log entries 1 MySQL thread id 36, OS thread handle 0, query id 6180 145.227.178.235 liverjis INSERT INTO RJIS_JQI_PERF (USER_ID, MACHINE_ID, INPUT_TIME, OUTPUT_TIME, TYPE_1, TOTAL_RESPONSE_TIME, IJQ_TIME, CTR_TIME, EXTERNAL_TIME, SERVER_NODE_NAME, QUERY_DETAILS, IP_ADDRESS, NRS_TIMEOUT, TRANSLATED_USER_ID, PORT) VALUES ('EUJQ0001','','2018-03-28 05:50:18','2018-03-28 05:50:18',3202,47,31,0,0,'JPEURT2','','10.101.164.163',0,null,6001) ---TRANSACTION 137848507, ACTIVE 240 sec inserting, thread declared inside InnoDB 5000 mysql tables in use 31, locked 31 1 lock struct(s), heap size 1080, 0 row lock(s), undo log entries 1 MySQL thread id 34, OS thread handle 0, query id 5500 145.227.178.199 liverjis INSERT INTO RJIS_JQI_PERF (USER_ID, MACHINE_ID, INPUT_TIME, OUTPUT_TIME, TYPE_1, TOTAL_RESPONSE_TIME, IJQ_TIME, CTR_TIME, EXTERNAL_TIME, SERVER_NODE_NAME, QUERY_DETAILS, IP_ADDRESS, NRS_TIMEOUT, TRANSLATED_USER_ID, PORT) VALUES ('ZZMON01','','2018-03-28 05:50:53','2018-03-28 05:50:53',3203,16,0,0,0,'NRSMEDT2','','145.227.178.199',0,null,6024) ---TRANSACTION 137848490, ACTIVE 240 sec inserting, thread declared inside InnoDB 5000 mysql tables in use 31, locked 31 1 lock struct(s), heap size 1080, 0 row lock(s), undo log entries 1 MySQL thread id 32, OS thread handle 0, query id 3056 145.227.178.233 liverjis INSERT INTO RJIS_JQI_PERF (USER_ID, MACHINE_ID, INPUT_TIME, OUTPUT_TIME, TYPE_1, TOTAL_RESPONSE_TIME, IJQ_TIME, CTR_TIME, EXTERNAL_TIME, SERVER_NODE_NAME, QUERY_DETAILS, IP_ADDRESS, NRS_TIMEOUT, TRANSLATED_USER_ID, PORT) VALUES ('ZZMON01','','2018-03-28 05:55:08','2018-03-28 05:55:08',3203,234,203,0,0,'JPGUIT4','','145.227.178.233',0,null,6004) ---TRANSACTION 137848235, ACTIVE 241 sec inserting, thread declared inside InnoDB 5000 mysql tables in use 31, locked 31 1 lock struct(s), heap size 1080, 0 row lock(s), undo log entries 1 MySQL thread id 20, OS thread handle 0, query id 7948 145.227.178.232 liverjis INSERT INTO RJIS_JQI_PERF (USER_ID, MACHINE_ID, INPUT_TIME, OUTPUT_TIME, TYPE_1, TOTAL_RESPONSE_TIME, IJQ_TIME, CTR_TIME, EXTERNAL_TIME, SERVER_NODE_NAME, QUERY_DETAILS, IP_ADDRESS, NRS_TIMEOUT, TRANSLATED_USER_ID, PORT) VALUES ('ZZMON01','','2018-03-28 05:54:23','2018-03-28 05:54:23',3203,15,15,0,0,'JPGUIT3','','145.227.178.232',0,null,6002) ---TRANSACTION 137848179, ACTIVE 241 sec inserting, thread declared inside InnoDB 5000 mysql tables in use 1, locked 1 5 lock struct(s), heap size 1080, 2 row lock(s), undo log entries 1 MySQL thread id 30, OS thread handle 0, query id 7736 145.227.178.233 liverjis update INSERT INTO LOGIN_HISTORY (USER_ID, COMPANY_ID, LOCATION, DATE_CREATED, DATE_AMENDED, AMENDED_BY, VERSION) VALUES ('RS07019','SOUTHERN','ECR95','2018-03-28 05:35:08','2018-03-28 05:35:08','RS07019',1) ---TRANSACTION 137848152, ACTIVE 241 sec inserting, thread declared inside InnoDB 5000 mysql tables in use 31, locked 31 1 lock struct(s), heap size 1080, 0 row lock(s), undo log entries 1 MySQL thread id 25, OS thread handle 0, query id 788 10.172.12.141 liverjis INSERT INTO RJIS_JQI_PERF (USER_ID, MACHINE_ID, INPUT_TIME, OUTPUT_TIME, TYPE_1, TOTAL_RESPONSE_TIME, IJQ_TIME, CTR_TIME, EXTERNAL_TIME, SERVER_NODE_NAME, QUERY_DETAILS, IP_ADDRESS, NRS_TIMEOUT, TRANSLATED_USER_ID, PORT) VALUES ('ZZMON01','','2018-03-28 06:12:14','2018-03-28 06:12:14',3203,31,23,0,0,'RIBSNG2','','10.172.12.141',0,null,6003) ---TRANSACTION 137847945, ACTIVE 241 sec inserting, thread declared inside InnoDB 5000 mysql tables in use 31, locked 31 1 lock struct(s), heap size 1080, 0 row lock(s), undo log entries 1 MySQL thread id 18, OS thread handle 0, query id 6356 145.227.178.235 liverjis INSERT INTO RJIS_JQI_PERF (USER_ID, MACHINE_ID, INPUT_TIME, OUTPUT_TIME, TYPE_1, TOTAL_RESPONSE_TIME, IJQ_TIME, CTR_TIME, EXTERNAL_TIME, SERVER_NODE_NAME, QUERY_DETAILS, IP_ADDRESS, NRS_TIMEOUT, TRANSLATED_USER_ID, PORT) VALUES ('EUJQ0001','','2018-03-28 06:19:06','2018-03-28 06:19:06',3309,187,156,0,125,'JPEURT2','','10.101.164.163',0,null,6002) -------- FILE I/O -------- I/O thread 0 state: complete io for buf page (insert buffer thread) I/O thread 1 state: complete io for buf page (log thread) I/O thread 2 state: complete io for buf page (read thread) I/O thread 3 state: complete io for buf page (read thread) I/O thread 4 state: native aio handle (read thread) I/O thread 5 state: native aio handle (read thread) I/O thread 6 state: native aio handle (write thread) I/O thread 7 state: native aio handle (write thread) I/O thread 8 state: native aio handle (write thread) I/O thread 9 state: native aio handle (write thread) Pending normal aio reads: [39, 16, 19, 26] , 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 7831 OS file reads, 1513 OS file writes, 1296 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- InnoDB: ###### Diagnostic info printed to the standard error stream 2018-03-28 6:31:03 8140 [Warning] InnoDB: A long semaphore wait: --Thread 4528 has waited at buf0buf.cc line 4136 for 272.00 seconds the semaphore: S-lock on RW-latch at 042BF50C created in file buf0buf.cc line 1471 a writer (thread id 0) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file not yet reserved line 0 Last time write locked in file buf0buf.cc line 5363 2018-03-28 6:31:03 8140 [Warning] InnoDB: A long semaphore wait: --Thread 4172 has waited at ibuf0ibuf.cc line 4394 for 272.00 seconds the semaphore: Mutex at 01F93E20, Mutex IBUF created ibuf0ibuf.cc:516, lock var 2 2018-03-28 6:31:03 8140 [Warning] InnoDB: A long semaphore wait: --Thread 4776 has waited at ibuf0ibuf.cc line 4394 for 272.00 seconds the semaphore: Mutex at 01F93E20, Mutex IBUF created ibuf0ibuf.cc:516, lock var 2 2018-03-28 6:31:03 8140 [Warning] InnoDB: A long semaphore wait: --Thread 6032 has waited at ibuf0ibuf.cc line 4394 for 272.00 seconds the semaphore: Mutex at 01F93E20, Mutex IBUF created ibuf0ibuf.cc:516, lock var 2 2018-03-28 6:31:03 8140 [Warning] InnoDB: A long semaphore wait: --Thread 8096 has waited at ibuf0ibuf.cc line 2532 for 272.00 seconds the semaphore: S-lock on RW-latch at 04313E64 created in file buf0buf.cc line 1471 a writer (thread id 4528) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file ibuf0ibuf.cc line 2532 Last time write locked in file mtr0mtr.ic line 147 2018-03-28 6:31:03 8140 [Warning] InnoDB: A long semaphore wait: --Thread 7944 has waited at buf0flu.cc line 1246 for 271.00 seconds the semaphore: SX-lock on RW-latch at 0435D294 created in file buf0buf.cc line 1471 a writer (thread id 4528) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file not yet reserved line 0 Last time write locked in file btr0cur.cc line 293 2018-03-28 6:31:03 8140 [Warning] InnoDB: A long semaphore wait: --Thread 6356 has waited at buf0buf.cc line 4136 for 255.00 seconds the semaphore: S-lock on RW-latch at 044376EC created in file buf0buf.cc line 1471 a writer (thread id 0) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file not yet reserved line 0 Last time write locked in file buf0buf.cc line 5363 2018-03-28 6:31:03 8140 [Warning] InnoDB: A long semaphore wait: --Thread 7736 has waited at ibuf0ibuf.cc line 3460 for 255.00 seconds the semaphore: S-lock on RW-latch at 04313E64 created in file buf0buf.cc line 1471 a writer (thread id 4528) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file ibuf0ibuf.cc line 2532 Last time write locked in file mtr0mtr.ic line 147 2018-03-28 6:31:03 8140 [Warning] InnoDB: A long semaphore wait: --Thread 788 has waited at row0ins.cc line 2944 for 255.00 seconds the semaphore: S-lock on RW-latch at 042B771C created in file buf0buf.cc line 1471 a writer (thread id 6356) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file row0ins.cc line 2944 Last time write locked in file mtr0mtr.ic line 147 2018-03-28 6:31:03 8140 [Warning] InnoDB: A long semaphore wait: --Thread 3056 has waited at row0ins.cc line 2944 for 254.00 seconds the semaphore: S-lock on RW-latch at 042B771C created in file buf0buf.cc line 1471 a writer (thread id 6356) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file row0ins.cc line 2944 Last time write locked in file mtr0mtr.ic line 147 2018-03-28 6:31:03 8140 [Warning] InnoDB: A long semaphore wait: --Thread 5500 has waited at row0ins.cc line 2944 for 254.00 seconds the semaphore: S-lock on RW-latch at 042B771C created in file buf0buf.cc line 1471 a writer (thread id 6356) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file row0ins.cc line 2944 Last time write locked in file mtr0mtr.ic line 147 2018-03-28 6:31:03 8140 [Warning] InnoDB: A long semaphore wait: --Thread 7948 has waited at row0ins.cc line 2944 for 255.00 seconds the semaphore: S-lock on RW-latch at 042B771C created in file buf0buf.cc line 1471 a writer (thread id 6356) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file row0ins.cc line 2944 Last time write locked in file mtr0mtr.ic line 147 2018-03-28 6:31:03 8140 [Warning] InnoDB: A long semaphore wait: --Thread 6180 has waited at row0ins.cc line 2944 for 251.00 seconds the semaphore: S-lock on RW-latch at 042B771C created in file buf0buf.cc line 1471 a writer (thread id 6356) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file row0ins.cc line 2944 Last time write locked in file mtr0mtr.ic line 147 2018-03-28 6:31:03 8140 [Warning] InnoDB: A long semaphore wait: --Thread 6200 has waited at row0ins.cc line 2944 for 251.00 seconds the semaphore: S-lock on RW-latch at 042B771C created in file buf0buf.cc line 1471 a writer (thread id 6356) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file row0ins.cc line 2944 Last time write locked in file mtr0mtr.ic line 147 2018-03-28 6:31:03 8140 [Warning] InnoDB: A long semaphore wait: --Thread 6196 has waited at row0ins.cc line 2944 for 251.00 seconds the semaphore: S-lock on RW-latch at 042B771C created in file buf0buf.cc line 1471 a writer (thread id 6356) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file row0ins.cc line 2944 Last time write locked in file mtr0mtr.ic line 147 2018-03-28 6:31:03 8140 [Note] InnoDB: A semaphore wait: --Thread 4528 has waited at buf0buf.cc line 4136 for 272.00 seconds the semaphore: S-lock on RW-latch at 042BF50C created in file buf0buf.cc line 1471 a writer (thread id 0) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file not yet reserved line 0 Last time write locked in file buf0buf.cc line 5363 2018-03-28 6:31:03 8140 [Note] InnoDB: A semaphore wait: --Thread 4172 has waited at ibuf0ibuf.cc line 4394 for 272.00 seconds the semaphore: Mutex at 01F93E20, Mutex IBUF created ibuf0ibuf.cc:516, lock var 2 2018-03-28 6:31:03 8140 [Note] InnoDB: A semaphore wait: --Thread 4776 has waited at ibuf0ibuf.cc line 4394 for 272.00 seconds the semaphore: Mutex at 01F93E20, Mutex IBUF created ibuf0ibuf.cc:516, lock var 2 2018-03-28 6:31:03 8140 [Note] InnoDB: A semaphore wait: --Thread 6032 has waited at ibuf0ibuf.cc line 4394 for 272.00 seconds the semaphore: Mutex at 01F93E20, Mutex IBUF created ibuf0ibuf.cc:516, lock var 2 2018-03-28 6:31:03 8140 [Note] InnoDB: A semaphore wait: --Thread 8096 has waited at ibuf0ibuf.cc line 2532 for 272.00 seconds the semaphore: S-lock on RW-latch at 04313E64 created in file buf0buf.cc line 1471 a writer (thread id 4528) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file ibuf0ibuf.cc line 2532 Last time write locked in file mtr0mtr.ic line 147 2018-03-28 6:31:03 8140 [Note] InnoDB: A semaphore wait: --Thread 7944 has waited at buf0flu.cc line 1246 for 271.00 seconds the semaphore: SX-lock on RW-latch at 0435D294 created in file buf0buf.cc line 1471 a writer (thread id 4528) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file not yet reserved line 0 Last time write locked in file btr0cur.cc line 293 2018-03-28 6:31:03 8140 [Note] InnoDB: A semaphore wait: --Thread 6356 has waited at buf0buf.cc line 4136 for 255.00 seconds the semaphore: S-lock on RW-latch at 044376EC created in file buf0buf.cc line 1471 a writer (thread id 0) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file not yet reserved line 0 Last time write locked in file buf0buf.cc line 5363 2018-03-28 6:31:03 8140 [Note] InnoDB: A semaphore wait: --Thread 7736 has waited at ibuf0ibuf.cc line 3460 for 255.00 seconds the semaphore: S-lock on RW-latch at 04313E64 created in file buf0buf.cc line 1471 a writer (thread id 4528) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file ibuf0ibuf.cc line 2532 Last time write locked in file mtr0mtr.ic line 147 2018-03-28 6:31:03 8140 [Note] InnoDB: A semaphore wait: --Thread 788 has waited at row0ins.cc line 2944 for 255.00 seconds the semaphore: S-lock on RW-latch at 042B771C created in file buf0buf.cc line 1471 a writer (thread id 6356) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file row0ins.cc line 2944 Last time write locked in file mtr0mtr.ic line 147 2018-03-28 6:31:03 8140 [Note] InnoDB: A semaphore wait: --Thread 3056 has waited at row0ins.cc line 2944 for 254.00 seconds the semaphore: S-lock on RW-latch at 042B771C created in file buf0buf.cc line 1471 a writer (thread id 6356) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file row0ins.cc line 2944 Last time write locked in file mtr0mtr.ic line 147 2018-03-28 6:31:03 8140 [Note] InnoDB: A semaphore wait: --Thread 5500 has waited at row0ins.cc line 2944 for 254.00 seconds the semaphore: S-lock on RW-latch at 042B771C created in file buf0buf.cc line 1471 a writer (thread id 6356) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file row0ins.cc line 2944 Last time write locked in file mtr0mtr.ic line 147 2018-03-28 6:31:03 8140 [Note] InnoDB: A semaphore wait: --Thread 7948 has waited at row0ins.cc line 2944 for 255.00 seconds the semaphore: S-lock on RW-latch at 042B771C created in file buf0buf.cc line 1471 a writer (thread id 6356) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file row0ins.cc line 2944 Last time write locked in file mtr0mtr.ic line 147 2018-03-28 6:31:03 8140 [Note] InnoDB: A semaphore wait: --Thread 6180 has waited at row0ins.cc line 2944 for 251.00 seconds the semaphore: S-lock on RW-latch at 042B771C created in file buf0buf.cc line 1471 a writer (thread id 6356) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file row0ins.cc line 2944 Last time write locked in file mtr0mtr.ic line 147 2018-03-28 6:31:03 8140 [Note] InnoDB: A semaphore wait: --Thread 6200 has waited at row0ins.cc line 2944 for 251.00 seconds the semaphore: S-lock on RW-latch at 042B771C created in file buf0buf.cc line 1471 a writer (thread id 6356) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file row0ins.cc line 2944 Last time write locked in file mtr0mtr.ic line 147 2018-03-28 6:31:03 8140 [Note] InnoDB: A semaphore wait: --Thread 6196 has waited at row0ins.cc line 2944 for 251.00 seconds the semaphore: S-lock on RW-latch at 042B771C created in file buf0buf.cc line 1471 a writer (thread id 6356) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file row0ins.cc line 2944 Last time write locked in file mtr0mtr.ic line 147 2018-03-28 6:31:03 8140 [Note] InnoDB: A semaphore wait: --Thread 8144 has waited at ibuf0ibuf.cc line 4921 for 14.00 seconds the semaphore: Mutex at 01F93E20, Mutex IBUF created ibuf0ibuf.cc:516, lock var 2 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending reads 0, writes 0 InnoDB: ###### Diagnostic info printed to the standard error stream 2018-03-28 6:31:34 8140 [Warning] InnoDB: A long semaphore wait: --Thread 4528 has waited at buf0buf.cc line 4136 for 303.00 seconds the semaphore: S-lock on RW-latch at 042BF50C created in file buf0buf.cc line 1471 a writer (thread id 0) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file not yet reserved line 0 Last time write locked in file buf0buf.cc line 5363 2018-03-28 6:31:34 8140 [Warning] InnoDB: A long semaphore wait: --Thread 4172 has waited at ibuf0ibuf.cc line 4394 for 303.00 seconds the semaphore: Mutex at 01F93E20, Mutex IBUF created ibuf0ibuf.cc:516, lock var 2 2018-03-28 6:31:34 8140 [Warning] InnoDB: A long semaphore wait: --Thread 4776 has waited at ibuf0ibuf.cc line 4394 for 303.00 seconds the semaphore: Mutex at 01F93E20, Mutex IBUF created ibuf0ibuf.cc:516, lock var 2 2018-03-28 6:31:34 8140 [Warning] InnoDB: A long semaphore wait: --Thread 6032 has waited at ibuf0ibuf.cc line 4394 for 303.00 seconds the semaphore: Mutex at 01F93E20, Mutex IBUF created ibuf0ibuf.cc:516, lock var 2 2018-03-28 6:31:34 8140 [Warning] InnoDB: A long semaphore wait: --Thread 8096 has waited at ibuf0ibuf.cc line 2532 for 303.00 seconds the semaphore: S-lock on RW-latch at 04313E64 created in file buf0buf.cc line 1471 a writer (thread id 4528) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file ibuf0ibuf.cc line 2532 Last time write locked in file mtr0mtr.ic line 147 2018-03-28 6:31:34 8140 [Warning] InnoDB: A long semaphore wait: --Thread 7944 has waited at buf0flu.cc line 1246 for 302.00 seconds the semaphore: SX-lock on RW-latch at 0435D294 created in file buf0buf.cc line 1471 a writer (thread id 4528) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file not yet reserved line 0 Last time write locked in file btr0cur.cc line 293 2018-03-28 6:31:34 8140 [Warning] InnoDB: A long semaphore wait: --Thread 6356 has waited at buf0buf.cc line 4136 for 286.00 seconds the semaphore: S-lock on RW-latch at 044376EC created in file buf0buf.cc line 1471 a writer (thread id 0) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file not yet reserved line 0 Last time write locked in file buf0buf.cc line 5363 2018-03-28 6:31:34 8140 [Warning] InnoDB: A long semaphore wait: --Thread 7736 has waited at ibuf0ibuf.cc line 3460 for 286.00 seconds the semaphore: S-lock on RW-latch at 04313E64 created in file buf0buf.cc line 1471 a writer (thread id 4528) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file ibuf0ibuf.cc line 2532 Last time write locked in file mtr0mtr.ic line 147 2018-03-28 6:31:34 8140 [Warning] InnoDB: A long semaphore wait: --Thread 788 has waited at row0ins.cc line 2944 for 286.00 seconds the semaphore: S-lock on RW-latch at 042B771C created in file buf0buf.cc line 1471 a writer (thread id 6356) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file row0ins.cc line 2944 Last time write locked in file mtr0mtr.ic line 147 2018-03-28 6:31:34 8140 [Warning] InnoDB: A long semaphore wait: --Thread 3056 has waited at row0ins.cc line 2944 for 285.00 seconds the semaphore: S-lock on RW-latch at 042B771C created in file buf0buf.cc line 1471 a writer (thread id 6356) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file row0ins.cc line 2944 Last time write locked in file mtr0mtr.ic line 147 2018-03-28 6:31:34 8140 [Warning] InnoDB: A long semaphore wait: --Thread 5500 has waited at row0ins.cc line 2944 for 285.00 seconds the semaphore: S-lock on RW-latch at 042B771C created in file buf0buf.cc line 1471 a writer (thread id 6356) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file row0ins.cc line 2944 Last time write locked in file mtr0mtr.ic line 147 2018-03-28 6:31:34 8140 [Warning] InnoDB: A long semaphore wait: --Thread 7948 has waited at row0ins.cc line 2944 for 286.00 seconds the semaphore: S-lock on RW-latch at 042B771C created in file buf0buf.cc line 1471 a writer (thread id 6356) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file row0ins.cc line 2944 Last time write locked in file mtr0mtr.ic line 147 2018-03-28 6:31:34 8140 [Warning] InnoDB: A long semaphore wait: --Thread 6180 has waited at row0ins.cc line 2944 for 282.00 seconds the semaphore: S-lock on RW-latch at 042B771C created in file buf0buf.cc line 1471 a writer (thread id 6356) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file row0ins.cc line 2944 Last time write locked in file mtr0mtr.ic line 147 2018-03-28 6:31:34 8140 [Warning] InnoDB: A long semaphore wait: --Thread 6200 has waited at row0ins.cc line 2944 for 282.00 seconds the semaphore: S-lock on RW-latch at 042B771C created in file buf0buf.cc line 1471 a writer (thread id 6356) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file row0ins.cc line 2944 Last time write locked in file mtr0mtr.ic line 147 2018-03-28 6:31:34 8140 [Warning] InnoDB: A long semaphore wait: --Thread 6196 has waited at row0ins.cc line 2944 for 282.00 seconds the semaphore: S-lock on RW-latch at 042B771C created in file buf0buf.cc line 1471 a writer (thread id 6356) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file row0ins.cc line 2944 Last time write locked in file mtr0mtr.ic line 147 2018-03-28 6:31:34 8140 [Note] InnoDB: A semaphore wait: --Thread 4528 has waited at buf0buf.cc line 4136 for 303.00 seconds the semaphore: S-lock on RW-latch at 042BF50C created in file buf0buf.cc line 1471 a writer (thread id 0) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file not yet reserved line 0 Last time write locked in file buf0buf.cc line 5363 2018-03-28 6:31:34 8140 [Note] InnoDB: A semaphore wait: --Thread 4172 has waited at ibuf0ibuf.cc line 4394 for 303.00 seconds the semaphore: Mutex at 01F93E20, Mutex IBUF created ibuf0ibuf.cc:516, lock var 2 2018-03-28 6:31:34 8140 [Note] InnoDB: A semaphore wait: --Thread 4776 has waited at ibuf0ibuf.cc line 4394 for 303.00 seconds the semaphore: Mutex at 01F93E20, Mutex IBUF created ibuf0ibuf.cc:516, lock var 2 2018-03-28 6:31:34 8140 [Note] InnoDB: A semaphore wait: --Thread 6032 has waited at ibuf0ibuf.cc line 4394 for 303.00 seconds the semaphore: Mutex at 01F93E20, Mutex IBUF created ibuf0ibuf.cc:516, lock var 2 2018-03-28 6:31:34 8140 [Note] InnoDB: A semaphore wait: --Thread 8096 has waited at ibuf0ibuf.cc line 2532 for 303.00 seconds the semaphore: S-lock on RW-latch at 04313E64 created in file buf0buf.cc line 1471 a writer (thread id 4528) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file ibuf0ibuf.cc line 2532 Last time write locked in file mtr0mtr.ic line 147 2018-03-28 6:31:34 8140 [Note] InnoDB: A semaphore wait: --Thread 7944 has waited at buf0flu.cc line 1246 for 302.00 seconds the semaphore: SX-lock on RW-latch at 0435D294 created in file buf0buf.cc line 1471 a writer (thread id 4528) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file not yet reserved line 0 Last time write locked in file btr0cur.cc line 293 2018-03-28 6:31:34 8140 [Note] InnoDB: A semaphore wait: --Thread 6356 has waited at buf0buf.cc line 4136 for 286.00 seconds the semaphore: S-lock on RW-latch at 044376EC created in file buf0buf.cc line 1471 a writer (thread id 0) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file not yet reserved line 0 Last time write locked in file buf0buf.cc line 5363 2018-03-28 6:31:34 8140 [Note] InnoDB: A semaphore wait: --Thread 7736 has waited at ibuf0ibuf.cc line 3460 for 286.00 seconds the semaphore: S-lock on RW-latch at 04313E64 created in file buf0buf.cc line 1471 a writer (thread id 4528) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file ibuf0ibuf.cc line 2532 Last time write locked in file mtr0mtr.ic line 147 2018-03-28 6:31:34 8140 [Note] InnoDB: A semaphore wait: --Thread 788 has waited at row0ins.cc line 2944 for 286.00 seconds the semaphore: S-lock on RW-latch at 042B771C created in file buf0buf.cc line 1471 a writer (thread id 6356) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file row0ins.cc line 2944 Last time write locked in file mtr0mtr.ic line 147 2018-03-28 6:31:34 8140 [Note] InnoDB: A semaphore wait: --Thread 3056 has waited at row0ins.cc line 2944 for 285.00 seconds the semaphore: S-lock on RW-latch at 042B771C created in file buf0buf.cc line 1471 a writer (thread id 6356) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file row0ins.cc line 2944 Last time write locked in file mtr0mtr.ic line 147 2018-03-28 6:31:34 8140 [Note] InnoDB: A semaphore wait: --Thread 5500 has waited at row0ins.cc line 2944 for 285.00 seconds the semaphore: S-lock on RW-latch at 042B771C created in file buf0buf.cc line 1471 a writer (thread id 6356) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file row0ins.cc line 2944 Last time write locked in file mtr0mtr.ic line 147 2018-03-28 6:31:34 8140 [Note] InnoDB: A semaphore wait: --Thread 7948 has waited at row0ins.cc line 2944 for 286.00 seconds the semaphore: S-lock on RW-latch at 042B771C created in file buf0buf.cc line 1471 a writer (thread id 6356) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file row0ins.cc line 2944 Last time write locked in file mtr0mtr.ic line 147 2018-03-28 6:31:34 8140 [Note] InnoDB: A semaphore wait: --Thread 6180 has waited at row0ins.cc line 2944 for 282.00 seconds the semaphore: S-lock on RW-latch at 042B771C created in file buf0buf.cc line 1471 a writer (thread id 6356) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file row0ins.cc line 2944 Last time write locked in file mtr0mtr.ic line 147 2018-03-28 6:31:34 8140 [Note] InnoDB: A semaphore wait: --Thread 6200 has waited at row0ins.cc line 2944 for 282.00 seconds the semaphore: S-lock on RW-latch at 042B771C created in file buf0buf.cc line 1471 a writer (thread id 6356) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file row0ins.cc line 2944 Last time write locked in file mtr0mtr.ic line 147 2018-03-28 6:31:34 8140 [Note] InnoDB: A semaphore wait: --Thread 6196 has waited at row0ins.cc line 2944 for 282.00 seconds the semaphore: S-lock on RW-latch at 042B771C created in file buf0buf.cc line 1471 a writer (thread id 6356) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file row0ins.cc line 2944 Last time write locked in file mtr0mtr.ic line 147 2018-03-28 6:31:34 8140 [Note] InnoDB: A semaphore wait: --Thread 8144 has waited at ibuf0ibuf.cc line 4921 for 45.00 seconds the semaphore: Mutex at 01F93E20, Mutex IBUF created ibuf0ibuf.cc:516, lock var 2 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending reads 0, writes 0 InnoDB: ###### Diagnostic info printed to the standard error stream 2018-03-28 6:42:05 576 [Warning] option 'innodb-autoextend-increment': unsigned value 67108864 adjusted to 1000 2018-03-28 6:42:05 576 [Warning] InnoDB: Using innodb_file_format is deprecated and the parameter may be removed in future releases. See http://dev.mysql.com/doc/refman/5.7/en/innodb-file-format.html 2018-03-28 6:42:05 576 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2018-03-28 6:42:05 576 [Note] InnoDB: Uses event mutexes 2018-03-28 6:42:05 576 [Note] InnoDB: Compressed tables use zlib 1.2.3 2018-03-28 6:42:05 576 [Note] InnoDB: Adjusting innodb_buffer_pool_instances from 8 to 1 since innodb_buffer_pool_size is less than 1024 MiB 2018-03-28 6:42:05 576 [Note] InnoDB: Number of pools: 1 2018-03-28 6:42:05 576 [Note] InnoDB: Using SSE2 crc32 instructions 2018-03-28 6:42:05 576 [Note] InnoDB: Initializing buffer pool, total size = 256M, instances = 1, chunk size = 128M 2018-03-28 6:42:05 576 [Note] InnoDB: Completed initialization of buffer pool 2018-03-28 6:42:05 576 [Note] InnoDB: Highest supported file format is Barracuda. 2018-03-28 6:42:05 576 [Note] InnoDB: Starting crash recovery from checkpoint LSN=63060628696 2018-03-28 6:42:12 576 [Note] InnoDB: Transaction 137848744 was in the XA prepared state. 2018-03-28 6:42:12 576 [Note] InnoDB: 7 transaction(s) which must be rolled back or cleaned up in total 6 row operations to undo 2018-03-28 6:42:12 576 [Note] InnoDB: Trx id counter is 137849088 2018-03-28 6:42:12 576 [Note] InnoDB: Starting final batch to recover 2175 pages from redo log. 2018-03-28 6:42:17 576 [Note] InnoDB: Last binlog file 'd:\MariaDB\master\logbin\Master-bin.000299', position 877543 2018-03-28 6:42:21 576 [Note] InnoDB: 128 out of 128 rollback segments are active. 2018-03-28 6:42:21 2844 [Note] InnoDB: Starting in background the rollback of recovered transactions 2018-03-28 6:42:21 2844 [Note] InnoDB: Rolling back trx with id 137848507, 1 rows to undo 2018-03-28 6:42:21 576 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2018-03-28 6:42:21 576 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-03-28 6:42:21 576 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2018-03-28 6:42:21 576 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB. 2018-03-28 6:42:21 2844 [Note] InnoDB: Rollback of trx with id 137848507 completed 2018-03-28 6:42:21 2844 [Note] InnoDB: Rolling back trx with id 137848490, 1 rows to undo 2018-03-28 6:42:21 2844 [Note] InnoDB: Rollback of trx with id 137848490 completed 2018-03-28 6:42:21 2844 [Note] InnoDB: Rolling back trx with id 137848235, 1 rows to undo 2018-03-28 6:42:21 576 [Note] InnoDB: Waiting for purge to start 2018-03-28 6:42:21 2844 [Note] InnoDB: Rollback of trx with id 137848235 completed 2018-03-28 6:42:21 2844 [Note] InnoDB: Rolling back trx with id 137848179, 1 rows to undo 2018-03-28 6:42:21 2844 [Note] InnoDB: Rollback of trx with id 137848179 completed 2018-03-28 6:42:21 2844 [Note] InnoDB: Rolling back trx with id 137848152, 1 rows to undo 2018-03-28 6:42:21 2844 [Note] InnoDB: Rollback of trx with id 137848152 completed 2018-03-28 6:42:21 2844 [Note] InnoDB: Rolling back trx with id 137847945, 1 rows to undo 2018-03-28 6:42:21 2844 [Note] InnoDB: Rollback of trx with id 137847945 completed 2018-03-28 6:42:21 2844 [Note] InnoDB: Rollback of non-prepared transactions completed 2018-03-28 6:42:21 576 [Note] InnoDB: 5.7.20 started; log sequence number 63082646708 2018-03-28 6:42:21 2888 [Note] InnoDB: Loading buffer pool(s) from D:\MariaDB\data\ib_buffer_pool 2018-03-28 6:42:22 576 [Note] Plugin 'FEEDBACK' is disabled. 2018-03-28 6:42:22 576 [Note] Recovering after a crash using d:/MariaDB/master/logbin/Master-bin 2018-03-28 6:42:22 576 [Note] Starting crash recovery... 2018-03-28 6:42:22 576 [Note] InnoDB: Starting recovery for XA transactions... 2018-03-28 6:42:22 576 [Note] InnoDB: Transaction 137848744 in prepared state after recovery 2018-03-28 6:42:22 576 [Note] InnoDB: Transaction contains changes to 1 rows 2018-03-28 6:42:22 576 [Note] InnoDB: 1 transactions in prepared state after recovery 2018-03-28 6:42:22 576 [Note] Found 1 prepared transaction(s) in InnoDB 2018-03-28 6:42:22 576 [Note] Crash recovery finished. 2018-03-28 6:42:22 576 [Note] Server socket created on IP: '::'. 2018-03-28 6:42:22 576 [Warning] 'user' entry 'root@jpdpt3' ignored in --skip-name-resolve mode. 2018-03-28 6:42:22 576 [Warning] 'proxies_priv' entry '@% root@jpdpt3' ignored in --skip-name-resolve mode. 2018-03-28 6:42:22 576 [Note] Reading of all Master_info entries succeded 2018-03-28 6:42:22 576 [Note] Added new Master_info '' to hash table 2018-03-28 6:42:22 576 [Note] D:\mariadb\bin\mysqld.exe: ready for connections. Version: '10.2.11-MariaDB-log' socket: '' port: 3309 mariadb.org binary distribution 2018-03-28 6:42:28 2888 [Note] InnoDB: Buffer pool(s) load completed at 180328 6:42:28 2018-03-28 6:46:23 2852 [Warning] InnoDB: A long semaphore wait: --Thread 644 has waited at ibuf0ibuf.cc line 4578 for 241.00 seconds the semaphore: S-lock on RW-latch at 037FB2A4 created in file buf0buf.cc line 1471 a writer (thread id 580) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file ibuf0ibuf.cc line 4578 Last time write locked in file mtr0mtr.ic line 147 2018-03-28 6:46:23 2852 [Warning] InnoDB: A long semaphore wait: --Thread 960 has waited at ibuf0ibuf.cc line 4578 for 241.00 seconds the semaphore: S-lock on RW-latch at 037FB2A4 created in file buf0buf.cc line 1471 a writer (thread id 580) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file ibuf0ibuf.cc line 4578 Last time write locked in file mtr0mtr.ic line 147 2018-03-28 6:46:23 2852 [Warning] InnoDB: A long semaphore wait: --Thread 580 has waited at buf0buf.cc line 4136 for 241.00 seconds the semaphore: S-lock on RW-latch at 0378D174 created in file buf0buf.cc line 1471 a writer (thread id 0) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file not yet reserved line 0 Last time write locked in file buf0buf.cc line 5363 2018-03-28 6:46:23 2852 [Note] InnoDB: A semaphore wait: --Thread 644 has waited at ibuf0ibuf.cc line 4578 for 241.00 seconds the semaphore: S-lock on RW-latch at 037FB2A4 created in file buf0buf.cc line 1471 a writer (thread id 580) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file ibuf0ibuf.cc line 4578 Last time write locked in file mtr0mtr.ic line 147 2018-03-28 6:46:23 2852 [Note] InnoDB: A semaphore wait: --Thread 472 has waited at ibuf0ibuf.cc line 4578 for 240.00 seconds the semaphore: S-lock on RW-latch at 037FB2A4 created in file buf0buf.cc line 1471 a writer (thread id 580) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file ibuf0ibuf.cc line 4578 Last time write locked in file mtr0mtr.ic line 147 2018-03-28 6:46:23 2852 [Note] InnoDB: A semaphore wait: --Thread 960 has waited at ibuf0ibuf.cc line 4578 for 241.00 seconds the semaphore: S-lock on RW-latch at 037FB2A4 created in file buf0buf.cc line 1471 a writer (thread id 580) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file ibuf0ibuf.cc line 4578 Last time write locked in file mtr0mtr.ic line 147 2018-03-28 6:46:23 2852 [Note] InnoDB: A semaphore wait: --Thread 580 has waited at buf0buf.cc line 4136 for 241.00 seconds the semaphore: S-lock on RW-latch at 0378D174 created in file buf0buf.cc line 1471 a writer (thread id 0) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file not yet reserved line 0 Last time write locked in file buf0buf.cc line 5363 2018-03-28 6:46:23 2852 [Note] InnoDB: A semaphore wait: --Thread 2860 has waited at ibuf0ibuf.cc line 2532 for 240.00 seconds the semaphore: S-lock on RW-latch at 037FB2A4 created in file buf0buf.cc line 1471 a writer (thread id 580) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file ibuf0ibuf.cc line 4578 Last time write locked in file mtr0mtr.ic line 147 2018-03-28 6:46:23 2852 [Note] InnoDB: A semaphore wait: --Thread 2060 has waited at buf0flu.cc line 1246 for 236.00 seconds the semaphore: SX-lock on RW-latch at 037FB2A4 created in file buf0buf.cc line 1471 a writer (thread id 580) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file ibuf0ibuf.cc line 4578 Last time write locked in file mtr0mtr.ic line 147 2018-03-28 6:46:23 2852 [Note] InnoDB: A semaphore wait: --Thread 4632 has waited at buf0buf.cc line 4136 for 107.00 seconds the semaphore: S-lock on RW-latch at 0390F614 created in file buf0buf.cc line 1471 a writer (thread id 0) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file not yet reserved line 0 Last time write locked in file buf0buf.cc line 5363 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending reads 0, writes 0 ===================================== 2018-03-28 06:46:36 0xb28 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 72 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 1 srv_active, 0 srv_shutdown, 1 srv_idle srv_master_thread log flush and writes: 1 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 62 --Thread 644 has waited at ibuf0ibuf.cc line 4578 for 254.00 seconds the semaphore: S-lock on RW-latch at 037FB2A4 created in file buf0buf.cc line 1471 a writer (thread id 580) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file ibuf0ibuf.cc line 4578 Last time write locked in file mtr0mtr.ic line 147 --Thread 472 has waited at ibuf0ibuf.cc line 4578 for 253.00 seconds the semaphore: S-lock on RW-latch at 037FB2A4 created in file buf0buf.cc line 1471 a writer (thread id 580) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file ibuf0ibuf.cc line 4578 Last time write locked in file mtr0mtr.ic line 147 --Thread 960 has waited at ibuf0ibuf.cc line 4578 for 254.00 seconds the semaphore: S-lock on RW-latch at 037FB2A4 created in file buf0buf.cc line 1471 a writer (thread id 580) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file ibuf0ibuf.cc line 4578 Last time write locked in file mtr0mtr.ic line 147 --Thread 580 has waited at buf0buf.cc line 4136 for 254.00 seconds the semaphore: S-lock on RW-latch at 0378D174 created in file buf0buf.cc line 1471 a writer (thread id 0) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file not yet reserved line 0 Last time write locked in file buf0buf.cc line 5363 --Thread 2860 has waited at ibuf0ibuf.cc line 2532 for 253.00 seconds the semaphore: S-lock on RW-latch at 037FB2A4 created in file buf0buf.cc line 1471 a writer (thread id 580) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file ibuf0ibuf.cc line 4578 Last time write locked in file mtr0mtr.ic line 147 --Thread 2060 has waited at buf0flu.cc line 1246 for 249.00 seconds the semaphore: SX-lock on RW-latch at 037FB2A4 created in file buf0buf.cc line 1471 a writer (thread id 580) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file ibuf0ibuf.cc line 4578 Last time write locked in file mtr0mtr.ic line 147 --Thread 4632 has waited at buf0buf.cc line 4136 for 120.00 seconds the semaphore: S-lock on RW-latch at 0390F614 created in file buf0buf.cc line 1471 a writer (thread id 0) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file not yet reserved line 0 Last time write locked in file buf0buf.cc line 5363 OS WAIT ARRAY INFO: signal count 35 RW-shared spins 0, rounds 47, OS waits 21 RW-excl spins 0, rounds 203, OS waits 6 RW-sx spins 1, rounds 30, OS waits 1 Spin rounds per wait: 47.00 RW-shared, 203.00 RW-excl, 30.00 RW-sx ------------ TRANSACTIONS ------------ Trx id counter 137849104 Purge done for trx's n:o < 0 undo n:o < 0 state: running but idle History list length 0 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 281475030582408, not started 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 137849103, ACTIVE 121 sec updating or deleting, thread declared inside InnoDB 4999 mysql tables in use 5, locked 5 2 lock struct(s), heap size 1080, 1 row lock(s) MySQL thread id 9, OS thread handle 0, query id 4632 127.0.0.1 liverjis updating update users set last_login_date_time=curdate() -------- FILE I/O -------- I/O thread 0 state: complete io for buf page (insert buffer thread) I/O thread 1 state: complete io for buf page (log thread) I/O thread 2 state: complete io for buf page (read thread) I/O thread 3 state: complete io for buf page (read thread) I/O thread 4 state: native aio handle (read thread) I/O thread 5 state: native aio handle (read thread) I/O thread 6 state: native aio handle (write thread) I/O thread 7 state: native aio handle (write thread) I/O thread 8 state: native aio handle (write thread) I/O thread 9 state: native aio handle (write thread) Pending normal aio reads: [1, 2, 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 8032 OS file reads, 748 OS file writes, 48 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- InnoDB: ###### Diagnostic info printed to the standard error stream 2018-03-28 6:46:54 2852 [Warning] InnoDB: A long semaphore wait: --Thread 644 has waited at ibuf0ibuf.cc line 4578 for 272.00 seconds the semaphore: S-lock on RW-latch at 037FB2A4 created in file buf0buf.cc line 1471 a writer (thread id 580) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file ibuf0ibuf.cc line 4578 Last time write locked in file mtr0mtr.ic line 147 2018-03-28 6:46:54 2852 [Warning] InnoDB: A long semaphore wait: --Thread 472 has waited at ibuf0ibuf.cc line 4578 for 271.00 seconds the semaphore: S-lock on RW-latch at 037FB2A4 created in file buf0buf.cc line 1471 a writer (thread id 580) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file ibuf0ibuf.cc line 4578 Last time write locked in file mtr0mtr.ic line 147 2018-03-28 6:46:54 2852 [Warning] InnoDB: A long semaphore wait: --Thread 960 has waited at ibuf0ibuf.cc line 4578 for 272.00 seconds the semaphore: S-lock on RW-latch at 037FB2A4 created in file buf0buf.cc line 1471 a writer (thread id 580) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file ibuf0ibuf.cc line 4578 Last time write locked in file mtr0mtr.ic line 147 2018-03-28 6:46:54 2852 [Warning] InnoDB: A long semaphore wait: --Thread 580 has waited at buf0buf.cc line 4136 for 272.00 seconds the semaphore: S-lock on RW-latch at 0378D174 created in file buf0buf.cc line 1471 a writer (thread id 0) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file not yet reserved line 0 Last time write locked in file buf0buf.cc line 5363 2018-03-28 6:46:54 2852 [Warning] InnoDB: A long semaphore wait: --Thread 2860 has waited at ibuf0ibuf.cc line 2532 for 271.00 seconds the semaphore: S-lock on RW-latch at 037FB2A4 created in file buf0buf.cc line 1471 a writer (thread id 580) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file ibuf0ibuf.cc line 4578 Last time write locked in file mtr0mtr.ic line 147 2018-03-28 6:46:54 2852 [Warning] InnoDB: A long semaphore wait: --Thread 2060 has waited at buf0flu.cc line 1246 for 267.00 seconds the semaphore: SX-lock on RW-latch at 037FB2A4 created in file buf0buf.cc line 1471 a writer (thread id 580) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file ibuf0ibuf.cc line 4578 Last time write locked in file mtr0mtr.ic line 147 2018-03-28 6:46:54 2852 [Note] InnoDB: A semaphore wait: --Thread 644 has waited at ibuf0ibuf.cc line 4578 for 272.00 seconds the semaphore: S-lock on RW-latch at 037FB2A4 created in file buf0buf.cc line 1471 a writer (thread id 580) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file ibuf0ibuf.cc line 4578 Last time write locked in file mtr0mtr.ic line 147 2018-03-28 6:46:54 2852 [Note] InnoDB: A semaphore wait: --Thread 472 has waited at ibuf0ibuf.cc line 4578 for 271.00 seconds the semaphore: S-lock on RW-latch at 037FB2A4 created in file buf0buf.cc line 1471 a writer (thread id 580) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file ibuf0ibuf.cc line 4578 Last time write locked in file mtr0mtr.ic line 147 2018-03-28 6:46:54 2852 [Note] InnoDB: A semaphore wait: --Thread 960 has waited at ibuf0ibuf.cc line 4578 for 272.00 seconds the semaphore: S-lock on RW-latch at 037FB2A4 created in file buf0buf.cc line 1471 a writer (thread id 580) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file ibuf0ibuf.cc line 4578 Last time write locked in file mtr0mtr.ic line 147 2018-03-28 6:46:54 2852 [Note] InnoDB: A semaphore wait: --Thread 580 has waited at buf0buf.cc line 4136 for 272.00 seconds the semaphore: S-lock on RW-latch at 0378D174 created in file buf0buf.cc line 1471 a writer (thread id 0) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file not yet reserved line 0 Last time write locked in file buf0buf.cc line 5363 2018-03-28 6:46:54 2852 [Note] InnoDB: A semaphore wait: --Thread 2860 has waited at ibuf0ibuf.cc line 2532 for 271.00 seconds the semaphore: S-lock on RW-latch at 037FB2A4 created in file buf0buf.cc line 1471 a writer (thread id 580) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file ibuf0ibuf.cc line 4578 Last time write locked in file mtr0mtr.ic line 147 2018-03-28 6:46:54 2852 [Note] InnoDB: A semaphore wait: --Thread 2060 has waited at buf0flu.cc line 1246 for 267.00 seconds the semaphore: SX-lock on RW-latch at 037FB2A4 created in file buf0buf.cc line 1471 a writer (thread id 580) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file ibuf0ibuf.cc line 4578 Last time write locked in file mtr0mtr.ic line 147 2018-03-28 6:46:54 2852 [Note] InnoDB: A semaphore wait: --Thread 4632 has waited at buf0buf.cc line 4136 for 138.00 seconds the semaphore: S-lock on RW-latch at 0390F614 created in file buf0buf.cc line 1471 a writer (thread id 0) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file not yet reserved line 0 Last time write locked in file buf0buf.cc line 5363 2018-03-28 6:46:54 2852 [Note] InnoDB: A semaphore wait: --Thread 2856 has waited at ibuf0ibuf.cc line 4921 for 18.00 seconds the semaphore: Mutex at 01953E20, Mutex IBUF created ibuf0ibuf.cc:516, lock var 2 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending reads 0, writes 0 2018-03-28 6:47:17 2920 [Note] D:\mariadb\bin\mysqld.exe (unknown): Normal shutdown 2018-03-28 6:47:17 2920 [Note] Event Scheduler: Purging the queue. 0 events 2018-03-28 6:47:17 2868 [Note] InnoDB: FTS optimize thread exiting. InnoDB: ###### Diagnostic info printed to the standard error stream 2018-03-28 6:47:25 2852 [Warning] InnoDB: A long semaphore wait: --Thread 644 has waited at ibuf0ibuf.cc line 4578 for 303.00 seconds the semaphore: S-lock on RW-latch at 037FB2A4 created in file buf0buf.cc line 1471 a writer (thread id 580) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file ibuf0ibuf.cc line 4578 Last time write locked in file mtr0mtr.ic line 147 2018-03-28 6:47:25 2852 [Warning] InnoDB: A long semaphore wait: --Thread 472 has waited at ibuf0ibuf.cc line 4578 for 302.00 seconds the semaphore: S-lock on RW-latch at 037FB2A4 created in file buf0buf.cc line 1471 a writer (thread id 580) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file ibuf0ibuf.cc line 4578 Last time write locked in file mtr0mtr.ic line 147 2018-03-28 6:47:25 2852 [Warning] InnoDB: A long semaphore wait: --Thread 960 has waited at ibuf0ibuf.cc line 4578 for 303.00 seconds the semaphore: S-lock on RW-latch at 037FB2A4 created in file buf0buf.cc line 1471 a writer (thread id 580) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file ibuf0ibuf.cc line 4578 Last time write locked in file mtr0mtr.ic line 147 2018-03-28 6:47:25 2852 [Warning] InnoDB: A long semaphore wait: --Thread 580 has waited at buf0buf.cc line 4136 for 303.00 seconds the semaphore: S-lock on RW-latch at 0378D174 created in file buf0buf.cc line 1471 a writer (thread id 0) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file not yet reserved line 0 Last time write locked in file buf0buf.cc line 5363 2018-03-28 6:47:25 2852 [Warning] InnoDB: A long semaphore wait: --Thread 2860 has waited at ibuf0ibuf.cc line 2532 for 302.00 seconds the semaphore: S-lock on RW-latch at 037FB2A4 created in file buf0buf.cc line 1471 a writer (thread id 580) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file ibuf0ibuf.cc line 4578 Last time write locked in file mtr0mtr.ic line 147 2018-03-28 6:47:25 2852 [Warning] InnoDB: A long semaphore wait: --Thread 2060 has waited at buf0flu.cc line 1246 for 298.00 seconds the semaphore: SX-lock on RW-latch at 037FB2A4 created in file buf0buf.cc line 1471 a writer (thread id 580) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file ibuf0ibuf.cc line 4578 Last time write locked in file mtr0mtr.ic line 147 2018-03-28 6:47:25 2852 [Note] InnoDB: A semaphore wait: --Thread 644 has waited at ibuf0ibuf.cc line 4578 for 303.00 seconds the semaphore: S-lock on RW-latch at 037FB2A4 created in file buf0buf.cc line 1471 a writer (thread id 580) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file ibuf0ibuf.cc line 4578 Last time write locked in file mtr0mtr.ic line 147 2018-03-28 6:47:25 2852 [Note] InnoDB: A semaphore wait: --Thread 472 has waited at ibuf0ibuf.cc line 4578 for 302.00 seconds the semaphore: S-lock on RW-latch at 037FB2A4 created in file buf0buf.cc line 1471 a writer (thread id 580) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file ibuf0ibuf.cc line 4578 Last time write locked in file mtr0mtr.ic line 147 2018-03-28 6:47:25 2852 [Note] InnoDB: A semaphore wait: --Thread 960 has waited at ibuf0ibuf.cc line 4578 for 303.00 seconds the semaphore: S-lock on RW-latch at 037FB2A4 created in file buf0buf.cc line 1471 a writer (thread id 580) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file ibuf0ibuf.cc line 4578 Last time write locked in file mtr0mtr.ic line 147 2018-03-28 6:47:25 2852 [Note] InnoDB: A semaphore wait: --Thread 580 has waited at buf0buf.cc line 4136 for 303.00 seconds the semaphore: S-lock on RW-latch at 0378D174 created in file buf0buf.cc line 1471 a writer (thread id 0) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file not yet reserved line 0 Last time write locked in file buf0buf.cc line 5363 2018-03-28 6:47:25 2852 [Note] InnoDB: A semaphore wait: --Thread 2860 has waited at ibuf0ibuf.cc line 2532 for 302.00 seconds the semaphore: S-lock on RW-latch at 037FB2A4 created in file buf0buf.cc line 1471 a writer (thread id 580) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file ibuf0ibuf.cc line 4578 Last time write locked in file mtr0mtr.ic line 147 2018-03-28 6:47:25 2852 [Note] InnoDB: A semaphore wait: --Thread 2060 has waited at buf0flu.cc line 1246 for 298.00 seconds the semaphore: SX-lock on RW-latch at 037FB2A4 created in file buf0buf.cc line 1471 a writer (thread id 580) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file ibuf0ibuf.cc line 4578 Last time write locked in file mtr0mtr.ic line 147 2018-03-28 6:47:25 2852 [Note] InnoDB: A semaphore wait: --Thread 4632 has waited at buf0buf.cc line 4136 for 169.00 seconds the semaphore: S-lock on RW-latch at 0390F614 created in file buf0buf.cc line 1471 a writer (thread id 0) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file not yet reserved line 0 Last time write locked in file buf0buf.cc line 5363 2018-03-28 6:47:25 2852 [Note] InnoDB: A semaphore wait: --Thread 2856 has waited at ibuf0ibuf.cc line 4921 for 49.00 seconds the semaphore: Mutex at 01953E20, Mutex IBUF created ibuf0ibuf.cc:516, lock var 2 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending reads 0, writes 0 2018-03-28 6:47:49 2920 [Warning] D:\mariadb\bin\mysqld.exe: Forcing close of thread 9 user: 'liverjis' 2018-03-28 6:47:49 2920 [ERROR] mysqld.exe: Got an error writing communication packets InnoDB: ###### Diagnostic info printed to the standard error stream 2018-03-28 6:49:10 5140 [Warning] option 'innodb-autoextend-increment': unsigned value 67108864 adjusted to 1000 2018-03-28 6:49:10 5140 [Warning] InnoDB: Using innodb_file_format is deprecated and the parameter may be removed in future releases. See http://dev.mysql.com/doc/refman/5.7/en/innodb-file-format.html 2018-03-28 6:49:10 5140 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2018-03-28 6:49:10 5140 [Note] InnoDB: Uses event mutexes 2018-03-28 6:49:10 5140 [Note] InnoDB: Compressed tables use zlib 1.2.3 2018-03-28 6:49:10 5140 [Note] InnoDB: Adjusting innodb_buffer_pool_instances from 8 to 1 since innodb_buffer_pool_size is less than 1024 MiB 2018-03-28 6:49:10 5140 [Note] InnoDB: Number of pools: 1 2018-03-28 6:49:10 5140 [Note] InnoDB: Using SSE2 crc32 instructions 2018-03-28 6:49:10 5140 [Note] InnoDB: Initializing buffer pool, total size = 256M, instances = 1, chunk size = 128M 2018-03-28 6:49:10 5140 [Note] InnoDB: Completed initialization of buffer pool 2018-03-28 6:49:10 5140 [Note] InnoDB: Highest supported file format is Barracuda. 2018-03-28 6:49:10 5140 [Note] InnoDB: Starting crash recovery from checkpoint LSN=63060628696 2018-03-28 6:49:17 5140 [Note] InnoDB: Starting final batch to recover 2187 pages from redo log. 2018-03-28 6:49:22 5140 [Note] InnoDB: Last binlog file 'd:\MariaDB\master\logbin\Master-bin.000299', position 877543 2018-03-28 6:49:25 5140 [Note] InnoDB: 128 out of 128 rollback segments are active. 2018-03-28 6:49:25 5140 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2018-03-28 6:49:25 5140 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-03-28 6:49:25 5140 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2018-03-28 6:49:25 5140 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB. 2018-03-28 6:49:25 5140 [Note] InnoDB: 5.7.20 started; log sequence number 63082677933 2018-03-28 6:49:25 5256 [Note] InnoDB: Loading buffer pool(s) from D:\MariaDB\data\ib_buffer_pool 2018-03-28 6:49:25 5140 [Note] Plugin 'FEEDBACK' is disabled. 2018-03-28 6:49:25 5140 [Note] Recovering after a crash using d:/MariaDB/master/logbin/Master-bin 2018-03-28 6:49:25 5140 [Note] Starting crash recovery... 2018-03-28 6:49:25 5140 [Note] Crash recovery finished. 2018-03-28 6:49:25 5140 [Note] Server socket created on IP: '::'. 2018-03-28 6:49:25 5140 [Warning] 'user' entry 'root@jpdpt3' ignored in --skip-name-resolve mode. 2018-03-28 6:49:25 5140 [Warning] 'proxies_priv' entry '@% root@jpdpt3' ignored in --skip-name-resolve mode. 2018-03-28 6:49:25 5140 [Note] Reading of all Master_info entries succeded 2018-03-28 6:49:25 5140 [Note] Added new Master_info '' to hash table 2018-03-28 6:49:25 5140 [Note] D:\mariadb\bin\mysqld.exe: ready for connections. Version: '10.2.11-MariaDB-log' socket: '' port: 3309 mariadb.org binary distribution 2018-03-28 6:49:32 5256 [Note] InnoDB: Buffer pool(s) load completed at 180328 6:49:32 2018-03-28 6:53:28 5220 [Warning] InnoDB: A long semaphore wait: --Thread 5156 has waited at buf0buf.cc line 4136 for 241.00 seconds the semaphore: S-lock on RW-latch at 0372DFBC created in file buf0buf.cc line 1471 a writer (thread id 0) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file not yet reserved line 0 Last time write locked in file buf0buf.cc line 5363 2018-03-28 6:53:28 5220 [Warning] InnoDB: A long semaphore wait: --Thread 5148 has waited at ibuf0ibuf.cc line 4394 for 241.00 seconds the semaphore: Mutex at 01953E20, Mutex IBUF created ibuf0ibuf.cc:516, lock var 2 2018-03-28 6:53:28 5220 [Warning] InnoDB: A long semaphore wait: --Thread 5160 has waited at ibuf0ibuf.cc line 4394 for 241.00 seconds the semaphore: Mutex at 01953E20, Mutex IBUF created ibuf0ibuf.cc:516, lock var 2 2018-03-28 6:53:28 5220 [Warning] InnoDB: A long semaphore wait: --Thread 5152 has waited at ibuf0ibuf.cc line 4394 for 241.00 seconds the semaphore: Mutex at 01953E20, Mutex IBUF created ibuf0ibuf.cc:516, lock var 2 2018-03-28 6:53:28 5220 [Warning] InnoDB: A long semaphore wait: --Thread 5228 has waited at ibuf0ibuf.cc line 2532 for 241.00 seconds the semaphore: S-lock on RW-latch at 0378B77C created in file buf0buf.cc line 1471 a writer (thread id 5156) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file ibuf0ibuf.cc line 4578 Last time write locked in file mtr0mtr.ic line 147 2018-03-28 6:53:28 5220 [Warning] InnoDB: A long semaphore wait: --Thread 5188 has waited at buf0flu.cc line 1246 for 241.00 seconds the semaphore: SX-lock on RW-latch at 0378B77C created in file buf0buf.cc line 1471 a writer (thread id 5156) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file ibuf0ibuf.cc line 4578 Last time write locked in file mtr0mtr.ic line 147 2018-03-28 6:53:28 5220 [Note] InnoDB: A semaphore wait: --Thread 5156 has waited at buf0buf.cc line 4136 for 241.00 seconds the semaphore: S-lock on RW-latch at 0372DFBC created in file buf0buf.cc line 1471 a writer (thread id 0) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file not yet reserved line 0 Last time write locked in file buf0buf.cc line 5363 2018-03-28 6:53:28 5220 [Note] InnoDB: A semaphore wait: --Thread 5148 has waited at ibuf0ibuf.cc line 4394 for 241.00 seconds the semaphore: Mutex at 01953E20, Mutex IBUF created ibuf0ibuf.cc:516, lock var 2 2018-03-28 6:53:28 5220 [Note] InnoDB: A semaphore wait: --Thread 5160 has waited at ibuf0ibuf.cc line 4394 for 241.00 seconds the semaphore: Mutex at 01953E20, Mutex IBUF created ibuf0ibuf.cc:516, lock var 2 2018-03-28 6:53:28 5220 [Note] InnoDB: A semaphore wait: --Thread 5152 has waited at ibuf0ibuf.cc line 4394 for 241.00 seconds the semaphore: Mutex at 01953E20, Mutex IBUF created ibuf0ibuf.cc:516, lock var 2 2018-03-28 6:53:28 5220 [Note] InnoDB: A semaphore wait: --Thread 5228 has waited at ibuf0ibuf.cc line 2532 for 241.00 seconds the semaphore: S-lock on RW-latch at 0378B77C created in file buf0buf.cc line 1471 a writer (thread id 5156) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file ibuf0ibuf.cc line 4578 Last time write locked in file mtr0mtr.ic line 147 2018-03-28 6:53:28 5220 [Note] InnoDB: A semaphore wait: --Thread 5188 has waited at buf0flu.cc line 1246 for 241.00 seconds the semaphore: SX-lock on RW-latch at 0378B77C created in file buf0buf.cc line 1471 a writer (thread id 5156) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file ibuf0ibuf.cc line 4578 Last time write locked in file mtr0mtr.ic line 147 2018-03-28 6:53:28 5220 [Note] InnoDB: A semaphore wait: --Thread 5248 has waited at row0purge.cc line 852 for 198.00 seconds the semaphore: S-lock on RW-latch at 0045C920 created in file dict0dict.cc line 1107 a writer (thread id 5372) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file not yet reserved line 0 Last time write locked in file row0mysql.cc line 3593 2018-03-28 6:53:28 5220 [Note] InnoDB: A semaphore wait: --Thread 5372 has waited at ibuf0ibuf.cc line 3460 for 198.00 seconds the semaphore: S-lock on RW-latch at 0378B77C created in file buf0buf.cc line 1471 a writer (thread id 5156) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file ibuf0ibuf.cc line 4578 Last time write locked in file mtr0mtr.ic line 147 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending reads 0, writes 0 ===================================== 2018-03-28 06:53:41 0x1468 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 73 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 0 srv_active, 0 srv_shutdown, 1 srv_idle srv_master_thread log flush and writes: 0 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 57 --Thread 5156 has waited at buf0buf.cc line 4136 for 254.00 seconds the semaphore: S-lock on RW-latch at 0372DFBC created in file buf0buf.cc line 1471 a writer (thread id 0) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file not yet reserved line 0 Last time write locked in file buf0buf.cc line 5363 --Thread 5148 has waited at ibuf0ibuf.cc line 4394 for 254.00 seconds the semaphore: Mutex at 01953E20, Mutex IBUF created ibuf0ibuf.cc:516, lock var 2 --Thread 5160 has waited at ibuf0ibuf.cc line 4394 for 254.00 seconds the semaphore: Mutex at 01953E20, Mutex IBUF created ibuf0ibuf.cc:516, lock var 2 --Thread 5152 has waited at ibuf0ibuf.cc line 4394 for 254.00 seconds the semaphore: Mutex at 01953E20, Mutex IBUF created ibuf0ibuf.cc:516, lock var 2 --Thread 5228 has waited at ibuf0ibuf.cc line 2532 for 254.00 seconds the semaphore: S-lock on RW-latch at 0378B77C created in file buf0buf.cc line 1471 a writer (thread id 5156) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file ibuf0ibuf.cc line 4578 Last time write locked in file mtr0mtr.ic line 147 --Thread 5188 has waited at buf0flu.cc line 1246 for 254.00 seconds the semaphore: SX-lock on RW-latch at 0378B77C created in file buf0buf.cc line 1471 a writer (thread id 5156) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file ibuf0ibuf.cc line 4578 Last time write locked in file mtr0mtr.ic line 147 --Thread 5248 has waited at row0purge.cc line 852 for 211.00 seconds the semaphore: S-lock on RW-latch at 0045C920 created in file dict0dict.cc line 1107 a writer (thread id 5372) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file not yet reserved line 0 Last time write locked in file row0mysql.cc line 3593 --Thread 5372 has waited at ibuf0ibuf.cc line 3460 for 211.00 seconds the semaphore: S-lock on RW-latch at 0378B77C created in file buf0buf.cc line 1471 a writer (thread id 5156) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file ibuf0ibuf.cc line 4578 Last time write locked in file mtr0mtr.ic line 147 OS WAIT ARRAY INFO: signal count 31 RW-shared spins 0, rounds 47, OS waits 21 RW-excl spins 0, rounds 300, OS waits 10 RW-sx spins 0, rounds 0, OS waits 0 Spin rounds per wait: 47.00 RW-shared, 300.00 RW-excl, 0.00 RW-sx ------------ TRANSACTIONS ------------ Trx id counter 137849608 Purge done for trx's n:o < 137849606 undo n:o < 0 state: running History list length 2 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 281475029075640, not started 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 281475029075080, not started 0 lock struct(s), heap size 1080, 0 row lock(s) ---TRANSACTION 137849603, ACTIVE 211 sec dropping table 14 lock struct(s), heap size 1080, 20 row lock(s), undo log entries 13 MySQL thread id 9, OS thread handle 0, query id 5372 127.0.0.1 root Unlocking tables drop database datafactorydb Trx read view will not see trx with id >= 137849608, sees < 137849608 -------- FILE I/O -------- I/O thread 0 state: complete io for buf page (insert buffer thread) I/O thread 1 state: complete io for buf page (log thread) I/O thread 2 state: complete io for buf page (read thread) I/O thread 3 state: complete io for buf page (read thread) I/O thread 4 state: native aio handle (read thread) I/O thread 5 state: native aio handle (read thread) I/O thread 6 state: native aio handle (write thread) I/O thread 7 state: native aio handle (write thread) I/O thread 8 state: native aio handle (write thread) I/O thread 9 state: native aio handle (write thread) Pending normal aio reads: [65, 16, 11, 28] , 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 8136 OS file reads, 163 OS file writes, 13 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- InnoDB: ###### Diagnostic info printed to the standard error stream 2018-03-28 6:53:59 5220 [Warning] InnoDB: A long semaphore wait: --Thread 5156 has waited at buf0buf.cc line 4136 for 272.00 seconds the semaphore: S-lock on RW-latch at 0372DFBC created in file buf0buf.cc line 1471 a writer (thread id 0) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file not yet reserved line 0 Last time write locked in file buf0buf.cc line 5363 2018-03-28 6:53:59 5220 [Warning] InnoDB: A long semaphore wait: --Thread 5148 has waited at ibuf0ibuf.cc line 4394 for 272.00 seconds the semaphore: Mutex at 01953E20, Mutex IBUF created ibuf0ibuf.cc:516, lock var 2 2018-03-28 6:53:59 5220 [Warning] InnoDB: A long semaphore wait: --Thread 5160 has waited at ibuf0ibuf.cc line 4394 for 272.00 seconds the semaphore: Mutex at 01953E20, Mutex IBUF created ibuf0ibuf.cc:516, lock var 2 2018-03-28 6:53:59 5220 [Warning] InnoDB: A long semaphore wait: --Thread 5152 has waited at ibuf0ibuf.cc line 4394 for 272.00 seconds the semaphore: Mutex at 01953E20, Mutex IBUF created ibuf0ibuf.cc:516, lock var 2 2018-03-28 6:53:59 5220 [Warning] InnoDB: A long semaphore wait: --Thread 5228 has waited at ibuf0ibuf.cc line 2532 for 272.00 seconds the semaphore: S-lock on RW-latch at 0378B77C created in file buf0buf.cc line 1471 a writer (thread id 5156) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file ibuf0ibuf.cc line 4578 Last time write locked in file mtr0mtr.ic line 147 2018-03-28 6:53:59 5220 [Warning] InnoDB: A long semaphore wait: --Thread 5188 has waited at buf0flu.cc line 1246 for 272.00 seconds the semaphore: SX-lock on RW-latch at 0378B77C created in file buf0buf.cc line 1471 a writer (thread id 5156) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file ibuf0ibuf.cc line 4578 Last time write locked in file mtr0mtr.ic line 147 2018-03-28 6:53:59 5220 [Note] InnoDB: A semaphore wait: --Thread 5156 has waited at buf0buf.cc line 4136 for 272.00 seconds the semaphore: S-lock on RW-latch at 0372DFBC created in file buf0buf.cc line 1471 a writer (thread id 0) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file not yet reserved line 0 Last time write locked in file buf0buf.cc line 5363 2018-03-28 6:53:59 5220 [Note] InnoDB: A semaphore wait: --Thread 5148 has waited at ibuf0ibuf.cc line 4394 for 272.00 seconds the semaphore: Mutex at 01953E20, Mutex IBUF created ibuf0ibuf.cc:516, lock var 2 2018-03-28 6:53:59 5220 [Note] InnoDB: A semaphore wait: --Thread 5160 has waited at ibuf0ibuf.cc line 4394 for 272.00 seconds the semaphore: Mutex at 01953E20, Mutex IBUF created ibuf0ibuf.cc:516, lock var 2 2018-03-28 6:53:59 5220 [Note] InnoDB: A semaphore wait: --Thread 5152 has waited at ibuf0ibuf.cc line 4394 for 272.00 seconds the semaphore: Mutex at 01953E20, Mutex IBUF created ibuf0ibuf.cc:516, lock var 2 2018-03-28 6:53:59 5220 [Note] InnoDB: A semaphore wait: --Thread 5228 has waited at ibuf0ibuf.cc line 2532 for 272.00 seconds the semaphore: S-lock on RW-latch at 0378B77C created in file buf0buf.cc line 1471 a writer (thread id 5156) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file ibuf0ibuf.cc line 4578 Last time write locked in file mtr0mtr.ic line 147 2018-03-28 6:53:59 5220 [Note] InnoDB: A semaphore wait: --Thread 5188 has waited at buf0flu.cc line 1246 for 272.00 seconds the semaphore: SX-lock on RW-latch at 0378B77C created in file buf0buf.cc line 1471 a writer (thread id 5156) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file ibuf0ibuf.cc line 4578 Last time write locked in file mtr0mtr.ic line 147 2018-03-28 6:53:59 5220 [Note] InnoDB: A semaphore wait: --Thread 5248 has waited at row0purge.cc line 852 for 229.00 seconds the semaphore: S-lock on RW-latch at 0045C920 created in file dict0dict.cc line 1107 a writer (thread id 5372) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file not yet reserved line 0 Last time write locked in file row0mysql.cc line 3593 2018-03-28 6:53:59 5220 [Note] InnoDB: A semaphore wait: --Thread 5372 has waited at ibuf0ibuf.cc line 3460 for 229.00 seconds the semaphore: S-lock on RW-latch at 0378B77C created in file buf0buf.cc line 1471 a writer (thread id 5156) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file ibuf0ibuf.cc line 4578 Last time write locked in file mtr0mtr.ic line 147 2018-03-28 6:53:59 5220 [Note] InnoDB: A semaphore wait: --Thread 5224 has waited at ibuf0ibuf.cc line 4921 for 18.00 seconds the semaphore: Mutex at 01953E20, Mutex IBUF created ibuf0ibuf.cc:516, lock var 2 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending reads 0, writes 0 InnoDB: ###### Diagnostic info printed to the standard error stream 2018-03-28 6:54:30 5220 [Warning] InnoDB: A long semaphore wait: --Thread 5156 has waited at buf0buf.cc line 4136 for 303.00 seconds the semaphore: S-lock on RW-latch at 0372DFBC created in file buf0buf.cc line 1471 a writer (thread id 0) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file not yet reserved line 0 Last time write locked in file buf0buf.cc line 5363 2018-03-28 6:54:30 5220 [Warning] InnoDB: A long semaphore wait: --Thread 5148 has waited at ibuf0ibuf.cc line 4394 for 303.00 seconds the semaphore: Mutex at 01953E20, Mutex IBUF created ibuf0ibuf.cc:516, lock var 2 2018-03-28 6:54:30 5220 [Warning] InnoDB: A long semaphore wait: --Thread 5160 has waited at ibuf0ibuf.cc line 4394 for 303.00 seconds the semaphore: Mutex at 01953E20, Mutex IBUF created ibuf0ibuf.cc:516, lock var 2 2018-03-28 6:54:30 5220 [Warning] InnoDB: A long semaphore wait: --Thread 5152 has waited at ibuf0ibuf.cc line 4394 for 303.00 seconds the semaphore: Mutex at 01953E20, Mutex IBUF created ibuf0ibuf.cc:516, lock var 2 2018-03-28 6:54:30 5220 [Warning] InnoDB: A long semaphore wait: --Thread 5228 has waited at ibuf0ibuf.cc line 2532 for 303.00 seconds the semaphore: S-lock on RW-latch at 0378B77C created in file buf0buf.cc line 1471 a writer (thread id 5156) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file ibuf0ibuf.cc line 4578 Last time write locked in file mtr0mtr.ic line 147 2018-03-28 6:54:30 5220 [Warning] InnoDB: A long semaphore wait: --Thread 5188 has waited at buf0flu.cc line 1246 for 303.00 seconds the semaphore: SX-lock on RW-latch at 0378B77C created in file buf0buf.cc line 1471 a writer (thread id 5156) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file ibuf0ibuf.cc line 4578 Last time write locked in file mtr0mtr.ic line 147 2018-03-28 6:54:30 5220 [Warning] InnoDB: A long semaphore wait: --Thread 5248 has waited at row0purge.cc line 852 for 260.00 seconds the semaphore: S-lock on RW-latch at 0045C920 created in file dict0dict.cc line 1107 a writer (thread id 5372) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file not yet reserved line 0 Last time write locked in file row0mysql.cc line 3593 2018-03-28 6:54:30 5220 [Warning] InnoDB: A long semaphore wait: --Thread 5372 has waited at ibuf0ibuf.cc line 3460 for 260.00 seconds the semaphore: S-lock on RW-latch at 0378B77C created in file buf0buf.cc line 1471 a writer (thread id 5156) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file ibuf0ibuf.cc line 4578 Last time write locked in file mtr0mtr.ic line 147 2018-03-28 6:54:30 5220 [Note] InnoDB: A semaphore wait: --Thread 5156 has waited at buf0buf.cc line 4136 for 303.00 seconds the semaphore: S-lock on RW-latch at 0372DFBC created in file buf0buf.cc line 1471 a writer (thread id 0) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file not yet reserved line 0 Last time write locked in file buf0buf.cc line 5363 2018-03-28 6:54:30 5220 [Note] InnoDB: A semaphore wait: --Thread 5148 has waited at ibuf0ibuf.cc line 4394 for 303.00 seconds the semaphore: Mutex at 01953E20, Mutex IBUF created ibuf0ibuf.cc:516, lock var 2 2018-03-28 6:54:30 5220 [Note] InnoDB: A semaphore wait: --Thread 5160 has waited at ibuf0ibuf.cc line 4394 for 303.00 seconds the semaphore: Mutex at 01953E20, Mutex IBUF created ibuf0ibuf.cc:516, lock var 2 2018-03-28 6:54:30 5220 [Note] InnoDB: A semaphore wait: --Thread 5152 has waited at ibuf0ibuf.cc line 4394 for 303.00 seconds the semaphore: Mutex at 01953E20, Mutex IBUF created ibuf0ibuf.cc:516, lock var 2 2018-03-28 6:54:30 5220 [Note] InnoDB: A semaphore wait: --Thread 5228 has waited at ibuf0ibuf.cc line 2532 for 303.00 seconds the semaphore: S-lock on RW-latch at 0378B77C created in file buf0buf.cc line 1471 a writer (thread id 5156) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file ibuf0ibuf.cc line 4578 Last time write locked in file mtr0mtr.ic line 147 2018-03-28 6:54:30 5220 [Note] InnoDB: A semaphore wait: --Thread 5188 has waited at buf0flu.cc line 1246 for 303.00 seconds the semaphore: SX-lock on RW-latch at 0378B77C created in file buf0buf.cc line 1471 a writer (thread id 5156) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file ibuf0ibuf.cc line 4578 Last time write locked in file mtr0mtr.ic line 147 2018-03-28 6:54:30 5220 [Note] InnoDB: A semaphore wait: --Thread 5248 has waited at row0purge.cc line 852 for 260.00 seconds the semaphore: S-lock on RW-latch at 0045C920 created in file dict0dict.cc line 1107 a writer (thread id 5372) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file not yet reserved line 0 Last time write locked in file row0mysql.cc line 3593 2018-03-28 6:54:30 5220 [Note] InnoDB: A semaphore wait: --Thread 5372 has waited at ibuf0ibuf.cc line 3460 for 260.00 seconds the semaphore: S-lock on RW-latch at 0378B77C created in file buf0buf.cc line 1471 a writer (thread id 5156) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file ibuf0ibuf.cc line 4578 Last time write locked in file mtr0mtr.ic line 147 2018-03-28 6:54:30 5220 [Note] InnoDB: A semaphore wait: --Thread 5224 has waited at ibuf0ibuf.cc line 4921 for 49.00 seconds the semaphore: Mutex at 01953E20, Mutex IBUF created ibuf0ibuf.cc:516, lock var 2 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending reads 0, writes 0 InnoDB: ###### Diagnostic info printed to the standard error stream 2018-03-28 7:33:50 5284 [Note] D:\mariadb\bin\mysqld.exe (unknown): Normal shutdown 2018-03-28 7:33:50 5284 [Note] Event Scheduler: Purging the queue. 0 events