2019-12-19T03:58:43.0728145Z galera.MW-328A 'innodb' w1 [ fail ] 2019-12-19T03:58:43.0731913Z Test ended at 2019-12-19 03:58:43 2019-12-19T03:58:43.0732318Z 2019-12-19T03:58:43.0732753Z CURRENT_TEST: galera.MW-328A 2019-12-19T03:58:43.0733888Z mysqltest: At line 47: query 'INSERT IGNORE INTO t2 SELECT f2 FROM t1' failed with wrong errno 2013: 'Lost connection to MySQL server during query', instead of 0... 2019-12-19T03:58:43.0734338Z 2019-12-19T03:58:43.0734593Z The result from queries just before the failure was: 2019-12-19T03:58:43.0734857Z < snip > 2019-12-19T03:58:43.0735277Z INSERT INTO t1 (f1) VALUES (1); 2019-12-19T03:58:43.0736085Z CREATE TABLE t2 (f1 CHAR(20)) ENGINE=InnoDB; 2019-12-19T03:58:43.0736420Z CREATE PROCEDURE proc_update () 2019-12-19T03:58:43.0737052Z BEGIN 2019-12-19T03:58:43.0737253Z DECLARE CONTINUE HANDLER FOR SQLEXCEPTION BEGIN END; 2019-12-19T03:58:43.0737447Z SET SESSION wsrep_sync_wait = 0; 2019-12-19T03:58:43.0737635Z WHILE 1 DO 2019-12-19T03:58:43.0737804Z UPDATE t1 SET f2 = LEFT(MD5(RAND()), 4); 2019-12-19T03:58:43.0737993Z END WHILE; 2019-12-19T03:58:43.0738169Z END| 2019-12-19T03:58:43.0738408Z connect node_1X, 127.0.0.1, root, , test, $NODE_MYPORT_1; 2019-12-19T03:58:43.0738591Z connection node_1X; 2019-12-19T03:58:43.0738774Z CALL proc_update();; 2019-12-19T03:58:43.0738953Z connection node_2; 2019-12-19T03:58:43.0739134Z SET SESSION wsrep_retry_autocommit = 0; 2019-12-19T03:58:43.0739286Z 2019-12-19T03:58:43.0782905Z More results from queries before failure can be found in /var/tmp/mtr/1/log/MW-328A.log 2019-12-19T03:58:43.0856065Z 2019-12-19T03:58:43.0856471Z 2019-12-19T03:58:43.0857474Z Server [mysqld.2 - pid: 102455, winpid: 102455, exit: 256] failed during test run 2019-12-19T03:58:43.0857775Z Server log from this test: 2019-12-19T03:58:43.0858160Z ----------SERVER LOG START----------- 2019-12-19T03:58:43.0858613Z 2019-12-19 3:46:47 0 [Warning] InnoDB: A long semaphore wait: 2019-12-19T03:58:43.0859102Z --Thread 139858299688704 has waited at lock0lock.cc line 6267 for 241.00 seconds the semaphore: 2019-12-19T03:58:43.0859411Z Mutex at 0x55e556b0c200, Mutex LOCK_SYS created lock0lock.cc:460, lock var 2 2019-12-19T03:58:43.0859589Z 2019-12-19T03:58:43.0860000Z 2019-12-19 3:46:47 0 [Warning] InnoDB: A long semaphore wait: 2019-12-19T03:58:43.0860516Z --Thread 139858053515008 has waited at trx0trx.cc line 2074 for 241.00 seconds the semaphore: 2019-12-19T03:58:43.0860797Z Mutex at 0x7f333e45d110, Mutex TRX created trx0trx.cc:207, lock var 2 2019-12-19T03:58:43.0860970Z 2019-12-19T03:58:43.0861359Z 2019-12-19 3:46:47 0 [Note] InnoDB: A semaphore wait: 2019-12-19T03:58:43.0861860Z --Thread 139858299688704 has waited at lock0lock.cc line 6267 for 241.00 seconds the semaphore: 2019-12-19T03:58:43.0862154Z Mutex at 0x55e556b0c200, Mutex LOCK_SYS created lock0lock.cc:460, lock var 2 2019-12-19T03:58:43.0862337Z 2019-12-19T03:58:43.0862762Z 2019-12-19 3:46:47 0 [Note] InnoDB: A semaphore wait: 2019-12-19T03:58:43.0863257Z --Thread 139858053515008 has waited at trx0trx.cc line 2074 for 241.00 seconds the semaphore: 2019-12-19T03:58:43.0863687Z Mutex at 0x7f333e45d110, Mutex TRX created trx0trx.cc:207, lock var 2 2019-12-19T03:58:43.0864207Z 2019-12-19T03:58:43.0864469Z InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: 2019-12-19T03:58:43.0864732Z InnoDB: Pending reads 0, writes 0 2019-12-19T03:58:43.0864927Z 2019-12-19T03:58:43.0865150Z ===================================== 2019-12-19T03:58:43.0865701Z 2019-12-19 03:47:03 0x7f331bfff700 INNODB MONITOR OUTPUT 2019-12-19T03:58:43.0866011Z ===================================== 2019-12-19T03:58:43.0866274Z Per second averages calculated from the last 65 seconds 2019-12-19T03:58:43.0866736Z ----------------- 2019-12-19T03:58:43.0867034Z BACKGROUND THREAD 2019-12-19T03:58:43.0867962Z ----------------- 2019-12-19T03:58:43.0868255Z srv_master_thread loops: 1 srv_active, 0 srv_shutdown, 258 srv_idle 2019-12-19T03:58:43.0868495Z srv_master_thread log flush and writes: 259 2019-12-19T03:58:43.0869030Z ---------- 2019-12-19T03:58:43.0869612Z SEMAPHORES 2019-12-19T03:58:43.0869930Z ---------- 2019-12-19T03:58:43.0870161Z OS WAIT ARRAY INFO: reservation count 293 2019-12-19T03:58:43.0870590Z --Thread 139858299688704 has waited at lock0lock.cc line 6267 for 257.00 seconds the semaphore: 2019-12-19T03:58:43.0870882Z Mutex at 0x55e556b0c200, Mutex LOCK_SYS created lock0lock.cc:460, lock var 2 2019-12-19T03:58:43.0871062Z 2019-12-19T03:58:43.0871489Z --Thread 139858053515008 has waited at trx0trx.cc line 2074 for 257.00 seconds the semaphore: 2019-12-19T03:58:43.0871773Z Mutex at 0x7f333e45d110, Mutex TRX created trx0trx.cc:207, lock var 2 2019-12-19T03:58:43.0871979Z 2019-12-19T03:58:43.0872164Z OS WAIT ARRAY INFO: signal count 166 2019-12-19T03:58:43.0872566Z RW-shared spins 0, rounds 388, OS waits 180 2019-12-19T03:58:43.0873157Z RW-excl spins 0, rounds 0, OS waits 0 2019-12-19T03:58:43.0874144Z RW-sx spins 0, rounds 0, OS waits 0 2019-12-19T03:58:43.0874732Z Spin rounds per wait: 388.00 RW-shared, 0.00 RW-excl, 0.00 RW-sx 2019-12-19T03:58:43.0875055Z FAIL TO OBTAIN LOCK MUTEX, SKIP LOCK INFO PRINTING 2019-12-19T03:58:43.0875508Z -------- 2019-12-19T03:58:43.0875765Z FILE I/O 2019-12-19T03:58:43.0876194Z -------- 2019-12-19T03:58:43.0876485Z I/O thread 0 state: waiting for completed aio requests (insert buffer thread) 2019-12-19T03:58:43.0876933Z I/O thread 1 state: waiting for completed aio requests (log thread) 2019-12-19T03:58:43.0877142Z I/O thread 2 state: waiting for completed aio requests (read thread) 2019-12-19T03:58:43.0877334Z I/O thread 3 state: waiting for completed aio requests (read thread) 2019-12-19T03:58:43.0877537Z I/O thread 4 state: waiting for completed aio requests (write thread) 2019-12-19T03:58:43.0877746Z I/O thread 5 state: waiting for completed aio requests (write thread) 2019-12-19T03:58:43.0877964Z Pending normal aio reads: [0, 0] , aio writes: [0, 0] , 2019-12-19T03:58:43.0878338Z ibuf aio reads:, log i/o's:, sync i/o's: 2019-12-19T03:58:43.0878559Z Pending flushes (fsync) log: 0; buffer pool: 0 2019-12-19T03:58:43.0878761Z 332 OS file reads, 1240 OS file writes, 829 OS fsyncs 2019-12-19T03:58:43.0878961Z 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s 2019-12-19T03:58:43.0879328Z ------------------------------------- 2019-12-19T03:58:43.0879558Z INSERT BUFFER AND ADAPTIVE HASH INDEX 2019-12-19T03:58:43.0879907Z ------------------------------------- 2019-12-19T03:58:43.0880169Z Ibuf: size 1, free list len 0, seg size 2, 0 merges 2019-12-19T03:58:43.0880363Z merged operations: 2019-12-19T03:58:43.0880543Z insert 0, delete mark 0, delete 0 2019-12-19T03:58:43.0880711Z discarded operations: 2019-12-19T03:58:43.0880891Z insert 0, delete mark 0, delete 0 2019-12-19T03:58:43.0881090Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.0881297Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.0881475Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.0881668Z Hash table size 2267, node heap has 1 buffer(s) 2019-12-19T03:58:43.0881859Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.0882050Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.0882239Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.0882415Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.0882796Z 0.00 hash searches/s, 0.00 non-hash searches/s 2019-12-19T03:58:43.0883174Z --- 2019-12-19T03:58:43.0883391Z LOG 2019-12-19T03:58:43.0883831Z --- 2019-12-19T03:58:43.0884633Z Log sequence number 2102181 2019-12-19T03:58:43.0885068Z Log flushed up to 2102181 2019-12-19T03:58:43.0885397Z Pages flushed up to 2102181 2019-12-19T03:58:43.0885623Z Last checkpoint at 2102172 2019-12-19T03:58:43.0885873Z 0 pending log flushes, 0 pending chkp writes 2019-12-19T03:58:43.0886570Z 723 log i/o's done, 0.00 log i/o's/second 2019-12-19T03:58:43.0887101Z ---------------------- 2019-12-19T03:58:43.0887566Z BUFFER POOL AND MEMORY 2019-12-19T03:58:43.0888495Z ---------------------- 2019-12-19T03:58:43.0888839Z Total large memory allocated 10682368 2019-12-19T03:58:43.0889173Z Dictionary memory allocated 31824 2019-12-19T03:58:43.0889383Z Buffer pool size 511 2019-12-19T03:58:43.0889563Z Free buffers 100 2019-12-19T03:58:43.0889750Z Database pages 410 2019-12-19T03:58:43.0889932Z Old database pages 0 2019-12-19T03:58:43.0890114Z Modified db pages 0 2019-12-19T03:58:43.0890286Z Percent of dirty pages(LRU & free pages): 0.000 2019-12-19T03:58:43.0890490Z Max dirty pages percent: 75.000 2019-12-19T03:58:43.0890679Z Pending reads 0 2019-12-19T03:58:43.0890865Z Pending writes: LRU 0, flush list 0, single page 0 2019-12-19T03:58:43.0891059Z Pages made young 0, not young 0 2019-12-19T03:58:43.0891481Z 0.00 youngs/s, 0.00 non-youngs/s 2019-12-19T03:58:43.0891760Z Pages read 188, created 449, written 467 2019-12-19T03:58:43.0892101Z 0.00 reads/s, 0.00 creates/s, 0.00 writes/s 2019-12-19T03:58:43.0892307Z No buffer pool page gets since the last printout 2019-12-19T03:58:43.0892500Z Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s 2019-12-19T03:58:43.0892710Z LRU len: 410, unzip_LRU len: 0 2019-12-19T03:58:43.0892898Z I/O sum[0]:cur[0], unzip sum[0]:cur[0] 2019-12-19T03:58:43.0893282Z -------------- 2019-12-19T03:58:43.0893977Z ROW OPERATIONS 2019-12-19T03:58:43.0894558Z -------------- 2019-12-19T03:58:43.0894871Z 0 queries inside InnoDB, 0 queries in queue 2019-12-19T03:58:43.0895382Z 0 read views open inside InnoDB 2019-12-19T03:58:43.0895653Z Process ID=102456, Main thread ID=139857655457536, state: sleeping 2019-12-19T03:58:43.0895909Z Number of rows inserted 62, updated 264, deleted 0, read 328 2019-12-19T03:58:43.0896208Z 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s 2019-12-19T03:58:43.0896474Z Number of system rows inserted 0, updated 0, deleted 0, read 0 2019-12-19T03:58:43.0896760Z 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s 2019-12-19T03:58:43.0897614Z ---------------------------- 2019-12-19T03:58:43.0897991Z END OF INNODB MONITOR OUTPUT 2019-12-19T03:58:43.0898184Z ============================ 2019-12-19T03:58:43.0898384Z InnoDB: ###### Diagnostic info printed to the standard error stream 2019-12-19T03:58:43.0898792Z 2019-12-19 3:47:18 0 [Warning] InnoDB: A long semaphore wait: 2019-12-19T03:58:43.0899258Z --Thread 139858299688704 has waited at lock0lock.cc line 6267 for 272.00 seconds the semaphore: 2019-12-19T03:58:43.0899543Z Mutex at 0x55e556b0c200, Mutex LOCK_SYS created lock0lock.cc:460, lock var 2 2019-12-19T03:58:43.0899735Z 2019-12-19T03:58:43.0900139Z 2019-12-19 3:47:18 0 [Warning] InnoDB: A long semaphore wait: 2019-12-19T03:58:43.0900620Z --Thread 139858053515008 has waited at trx0trx.cc line 2074 for 272.00 seconds the semaphore: 2019-12-19T03:58:43.0900894Z Mutex at 0x7f333e45d110, Mutex TRX created trx0trx.cc:207, lock var 2 2019-12-19T03:58:43.0901342Z 2019-12-19T03:58:43.0901715Z 2019-12-19 3:47:18 0 [Note] InnoDB: A semaphore wait: 2019-12-19T03:58:43.0902225Z --Thread 139858299688704 has waited at lock0lock.cc line 6267 for 272.00 seconds the semaphore: 2019-12-19T03:58:43.0902516Z Mutex at 0x55e556b0c200, Mutex LOCK_SYS created lock0lock.cc:460, lock var 2 2019-12-19T03:58:43.0902716Z 2019-12-19T03:58:43.0903106Z 2019-12-19 3:47:18 0 [Note] InnoDB: A semaphore wait: 2019-12-19T03:58:43.0903618Z --Thread 139858053515008 has waited at trx0trx.cc line 2074 for 272.00 seconds the semaphore: 2019-12-19T03:58:43.0904597Z Mutex at 0x7f333e45d110, Mutex TRX created trx0trx.cc:207, lock var 2 2019-12-19T03:58:43.0904913Z 2019-12-19T03:58:43.0905171Z InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: 2019-12-19T03:58:43.0905468Z InnoDB: Pending reads 0, writes 0 2019-12-19T03:58:43.0905681Z 2019-12-19T03:58:43.0905891Z ===================================== 2019-12-19T03:58:43.0906642Z 2019-12-19 03:47:23 0x7f331bfff700 INNODB MONITOR OUTPUT 2019-12-19T03:58:43.0906975Z ===================================== 2019-12-19T03:58:43.0907240Z Per second averages calculated from the last 20 seconds 2019-12-19T03:58:43.0907967Z ----------------- 2019-12-19T03:58:43.0908364Z BACKGROUND THREAD 2019-12-19T03:58:43.0908709Z ----------------- 2019-12-19T03:58:43.0908960Z srv_master_thread loops: 1 srv_active, 0 srv_shutdown, 278 srv_idle 2019-12-19T03:58:43.0909335Z srv_master_thread log flush and writes: 279 2019-12-19T03:58:43.0909931Z ---------- 2019-12-19T03:58:43.0910176Z SEMAPHORES 2019-12-19T03:58:43.0910531Z ---------- 2019-12-19T03:58:43.0910757Z OS WAIT ARRAY INFO: reservation count 293 2019-12-19T03:58:43.0911224Z --Thread 139858299688704 has waited at lock0lock.cc line 6267 for 277.00 seconds the semaphore: 2019-12-19T03:58:43.0911526Z Mutex at 0x55e556b0c200, Mutex LOCK_SYS created lock0lock.cc:460, lock var 2 2019-12-19T03:58:43.0911731Z 2019-12-19T03:58:43.0912338Z --Thread 139858053515008 has waited at trx0trx.cc line 2074 for 277.00 seconds the semaphore: 2019-12-19T03:58:43.0912655Z Mutex at 0x7f333e45d110, Mutex TRX created trx0trx.cc:207, lock var 2 2019-12-19T03:58:43.0913185Z 2019-12-19T03:58:43.0913344Z OS WAIT ARRAY INFO: signal count 166 2019-12-19T03:58:43.0914305Z RW-shared spins 0, rounds 388, OS waits 180 2019-12-19T03:58:43.0914923Z RW-excl spins 0, rounds 0, OS waits 0 2019-12-19T03:58:43.0915439Z RW-sx spins 0, rounds 0, OS waits 0 2019-12-19T03:58:43.0916046Z Spin rounds per wait: 388.00 RW-shared, 0.00 RW-excl, 0.00 RW-sx 2019-12-19T03:58:43.0916371Z FAIL TO OBTAIN LOCK MUTEX, SKIP LOCK INFO PRINTING 2019-12-19T03:58:43.0916843Z -------- 2019-12-19T03:58:43.0917302Z FILE I/O 2019-12-19T03:58:43.0917819Z -------- 2019-12-19T03:58:43.0918035Z I/O thread 0 state: waiting for completed aio requests (insert buffer thread) 2019-12-19T03:58:43.0918254Z I/O thread 1 state: waiting for completed aio requests (log thread) 2019-12-19T03:58:43.0918473Z I/O thread 2 state: waiting for completed aio requests (read thread) 2019-12-19T03:58:43.0918688Z I/O thread 3 state: waiting for completed aio requests (read thread) 2019-12-19T03:58:43.0918896Z I/O thread 4 state: waiting for completed aio requests (write thread) 2019-12-19T03:58:43.0919090Z I/O thread 5 state: waiting for completed aio requests (write thread) 2019-12-19T03:58:43.0919294Z Pending normal aio reads: [0, 0] , aio writes: [0, 0] , 2019-12-19T03:58:43.0919667Z ibuf aio reads:, log i/o's:, sync i/o's: 2019-12-19T03:58:43.0919915Z Pending flushes (fsync) log: 0; buffer pool: 0 2019-12-19T03:58:43.0920119Z 332 OS file reads, 1240 OS file writes, 829 OS fsyncs 2019-12-19T03:58:43.0920307Z 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s 2019-12-19T03:58:43.0920674Z ------------------------------------- 2019-12-19T03:58:43.0920916Z INSERT BUFFER AND ADAPTIVE HASH INDEX 2019-12-19T03:58:43.0921325Z ------------------------------------- 2019-12-19T03:58:43.0921567Z Ibuf: size 1, free list len 0, seg size 2, 0 merges 2019-12-19T03:58:43.0921785Z merged operations: 2019-12-19T03:58:43.0922012Z insert 0, delete mark 0, delete 0 2019-12-19T03:58:43.0922228Z discarded operations: 2019-12-19T03:58:43.0922435Z insert 0, delete mark 0, delete 0 2019-12-19T03:58:43.0922643Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1028594Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1029082Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1029340Z Hash table size 2267, node heap has 1 buffer(s) 2019-12-19T03:58:43.1029549Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1029757Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1029965Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1030174Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1030733Z 0.00 hash searches/s, 0.00 non-hash searches/s 2019-12-19T03:58:43.1031189Z --- 2019-12-19T03:58:43.1031604Z LOG 2019-12-19T03:58:43.1032158Z --- 2019-12-19T03:58:43.1032568Z Log sequence number 2102181 2019-12-19T03:58:43.1032758Z Log flushed up to 2102181 2019-12-19T03:58:43.1032947Z Pages flushed up to 2102181 2019-12-19T03:58:43.1033131Z Last checkpoint at 2102172 2019-12-19T03:58:43.1033323Z 0 pending log flushes, 0 pending chkp writes 2019-12-19T03:58:43.1034384Z 723 log i/o's done, 0.00 log i/o's/second 2019-12-19T03:58:43.1034985Z ---------------------- 2019-12-19T03:58:43.1035303Z BUFFER POOL AND MEMORY 2019-12-19T03:58:43.1035754Z ---------------------- 2019-12-19T03:58:43.1036041Z Total large memory allocated 10682368 2019-12-19T03:58:43.1036288Z Dictionary memory allocated 31824 2019-12-19T03:58:43.1036525Z Buffer pool size 511 2019-12-19T03:58:43.1036776Z Free buffers 100 2019-12-19T03:58:43.1037010Z Database pages 410 2019-12-19T03:58:43.1037577Z Old database pages 0 2019-12-19T03:58:43.1037760Z Modified db pages 0 2019-12-19T03:58:43.1037944Z Percent of dirty pages(LRU & free pages): 0.000 2019-12-19T03:58:43.1038298Z Max dirty pages percent: 75.000 2019-12-19T03:58:43.1038486Z Pending reads 0 2019-12-19T03:58:43.1038675Z Pending writes: LRU 0, flush list 0, single page 0 2019-12-19T03:58:43.1038873Z Pages made young 0, not young 0 2019-12-19T03:58:43.1039273Z 0.00 youngs/s, 0.00 non-youngs/s 2019-12-19T03:58:43.1039524Z Pages read 188, created 449, written 467 2019-12-19T03:58:43.1039727Z 0.00 reads/s, 0.00 creates/s, 0.00 writes/s 2019-12-19T03:58:43.1040063Z No buffer pool page gets since the last printout 2019-12-19T03:58:43.1040292Z Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s 2019-12-19T03:58:43.1040499Z LRU len: 410, unzip_LRU len: 0 2019-12-19T03:58:43.1040677Z I/O sum[0]:cur[0], unzip sum[0]:cur[0] 2019-12-19T03:58:43.1041059Z -------------- 2019-12-19T03:58:43.1041304Z ROW OPERATIONS 2019-12-19T03:58:43.1041649Z -------------- 2019-12-19T03:58:43.1041878Z 0 queries inside InnoDB, 0 queries in queue 2019-12-19T03:58:43.1042075Z 0 read views open inside InnoDB 2019-12-19T03:58:43.1042287Z Process ID=102456, Main thread ID=139857655457536, state: sleeping 2019-12-19T03:58:43.1042674Z Number of rows inserted 62, updated 264, deleted 0, read 328 2019-12-19T03:58:43.1043092Z 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s 2019-12-19T03:58:43.1043298Z Number of system rows inserted 0, updated 0, deleted 0, read 0 2019-12-19T03:58:43.1044151Z 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s 2019-12-19T03:58:43.1044866Z ---------------------------- 2019-12-19T03:58:43.1045186Z END OF INNODB MONITOR OUTPUT 2019-12-19T03:58:43.1045456Z ============================ 2019-12-19T03:58:43.1045671Z 2019-12-19T03:58:43.1045895Z ===================================== 2019-12-19T03:58:43.1046398Z 2019-12-19 03:47:43 0x7f331bfff700 INNODB MONITOR OUTPUT 2019-12-19T03:58:43.1046718Z ===================================== 2019-12-19T03:58:43.1046969Z Per second averages calculated from the last 20 seconds 2019-12-19T03:58:43.1047525Z ----------------- 2019-12-19T03:58:43.1047768Z BACKGROUND THREAD 2019-12-19T03:58:43.1048109Z ----------------- 2019-12-19T03:58:43.1048355Z srv_master_thread loops: 1 srv_active, 0 srv_shutdown, 298 srv_idle 2019-12-19T03:58:43.1048562Z srv_master_thread log flush and writes: 299 2019-12-19T03:58:43.1048916Z ---------- 2019-12-19T03:58:43.1049143Z SEMAPHORES 2019-12-19T03:58:43.1049476Z ---------- 2019-12-19T03:58:43.1049707Z OS WAIT ARRAY INFO: reservation count 293 2019-12-19T03:58:43.1050151Z --Thread 139858299688704 has waited at lock0lock.cc line 6267 for 297.00 seconds the semaphore: 2019-12-19T03:58:43.1050443Z Mutex at 0x55e556b0c200, Mutex LOCK_SYS created lock0lock.cc:460, lock var 2 2019-12-19T03:58:43.1050622Z 2019-12-19T03:58:43.1051041Z --Thread 139858053515008 has waited at trx0trx.cc line 2074 for 297.00 seconds the semaphore: 2019-12-19T03:58:43.1051318Z Mutex at 0x7f333e45d110, Mutex TRX created trx0trx.cc:207, lock var 2 2019-12-19T03:58:43.1051493Z 2019-12-19T03:58:43.1051668Z OS WAIT ARRAY INFO: signal count 166 2019-12-19T03:58:43.1052227Z RW-shared spins 0, rounds 388, OS waits 180 2019-12-19T03:58:43.1052646Z RW-excl spins 0, rounds 0, OS waits 0 2019-12-19T03:58:43.1053066Z RW-sx spins 0, rounds 0, OS waits 0 2019-12-19T03:58:43.1053730Z Spin rounds per wait: 388.00 RW-shared, 0.00 RW-excl, 0.00 RW-sx 2019-12-19T03:58:43.1054715Z FAIL TO OBTAIN LOCK MUTEX, SKIP LOCK INFO PRINTING 2019-12-19T03:58:43.1055422Z -------- 2019-12-19T03:58:43.1055758Z FILE I/O 2019-12-19T03:58:43.1056193Z -------- 2019-12-19T03:58:43.1056499Z I/O thread 0 state: waiting for completed aio requests (insert buffer thread) 2019-12-19T03:58:43.1056774Z I/O thread 1 state: waiting for completed aio requests (log thread) 2019-12-19T03:58:43.1057026Z I/O thread 2 state: waiting for completed aio requests (read thread) 2019-12-19T03:58:43.1057293Z I/O thread 3 state: waiting for completed aio requests (read thread) 2019-12-19T03:58:43.1057552Z I/O thread 4 state: waiting for completed aio requests (write thread) 2019-12-19T03:58:43.1058194Z I/O thread 5 state: waiting for completed aio requests (write thread) 2019-12-19T03:58:43.1058594Z Pending normal aio reads: [0, 0] , aio writes: [0, 0] , 2019-12-19T03:58:43.1059038Z ibuf aio reads:, log i/o's:, sync i/o's: 2019-12-19T03:58:43.1059343Z Pending flushes (fsync) log: 0; buffer pool: 0 2019-12-19T03:58:43.1059572Z 332 OS file reads, 1240 OS file writes, 829 OS fsyncs 2019-12-19T03:58:43.1059801Z 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s 2019-12-19T03:58:43.1060224Z ------------------------------------- 2019-12-19T03:58:43.1060490Z INSERT BUFFER AND ADAPTIVE HASH INDEX 2019-12-19T03:58:43.1060913Z ------------------------------------- 2019-12-19T03:58:43.1061348Z Ibuf: size 1, free list len 0, seg size 2, 0 merges 2019-12-19T03:58:43.1061561Z merged operations: 2019-12-19T03:58:43.1061748Z insert 0, delete mark 0, delete 0 2019-12-19T03:58:43.1061947Z discarded operations: 2019-12-19T03:58:43.1062143Z insert 0, delete mark 0, delete 0 2019-12-19T03:58:43.1062384Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1062770Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1063706Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1064054Z Hash table size 2267, node heap has 1 buffer(s) 2019-12-19T03:58:43.1064309Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1064552Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1064784Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1065028Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1065548Z 0.00 hash searches/s, 0.00 non-hash searches/s 2019-12-19T03:58:43.1066054Z --- 2019-12-19T03:58:43.1066350Z LOG 2019-12-19T03:58:43.1066753Z --- 2019-12-19T03:58:43.1067374Z Log sequence number 2102181 2019-12-19T03:58:43.1067581Z Log flushed up to 2102181 2019-12-19T03:58:43.1067791Z Pages flushed up to 2102181 2019-12-19T03:58:43.1067985Z Last checkpoint at 2102172 2019-12-19T03:58:43.1068186Z 0 pending log flushes, 0 pending chkp writes 2019-12-19T03:58:43.1068925Z 723 log i/o's done, 0.00 log i/o's/second 2019-12-19T03:58:43.1069357Z ---------------------- 2019-12-19T03:58:43.1069796Z BUFFER POOL AND MEMORY 2019-12-19T03:58:43.1070225Z ---------------------- 2019-12-19T03:58:43.1070515Z Total large memory allocated 10682368 2019-12-19T03:58:43.1070732Z Dictionary memory allocated 31824 2019-12-19T03:58:43.1070924Z Buffer pool size 511 2019-12-19T03:58:43.1071136Z Free buffers 100 2019-12-19T03:58:43.1071338Z Database pages 410 2019-12-19T03:58:43.1071537Z Old database pages 0 2019-12-19T03:58:43.1071773Z Modified db pages 0 2019-12-19T03:58:43.1071972Z Percent of dirty pages(LRU & free pages): 0.000 2019-12-19T03:58:43.1072188Z Max dirty pages percent: 75.000 2019-12-19T03:58:43.1072396Z Pending reads 0 2019-12-19T03:58:43.1072605Z Pending writes: LRU 0, flush list 0, single page 0 2019-12-19T03:58:43.1072810Z Pages made young 0, not young 0 2019-12-19T03:58:43.1073253Z 0.00 youngs/s, 0.00 non-youngs/s 2019-12-19T03:58:43.1074148Z Pages read 188, created 449, written 467 2019-12-19T03:58:43.1074479Z 0.00 reads/s, 0.00 creates/s, 0.00 writes/s 2019-12-19T03:58:43.1074730Z No buffer pool page gets since the last printout 2019-12-19T03:58:43.1075004Z Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s 2019-12-19T03:58:43.1075266Z LRU len: 410, unzip_LRU len: 0 2019-12-19T03:58:43.1075505Z I/O sum[0]:cur[0], unzip sum[0]:cur[0] 2019-12-19T03:58:43.1076051Z -------------- 2019-12-19T03:58:43.1076360Z ROW OPERATIONS 2019-12-19T03:58:43.1076829Z -------------- 2019-12-19T03:58:43.1077136Z 0 queries inside InnoDB, 0 queries in queue 2019-12-19T03:58:43.1077570Z 0 read views open inside InnoDB 2019-12-19T03:58:43.1078122Z Process ID=102456, Main thread ID=139857655457536, state: sleeping 2019-12-19T03:58:43.1078583Z Number of rows inserted 62, updated 264, deleted 0, read 328 2019-12-19T03:58:43.1078809Z 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s 2019-12-19T03:58:43.1079044Z Number of system rows inserted 0, updated 0, deleted 0, read 0 2019-12-19T03:58:43.1079416Z 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s 2019-12-19T03:58:43.1079847Z ---------------------------- 2019-12-19T03:58:43.1080265Z END OF INNODB MONITOR OUTPUT 2019-12-19T03:58:43.1080519Z ============================ 2019-12-19T03:58:43.1080737Z InnoDB: ###### Diagnostic info printed to the standard error stream 2019-12-19T03:58:43.1081207Z 2019-12-19 3:47:49 0 [Warning] InnoDB: A long semaphore wait: 2019-12-19T03:58:43.1081740Z --Thread 139858299688704 has waited at lock0lock.cc line 6267 for 303.00 seconds the semaphore: 2019-12-19T03:58:43.1082049Z Mutex at 0x55e556b0c200, Mutex LOCK_SYS created lock0lock.cc:460, lock var 2 2019-12-19T03:58:43.1082254Z 2019-12-19T03:58:43.1082689Z 2019-12-19 3:47:49 0 [Warning] InnoDB: A long semaphore wait: 2019-12-19T03:58:43.1136144Z --Thread 139858053515008 has waited at trx0trx.cc line 2074 for 303.00 seconds the semaphore: 2019-12-19T03:58:43.1136622Z Mutex at 0x7f333e45d110, Mutex TRX created trx0trx.cc:207, lock var 2 2019-12-19T03:58:43.1136884Z 2019-12-19T03:58:43.1137477Z 2019-12-19 3:47:49 0 [Note] InnoDB: A semaphore wait: 2019-12-19T03:58:43.1137967Z --Thread 139858299688704 has waited at lock0lock.cc line 6267 for 303.00 seconds the semaphore: 2019-12-19T03:58:43.1138248Z Mutex at 0x55e556b0c200, Mutex LOCK_SYS created lock0lock.cc:460, lock var 2 2019-12-19T03:58:43.1138420Z 2019-12-19T03:58:43.1138789Z 2019-12-19 3:47:49 0 [Note] InnoDB: A semaphore wait: 2019-12-19T03:58:43.1139261Z --Thread 139858053515008 has waited at trx0trx.cc line 2074 for 303.00 seconds the semaphore: 2019-12-19T03:58:43.1139535Z Mutex at 0x7f333e45d110, Mutex TRX created trx0trx.cc:207, lock var 2 2019-12-19T03:58:43.1139703Z 2019-12-19T03:58:43.1139883Z InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: 2019-12-19T03:58:43.1140077Z InnoDB: Pending reads 0, writes 0 2019-12-19T03:58:43.1140222Z 2019-12-19T03:58:43.1140394Z ===================================== 2019-12-19T03:58:43.1140801Z 2019-12-19 03:48:03 0x7f331bfff700 INNODB MONITOR OUTPUT 2019-12-19T03:58:43.1141084Z ===================================== 2019-12-19T03:58:43.1141273Z Per second averages calculated from the last 20 seconds 2019-12-19T03:58:43.1141629Z ----------------- 2019-12-19T03:58:43.1141865Z BACKGROUND THREAD 2019-12-19T03:58:43.1142202Z ----------------- 2019-12-19T03:58:43.1142430Z srv_master_thread loops: 1 srv_active, 0 srv_shutdown, 318 srv_idle 2019-12-19T03:58:43.1142825Z srv_master_thread log flush and writes: 319 2019-12-19T03:58:43.1143292Z ---------- 2019-12-19T03:58:43.1143801Z SEMAPHORES 2019-12-19T03:58:43.1144247Z ---------- 2019-12-19T03:58:43.1144527Z OS WAIT ARRAY INFO: reservation count 293 2019-12-19T03:58:43.1145091Z --Thread 139858299688704 has waited at lock0lock.cc line 6267 for 317.00 seconds the semaphore: 2019-12-19T03:58:43.1145449Z Mutex at 0x55e556b0c200, Mutex LOCK_SYS created lock0lock.cc:460, lock var 2 2019-12-19T03:58:43.1145879Z 2019-12-19T03:58:43.1146512Z --Thread 139858053515008 has waited at trx0trx.cc line 2074 for 317.00 seconds the semaphore: 2019-12-19T03:58:43.1147177Z Mutex at 0x7f333e45d110, Mutex TRX created trx0trx.cc:207, lock var 2 2019-12-19T03:58:43.1147775Z 2019-12-19T03:58:43.1147951Z OS WAIT ARRAY INFO: signal count 166 2019-12-19T03:58:43.1148359Z RW-shared spins 0, rounds 388, OS waits 180 2019-12-19T03:58:43.1149022Z RW-excl spins 0, rounds 0, OS waits 0 2019-12-19T03:58:43.1149477Z RW-sx spins 0, rounds 0, OS waits 0 2019-12-19T03:58:43.1149955Z Spin rounds per wait: 388.00 RW-shared, 0.00 RW-excl, 0.00 RW-sx 2019-12-19T03:58:43.1150235Z FAIL TO OBTAIN LOCK MUTEX, SKIP LOCK INFO PRINTING 2019-12-19T03:58:43.1150623Z -------- 2019-12-19T03:58:43.1150878Z FILE I/O 2019-12-19T03:58:43.1151232Z -------- 2019-12-19T03:58:43.1151532Z I/O thread 0 state: waiting for completed aio requests (insert buffer thread) 2019-12-19T03:58:43.1151779Z I/O thread 1 state: waiting for completed aio requests (log thread) 2019-12-19T03:58:43.1152169Z I/O thread 2 state: waiting for completed aio requests (read thread) 2019-12-19T03:58:43.1152413Z I/O thread 3 state: waiting for completed aio requests (read thread) 2019-12-19T03:58:43.1152632Z I/O thread 4 state: waiting for completed aio requests (write thread) 2019-12-19T03:58:43.1152866Z I/O thread 5 state: waiting for completed aio requests (write thread) 2019-12-19T03:58:43.1153091Z Pending normal aio reads: [0, 0] , aio writes: [0, 0] , 2019-12-19T03:58:43.1153530Z ibuf aio reads:, log i/o's:, sync i/o's: 2019-12-19T03:58:43.1154166Z Pending flushes (fsync) log: 0; buffer pool: 0 2019-12-19T03:58:43.1154425Z 332 OS file reads, 1240 OS file writes, 829 OS fsyncs 2019-12-19T03:58:43.1154690Z 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s 2019-12-19T03:58:43.1155170Z ------------------------------------- 2019-12-19T03:58:43.1155485Z INSERT BUFFER AND ADAPTIVE HASH INDEX 2019-12-19T03:58:43.1155957Z ------------------------------------- 2019-12-19T03:58:43.1156249Z Ibuf: size 1, free list len 0, seg size 2, 0 merges 2019-12-19T03:58:43.1156526Z merged operations: 2019-12-19T03:58:43.1156763Z insert 0, delete mark 0, delete 0 2019-12-19T03:58:43.1157006Z discarded operations: 2019-12-19T03:58:43.1157376Z insert 0, delete mark 0, delete 0 2019-12-19T03:58:43.1157576Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1157942Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1158153Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1158357Z Hash table size 2267, node heap has 1 buffer(s) 2019-12-19T03:58:43.1158550Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1159891Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1160280Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1160528Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1161139Z 0.00 hash searches/s, 0.00 non-hash searches/s 2019-12-19T03:58:43.1161655Z --- 2019-12-19T03:58:43.1161948Z LOG 2019-12-19T03:58:43.1162347Z --- 2019-12-19T03:58:43.1162603Z Log sequence number 2102181 2019-12-19T03:58:43.1162834Z Log flushed up to 2102181 2019-12-19T03:58:43.1163049Z Pages flushed up to 2102181 2019-12-19T03:58:43.1163265Z Last checkpoint at 2102172 2019-12-19T03:58:43.1163479Z 0 pending log flushes, 0 pending chkp writes 2019-12-19T03:58:43.1164725Z 723 log i/o's done, 0.00 log i/o's/second 2019-12-19T03:58:43.1165341Z ---------------------- 2019-12-19T03:58:43.1165677Z BUFFER POOL AND MEMORY 2019-12-19T03:58:43.1166140Z ---------------------- 2019-12-19T03:58:43.1166440Z Total large memory allocated 10682368 2019-12-19T03:58:43.1166700Z Dictionary memory allocated 31824 2019-12-19T03:58:43.1166957Z Buffer pool size 511 2019-12-19T03:58:43.1167353Z Free buffers 100 2019-12-19T03:58:43.1167542Z Database pages 410 2019-12-19T03:58:43.1167746Z Old database pages 0 2019-12-19T03:58:43.1167949Z Modified db pages 0 2019-12-19T03:58:43.1168158Z Percent of dirty pages(LRU & free pages): 0.000 2019-12-19T03:58:43.1168559Z Max dirty pages percent: 75.000 2019-12-19T03:58:43.1168781Z Pending reads 0 2019-12-19T03:58:43.1168990Z Pending writes: LRU 0, flush list 0, single page 0 2019-12-19T03:58:43.1169390Z Pages made young 0, not young 0 2019-12-19T03:58:43.1169827Z 0.00 youngs/s, 0.00 non-youngs/s 2019-12-19T03:58:43.1170086Z Pages read 188, created 449, written 467 2019-12-19T03:58:43.1170309Z 0.00 reads/s, 0.00 creates/s, 0.00 writes/s 2019-12-19T03:58:43.1170527Z No buffer pool page gets since the last printout 2019-12-19T03:58:43.1170754Z Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s 2019-12-19T03:58:43.1170965Z LRU len: 410, unzip_LRU len: 0 2019-12-19T03:58:43.1171354Z I/O sum[0]:cur[0], unzip sum[0]:cur[0] 2019-12-19T03:58:43.1171958Z -------------- 2019-12-19T03:58:43.1172229Z ROW OPERATIONS 2019-12-19T03:58:43.1172794Z -------------- 2019-12-19T03:58:43.1173057Z 0 queries inside InnoDB, 0 queries in queue 2019-12-19T03:58:43.1174081Z 0 read views open inside InnoDB 2019-12-19T03:58:43.1174620Z Process ID=102456, Main thread ID=139857655457536, state: sleeping 2019-12-19T03:58:43.1175049Z Number of rows inserted 62, updated 264, deleted 0, read 328 2019-12-19T03:58:43.1175384Z 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s 2019-12-19T03:58:43.1175676Z Number of system rows inserted 0, updated 0, deleted 0, read 0 2019-12-19T03:58:43.1175952Z 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s 2019-12-19T03:58:43.1176521Z ---------------------------- 2019-12-19T03:58:43.1177019Z END OF INNODB MONITOR OUTPUT 2019-12-19T03:58:43.1177237Z ============================ 2019-12-19T03:58:43.1177470Z InnoDB: ###### Diagnostic info printed to the standard error stream 2019-12-19T03:58:43.1177954Z 2019-12-19 3:48:20 0 [Warning] InnoDB: A long semaphore wait: 2019-12-19T03:58:43.1178684Z --Thread 139858299688704 has waited at lock0lock.cc line 6267 for 334.00 seconds the semaphore: 2019-12-19T03:58:43.1179043Z Mutex at 0x55e556b0c200, Mutex LOCK_SYS created lock0lock.cc:460, lock var 2 2019-12-19T03:58:43.1179282Z 2019-12-19T03:58:43.1179763Z 2019-12-19 3:48:20 0 [Warning] InnoDB: A long semaphore wait: 2019-12-19T03:58:43.1180360Z --Thread 139858053515008 has waited at trx0trx.cc line 2074 for 334.00 seconds the semaphore: 2019-12-19T03:58:43.1180848Z Mutex at 0x7f333e45d110, Mutex TRX created trx0trx.cc:207, lock var 2 2019-12-19T03:58:43.1181074Z 2019-12-19T03:58:43.1181737Z 2019-12-19 3:48:20 0 [Note] InnoDB: A semaphore wait: 2019-12-19T03:58:43.1182346Z --Thread 139858299688704 has waited at lock0lock.cc line 6267 for 334.00 seconds the semaphore: 2019-12-19T03:58:43.1182681Z Mutex at 0x55e556b0c200, Mutex LOCK_SYS created lock0lock.cc:460, lock var 2 2019-12-19T03:58:43.1182912Z 2019-12-19T03:58:43.1183520Z 2019-12-19 3:48:20 0 [Note] InnoDB: A semaphore wait: 2019-12-19T03:58:43.1184635Z --Thread 139858053515008 has waited at trx0trx.cc line 2074 for 334.00 seconds the semaphore: 2019-12-19T03:58:43.1185031Z Mutex at 0x7f333e45d110, Mutex TRX created trx0trx.cc:207, lock var 2 2019-12-19T03:58:43.1185312Z 2019-12-19T03:58:43.1185555Z InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: 2019-12-19T03:58:43.1185830Z InnoDB: Pending reads 0, writes 0 2019-12-19T03:58:43.1186052Z 2019-12-19T03:58:43.1186289Z ===================================== 2019-12-19T03:58:43.1186823Z 2019-12-19 03:48:23 0x7f331bfff700 INNODB MONITOR OUTPUT 2019-12-19T03:58:43.1187329Z ===================================== 2019-12-19T03:58:43.1255278Z Per second averages calculated from the last 20 seconds 2019-12-19T03:58:43.1256098Z ----------------- 2019-12-19T03:58:43.1256376Z BACKGROUND THREAD 2019-12-19T03:58:43.1256807Z ----------------- 2019-12-19T03:58:43.1257382Z srv_master_thread loops: 1 srv_active, 0 srv_shutdown, 338 srv_idle 2019-12-19T03:58:43.1257607Z srv_master_thread log flush and writes: 339 2019-12-19T03:58:43.1258455Z ---------- 2019-12-19T03:58:43.1258656Z SEMAPHORES 2019-12-19T03:58:43.1258991Z ---------- 2019-12-19T03:58:43.1259374Z OS WAIT ARRAY INFO: reservation count 293 2019-12-19T03:58:43.1260016Z --Thread 139858299688704 has waited at lock0lock.cc line 6267 for 337.00 seconds the semaphore: 2019-12-19T03:58:43.1260266Z Mutex at 0x55e556b0c200, Mutex LOCK_SYS created lock0lock.cc:460, lock var 2 2019-12-19T03:58:43.1260444Z 2019-12-19T03:58:43.1260863Z --Thread 139858053515008 has waited at trx0trx.cc line 2074 for 337.00 seconds the semaphore: 2019-12-19T03:58:43.1261118Z Mutex at 0x7f333e45d110, Mutex TRX created trx0trx.cc:207, lock var 2 2019-12-19T03:58:43.1261268Z 2019-12-19T03:58:43.1261432Z OS WAIT ARRAY INFO: signal count 166 2019-12-19T03:58:43.1261807Z RW-shared spins 0, rounds 388, OS waits 180 2019-12-19T03:58:43.1262193Z RW-excl spins 0, rounds 0, OS waits 0 2019-12-19T03:58:43.1262590Z RW-sx spins 0, rounds 0, OS waits 0 2019-12-19T03:58:43.1263024Z Spin rounds per wait: 388.00 RW-shared, 0.00 RW-excl, 0.00 RW-sx 2019-12-19T03:58:43.1263262Z FAIL TO OBTAIN LOCK MUTEX, SKIP LOCK INFO PRINTING 2019-12-19T03:58:43.1264172Z -------- 2019-12-19T03:58:43.1264467Z FILE I/O 2019-12-19T03:58:43.1264874Z -------- 2019-12-19T03:58:43.1265138Z I/O thread 0 state: waiting for completed aio requests (insert buffer thread) 2019-12-19T03:58:43.1265386Z I/O thread 1 state: waiting for completed aio requests (log thread) 2019-12-19T03:58:43.1265611Z I/O thread 2 state: waiting for completed aio requests (read thread) 2019-12-19T03:58:43.1265851Z I/O thread 3 state: waiting for completed aio requests (read thread) 2019-12-19T03:58:43.1266092Z I/O thread 4 state: waiting for completed aio requests (write thread) 2019-12-19T03:58:43.1266333Z I/O thread 5 state: waiting for completed aio requests (write thread) 2019-12-19T03:58:43.1266569Z Pending normal aio reads: [0, 0] , aio writes: [0, 0] , 2019-12-19T03:58:43.1267006Z ibuf aio reads:, log i/o's:, sync i/o's: 2019-12-19T03:58:43.1267412Z Pending flushes (fsync) log: 0; buffer pool: 0 2019-12-19T03:58:43.1267828Z 332 OS file reads, 1240 OS file writes, 829 OS fsyncs 2019-12-19T03:58:43.1268035Z 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s 2019-12-19T03:58:43.1268394Z ------------------------------------- 2019-12-19T03:58:43.1268620Z INSERT BUFFER AND ADAPTIVE HASH INDEX 2019-12-19T03:58:43.1268982Z ------------------------------------- 2019-12-19T03:58:43.1269207Z Ibuf: size 1, free list len 0, seg size 2, 0 merges 2019-12-19T03:58:43.1269392Z merged operations: 2019-12-19T03:58:43.1269546Z insert 0, delete mark 0, delete 0 2019-12-19T03:58:43.1269721Z discarded operations: 2019-12-19T03:58:43.1269895Z insert 0, delete mark 0, delete 0 2019-12-19T03:58:43.1270076Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1270243Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1270433Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1270619Z Hash table size 2267, node heap has 1 buffer(s) 2019-12-19T03:58:43.1270803Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1270990Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1271170Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1271354Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1271736Z 0.00 hash searches/s, 0.00 non-hash searches/s 2019-12-19T03:58:43.1272106Z --- 2019-12-19T03:58:43.1272293Z LOG 2019-12-19T03:58:43.1272644Z --- 2019-12-19T03:58:43.1272847Z Log sequence number 2102181 2019-12-19T03:58:43.1273028Z Log flushed up to 2102181 2019-12-19T03:58:43.1273182Z Pages flushed up to 2102181 2019-12-19T03:58:43.1273360Z Last checkpoint at 2102172 2019-12-19T03:58:43.1273536Z 0 pending log flushes, 0 pending chkp writes 2019-12-19T03:58:43.1274693Z 723 log i/o's done, 0.00 log i/o's/second 2019-12-19T03:58:43.1275184Z ---------------------- 2019-12-19T03:58:43.1275421Z BUFFER POOL AND MEMORY 2019-12-19T03:58:43.1275834Z ---------------------- 2019-12-19T03:58:43.1276087Z Total large memory allocated 10682368 2019-12-19T03:58:43.1276306Z Dictionary memory allocated 31824 2019-12-19T03:58:43.1276666Z Buffer pool size 511 2019-12-19T03:58:43.1276891Z Free buffers 100 2019-12-19T03:58:43.1277389Z Database pages 410 2019-12-19T03:58:43.1277786Z Old database pages 0 2019-12-19T03:58:43.1277948Z Modified db pages 0 2019-12-19T03:58:43.1278129Z Percent of dirty pages(LRU & free pages): 0.000 2019-12-19T03:58:43.1278324Z Max dirty pages percent: 75.000 2019-12-19T03:58:43.1278507Z Pending reads 0 2019-12-19T03:58:43.1278675Z Pending writes: LRU 0, flush list 0, single page 0 2019-12-19T03:58:43.1278870Z Pages made young 0, not young 0 2019-12-19T03:58:43.1279289Z 0.00 youngs/s, 0.00 non-youngs/s 2019-12-19T03:58:43.1279532Z Pages read 188, created 449, written 467 2019-12-19T03:58:43.1279730Z 0.00 reads/s, 0.00 creates/s, 0.00 writes/s 2019-12-19T03:58:43.1279907Z No buffer pool page gets since the last printout 2019-12-19T03:58:43.1280113Z Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s 2019-12-19T03:58:43.1280319Z LRU len: 410, unzip_LRU len: 0 2019-12-19T03:58:43.1280637Z I/O sum[0]:cur[0], unzip sum[0]:cur[0] 2019-12-19T03:58:43.1281025Z -------------- 2019-12-19T03:58:43.1281233Z ROW OPERATIONS 2019-12-19T03:58:43.1281580Z -------------- 2019-12-19T03:58:43.1281798Z 0 queries inside InnoDB, 0 queries in queue 2019-12-19T03:58:43.1281992Z 0 read views open inside InnoDB 2019-12-19T03:58:43.1282172Z Process ID=102456, Main thread ID=139857655457536, state: sleeping 2019-12-19T03:58:43.1282379Z Number of rows inserted 62, updated 264, deleted 0, read 328 2019-12-19T03:58:43.1282587Z 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s 2019-12-19T03:58:43.1282790Z Number of system rows inserted 0, updated 0, deleted 0, read 0 2019-12-19T03:58:43.1282996Z 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s 2019-12-19T03:58:43.1283359Z ---------------------------- 2019-12-19T03:58:43.1283935Z END OF INNODB MONITOR OUTPUT 2019-12-19T03:58:43.1284189Z ============================ 2019-12-19T03:58:43.1284355Z 2019-12-19T03:58:43.1284574Z ===================================== 2019-12-19T03:58:43.1285091Z 2019-12-19 03:48:43 0x7f331bfff700 INNODB MONITOR OUTPUT 2019-12-19T03:58:43.1285368Z ===================================== 2019-12-19T03:58:43.1285580Z Per second averages calculated from the last 20 seconds 2019-12-19T03:58:43.1286006Z ----------------- 2019-12-19T03:58:43.1286251Z BACKGROUND THREAD 2019-12-19T03:58:43.1286657Z ----------------- 2019-12-19T03:58:43.1286901Z srv_master_thread loops: 1 srv_active, 0 srv_shutdown, 358 srv_idle 2019-12-19T03:58:43.1287377Z srv_master_thread log flush and writes: 359 2019-12-19T03:58:43.1287736Z ---------- 2019-12-19T03:58:43.1287946Z SEMAPHORES 2019-12-19T03:58:43.1288289Z ---------- 2019-12-19T03:58:43.1288484Z OS WAIT ARRAY INFO: reservation count 293 2019-12-19T03:58:43.1288940Z --Thread 139858299688704 has waited at lock0lock.cc line 6267 for 357.00 seconds the semaphore: 2019-12-19T03:58:43.1289215Z Mutex at 0x55e556b0c200, Mutex LOCK_SYS created lock0lock.cc:460, lock var 2 2019-12-19T03:58:43.1289400Z 2019-12-19T03:58:43.1289871Z --Thread 139858053515008 has waited at trx0trx.cc line 2074 for 357.00 seconds the semaphore: 2019-12-19T03:58:43.1290149Z Mutex at 0x7f333e45d110, Mutex TRX created trx0trx.cc:207, lock var 2 2019-12-19T03:58:43.1290484Z 2019-12-19T03:58:43.1290639Z OS WAIT ARRAY INFO: signal count 166 2019-12-19T03:58:43.1291025Z RW-shared spins 0, rounds 388, OS waits 180 2019-12-19T03:58:43.1291439Z RW-excl spins 0, rounds 0, OS waits 0 2019-12-19T03:58:43.1292023Z RW-sx spins 0, rounds 0, OS waits 0 2019-12-19T03:58:43.1292459Z Spin rounds per wait: 388.00 RW-shared, 0.00 RW-excl, 0.00 RW-sx 2019-12-19T03:58:43.1292701Z FAIL TO OBTAIN LOCK MUTEX, SKIP LOCK INFO PRINTING 2019-12-19T03:58:43.1293061Z -------- 2019-12-19T03:58:43.1293274Z FILE I/O 2019-12-19T03:58:43.1293937Z -------- 2019-12-19T03:58:43.1294232Z I/O thread 0 state: waiting for completed aio requests (insert buffer thread) 2019-12-19T03:58:43.1294489Z I/O thread 1 state: waiting for completed aio requests (log thread) 2019-12-19T03:58:43.1295011Z I/O thread 2 state: waiting for completed aio requests (read thread) 2019-12-19T03:58:43.1295297Z I/O thread 3 state: waiting for completed aio requests (read thread) 2019-12-19T03:58:43.1295547Z I/O thread 4 state: waiting for completed aio requests (write thread) 2019-12-19T03:58:43.1295791Z I/O thread 5 state: waiting for completed aio requests (write thread) 2019-12-19T03:58:43.1296027Z Pending normal aio reads: [0, 0] , aio writes: [0, 0] , 2019-12-19T03:58:43.1296529Z ibuf aio reads:, log i/o's:, sync i/o's: 2019-12-19T03:58:43.1296785Z Pending flushes (fsync) log: 0; buffer pool: 0 2019-12-19T03:58:43.1297017Z 332 OS file reads, 1240 OS file writes, 829 OS fsyncs 2019-12-19T03:58:43.1297609Z 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s 2019-12-19T03:58:43.1297987Z ------------------------------------- 2019-12-19T03:58:43.1298208Z INSERT BUFFER AND ADAPTIVE HASH INDEX 2019-12-19T03:58:43.1298555Z ------------------------------------- 2019-12-19T03:58:43.1298908Z Ibuf: size 1, free list len 0, seg size 2, 0 merges 2019-12-19T03:58:43.1299103Z merged operations: 2019-12-19T03:58:43.1299274Z insert 0, delete mark 0, delete 0 2019-12-19T03:58:43.1299434Z discarded operations: 2019-12-19T03:58:43.1299608Z insert 0, delete mark 0, delete 0 2019-12-19T03:58:43.1299791Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1299976Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1300162Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1300328Z Hash table size 2267, node heap has 1 buffer(s) 2019-12-19T03:58:43.1300514Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1300699Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1300883Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1301067Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1301456Z 0.00 hash searches/s, 0.00 non-hash searches/s 2019-12-19T03:58:43.1301834Z --- 2019-12-19T03:58:43.1302059Z LOG 2019-12-19T03:58:43.1302380Z --- 2019-12-19T03:58:43.1302568Z Log sequence number 2102181 2019-12-19T03:58:43.1302746Z Log flushed up to 2102181 2019-12-19T03:58:43.1302918Z Pages flushed up to 2102181 2019-12-19T03:58:43.1303090Z Last checkpoint at 2102172 2019-12-19T03:58:43.1303249Z 0 pending log flushes, 0 pending chkp writes 2019-12-19T03:58:43.1304022Z 723 log i/o's done, 0.00 log i/o's/second 2019-12-19T03:58:43.1304527Z ---------------------- 2019-12-19T03:58:43.1304780Z BUFFER POOL AND MEMORY 2019-12-19T03:58:43.1305180Z ---------------------- 2019-12-19T03:58:43.1305434Z Total large memory allocated 10682368 2019-12-19T03:58:43.1305652Z Dictionary memory allocated 31824 2019-12-19T03:58:43.1305868Z Buffer pool size 511 2019-12-19T03:58:43.1306084Z Free buffers 100 2019-12-19T03:58:43.1306279Z Database pages 410 2019-12-19T03:58:43.1306489Z Old database pages 0 2019-12-19T03:58:43.1306700Z Modified db pages 0 2019-12-19T03:58:43.1306918Z Percent of dirty pages(LRU & free pages): 0.000 2019-12-19T03:58:43.1307299Z Max dirty pages percent: 75.000 2019-12-19T03:58:43.1307492Z Pending reads 0 2019-12-19T03:58:43.1307683Z Pending writes: LRU 0, flush list 0, single page 0 2019-12-19T03:58:43.1307882Z Pages made young 0, not young 0 2019-12-19T03:58:43.1308259Z 0.00 youngs/s, 0.00 non-youngs/s 2019-12-19T03:58:43.1308497Z Pages read 188, created 449, written 467 2019-12-19T03:58:43.1308698Z 0.00 reads/s, 0.00 creates/s, 0.00 writes/s 2019-12-19T03:58:43.1308906Z No buffer pool page gets since the last printout 2019-12-19T03:58:43.1309197Z Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s 2019-12-19T03:58:43.1309394Z LRU len: 410, unzip_LRU len: 0 2019-12-19T03:58:43.1309592Z I/O sum[0]:cur[0], unzip sum[0]:cur[0] 2019-12-19T03:58:43.1309985Z -------------- 2019-12-19T03:58:43.1310214Z ROW OPERATIONS 2019-12-19T03:58:43.1310580Z -------------- 2019-12-19T03:58:43.1310807Z 0 queries inside InnoDB, 0 queries in queue 2019-12-19T03:58:43.1311156Z 0 read views open inside InnoDB 2019-12-19T03:58:43.1311374Z Process ID=102456, Main thread ID=139857655457536, state: sleeping 2019-12-19T03:58:43.1311576Z Number of rows inserted 62, updated 264, deleted 0, read 328 2019-12-19T03:58:43.1311793Z 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s 2019-12-19T03:58:43.1312176Z Number of system rows inserted 0, updated 0, deleted 0, read 0 2019-12-19T03:58:43.1312386Z 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s 2019-12-19T03:58:43.1312800Z ---------------------------- 2019-12-19T03:58:43.1313012Z END OF INNODB MONITOR OUTPUT 2019-12-19T03:58:43.1313201Z ============================ 2019-12-19T03:58:43.1313552Z InnoDB: ###### Diagnostic info printed to the standard error stream 2019-12-19T03:58:43.1314549Z 2019-12-19 3:48:51 0 [Warning] InnoDB: A long semaphore wait: 2019-12-19T03:58:43.1315169Z --Thread 139858299688704 has waited at lock0lock.cc line 6267 for 365.00 seconds the semaphore: 2019-12-19T03:58:43.1315464Z Mutex at 0x55e556b0c200, Mutex LOCK_SYS created lock0lock.cc:460, lock var 2 2019-12-19T03:58:43.1315810Z 2019-12-19T03:58:43.1316305Z 2019-12-19 3:48:51 0 [Warning] InnoDB: A long semaphore wait: 2019-12-19T03:58:43.1316862Z --Thread 139858053515008 has waited at trx0trx.cc line 2074 for 365.00 seconds the semaphore: 2019-12-19T03:58:43.1317168Z Mutex at 0x7f333e45d110, Mutex TRX created trx0trx.cc:207, lock var 2 2019-12-19T03:58:43.1317366Z 2019-12-19T03:58:43.1318079Z 2019-12-19 3:48:51 0 [Note] InnoDB: A semaphore wait: 2019-12-19T03:58:43.1318737Z --Thread 139858299688704 has waited at lock0lock.cc line 6267 for 365.00 seconds the semaphore: 2019-12-19T03:58:43.1319007Z Mutex at 0x55e556b0c200, Mutex LOCK_SYS created lock0lock.cc:460, lock var 2 2019-12-19T03:58:43.1319182Z 2019-12-19T03:58:43.1319590Z 2019-12-19 3:48:51 0 [Note] InnoDB: A semaphore wait: 2019-12-19T03:58:43.1320086Z --Thread 139858053515008 has waited at trx0trx.cc line 2074 for 365.00 seconds the semaphore: 2019-12-19T03:58:43.1320341Z Mutex at 0x7f333e45d110, Mutex TRX created trx0trx.cc:207, lock var 2 2019-12-19T03:58:43.1320700Z 2019-12-19T03:58:43.1320885Z InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: 2019-12-19T03:58:43.1321086Z InnoDB: Pending reads 0, writes 0 2019-12-19T03:58:43.1321229Z 2019-12-19T03:58:43.1321405Z ===================================== 2019-12-19T03:58:43.1321829Z 2019-12-19 03:49:03 0x7f331bfff700 INNODB MONITOR OUTPUT 2019-12-19T03:58:43.1322049Z ===================================== 2019-12-19T03:58:43.1322253Z Per second averages calculated from the last 20 seconds 2019-12-19T03:58:43.1322624Z ----------------- 2019-12-19T03:58:43.1322843Z BACKGROUND THREAD 2019-12-19T03:58:43.1323177Z ----------------- 2019-12-19T03:58:43.1323406Z srv_master_thread loops: 1 srv_active, 0 srv_shutdown, 378 srv_idle 2019-12-19T03:58:43.1324386Z srv_master_thread log flush and writes: 379 2019-12-19T03:58:43.1324900Z ---------- 2019-12-19T03:58:43.1325150Z SEMAPHORES 2019-12-19T03:58:43.1325539Z ---------- 2019-12-19T03:58:43.1325792Z OS WAIT ARRAY INFO: reservation count 293 2019-12-19T03:58:43.1326321Z --Thread 139858299688704 has waited at lock0lock.cc line 6267 for 377.00 seconds the semaphore: 2019-12-19T03:58:43.1326628Z Mutex at 0x55e556b0c200, Mutex LOCK_SYS created lock0lock.cc:460, lock var 2 2019-12-19T03:58:43.1326818Z 2019-12-19T03:58:43.1327509Z --Thread 139858053515008 has waited at trx0trx.cc line 2074 for 377.00 seconds the semaphore: 2019-12-19T03:58:43.1328090Z Mutex at 0x7f333e45d110, Mutex TRX created trx0trx.cc:207, lock var 2 2019-12-19T03:58:43.1328242Z 2019-12-19T03:58:43.1328403Z OS WAIT ARRAY INFO: signal count 166 2019-12-19T03:58:43.1328774Z RW-shared spins 0, rounds 388, OS waits 180 2019-12-19T03:58:43.1329177Z RW-excl spins 0, rounds 0, OS waits 0 2019-12-19T03:58:43.1329559Z RW-sx spins 0, rounds 0, OS waits 0 2019-12-19T03:58:43.1329992Z Spin rounds per wait: 388.00 RW-shared, 0.00 RW-excl, 0.00 RW-sx 2019-12-19T03:58:43.1330227Z FAIL TO OBTAIN LOCK MUTEX, SKIP LOCK INFO PRINTING 2019-12-19T03:58:43.1330724Z -------- 2019-12-19T03:58:43.1330921Z FILE I/O 2019-12-19T03:58:43.1331247Z -------- 2019-12-19T03:58:43.1331466Z I/O thread 0 state: waiting for completed aio requests (insert buffer thread) 2019-12-19T03:58:43.1331673Z I/O thread 1 state: waiting for completed aio requests (log thread) 2019-12-19T03:58:43.1331877Z I/O thread 2 state: waiting for completed aio requests (read thread) 2019-12-19T03:58:43.1332064Z I/O thread 3 state: waiting for completed aio requests (read thread) 2019-12-19T03:58:43.1332264Z I/O thread 4 state: waiting for completed aio requests (write thread) 2019-12-19T03:58:43.1332653Z I/O thread 5 state: waiting for completed aio requests (write thread) 2019-12-19T03:58:43.1332851Z Pending normal aio reads: [0, 0] , aio writes: [0, 0] , 2019-12-19T03:58:43.1333238Z ibuf aio reads:, log i/o's:, sync i/o's: 2019-12-19T03:58:43.1333451Z Pending flushes (fsync) log: 0; buffer pool: 0 2019-12-19T03:58:43.1334007Z 332 OS file reads, 1240 OS file writes, 829 OS fsyncs 2019-12-19T03:58:43.1334415Z 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s 2019-12-19T03:58:43.1415169Z ------------------------------------- 2019-12-19T03:58:43.1415555Z INSERT BUFFER AND ADAPTIVE HASH INDEX 2019-12-19T03:58:43.1416300Z ------------------------------------- 2019-12-19T03:58:43.1416566Z Ibuf: size 1, free list len 0, seg size 2, 0 merges 2019-12-19T03:58:43.1416771Z merged operations: 2019-12-19T03:58:43.1416955Z insert 0, delete mark 0, delete 0 2019-12-19T03:58:43.1417130Z discarded operations: 2019-12-19T03:58:43.1417316Z insert 0, delete mark 0, delete 0 2019-12-19T03:58:43.1417512Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1417712Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1418055Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1418247Z Hash table size 2267, node heap has 1 buffer(s) 2019-12-19T03:58:43.1418442Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1418649Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1418841Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1419016Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1419433Z 0.00 hash searches/s, 0.00 non-hash searches/s 2019-12-19T03:58:43.1419824Z --- 2019-12-19T03:58:43.1420040Z LOG 2019-12-19T03:58:43.1420357Z --- 2019-12-19T03:58:43.1420569Z Log sequence number 2102181 2019-12-19T03:58:43.1420753Z Log flushed up to 2102181 2019-12-19T03:58:43.1420937Z Pages flushed up to 2102181 2019-12-19T03:58:43.1421100Z Last checkpoint at 2102172 2019-12-19T03:58:43.1421292Z 0 pending log flushes, 0 pending chkp writes 2019-12-19T03:58:43.1421691Z 723 log i/o's done, 0.00 log i/o's/second 2019-12-19T03:58:43.1422247Z ---------------------- 2019-12-19T03:58:43.1422462Z BUFFER POOL AND MEMORY 2019-12-19T03:58:43.1422794Z ---------------------- 2019-12-19T03:58:43.1423009Z Total large memory allocated 10682368 2019-12-19T03:58:43.1423146Z Dictionary memory allocated 31824 2019-12-19T03:58:43.1423286Z Buffer pool size 511 2019-12-19T03:58:43.1423391Z Free buffers 100 2019-12-19T03:58:43.1423563Z Database pages 410 2019-12-19T03:58:43.1423735Z Old database pages 0 2019-12-19T03:58:43.1423907Z Modified db pages 0 2019-12-19T03:58:43.1424070Z Percent of dirty pages(LRU & free pages): 0.000 2019-12-19T03:58:43.1424253Z Max dirty pages percent: 75.000 2019-12-19T03:58:43.1424434Z Pending reads 0 2019-12-19T03:58:43.1424613Z Pending writes: LRU 0, flush list 0, single page 0 2019-12-19T03:58:43.1424960Z Pages made young 0, not young 0 2019-12-19T03:58:43.1425339Z 0.00 youngs/s, 0.00 non-youngs/s 2019-12-19T03:58:43.1425898Z Pages read 188, created 449, written 467 2019-12-19T03:58:43.1426092Z 0.00 reads/s, 0.00 creates/s, 0.00 writes/s 2019-12-19T03:58:43.1426291Z No buffer pool page gets since the last printout 2019-12-19T03:58:43.1426484Z Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s 2019-12-19T03:58:43.1426689Z LRU len: 410, unzip_LRU len: 0 2019-12-19T03:58:43.1427043Z I/O sum[0]:cur[0], unzip sum[0]:cur[0] 2019-12-19T03:58:43.1427433Z -------------- 2019-12-19T03:58:43.1427638Z ROW OPERATIONS 2019-12-19T03:58:43.1427991Z -------------- 2019-12-19T03:58:43.1428208Z 0 queries inside InnoDB, 0 queries in queue 2019-12-19T03:58:43.1428404Z 0 read views open inside InnoDB 2019-12-19T03:58:43.1428598Z Process ID=102456, Main thread ID=139857655457536, state: sleeping 2019-12-19T03:58:43.1428793Z Number of rows inserted 62, updated 264, deleted 0, read 328 2019-12-19T03:58:43.1429002Z 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s 2019-12-19T03:58:43.1429207Z Number of system rows inserted 0, updated 0, deleted 0, read 0 2019-12-19T03:58:43.1429410Z 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s 2019-12-19T03:58:43.1429793Z ---------------------------- 2019-12-19T03:58:43.1430154Z END OF INNODB MONITOR OUTPUT 2019-12-19T03:58:43.1430335Z ============================ 2019-12-19T03:58:43.1430537Z InnoDB: ###### Diagnostic info printed to the standard error stream 2019-12-19T03:58:43.1431110Z 2019-12-19 3:49:22 0 [Warning] InnoDB: A long semaphore wait: 2019-12-19T03:58:43.1431583Z --Thread 139858299688704 has waited at lock0lock.cc line 6267 for 396.00 seconds the semaphore: 2019-12-19T03:58:43.1431864Z Mutex at 0x55e556b0c200, Mutex LOCK_SYS created lock0lock.cc:460, lock var 2 2019-12-19T03:58:43.1432046Z 2019-12-19T03:58:43.1432472Z 2019-12-19 3:49:22 0 [Warning] InnoDB: A long semaphore wait: 2019-12-19T03:58:43.1432962Z --Thread 139858053515008 has waited at trx0trx.cc line 2074 for 396.00 seconds the semaphore: 2019-12-19T03:58:43.1433228Z Mutex at 0x7f333e45d110, Mutex TRX created trx0trx.cc:207, lock var 2 2019-12-19T03:58:43.1433402Z 2019-12-19T03:58:43.1433789Z 2019-12-19 3:49:22 0 [Note] InnoDB: A semaphore wait: 2019-12-19T03:58:43.1434547Z --Thread 139858299688704 has waited at lock0lock.cc line 6267 for 396.00 seconds the semaphore: 2019-12-19T03:58:43.1434822Z Mutex at 0x55e556b0c200, Mutex LOCK_SYS created lock0lock.cc:460, lock var 2 2019-12-19T03:58:43.1435019Z 2019-12-19T03:58:43.1435410Z 2019-12-19 3:49:22 0 [Note] InnoDB: A semaphore wait: 2019-12-19T03:58:43.1435921Z --Thread 139858053515008 has waited at trx0trx.cc line 2074 for 396.00 seconds the semaphore: 2019-12-19T03:58:43.1436190Z Mutex at 0x7f333e45d110, Mutex TRX created trx0trx.cc:207, lock var 2 2019-12-19T03:58:43.1437534Z 2019-12-19T03:58:43.1437862Z InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: 2019-12-19T03:58:43.1438101Z InnoDB: Pending reads 0, writes 0 2019-12-19T03:58:43.1438266Z 2019-12-19T03:58:43.1438504Z ===================================== 2019-12-19T03:58:43.1439055Z 2019-12-19 03:49:23 0x7f331bfff700 INNODB MONITOR OUTPUT 2019-12-19T03:58:43.1439328Z ===================================== 2019-12-19T03:58:43.1439556Z Per second averages calculated from the last 20 seconds 2019-12-19T03:58:43.1439963Z ----------------- 2019-12-19T03:58:43.1440209Z BACKGROUND THREAD 2019-12-19T03:58:43.1441087Z ----------------- 2019-12-19T03:58:43.1441308Z srv_master_thread loops: 1 srv_active, 0 srv_shutdown, 398 srv_idle 2019-12-19T03:58:43.1441490Z srv_master_thread log flush and writes: 399 2019-12-19T03:58:43.1441830Z ---------- 2019-12-19T03:58:43.1442030Z SEMAPHORES 2019-12-19T03:58:43.1442354Z ---------- 2019-12-19T03:58:43.1442540Z OS WAIT ARRAY INFO: reservation count 293 2019-12-19T03:58:43.1442970Z --Thread 139858299688704 has waited at lock0lock.cc line 6267 for 397.00 seconds the semaphore: 2019-12-19T03:58:43.1443225Z Mutex at 0x55e556b0c200, Mutex LOCK_SYS created lock0lock.cc:460, lock var 2 2019-12-19T03:58:43.1443572Z 2019-12-19T03:58:43.1444351Z --Thread 139858053515008 has waited at trx0trx.cc line 2074 for 397.00 seconds the semaphore: 2019-12-19T03:58:43.1444694Z Mutex at 0x7f333e45d110, Mutex TRX created trx0trx.cc:207, lock var 2 2019-12-19T03:58:43.1444900Z 2019-12-19T03:58:43.1445083Z OS WAIT ARRAY INFO: signal count 166 2019-12-19T03:58:43.1445541Z RW-shared spins 0, rounds 388, OS waits 180 2019-12-19T03:58:43.1446217Z RW-excl spins 0, rounds 0, OS waits 0 2019-12-19T03:58:43.1446702Z RW-sx spins 0, rounds 0, OS waits 0 2019-12-19T03:58:43.1447203Z Spin rounds per wait: 388.00 RW-shared, 0.00 RW-excl, 0.00 RW-sx 2019-12-19T03:58:43.1447631Z FAIL TO OBTAIN LOCK MUTEX, SKIP LOCK INFO PRINTING 2019-12-19T03:58:43.1448581Z -------- 2019-12-19T03:58:43.1448805Z FILE I/O 2019-12-19T03:58:43.1449144Z -------- 2019-12-19T03:58:43.1449353Z I/O thread 0 state: waiting for completed aio requests (insert buffer thread) 2019-12-19T03:58:43.1449570Z I/O thread 1 state: waiting for completed aio requests (log thread) 2019-12-19T03:58:43.1449780Z I/O thread 2 state: waiting for completed aio requests (read thread) 2019-12-19T03:58:43.1449988Z I/O thread 3 state: waiting for completed aio requests (read thread) 2019-12-19T03:58:43.1450196Z I/O thread 4 state: waiting for completed aio requests (write thread) 2019-12-19T03:58:43.1450388Z I/O thread 5 state: waiting for completed aio requests (write thread) 2019-12-19T03:58:43.1450747Z Pending normal aio reads: [0, 0] , aio writes: [0, 0] , 2019-12-19T03:58:43.1451172Z ibuf aio reads:, log i/o's:, sync i/o's: 2019-12-19T03:58:43.1451562Z Pending flushes (fsync) log: 0; buffer pool: 0 2019-12-19T03:58:43.1451755Z 332 OS file reads, 1240 OS file writes, 829 OS fsyncs 2019-12-19T03:58:43.1451940Z 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s 2019-12-19T03:58:43.1452323Z ------------------------------------- 2019-12-19T03:58:43.1452544Z INSERT BUFFER AND ADAPTIVE HASH INDEX 2019-12-19T03:58:43.1452912Z ------------------------------------- 2019-12-19T03:58:43.1453120Z Ibuf: size 1, free list len 0, seg size 2, 0 merges 2019-12-19T03:58:43.1453312Z merged operations: 2019-12-19T03:58:43.1453483Z insert 0, delete mark 0, delete 0 2019-12-19T03:58:43.1454109Z discarded operations: 2019-12-19T03:58:43.1454338Z insert 0, delete mark 0, delete 0 2019-12-19T03:58:43.1454543Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1454782Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1455165Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1455352Z Hash table size 2267, node heap has 1 buffer(s) 2019-12-19T03:58:43.1455524Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1455750Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1455975Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1456193Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1456700Z 0.00 hash searches/s, 0.00 non-hash searches/s 2019-12-19T03:58:43.1457129Z --- 2019-12-19T03:58:43.1457688Z LOG 2019-12-19T03:58:43.1458159Z --- 2019-12-19T03:58:43.1458359Z Log sequence number 2102181 2019-12-19T03:58:43.1458519Z Log flushed up to 2102181 2019-12-19T03:58:43.1458692Z Pages flushed up to 2102181 2019-12-19T03:58:43.1458862Z Last checkpoint at 2102172 2019-12-19T03:58:43.1459037Z 0 pending log flushes, 0 pending chkp writes 2019-12-19T03:58:43.1459407Z 723 log i/o's done, 0.00 log i/o's/second 2019-12-19T03:58:43.1459790Z ---------------------- 2019-12-19T03:58:43.1459997Z BUFFER POOL AND MEMORY 2019-12-19T03:58:43.1460332Z ---------------------- 2019-12-19T03:58:43.1460524Z Total large memory allocated 10682368 2019-12-19T03:58:43.1460706Z Dictionary memory allocated 31824 2019-12-19T03:58:43.1460883Z Buffer pool size 511 2019-12-19T03:58:43.1461062Z Free buffers 100 2019-12-19T03:58:43.1461236Z Database pages 410 2019-12-19T03:58:43.1461394Z Old database pages 0 2019-12-19T03:58:43.1461565Z Modified db pages 0 2019-12-19T03:58:43.1461743Z Percent of dirty pages(LRU & free pages): 0.000 2019-12-19T03:58:43.1461929Z Max dirty pages percent: 75.000 2019-12-19T03:58:43.1462092Z Pending reads 0 2019-12-19T03:58:43.1462270Z Pending writes: LRU 0, flush list 0, single page 0 2019-12-19T03:58:43.1462458Z Pages made young 0, not young 0 2019-12-19T03:58:43.1462846Z 0.00 youngs/s, 0.00 non-youngs/s 2019-12-19T03:58:43.1463049Z Pages read 188, created 449, written 467 2019-12-19T03:58:43.1463390Z 0.00 reads/s, 0.00 creates/s, 0.00 writes/s 2019-12-19T03:58:43.1463922Z No buffer pool page gets since the last printout 2019-12-19T03:58:43.1464145Z Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s 2019-12-19T03:58:43.1464394Z LRU len: 410, unzip_LRU len: 0 2019-12-19T03:58:43.1464592Z I/O sum[0]:cur[0], unzip sum[0]:cur[0] 2019-12-19T03:58:43.1465055Z -------------- 2019-12-19T03:58:43.1465304Z ROW OPERATIONS 2019-12-19T03:58:43.1465700Z -------------- 2019-12-19T03:58:43.1465924Z 0 queries inside InnoDB, 0 queries in queue 2019-12-19T03:58:43.1466140Z 0 read views open inside InnoDB 2019-12-19T03:58:43.1466362Z Process ID=102456, Main thread ID=139857655457536, state: sleeping 2019-12-19T03:58:43.1466602Z Number of rows inserted 62, updated 264, deleted 0, read 328 2019-12-19T03:58:43.1466840Z 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s 2019-12-19T03:58:43.1467059Z Number of system rows inserted 0, updated 0, deleted 0, read 0 2019-12-19T03:58:43.1467570Z 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s 2019-12-19T03:58:43.1467965Z ---------------------------- 2019-12-19T03:58:43.1468190Z END OF INNODB MONITOR OUTPUT 2019-12-19T03:58:43.1468358Z ============================ 2019-12-19T03:58:43.1468512Z 2019-12-19T03:58:43.1468679Z ===================================== 2019-12-19T03:58:43.1469066Z 2019-12-19 03:49:43 0x7f331bfff700 INNODB MONITOR OUTPUT 2019-12-19T03:58:43.1469296Z ===================================== 2019-12-19T03:58:43.1469486Z Per second averages calculated from the last 20 seconds 2019-12-19T03:58:43.1469837Z ----------------- 2019-12-19T03:58:43.1470044Z BACKGROUND THREAD 2019-12-19T03:58:43.1470367Z ----------------- 2019-12-19T03:58:43.1470586Z srv_master_thread loops: 1 srv_active, 0 srv_shutdown, 418 srv_idle 2019-12-19T03:58:43.1470996Z srv_master_thread log flush and writes: 419 2019-12-19T03:58:43.1471524Z ---------- 2019-12-19T03:58:43.1471705Z SEMAPHORES 2019-12-19T03:58:43.1472024Z ---------- 2019-12-19T03:58:43.1472222Z OS WAIT ARRAY INFO: reservation count 293 2019-12-19T03:58:43.1472639Z --Thread 139858299688704 has waited at lock0lock.cc line 6267 for 417.00 seconds the semaphore: 2019-12-19T03:58:43.1472891Z Mutex at 0x55e556b0c200, Mutex LOCK_SYS created lock0lock.cc:460, lock var 2 2019-12-19T03:58:43.1473045Z 2019-12-19T03:58:43.1473471Z --Thread 139858053515008 has waited at trx0trx.cc line 2074 for 417.00 seconds the semaphore: 2019-12-19T03:58:43.1474123Z Mutex at 0x7f333e45d110, Mutex TRX created trx0trx.cc:207, lock var 2 2019-12-19T03:58:43.1474325Z 2019-12-19T03:58:43.1474518Z OS WAIT ARRAY INFO: signal count 166 2019-12-19T03:58:43.1475001Z RW-shared spins 0, rounds 388, OS waits 180 2019-12-19T03:58:43.1475596Z RW-excl spins 0, rounds 0, OS waits 0 2019-12-19T03:58:43.1476082Z RW-sx spins 0, rounds 0, OS waits 0 2019-12-19T03:58:43.1476594Z Spin rounds per wait: 388.00 RW-shared, 0.00 RW-excl, 0.00 RW-sx 2019-12-19T03:58:43.1476867Z FAIL TO OBTAIN LOCK MUTEX, SKIP LOCK INFO PRINTING 2019-12-19T03:58:43.1477420Z -------- 2019-12-19T03:58:43.1477612Z FILE I/O 2019-12-19T03:58:43.1478097Z -------- 2019-12-19T03:58:43.1478312Z I/O thread 0 state: waiting for completed aio requests (insert buffer thread) 2019-12-19T03:58:43.1478515Z I/O thread 1 state: waiting for completed aio requests (log thread) 2019-12-19T03:58:43.1478704Z I/O thread 2 state: waiting for completed aio requests (read thread) 2019-12-19T03:58:43.1478906Z I/O thread 3 state: waiting for completed aio requests (read thread) 2019-12-19T03:58:43.1479104Z I/O thread 4 state: waiting for completed aio requests (write thread) 2019-12-19T03:58:43.1479299Z I/O thread 5 state: waiting for completed aio requests (write thread) 2019-12-19T03:58:43.1479493Z Pending normal aio reads: [0, 0] , aio writes: [0, 0] , 2019-12-19T03:58:43.1479850Z ibuf aio reads:, log i/o's:, sync i/o's: 2019-12-19T03:58:43.1480074Z Pending flushes (fsync) log: 0; buffer pool: 0 2019-12-19T03:58:43.1480263Z 332 OS file reads, 1240 OS file writes, 829 OS fsyncs 2019-12-19T03:58:43.1480582Z 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s 2019-12-19T03:58:43.1480979Z ------------------------------------- 2019-12-19T03:58:43.1481185Z INSERT BUFFER AND ADAPTIVE HASH INDEX 2019-12-19T03:58:43.1481537Z ------------------------------------- 2019-12-19T03:58:43.1481754Z Ibuf: size 1, free list len 0, seg size 2, 0 merges 2019-12-19T03:58:43.1482107Z merged operations: 2019-12-19T03:58:43.1482256Z insert 0, delete mark 0, delete 0 2019-12-19T03:58:43.1482428Z discarded operations: 2019-12-19T03:58:43.1482593Z insert 0, delete mark 0, delete 0 2019-12-19T03:58:43.1482767Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1482948Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1483112Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1483330Z Hash table size 2267, node heap has 1 buffer(s) 2019-12-19T03:58:43.1483512Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1484310Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1484546Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1484768Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1485279Z 0.00 hash searches/s, 0.00 non-hash searches/s 2019-12-19T03:58:43.1485728Z --- 2019-12-19T03:58:43.1485965Z LOG 2019-12-19T03:58:43.1486327Z --- 2019-12-19T03:58:43.1486563Z Log sequence number 2102181 2019-12-19T03:58:43.1486776Z Log flushed up to 2102181 2019-12-19T03:58:43.1486980Z Pages flushed up to 2102181 2019-12-19T03:58:43.1487331Z Last checkpoint at 2102172 2019-12-19T03:58:43.1487918Z 0 pending log flushes, 0 pending chkp writes 2019-12-19T03:58:43.1488286Z 723 log i/o's done, 0.00 log i/o's/second 2019-12-19T03:58:43.1488656Z ---------------------- 2019-12-19T03:58:43.1488845Z BUFFER POOL AND MEMORY 2019-12-19T03:58:43.1489174Z ---------------------- 2019-12-19T03:58:43.1489376Z Total large memory allocated 10682368 2019-12-19T03:58:43.1489565Z Dictionary memory allocated 31824 2019-12-19T03:58:43.1489738Z Buffer pool size 511 2019-12-19T03:58:43.1489896Z Free buffers 100 2019-12-19T03:58:43.1490065Z Database pages 410 2019-12-19T03:58:43.1490232Z Old database pages 0 2019-12-19T03:58:43.1490399Z Modified db pages 0 2019-12-19T03:58:43.1490557Z Percent of dirty pages(LRU & free pages): 0.000 2019-12-19T03:58:43.1490739Z Max dirty pages percent: 75.000 2019-12-19T03:58:43.1490910Z Pending reads 0 2019-12-19T03:58:43.1491086Z Pending writes: LRU 0, flush list 0, single page 0 2019-12-19T03:58:43.1491252Z Pages made young 0, not young 0 2019-12-19T03:58:43.1491626Z 0.00 youngs/s, 0.00 non-youngs/s 2019-12-19T03:58:43.1491843Z Pages read 188, created 449, written 467 2019-12-19T03:58:43.1492027Z 0.00 reads/s, 0.00 creates/s, 0.00 writes/s 2019-12-19T03:58:43.1492371Z No buffer pool page gets since the last printout 2019-12-19T03:58:43.1492570Z Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s 2019-12-19T03:58:43.1492778Z LRU len: 410, unzip_LRU len: 0 2019-12-19T03:58:43.1493644Z I/O sum[0]:cur[0], unzip sum[0]:cur[0] 2019-12-19T03:58:43.1494134Z -------------- 2019-12-19T03:58:43.1494367Z ROW OPERATIONS 2019-12-19T03:58:43.1494755Z -------------- 2019-12-19T03:58:43.1535304Z 0 queries inside InnoDB, 0 queries in queue 2019-12-19T03:58:43.1535668Z 0 read views open inside InnoDB 2019-12-19T03:58:43.1535894Z Process ID=102456, Main thread ID=139857655457536, state: sleeping 2019-12-19T03:58:43.1536136Z Number of rows inserted 62, updated 264, deleted 0, read 328 2019-12-19T03:58:43.1536371Z 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s 2019-12-19T03:58:43.1536605Z Number of system rows inserted 0, updated 0, deleted 0, read 0 2019-12-19T03:58:43.1536840Z 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s 2019-12-19T03:58:43.1537888Z ---------------------------- 2019-12-19T03:58:43.1538281Z END OF INNODB MONITOR OUTPUT 2019-12-19T03:58:43.1538457Z ============================ 2019-12-19T03:58:43.1538803Z InnoDB: ###### Diagnostic info printed to the standard error stream 2019-12-19T03:58:43.1539246Z 2019-12-19 3:49:53 0 [Warning] InnoDB: A long semaphore wait: 2019-12-19T03:58:43.1539711Z --Thread 139858299688704 has waited at lock0lock.cc line 6267 for 427.00 seconds the semaphore: 2019-12-19T03:58:43.1539970Z Mutex at 0x55e556b0c200, Mutex LOCK_SYS created lock0lock.cc:460, lock var 2 2019-12-19T03:58:43.1540153Z 2019-12-19T03:58:43.1540549Z 2019-12-19 3:49:53 0 [Warning] InnoDB: A long semaphore wait: 2019-12-19T03:58:43.1541041Z --Thread 139858053515008 has waited at trx0trx.cc line 2074 for 427.00 seconds the semaphore: 2019-12-19T03:58:43.1541297Z Mutex at 0x7f333e45d110, Mutex TRX created trx0trx.cc:207, lock var 2 2019-12-19T03:58:43.1541466Z 2019-12-19T03:58:43.1541840Z 2019-12-19 3:49:53 0 [Note] InnoDB: A semaphore wait: 2019-12-19T03:58:43.1542323Z --Thread 139858299688704 has waited at lock0lock.cc line 6267 for 427.00 seconds the semaphore: 2019-12-19T03:58:43.1542588Z Mutex at 0x55e556b0c200, Mutex LOCK_SYS created lock0lock.cc:460, lock var 2 2019-12-19T03:58:43.1542867Z 2019-12-19T03:58:43.1543290Z 2019-12-19 3:49:53 0 [Note] InnoDB: A semaphore wait: 2019-12-19T03:58:43.1544219Z --Thread 139858053515008 has waited at trx0trx.cc line 2074 for 427.00 seconds the semaphore: 2019-12-19T03:58:43.1544556Z Mutex at 0x7f333e45d110, Mutex TRX created trx0trx.cc:207, lock var 2 2019-12-19T03:58:43.1544744Z 2019-12-19T03:58:43.1544959Z InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: 2019-12-19T03:58:43.1545191Z InnoDB: Pending reads 0, writes 0 2019-12-19T03:58:43.1545355Z 2019-12-19T03:58:43.1545550Z ===================================== 2019-12-19T03:58:43.1546038Z 2019-12-19 03:50:03 0x7f331bfff700 INNODB MONITOR OUTPUT 2019-12-19T03:58:43.1546308Z ===================================== 2019-12-19T03:58:43.1546464Z Per second averages calculated from the last 20 seconds 2019-12-19T03:58:43.1546882Z ----------------- 2019-12-19T03:58:43.1547128Z BACKGROUND THREAD 2019-12-19T03:58:43.1547767Z ----------------- 2019-12-19T03:58:43.1547982Z srv_master_thread loops: 1 srv_active, 0 srv_shutdown, 438 srv_idle 2019-12-19T03:58:43.1548174Z srv_master_thread log flush and writes: 439 2019-12-19T03:58:43.1548470Z ---------- 2019-12-19T03:58:43.1548854Z SEMAPHORES 2019-12-19T03:58:43.1549134Z ---------- 2019-12-19T03:58:43.1549319Z OS WAIT ARRAY INFO: reservation count 293 2019-12-19T03:58:43.1549945Z --Thread 139858299688704 has waited at lock0lock.cc line 6267 for 437.00 seconds the semaphore: 2019-12-19T03:58:43.1550217Z Mutex at 0x55e556b0c200, Mutex LOCK_SYS created lock0lock.cc:460, lock var 2 2019-12-19T03:58:43.1550382Z 2019-12-19T03:58:43.1550794Z --Thread 139858053515008 has waited at trx0trx.cc line 2074 for 437.00 seconds the semaphore: 2019-12-19T03:58:43.1550994Z Mutex at 0x7f333e45d110, Mutex TRX created trx0trx.cc:207, lock var 2 2019-12-19T03:58:43.1551115Z 2019-12-19T03:58:43.1551220Z OS WAIT ARRAY INFO: signal count 166 2019-12-19T03:58:43.1551572Z RW-shared spins 0, rounds 388, OS waits 180 2019-12-19T03:58:43.1552003Z RW-excl spins 0, rounds 0, OS waits 0 2019-12-19T03:58:43.1552436Z RW-sx spins 0, rounds 0, OS waits 0 2019-12-19T03:58:43.1552999Z Spin rounds per wait: 388.00 RW-shared, 0.00 RW-excl, 0.00 RW-sx 2019-12-19T03:58:43.1553477Z FAIL TO OBTAIN LOCK MUTEX, SKIP LOCK INFO PRINTING 2019-12-19T03:58:43.1554186Z -------- 2019-12-19T03:58:43.1554440Z FILE I/O 2019-12-19T03:58:43.1554809Z -------- 2019-12-19T03:58:43.1555069Z I/O thread 0 state: waiting for completed aio requests (insert buffer thread) 2019-12-19T03:58:43.1555313Z I/O thread 1 state: waiting for completed aio requests (log thread) 2019-12-19T03:58:43.1555554Z I/O thread 2 state: waiting for completed aio requests (read thread) 2019-12-19T03:58:43.1555793Z I/O thread 3 state: waiting for completed aio requests (read thread) 2019-12-19T03:58:43.1556017Z I/O thread 4 state: waiting for completed aio requests (write thread) 2019-12-19T03:58:43.1556257Z I/O thread 5 state: waiting for completed aio requests (write thread) 2019-12-19T03:58:43.1556645Z Pending normal aio reads: [0, 0] , aio writes: [0, 0] , 2019-12-19T03:58:43.1557264Z ibuf aio reads:, log i/o's:, sync i/o's: 2019-12-19T03:58:43.1557491Z Pending flushes (fsync) log: 0; buffer pool: 0 2019-12-19T03:58:43.1557665Z 332 OS file reads, 1240 OS file writes, 829 OS fsyncs 2019-12-19T03:58:43.1557857Z 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s 2019-12-19T03:58:43.1558225Z ------------------------------------- 2019-12-19T03:58:43.1558439Z INSERT BUFFER AND ADAPTIVE HASH INDEX 2019-12-19T03:58:43.1558796Z ------------------------------------- 2019-12-19T03:58:43.1559000Z Ibuf: size 1, free list len 0, seg size 2, 0 merges 2019-12-19T03:58:43.1559183Z merged operations: 2019-12-19T03:58:43.1559353Z insert 0, delete mark 0, delete 0 2019-12-19T03:58:43.1559528Z discarded operations: 2019-12-19T03:58:43.1559684Z insert 0, delete mark 0, delete 0 2019-12-19T03:58:43.1559865Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1560173Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1560358Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1560543Z Hash table size 2267, node heap has 1 buffer(s) 2019-12-19T03:58:43.1560711Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1560895Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1561078Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1561261Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1561648Z 0.00 hash searches/s, 0.00 non-hash searches/s 2019-12-19T03:58:43.1562029Z --- 2019-12-19T03:58:43.1562231Z LOG 2019-12-19T03:58:43.1562548Z --- 2019-12-19T03:58:43.1562730Z Log sequence number 2102181 2019-12-19T03:58:43.1562909Z Log flushed up to 2102181 2019-12-19T03:58:43.1563079Z Pages flushed up to 2102181 2019-12-19T03:58:43.1563247Z Last checkpoint at 2102172 2019-12-19T03:58:43.1563401Z 0 pending log flushes, 0 pending chkp writes 2019-12-19T03:58:43.1564239Z 723 log i/o's done, 0.00 log i/o's/second 2019-12-19T03:58:43.1564742Z ---------------------- 2019-12-19T03:58:43.1565003Z BUFFER POOL AND MEMORY 2019-12-19T03:58:43.1565412Z ---------------------- 2019-12-19T03:58:43.1565648Z Total large memory allocated 10682368 2019-12-19T03:58:43.1565879Z Dictionary memory allocated 31824 2019-12-19T03:58:43.1566091Z Buffer pool size 511 2019-12-19T03:58:43.1566370Z Free buffers 100 2019-12-19T03:58:43.1566569Z Database pages 410 2019-12-19T03:58:43.1566806Z Old database pages 0 2019-12-19T03:58:43.1567041Z Modified db pages 0 2019-12-19T03:58:43.1567539Z Percent of dirty pages(LRU & free pages): 0.000 2019-12-19T03:58:43.1567762Z Max dirty pages percent: 75.000 2019-12-19T03:58:43.1567937Z Pending reads 0 2019-12-19T03:58:43.1568148Z Pending writes: LRU 0, flush list 0, single page 0 2019-12-19T03:58:43.1568376Z Pages made young 0, not young 0 2019-12-19T03:58:43.1568911Z 0.00 youngs/s, 0.00 non-youngs/s 2019-12-19T03:58:43.1569230Z Pages read 188, created 449, written 467 2019-12-19T03:58:43.1569386Z 0.00 reads/s, 0.00 creates/s, 0.00 writes/s 2019-12-19T03:58:43.1569620Z No buffer pool page gets since the last printout 2019-12-19T03:58:43.1569850Z Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s 2019-12-19T03:58:43.1570075Z LRU len: 410, unzip_LRU len: 0 2019-12-19T03:58:43.1570245Z I/O sum[0]:cur[0], unzip sum[0]:cur[0] 2019-12-19T03:58:43.1570616Z -------------- 2019-12-19T03:58:43.1570857Z ROW OPERATIONS 2019-12-19T03:58:43.1571403Z -------------- 2019-12-19T03:58:43.1571606Z 0 queries inside InnoDB, 0 queries in queue 2019-12-19T03:58:43.1571873Z 0 read views open inside InnoDB 2019-12-19T03:58:43.1572095Z Process ID=102456, Main thread ID=139857655457536, state: sleeping 2019-12-19T03:58:43.1572325Z Number of rows inserted 62, updated 264, deleted 0, read 328 2019-12-19T03:58:43.1572518Z 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s 2019-12-19T03:58:43.1572748Z Number of system rows inserted 0, updated 0, deleted 0, read 0 2019-12-19T03:58:43.1573123Z 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s 2019-12-19T03:58:43.1574048Z ---------------------------- 2019-12-19T03:58:43.1574354Z END OF INNODB MONITOR OUTPUT 2019-12-19T03:58:43.1574550Z ============================ 2019-12-19T03:58:43.1574750Z 2019-12-19T03:58:43.1575110Z ===================================== 2019-12-19T03:58:43.1575633Z 2019-12-19 03:50:23 0x7f331bfff700 INNODB MONITOR OUTPUT 2019-12-19T03:58:43.1575931Z ===================================== 2019-12-19T03:58:43.1576191Z Per second averages calculated from the last 20 seconds 2019-12-19T03:58:43.1576645Z ----------------- 2019-12-19T03:58:43.1577071Z BACKGROUND THREAD 2019-12-19T03:58:43.1577396Z ----------------- 2019-12-19T03:58:43.1577639Z srv_master_thread loops: 1 srv_active, 0 srv_shutdown, 458 srv_idle 2019-12-19T03:58:43.1577858Z srv_master_thread log flush and writes: 459 2019-12-19T03:58:43.1578224Z ---------- 2019-12-19T03:58:43.1578422Z SEMAPHORES 2019-12-19T03:58:43.1578924Z ---------- 2019-12-19T03:58:43.1579159Z OS WAIT ARRAY INFO: reservation count 293 2019-12-19T03:58:43.1579623Z --Thread 139858299688704 has waited at lock0lock.cc line 6267 for 457.00 seconds the semaphore: 2019-12-19T03:58:43.1579869Z Mutex at 0x55e556b0c200, Mutex LOCK_SYS created lock0lock.cc:460, lock var 2 2019-12-19T03:58:43.1580066Z 2019-12-19T03:58:43.1580508Z --Thread 139858053515008 has waited at trx0trx.cc line 2074 for 457.00 seconds the semaphore: 2019-12-19T03:58:43.1580781Z Mutex at 0x7f333e45d110, Mutex TRX created trx0trx.cc:207, lock var 2 2019-12-19T03:58:43.1580938Z 2019-12-19T03:58:43.1581082Z OS WAIT ARRAY INFO: signal count 166 2019-12-19T03:58:43.1581477Z RW-shared spins 0, rounds 388, OS waits 180 2019-12-19T03:58:43.1581868Z RW-excl spins 0, rounds 0, OS waits 0 2019-12-19T03:58:43.1582460Z RW-sx spins 0, rounds 0, OS waits 0 2019-12-19T03:58:43.1582934Z Spin rounds per wait: 388.00 RW-shared, 0.00 RW-excl, 0.00 RW-sx 2019-12-19T03:58:43.1583393Z FAIL TO OBTAIN LOCK MUTEX, SKIP LOCK INFO PRINTING 2019-12-19T03:58:43.1584150Z -------- 2019-12-19T03:58:43.1584459Z FILE I/O 2019-12-19T03:58:43.1584888Z -------- 2019-12-19T03:58:43.1585184Z I/O thread 0 state: waiting for completed aio requests (insert buffer thread) 2019-12-19T03:58:43.1585465Z I/O thread 1 state: waiting for completed aio requests (log thread) 2019-12-19T03:58:43.1585689Z I/O thread 2 state: waiting for completed aio requests (read thread) 2019-12-19T03:58:43.1585953Z I/O thread 3 state: waiting for completed aio requests (read thread) 2019-12-19T03:58:43.1586226Z I/O thread 4 state: waiting for completed aio requests (write thread) 2019-12-19T03:58:43.1586495Z I/O thread 5 state: waiting for completed aio requests (write thread) 2019-12-19T03:58:43.1586757Z Pending normal aio reads: [0, 0] , aio writes: [0, 0] , 2019-12-19T03:58:43.1587506Z ibuf aio reads:, log i/o's:, sync i/o's: 2019-12-19T03:58:43.1587766Z Pending flushes (fsync) log: 0; buffer pool: 0 2019-12-19T03:58:43.1588009Z 332 OS file reads, 1240 OS file writes, 829 OS fsyncs 2019-12-19T03:58:43.1588234Z 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s 2019-12-19T03:58:43.1588653Z ------------------------------------- 2019-12-19T03:58:43.1589021Z INSERT BUFFER AND ADAPTIVE HASH INDEX 2019-12-19T03:58:43.1589610Z ------------------------------------- 2019-12-19T03:58:43.1609324Z Ibuf: size 1, free list len 0, seg size 2, 0 merges 2019-12-19T03:58:43.1609954Z merged operations: 2019-12-19T03:58:43.1610163Z insert 0, delete mark 0, delete 0 2019-12-19T03:58:43.1610349Z discarded operations: 2019-12-19T03:58:43.1610522Z insert 0, delete mark 0, delete 0 2019-12-19T03:58:43.1610699Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1610891Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1611102Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1611288Z Hash table size 2267, node heap has 1 buffer(s) 2019-12-19T03:58:43.1611475Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1611825Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1612018Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1612206Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1612743Z 0.00 hash searches/s, 0.00 non-hash searches/s 2019-12-19T03:58:43.1613870Z --- 2019-12-19T03:58:43.1614168Z LOG 2019-12-19T03:58:43.1614573Z --- 2019-12-19T03:58:43.1614809Z Log sequence number 2102181 2019-12-19T03:58:43.1655364Z Log flushed up to 2102181 2019-12-19T03:58:43.1655692Z Pages flushed up to 2102181 2019-12-19T03:58:43.1655899Z Last checkpoint at 2102172 2019-12-19T03:58:43.1656106Z 0 pending log flushes, 0 pending chkp writes 2019-12-19T03:58:43.1656694Z 723 log i/o's done, 0.00 log i/o's/second 2019-12-19T03:58:43.1657173Z ---------------------- 2019-12-19T03:58:43.1657762Z BUFFER POOL AND MEMORY 2019-12-19T03:58:43.1658114Z ---------------------- 2019-12-19T03:58:43.1658326Z Total large memory allocated 10682368 2019-12-19T03:58:43.1658665Z Dictionary memory allocated 31824 2019-12-19T03:58:43.1658855Z Buffer pool size 511 2019-12-19T03:58:43.1659044Z Free buffers 100 2019-12-19T03:58:43.1659223Z Database pages 410 2019-12-19T03:58:43.1659388Z Old database pages 0 2019-12-19T03:58:43.1659735Z Modified db pages 0 2019-12-19T03:58:43.1659912Z Percent of dirty pages(LRU & free pages): 0.000 2019-12-19T03:58:43.1660304Z Max dirty pages percent: 75.000 2019-12-19T03:58:43.1660489Z Pending reads 0 2019-12-19T03:58:43.1660665Z Pending writes: LRU 0, flush list 0, single page 0 2019-12-19T03:58:43.1661034Z Pages made young 0, not young 0 2019-12-19T03:58:43.1661621Z 0.00 youngs/s, 0.00 non-youngs/s 2019-12-19T03:58:43.1661857Z Pages read 188, created 449, written 467 2019-12-19T03:58:43.1662041Z 0.00 reads/s, 0.00 creates/s, 0.00 writes/s 2019-12-19T03:58:43.1662233Z No buffer pool page gets since the last printout 2019-12-19T03:58:43.1662440Z Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s 2019-12-19T03:58:43.1662661Z LRU len: 410, unzip_LRU len: 0 2019-12-19T03:58:43.1662846Z I/O sum[0]:cur[0], unzip sum[0]:cur[0] 2019-12-19T03:58:43.1663210Z -------------- 2019-12-19T03:58:43.1664159Z ROW OPERATIONS 2019-12-19T03:58:43.1664636Z -------------- 2019-12-19T03:58:43.1664883Z 0 queries inside InnoDB, 0 queries in queue 2019-12-19T03:58:43.1665088Z 0 read views open inside InnoDB 2019-12-19T03:58:43.1665300Z Process ID=102456, Main thread ID=139857655457536, state: sleeping 2019-12-19T03:58:43.1665532Z Number of rows inserted 62, updated 264, deleted 0, read 328 2019-12-19T03:58:43.1665757Z 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s 2019-12-19T03:58:43.1665973Z Number of system rows inserted 0, updated 0, deleted 0, read 0 2019-12-19T03:58:43.1666200Z 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s 2019-12-19T03:58:43.1666630Z ---------------------------- 2019-12-19T03:58:43.1666873Z END OF INNODB MONITOR OUTPUT 2019-12-19T03:58:43.1667075Z ============================ 2019-12-19T03:58:43.1667689Z InnoDB: ###### Diagnostic info printed to the standard error stream 2019-12-19T03:58:43.1668558Z 2019-12-19 3:50:24 0 [Warning] InnoDB: A long semaphore wait: 2019-12-19T03:58:43.1669059Z --Thread 139858299688704 has waited at lock0lock.cc line 6267 for 458.00 seconds the semaphore: 2019-12-19T03:58:43.1669333Z Mutex at 0x55e556b0c200, Mutex LOCK_SYS created lock0lock.cc:460, lock var 2 2019-12-19T03:58:43.1669504Z 2019-12-19T03:58:43.1669942Z 2019-12-19 3:50:24 0 [Warning] InnoDB: A long semaphore wait: 2019-12-19T03:58:43.1670475Z --Thread 139858053515008 has waited at trx0trx.cc line 2074 for 458.00 seconds the semaphore: 2019-12-19T03:58:43.1670741Z Mutex at 0x7f333e45d110, Mutex TRX created trx0trx.cc:207, lock var 2 2019-12-19T03:58:43.1670908Z 2019-12-19T03:58:43.1671323Z 2019-12-19 3:50:24 0 [Note] InnoDB: A semaphore wait: 2019-12-19T03:58:43.1671843Z --Thread 139858299688704 has waited at lock0lock.cc line 6267 for 458.00 seconds the semaphore: 2019-12-19T03:58:43.1672728Z Mutex at 0x55e556b0c200, Mutex LOCK_SYS created lock0lock.cc:460, lock var 2 2019-12-19T03:58:43.1672890Z 2019-12-19T03:58:43.1673299Z 2019-12-19 3:50:24 0 [Note] InnoDB: A semaphore wait: 2019-12-19T03:58:43.1674203Z --Thread 139858053515008 has waited at trx0trx.cc line 2074 for 458.00 seconds the semaphore: 2019-12-19T03:58:43.1674525Z Mutex at 0x7f333e45d110, Mutex TRX created trx0trx.cc:207, lock var 2 2019-12-19T03:58:43.1674667Z 2019-12-19T03:58:43.1674869Z InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: 2019-12-19T03:58:43.1675089Z InnoDB: Pending reads 0, writes 0 2019-12-19T03:58:43.1675259Z 2019-12-19T03:58:43.1675442Z ===================================== 2019-12-19T03:58:43.1675865Z 2019-12-19 03:50:43 0x7f331bfff700 INNODB MONITOR OUTPUT 2019-12-19T03:58:43.1676108Z ===================================== 2019-12-19T03:58:43.1676337Z Per second averages calculated from the last 20 seconds 2019-12-19T03:58:43.1676753Z ----------------- 2019-12-19T03:58:43.1677303Z BACKGROUND THREAD 2019-12-19T03:58:43.1678013Z ----------------- 2019-12-19T03:58:43.1678583Z srv_master_thread loops: 1 srv_active, 0 srv_shutdown, 478 srv_idle 2019-12-19T03:58:43.1678935Z srv_master_thread log flush and writes: 479 2019-12-19T03:58:43.1679266Z ---------- 2019-12-19T03:58:43.1679459Z SEMAPHORES 2019-12-19T03:58:43.1679941Z ---------- 2019-12-19T03:58:43.1680138Z OS WAIT ARRAY INFO: reservation count 293 2019-12-19T03:58:43.1680802Z --Thread 139858299688704 has waited at lock0lock.cc line 6267 for 477.00 seconds the semaphore: 2019-12-19T03:58:43.1681236Z Mutex at 0x55e556b0c200, Mutex LOCK_SYS created lock0lock.cc:460, lock var 2 2019-12-19T03:58:43.1681406Z 2019-12-19T03:58:43.1681864Z --Thread 139858053515008 has waited at trx0trx.cc line 2074 for 477.00 seconds the semaphore: 2019-12-19T03:58:43.1682131Z Mutex at 0x7f333e45d110, Mutex TRX created trx0trx.cc:207, lock var 2 2019-12-19T03:58:43.1682298Z 2019-12-19T03:58:43.1682470Z OS WAIT ARRAY INFO: signal count 166 2019-12-19T03:58:43.1682901Z RW-shared spins 0, rounds 388, OS waits 180 2019-12-19T03:58:43.1683343Z RW-excl spins 0, rounds 0, OS waits 0 2019-12-19T03:58:43.1684163Z RW-sx spins 0, rounds 0, OS waits 0 2019-12-19T03:58:43.1684719Z Spin rounds per wait: 388.00 RW-shared, 0.00 RW-excl, 0.00 RW-sx 2019-12-19T03:58:43.1684998Z FAIL TO OBTAIN LOCK MUTEX, SKIP LOCK INFO PRINTING 2019-12-19T03:58:43.1685404Z -------- 2019-12-19T03:58:43.1685626Z FILE I/O 2019-12-19T03:58:43.1686002Z -------- 2019-12-19T03:58:43.1686250Z I/O thread 0 state: waiting for completed aio requests (insert buffer thread) 2019-12-19T03:58:43.1686490Z I/O thread 1 state: waiting for completed aio requests (log thread) 2019-12-19T03:58:43.1686723Z I/O thread 2 state: waiting for completed aio requests (read thread) 2019-12-19T03:58:43.1686945Z I/O thread 3 state: waiting for completed aio requests (read thread) 2019-12-19T03:58:43.1687346Z I/O thread 4 state: waiting for completed aio requests (write thread) 2019-12-19T03:58:43.1687723Z I/O thread 5 state: waiting for completed aio requests (write thread) 2019-12-19T03:58:43.1688243Z Pending normal aio reads: [0, 0] , aio writes: [0, 0] , 2019-12-19T03:58:43.1688779Z ibuf aio reads:, log i/o's:, sync i/o's: 2019-12-19T03:58:43.1688987Z Pending flushes (fsync) log: 0; buffer pool: 0 2019-12-19T03:58:43.1689168Z 332 OS file reads, 1240 OS file writes, 829 OS fsyncs 2019-12-19T03:58:43.1689351Z 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s 2019-12-19T03:58:43.1689713Z ------------------------------------- 2019-12-19T03:58:43.1689915Z INSERT BUFFER AND ADAPTIVE HASH INDEX 2019-12-19T03:58:43.1690440Z ------------------------------------- 2019-12-19T03:58:43.1690657Z Ibuf: size 1, free list len 0, seg size 2, 0 merges 2019-12-19T03:58:43.1690834Z merged operations: 2019-12-19T03:58:43.1690996Z insert 0, delete mark 0, delete 0 2019-12-19T03:58:43.1691159Z discarded operations: 2019-12-19T03:58:43.1691320Z insert 0, delete mark 0, delete 0 2019-12-19T03:58:43.1691494Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1691818Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1691993Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1692174Z Hash table size 2267, node heap has 1 buffer(s) 2019-12-19T03:58:43.1692349Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1692526Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1692705Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1692874Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1693469Z 0.00 hash searches/s, 0.00 non-hash searches/s 2019-12-19T03:58:43.1694634Z --- 2019-12-19T03:58:43.1695013Z LOG 2019-12-19T03:58:43.1695437Z --- 2019-12-19T03:58:43.1695677Z Log sequence number 2102181 2019-12-19T03:58:43.1695880Z Log flushed up to 2102181 2019-12-19T03:58:43.1696079Z Pages flushed up to 2102181 2019-12-19T03:58:43.1696267Z Last checkpoint at 2102172 2019-12-19T03:58:43.1696470Z 0 pending log flushes, 0 pending chkp writes 2019-12-19T03:58:43.1697093Z 723 log i/o's done, 0.00 log i/o's/second 2019-12-19T03:58:43.1697855Z ---------------------- 2019-12-19T03:58:43.1698067Z BUFFER POOL AND MEMORY 2019-12-19T03:58:43.1698400Z ---------------------- 2019-12-19T03:58:43.1698611Z Total large memory allocated 10682368 2019-12-19T03:58:43.1698791Z Dictionary memory allocated 31824 2019-12-19T03:58:43.1698962Z Buffer pool size 511 2019-12-19T03:58:43.1699126Z Free buffers 100 2019-12-19T03:58:43.1699298Z Database pages 410 2019-12-19T03:58:43.1699472Z Old database pages 0 2019-12-19T03:58:43.1699643Z Modified db pages 0 2019-12-19T03:58:43.1699811Z Percent of dirty pages(LRU & free pages): 0.000 2019-12-19T03:58:43.1699996Z Max dirty pages percent: 75.000 2019-12-19T03:58:43.1700174Z Pending reads 0 2019-12-19T03:58:43.1700348Z Pending writes: LRU 0, flush list 0, single page 0 2019-12-19T03:58:43.1700686Z Pages made young 0, not young 0 2019-12-19T03:58:43.1701048Z 0.00 youngs/s, 0.00 non-youngs/s 2019-12-19T03:58:43.1701273Z Pages read 188, created 449, written 467 2019-12-19T03:58:43.1701448Z 0.00 reads/s, 0.00 creates/s, 0.00 writes/s 2019-12-19T03:58:43.1701629Z No buffer pool page gets since the last printout 2019-12-19T03:58:43.1701814Z Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s 2019-12-19T03:58:43.1702001Z LRU len: 410, unzip_LRU len: 0 2019-12-19T03:58:43.1702174Z I/O sum[0]:cur[0], unzip sum[0]:cur[0] 2019-12-19T03:58:43.1702530Z -------------- 2019-12-19T03:58:43.1702726Z ROW OPERATIONS 2019-12-19T03:58:43.1703072Z -------------- 2019-12-19T03:58:43.1703244Z 0 queries inside InnoDB, 0 queries in queue 2019-12-19T03:58:43.1703432Z 0 read views open inside InnoDB 2019-12-19T03:58:43.1704071Z Process ID=102456, Main thread ID=139857655457536, state: sleeping 2019-12-19T03:58:43.1704258Z Number of rows inserted 62, updated 264, deleted 0, read 328 2019-12-19T03:58:43.1704954Z 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s 2019-12-19T03:58:43.1705222Z Number of system rows inserted 0, updated 0, deleted 0, read 0 2019-12-19T03:58:43.1705398Z 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s 2019-12-19T03:58:43.1705831Z ---------------------------- 2019-12-19T03:58:43.1705996Z END OF INNODB MONITOR OUTPUT 2019-12-19T03:58:43.1706143Z ============================ 2019-12-19T03:58:43.1706300Z InnoDB: ###### Diagnostic info printed to the standard error stream 2019-12-19T03:58:43.1706706Z 2019-12-19 3:50:55 0 [Warning] InnoDB: A long semaphore wait: 2019-12-19T03:58:43.1707320Z --Thread 139858299688704 has waited at lock0lock.cc line 6267 for 489.00 seconds the semaphore: 2019-12-19T03:58:43.1707526Z Mutex at 0x55e556b0c200, Mutex LOCK_SYS created lock0lock.cc:460, lock var 2 2019-12-19T03:58:43.1707806Z 2019-12-19T03:58:43.1708140Z 2019-12-19 3:50:55 0 [Warning] InnoDB: A long semaphore wait: 2019-12-19T03:58:43.1708685Z --Thread 139858053515008 has waited at trx0trx.cc line 2074 for 489.00 seconds the semaphore: 2019-12-19T03:58:43.1709010Z Mutex at 0x7f333e45d110, Mutex TRX created trx0trx.cc:207, lock var 2 2019-12-19T03:58:43.1709133Z 2019-12-19T03:58:43.1709463Z 2019-12-19 3:50:55 0 [Note] InnoDB: A semaphore wait: 2019-12-19T03:58:43.1709876Z --Thread 139858299688704 has waited at lock0lock.cc line 6267 for 489.00 seconds the semaphore: 2019-12-19T03:58:43.1710070Z Mutex at 0x55e556b0c200, Mutex LOCK_SYS created lock0lock.cc:460, lock var 2 2019-12-19T03:58:43.1710184Z 2019-12-19T03:58:43.1710481Z 2019-12-19 3:50:55 0 [Note] InnoDB: A semaphore wait: 2019-12-19T03:58:43.1711199Z --Thread 139858053515008 has waited at trx0trx.cc line 2074 for 489.00 seconds the semaphore: 2019-12-19T03:58:43.1711536Z Mutex at 0x7f333e45d110, Mutex TRX created trx0trx.cc:207, lock var 2 2019-12-19T03:58:43.1711633Z 2019-12-19T03:58:43.1711754Z InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: 2019-12-19T03:58:43.1711886Z InnoDB: Pending reads 0, writes 0 2019-12-19T03:58:43.1711971Z 2019-12-19T03:58:43.1712082Z ===================================== 2019-12-19T03:58:43.1712535Z 2019-12-19 03:51:03 0x7f331bfff700 INNODB MONITOR OUTPUT 2019-12-19T03:58:43.1712696Z ===================================== 2019-12-19T03:58:43.1712829Z Per second averages calculated from the last 20 seconds 2019-12-19T03:58:43.1713095Z ----------------- 2019-12-19T03:58:43.1713232Z BACKGROUND THREAD 2019-12-19T03:58:43.1713494Z ----------------- 2019-12-19T03:58:43.1714255Z srv_master_thread loops: 1 srv_active, 0 srv_shutdown, 498 srv_idle 2019-12-19T03:58:43.1714419Z srv_master_thread log flush and writes: 499 2019-12-19T03:58:43.1714789Z ---------- 2019-12-19T03:58:43.1714954Z SEMAPHORES 2019-12-19T03:58:43.1715258Z ---------- 2019-12-19T03:58:43.1715405Z OS WAIT ARRAY INFO: reservation count 293 2019-12-19T03:58:43.1715841Z --Thread 139858299688704 has waited at lock0lock.cc line 6267 for 497.00 seconds the semaphore: 2019-12-19T03:58:43.1716060Z Mutex at 0x55e556b0c200, Mutex LOCK_SYS created lock0lock.cc:460, lock var 2 2019-12-19T03:58:43.1716204Z 2019-12-19T03:58:43.1716614Z --Thread 139858053515008 has waited at trx0trx.cc line 2074 for 497.00 seconds the semaphore: 2019-12-19T03:58:43.1716834Z Mutex at 0x7f333e45d110, Mutex TRX created trx0trx.cc:207, lock var 2 2019-12-19T03:58:43.1716966Z 2019-12-19T03:58:43.1717087Z OS WAIT ARRAY INFO: signal count 166 2019-12-19T03:58:43.1717784Z RW-shared spins 0, rounds 388, OS waits 180 2019-12-19T03:58:43.1718114Z RW-excl spins 0, rounds 0, OS waits 0 2019-12-19T03:58:43.1718595Z RW-sx spins 0, rounds 0, OS waits 0 2019-12-19T03:58:43.1719141Z Spin rounds per wait: 388.00 RW-shared, 0.00 RW-excl, 0.00 RW-sx 2019-12-19T03:58:43.1719312Z FAIL TO OBTAIN LOCK MUTEX, SKIP LOCK INFO PRINTING 2019-12-19T03:58:43.1719772Z -------- 2019-12-19T03:58:43.1719916Z FILE I/O 2019-12-19T03:58:43.1720181Z -------- 2019-12-19T03:58:43.1720324Z I/O thread 0 state: waiting for completed aio requests (insert buffer thread) 2019-12-19T03:58:43.1720484Z I/O thread 1 state: waiting for completed aio requests (log thread) 2019-12-19T03:58:43.1720653Z I/O thread 2 state: waiting for completed aio requests (read thread) 2019-12-19T03:58:43.1720809Z I/O thread 3 state: waiting for completed aio requests (read thread) 2019-12-19T03:58:43.1720960Z I/O thread 4 state: waiting for completed aio requests (write thread) 2019-12-19T03:58:43.1721101Z I/O thread 5 state: waiting for completed aio requests (write thread) 2019-12-19T03:58:43.1721255Z Pending normal aio reads: [0, 0] , aio writes: [0, 0] , 2019-12-19T03:58:43.1721585Z ibuf aio reads:, log i/o's:, sync i/o's: 2019-12-19T03:58:43.1721747Z Pending flushes (fsync) log: 0; buffer pool: 0 2019-12-19T03:58:43.1721891Z 332 OS file reads, 1240 OS file writes, 829 OS fsyncs 2019-12-19T03:58:43.1722023Z 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s 2019-12-19T03:58:43.1722343Z ------------------------------------- 2019-12-19T03:58:43.1722672Z INSERT BUFFER AND ADAPTIVE HASH INDEX 2019-12-19T03:58:43.1723259Z ------------------------------------- 2019-12-19T03:58:43.1723922Z Ibuf: size 1, free list len 0, seg size 2, 0 merges 2019-12-19T03:58:43.1724103Z merged operations: 2019-12-19T03:58:43.1724243Z insert 0, delete mark 0, delete 0 2019-12-19T03:58:43.1724389Z discarded operations: 2019-12-19T03:58:43.1724525Z insert 0, delete mark 0, delete 0 2019-12-19T03:58:43.1724665Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1724820Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1724974Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1725129Z Hash table size 2267, node heap has 1 buffer(s) 2019-12-19T03:58:43.1725272Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1725429Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1725581Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1725737Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1726166Z 0.00 hash searches/s, 0.00 non-hash searches/s 2019-12-19T03:58:43.1726504Z --- 2019-12-19T03:58:43.1726788Z LOG 2019-12-19T03:58:43.1727251Z --- 2019-12-19T03:58:43.1727564Z Log sequence number 2102181 2019-12-19T03:58:43.1727686Z Log flushed up to 2102181 2019-12-19T03:58:43.1727812Z Pages flushed up to 2102181 2019-12-19T03:58:43.1727938Z Last checkpoint at 2102172 2019-12-19T03:58:43.1728248Z 0 pending log flushes, 0 pending chkp writes 2019-12-19T03:58:43.1728582Z 723 log i/o's done, 0.00 log i/o's/second 2019-12-19T03:58:43.1729071Z ---------------------- 2019-12-19T03:58:43.1729254Z BUFFER POOL AND MEMORY 2019-12-19T03:58:43.1729545Z ---------------------- 2019-12-19T03:58:43.1729685Z Total large memory allocated 10682368 2019-12-19T03:58:43.1729823Z Dictionary memory allocated 31824 2019-12-19T03:58:43.1729959Z Buffer pool size 511 2019-12-19T03:58:43.1730094Z Free buffers 100 2019-12-19T03:58:43.1730223Z Database pages 410 2019-12-19T03:58:43.1730341Z Old database pages 0 2019-12-19T03:58:43.1730472Z Modified db pages 0 2019-12-19T03:58:43.1730605Z Percent of dirty pages(LRU & free pages): 0.000 2019-12-19T03:58:43.1730766Z Max dirty pages percent: 75.000 2019-12-19T03:58:43.1730901Z Pending reads 0 2019-12-19T03:58:43.1731039Z Pending writes: LRU 0, flush list 0, single page 0 2019-12-19T03:58:43.1731338Z Pages made young 0, not young 0 2019-12-19T03:58:43.1731656Z 0.00 youngs/s, 0.00 non-youngs/s 2019-12-19T03:58:43.1731803Z Pages read 188, created 449, written 467 2019-12-19T03:58:43.1732125Z 0.00 reads/s, 0.00 creates/s, 0.00 writes/s 2019-12-19T03:58:43.1732413Z No buffer pool page gets since the last printout 2019-12-19T03:58:43.1732552Z Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s 2019-12-19T03:58:43.1732693Z LRU len: 410, unzip_LRU len: 0 2019-12-19T03:58:43.1732804Z I/O sum[0]:cur[0], unzip sum[0]:cur[0] 2019-12-19T03:58:43.1733090Z -------------- 2019-12-19T03:58:43.1733225Z ROW OPERATIONS 2019-12-19T03:58:43.1736256Z -------------- 2019-12-19T03:58:43.1736531Z 0 queries inside InnoDB, 0 queries in queue 2019-12-19T03:58:43.1736693Z 0 read views open inside InnoDB 2019-12-19T03:58:43.1736866Z Process ID=102456, Main thread ID=139857655457536, state: sleeping 2019-12-19T03:58:43.1737048Z Number of rows inserted 62, updated 264, deleted 0, read 328 2019-12-19T03:58:43.1737681Z 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s 2019-12-19T03:58:43.1738041Z Number of system rows inserted 0, updated 0, deleted 0, read 0 2019-12-19T03:58:43.1738240Z 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s 2019-12-19T03:58:43.1738840Z ---------------------------- 2019-12-19T03:58:43.1739215Z END OF INNODB MONITOR OUTPUT 2019-12-19T03:58:43.1739376Z ============================ 2019-12-19T03:58:43.1739522Z 2019-12-19T03:58:43.1739679Z ===================================== 2019-12-19T03:58:43.1740067Z 2019-12-19 03:51:23 0x7f331bfff700 INNODB MONITOR OUTPUT 2019-12-19T03:58:43.1740295Z ===================================== 2019-12-19T03:58:43.1740479Z Per second averages calculated from the last 20 seconds 2019-12-19T03:58:43.1740828Z ----------------- 2019-12-19T03:58:43.1741191Z BACKGROUND THREAD 2019-12-19T03:58:43.1741542Z ----------------- 2019-12-19T03:58:43.1741766Z srv_master_thread loops: 1 srv_active, 0 srv_shutdown, 518 srv_idle 2019-12-19T03:58:43.1741959Z srv_master_thread log flush and writes: 519 2019-12-19T03:58:43.1742298Z ---------- 2019-12-19T03:58:43.1742487Z SEMAPHORES 2019-12-19T03:58:43.1742802Z ---------- 2019-12-19T03:58:43.1743006Z OS WAIT ARRAY INFO: reservation count 293 2019-12-19T03:58:43.1743438Z --Thread 139858299688704 has waited at lock0lock.cc line 6267 for 517.00 seconds the semaphore: 2019-12-19T03:58:43.1743847Z Mutex at 0x55e556b0c200, Mutex LOCK_SYS created lock0lock.cc:460, lock var 2 2019-12-19T03:58:43.1744255Z 2019-12-19T03:58:43.1744798Z --Thread 139858053515008 has waited at trx0trx.cc line 2074 for 517.00 seconds the semaphore: 2019-12-19T03:58:43.1745100Z Mutex at 0x7f333e45d110, Mutex TRX created trx0trx.cc:207, lock var 2 2019-12-19T03:58:43.1745283Z 2019-12-19T03:58:43.1745471Z OS WAIT ARRAY INFO: signal count 166 2019-12-19T03:58:43.1746099Z RW-shared spins 0, rounds 388, OS waits 180 2019-12-19T03:58:43.1746574Z RW-excl spins 0, rounds 0, OS waits 0 2019-12-19T03:58:43.1747057Z RW-sx spins 0, rounds 0, OS waits 0 2019-12-19T03:58:43.1747990Z Spin rounds per wait: 388.00 RW-shared, 0.00 RW-excl, 0.00 RW-sx 2019-12-19T03:58:43.1748236Z FAIL TO OBTAIN LOCK MUTEX, SKIP LOCK INFO PRINTING 2019-12-19T03:58:43.1748769Z -------- 2019-12-19T03:58:43.1748969Z FILE I/O 2019-12-19T03:58:43.1749416Z -------- 2019-12-19T03:58:43.1749657Z I/O thread 0 state: waiting for completed aio requests (insert buffer thread) 2019-12-19T03:58:43.1749871Z I/O thread 1 state: waiting for completed aio requests (log thread) 2019-12-19T03:58:43.1750066Z I/O thread 2 state: waiting for completed aio requests (read thread) 2019-12-19T03:58:43.1750272Z I/O thread 3 state: waiting for completed aio requests (read thread) 2019-12-19T03:58:43.1750473Z I/O thread 4 state: waiting for completed aio requests (write thread) 2019-12-19T03:58:43.1750690Z I/O thread 5 state: waiting for completed aio requests (write thread) 2019-12-19T03:58:43.1750887Z Pending normal aio reads: [0, 0] , aio writes: [0, 0] , 2019-12-19T03:58:43.1751267Z ibuf aio reads:, log i/o's:, sync i/o's: 2019-12-19T03:58:43.1751502Z Pending flushes (fsync) log: 0; buffer pool: 0 2019-12-19T03:58:43.1751691Z 332 OS file reads, 1240 OS file writes, 829 OS fsyncs 2019-12-19T03:58:43.1751888Z 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s 2019-12-19T03:58:43.1752275Z ------------------------------------- 2019-12-19T03:58:43.1752483Z INSERT BUFFER AND ADAPTIVE HASH INDEX 2019-12-19T03:58:43.1753020Z ------------------------------------- 2019-12-19T03:58:43.1753398Z Ibuf: size 1, free list len 0, seg size 2, 0 merges 2019-12-19T03:58:43.1753921Z merged operations: 2019-12-19T03:58:43.1754102Z insert 0, delete mark 0, delete 0 2019-12-19T03:58:43.1754307Z discarded operations: 2019-12-19T03:58:43.1754506Z insert 0, delete mark 0, delete 0 2019-12-19T03:58:43.1754733Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1754952Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1755157Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1755371Z Hash table size 2267, node heap has 1 buffer(s) 2019-12-19T03:58:43.1755588Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1755803Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1756016Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1756220Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1756705Z 0.00 hash searches/s, 0.00 non-hash searches/s 2019-12-19T03:58:43.1757320Z --- 2019-12-19T03:58:43.1757533Z LOG 2019-12-19T03:58:43.1758170Z --- 2019-12-19T03:58:43.1758367Z Log sequence number 2102181 2019-12-19T03:58:43.1758546Z Log flushed up to 2102181 2019-12-19T03:58:43.1758719Z Pages flushed up to 2102181 2019-12-19T03:58:43.1758877Z Last checkpoint at 2102172 2019-12-19T03:58:43.1759329Z 0 pending log flushes, 0 pending chkp writes 2019-12-19T03:58:43.1759732Z 723 log i/o's done, 0.00 log i/o's/second 2019-12-19T03:58:43.1760115Z ---------------------- 2019-12-19T03:58:43.1760313Z BUFFER POOL AND MEMORY 2019-12-19T03:58:43.1760648Z ---------------------- 2019-12-19T03:58:43.1760853Z Total large memory allocated 10682368 2019-12-19T03:58:43.1761027Z Dictionary memory allocated 31824 2019-12-19T03:58:43.1761203Z Buffer pool size 511 2019-12-19T03:58:43.1761366Z Free buffers 100 2019-12-19T03:58:43.1761534Z Database pages 410 2019-12-19T03:58:43.1761701Z Old database pages 0 2019-12-19T03:58:43.1761869Z Modified db pages 0 2019-12-19T03:58:43.1762032Z Percent of dirty pages(LRU & free pages): 0.000 2019-12-19T03:58:43.1762215Z Max dirty pages percent: 75.000 2019-12-19T03:58:43.1762388Z Pending reads 0 2019-12-19T03:58:43.1762562Z Pending writes: LRU 0, flush list 0, single page 0 2019-12-19T03:58:43.1762732Z Pages made young 0, not young 0 2019-12-19T03:58:43.1763111Z 0.00 youngs/s, 0.00 non-youngs/s 2019-12-19T03:58:43.1763469Z Pages read 188, created 449, written 467 2019-12-19T03:58:43.1764080Z 0.00 reads/s, 0.00 creates/s, 0.00 writes/s 2019-12-19T03:58:43.1764306Z No buffer pool page gets since the last printout 2019-12-19T03:58:43.1764530Z Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s 2019-12-19T03:58:43.1764763Z LRU len: 410, unzip_LRU len: 0 2019-12-19T03:58:43.1764976Z I/O sum[0]:cur[0], unzip sum[0]:cur[0] 2019-12-19T03:58:43.1765436Z -------------- 2019-12-19T03:58:43.1765679Z ROW OPERATIONS 2019-12-19T03:58:43.1766083Z -------------- 2019-12-19T03:58:43.1766322Z 0 queries inside InnoDB, 0 queries in queue 2019-12-19T03:58:43.1766535Z 0 read views open inside InnoDB 2019-12-19T03:58:43.1766744Z Process ID=102456, Main thread ID=139857655457536, state: sleeping 2019-12-19T03:58:43.1767146Z Number of rows inserted 62, updated 264, deleted 0, read 328 2019-12-19T03:58:43.1767653Z 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s 2019-12-19T03:58:43.1768028Z Number of system rows inserted 0, updated 0, deleted 0, read 0 2019-12-19T03:58:43.1768223Z 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s 2019-12-19T03:58:43.1768739Z ---------------------------- 2019-12-19T03:58:43.1769119Z END OF INNODB MONITOR OUTPUT 2019-12-19T03:58:43.1769289Z ============================ 2019-12-19T03:58:43.1769568Z InnoDB: ###### Diagnostic info printed to the standard error stream 2019-12-19T03:58:43.1770313Z 2019-12-19 3:51:26 0 [Warning] InnoDB: A long semaphore wait: 2019-12-19T03:58:43.1770794Z --Thread 139858299688704 has waited at lock0lock.cc line 6267 for 520.00 seconds the semaphore: 2019-12-19T03:58:43.1771110Z Mutex at 0x55e556b0c200, Mutex LOCK_SYS created lock0lock.cc:460, lock var 2 2019-12-19T03:58:43.1771287Z 2019-12-19T03:58:43.1771693Z 2019-12-19 3:51:26 0 [Warning] InnoDB: A long semaphore wait: 2019-12-19T03:58:43.1772207Z --Thread 139858053515008 has waited at trx0trx.cc line 2074 for 520.00 seconds the semaphore: 2019-12-19T03:58:43.1772491Z Mutex at 0x7f333e45d110, Mutex TRX created trx0trx.cc:207, lock var 2 2019-12-19T03:58:43.1772665Z 2019-12-19T03:58:43.1773355Z 2019-12-19 3:51:26 0 [Note] InnoDB: A semaphore wait: 2019-12-19T03:58:43.1774810Z --Thread 139858299688704 has waited at lock0lock.cc line 6267 for 520.00 seconds the semaphore: 2019-12-19T03:58:43.1775291Z Mutex at 0x55e556b0c200, Mutex LOCK_SYS created lock0lock.cc:460, lock var 2 2019-12-19T03:58:43.1775472Z 2019-12-19T03:58:43.1775869Z 2019-12-19 3:51:26 0 [Note] InnoDB: A semaphore wait: 2019-12-19T03:58:43.1776437Z --Thread 139858053515008 has waited at trx0trx.cc line 2074 for 520.00 seconds the semaphore: 2019-12-19T03:58:43.1776736Z Mutex at 0x7f333e45d110, Mutex TRX created trx0trx.cc:207, lock var 2 2019-12-19T03:58:43.1776918Z 2019-12-19T03:58:43.1777129Z InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: 2019-12-19T03:58:43.1777512Z InnoDB: Pending reads 0, writes 0 2019-12-19T03:58:43.1777811Z 2019-12-19T03:58:43.1778113Z ===================================== 2019-12-19T03:58:43.1778731Z 2019-12-19 03:51:43 0x7f331bfff700 INNODB MONITOR OUTPUT 2019-12-19T03:58:43.1778967Z ===================================== 2019-12-19T03:58:43.1779337Z Per second averages calculated from the last 20 seconds 2019-12-19T03:58:43.1779690Z ----------------- 2019-12-19T03:58:43.1779901Z BACKGROUND THREAD 2019-12-19T03:58:43.1780249Z ----------------- 2019-12-19T03:58:43.1780475Z srv_master_thread loops: 1 srv_active, 0 srv_shutdown, 538 srv_idle 2019-12-19T03:58:43.1780664Z srv_master_thread log flush and writes: 539 2019-12-19T03:58:43.1781009Z ---------- 2019-12-19T03:58:43.1781419Z SEMAPHORES 2019-12-19T03:58:43.1781763Z ---------- 2019-12-19T03:58:43.1781964Z OS WAIT ARRAY INFO: reservation count 293 2019-12-19T03:58:43.1782992Z --Thread 139858299688704 has waited at lock0lock.cc line 6267 for 537.00 seconds the semaphore: 2019-12-19T03:58:43.1783271Z Mutex at 0x55e556b0c200, Mutex LOCK_SYS created lock0lock.cc:460, lock var 2 2019-12-19T03:58:43.1783592Z 2019-12-19T03:58:43.1784585Z --Thread 139858053515008 has waited at trx0trx.cc line 2074 for 537.00 seconds the semaphore: 2019-12-19T03:58:43.1784916Z Mutex at 0x7f333e45d110, Mutex TRX created trx0trx.cc:207, lock var 2 2019-12-19T03:58:43.1785115Z 2019-12-19T03:58:43.1785296Z OS WAIT ARRAY INFO: signal count 166 2019-12-19T03:58:43.1785750Z RW-shared spins 0, rounds 388, OS waits 180 2019-12-19T03:58:43.1786233Z RW-excl spins 0, rounds 0, OS waits 0 2019-12-19T03:58:43.1786703Z RW-sx spins 0, rounds 0, OS waits 0 2019-12-19T03:58:43.1787209Z Spin rounds per wait: 388.00 RW-shared, 0.00 RW-excl, 0.00 RW-sx 2019-12-19T03:58:43.1787981Z FAIL TO OBTAIN LOCK MUTEX, SKIP LOCK INFO PRINTING 2019-12-19T03:58:43.1788318Z -------- 2019-12-19T03:58:43.1788520Z FILE I/O 2019-12-19T03:58:43.1788837Z -------- 2019-12-19T03:58:43.1789038Z I/O thread 0 state: waiting for completed aio requests (insert buffer thread) 2019-12-19T03:58:43.1789237Z I/O thread 1 state: waiting for completed aio requests (log thread) 2019-12-19T03:58:43.1789620Z I/O thread 2 state: waiting for completed aio requests (read thread) 2019-12-19T03:58:43.1789822Z I/O thread 3 state: waiting for completed aio requests (read thread) 2019-12-19T03:58:43.1790200Z I/O thread 4 state: waiting for completed aio requests (write thread) 2019-12-19T03:58:43.1790391Z I/O thread 5 state: waiting for completed aio requests (write thread) 2019-12-19T03:58:43.1790588Z Pending normal aio reads: [0, 0] , aio writes: [0, 0] , 2019-12-19T03:58:43.1790979Z ibuf aio reads:, log i/o's:, sync i/o's: 2019-12-19T03:58:43.1791211Z Pending flushes (fsync) log: 0; buffer pool: 0 2019-12-19T03:58:43.1791399Z 332 OS file reads, 1240 OS file writes, 829 OS fsyncs 2019-12-19T03:58:43.1791584Z 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s 2019-12-19T03:58:43.1791961Z ------------------------------------- 2019-12-19T03:58:43.1792182Z INSERT BUFFER AND ADAPTIVE HASH INDEX 2019-12-19T03:58:43.1792551Z ------------------------------------- 2019-12-19T03:58:43.1792935Z Ibuf: size 1, free list len 0, seg size 2, 0 merges 2019-12-19T03:58:43.1793121Z merged operations: 2019-12-19T03:58:43.1793287Z insert 0, delete mark 0, delete 0 2019-12-19T03:58:43.1793460Z discarded operations: 2019-12-19T03:58:43.1794212Z insert 0, delete mark 0, delete 0 2019-12-19T03:58:43.1794378Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1794561Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1794719Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1794875Z Hash table size 2267, node heap has 1 buffer(s) 2019-12-19T03:58:43.1795017Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1795177Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1795328Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1795481Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1795913Z 0.00 hash searches/s, 0.00 non-hash searches/s 2019-12-19T03:58:43.1796258Z --- 2019-12-19T03:58:43.1796550Z LOG 2019-12-19T03:58:43.1796878Z --- 2019-12-19T03:58:43.1797038Z Log sequence number 2102181 2019-12-19T03:58:43.1797173Z Log flushed up to 2102181 2019-12-19T03:58:43.1797312Z Pages flushed up to 2102181 2019-12-19T03:58:43.1797647Z Last checkpoint at 2102172 2019-12-19T03:58:43.1797930Z 0 pending log flushes, 0 pending chkp writes 2019-12-19T03:58:43.1798219Z 723 log i/o's done, 0.00 log i/o's/second 2019-12-19T03:58:43.1798520Z ---------------------- 2019-12-19T03:58:43.1798662Z BUFFER POOL AND MEMORY 2019-12-19T03:58:43.1798924Z ---------------------- 2019-12-19T03:58:43.1799051Z Total large memory allocated 10682368 2019-12-19T03:58:43.1799171Z Dictionary memory allocated 31824 2019-12-19T03:58:43.1799291Z Buffer pool size 511 2019-12-19T03:58:43.1799405Z Free buffers 100 2019-12-19T03:58:43.1799523Z Database pages 410 2019-12-19T03:58:43.1799626Z Old database pages 0 2019-12-19T03:58:43.1799739Z Modified db pages 0 2019-12-19T03:58:43.1799855Z Percent of dirty pages(LRU & free pages): 0.000 2019-12-19T03:58:43.1800085Z Max dirty pages percent: 75.000 2019-12-19T03:58:43.1800196Z Pending reads 0 2019-12-19T03:58:43.1800323Z Pending writes: LRU 0, flush list 0, single page 0 2019-12-19T03:58:43.1800440Z Pages made young 0, not young 0 2019-12-19T03:58:43.1800771Z 0.00 youngs/s, 0.00 non-youngs/s 2019-12-19T03:58:43.1801405Z Pages read 188, created 449, written 467 2019-12-19T03:58:43.1801538Z 0.00 reads/s, 0.00 creates/s, 0.00 writes/s 2019-12-19T03:58:43.1801665Z No buffer pool page gets since the last printout 2019-12-19T03:58:43.1801821Z Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s 2019-12-19T03:58:43.1801966Z LRU len: 410, unzip_LRU len: 0 2019-12-19T03:58:43.1802095Z I/O sum[0]:cur[0], unzip sum[0]:cur[0] 2019-12-19T03:58:43.1802395Z -------------- 2019-12-19T03:58:43.1802531Z ROW OPERATIONS 2019-12-19T03:58:43.1802811Z -------------- 2019-12-19T03:58:43.1802957Z 0 queries inside InnoDB, 0 queries in queue 2019-12-19T03:58:43.1803107Z 0 read views open inside InnoDB 2019-12-19T03:58:43.1803235Z Process ID=102456, Main thread ID=139857655457536, state: sleeping 2019-12-19T03:58:43.1803386Z Number of rows inserted 62, updated 264, deleted 0, read 328 2019-12-19T03:58:43.1803535Z 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s 2019-12-19T03:58:43.1804263Z Number of system rows inserted 0, updated 0, deleted 0, read 0 2019-12-19T03:58:43.1804442Z 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s 2019-12-19T03:58:43.1804831Z ---------------------------- 2019-12-19T03:58:43.1805007Z END OF INNODB MONITOR OUTPUT 2019-12-19T03:58:43.1805146Z ============================ 2019-12-19T03:58:43.1805303Z InnoDB: ###### Diagnostic info printed to the standard error stream 2019-12-19T03:58:43.1805696Z 2019-12-19 3:51:57 0 [Warning] InnoDB: A long semaphore wait: 2019-12-19T03:58:43.1806172Z --Thread 139858299688704 has waited at lock0lock.cc line 6267 for 551.00 seconds the semaphore: 2019-12-19T03:58:43.1806413Z Mutex at 0x55e556b0c200, Mutex LOCK_SYS created lock0lock.cc:460, lock var 2 2019-12-19T03:58:43.1806570Z 2019-12-19T03:58:43.1806961Z 2019-12-19 3:51:57 0 [Warning] InnoDB: A long semaphore wait: 2019-12-19T03:58:43.1807727Z --Thread 139858053515008 has waited at trx0trx.cc line 2074 for 551.00 seconds the semaphore: 2019-12-19T03:58:43.1807904Z Mutex at 0x7f333e45d110, Mutex TRX created trx0trx.cc:207, lock var 2 2019-12-19T03:58:43.1808004Z 2019-12-19T03:58:43.1808307Z 2019-12-19 3:51:57 0 [Note] InnoDB: A semaphore wait: 2019-12-19T03:58:43.1808875Z --Thread 139858299688704 has waited at lock0lock.cc line 6267 for 551.00 seconds the semaphore: 2019-12-19T03:58:43.1809064Z Mutex at 0x55e556b0c200, Mutex LOCK_SYS created lock0lock.cc:460, lock var 2 2019-12-19T03:58:43.1809171Z 2019-12-19T03:58:43.1809476Z 2019-12-19 3:51:57 0 [Note] InnoDB: A semaphore wait: 2019-12-19T03:58:43.1810024Z --Thread 139858053515008 has waited at trx0trx.cc line 2074 for 551.00 seconds the semaphore: 2019-12-19T03:58:43.1810316Z Mutex at 0x7f333e45d110, Mutex TRX created trx0trx.cc:207, lock var 2 2019-12-19T03:58:43.1810424Z 2019-12-19T03:58:43.1810544Z InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: 2019-12-19T03:58:43.1810681Z InnoDB: Pending reads 0, writes 0 2019-12-19T03:58:43.1810763Z 2019-12-19T03:58:43.1810870Z ===================================== 2019-12-19T03:58:43.1811396Z 2019-12-19 03:52:03 0x7f331bfff700 INNODB MONITOR OUTPUT 2019-12-19T03:58:43.1811565Z ===================================== 2019-12-19T03:58:43.1811692Z Per second averages calculated from the last 20 seconds 2019-12-19T03:58:43.1812204Z ----------------- 2019-12-19T03:58:43.1812540Z BACKGROUND THREAD 2019-12-19T03:58:43.1812842Z ----------------- 2019-12-19T03:58:43.1812996Z srv_master_thread loops: 1 srv_active, 0 srv_shutdown, 558 srv_idle 2019-12-19T03:58:43.1813149Z srv_master_thread log flush and writes: 559 2019-12-19T03:58:43.1813439Z ---------- 2019-12-19T03:58:43.1814228Z SEMAPHORES 2019-12-19T03:58:43.1814815Z ---------- 2019-12-19T03:58:43.1815524Z OS WAIT ARRAY INFO: reservation count 293 2019-12-19T03:58:43.1816078Z --Thread 139858299688704 has waited at lock0lock.cc line 6267 for 557.00 seconds the semaphore: 2019-12-19T03:58:43.1816324Z Mutex at 0x55e556b0c200, Mutex LOCK_SYS created lock0lock.cc:460, lock var 2 2019-12-19T03:58:43.1816452Z 2019-12-19T03:58:43.1816901Z --Thread 139858053515008 has waited at trx0trx.cc line 2074 for 557.00 seconds the semaphore: 2019-12-19T03:58:43.1817121Z Mutex at 0x7f333e45d110, Mutex TRX created trx0trx.cc:207, lock var 2 2019-12-19T03:58:43.1817245Z 2019-12-19T03:58:43.1817536Z OS WAIT ARRAY INFO: signal count 166 2019-12-19T03:58:43.1818007Z RW-shared spins 0, rounds 388, OS waits 180 2019-12-19T03:58:43.1818325Z RW-excl spins 0, rounds 0, OS waits 0 2019-12-19T03:58:43.1818638Z RW-sx spins 0, rounds 0, OS waits 0 2019-12-19T03:58:43.1818975Z Spin rounds per wait: 388.00 RW-shared, 0.00 RW-excl, 0.00 RW-sx 2019-12-19T03:58:43.1819144Z FAIL TO OBTAIN LOCK MUTEX, SKIP LOCK INFO PRINTING 2019-12-19T03:58:43.1819431Z -------- 2019-12-19T03:58:43.1819561Z FILE I/O 2019-12-19T03:58:43.1819801Z -------- 2019-12-19T03:58:43.1819951Z I/O thread 0 state: waiting for completed aio requests (insert buffer thread) 2019-12-19T03:58:43.1820096Z I/O thread 1 state: waiting for completed aio requests (log thread) 2019-12-19T03:58:43.1820236Z I/O thread 2 state: waiting for completed aio requests (read thread) 2019-12-19T03:58:43.1820382Z I/O thread 3 state: waiting for completed aio requests (read thread) 2019-12-19T03:58:43.1820533Z I/O thread 4 state: waiting for completed aio requests (write thread) 2019-12-19T03:58:43.1820681Z I/O thread 5 state: waiting for completed aio requests (write thread) 2019-12-19T03:58:43.1820822Z Pending normal aio reads: [0, 0] , aio writes: [0, 0] , 2019-12-19T03:58:43.1821128Z ibuf aio reads:, log i/o's:, sync i/o's: 2019-12-19T03:58:43.1821280Z Pending flushes (fsync) log: 0; buffer pool: 0 2019-12-19T03:58:43.1821401Z 332 OS file reads, 1240 OS file writes, 829 OS fsyncs 2019-12-19T03:58:43.1821548Z 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s 2019-12-19T03:58:43.1821849Z ------------------------------------- 2019-12-19T03:58:43.1821994Z INSERT BUFFER AND ADAPTIVE HASH INDEX 2019-12-19T03:58:43.1822269Z ------------------------------------- 2019-12-19T03:58:43.1822420Z Ibuf: size 1, free list len 0, seg size 2, 0 merges 2019-12-19T03:58:43.1822543Z merged operations: 2019-12-19T03:58:43.1822658Z insert 0, delete mark 0, delete 0 2019-12-19T03:58:43.1822777Z discarded operations: 2019-12-19T03:58:43.1822881Z insert 0, delete mark 0, delete 0 2019-12-19T03:58:43.1823001Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1823129Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1823255Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1823370Z Hash table size 2267, node heap has 1 buffer(s) 2019-12-19T03:58:43.1823496Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1824685Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1824880Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1825037Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1825460Z 0.00 hash searches/s, 0.00 non-hash searches/s 2019-12-19T03:58:43.1825807Z --- 2019-12-19T03:58:43.1825958Z LOG 2019-12-19T03:58:43.1826247Z --- 2019-12-19T03:58:43.1826391Z Log sequence number 2102181 2019-12-19T03:58:43.1826532Z Log flushed up to 2102181 2019-12-19T03:58:43.1826668Z Pages flushed up to 2102181 2019-12-19T03:58:43.1826807Z Last checkpoint at 2102172 2019-12-19T03:58:43.1826940Z 0 pending log flushes, 0 pending chkp writes 2019-12-19T03:58:43.1827303Z 723 log i/o's done, 0.00 log i/o's/second 2019-12-19T03:58:43.1827654Z ---------------------- 2019-12-19T03:58:43.1828217Z BUFFER POOL AND MEMORY 2019-12-19T03:58:43.1828488Z ---------------------- 2019-12-19T03:58:43.1828623Z Total large memory allocated 10682368 2019-12-19T03:58:43.1828743Z Dictionary memory allocated 31824 2019-12-19T03:58:43.1828987Z Buffer pool size 511 2019-12-19T03:58:43.1829103Z Free buffers 100 2019-12-19T03:58:43.1829210Z Database pages 410 2019-12-19T03:58:43.1829329Z Old database pages 0 2019-12-19T03:58:43.1829444Z Modified db pages 0 2019-12-19T03:58:43.1829565Z Percent of dirty pages(LRU & free pages): 0.000 2019-12-19T03:58:43.1829684Z Max dirty pages percent: 75.000 2019-12-19T03:58:43.1829806Z Pending reads 0 2019-12-19T03:58:43.1829927Z Pending writes: LRU 0, flush list 0, single page 0 2019-12-19T03:58:43.1830057Z Pages made young 0, not young 0 2019-12-19T03:58:43.1830381Z 0.00 youngs/s, 0.00 non-youngs/s 2019-12-19T03:58:43.1830537Z Pages read 188, created 449, written 467 2019-12-19T03:58:43.1830664Z 0.00 reads/s, 0.00 creates/s, 0.00 writes/s 2019-12-19T03:58:43.1830791Z No buffer pool page gets since the last printout 2019-12-19T03:58:43.1830937Z Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s 2019-12-19T03:58:43.1831076Z LRU len: 410, unzip_LRU len: 0 2019-12-19T03:58:43.1831380Z I/O sum[0]:cur[0], unzip sum[0]:cur[0] 2019-12-19T03:58:43.1831655Z -------------- 2019-12-19T03:58:43.1831792Z ROW OPERATIONS 2019-12-19T03:58:43.1832037Z -------------- 2019-12-19T03:58:43.1832176Z 0 queries inside InnoDB, 0 queries in queue 2019-12-19T03:58:43.1832298Z 0 read views open inside InnoDB 2019-12-19T03:58:43.1832433Z Process ID=102456, Main thread ID=139857655457536, state: sleeping 2019-12-19T03:58:43.1832579Z Number of rows inserted 62, updated 264, deleted 0, read 328 2019-12-19T03:58:43.1832709Z 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s 2019-12-19T03:58:43.1832843Z Number of system rows inserted 0, updated 0, deleted 0, read 0 2019-12-19T03:58:43.1832982Z 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s 2019-12-19T03:58:43.1833272Z ---------------------------- 2019-12-19T03:58:43.1833412Z END OF INNODB MONITOR OUTPUT 2019-12-19T03:58:43.1833671Z ============================ 2019-12-19T03:58:43.1834011Z 2019-12-19T03:58:43.1834154Z ===================================== 2019-12-19T03:58:43.1834580Z 2019-12-19 03:52:23 0x7f331bfff700 INNODB MONITOR OUTPUT 2019-12-19T03:58:43.1834766Z ===================================== 2019-12-19T03:58:43.1834923Z Per second averages calculated from the last 20 seconds 2019-12-19T03:58:43.1835255Z ----------------- 2019-12-19T03:58:43.1835408Z BACKGROUND THREAD 2019-12-19T03:58:43.1835713Z ----------------- 2019-12-19T03:58:43.1835887Z srv_master_thread loops: 1 srv_active, 0 srv_shutdown, 578 srv_idle 2019-12-19T03:58:43.1836051Z srv_master_thread log flush and writes: 579 2019-12-19T03:58:43.1836364Z ---------- 2019-12-19T03:58:43.1836510Z SEMAPHORES 2019-12-19T03:58:43.1836805Z ---------- 2019-12-19T03:58:43.1836960Z OS WAIT ARRAY INFO: reservation count 293 2019-12-19T03:58:43.1837852Z --Thread 139858299688704 has waited at lock0lock.cc line 6267 for 577.00 seconds the semaphore: 2019-12-19T03:58:43.1838029Z Mutex at 0x55e556b0c200, Mutex LOCK_SYS created lock0lock.cc:460, lock var 2 2019-12-19T03:58:43.1838264Z 2019-12-19T03:58:43.1838664Z --Thread 139858053515008 has waited at trx0trx.cc line 2074 for 577.00 seconds the semaphore: 2019-12-19T03:58:43.1838845Z Mutex at 0x7f333e45d110, Mutex TRX created trx0trx.cc:207, lock var 2 2019-12-19T03:58:43.1838955Z 2019-12-19T03:58:43.1839066Z OS WAIT ARRAY INFO: signal count 166 2019-12-19T03:58:43.1839379Z RW-shared spins 0, rounds 388, OS waits 180 2019-12-19T03:58:43.1839715Z RW-excl spins 0, rounds 0, OS waits 0 2019-12-19T03:58:43.1840184Z RW-sx spins 0, rounds 0, OS waits 0 2019-12-19T03:58:43.1840522Z Spin rounds per wait: 388.00 RW-shared, 0.00 RW-excl, 0.00 RW-sx 2019-12-19T03:58:43.1840678Z FAIL TO OBTAIN LOCK MUTEX, SKIP LOCK INFO PRINTING 2019-12-19T03:58:43.1841099Z -------- 2019-12-19T03:58:43.1841228Z FILE I/O 2019-12-19T03:58:43.1841682Z -------- 2019-12-19T03:58:43.1841838Z I/O thread 0 state: waiting for completed aio requests (insert buffer thread) 2019-12-19T03:58:43.1841982Z I/O thread 1 state: waiting for completed aio requests (log thread) 2019-12-19T03:58:43.1842417Z I/O thread 2 state: waiting for completed aio requests (read thread) 2019-12-19T03:58:43.1842573Z I/O thread 3 state: waiting for completed aio requests (read thread) 2019-12-19T03:58:43.1842722Z I/O thread 4 state: waiting for completed aio requests (write thread) 2019-12-19T03:58:43.1842872Z I/O thread 5 state: waiting for completed aio requests (write thread) 2019-12-19T03:58:43.1843009Z Pending normal aio reads: [0, 0] , aio writes: [0, 0] , 2019-12-19T03:58:43.1843362Z ibuf aio reads:, log i/o's:, sync i/o's: 2019-12-19T03:58:43.1844005Z Pending flushes (fsync) log: 0; buffer pool: 0 2019-12-19T03:58:43.1844210Z 332 OS file reads, 1240 OS file writes, 829 OS fsyncs 2019-12-19T03:58:43.1844383Z 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s 2019-12-19T03:58:43.1844776Z ------------------------------------- 2019-12-19T03:58:43.1844960Z INSERT BUFFER AND ADAPTIVE HASH INDEX 2019-12-19T03:58:43.1845316Z ------------------------------------- 2019-12-19T03:58:43.1845515Z Ibuf: size 1, free list len 0, seg size 2, 0 merges 2019-12-19T03:58:43.1845669Z merged operations: 2019-12-19T03:58:43.1845794Z insert 0, delete mark 0, delete 0 2019-12-19T03:58:43.1845941Z discarded operations: 2019-12-19T03:58:43.1846078Z insert 0, delete mark 0, delete 0 2019-12-19T03:58:43.1846229Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1846374Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1846528Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1846681Z Hash table size 2267, node heap has 1 buffer(s) 2019-12-19T03:58:43.1846834Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1847148Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1847461Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1847840Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1848189Z 0.00 hash searches/s, 0.00 non-hash searches/s 2019-12-19T03:58:43.1848520Z --- 2019-12-19T03:58:43.1848657Z LOG 2019-12-19T03:58:43.1848921Z --- 2019-12-19T03:58:43.1849064Z Log sequence number 2102181 2019-12-19T03:58:43.1849192Z Log flushed up to 2102181 2019-12-19T03:58:43.1849310Z Pages flushed up to 2102181 2019-12-19T03:58:43.1849431Z Last checkpoint at 2102172 2019-12-19T03:58:43.1849558Z 0 pending log flushes, 0 pending chkp writes 2019-12-19T03:58:43.1850043Z 723 log i/o's done, 0.00 log i/o's/second 2019-12-19T03:58:43.1850523Z ---------------------- 2019-12-19T03:58:43.1850659Z BUFFER POOL AND MEMORY 2019-12-19T03:58:43.1851086Z ---------------------- 2019-12-19T03:58:43.1851226Z Total large memory allocated 10682368 2019-12-19T03:58:43.1851350Z Dictionary memory allocated 31824 2019-12-19T03:58:43.1851460Z Buffer pool size 511 2019-12-19T03:58:43.1851578Z Free buffers 100 2019-12-19T03:58:43.1851698Z Database pages 410 2019-12-19T03:58:43.1851813Z Old database pages 0 2019-12-19T03:58:43.1851920Z Modified db pages 0 2019-12-19T03:58:43.1852157Z Percent of dirty pages(LRU & free pages): 0.000 2019-12-19T03:58:43.1852288Z Max dirty pages percent: 75.000 2019-12-19T03:58:43.1852408Z Pending reads 0 2019-12-19T03:58:43.1852518Z Pending writes: LRU 0, flush list 0, single page 0 2019-12-19T03:58:43.1852654Z Pages made young 0, not young 0 2019-12-19T03:58:43.1852990Z 0.00 youngs/s, 0.00 non-youngs/s 2019-12-19T03:58:43.1853146Z Pages read 188, created 449, written 467 2019-12-19T03:58:43.1853275Z 0.00 reads/s, 0.00 creates/s, 0.00 writes/s 2019-12-19T03:58:43.1853397Z No buffer pool page gets since the last printout 2019-12-19T03:58:43.1854112Z Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s 2019-12-19T03:58:43.1854319Z LRU len: 410, unzip_LRU len: 0 2019-12-19T03:58:43.1854463Z I/O sum[0]:cur[0], unzip sum[0]:cur[0] 2019-12-19T03:58:43.1854826Z -------------- 2019-12-19T03:58:43.1855161Z ROW OPERATIONS 2019-12-19T03:58:43.1855521Z -------------- 2019-12-19T03:58:43.1855693Z 0 queries inside InnoDB, 0 queries in queue 2019-12-19T03:58:43.1855974Z 0 read views open inside InnoDB 2019-12-19T03:58:43.1856139Z Process ID=102456, Main thread ID=139857655457536, state: sleeping 2019-12-19T03:58:43.1856310Z Number of rows inserted 62, updated 264, deleted 0, read 328 2019-12-19T03:58:43.1856473Z 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s 2019-12-19T03:58:43.1856642Z Number of system rows inserted 0, updated 0, deleted 0, read 0 2019-12-19T03:58:43.1856799Z 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s 2019-12-19T03:58:43.1857186Z ---------------------------- 2019-12-19T03:58:43.1857707Z END OF INNODB MONITOR OUTPUT 2019-12-19T03:58:43.1857819Z ============================ 2019-12-19T03:58:43.1857942Z InnoDB: ###### Diagnostic info printed to the standard error stream 2019-12-19T03:58:43.1858263Z 2019-12-19 3:52:28 0 [Warning] InnoDB: A long semaphore wait: 2019-12-19T03:58:43.1858645Z --Thread 139858299688704 has waited at lock0lock.cc line 6267 for 582.00 seconds the semaphore: 2019-12-19T03:58:43.1858995Z Mutex at 0x55e556b0c200, Mutex LOCK_SYS created lock0lock.cc:460, lock var 2 2019-12-19T03:58:43.1859170Z 2019-12-19T03:58:43.1859777Z 2019-12-19 3:52:28 0 [Warning] InnoDB: A long semaphore wait: 2019-12-19T03:58:43.1860621Z --Thread 139858053515008 has waited at trx0trx.cc line 2074 for 582.00 seconds the semaphore: 2019-12-19T03:58:43.1860885Z Mutex at 0x7f333e45d110, Mutex TRX created trx0trx.cc:207, lock var 2 2019-12-19T03:58:43.1861046Z 2019-12-19T03:58:43.1861435Z 2019-12-19 3:52:28 0 [Note] InnoDB: A semaphore wait: 2019-12-19T03:58:43.1861932Z --Thread 139858299688704 has waited at lock0lock.cc line 6267 for 582.00 seconds the semaphore: 2019-12-19T03:58:43.1862194Z Mutex at 0x55e556b0c200, Mutex LOCK_SYS created lock0lock.cc:460, lock var 2 2019-12-19T03:58:43.1862358Z 2019-12-19T03:58:43.1862745Z 2019-12-19 3:52:28 0 [Note] InnoDB: A semaphore wait: 2019-12-19T03:58:43.1863236Z --Thread 139858053515008 has waited at trx0trx.cc line 2074 for 582.00 seconds the semaphore: 2019-12-19T03:58:43.1863826Z Mutex at 0x7f333e45d110, Mutex TRX created trx0trx.cc:207, lock var 2 2019-12-19T03:58:43.1864235Z 2019-12-19T03:58:43.1864449Z InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: 2019-12-19T03:58:43.1864676Z InnoDB: Pending reads 0, writes 0 2019-12-19T03:58:43.1864841Z 2019-12-19T03:58:43.1865031Z ===================================== 2019-12-19T03:58:43.1865537Z 2019-12-19 03:52:43 0x7f331bfff700 INNODB MONITOR OUTPUT 2019-12-19T03:58:43.1865803Z ===================================== 2019-12-19T03:58:43.1866017Z Per second averages calculated from the last 20 seconds 2019-12-19T03:58:43.1866427Z ----------------- 2019-12-19T03:58:43.1866678Z BACKGROUND THREAD 2019-12-19T03:58:43.1867076Z ----------------- 2019-12-19T03:58:43.1867782Z srv_master_thread loops: 1 srv_active, 0 srv_shutdown, 598 srv_idle 2019-12-19T03:58:43.1868130Z srv_master_thread log flush and writes: 599 2019-12-19T03:58:43.1868680Z ---------- 2019-12-19T03:58:43.1868890Z SEMAPHORES 2019-12-19T03:58:43.1869381Z ---------- 2019-12-19T03:58:43.1869595Z OS WAIT ARRAY INFO: reservation count 293 2019-12-19T03:58:43.1870043Z --Thread 139858299688704 has waited at lock0lock.cc line 6267 for 597.00 seconds the semaphore: 2019-12-19T03:58:43.1870305Z Mutex at 0x55e556b0c200, Mutex LOCK_SYS created lock0lock.cc:460, lock var 2 2019-12-19T03:58:43.1870466Z 2019-12-19T03:58:43.1870894Z --Thread 139858053515008 has waited at trx0trx.cc line 2074 for 597.00 seconds the semaphore: 2019-12-19T03:58:43.1871297Z Mutex at 0x7f333e45d110, Mutex TRX created trx0trx.cc:207, lock var 2 2019-12-19T03:58:43.1871449Z 2019-12-19T03:58:43.1871611Z OS WAIT ARRAY INFO: signal count 166 2019-12-19T03:58:43.1871979Z RW-shared spins 0, rounds 388, OS waits 180 2019-12-19T03:58:43.1872384Z RW-excl spins 0, rounds 0, OS waits 0 2019-12-19T03:58:43.1872768Z RW-sx spins 0, rounds 0, OS waits 0 2019-12-19T03:58:43.1873208Z Spin rounds per wait: 388.00 RW-shared, 0.00 RW-excl, 0.00 RW-sx 2019-12-19T03:58:43.1873437Z FAIL TO OBTAIN LOCK MUTEX, SKIP LOCK INFO PRINTING 2019-12-19T03:58:43.1874400Z -------- 2019-12-19T03:58:43.1874647Z FILE I/O 2019-12-19T03:58:43.1875027Z -------- 2019-12-19T03:58:43.1875273Z I/O thread 0 state: waiting for completed aio requests (insert buffer thread) 2019-12-19T03:58:43.1875522Z I/O thread 1 state: waiting for completed aio requests (log thread) 2019-12-19T03:58:43.1875754Z I/O thread 2 state: waiting for completed aio requests (read thread) 2019-12-19T03:58:43.1875977Z I/O thread 3 state: waiting for completed aio requests (read thread) 2019-12-19T03:58:43.1876213Z I/O thread 4 state: waiting for completed aio requests (write thread) 2019-12-19T03:58:43.1876447Z I/O thread 5 state: waiting for completed aio requests (write thread) 2019-12-19T03:58:43.1876676Z Pending normal aio reads: [0, 0] , aio writes: [0, 0] , 2019-12-19T03:58:43.1877282Z ibuf aio reads:, log i/o's:, sync i/o's: 2019-12-19T03:58:43.1877495Z Pending flushes (fsync) log: 0; buffer pool: 0 2019-12-19T03:58:43.1877681Z 332 OS file reads, 1240 OS file writes, 829 OS fsyncs 2019-12-19T03:58:43.1877834Z 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s 2019-12-19T03:58:43.1878150Z ------------------------------------- 2019-12-19T03:58:43.1878296Z INSERT BUFFER AND ADAPTIVE HASH INDEX 2019-12-19T03:58:43.1878568Z ------------------------------------- 2019-12-19T03:58:43.1878713Z Ibuf: size 1, free list len 0, seg size 2, 0 merges 2019-12-19T03:58:43.1879075Z merged operations: 2019-12-19T03:58:43.1879289Z insert 0, delete mark 0, delete 0 2019-12-19T03:58:43.1879400Z discarded operations: 2019-12-19T03:58:43.1879518Z insert 0, delete mark 0, delete 0 2019-12-19T03:58:43.1879659Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1879791Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1879919Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1880037Z Hash table size 2267, node heap has 1 buffer(s) 2019-12-19T03:58:43.1880166Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1880314Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1880443Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1880573Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1880886Z 0.00 hash searches/s, 0.00 non-hash searches/s 2019-12-19T03:58:43.1881183Z --- 2019-12-19T03:58:43.1881317Z LOG 2019-12-19T03:58:43.1881566Z --- 2019-12-19T03:58:43.1881693Z Log sequence number 2102181 2019-12-19T03:58:43.1881811Z Log flushed up to 2102181 2019-12-19T03:58:43.1881927Z Pages flushed up to 2102181 2019-12-19T03:58:43.1882195Z Last checkpoint at 2102172 2019-12-19T03:58:43.1882467Z 0 pending log flushes, 0 pending chkp writes 2019-12-19T03:58:43.1882760Z 723 log i/o's done, 0.00 log i/o's/second 2019-12-19T03:58:43.1883050Z ---------------------- 2019-12-19T03:58:43.1883189Z BUFFER POOL AND MEMORY 2019-12-19T03:58:43.1883441Z ---------------------- 2019-12-19T03:58:43.1883950Z Total large memory allocated 10682368 2019-12-19T03:58:43.1884264Z Dictionary memory allocated 31824 2019-12-19T03:58:43.1884412Z Buffer pool size 511 2019-12-19T03:58:43.1884555Z Free buffers 100 2019-12-19T03:58:43.1884683Z Database pages 410 2019-12-19T03:58:43.1884823Z Old database pages 0 2019-12-19T03:58:43.1884961Z Modified db pages 0 2019-12-19T03:58:43.1885106Z Percent of dirty pages(LRU & free pages): 0.000 2019-12-19T03:58:43.1885249Z Max dirty pages percent: 75.000 2019-12-19T03:58:43.1885396Z Pending reads 0 2019-12-19T03:58:43.1885544Z Pending writes: LRU 0, flush list 0, single page 0 2019-12-19T03:58:43.1885700Z Pages made young 0, not young 0 2019-12-19T03:58:43.1886113Z 0.00 youngs/s, 0.00 non-youngs/s 2019-12-19T03:58:43.1886301Z Pages read 188, created 449, written 467 2019-12-19T03:58:43.1886460Z 0.00 reads/s, 0.00 creates/s, 0.00 writes/s 2019-12-19T03:58:43.1886622Z No buffer pool page gets since the last printout 2019-12-19T03:58:43.1886796Z Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s 2019-12-19T03:58:43.1887230Z LRU len: 410, unzip_LRU len: 0 2019-12-19T03:58:43.1887353Z I/O sum[0]:cur[0], unzip sum[0]:cur[0] 2019-12-19T03:58:43.1887651Z -------------- 2019-12-19T03:58:43.1887785Z ROW OPERATIONS 2019-12-19T03:58:43.1888031Z -------------- 2019-12-19T03:58:43.1888164Z 0 queries inside InnoDB, 0 queries in queue 2019-12-19T03:58:43.1888282Z 0 read views open inside InnoDB 2019-12-19T03:58:43.1888409Z Process ID=102456, Main thread ID=139857655457536, state: sleeping 2019-12-19T03:58:43.1888539Z Number of rows inserted 62, updated 264, deleted 0, read 328 2019-12-19T03:58:43.1888687Z 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s 2019-12-19T03:58:43.1888822Z Number of system rows inserted 0, updated 0, deleted 0, read 0 2019-12-19T03:58:43.1888958Z 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s 2019-12-19T03:58:43.1889249Z ---------------------------- 2019-12-19T03:58:43.1889376Z END OF INNODB MONITOR OUTPUT 2019-12-19T03:58:43.1889493Z ============================ 2019-12-19T03:58:43.1889630Z InnoDB: ###### Diagnostic info printed to the standard error stream 2019-12-19T03:58:43.1889958Z 2019-12-19 3:52:59 0 [Warning] InnoDB: A long semaphore wait: 2019-12-19T03:58:43.1890335Z --Thread 139858299688704 has waited at lock0lock.cc line 6267 for 613.00 seconds the semaphore: 2019-12-19T03:58:43.1890511Z Mutex at 0x55e556b0c200, Mutex LOCK_SYS created lock0lock.cc:460, lock var 2 2019-12-19T03:58:43.1890629Z 2019-12-19T03:58:43.1890957Z 2019-12-19 3:52:59 0 [Warning] InnoDB: A long semaphore wait: 2019-12-19T03:58:43.1891347Z --Thread 139858053515008 has waited at trx0trx.cc line 2074 for 613.00 seconds the semaphore: 2019-12-19T03:58:43.1891525Z Mutex at 0x7f333e45d110, Mutex TRX created trx0trx.cc:207, lock var 2 2019-12-19T03:58:43.1891629Z 2019-12-19T03:58:43.1891937Z 2019-12-19 3:52:59 0 [Note] InnoDB: A semaphore wait: 2019-12-19T03:58:43.1892323Z --Thread 139858299688704 has waited at lock0lock.cc line 6267 for 613.00 seconds the semaphore: 2019-12-19T03:58:43.1892511Z Mutex at 0x55e556b0c200, Mutex LOCK_SYS created lock0lock.cc:460, lock var 2 2019-12-19T03:58:43.1892629Z 2019-12-19T03:58:43.1892919Z 2019-12-19 3:52:59 0 [Note] InnoDB: A semaphore wait: 2019-12-19T03:58:43.1893311Z --Thread 139858053515008 has waited at trx0trx.cc line 2074 for 613.00 seconds the semaphore: 2019-12-19T03:58:43.1893644Z Mutex at 0x7f333e45d110, Mutex TRX created trx0trx.cc:207, lock var 2 2019-12-19T03:58:43.1893988Z 2019-12-19T03:58:43.1894130Z InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: 2019-12-19T03:58:43.1894292Z InnoDB: Pending reads 0, writes 0 2019-12-19T03:58:43.1894402Z 2019-12-19T03:58:43.1894519Z ===================================== 2019-12-19T03:58:43.1895096Z 2019-12-19 03:53:03 0x7f331bfff700 INNODB MONITOR OUTPUT 2019-12-19T03:58:43.1895310Z ===================================== 2019-12-19T03:58:43.1895476Z Per second averages calculated from the last 20 seconds 2019-12-19T03:58:43.1895840Z ----------------- 2019-12-19T03:58:43.1896131Z BACKGROUND THREAD 2019-12-19T03:58:43.1896486Z ----------------- 2019-12-19T03:58:43.1896674Z srv_master_thread loops: 1 srv_active, 0 srv_shutdown, 618 srv_idle 2019-12-19T03:58:43.1896845Z srv_master_thread log flush and writes: 619 2019-12-19T03:58:43.1897463Z ---------- 2019-12-19T03:58:43.1897600Z SEMAPHORES 2019-12-19T03:58:43.1898188Z ---------- 2019-12-19T03:58:43.1898485Z OS WAIT ARRAY INFO: reservation count 293 2019-12-19T03:58:43.1898821Z --Thread 139858299688704 has waited at lock0lock.cc line 6267 for 617.00 seconds the semaphore: 2019-12-19T03:58:43.1899002Z Mutex at 0x55e556b0c200, Mutex LOCK_SYS created lock0lock.cc:460, lock var 2 2019-12-19T03:58:43.1899113Z 2019-12-19T03:58:43.1899451Z --Thread 139858053515008 has waited at trx0trx.cc line 2074 for 617.00 seconds the semaphore: 2019-12-19T03:58:43.1899629Z Mutex at 0x7f333e45d110, Mutex TRX created trx0trx.cc:207, lock var 2 2019-12-19T03:58:43.1899733Z 2019-12-19T03:58:43.1899842Z OS WAIT ARRAY INFO: signal count 166 2019-12-19T03:58:43.1900273Z RW-shared spins 0, rounds 388, OS waits 180 2019-12-19T03:58:43.1900607Z RW-excl spins 0, rounds 0, OS waits 0 2019-12-19T03:58:43.1900930Z RW-sx spins 0, rounds 0, OS waits 0 2019-12-19T03:58:43.1901273Z Spin rounds per wait: 388.00 RW-shared, 0.00 RW-excl, 0.00 RW-sx 2019-12-19T03:58:43.1901422Z FAIL TO OBTAIN LOCK MUTEX, SKIP LOCK INFO PRINTING 2019-12-19T03:58:43.1901698Z -------- 2019-12-19T03:58:43.1901827Z FILE I/O 2019-12-19T03:58:43.1902079Z -------- 2019-12-19T03:58:43.1902216Z I/O thread 0 state: waiting for completed aio requests (insert buffer thread) 2019-12-19T03:58:43.1902367Z I/O thread 1 state: waiting for completed aio requests (log thread) 2019-12-19T03:58:43.1902505Z I/O thread 2 state: waiting for completed aio requests (read thread) 2019-12-19T03:58:43.1902823Z I/O thread 3 state: waiting for completed aio requests (read thread) 2019-12-19T03:58:43.1902965Z I/O thread 4 state: waiting for completed aio requests (write thread) 2019-12-19T03:58:43.1903105Z I/O thread 5 state: waiting for completed aio requests (write thread) 2019-12-19T03:58:43.1903242Z Pending normal aio reads: [0, 0] , aio writes: [0, 0] , 2019-12-19T03:58:43.1903896Z ibuf aio reads:, log i/o's:, sync i/o's: 2019-12-19T03:58:43.1904116Z Pending flushes (fsync) log: 0; buffer pool: 0 2019-12-19T03:58:43.1904277Z 332 OS file reads, 1240 OS file writes, 829 OS fsyncs 2019-12-19T03:58:43.1904428Z 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s 2019-12-19T03:58:43.1904829Z ------------------------------------- 2019-12-19T03:58:43.1905005Z INSERT BUFFER AND ADAPTIVE HASH INDEX 2019-12-19T03:58:43.1905352Z ------------------------------------- 2019-12-19T03:58:43.1905526Z Ibuf: size 1, free list len 0, seg size 2, 0 merges 2019-12-19T03:58:43.1905668Z merged operations: 2019-12-19T03:58:43.1905847Z insert 0, delete mark 0, delete 0 2019-12-19T03:58:43.1905994Z discarded operations: 2019-12-19T03:58:43.1906135Z insert 0, delete mark 0, delete 0 2019-12-19T03:58:43.1906276Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1906448Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1906598Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1906752Z Hash table size 2267, node heap has 1 buffer(s) 2019-12-19T03:58:43.1906905Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1907046Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1907388Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1907614Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.1908280Z 0.00 hash searches/s, 0.00 non-hash searches/s 2019-12-19T03:58:43.1908576Z --- 2019-12-19T03:58:43.1908703Z LOG 2019-12-19T03:58:43.1909112Z --- 2019-12-19T03:58:43.1909244Z Log sequence number 2102181 2019-12-19T03:58:43.1909359Z Log flushed up to 2102181 2019-12-19T03:58:43.1909466Z Pages flushed up to 2102181 2019-12-19T03:58:43.1909581Z Last checkpoint at 2102172 2019-12-19T03:58:43.1909699Z 0 pending log flushes, 0 pending chkp writes 2019-12-19T03:58:43.1910148Z 723 log i/o's done, 0.00 log i/o's/second 2019-12-19T03:58:43.1910448Z ---------------------- 2019-12-19T03:58:43.1910592Z BUFFER POOL AND MEMORY 2019-12-19T03:58:43.1910865Z ---------------------- 2019-12-19T03:58:43.1911001Z Total large memory allocated 10682368 2019-12-19T03:58:43.1911115Z Dictionary memory allocated 31824 2019-12-19T03:58:43.1911234Z Buffer pool size 511 2019-12-19T03:58:43.1911352Z Free buffers 100 2019-12-19T03:58:43.1911475Z Database pages 410 2019-12-19T03:58:43.1911582Z Old database pages 0 2019-12-19T03:58:43.1911698Z Modified db pages 0 2019-12-19T03:58:43.1911816Z Percent of dirty pages(LRU & free pages): 0.000 2019-12-19T03:58:43.1911957Z Max dirty pages percent: 75.000 2019-12-19T03:58:43.1912078Z Pending reads 0 2019-12-19T03:58:43.1912188Z Pending writes: LRU 0, flush list 0, single page 0 2019-12-19T03:58:43.1912490Z Pages made young 0, not young 0 2019-12-19T03:58:43.1912960Z 0.00 youngs/s, 0.00 non-youngs/s 2019-12-19T03:58:43.1913444Z Pages read 188, created 449, written 467 2019-12-19T03:58:43.1914230Z 0.00 reads/s, 0.00 creates/s, 0.00 writes/s 2019-12-19T03:58:43.1914429Z No buffer pool page gets since the last printout 2019-12-19T03:58:43.1914609Z Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s 2019-12-19T03:58:43.1914784Z LRU len: 410, unzip_LRU len: 0 2019-12-19T03:58:43.1914934Z I/O sum[0]:cur[0], unzip sum[0]:cur[0] 2019-12-19T03:58:43.1915330Z -------------- 2019-12-19T03:58:43.1915506Z ROW OPERATIONS 2019-12-19T03:58:43.1915836Z -------------- 2019-12-19T03:58:43.1916009Z 0 queries inside InnoDB, 0 queries in queue 2019-12-19T03:58:43.1916154Z 0 read views open inside InnoDB 2019-12-19T03:58:43.1916319Z Process ID=102456, Main thread ID=139857655457536, state: sleeping 2019-12-19T03:58:43.1916499Z Number of rows inserted 62, updated 264, deleted 0, read 328 2019-12-19T03:58:43.1916669Z 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s 2019-12-19T03:58:43.1916843Z Number of system rows inserted 0, updated 0, deleted 0, read 0 2019-12-19T03:58:43.1917020Z 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s 2019-12-19T03:58:43.1917550Z ---------------------------- 2019-12-19T03:58:43.1917698Z END OF INNODB MONITOR OUTPUT 2019-12-19T03:58:43.1917821Z ============================ 2019-12-19T03:58:43.1917905Z 2019-12-19T03:58:43.1918014Z ===================================== 2019-12-19T03:58:43.1918502Z 2019-12-19 03:53:23 0x7f331bfff700 INNODB MONITOR OUTPUT 2019-12-19T03:58:43.1918648Z ===================================== 2019-12-19T03:58:43.1918778Z Per second averages calculated from the last 20 seconds 2019-12-19T03:58:43.1919054Z ----------------- 2019-12-19T03:58:43.1919189Z BACKGROUND THREAD 2019-12-19T03:58:43.1919446Z ----------------- 2019-12-19T03:58:43.1919586Z srv_master_thread loops: 1 srv_active, 0 srv_shutdown, 638 srv_idle 2019-12-19T03:58:43.1919760Z srv_master_thread log flush and writes: 639 2019-12-19T03:58:43.1920070Z ---------- 2019-12-19T03:58:43.1920244Z SEMAPHORES 2019-12-19T03:58:43.1920500Z ---------- 2019-12-19T03:58:43.1920667Z OS WAIT ARRAY INFO: reservation count 293 2019-12-19T03:58:43.1921224Z --Thread 139858299688704 has waited at lock0lock.cc line 6267 for 637.00 seconds the semaphore: 2019-12-19T03:58:43.1921438Z Mutex at 0x55e556b0c200, Mutex LOCK_SYS created lock0lock.cc:460, lock var 2 2019-12-19T03:58:43.1921539Z 2019-12-19T03:58:43.1921902Z --Thread 139858053515008 has waited at trx0trx.cc line 2074 for 637.00 seconds the semaphore: 2019-12-19T03:58:43.1922113Z Mutex at 0x7f333e45d110, Mutex TRX created trx0trx.cc:207, lock var 2 2019-12-19T03:58:43.1922213Z 2019-12-19T03:58:43.1922344Z OS WAIT ARRAY INFO: signal count 166 2019-12-19T03:58:43.1922656Z RW-shared spins 0, rounds 388, OS waits 180 2019-12-19T03:58:43.2004222Z RW-excl spins 0, rounds 0, OS waits 0 2019-12-19T03:58:43.2004816Z RW-sx spins 0, rounds 0, OS waits 0 2019-12-19T03:58:43.2005259Z Spin rounds per wait: 388.00 RW-shared, 0.00 RW-excl, 0.00 RW-sx 2019-12-19T03:58:43.2005644Z FAIL TO OBTAIN LOCK MUTEX, SKIP LOCK INFO PRINTING 2019-12-19T03:58:43.2006038Z -------- 2019-12-19T03:58:43.2006206Z FILE I/O 2019-12-19T03:58:43.2006532Z -------- 2019-12-19T03:58:43.2006712Z I/O thread 0 state: waiting for completed aio requests (insert buffer thread) 2019-12-19T03:58:43.2006888Z I/O thread 1 state: waiting for completed aio requests (log thread) 2019-12-19T03:58:43.2007375Z I/O thread 2 state: waiting for completed aio requests (read thread) 2019-12-19T03:58:43.2007520Z I/O thread 3 state: waiting for completed aio requests (read thread) 2019-12-19T03:58:43.2007664Z I/O thread 4 state: waiting for completed aio requests (write thread) 2019-12-19T03:58:43.2007964Z I/O thread 5 state: waiting for completed aio requests (write thread) 2019-12-19T03:58:43.2008091Z Pending normal aio reads: [0, 0] , aio writes: [0, 0] , 2019-12-19T03:58:43.2008558Z ibuf aio reads:, log i/o's:, sync i/o's: 2019-12-19T03:58:43.2008707Z Pending flushes (fsync) log: 0; buffer pool: 0 2019-12-19T03:58:43.2008946Z 332 OS file reads, 1240 OS file writes, 829 OS fsyncs 2019-12-19T03:58:43.2009079Z 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s 2019-12-19T03:58:43.2009395Z ------------------------------------- 2019-12-19T03:58:43.2009549Z INSERT BUFFER AND ADAPTIVE HASH INDEX 2019-12-19T03:58:43.2009831Z ------------------------------------- 2019-12-19T03:58:43.2009974Z Ibuf: size 1, free list len 0, seg size 2, 0 merges 2019-12-19T03:58:43.2010086Z merged operations: 2019-12-19T03:58:43.2010194Z insert 0, delete mark 0, delete 0 2019-12-19T03:58:43.2010306Z discarded operations: 2019-12-19T03:58:43.2010413Z insert 0, delete mark 0, delete 0 2019-12-19T03:58:43.2010527Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.2010817Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.2010940Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.2011062Z Hash table size 2267, node heap has 1 buffer(s) 2019-12-19T03:58:43.2011353Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.2011488Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.2011774Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.2012076Z Hash table size 2267, node heap has 0 buffer(s) 2019-12-19T03:58:43.2012400Z 0.00 hash searches/s, 0.00 non-hash searches/s 2019-12-19T03:58:43.2012690Z --- 2019-12-19T03:58:43.2012816Z LOG 2019-12-19T03:58:43.2013062Z --- 2019-12-19T03:58:43.2013189Z Log sequence number 2102181 2019-12-19T03:58:43.2013310Z Log flushed up to 2102181 2019-12-19T03:58:43.2013416Z Pages flushed up to 2102181 2019-12-19T03:58:43.2013530Z Last checkpoint at 2102172 2019-12-19T03:58:43.2014496Z 0 pending log flushes, 0 pending chkp writes 2019-12-19T03:58:43.2015127Z 723 log i/o's done, 0.00 log i/o's/second 2019-12-19T03:58:43.2015537Z ---------------------- 2019-12-19T03:58:43.2015712Z BUFFER POOL AND MEMORY 2019-12-19T03:58:43.2016034Z ---------------------- 2019-12-19T03:58:43.2016199Z Total large memory allocated 10682368 2019-12-19T03:58:43.2016353Z Dictionary memory allocated 31824 2019-12-19T03:58:43.2016499Z Buffer pool size 511 2019-12-19T03:58:43.2016637Z Free buffers 100 2019-12-19T03:58:43.2016781Z Database pages 410 2019-12-19T03:58:43.2016916Z Old database pages 0 2019-12-19T03:58:43.2017047Z Modified db pages 0 2019-12-19T03:58:43.2017188Z Percent of dirty pages(LRU & free pages): 0.000 2019-12-19T03:58:43.2017356Z Max dirty pages percent: 75.000 2019-12-19T03:58:43.2017836Z Pending reads 0 2019-12-19T03:58:43.2017947Z Pending writes: LRU 0, flush list 0, single page 0 2019-12-19T03:58:43.2018072Z Pages made young 0, not young 0 2019-12-19T03:58:43.2018380Z 0.00 youngs/s, 0.00 non-youngs/s 2019-12-19T03:58:43.2018528Z Pages read 188, created 449, written 467 2019-12-19T03:58:43.2018649Z 0.00 reads/s, 0.00 creates/s, 0.00 writes/s 2019-12-19T03:58:43.2018781Z No buffer pool page gets since the last printout 2019-12-19T03:58:43.2018925Z Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s 2019-12-19T03:58:43.2019199Z LRU len: 410, unzip_LRU len: 0 2019-12-19T03:58:43.2019327Z I/O sum[0]:cur[0], unzip sum[0]:cur[0] 2019-12-19T03:58:43.2019823Z -------------- 2019-12-19T03:58:43.2019974Z ROW OPERATIONS 2019-12-19T03:58:43.2020247Z -------------- 2019-12-19T03:58:43.2020392Z 0 queries inside InnoDB, 0 queries in queue 2019-12-19T03:58:43.2020514Z 0 read views open inside InnoDB 2019-12-19T03:58:43.2020645Z Process ID=102456, Main thread ID=139857655457536, state: sleeping 2019-12-19T03:58:43.2020791Z Number of rows inserted 62, updated 264, deleted 0, read 328 2019-12-19T03:58:43.2020934Z 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s 2019-12-19T03:58:43.2021075Z Number of system rows inserted 0, updated 0, deleted 0, read 0 2019-12-19T03:58:43.2021212Z 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s 2019-12-19T03:58:43.2021835Z ---------------------------- 2019-12-19T03:58:43.2022134Z END OF INNODB MONITOR OUTPUT 2019-12-19T03:58:43.2022244Z ============================ 2019-12-19T03:58:43.2022464Z InnoDB: ###### Diagnostic info printed to the standard error stream 2019-12-19T03:58:43.2022822Z 2019-12-19 3:53:30 0 [Warning] InnoDB: A long semaphore wait: 2019-12-19T03:58:43.2023205Z --Thread 139858299688704 has waited at lock0lock.cc line 6267 for 644.00 seconds the semaphore: 2019-12-19T03:58:43.2023417Z Mutex at 0x55e556b0c200, Mutex LOCK_SYS created lock0lock.cc:460, lock var 2 2019-12-19T03:58:43.2023674Z 2019-12-19T03:58:43.2024321Z 2019-12-19 3:53:30 0 [Warning] InnoDB: A long semaphore wait: 2019-12-19T03:58:43.2024792Z --Thread 139858053515008 has waited at trx0trx.cc line 2074 for 644.00 seconds the semaphore: 2019-12-19T03:58:43.2025003Z Mutex at 0x7f333e45d110, Mutex TRX created trx0trx.cc:207, lock var 2 2019-12-19T03:58:43.2025122Z 2019-12-19T03:58:43.2025479Z 2019-12-19 3:53:30 0 [Note] InnoDB: A semaphore wait: 2019-12-19T03:58:43.2025944Z --Thread 139858299688704 has waited at lock0lock.cc line 6267 for 644.00 seconds the semaphore: 2019-12-19T03:58:43.2026184Z Mutex at 0x55e556b0c200, Mutex LOCK_SYS created lock0lock.cc:460, lock var 2 2019-12-19T03:58:43.2026309Z 2019-12-19T03:58:43.2026700Z 2019-12-19 3:53:30 0 [Note] InnoDB: A semaphore wait: 2019-12-19T03:58:43.2027348Z --Thread 139858053515008 has waited at trx0trx.cc line 2074 for 644.00 seconds the semaphore: 2019-12-19T03:58:43.2027684Z Mutex at 0x7f333e45d110, Mutex TRX created trx0trx.cc:207, lock var 2 2019-12-19T03:58:43.2027958Z 2019-12-19T03:58:43.2028068Z InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: 2019-12-19T03:58:43.2028192Z InnoDB: Pending reads 0, writes 0 2019-12-19T03:58:43.2028271Z 2019-12-19T03:58:43.2028365Z ===================================== 2019-12-19T03:58:43.2028670Z 2019-12-19 03:53:43 0x7f331bfff700 INNODB MONITOR OUTPUT 2019-12-19T03:58:43.2028808Z ===================================== 2019-12-19T03:58:43.2028929Z Per second averages calculated from the last 20 seconds 2019-12-19T03:58:43.2029208Z ----------------- 2019-12-19T03:58:43.2029351Z BACKGROUND THREAD 2019-12-19T03:58:43.2029601Z ----------------- 2019-12-19T03:58:43.2029732Z srv_master_thread loops: 1 srv_active, 0 srv_shutdown, 658 srv_idle 2019-12-19T03:58:43.2029857Z srv_master_thread log flush and writes: 659 2019-12-19T03:58:43.2030105Z ---------- 2019-12-19T03:58:43.2030229Z SEMAPHORES 2019-12-19T03:58:43.2030457Z ---------- 2019-12-19T03:58:43.2030582Z OS WAIT ARRAY INFO: reservation count 293 2019-12-19T03:58:43.2030923Z --Thread 139858299688704 has waited at lock0lock.cc line 6267 for 657.00 seconds the semaphore: 2019-12-19T03:58:43.2031094Z Mutex at 0x55e556b0c200, Mutex LOCK_SYS created lock0lock.cc:460, lock var 2 2019-12-19T03:58:43.2031188Z 2019-12-19T03:58:43.2031508Z --Thread 139858053515008 has waited at trx0trx.cc line 2074 for 657.00 seconds the semaphore: 2019-12-19T03:58:43.2031672Z Mutex at 0x7f333e45d110, Mutex TRX created trx0trx.cc:207, lock var 2 2019-12-19T03:58:43.2031763Z 2019-12-19T03:58:43.2031858Z OS WAIT ARRAY INFO: signal count 166 2019-12-19T03:58:43.2032290Z RW-shared spins 0, rounds 388, OS waits 180 2019-12-19T03:58:43.2032595Z RW-excl spins 0, rounds 0, OS waits 0 2019-12-19T03:58:43.2032884Z RW-sx spins 0, rounds 0, OS waits 0 2019-12-19T03:58:43.2033576Z Spin rounds per wait: 388.00 RW-shared, 0.00 RW-excl, 0.00 RW-sx 2019-12-19T03:58:43.2033826Z InnoDB: ###### Diagnostic info printed to the standard error stream 2019-12-19T03:58:43.2034271Z 2019-12-19 3:54:01 0 [Warning] InnoDB: A long semaphore wait: 2019-12-19T03:58:43.2034747Z --Thread 139858299688704 has waited at lock0lock.cc line 6267 for 675.00 seconds the semaphore: 2019-12-19T03:58:43.2034957Z Mutex at 0x55e556b0c200, Mutex LOCK_SYS created lock0lock.cc:460, lock var 2 2019-12-19T03:58:43.2035093Z 2019-12-19T03:58:43.2035496Z 2019-12-19 3:54:01 0 [Warning] InnoDB: A long semaphore wait: 2019-12-19T03:58:43.2035981Z --Thread 139858053515008 has waited at trx0trx.cc line 2074 for 675.00 seconds the semaphore: 2019-12-19T03:58:43.2036199Z Mutex at 0x7f333e45d110, Mutex TRX created trx0trx.cc:207, lock var 2 2019-12-19T03:58:43.2036460Z 2019-12-19T03:58:43.2037014Z 2019-12-19 3:54:01 0 [Note] InnoDB: A semaphore wait: 2019-12-19T03:58:43.2037584Z --Thread 139858299688704 has waited at lock0lock.cc line 6267 for 675.00 seconds the semaphore: 2019-12-19T03:58:43.2038100Z Mutex at 0x55e556b0c200, Mutex LOCK_SYS created lock0lock.cc:460, lock var 2 2019-12-19T03:58:43.2038204Z 2019-12-19T03:58:43.2038482Z 2019-12-19 3:54:01 0 [Note] InnoDB: A semaphore wait: 2019-12-19T03:58:43.2038849Z --Thread 139857489819392 has waited at lock0lock.cc line 4567 for 18.00 seconds the semaphore: 2019-12-19T03:58:43.2039017Z Mutex at 0x55e556b0c200, Mutex LOCK_SYS created lock0lock.cc:460, lock var 2 2019-12-19T03:58:43.2039117Z 2019-12-19T03:58:43.2039393Z 2019-12-19 3:54:01 0 [Note] InnoDB: A semaphore wait: 2019-12-19T03:58:43.2039759Z --Thread 139858053515008 has waited at trx0trx.cc line 2074 for 675.00 seconds the semaphore: 2019-12-19T03:58:43.2039925Z Mutex at 0x7f333e45d110, Mutex TRX created trx0trx.cc:207, lock var 2 2019-12-19T03:58:43.2040032Z 2019-12-19T03:58:43.2040141Z InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: 2019-12-19T03:58:43.2040262Z InnoDB: Pending reads 0, writes 0 2019-12-19T03:58:43.2040382Z InnoDB: ###### Diagnostic info printed to the standard error stream 2019-12-19T03:58:43.2040704Z 2019-12-19 3:54:32 0 [Warning] InnoDB: A long semaphore wait: 2019-12-19T03:58:43.2041069Z --Thread 139858299688704 has waited at lock0lock.cc line 6267 for 706.00 seconds the semaphore: 2019-12-19T03:58:43.2041254Z Mutex at 0x55e556b0c200, Mutex LOCK_SYS created lock0lock.cc:460, lock var 2 2019-12-19T03:58:43.2041357Z 2019-12-19T03:58:43.2041669Z 2019-12-19 3:54:32 0 [Warning] InnoDB: A long semaphore wait: 2019-12-19T03:58:43.2042058Z --Thread 139858053515008 has waited at trx0trx.cc line 2074 for 706.00 seconds the semaphore: 2019-12-19T03:58:43.2042230Z Mutex at 0x7f333e45d110, Mutex TRX created trx0trx.cc:207, lock var 2 2019-12-19T03:58:43.2042343Z 2019-12-19T03:58:43.2042638Z 2019-12-19 3:54:32 0 [Note] InnoDB: A semaphore wait: 2019-12-19T03:58:43.2043021Z --Thread 139858299688704 has waited at lock0lock.cc line 6267 for 706.00 seconds the semaphore: 2019-12-19T03:58:43.2043198Z Mutex at 0x55e556b0c200, Mutex LOCK_SYS created lock0lock.cc:460, lock var 2 2019-12-19T03:58:43.2043300Z 2019-12-19T03:58:43.2044102Z 2019-12-19 3:54:32 0 [Note] InnoDB: A semaphore wait: 2019-12-19T03:58:43.2044639Z --Thread 139857489819392 has waited at lock0lock.cc line 4567 for 49.00 seconds the semaphore: 2019-12-19T03:58:43.2044862Z Mutex at 0x55e556b0c200, Mutex LOCK_SYS created lock0lock.cc:460, lock var 2 2019-12-19T03:58:43.2044984Z 2019-12-19T03:58:43.2045344Z 2019-12-19 3:54:32 0 [Note] InnoDB: A semaphore wait: 2019-12-19T03:58:43.2045798Z --Thread 139858053515008 has waited at trx0trx.cc line 2074 for 706.00 seconds the semaphore: 2019-12-19T03:58:43.2046010Z Mutex at 0x7f333e45d110, Mutex TRX created trx0trx.cc:207, lock var 2 2019-12-19T03:58:43.2046254Z 2019-12-19T03:58:43.2046399Z InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: 2019-12-19T03:58:43.2046554Z InnoDB: Pending reads 0, writes 0 2019-12-19T03:58:43.2046708Z InnoDB: ###### Diagnostic info printed to the standard error stream 2019-12-19T03:58:43.2047130Z 2019-12-19 3:55:03 0 [Warning] InnoDB: A long semaphore wait: 2019-12-19T03:58:43.2047873Z --Thread 139858299688704 has waited at lock0lock.cc line 6267 for 737.00 seconds the semaphore: 2019-12-19T03:58:43.2048057Z Mutex at 0x55e556b0c200, Mutex LOCK_SYS created lock0lock.cc:460, lock var 2 2019-12-19T03:58:43.2048170Z 2019-12-19T03:58:43.2048645Z 2019-12-19 3:55:03 0 [Warning] InnoDB: A long semaphore wait: 2019-12-19T03:58:43.2049189Z --Thread 139858053515008 has waited at trx0trx.cc line 2074 for 737.00 seconds the semaphore: 2019-12-19T03:58:43.2049359Z Mutex at 0x7f333e45d110, Mutex TRX created trx0trx.cc:207, lock var 2 2019-12-19T03:58:43.2049454Z 2019-12-19T03:58:43.2049742Z 2019-12-19 3:55:03 0 [Note] InnoDB: A semaphore wait: 2019-12-19T03:58:43.2050243Z --Thread 139858299688704 has waited at lock0lock.cc line 6267 for 737.00 seconds the semaphore: 2019-12-19T03:58:43.2050426Z Mutex at 0x55e556b0c200, Mutex LOCK_SYS created lock0lock.cc:460, lock var 2 2019-12-19T03:58:43.2050528Z 2019-12-19T03:58:43.2050830Z 2019-12-19 3:55:03 0 [Note] InnoDB: A semaphore wait: 2019-12-19T03:58:43.2051221Z --Thread 139857489819392 has waited at lock0lock.cc line 4567 for 80.00 seconds the semaphore: 2019-12-19T03:58:43.2051562Z Mutex at 0x55e556b0c200, Mutex LOCK_SYS created lock0lock.cc:460, lock var 2 2019-12-19T03:58:43.2051659Z 2019-12-19T03:58:43.2051938Z 2019-12-19 3:55:03 0 [Note] InnoDB: A semaphore wait: 2019-12-19T03:58:43.2052295Z --Thread 139858053515008 has waited at trx0trx.cc line 2074 for 737.00 seconds the semaphore: 2019-12-19T03:58:43.2052458Z Mutex at 0x7f333e45d110, Mutex TRX created trx0trx.cc:207, lock var 2 2019-12-19T03:58:43.2052551Z 2019-12-19T03:58:43.2052660Z InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: 2019-12-19T03:58:43.2052797Z InnoDB: Pending reads 0, writes 0 2019-12-19T03:58:43.2052924Z InnoDB: ###### Diagnostic info printed to the standard error stream 2019-12-19T03:58:43.2053602Z 2019-12-19 3:55:34 0 [Warning] InnoDB: A long semaphore wait: 2019-12-19T03:58:43.2054140Z --Thread 139858299688704 has waited at lock0lock.cc line 6267 for 768.00 seconds the semaphore: 2019-12-19T03:58:43.2054367Z Mutex at 0x55e556b0c200, Mutex LOCK_SYS created lock0lock.cc:460, lock var 2 2019-12-19T03:58:43.2054489Z 2019-12-19T03:58:43.2054864Z 2019-12-19 3:55:34 0 [Warning] InnoDB: A long semaphore wait: 2019-12-19T03:58:43.2098843Z --Thread 139858053515008 has waited at trx0trx.cc line 2074 for 768.00 seconds the semaphore: 2019-12-19T03:58:43.2099170Z Mutex at 0x7f333e45d110, Mutex TRX created trx0trx.cc:207, lock var 2 2019-12-19T03:58:43.2099364Z 2019-12-19T03:58:43.2099763Z 2019-12-19 3:55:34 0 [Note] InnoDB: A semaphore wait: 2019-12-19T03:58:43.2100276Z --Thread 139858299688704 has waited at lock0lock.cc line 6267 for 768.00 seconds the semaphore: 2019-12-19T03:58:43.2100572Z Mutex at 0x55e556b0c200, Mutex LOCK_SYS created lock0lock.cc:460, lock var 2 2019-12-19T03:58:43.2100930Z 2019-12-19T03:58:43.2101323Z 2019-12-19 3:55:34 0 [Note] InnoDB: A semaphore wait: 2019-12-19T03:58:43.2102048Z --Thread 139857489819392 has waited at lock0lock.cc line 4567 for 111.00 seconds the semaphore: 2019-12-19T03:58:43.2102347Z Mutex at 0x55e556b0c200, Mutex LOCK_SYS created lock0lock.cc:460, lock var 2 2019-12-19T03:58:43.2102545Z 2019-12-19T03:58:43.2102943Z 2019-12-19 3:55:34 0 [Note] InnoDB: A semaphore wait: 2019-12-19T03:58:43.2104035Z --Thread 139858053515008 has waited at trx0trx.cc line 2074 for 768.00 seconds the semaphore: 2019-12-19T03:58:43.2104459Z Mutex at 0x7f333e45d110, Mutex TRX created trx0trx.cc:207, lock var 2 2019-12-19T03:58:43.2104695Z 2019-12-19T03:58:43.2104935Z InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: 2019-12-19T03:58:43.2105391Z InnoDB: Pending reads 0, writes 0 2019-12-19T03:58:43.2105662Z InnoDB: ###### Diagnostic info printed to the standard error stream 2019-12-19T03:58:43.2106236Z 2019-12-19 3:56:05 0 [Warning] InnoDB: A long semaphore wait: 2019-12-19T03:58:43.2106871Z --Thread 139858299688704 has waited at lock0lock.cc line 6267 for 799.00 seconds the semaphore: 2019-12-19T03:58:43.2107389Z Mutex at 0x55e556b0c200, Mutex LOCK_SYS created lock0lock.cc:460, lock var 2 2019-12-19T03:58:43.2107605Z 2019-12-19T03:58:43.2108075Z 2019-12-19 3:56:05 0 [Warning] InnoDB: A long semaphore wait: 2019-12-19T03:58:43.2108916Z --Thread 139858053515008 has waited at trx0trx.cc line 2074 for 799.00 seconds the semaphore: 2019-12-19T03:58:43.2109217Z Mutex at 0x7f333e45d110, Mutex TRX created trx0trx.cc:207, lock var 2 2019-12-19T03:58:43.2109405Z 2019-12-19T03:58:43.2109799Z 2019-12-19 3:56:05 0 [Note] InnoDB: A semaphore wait: 2019-12-19T03:58:43.2110316Z --Thread 139858299688704 has waited at lock0lock.cc line 6267 for 799.00 seconds the semaphore: 2019-12-19T03:58:43.2110754Z Mutex at 0x55e556b0c200, Mutex LOCK_SYS created lock0lock.cc:460, lock var 2 2019-12-19T03:58:43.2110958Z 2019-12-19T03:58:43.2111371Z 2019-12-19 3:56:05 0 [Note] InnoDB: A semaphore wait: 2019-12-19T03:58:43.2112284Z --Thread 139857489819392 has waited at lock0lock.cc line 4567 for 142.00 seconds the semaphore: 2019-12-19T03:58:43.2112598Z Mutex at 0x55e556b0c200, Mutex LOCK_SYS created lock0lock.cc:460, lock var 2 2019-12-19T03:58:43.2112804Z 2019-12-19T03:58:43.2113221Z 2019-12-19 3:56:05 0 [Note] InnoDB: A semaphore wait: 2019-12-19T03:58:43.2114207Z --Thread 139858053515008 has waited at trx0trx.cc line 2074 for 799.00 seconds the semaphore: 2019-12-19T03:58:43.2114654Z Mutex at 0x7f333e45d110, Mutex TRX created trx0trx.cc:207, lock var 2 2019-12-19T03:58:43.2114895Z 2019-12-19T03:58:43.2115130Z InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: 2019-12-19T03:58:43.2115393Z InnoDB: Pending reads 0, writes 0 2019-12-19T03:58:43.2115670Z InnoDB: ###### Diagnostic info printed to the standard error stream 2019-12-19T03:58:43.2116211Z 2019-12-19 3:56:36 0 [Warning] InnoDB: A long semaphore wait: 2019-12-19T03:58:43.2116850Z --Thread 139858299688704 has waited at lock0lock.cc line 6267 for 830.00 seconds the semaphore: 2019-12-19T03:58:43.2117365Z Mutex at 0x55e556b0c200, Mutex LOCK_SYS created lock0lock.cc:460, lock var 2 2019-12-19T03:58:43.2117734Z 2019-12-19T03:58:43.2118148Z 2019-12-19 3:56:36 0 [Warning] InnoDB: A long semaphore wait: 2019-12-19T03:58:43.2118820Z --Thread 139858053515008 has waited at trx0trx.cc line 2074 for 830.00 seconds the semaphore: 2019-12-19T03:58:43.2119871Z Mutex at 0x7f333e45d110, Mutex TRX created trx0trx.cc:207, lock var 2 2019-12-19T03:58:43.2120177Z 2019-12-19T03:58:43.2120820Z 2019-12-19 3:56:36 0 [Note] InnoDB: A semaphore wait: 2019-12-19T03:58:43.2121376Z --Thread 139858299688704 has waited at lock0lock.cc line 6267 for 830.00 seconds the semaphore: 2019-12-19T03:58:43.2121710Z Mutex at 0x55e556b0c200, Mutex LOCK_SYS created lock0lock.cc:460, lock var 2 2019-12-19T03:58:43.2121934Z 2019-12-19T03:58:43.2122509Z 2019-12-19 3:56:36 0 [Note] InnoDB: A semaphore wait: 2019-12-19T03:58:43.2123076Z --Thread 139857489819392 has waited at lock0lock.cc line 4567 for 173.00 seconds the semaphore: 2019-12-19T03:58:43.2123392Z Mutex at 0x55e556b0c200, Mutex LOCK_SYS created lock0lock.cc:460, lock var 2 2019-12-19T03:58:43.2124386Z 2019-12-19T03:58:43.2125549Z 2019-12-19 3:56:36 0 [Note] InnoDB: A semaphore wait: 2019-12-19T03:58:43.2126438Z --Thread 139858053515008 has waited at trx0trx.cc line 2074 for 830.00 seconds the semaphore: 2019-12-19T03:58:43.2126842Z Mutex at 0x7f333e45d110, Mutex TRX created trx0trx.cc:207, lock var 2 2019-12-19T03:58:43.2127082Z 2019-12-19T03:58:43.2127318Z InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: 2019-12-19T03:58:43.2127912Z InnoDB: Pending reads 0, writes 0 2019-12-19T03:58:43.2128135Z InnoDB: ###### Diagnostic info printed to the standard error stream 2019-12-19T03:58:43.2128945Z 2019-12-19 3:57:07 0 [Warning] InnoDB: A long semaphore wait: 2019-12-19T03:58:43.2129636Z --Thread 139858299688704 has waited at lock0lock.cc line 6267 for 861.00 seconds the semaphore: 2019-12-19T03:58:43.2130704Z Mutex at 0x55e556b0c200, Mutex LOCK_SYS created lock0lock.cc:460, lock var 2 2019-12-19T03:58:43.2130971Z 2019-12-19T03:58:43.2131487Z 2019-12-19 3:57:07 0 [Warning] InnoDB: A long semaphore wait: 2019-12-19T03:58:43.2132069Z --Thread 139858053515008 has waited at trx0trx.cc line 2074 for 861.00 seconds the semaphore: 2019-12-19T03:58:43.2132387Z Mutex at 0x7f333e45d110, Mutex TRX created trx0trx.cc:207, lock var 2 2019-12-19T03:58:43.2132586Z 2019-12-19T03:58:43.2133011Z 2019-12-19 3:57:07 0 [Note] InnoDB: A semaphore wait: 2019-12-19T03:58:43.2133869Z --Thread 139858299688704 has waited at lock0lock.cc line 6267 for 861.00 seconds the semaphore: 2019-12-19T03:58:43.2134513Z Mutex at 0x55e556b0c200, Mutex LOCK_SYS created lock0lock.cc:460, lock var 2 2019-12-19T03:58:43.2135096Z 2019-12-19T03:58:43.2135771Z 2019-12-19 3:57:07 0 [Note] InnoDB: A semaphore wait: 2019-12-19T03:58:43.2136474Z --Thread 139857489819392 has waited at lock0lock.cc line 4567 for 204.00 seconds the semaphore: 2019-12-19T03:58:43.2136845Z Mutex at 0x55e556b0c200, Mutex LOCK_SYS created lock0lock.cc:460, lock var 2 2019-12-19T03:58:43.2137087Z 2019-12-19T03:58:43.2137856Z 2019-12-19 3:57:07 0 [Note] InnoDB: A semaphore wait: 2019-12-19T03:58:43.2138389Z --Thread 139858053515008 has waited at trx0trx.cc line 2074 for 861.00 seconds the semaphore: 2019-12-19T03:58:43.2138850Z Mutex at 0x7f333e45d110, Mutex TRX created trx0trx.cc:207, lock var 2 2019-12-19T03:58:43.2139205Z 2019-12-19T03:58:43.2139405Z InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: 2019-12-19T03:58:43.2139615Z InnoDB: Pending reads 0, writes 0 2019-12-19T03:58:43.2139817Z InnoDB: ###### Diagnostic info printed to the standard error stream 2019-12-19T03:58:43.2140240Z 2019-12-19 3:57:38 0 [Warning] InnoDB: A long semaphore wait: 2019-12-19T03:58:43.2140764Z --Thread 139858299688704 has waited at lock0lock.cc line 6267 for 892.00 seconds the semaphore: 2019-12-19T03:58:43.2141072Z Mutex at 0x55e556b0c200, Mutex LOCK_SYS created lock0lock.cc:460, lock var 2 2019-12-19T03:58:43.2141268Z 2019-12-19T03:58:43.2141676Z 2019-12-19 3:57:38 0 [Warning] InnoDB: A long semaphore wait: 2019-12-19T03:58:43.2142212Z --Thread 139858053515008 has waited at trx0trx.cc line 2074 for 892.00 seconds the semaphore: 2019-12-19T03:58:43.2142507Z Mutex at 0x7f333e45d110, Mutex TRX created trx0trx.cc:207, lock var 2 2019-12-19T03:58:43.2142696Z 2019-12-19T03:58:43.2143089Z 2019-12-19 3:57:38 0 [Note] InnoDB: A semaphore wait: 2019-12-19T03:58:43.2143780Z --Thread 139858299688704 has waited at lock0lock.cc line 6267 for 892.00 seconds the semaphore: 2019-12-19T03:58:43.2144075Z Mutex at 0x55e556b0c200, Mutex LOCK_SYS created lock0lock.cc:460, lock var 2 2019-12-19T03:58:43.2144265Z 2019-12-19T03:58:43.2144726Z 2019-12-19 3:57:38 0 [Note] InnoDB: A semaphore wait: 2019-12-19T03:58:43.2145425Z --Thread 139857489819392 has waited at lock0lock.cc line 4567 for 235.00 seconds the semaphore: 2019-12-19T03:58:43.2145732Z Mutex at 0x55e556b0c200, Mutex LOCK_SYS created lock0lock.cc:460, lock var 2 2019-12-19T03:58:43.2145926Z 2019-12-19T03:58:43.2146322Z 2019-12-19 3:57:38 0 [Note] InnoDB: A semaphore wait: 2019-12-19T03:58:43.2146844Z --Thread 139858053515008 has waited at trx0trx.cc line 2074 for 892.00 seconds the semaphore: 2019-12-19T03:58:43.2147147Z Mutex at 0x7f333e45d110, Mutex TRX created trx0trx.cc:207, lock var 2 2019-12-19T03:58:43.2147336Z 2019-12-19T03:58:43.2147532Z InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: 2019-12-19T03:58:43.2147747Z InnoDB: Pending reads 0, writes 0 2019-12-19T03:58:43.2147956Z InnoDB: ###### Diagnostic info printed to the standard error stream 2019-12-19T03:58:43.2148523Z 2019-12-19 3:58:09 0 [Warning] InnoDB: A long semaphore wait: 2019-12-19T03:58:43.2149232Z --Thread 139858299688704 has waited at lock0lock.cc line 6267 for 923.00 seconds the semaphore: 2019-12-19T03:58:43.2149547Z Mutex at 0x55e556b0c200, Mutex LOCK_SYS created lock0lock.cc:460, lock var 2 2019-12-19T03:58:43.2149750Z 2019-12-19T03:58:43.2150159Z 2019-12-19 3:58:09 0 [Warning] InnoDB: A long semaphore wait: 2019-12-19T03:58:43.2150680Z --Thread 139857489819392 has waited at lock0lock.cc line 4567 for 266.00 seconds the semaphore: 2019-12-19T03:58:43.2150976Z Mutex at 0x55e556b0c200, Mutex LOCK_SYS created lock0lock.cc:460, lock var 2 2019-12-19T03:58:43.2151340Z 2019-12-19T03:58:43.2152233Z 2019-12-19 3:58:09 0 [Warning] InnoDB: A long semaphore wait: 2019-12-19T03:58:43.2152933Z --Thread 139858053515008 has waited at trx0trx.cc line 2074 for 923.00 seconds the semaphore: 2019-12-19T03:58:43.2153607Z Mutex at 0x7f333e45d110, Mutex TRX created trx0trx.cc:207, lock var 2 2019-12-19T03:58:43.2153973Z 2019-12-19T03:58:43.2154508Z 2019-12-19 3:58:09 0 [Note] InnoDB: A semaphore wait: 2019-12-19T03:58:43.2155360Z --Thread 139858299688704 has waited at lock0lock.cc line 6267 for 923.00 seconds the semaphore: 2019-12-19T03:58:43.2155733Z Mutex at 0x55e556b0c200, Mutex LOCK_SYS created lock0lock.cc:460, lock var 2 2019-12-19T03:58:43.2155975Z 2019-12-19T03:58:43.2156615Z 2019-12-19 3:58:09 0 [Note] InnoDB: A semaphore wait: 2019-12-19T03:58:43.2157176Z --Thread 139857489819392 has waited at lock0lock.cc line 4567 for 266.00 seconds the semaphore: 2019-12-19T03:58:43.2157815Z Mutex at 0x55e556b0c200, Mutex LOCK_SYS created lock0lock.cc:460, lock var 2 2019-12-19T03:58:43.2158326Z 2019-12-19T03:58:43.2158705Z 2019-12-19 3:58:09 0 [Note] InnoDB: A semaphore wait: 2019-12-19T03:58:43.2159229Z --Thread 139858053515008 has waited at trx0trx.cc line 2074 for 923.00 seconds the semaphore: 2019-12-19T03:58:43.2159515Z Mutex at 0x7f333e45d110, Mutex TRX created trx0trx.cc:207, lock var 2 2019-12-19T03:58:43.2159709Z 2019-12-19T03:58:43.2159903Z InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: 2019-12-19T03:58:43.2160127Z InnoDB: Pending reads 0, writes 0 2019-12-19T03:58:43.2160345Z InnoDB: ###### Diagnostic info printed to the standard error stream 2019-12-19T03:58:43.2160884Z 2019-12-19 3:58:39 0 [ERROR] [FATAL] InnoDB: Semaphore wait has lasted > 600 seconds. We intentionally crash the server because it appears to be hung. 2019-12-19T03:58:43.2161206Z 191219 3:58:39 [ERROR] mysqld got signal 6 ; 2019-12-19T03:58:43.2161432Z This could be because you hit a bug. It is also possible that this binary 2019-12-19T03:58:43.2161660Z or one of the libraries it was linked against is corrupt, improperly built, 2019-12-19T03:58:43.2161879Z or misconfigured. This error can also be caused by malfunctioning hardware. 2019-12-19T03:58:43.2162066Z 2019-12-19T03:58:43.2162480Z To report this bug, see https://mariadb.com/kb/en/reporting-bugs 2019-12-19T03:58:43.2162747Z 2019-12-19T03:58:43.2162950Z We will try our best to scrape up some info that will hopefully help 2019-12-19T03:58:43.2163186Z diagnose the problem, but since we have already crashed, 2019-12-19T03:58:43.2163394Z something is definitely wrong and this may fail. 2019-12-19T03:58:43.2163913Z 2019-12-19T03:58:43.2164545Z Server version: 10.3.21-5-MariaDB-enterprise-log 2019-12-19T03:58:43.2164879Z key_buffer_size=1048576 2019-12-19T03:58:43.2165121Z read_buffer_size=131072 2019-12-19T03:58:43.2165358Z max_used_connections=1 2019-12-19T03:58:43.2165600Z max_threads=153 2019-12-19T03:58:43.2165833Z thread_count=9 2019-12-19T03:58:43.2166060Z It is possible that mysqld could use up to 2019-12-19T03:58:43.2166326Z key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 63225 K bytes of memory 2019-12-19T03:58:43.2166875Z Hope that's ok; if not, decrease some variables in the equation. 2019-12-19T03:58:43.2167325Z 2019-12-19T03:58:43.2167825Z Thread pointer: 0x0 2019-12-19T03:58:43.2168028Z Attempting backtrace. You can use the following information to find out 2019-12-19T03:58:43.2168252Z where mysqld died. If you see no messages after this, something went 2019-12-19T03:58:43.2168620Z terribly wrong... 2019-12-19T03:58:43.2168816Z stack_bottom = 0x0 thread_stack 0x49000 2019-12-19T03:58:43.2169022Z /__w/1/s/bin/mysqld(my_print_stacktrace+0x2e)[0x55e55618ff4e] 2019-12-19T03:58:43.2169238Z /__w/1/s/bin/mysqld(handle_fatal_signal+0x515)[0x55e555c172f5] 2019-12-19T03:58:43.2169701Z /lib/x86_64-linux-gnu/libpthread.so.0(+0x12890)[0x7f335d3cb890] 2019-12-19T03:58:43.2170200Z /lib/x86_64-linux-gnu/libc.so.6(gsignal+0xc7)[0x7f335c8dfe97] 2019-12-19T03:58:43.2170678Z /lib/x86_64-linux-gnu/libc.so.6(abort+0x141)[0x7f335c8e1801] 2019-12-19T03:58:43.2170992Z /__w/1/s/bin/mysqld(+0xa41f61)[0x55e555eeff61] 2019-12-19T03:58:43.2171205Z :0(ib::fatal::~fatal())[0x55e555ea20b7] 2019-12-19T03:58:43.2171409Z nptl/pthread_create.c:463(start_thread)[0x7f335d3c06db] 2019-12-19T03:58:43.2171828Z /lib/x86_64-linux-gnu/libc.so.6(clone+0x3f)[0x7f335c9c288f] 2019-12-19T03:58:43.2172121Z The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains 2019-12-19T03:58:43.2172512Z information that should help you find out what is causing the crash. 2019-12-19T03:58:43.2172741Z Writing a core file... 2019-12-19T03:58:43.2173122Z Working directory at /var/tmp/mtr/1/mysqld.2/data 2019-12-19T03:58:43.2173328Z Resource Limits: 2019-12-19T03:58:43.2173688Z Fatal signal 11 while backtracing 2019-12-19T03:58:43.2175184Z ----------SERVER LOG END------------- 2019-12-19T03:58:43.2175509Z 2019-12-19T03:58:43.2175729Z 2019-12-19T03:58:43.2176282Z - saving '/var/tmp/mtr/1/log/galera.MW-328A-innodb/' to '/var/tmp/mtr/log/galera.MW-328A-innodb/' 2019-12-19T03:58:43.2177013Z ***Warnings generated in error logs during shutdown after running tests: galera.MW-328A galera.GAL-419 2019-12-19T03:58:43.2177326Z 2019-12-19T03:58:43.2178140Z 2019-12-19 3:46:47 0 [Warning] InnoDB: A long semaphore wait: 2019-12-19T03:58:43.2178847Z 2019-12-19 3:46:47 0 [Warning] InnoDB: A long semaphore wait: 2019-12-19T03:58:43.2179393Z 2019-12-19 3:47:18 0 [Warning] InnoDB: A long semaphore wait: 2019-12-19T03:58:43.2180260Z 2019-12-19 3:47:18 0 [Warning] InnoDB: A long semaphore wait: 2019-12-19T03:58:43.2180779Z 2019-12-19 3:47:49 0 [Warning] InnoDB: A long semaphore wait: 2019-12-19T03:58:43.2181299Z 2019-12-19 3:47:49 0 [Warning] InnoDB: A long semaphore wait: 2019-12-19T03:58:43.2182029Z 2019-12-19 3:48:20 0 [Warning] InnoDB: A long semaphore wait: 2019-12-19T03:58:43.2182708Z 2019-12-19 3:48:20 0 [Warning] InnoDB: A long semaphore wait: 2019-12-19T03:58:43.2184234Z 2019-12-19 3:48:51 0 [Warning] InnoDB: A long semaphore wait: 2019-12-19T03:58:43.2184931Z 2019-12-19 3:48:51 0 [Warning] InnoDB: A long semaphore wait: 2019-12-19T03:58:43.2185527Z 2019-12-19 3:49:22 0 [Warning] InnoDB: A long semaphore wait: 2019-12-19T03:58:43.2186167Z 2019-12-19 3:49:22 0 [Warning] InnoDB: A long semaphore wait: 2019-12-19T03:58:43.2186791Z 2019-12-19 3:49:53 0 [Warning] InnoDB: A long semaphore wait: 2019-12-19T03:58:43.2187881Z 2019-12-19 3:49:53 0 [Warning] InnoDB: A long semaphore wait: 2019-12-19T03:58:43.2188887Z 2019-12-19 3:50:24 0 [Warning] InnoDB: A long semaphore wait: 2019-12-19T03:58:43.2189552Z 2019-12-19 3:50:24 0 [Warning] InnoDB: A long semaphore wait: 2019-12-19T03:58:43.2190050Z 2019-12-19 3:50:55 0 [Warning] InnoDB: A long semaphore wait: 2019-12-19T03:58:43.2190544Z 2019-12-19 3:50:55 0 [Warning] InnoDB: A long semaphore wait: 2019-12-19T03:58:43.2191455Z 2019-12-19 3:51:26 0 [Warning] InnoDB: A long semaphore wait: 2019-12-19T03:58:43.2192259Z 2019-12-19 3:51:26 0 [Warning] InnoDB: A long semaphore wait: 2019-12-19T03:58:43.2192795Z 2019-12-19 3:51:57 0 [Warning] InnoDB: A long semaphore wait: 2019-12-19T03:58:43.2193327Z 2019-12-19 3:51:57 0 [Warning] InnoDB: A long semaphore wait: 2019-12-19T03:58:43.2194274Z 2019-12-19 3:52:28 0 [Warning] InnoDB: A long semaphore wait: 2019-12-19T03:58:43.2194934Z 2019-12-19 3:52:28 0 [Warning] InnoDB: A long semaphore wait: 2019-12-19T03:58:43.2195510Z 2019-12-19 3:52:59 0 [Warning] InnoDB: A long semaphore wait: 2019-12-19T03:58:43.2196308Z 2019-12-19 3:52:59 0 [Warning] InnoDB: A long semaphore wait: 2019-12-19T03:58:43.2196906Z 2019-12-19 3:53:30 0 [Warning] InnoDB: A long semaphore wait: 2019-12-19T03:58:43.2198060Z 2019-12-19 3:53:30 0 [Warning] InnoDB: A long semaphore wait: 2019-12-19T03:58:43.2198533Z 2019-12-19 3:54:01 0 [Warning] InnoDB: A long semaphore wait: 2019-12-19T03:58:43.2199050Z 2019-12-19 3:54:01 0 [Warning] InnoDB: A long semaphore wait: 2019-12-19T03:58:43.2199536Z 2019-12-19 3:54:32 0 [Warning] InnoDB: A long semaphore wait: 2019-12-19T03:58:43.2200016Z 2019-12-19 3:54:32 0 [Warning] InnoDB: A long semaphore wait: 2019-12-19T03:58:43.2200496Z 2019-12-19 3:55:03 0 [Warning] InnoDB: A long semaphore wait: 2019-12-19T03:58:43.2200963Z 2019-12-19 3:55:03 0 [Warning] InnoDB: A long semaphore wait: 2019-12-19T03:58:43.2201446Z 2019-12-19 3:55:34 0 [Warning] InnoDB: A long semaphore wait: 2019-12-19T03:58:43.2201924Z 2019-12-19 3:55:34 0 [Warning] InnoDB: A long semaphore wait: 2019-12-19T03:58:43.2202576Z 2019-12-19 3:56:05 0 [Warning] InnoDB: A long semaphore wait: 2019-12-19T03:58:43.2203074Z 2019-12-19 3:56:05 0 [Warning] InnoDB: A long semaphore wait: 2019-12-19T03:58:43.2203900Z 2019-12-19 3:56:36 0 [Warning] InnoDB: A long semaphore wait: 2019-12-19T03:58:43.2204589Z 2019-12-19 3:56:36 0 [Warning] InnoDB: A long semaphore wait: 2019-12-19T03:58:43.2205185Z 2019-12-19 3:57:07 0 [Warning] InnoDB: A long semaphore wait: 2019-12-19T03:58:43.2205769Z 2019-12-19 3:57:07 0 [Warning] InnoDB: A long semaphore wait: 2019-12-19T03:58:43.2206356Z 2019-12-19 3:57:38 0 [Warning] InnoDB: A long semaphore wait: 2019-12-19T03:58:43.2206930Z 2019-12-19 3:57:38 0 [Warning] InnoDB: A long semaphore wait: 2019-12-19T03:58:43.2207631Z 2019-12-19 3:58:09 0 [Warning] InnoDB: A long semaphore wait: 2019-12-19T03:58:43.2208293Z 2019-12-19 3:58:09 0 [Warning] InnoDB: A long semaphore wait: 2019-12-19T03:58:43.2208914Z 2019-12-19 3:58:09 0 [Warning] InnoDB: A long semaphore wait: 2019-12-19T03:58:43.2209511Z 2019-12-19 3:58:39 0 [ERROR] [FATAL] InnoDB: Semaphore wait has lasted > 600 seconds. We intentionally crash the server because it appears to be hung. 2019-12-19T03:58:43.2209827Z Attempting backtrace. You can use the following information to find out 2019-12-19T03:58:43.2210026Z