2018-04-10 07:11:41 7f54e13ff700 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 38 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 22900 srv_active, 0 srv_shutdown, 14842 srv_idle
srv_master_thread log flush and writes: 37742
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 30762
--Thread 140002565647104 has waited at trx0sys.ic line 103 for 246.00 seconds the semaphore:
X-lock (wait_ex) on RW-latch at 0x7f5526ffe620 '&block->lock'
a writer (thread id 140002565647104) has reserved it in mode  wait exclusive
number of readers 1, waiters flag 0, lock_word: ffffffffffffffff
Last time read locked in file buf0flu.cc line 1113
Last time write locked in file trx0sys.ic line 103
Holder thread 0 file not yet reserved line 0
--Thread 140004157090560 has waited at trx0trx.cc line 1056 for 245.00 seconds the semaphore:
Mutex at 0x7f5567885868 '&trx_sys->mutex', lock var 1
Last time reserved by thread 140002565647104 in file not yet reserved line 0, waiters flag 1
--Thread 140002563222272 has waited at trx0trx.cc line 1056 for 235.00 seconds the semaphore:
Mutex at 0x7f5567885868 '&trx_sys->mutex', lock var 1
Last time reserved by thread 140002565647104 in file not yet reserved line 0, waiters flag 1
--Thread 140003134294784 has waited at trx0trx.cc line 1056 for 230.00 seconds the semaphore:
Mutex at 0x7f5567885868 '&trx_sys->mutex', lock var 1
Last time reserved by thread 140002565647104 in file not yet reserved line 0, waiters flag 1
--Thread 140003133991680 has waited at trx0trx.cc line 1056 for 230.00 seconds the semaphore:
Mutex at 0x7f5567885868 '&trx_sys->mutex', lock var 1
Last time reserved by thread 140002565647104 in file not yet reserved line 0, waiters flag 1
--Thread 140002564737792 has waited at trx0trx.cc line 1056 for 230.00 seconds the semaphore:
Mutex at 0x7f5567885868 '&trx_sys->mutex', lock var 1
Last time reserved by thread 140002565647104 in file not yet reserved line 0, waiters flag 1
--Thread 140003844340480 has waited at trx0trx.cc line 1056 for 228.00 seconds the semaphore:
Mutex at 0x7f5567885868 '&trx_sys->mutex', lock var 1
Last time reserved by thread 140002565647104 in file not yet reserved line 0, waiters flag 1
--Thread 140003842521856 has waited at trx0trx.cc line 1056 for 223.00 seconds the semaphore:
Mutex at 0x7f5567885868 '&trx_sys->mutex', lock var 1
Last time reserved by thread 140002565647104 in file not yet reserved line 0, waiters flag 1
--Thread 140002524347136 has waited at trx0trx.cc line 1056 for 214.00 seconds the semaphore:
Mutex at 0x7f5567885868 '&trx_sys->mutex', lock var 1
Last time reserved by thread 140002565647104 in file not yet reserved line 0, waiters flag 1
--Thread 140002566253312 has waited at trx0trx.cc line 1056 for 214.00 seconds the semaphore:
Mutex at 0x7f5567885868 '&trx_sys->mutex', lock var 1
Last time reserved by thread 140002565647104 in file not yet reserved line 0, waiters flag 1
--Thread 140003133688576 has waited at trx0trx.cc line 1056 for 165.00 seconds the semaphore:
Mutex at 0x7f5567885868 '&trx_sys->mutex', lock var 1
Last time reserved by thread 140002565647104 in file not yet reserved line 0, waiters flag 1
--Thread 140003134597888 has waited at trx0trx.cc line 1056 for 156.00 seconds the semaphore:
Mutex at 0x7f5567885868 '&trx_sys->mutex', lock var 1
Last time reserved by thread 140002565647104 in file not yet reserved line 0, waiters flag 1
--Thread 140003844946688 has waited at trx0trx.cc line 1056 for 84.000 seconds the semaphore:
Mutex at 0x7f5567885868 '&trx_sys->mutex', lock var 1
Last time reserved by thread 140002565647104 in file not yet reserved line 0, waiters flag 1
--Thread 140002705394432 has waited at trx0trx.cc line 1056 for 36.000 seconds the semaphore:
Mutex at 0x7f5567885868 '&trx_sys->mutex', lock var 1
Last time reserved by thread 140002565647104 in file not yet reserved line 0, waiters flag 1
OS WAIT ARRAY INFO: signal count 30116
Mutex spin waits 43626, rounds 833943, OS waits 22959
RW-shared spins 9743, rounds 260004, OS waits 7300
RW-excl spins 112, rounds 6347, OS waits 173
Spin rounds per wait: 19.12 mutex, 26.69 RW-shared, 56.67 RW-excl
------------
TRANSACTIONS
------------
Trx id counter 1029171200
Purge done for trx's n:o < 1029170992 undo n:o < 0 state: running but idle
History list length 26
LIST OF TRANSACTIONS FOR EACH SESSION:
InnoDB: ###### Diagnostic info printed to the standard error stream
InnoDB: Warning: a long semaphore wait:
--Thread 140002565647104 has waited at trx0sys.ic line 103 for 272.00 seconds the semaphore:
X-lock (wait_ex) on RW-latch at 0x7f5526ffe620 '&block->lock'
a writer (thread id 140002565647104) has reserved it in mode  wait exclusive
number of readers 1, waiters flag 0, lock_word: ffffffffffffffff
Last time read locked in file buf0flu.cc line 1113
Last time write locked in file trx0sys.ic line 103
Holder thread 0 file not yet reserved line 0
InnoDB: Warning: a long semaphore wait:
--Thread 140004157090560 has waited at trx0trx.cc line 1056 for 271.00 seconds the semaphore:
Mutex at 0x7f5567885868 '&trx_sys->mutex', lock var 1
Last time reserved by thread 140002565647104 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: a long semaphore wait:
--Thread 140002563222272 has waited at trx0trx.cc line 1056 for 261.00 seconds the semaphore:
Mutex at 0x7f5567885868 '&trx_sys->mutex', lock var 1
Last time reserved by thread 140002565647104 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: a long semaphore wait:
--Thread 140003134294784 has waited at trx0trx.cc line 1056 for 256.00 seconds the semaphore:
Mutex at 0x7f5567885868 '&trx_sys->mutex', lock var 1
Last time reserved by thread 140002565647104 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: a long semaphore wait:
--Thread 140003133991680 has waited at trx0trx.cc line 1056 for 256.00 seconds the semaphore:
Mutex at 0x7f5567885868 '&trx_sys->mutex', lock var 1
Last time reserved by thread 140002565647104 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: a long semaphore wait:
--Thread 140002564737792 has waited at trx0trx.cc line 1056 for 256.00 seconds the semaphore:
Mutex at 0x7f5567885868 '&trx_sys->mutex', lock var 1
Last time reserved by thread 140002565647104 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: a long semaphore wait:
--Thread 140003844340480 has waited at trx0trx.cc line 1056 for 254.00 seconds the semaphore:
Mutex at 0x7f5567885868 '&trx_sys->mutex', lock var 1
Last time reserved by thread 140002565647104 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: a long semaphore wait:
--Thread 140003842521856 has waited at trx0trx.cc line 1056 for 249.00 seconds the semaphore:
Mutex at 0x7f5567885868 '&trx_sys->mutex', lock var 1
Last time reserved by thread 140002565647104 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: semaphore wait:
--Thread 140002565647104 has waited at trx0sys.ic line 103 for 272.00 seconds the semaphore:
X-lock (wait_ex) on RW-latch at 0x7f5526ffe620 '&block->lock'
a writer (thread id 140002565647104) has reserved it in mode  wait exclusive
number of readers 1, waiters flag 0, lock_word: ffffffffffffffff
Last time read locked in file buf0flu.cc line 1113
Last time write locked in file trx0sys.ic line 103
Holder thread 0 file not yet reserved line 0
InnoDB: Warning: Writer thread is waiting this semaphore:
--Thread 140002565647104 has waited at trx0sys.ic line 103 for 272.00 seconds the semaphore:
X-lock (wait_ex) on RW-latch at 0x7f5526ffe620 '&block->lock'
a writer (thread id 140002565647104) has reserved it in mode  wait exclusive
number of readers 1, waiters flag 0, lock_word: ffffffffffffffff
Last time read locked in file buf0flu.cc line 1113
Last time write locked in file trx0sys.ic line 103
Holder thread 0 file not yet reserved line 0
InnoDB: Warning: semaphore wait:
--Thread 140004157090560 has waited at trx0trx.cc line 1056 for 271.00 seconds the semaphore:
Mutex at 0x7f5567885868 '&trx_sys->mutex', lock var 1
Last time reserved by thread 140002565647104 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: semaphore wait:
--Thread 140002563222272 has waited at trx0trx.cc line 1056 for 261.00 seconds the semaphore:
Mutex at 0x7f5567885868 '&trx_sys->mutex', lock var 1
Last time reserved by thread 140002565647104 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: semaphore wait:
--Thread 140003134294784 has waited at trx0trx.cc line 1056 for 256.00 seconds the semaphore:
Mutex at 0x7f5567885868 '&trx_sys->mutex', lock var 1
Last time reserved by thread 140002565647104 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: semaphore wait:
--Thread 140003133991680 has waited at trx0trx.cc line 1056 for 256.00 seconds the semaphore:
Mutex at 0x7f5567885868 '&trx_sys->mutex', lock var 1
Last time reserved by thread 140002565647104 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: semaphore wait:
--Thread 140002564737792 has waited at trx0trx.cc line 1056 for 256.00 seconds the semaphore:
Mutex at 0x7f5567885868 '&trx_sys->mutex', lock var 1
Last time reserved by thread 140002565647104 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: semaphore wait:
--Thread 140003844340480 has waited at trx0trx.cc line 1056 for 254.00 seconds the semaphore:
Mutex at 0x7f5567885868 '&trx_sys->mutex', lock var 1
Last time reserved by thread 140002565647104 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: semaphore wait:
--Thread 140003842521856 has waited at trx0trx.cc line 1056 for 249.00 seconds the semaphore:
Mutex at 0x7f5567885868 '&trx_sys->mutex', lock var 1
Last time reserved by thread 140002565647104 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: semaphore wait:
--Thread 140002524347136 has waited at trx0trx.cc line 1056 for 240.00 seconds the semaphore:
Mutex at 0x7f5567885868 '&trx_sys->mutex', lock var 1
Last time reserved by thread 140002565647104 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: semaphore wait:
--Thread 140002566253312 has waited at trx0trx.cc line 1056 for 240.00 seconds the semaphore:
Mutex at 0x7f5567885868 '&trx_sys->mutex', lock var 1
Last time reserved by thread 140002565647104 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: semaphore wait:
--Thread 140003133688576 has waited at trx0trx.cc line 1056 for 191.00 seconds the semaphore:
Mutex at 0x7f5567885868 '&trx_sys->mutex', lock var 1
Last time reserved by thread 140002565647104 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: semaphore wait:
--Thread 140003134597888 has waited at trx0trx.cc line 1056 for 182.00 seconds the semaphore:
Mutex at 0x7f5567885868 '&trx_sys->mutex', lock var 1
Last time reserved by thread 140002565647104 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: semaphore wait:
--Thread 140003844946688 has waited at trx0trx.cc line 1056 for 110.00 seconds the semaphore:
Mutex at 0x7f5567885868 '&trx_sys->mutex', lock var 1
Last time reserved by thread 140002565647104 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: semaphore wait:
--Thread 140002705394432 has waited at trx0trx.cc line 1056 for 62.000 seconds the semaphore:
Mutex at 0x7f5567885868 '&trx_sys->mutex', lock var 1
Last time reserved by thread 140002565647104 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: semaphore wait:
--Thread 140002533046016 has waited at lock0lock.cc line 6338 for 26.000 seconds the semaphore:
Mutex at 0x7f5567885868 '&trx_sys->mutex', lock var 1
Last time reserved by thread 140002565647104 in file not yet reserved line 0, waiters flag 1
InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info:
InnoDB: Pending reads 0, writes 0
InnoDB: ###### Diagnostic info printed to the standard error stream
InnoDB: Warning: a long semaphore wait:
--Thread 140002565647104 has waited at trx0sys.ic line 103 for 303.00 seconds the semaphore:
X-lock (wait_ex) on RW-latch at 0x7f5526ffe620 '&block->lock'
a writer (thread id 140002565647104) has reserved it in mode  wait exclusive
number of readers 1, waiters flag 0, lock_word: ffffffffffffffff
Last time read locked in file buf0flu.cc line 1113
Last time write locked in file trx0sys.ic line 103
Holder thread 0 file not yet reserved line 0
InnoDB: Warning: a long semaphore wait:
--Thread 140004157090560 has waited at trx0trx.cc line 1056 for 302.00 seconds the semaphore:
Mutex at 0x7f5567885868 '&trx_sys->mutex', lock var 1
Last time reserved by thread 140002565647104 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: a long semaphore wait:
--Thread 140002563222272 has waited at trx0trx.cc line 1056 for 292.00 seconds the semaphore:
Mutex at 0x7f5567885868 '&trx_sys->mutex', lock var 1
Last time reserved by thread 140002565647104 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: a long semaphore wait:
--Thread 140003134294784 has waited at trx0trx.cc line 1056 for 287.00 seconds the semaphore:
Mutex at 0x7f5567885868 '&trx_sys->mutex', lock var 1
Last time reserved by thread 140002565647104 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: a long semaphore wait:
--Thread 140003133991680 has waited at trx0trx.cc line 1056 for 287.00 seconds the semaphore:
Mutex at 0x7f5567885868 '&trx_sys->mutex', lock var 1
Last time reserved by thread 140002565647104 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: a long semaphore wait:
--Thread 140002564737792 has waited at trx0trx.cc line 1056 for 287.00 seconds the semaphore:
Mutex at 0x7f5567885868 '&trx_sys->mutex', lock var 1
Last time reserved by thread 140002565647104 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: a long semaphore wait:
--Thread 140003844340480 has waited at trx0trx.cc line 1056 for 285.00 seconds the semaphore:
Mutex at 0x7f5567885868 '&trx_sys->mutex', lock var 1
Last time reserved by thread 140002565647104 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: a long semaphore wait:
--Thread 140003842521856 has waited at trx0trx.cc line 1056 for 280.00 seconds the semaphore:
Mutex at 0x7f5567885868 '&trx_sys->mutex', lock var 1
Last time reserved by thread 140002565647104 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: a long semaphore wait:
--Thread 140002524347136 has waited at trx0trx.cc line 1056 for 271.00 seconds the semaphore:
Mutex at 0x7f5567885868 '&trx_sys->mutex', lock var 1
Last time reserved by thread 140002565647104 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: a long semaphore wait:
--Thread 140002566253312 has waited at trx0trx.cc line 1056 for 271.00 seconds the semaphore:
Mutex at 0x7f5567885868 '&trx_sys->mutex', lock var 1
Last time reserved by thread 140002565647104 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: semaphore wait:
--Thread 140002565647104 has waited at trx0sys.ic line 103 for 303.00 seconds the semaphore:
X-lock (wait_ex) on RW-latch at 0x7f5526ffe620 '&block->lock'
a writer (thread id 140002565647104) has reserved it in mode  wait exclusive
number of readers 1, waiters flag 0, lock_word: ffffffffffffffff
Last time read locked in file buf0flu.cc line 1113
Last time write locked in file trx0sys.ic line 103
Holder thread 0 file not yet reserved line 0
InnoDB: Warning: Writer thread is waiting this semaphore:
--Thread 140002565647104 has waited at trx0sys.ic line 103 for 303.00 seconds the semaphore:
X-lock (wait_ex) on RW-latch at 0x7f5526ffe620 '&block->lock'
a writer (thread id 140002565647104) has reserved it in mode  wait exclusive
number of readers 1, waiters flag 0, lock_word: ffffffffffffffff
Last time read locked in file buf0flu.cc line 1113
Last time write locked in file trx0sys.ic line 103
Holder thread 0 file not yet reserved line 0
InnoDB: Warning: semaphore wait:
--Thread 140004157090560 has waited at trx0trx.cc line 1056 for 302.00 seconds the semaphore:
Mutex at 0x7f5567885868 '&trx_sys->mutex', lock var 1
Last time reserved by thread 140002565647104 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: semaphore wait:
--Thread 140002563222272 has waited at trx0trx.cc line 1056 for 292.00 seconds the semaphore:
Mutex at 0x7f5567885868 '&trx_sys->mutex', lock var 1
Last time reserved by thread 140002565647104 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: semaphore wait:
--Thread 140003134294784 has waited at trx0trx.cc line 1056 for 287.00 seconds the semaphore:
Mutex at 0x7f5567885868 '&trx_sys->mutex', lock var 1
Last time reserved by thread 140002565647104 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: semaphore wait:
--Thread 140003133991680 has waited at trx0trx.cc line 1056 for 287.00 seconds the semaphore:
Mutex at 0x7f5567885868 '&trx_sys->mutex', lock var 1
Last time reserved by thread 140002565647104 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: semaphore wait:
--Thread 140002564737792 has waited at trx0trx.cc line 1056 for 287.00 seconds the semaphore:
Mutex at 0x7f5567885868 '&trx_sys->mutex', lock var 1
Last time reserved by thread 140002565647104 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: semaphore wait:
--Thread 140003844340480 has waited at trx0trx.cc line 1056 for 285.00 seconds the semaphore:
Mutex at 0x7f5567885868 '&trx_sys->mutex', lock var 1
Last time reserved by thread 140002565647104 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: semaphore wait:
--Thread 140003842521856 has waited at trx0trx.cc line 1056 for 280.00 seconds the semaphore:
Mutex at 0x7f5567885868 '&trx_sys->mutex', lock var 1
Last time reserved by thread 140002565647104 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: semaphore wait:
--Thread 140002524347136 has waited at trx0trx.cc line 1056 for 271.00 seconds the semaphore:
Mutex at 0x7f5567885868 '&trx_sys->mutex', lock var 1
Last time reserved by thread 140002565647104 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: semaphore wait:
--Thread 140002566253312 has waited at trx0trx.cc line 1056 for 271.00 seconds the semaphore:
Mutex at 0x7f5567885868 '&trx_sys->mutex', lock var 1
Last time reserved by thread 140002565647104 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: semaphore wait:
--Thread 140003133688576 has waited at trx0trx.cc line 1056 for 222.00 seconds the semaphore:
Mutex at 0x7f5567885868 '&trx_sys->mutex', lock var 1
Last time reserved by thread 140002565647104 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: semaphore wait:
--Thread 140003134597888 has waited at trx0trx.cc line 1056 for 213.00 seconds the semaphore:
Mutex at 0x7f5567885868 '&trx_sys->mutex', lock var 1
Last time reserved by thread 140002565647104 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: semaphore wait:
--Thread 140003844946688 has waited at trx0trx.cc line 1056 for 141.00 seconds the semaphore:
Mutex at 0x7f5567885868 '&trx_sys->mutex', lock var 1
Last time reserved by thread 140002565647104 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: semaphore wait:
--Thread 140002705394432 has waited at trx0trx.cc line 1056 for 93.000 seconds the semaphore:
Mutex at 0x7f5567885868 '&trx_sys->mutex', lock var 1
Last time reserved by thread 140002565647104 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: semaphore wait:
--Thread 140002533046016 has waited at lock0lock.cc line 6338 for 57.000 seconds the semaphore:
Mutex at 0x7f5567885868 '&trx_sys->mutex', lock var 1
Last time reserved by thread 140002565647104 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: semaphore wait:
--Thread 140004158909184 has waited at srv0srv.cc line 1806 for 30.000 seconds the semaphore:
Mutex at 0x55fb833cad40 '&srv_innodb_monitor_mutex', lock var 1
Last time reserved by thread 140002533046016 in file not yet reserved line 0, waiters flag 1
InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info:
InnoDB: Pending reads 0, writes 0
InnoDB: ###### Diagnostic info printed to the standard error stream
2018-04-10  7:31:23 139999441798912 [Note] WSREP: resuming provider at 211197
2018-04-10  7:31:23 139999441798912 [Note] WSREP: Provider resumed.
---TRANSACTION 1029171200, not started
MySQL thread id 40090, OS thread handle 0x7f54e3316b00, query id 3219068 azhdnl-ar03.azure.cloud.corp.local 10.134.17.157 01_MS_LITHUANIA_PP cleaning up
---TRANSACTION 1029170990, not started
MySQL thread id 2, OS thread handle 0x7f556cc4eb00, query id 3219515 Opening tables
---TRANSACTION 1025731587, not started
MySQL thread id 4, OS thread handle 0x7f556cb52b00, query id 0 Waiting for requests
---TRANSACTION 1029171213, ACTIVE 0 sec
Trx #rec lock waits 0 #table lock waits 0
Trx total rec lock wait time 0 SEC
Trx total table lock wait time 0 SEC
---TRANSACTION 1029171212, ACTIVE 0 sec
Trx #rec lock waits 0 #table lock waits 0
Trx total rec lock wait time 0 SEC
Trx total table lock wait time 0 SEC
---TRANSACTION 1029171211, ACTIVE 0 sec
Trx #rec lock waits 0 #table lock waits 0
Trx total rec lock wait time 0 SEC
Trx total table lock wait time 0 SEC
---TRANSACTION 1029171210, ACTIVE 0 sec
Trx #rec lock waits 0 #table lock waits 0
Trx total rec lock wait time 0 SEC
Trx total table lock wait time 0 SEC
---TRANSACTION 1029171209, ACTIVE 0 sec
Trx #rec lock waits 0 #table lock waits 0
Trx total rec lock wait time 0 SEC
Trx total table lock wait time 0 SEC
---TRANSACTION 1029171208, ACTIVE 0 sec
Trx #rec lock waits 0 #table lock waits 0
Trx total rec lock wait time 0 SEC
Trx total table lock wait time 0 SEC
---TRANSACTION 1029171207, ACTIVE 0 sec
Trx #rec lock waits 0 #table lock waits 0
Trx total rec lock wait time 0 SEC
Trx total table lock wait time 0 SEC
---TRANSACTION 1029171206, ACTIVE 0 sec
Trx #rec lock waits 0 #table lock waits 0
Trx total rec lock wait time 0 SEC
Trx total table lock wait time 0 SEC
---TRANSACTION 1029171205, ACTIVE 0 sec
Trx #rec lock waits 0 #table lock waits 0
Trx total rec lock wait time 0 SEC
Trx total table lock wait time 0 SEC
---TRANSACTION 1029171204, ACTIVE 0 sec
Trx #rec lock waits 0 #table lock waits 0
Trx total rec lock wait time 0 SEC
Trx total table lock wait time 0 SEC
---TRANSACTION 1029171203, ACTIVE 0 sec
Trx #rec lock waits 0 #table lock waits 0
Trx total rec lock wait time 0 SEC
Trx total table lock wait time 0 SEC
---TRANSACTION 1029171202, ACTIVE 0 sec
Trx #rec lock waits 0 #table lock waits 0
Trx total rec lock wait time 0 SEC
Trx total table lock wait time 0 SEC
---TRANSACTION 1029171201, ACTIVE 0 sec
Trx #rec lock waits 0 #table lock waits 0
Trx total rec lock wait time 0 SEC
Trx total table lock wait time 0 SEC
--------
FILE I/O
--------
I/O thread 0 state: waiting for completed aio requests (insert buffer thread)
I/O thread 1 state: waiting for completed aio requests (log thread)
I/O thread 2 state: waiting for completed aio requests (read thread)
I/O thread 3 state: waiting for completed aio requests (read thread)
I/O thread 4 state: waiting for completed aio requests (read thread)
I/O thread 5 state: waiting for completed aio requests (read thread)
I/O thread 6 state: waiting for completed aio requests (write thread)
I/O thread 7 state: waiting for completed aio requests (write thread)
I/O thread 8 state: waiting for completed aio requests (write thread)
I/O thread 9 state: complete io for buf page (write thread)
Pending normal aio reads: 0 [0, 0, 0, 0] , aio writes: 0 [0, 0, 0, 0] ,
 ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0
Pending flushes (fsync) log: 0; buffer pool: 2
1948207 OS file reads, 726498 OS file writes, 60228 OS fsyncs
0.00 reads/s, 0 avg bytes/read, 0.09 writes/s, 0.00 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 3043, seg size 3045, 387 merges
merged operations:
 insert 208, delete mark 4053, delete 201
discarded operations:
 insert 0, delete mark 0, delete 0
0.00 hash searches/s, 40.00 non-hash searches/s
---
LOG
---
Log sequence number 609380213011
Log flushed up to   609380210887
Pages flushed up to 609380194261
Last checkpoint at  609380192231
Max checkpoint age    80826164
Checkpoint age target 78300347
Modified age          18750
Checkpoint age        20780
0 pending log writes, 0 pending chkp writes
443324 log i/o's done, 0.01 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total memory allocated 1124597760; in additional pool allocated 0
Total memory allocated by read views 3056
Internal hash tables (constant factor + variable factor)
    Adaptive hash index 18926128        (18921928 + 4200)
    Page hash           139112 (buffer pool 0 only)
    Dictionary cache    13930525        (4426736 + 9503789)
    File system         64138816        (812272 + 63326544)
    Lock system         2666536         (2657176 + 9360)
    Recovery system     0       (0 + 0)
Dictionary memory allocated 9503789
Buffer pool size        65528
Buffer pool size, bytes 1073610752
Free buffers            8192
Database pages          57336
Old database pages      21000
Modified db pages       52
Percent of dirty pages(LRU & free pages): 0.079
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 2, single page 0
Pages made young 118154, not young 115333484
0.00 youngs/s, 0.00 non-youngs/s
Pages read 1878759, created 5359, written 271901
0.00 reads/s, 0.00 creates/s, 0.09 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 1 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 57336, unzip_LRU len: 0
I/O sum[0]:cur[1], unzip sum[0]:cur[0]
----------------------
INDIVIDUAL BUFFER POOL INFO
----------------------
---BUFFER POOL 0
Buffer pool size        8191
Buffer pool size, bytes 134201344
Free buffers            1024
Database pages          7167
Old database pages      2625
Modified db pages       27
Percent of dirty pages(LRU & free pages): 0.330
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 2, single page 0
Pages made young 18896, not young 14757802
0.00 youngs/s, 0.00 non-youngs/s
Pages read 240974, created 1183, written 65130
0.00 reads/s, 0.00 creates/s, 0.02 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 2 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 7167, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 1
Buffer pool size        8191
Buffer pool size, bytes 134201344
Free buffers            1024
Database pages          7167
Old database pages      2625
Modified db pages       0
Percent of dirty pages(LRU & free pages): 0.000
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 16051, not young 14029525
0.00 youngs/s, 0.00 non-youngs/s
Pages read 234827, created 632, written 21915
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 7167, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 2
Buffer pool size        8191
Buffer pool size, bytes 134201344
Free buffers            1024
Database pages          7167
Old database pages      2625
Modified db pages       1
Percent of dirty pages(LRU & free pages): 0.012
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 16689, not young 14668140
0.00 youngs/s, 0.00 non-youngs/s
Pages read 236108, created 648, written 14443
0.00 reads/s, 0.00 creates/s, 0.02 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 7167, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 3
Buffer pool size        8191
Buffer pool size, bytes 134201344
Free buffers            1024
Database pages          7167
Old database pages      2625
Modified db pages       5
Percent of dirty pages(LRU & free pages): 0.061
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 13534, not young 14445892
0.00 youngs/s, 0.00 non-youngs/s
Pages read 237194, created 627, written 72076
0.00 reads/s, 0.00 creates/s, 0.02 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 7167, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 4
Buffer pool size        8191
Buffer pool size, bytes 134201344
Free buffers            1024
Database pages          7167
Old database pages      2625
Modified db pages       17
Percent of dirty pages(LRU & free pages): 0.208
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 12019, not young 14574563
0.00 youngs/s, 0.00 non-youngs/s
Pages read 233123, created 436, written 49516
0.00 reads/s, 0.00 creates/s, 0.02 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 7167, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 5
Buffer pool size        8191
Buffer pool size, bytes 134201344
Free buffers            1024
Database pages          7167
Old database pages      2625
Modified db pages       1
Percent of dirty pages(LRU & free pages): 0.012
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 10731, not young 14006971
0.00 youngs/s, 0.00 non-youngs/s
Pages read 229658, created 638, written 16672
0.00 reads/s, 0.00 creates/s, 0.01 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 7167, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 6
Buffer pool size        8191
Buffer pool size, bytes 134201344
Free buffers            1024
Database pages          7167
Old database pages      2625
Modified db pages       0
Percent of dirty pages(LRU & free pages): 0.000
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 14160, not young 14429464
0.00 youngs/s, 0.00 non-youngs/s
Pages read 233729, created 420, written 7195
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 1 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 7167, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 7
Buffer pool size        8191
Buffer pool size, bytes 134201344
Free buffers            1024
Database pages          7167
Old database pages      2625
Modified db pages       1
Percent of dirty pages(LRU & free pages): 0.012
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 16074, not young 14421127
0.00 youngs/s, 0.00 non-youngs/s
Pages read 233146, created 775, written 24954
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 8 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 7167, unzip_LRU len: 0
I/O sum[0]:cur[1], unzip sum[0]:cur[0]
--------------
ROW OPERATIONS
--------------
0 queries inside InnoDB, 0 queries in queue
0 read views open inside InnoDB
1 RW transactions active inside InnoDB
0 RO transactions active inside InnoDB
1 out of 1000 descriptors used
Main thread process no. 118144, id 140002386241280, state: making checkpoint
Number of rows inserted 20974, updated 196402, deleted 19617, read 218751199
0.00 inserts/s, 0.13 updates/s, 0.00 deletes/s, 11.53 reads/s
Number of system rows inserted 0, updated 0, deleted 0, read 0
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================
2018-04-10  7:31:23 140004168820480 [Note] WSREP: 0.0 (azabnl-id01): State transfer to 1.0 (azabnl-id05) complete.
2018-04-10  7:31:23 140004168820480 [Note] WSREP: Shifting DONOR/DESYNCED -> JOINED (TO: 80616856)
2018-04-10  7:31:33 140004168820480 [Note] WSREP: Member 0.0 (azabnl-id01) synced with group.
2018-04-10  7:31:33 140004168820480 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 80616858)
2018-04-10  7:31:33 140004873792256 [Note] WSREP: Synchronized with group, ready for connections
2018-04-10  7:31:33 140004873792256 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2018-04-10  7:33:22 140004168820480 [Note] WSREP: 1.0 (azabnl-id05): State transfer from 0.0 (azabnl-id01) complete.
2018-04-10  7:33:24 140004177213184 [Note] WSREP: declaring 2da75f6b at tcp://10.134.17.5:4567 stable
2018-04-10  7:33:24 140004177213184 [Note] WSREP: forgetting 10fff4bd (tcp://10.134.17.26:4567)
2018-04-10  7:33:24 140004177213184 [Note] WSREP: Node 080605d2 state prim
2018-04-10  7:33:24 140004177213184 [Note] WSREP: view(view_id(PRIM,080605d2,30) memb {
        080605d2,0
        2da75f6b,0
} joined {
} left {
} partitioned {
        10fff4bd,0
})
2018-04-10  7:33:24 140004177213184 [Note] WSREP: save pc into disk
2018-04-10  7:33:24 140004177213184 [Note] WSREP: forgetting 10fff4bd (tcp://10.134.17.26:4567)
2018-04-10  7:33:24 140004168820480 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 2
2018-04-10  7:33:24 140004168820480 [Note] WSREP: STATE_EXCHANGE: sent state UUID: b04aeae0-3c80-11e8-9ac9-1ec436db9518
2018-04-10  7:33:24 140004168820480 [Note] WSREP: STATE EXCHANGE: sent state msg: b04aeae0-3c80-11e8-9ac9-1ec436db9518
2018-04-10  7:33:24 140004168820480 [Note] WSREP: STATE EXCHANGE: got state msg: b04aeae0-3c80-11e8-9ac9-1ec436db9518 from 0 (azabnl-id01)
2018-04-10  7:33:24 140004168820480 [Note] WSREP: STATE EXCHANGE: got state msg: b04aeae0-3c80-11e8-9ac9-1ec436db9518 from 1 (azabnl-id02)
2018-04-10  7:33:24 140004168820480 [Note] WSREP: Quorum results:
        version    = 4,
        component  = PRIMARY,
        conf_id    = 29,
        members    = 2/2 (joined/total),
        act_id     = 80617822,
        last_appl. = 80617741,
        protocols  = 0/8/3 (gcs/repl/appl),
        group UUID = 3b836c50-a528-11e7-8e1f-2f4e7221cd1d
2018-04-10  7:33:24 140004168820480 [Note] WSREP: Flow-control interval: [23, 23]
2018-04-10  7:33:24 140004168820480 [Note] WSREP: Trying to continue unpaused monitor
2018-04-10  7:33:24 140004873792256 [Note] WSREP: New cluster view: global state: 3b836c50-a528-11e7-8e1f-2f4e7221cd1d:80617822, view# 30: Primary, number of nodes: 2, my index: 0, protocol version 3
2018-04-10  7:33:24 140004873792256 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2018-04-10  7:33:24 140004873792256 [Note] WSREP: REPL Protocols: 8 (3, 2)
2018-04-10  7:33:24 140004873792256 [Note] WSREP: Assign initial position for certification: 80617822, protocol version: 3
2018-04-10  7:33:24 140004227147520 [Note] WSREP: Service thread queue flushed.
2018-04-10  7:33:29 140004177213184 [Note] WSREP:  cleaning up 10fff4bd (tcp://10.134.17.26:4567)
2018-04-10  7:39:33 140004177213184 [Note] WSREP: (080605d2, 'tcp://0.0.0.0:4567') connection established to 8ab87730 tcp://10.134.17.26:4567
2018-04-10  7:39:33 140004177213184 [Note] WSREP: (080605d2, 'tcp://0.0.0.0:4567') turning message relay requesting on, nonlive peers:
2018-04-10  7:39:34 140004177213184 [Note] WSREP: declaring 2da75f6b at tcp://10.134.17.5:4567 stable
2018-04-10  7:39:34 140004177213184 [Note] WSREP: declaring 8ab87730 at tcp://10.134.17.26:4567 stable
2018-04-10  7:39:34 140004177213184 [Note] WSREP: Node 080605d2 state prim
2018-04-10  7:39:34 140004177213184 [Note] WSREP: view(view_id(PRIM,080605d2,31) memb {
        080605d2,0
        2da75f6b,0
        8ab87730,0
} joined {
} left {
} partitioned {
})
2018-04-10  7:39:34 140004177213184 [Note] WSREP: save pc into disk
2018-04-10  7:39:34 140004168820480 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 3
2018-04-10  7:39:34 140004168820480 [Note] WSREP: STATE_EXCHANGE: sent state UUID: 8cb57b30-3c81-11e8-ab67-ef465d39bf7c
2018-04-10  7:39:34 140004168820480 [Note] WSREP: STATE EXCHANGE: sent state msg: 8cb57b30-3c81-11e8-ab67-ef465d39bf7c
2018-04-10  7:39:34 140004168820480 [Note] WSREP: STATE EXCHANGE: got state msg: 8cb57b30-3c81-11e8-ab67-ef465d39bf7c from 0 (azabnl-id01)
2018-04-10  7:39:34 140004168820480 [Note] WSREP: STATE EXCHANGE: got state msg: 8cb57b30-3c81-11e8-ab67-ef465d39bf7c from 1 (azabnl-id02)
2018-04-10  7:39:34 140004168820480 [Note] WSREP: STATE EXCHANGE: got state msg: 8cb57b30-3c81-11e8-ab67-ef465d39bf7c from 2 (azabnl-id05)
2018-04-10  7:39:34 140004168820480 [Note] WSREP: Quorum results:
        version    = 4,
        component  = PRIMARY,
        conf_id    = 30,
        members    = 2/3 (joined/total),
        act_id     = 80619388,
        last_appl. = 80619277,
        protocols  = 0/7/3 (gcs/repl/appl),
        group UUID = 3b836c50-a528-11e7-8e1f-2f4e7221cd1d
2018-04-10  7:39:34 140004168820480 [Note] WSREP: Flow-control interval: [28, 28]
2018-04-10  7:39:34 140004168820480 [Note] WSREP: Trying to continue unpaused monitor
2018-04-10  7:39:34 140004873792256 [Note] WSREP: New cluster view: global state: 3b836c50-a528-11e7-8e1f-2f4e7221cd1d:80619388, view# 31: Primary, number of nodes: 3, my index: 0, protocol version 3
2018-04-10  7:39:34 140004873792256 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2018-04-10  7:39:34 140004873792256 [Note] WSREP: REPL Protocols: 7 (3, 2)
2018-04-10  7:39:34 140004873792256 [Note] WSREP: Assign initial position for certification: 80619388, protocol version: 3
2018-04-10  7:39:34 140004227147520 [Note] WSREP: Service thread queue flushed.
2018-04-10  7:39:35 140004168820480 [Note] WSREP: Member 2.0 (azabnl-id05) requested state transfer from '*any*'. Selected 0.0 (azabnl-id01)(SYNCED) as donor.
2018-04-10  7:39:35 140004168820480 [Note] WSREP: Shifting SYNCED -> DONOR/DESYNCED (TO: 80619388)
2018-04-10  7:39:35 140004873792256 [Note] WSREP: IST request: 3b836c50-a528-11e7-8e1f-2f4e7221cd1d:0-80619388|tcp://10.134.17.26:4568
2018-04-10  7:39:35 140004873792256 [Note] WSREP: IST first seqno 1 not found from cache, falling back to SST
2018-04-10  7:39:35 140004873792256 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2018-04-10  7:39:35 139999433406208 [Note] WSREP: Running: 'wsrep_sst_rsync --role 'donor' --address '10.134.17.26:4444/rsync_sst' --socket '/var/lib/mysql/mysql.sock' --datadir '/mnt/data/'     '' --gtid '3b836c50-a528-11e7-8e1f-2f4e7221cd1d:80619388' --gtid-domain-id '0''
2018-04-10  7:39:35 140004873792256 [Note] WSREP: sst_donor_thread signaled with 0
2018-04-10  7:39:35 139999433406208 [Note] WSREP: Flushing tables for SST...
2018-04-10  7:39:35 139999433406208 [Note] WSREP: Provider paused at 3b836c50-a528-11e7-8e1f-2f4e7221cd1d:80619388 (215637)
2018-04-10  7:39:35 139999433406208 [Note] WSREP: Tables flushed.
2018-04-10  7:39:37 140004177213184 [Note] WSREP: (080605d2, 'tcp://0.0.0.0:4567') turning message relay requesting off
InnoDB: Warning: a long semaphore wait:
--Thread 140002331719424 has waited at log0log.ic line 461 for 241.00 seconds the semaphore:
Mutex at 0x7f556784c0b8 '&log_sys->mutex', lock var 1
Last time reserved by thread 140002386241280 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: semaphore wait:
--Thread 140002331719424 has waited at log0log.ic line 461 for 241.00 seconds the semaphore:
Mutex at 0x7f556784c0b8 '&log_sys->mutex', lock var 1
Last time reserved by thread 140002386241280 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: semaphore wait:
--Thread 140002311899904 has waited at log0log.ic line 358 for 239.00 seconds the semaphore:
Mutex at 0x7f556784c0b8 '&log_sys->mutex', lock var 1
Last time reserved by thread 140002386241280 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: semaphore wait:
--Thread 140004160121600 has waited at trx0trx.cc line 1056 for 239.00 seconds the semaphore:
Mutex at 0x7f5567885868 '&trx_sys->mutex', lock var 1
Last time reserved by thread 140002311899904 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: semaphore wait:
--Thread 140002347260672 has waited at trx0trx.cc line 1056 for 230.00 seconds the semaphore:
Mutex at 0x7f5567885868 '&trx_sys->mutex', lock var 1
Last time reserved by thread 140002311899904 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: semaphore wait:
--Thread 140004157999872 has waited at trx0trx.cc line 1056 for 230.00 seconds the semaphore:
Mutex at 0x7f5567885868 '&trx_sys->mutex', lock var 1
Last time reserved by thread 140002311899904 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: semaphore wait:
--Thread 140003843734272 has waited at trx0trx.cc line 1056 for 230.00 seconds the semaphore:
Mutex at 0x7f5567885868 '&trx_sys->mutex', lock var 1
Last time reserved by thread 140002311899904 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: semaphore wait:
--Thread 140002566556416 has waited at trx0trx.cc line 1056 for 212.00 seconds the semaphore:
Mutex at 0x7f5567885868 '&trx_sys->mutex', lock var 1
Last time reserved by thread 140002311899904 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: semaphore wait:
--Thread 140002359544576 has waited at trx0trx.cc line 1056 for 212.00 seconds the semaphore:
Mutex at 0x7f5567885868 '&trx_sys->mutex', lock var 1
Last time reserved by thread 140002311899904 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: semaphore wait:
--Thread 140002399681280 has waited at trx0trx.cc line 1056 for 211.00 seconds the semaphore:
Mutex at 0x7f5567885868 '&trx_sys->mutex', lock var 1
Last time reserved by thread 140002311899904 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: semaphore wait:
--Thread 140002521619200 has waited at trx0trx.cc line 1056 for 170.00 seconds the semaphore:
Mutex at 0x7f5567885868 '&trx_sys->mutex', lock var 1
Last time reserved by thread 140002311899904 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: semaphore wait:
--Thread 140002523437824 has waited at trx0trx.cc line 1056 for 92.000 seconds the semaphore:
Mutex at 0x7f5567885868 '&trx_sys->mutex', lock var 1
Last time reserved by thread 140002311899904 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: semaphore wait:
--Thread 140002345442048 has waited at trx0trx.cc line 1056 for 33.000 seconds the semaphore:
Mutex at 0x7f5567885868 '&trx_sys->mutex', lock var 1
Last time reserved by thread 140002311899904 in file not yet reserved line 0, waiters flag 1
InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info:
InnoDB: Pending reads 0, writes 0

=====================================
2018-04-10 07:43:47 7f54e13ff700 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 12 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 23059 srv_active, 0 srv_shutdown, 15405 srv_idle
srv_master_thread log flush and writes: 38463
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 31144
--Thread 140002331719424 has waited at log0log.ic line 461 for 251.00 seconds the semaphore:
Mutex at 0x7f556784c0b8 '&log_sys->mutex', lock var 1
Last time reserved by thread 140002386241280 in file not yet reserved line 0, waiters flag 1
--Thread 140002311899904 has waited at log0log.ic line 358 for 249.00 seconds the semaphore:
Mutex at 0x7f556784c0b8 '&log_sys->mutex', lock var 1
Last time reserved by thread 140002386241280 in file not yet reserved line 0, waiters flag 1
--Thread 140004160121600 has waited at trx0trx.cc line 1056 for 249.00 seconds the semaphore:
Mutex at 0x7f5567885868 '&trx_sys->mutex', lock var 1
Last time reserved by thread 140002311899904 in file not yet reserved line 0, waiters flag 1
--Thread 140002347260672 has waited at trx0trx.cc line 1056 for 240.00 seconds the semaphore:
Mutex at 0x7f5567885868 '&trx_sys->mutex', lock var 1
Last time reserved by thread 140002311899904 in file not yet reserved line 0, waiters flag 1
--Thread 140004157999872 has waited at trx0trx.cc line 1056 for 240.00 seconds the semaphore:
Mutex at 0x7f5567885868 '&trx_sys->mutex', lock var 1
Last time reserved by thread 140002311899904 in file not yet reserved line 0, waiters flag 1
--Thread 140003843734272 has waited at trx0trx.cc line 1056 for 240.00 seconds the semaphore:
Mutex at 0x7f5567885868 '&trx_sys->mutex', lock var 1
Last time reserved by thread 140002311899904 in file not yet reserved line 0, waiters flag 1
--Thread 140002566556416 has waited at trx0trx.cc line 1056 for 222.00 seconds the semaphore:
Mutex at 0x7f5567885868 '&trx_sys->mutex', lock var 1
Last time reserved by thread 140002311899904 in file not yet reserved line 0, waiters flag 1
--Thread 140002359544576 has waited at trx0trx.cc line 1056 for 222.00 seconds the semaphore:
Mutex at 0x7f5567885868 '&trx_sys->mutex', lock var 1
Last time reserved by thread 140002311899904 in file not yet reserved line 0, waiters flag 1
--Thread 140002399681280 has waited at trx0trx.cc line 1056 for 221.00 seconds the semaphore:
Mutex at 0x7f5567885868 '&trx_sys->mutex', lock var 1
Last time reserved by thread 140002311899904 in file not yet reserved line 0, waiters flag 1
--Thread 140002521619200 has waited at trx0trx.cc line 1056 for 180.00 seconds the semaphore:
Mutex at 0x7f5567885868 '&trx_sys->mutex', lock var 1
Last time reserved by thread 140002311899904 in file not yet reserved line 0, waiters flag 1
--Thread 140002523437824 has waited at trx0trx.cc line 1056 for 102.00 seconds the semaphore:
Mutex at 0x7f5567885868 '&trx_sys->mutex', lock var 1
Last time reserved by thread 140002311899904 in file not yet reserved line 0, waiters flag 1
--Thread 140002345442048 has waited at trx0trx.cc line 1056 for 43.000 seconds the semaphore:
Mutex at 0x7f5567885868 '&trx_sys->mutex', lock var 1
Last time reserved by thread 140002311899904 in file not yet reserved line 0, waiters flag 1
OS WAIT ARRAY INFO: signal count 30399
Mutex spin waits 45192, rounds 844845, OS waits 23217
RW-shared spins 9857, rounds 263424, OS waits 7414
RW-excl spins 115, rounds 6411, OS waits 175
Spin rounds per wait: 18.69 mutex, 26.72 RW-shared, 55.75 RW-excl
------------
TRANSACTIONS
------------
Trx id counter 1029209856
Purge done for trx's n:o < 1029209579 undo n:o < 0 state: running but idle
History list length 11
LIST OF TRANSACTIONS FOR EACH SESSION:
InnoDB: ###### Diagnostic info printed to the standard error stream
InnoDB: Warning: a long semaphore wait:
--Thread 140002331719424 has waited at log0log.ic line 461 for 272.00 seconds the semaphore:
Mutex at 0x7f556784c0b8 '&log_sys->mutex', lock var 1
Last time reserved by thread 140002386241280 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: a long semaphore wait:
--Thread 140002311899904 has waited at log0log.ic line 358 for 270.00 seconds the semaphore:
Mutex at 0x7f556784c0b8 '&log_sys->mutex', lock var 1
Last time reserved by thread 140002386241280 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: a long semaphore wait:
--Thread 140004160121600 has waited at trx0trx.cc line 1056 for 270.00 seconds the semaphore:
Mutex at 0x7f5567885868 '&trx_sys->mutex', lock var 1
Last time reserved by thread 140002311899904 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: a long semaphore wait:
--Thread 140002347260672 has waited at trx0trx.cc line 1056 for 261.00 seconds the semaphore:
Mutex at 0x7f5567885868 '&trx_sys->mutex', lock var 1
Last time reserved by thread 140002311899904 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: a long semaphore wait:
--Thread 140004157999872 has waited at trx0trx.cc line 1056 for 261.00 seconds the semaphore:
Mutex at 0x7f5567885868 '&trx_sys->mutex', lock var 1
Last time reserved by thread 140002311899904 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: a long semaphore wait:
--Thread 140003843734272 has waited at trx0trx.cc line 1056 for 261.00 seconds the semaphore:
Mutex at 0x7f5567885868 '&trx_sys->mutex', lock var 1
Last time reserved by thread 140002311899904 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: a long semaphore wait:
--Thread 140002566556416 has waited at trx0trx.cc line 1056 for 243.00 seconds the semaphore:
Mutex at 0x7f5567885868 '&trx_sys->mutex', lock var 1
Last time reserved by thread 140002311899904 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: a long semaphore wait:
--Thread 140002359544576 has waited at trx0trx.cc line 1056 for 243.00 seconds the semaphore:
Mutex at 0x7f5567885868 '&trx_sys->mutex', lock var 1
Last time reserved by thread 140002311899904 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: a long semaphore wait:
--Thread 140002399681280 has waited at trx0trx.cc line 1056 for 242.00 seconds the semaphore:
Mutex at 0x7f5567885868 '&trx_sys->mutex', lock var 1
Last time reserved by thread 140002311899904 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: semaphore wait:
--Thread 140002331719424 has waited at log0log.ic line 461 for 272.00 seconds the semaphore:
Mutex at 0x7f556784c0b8 '&log_sys->mutex', lock var 1
Last time reserved by thread 140002386241280 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: semaphore wait:
--Thread 140002311899904 has waited at log0log.ic line 358 for 270.00 seconds the semaphore:
Mutex at 0x7f556784c0b8 '&log_sys->mutex', lock var 1
Last time reserved by thread 140002386241280 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: semaphore wait:
--Thread 140004160121600 has waited at trx0trx.cc line 1056 for 270.00 seconds the semaphore:
Mutex at 0x7f5567885868 '&trx_sys->mutex', lock var 1
Last time reserved by thread 140002311899904 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: semaphore wait:
--Thread 140002347260672 has waited at trx0trx.cc line 1056 for 261.00 seconds the semaphore:
Mutex at 0x7f5567885868 '&trx_sys->mutex', lock var 1
Last time reserved by thread 140002311899904 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: semaphore wait:
--Thread 140004157999872 has waited at trx0trx.cc line 1056 for 261.00 seconds the semaphore:
Mutex at 0x7f5567885868 '&trx_sys->mutex', lock var 1
Last time reserved by thread 140002311899904 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: semaphore wait:
--Thread 140003843734272 has waited at trx0trx.cc line 1056 for 261.00 seconds the semaphore:
Mutex at 0x7f5567885868 '&trx_sys->mutex', lock var 1
Last time reserved by thread 140002311899904 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: semaphore wait:
--Thread 140002566556416 has waited at trx0trx.cc line 1056 for 243.00 seconds the semaphore:
Mutex at 0x7f5567885868 '&trx_sys->mutex', lock var 1
Last time reserved by thread 140002311899904 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: semaphore wait:
--Thread 140002359544576 has waited at trx0trx.cc line 1056 for 243.00 seconds the semaphore:
Mutex at 0x7f5567885868 '&trx_sys->mutex', lock var 1
Last time reserved by thread 140002311899904 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: semaphore wait:
--Thread 140002399681280 has waited at trx0trx.cc line 1056 for 242.00 seconds the semaphore:
Mutex at 0x7f5567885868 '&trx_sys->mutex', lock var 1
Last time reserved by thread 140002311899904 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: semaphore wait:
--Thread 140002521619200 has waited at trx0trx.cc line 1056 for 201.00 seconds the semaphore:
Mutex at 0x7f5567885868 '&trx_sys->mutex', lock var 1
Last time reserved by thread 140002311899904 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: semaphore wait:
--Thread 140002523437824 has waited at trx0trx.cc line 1056 for 123.00 seconds the semaphore:
Mutex at 0x7f5567885868 '&trx_sys->mutex', lock var 1
Last time reserved by thread 140002311899904 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: semaphore wait:
--Thread 140002345442048 has waited at trx0trx.cc line 1056 for 64.000 seconds the semaphore:
Mutex at 0x7f5567885868 '&trx_sys->mutex', lock var 1
Last time reserved by thread 140002311899904 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: semaphore wait:
--Thread 140002533046016 has waited at lock0lock.cc line 6338 for 21.000 seconds the semaphore:
Mutex at 0x7f5567885868 '&trx_sys->mutex', lock var 1
Last time reserved by thread 140002311899904 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: semaphore wait:
--Thread 140002360453888 has waited at trx0trx.cc line 1056 for 3.0000 seconds the semaphore:
Mutex at 0x7f5567885868 '&trx_sys->mutex', lock var 1
Last time reserved by thread 140002311899904 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: semaphore wait:
--Thread 140002564434688 has waited at srv0srv.cc line 1806 for 0.0000 seconds the semaphore:
Mutex at 0x55fb833cad40 '&srv_innodb_monitor_mutex', lock var 1
Last time reserved by thread 140002533046016 in file not yet reserved line 0, waiters flag 1
InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info:
InnoDB: Pending reads 0, writes 0
InnoDB: ###### Diagnostic info printed to the standard error stream
InnoDB: Warning: a long semaphore wait:
--Thread 140002331719424 has waited at log0log.ic line 461 for 303.00 seconds the semaphore:
Mutex at 0x7f556784c0b8 '&log_sys->mutex', lock var 1
Last time reserved by thread 140002386241280 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: a long semaphore wait:
--Thread 140002311899904 has waited at log0log.ic line 358 for 301.00 seconds the semaphore:
Mutex at 0x7f556784c0b8 '&log_sys->mutex', lock var 1
Last time reserved by thread 140002386241280 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: a long semaphore wait:
--Thread 140004160121600 has waited at trx0trx.cc line 1056 for 301.00 seconds the semaphore:
Mutex at 0x7f5567885868 '&trx_sys->mutex', lock var 1
Last time reserved by thread 140002311899904 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: a long semaphore wait:
--Thread 140002347260672 has waited at trx0trx.cc line 1056 for 292.00 seconds the semaphore:
Mutex at 0x7f5567885868 '&trx_sys->mutex', lock var 1
Last time reserved by thread 140002311899904 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: a long semaphore wait:
--Thread 140004157999872 has waited at trx0trx.cc line 1056 for 292.00 seconds the semaphore:
Mutex at 0x7f5567885868 '&trx_sys->mutex', lock var 1
Last time reserved by thread 140002311899904 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: a long semaphore wait:
--Thread 140003843734272 has waited at trx0trx.cc line 1056 for 292.00 seconds the semaphore:
Mutex at 0x7f5567885868 '&trx_sys->mutex', lock var 1
Last time reserved by thread 140002311899904 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: a long semaphore wait:
--Thread 140002566556416 has waited at trx0trx.cc line 1056 for 274.00 seconds the semaphore:
Mutex at 0x7f5567885868 '&trx_sys->mutex', lock var 1
Last time reserved by thread 140002311899904 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: a long semaphore wait:
--Thread 140002359544576 has waited at trx0trx.cc line 1056 for 274.00 seconds the semaphore:
Mutex at 0x7f5567885868 '&trx_sys->mutex', lock var 1
Last time reserved by thread 140002311899904 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: a long semaphore wait:
--Thread 140002399681280 has waited at trx0trx.cc line 1056 for 273.00 seconds the semaphore:
Mutex at 0x7f5567885868 '&trx_sys->mutex', lock var 1
Last time reserved by thread 140002311899904 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: semaphore wait:
--Thread 140002331719424 has waited at log0log.ic line 461 for 303.00 seconds the semaphore:
Mutex at 0x7f556784c0b8 '&log_sys->mutex', lock var 1
Last time reserved by thread 140002386241280 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: semaphore wait:
--Thread 140002311899904 has waited at log0log.ic line 358 for 301.00 seconds the semaphore:
Mutex at 0x7f556784c0b8 '&log_sys->mutex', lock var 1
Last time reserved by thread 140002386241280 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: semaphore wait:
--Thread 140004160121600 has waited at trx0trx.cc line 1056 for 301.00 seconds the semaphore:
Mutex at 0x7f5567885868 '&trx_sys->mutex', lock var 1
Last time reserved by thread 140002311899904 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: semaphore wait:
--Thread 140002347260672 has waited at trx0trx.cc line 1056 for 292.00 seconds the semaphore:
Mutex at 0x7f5567885868 '&trx_sys->mutex', lock var 1
Last time reserved by thread 140002311899904 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: semaphore wait:
--Thread 140004157999872 has waited at trx0trx.cc line 1056 for 292.00 seconds the semaphore:
Mutex at 0x7f5567885868 '&trx_sys->mutex', lock var 1
Last time reserved by thread 140002311899904 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: semaphore wait:
--Thread 140003843734272 has waited at trx0trx.cc line 1056 for 292.00 seconds the semaphore:
Mutex at 0x7f5567885868 '&trx_sys->mutex', lock var 1
Last time reserved by thread 140002311899904 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: semaphore wait:
--Thread 140002566556416 has waited at trx0trx.cc line 1056 for 274.00 seconds the semaphore:
Mutex at 0x7f5567885868 '&trx_sys->mutex', lock var 1
Last time reserved by thread 140002311899904 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: semaphore wait:
--Thread 140002359544576 has waited at trx0trx.cc line 1056 for 274.00 seconds the semaphore:
Mutex at 0x7f5567885868 '&trx_sys->mutex', lock var 1
Last time reserved by thread 140002311899904 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: semaphore wait:
--Thread 140002399681280 has waited at trx0trx.cc line 1056 for 273.00 seconds the semaphore:
Mutex at 0x7f5567885868 '&trx_sys->mutex', lock var 1
Last time reserved by thread 140002311899904 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: semaphore wait:
--Thread 140002521619200 has waited at trx0trx.cc line 1056 for 232.00 seconds the semaphore:
Mutex at 0x7f5567885868 '&trx_sys->mutex', lock var 1
Last time reserved by thread 140002311899904 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: semaphore wait:
--Thread 140002523437824 has waited at trx0trx.cc line 1056 for 154.00 seconds the semaphore:
Mutex at 0x7f5567885868 '&trx_sys->mutex', lock var 1
Last time reserved by thread 140002311899904 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: semaphore wait:
--Thread 140002345442048 has waited at trx0trx.cc line 1056 for 95.000 seconds the semaphore:
Mutex at 0x7f5567885868 '&trx_sys->mutex', lock var 1
Last time reserved by thread 140002311899904 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: semaphore wait:
--Thread 140002533046016 has waited at lock0lock.cc line 6338 for 52.000 seconds the semaphore:
Mutex at 0x7f5567885868 '&trx_sys->mutex', lock var 1
Last time reserved by thread 140002311899904 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: semaphore wait:
--Thread 140002360453888 has waited at trx0trx.cc line 1056 for 34.000 seconds the semaphore:
Mutex at 0x7f5567885868 '&trx_sys->mutex', lock var 1
Last time reserved by thread 140002311899904 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: semaphore wait:
--Thread 140002564434688 has waited at srv0srv.cc line 1806 for 31.000 seconds the semaphore:
Mutex at 0x55fb833cad40 '&srv_innodb_monitor_mutex', lock var 1
Last time reserved by thread 140002533046016 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: semaphore wait:
--Thread 140002401803008 has waited at trx0trx.cc line 1056 for 28.000 seconds the semaphore:
Mutex at 0x7f5567885868 '&trx_sys->mutex', lock var 1
Last time reserved by thread 140002311899904 in file not yet reserved line 0, waiters flag 1
InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info:
InnoDB: Pending reads 0, writes 0
InnoDB: ###### Diagnostic info printed to the standard error stream
2018-04-10  8:04:17 139999433406208 [Note] WSREP: resuming provider at 215637
2018-04-10  8:04:17 139999433406208 [Note] WSREP: Provider resumed.
---TRANSACTION 1029209758, not started
MySQL thread id 41398, OS thread handle 0x7f55423b2b00, query id 3253244 azhdnl-ar03.azure.cloud.corp.local 10.134.17.157 01_MS_CHINA_PP Opening tables
SELECT source FROM url_alias WHERE alias = 'node/16' AND language IN ('en', 'und') ORDER BY language ASC, pid DESC
---TRANSACTION 1029209856, not started
MySQL thread id 41393, OS thread handle 0x7f54d4118b00, query id 3253243 azhdnl-ar03.azure.cloud.corp.local 10.134.17.157 01_MSFRANCE_PP cleaning up
---TRANSACTION 1029207634, not started
MySQL thread id 2, OS thread handle 0x7f556cc4eb00, query id 3253726 Opening tables
---TRANSACTION 1025731587, not started
MySQL thread id 4, OS thread handle 0x7f556cb52b00, query id 0 Waiting for requests
---TRANSACTION 1029209866, ACTIVE 0 sec committing
Trx read view will not see trx with id >= 1029209867, sees < 1029209857
Trx #rec lock waits 0 #table lock waits 0
Trx total rec lock wait time 0 SEC
Trx total table lock wait time 0 SEC
---TRANSACTION 1029209865, ACTIVE 0 sec
Trx #rec lock waits 0 #table lock waits 0
Trx total rec lock wait time 0 SEC
Trx total table lock wait time 0 SEC
---TRANSACTION 1029209864, ACTIVE 0 sec committing
Trx read view will not see trx with id >= 1029209867, sees < 1029209857
Trx #rec lock waits 0 #table lock waits 0
Trx total rec lock wait time 0 SEC
Trx total table lock wait time 0 SEC
---TRANSACTION 1029209863, ACTIVE 0 sec committing
Trx read view will not see trx with id >= 1029209867, sees < 1029209857
Trx #rec lock waits 0 #table lock waits 0
Trx total rec lock wait time 0 SEC
Trx total table lock wait time 0 SEC
---TRANSACTION 1029209862, ACTIVE 0 sec committing
Trx read view will not see trx with id >= 1029209864, sees < 1029209857
Trx #rec lock waits 0 #table lock waits 0
Trx total rec lock wait time 0 SEC
Trx total table lock wait time 0 SEC
---TRANSACTION 1029209861, ACTIVE 0 sec committing
Trx read view will not see trx with id >= 1029209863, sees < 1029209857
Trx #rec lock waits 0 #table lock waits 0
Trx total rec lock wait time 0 SEC
Trx total table lock wait time 0 SEC
---TRANSACTION 1029209860, ACTIVE 0 sec committing
Trx read view will not see trx with id >= 1029209862, sees < 1029209857
Trx #rec lock waits 0 #table lock waits 0
Trx total rec lock wait time 0 SEC
Trx total table lock wait time 0 SEC
---TRANSACTION 1029209859, ACTIVE 0 sec committing
Trx read view will not see trx with id >= 1029209861, sees < 1029209857
Trx #rec lock waits 0 #table lock waits 0
Trx total rec lock wait time 0 SEC
Trx total table lock wait time 0 SEC
---TRANSACTION 1029209858, ACTIVE 0 sec committing
Trx read view will not see trx with id >= 1029209859, sees < 1029209857
Trx #rec lock waits 0 #table lock waits 0
Trx total rec lock wait time 0 SEC
Trx total table lock wait time 0 SEC
---TRANSACTION 1029209857, ACTIVE 0 sec committing
Trx read view will not see trx with id >= 1029209859, sees < 1029209858
Trx #rec lock waits 0 #table lock waits 0
Trx total rec lock wait time 0 SEC
Trx total table lock wait time 0 SEC
--------
FILE I/O
--------
I/O thread 0 state: waiting for completed aio requests (insert buffer thread)
I/O thread 1 state: waiting for completed aio requests (log thread)
I/O thread 2 state: waiting for completed aio requests (read thread)
I/O thread 3 state: waiting for completed aio requests (read thread)
I/O thread 4 state: waiting for completed aio requests (read thread)
I/O thread 5 state: waiting for completed aio requests (read thread)
I/O thread 6 state: waiting for completed aio requests (write thread)
I/O thread 7 state: waiting for completed aio requests (write thread)
I/O thread 8 state: waiting for completed aio requests (write thread)
I/O thread 9 state: waiting for completed aio requests (write thread)
Pending normal aio reads: 0 [0, 0, 0, 0] , aio writes: 0 [0, 0, 0, 0] ,
 ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0
Pending flushes (fsync) log: 1; buffer pool: 0
1948410 OS file reads, 739302 OS file writes, 60963 OS fsyncs
0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 3043, seg size 3045, 387 merges
merged operations:
 insert 208, delete mark 4053, delete 201
discarded operations:
 insert 0, delete mark 0, delete 0
0.00 hash searches/s, 9.58 non-hash searches/s
---
LOG
---
Log sequence number 609384517394
Log flushed up to   609384517374
Pages flushed up to 609384517374
Last checkpoint at  609384517374
Max checkpoint age    80826164
Checkpoint age target 78300347
Modified age          20
Checkpoint age        20
1 pending log writes, 0 pending chkp writes
452427 log i/o's done, 0.00 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total memory allocated 1124597760; in additional pool allocated 0
Total memory allocated by read views 1624
Internal hash tables (constant factor + variable factor)
    Adaptive hash index 18926128        (18921928 + 4200)
    Page hash           139112 (buffer pool 0 only)
    Dictionary cache    16755601        (4426736 + 12328865)
    File system         64138816        (812272 + 63326544)
    Lock system         2660416         (2657176 + 3240)
    Recovery system     0       (0 + 0)
Dictionary memory allocated 12328865
Buffer pool size        65528
Buffer pool size, bytes 1073610752
Free buffers            8192
Database pages          57336
Old database pages      21000
Modified db pages       1
Percent of dirty pages(LRU & free pages): 0.002
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 2, single page 0
Pages made young 121184, not young 115336876
0.01 youngs/s, 0.00 non-youngs/s
Pages read 1878962, created 5359, written 275466
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 27 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 57336, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
----------------------
INDIVIDUAL BUFFER POOL INFO
----------------------
---BUFFER POOL 0
Buffer pool size        8191
Buffer pool size, bytes 134201344
Free buffers            1024
Database pages          7167
Old database pages      2625
Modified db pages       1
Percent of dirty pages(LRU & free pages): 0.012
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 2, single page 0
Pages made young 19723, not young 14758466
0.01 youngs/s, 0.00 non-youngs/s
Pages read 241033, created 1183, written 66482
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 71 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 7167, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 1
Buffer pool size        8191
Buffer pool size, bytes 134201344
Free buffers            1024
Database pages          7167
Old database pages      2625
Modified db pages       0
Percent of dirty pages(LRU & free pages): 0.000
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 16395, not young 14029660
0.00 youngs/s, 0.00 non-youngs/s
Pages read 234849, created 632, written 22015
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 7167, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 2
Buffer pool size        8191
Buffer pool size, bytes 134201344
Free buffers            1024
Database pages          7167
Old database pages      2625
Modified db pages       0
Percent of dirty pages(LRU & free pages): 0.000
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 17288, not young 14669700
0.00 youngs/s, 0.00 non-youngs/s
Pages read 236143, created 648, written 14701
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 28 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 7167, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 3
Buffer pool size        8191
Buffer pool size, bytes 134201344
Free buffers            1024
Database pages          7167
Old database pages      2625
Modified db pages       0
Percent of dirty pages(LRU & free pages): 0.000
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 13974, not young 14446123
0.00 youngs/s, 0.00 non-youngs/s
Pages read 237211, created 627, written 73150
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 7167, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 4
Buffer pool size        8191
Buffer pool size, bytes 134201344
Free buffers            1024
Database pages          7167
Old database pages      2625
Modified db pages       0
Percent of dirty pages(LRU & free pages): 0.000
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 12132, not young 14574789
0.00 youngs/s, 0.00 non-youngs/s
Pages read 233146, created 436, written 50063
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 7167, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 5
Buffer pool size        8191
Buffer pool size, bytes 134201344
Free buffers            1024
Database pages          7167
Old database pages      2625
Modified db pages       0
Percent of dirty pages(LRU & free pages): 0.000
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 10748, not young 14007093
0.00 youngs/s, 0.00 non-youngs/s
Pages read 229664, created 638, written 16727
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 7167, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 6
Buffer pool size        8191
Buffer pool size, bytes 134201344
Free buffers            1024
Database pages          7167
Old database pages      2625
Modified db pages       0
Percent of dirty pages(LRU & free pages): 0.000
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 14284, not young 14429840
0.00 youngs/s, 0.00 non-youngs/s
Pages read 233751, created 420, written 7225
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 20 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 7167, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 7
Buffer pool size        8191
Buffer pool size, bytes 134201344
Free buffers            1024
Database pages          7167
Old database pages      2625
Modified db pages       0
Percent of dirty pages(LRU & free pages): 0.000
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 16640, not young 14421205
0.00 youngs/s, 0.00 non-youngs/s
Pages read 233165, created 775, written 25103
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 7167, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
--------------
ROW OPERATIONS
--------------
0 queries inside InnoDB, 0 queries in queue
3 read views open inside InnoDB
46 RW transactions active inside InnoDB
0 RO transactions active inside InnoDB
46 out of 1000 descriptors used
---OLDEST VIEW---
Normal read view
Read view low limit trx n:o 1029209871
Read view up limit trx id 1029209860
Read view low limit trx id 1029209871
Read view individually stored trx ids:
Read view trx id 1029209860
Read view trx id 1029209862
Read view trx id 1029209863
Read view trx id 1029209865
Read view trx id 1029209866
Read view trx id 1029209868
Read view trx id 1029209870
-----------------
Main thread process no. 118144, id 140002386241280, state: flushing log
Number of rows inserted 21117, updated 200562, deleted 19719, read 219544367
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.58 reads/s
Number of system rows inserted 0, updated 0, deleted 0, read 0
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================
2018-04-10  8:04:17 140004168820480 [Note] WSREP: 0.0 (azabnl-id01): State transfer to 2.0 (azabnl-id05) complete.
2018-04-10  8:04:17 140004168820480 [Note] WSREP: Shifting DONOR/DESYNCED -> JOINED (TO: 80620535)
2018-04-10  8:04:22 140004168820480 [Note] WSREP: Member 0.0 (azabnl-id01) synced with group.
2018-04-10  8:04:22 140004168820480 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 80620535)
2018-04-10  8:04:22 140004873792256 [Note] WSREP: Synchronized with group, ready for connections
2018-04-10  8:04:22 140004873792256 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2018-04-10  8:06:11 140004168820480 [Note] WSREP: 2.0 (azabnl-id05): State transfer from 0.0 (azabnl-id01) complete.
2018-04-10  8:06:29 140004168820480 [Note] WSREP: Member 2.0 (azabnl-id05) synced with group.
2018-04-10 09:56:59 7f54d77fc700 InnoDB: FTS Optimize Removing table DB_GesDoubles_D/fournisseurs_bak
2018-04-10 10:06:06 7f54d77fc700 InnoDB: FTS Optimize Removing table DB_GesDoubles_D/fournisseurs_bak
2018-04-10 10:06:31 140004774873856 [Warning] InnoDB: Difficult to find free blocks in the buffer pool (21 search iterations)! 0 failed attempts to flush a page!
2018-04-10 10:06:31 140004774873856 [Note] InnoDB: Consider increasing the buffer pool size.
2018-04-10 10:06:31 140004774873856 [Note] InnoDB: Pending flushes (fsync) log: 0 buffer pool: 1 OS file reads: 1977808 OS file writes: 962365 OS fsyncs: 83722
2018-04-10 10:22:43 140004873792256 [ERROR] Slave SQL: Error 'Can't create database 'DB_CATALOGUEDIGITALB2B_PP'; database exists' on query. Default database: ''. Query: 'CREATE DATABASE DB_CATALOGUEDIGITALB2B_PP', Internal MariaDB error code: 1007
2018-04-10 10:22:43 140004873792256 [Warning] WSREP: RBR event 1 Query apply warning: 1, 80706622
2018-04-10 10:22:43 140004873792256 [Warning] WSREP: Ignoring error for TO isolated action: source: 2da75f6b-3c20-11e8-bdb8-07308c323f6e version: 3 local: 0 state: APPLYING flags: 65 conn_id: 60606 trx_id: -1 seqnos (l: 304503, g: 80706622, s: 80706621, d: 80706621, ts: 197337131609797)
2018-04-10 14:53:19 7f54d77fc700 InnoDB: FTS Optimize Removing table DB_GesDoubles_D/fournisseurs_bak
2018-04-10 15:39:29 7f54d77fc700 InnoDB: FTS Optimize Removing table DB_GesDoubles_D/fournisseurs_bak