160602 5:32:48 [ERROR] mysqld got signal 11 ; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. To report this bug, see http://kb.askmonty.org/en/reporting-bugs We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. Server version: 10.0.23-MariaDB-log key_buffer_size=16777216 read_buffer_size=262144 max_used_connections=570 max_threads=1502 thread_count=37 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 1199576 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x0x0 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... stack_bottom = 0x0 thread_stack 0x48000 InnoDB: Warning: a long semaphore wait: --Thread 139704041174784 has waited at dict0stats.cc line 2391 for 241.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x138ac00 '&dict_operation_lock' a writer (thread id 139704041174784) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0ins.cc line 1819 Last time write locked in file /var/tmp/portage/dev-db/mariadb-10.0.23/work/mysql/storage/xtradb/dict/dict0stats.cc line 2391 InnoDB: Warning: semaphore wait: --Thread 139704041174784 has waited at dict0stats.cc line 2391 for 241.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x138ac00 '&dict_operation_lock' a writer (thread id 139704041174784) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0ins.cc line 1819 Last time write locked in file /var/tmp/portage/dev-db/mariadb-10.0.23/work/mysql/storage/xtradb/dict/dict0stats.cc line 2391 InnoDB: Warning: Writer thread is waiting this semaphore: --Thread 139704041174784 has waited at dict0stats.cc line 2391 for 241.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x138ac00 '&dict_operation_lock' a writer (thread id 139704041174784) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0ins.cc line 1819 Last time write locked in file /var/tmp/portage/dev-db/mariadb-10.0.23/work/mysql/storage/xtradb/dict/dict0stats.cc line 2391 InnoDB: Warning: semaphore wait: --Thread 139704074745600 has waited at srv0srv.cc line 2671 for 240.00 seconds the semaphore: X-lock on RW-latch at 0x138ac00 '&dict_operation_lock' a writer (thread id 139704041174784) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0ins.cc line 1819 Last time write locked in file /var/tmp/portage/dev-db/mariadb-10.0.23/work/mysql/storage/xtradb/dict/dict0stats.cc line 2391 InnoDB: Warning: Writer thread is waiting this semaphore: --Thread 139704041174784 has waited at dict0stats.cc line 2391 for 241.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x138ac00 '&dict_operation_lock' a writer (thread id 139704041174784) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0ins.cc line 1819 Last time write locked in file /var/tmp/portage/dev-db/mariadb-10.0.23/work/mysql/storage/xtradb/dict/dict0stats.cc line 2391 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending preads 0, pwrites 0 ===================================== 2016-06-02 05:37:08 7f0f643fc700 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 63 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 166521 srv_active, 0 srv_shutdown, 1 srv_idle srv_master_thread log flush and writes: 166522 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 13059303 --Thread 139704041174784 has waited at dict0stats.cc line 2391 for 251.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x138ac00 '&dict_operation_lock' a writer (thread id 139704041174784) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0ins.cc line 1819 Last time write locked in file /var/tmp/portage/dev-db/mariadb-10.0.23/work/mysql/storage/xtradb/dict/dict0stats.cc line 2391 --Thread 139704074745600 has waited at srv0srv.cc line 2671 for 250.00 seconds the semaphore: X-lock on RW-latch at 0x138ac00 '&dict_operation_lock' a writer (thread id 139704041174784) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0ins.cc line 1819 Last time write locked in file /var/tmp/portage/dev-db/mariadb-10.0.23/work/mysql/storage/xtradb/dict/dict0stats.cc line 2391 OS WAIT ARRAY INFO: signal count 10262799 Mutex spin waits 62788729, rounds 300041397, OS waits 4862328 RW-shared spins 5512318, rounds 178761635, OS waits 5461416 RW-excl spins 2340007, rounds 98642232, OS waits 2593347 Spin rounds per wait: 4.78 mutex, 32.43 RW-shared, 42.15 RW-excl ------------------------ LATEST FOREIGN KEY ERROR ------------------------ 2016-06-01 13:15:56 7f0f5fe89700 Transaction: TRANSACTION 62836333271, ACTIVE 0 sec inserting mysql tables in use 1, locked 1 3 lock struct(s), heap size 1184, 1 row lock(s), undo log entries 1 MySQL thread id 21222146, OS thread handle 0x7f0f5fe89700, query id 351617289 xxx xxx xxx update INSERT INTO xxx (xxx,xxx,xxx,xxx,xxx,xxx,xxx,xxx,xxx,xxx) VALUES ('abc', 'abc', 'abc', '', '', 3297252, '2012-11-22 10:53:30', 'abc', 0, NULL) Foreign key constraint fails for table `xxx`.`xxx`: , CONSTRAINT `xxx` FOREIGN KEY (`xxx`) REFERENCES `xxx` (`xxx`) Trying to add in child table, in index `xxx` tuple: DATA TUPLE: 2 fields; 0: len 1; hex 84; asc ;; 1: len 4; hex 8000da6b; asc k;; But in parent table `xxx`.`xxx`, in index `PRIMARY`, the closest match we can find is record: PHYSICAL RECORD: n_fields 7; compact format; info bits 0 0: len 1; hex 85; asc ;; 1: len 6; hex 0003f46f366a; asc o6j;; 2: len 7; hex 400001c0140dee; asc @ ;; 3: len 5; hex 6b6f726561; asc xxx; 4: len 20; hex 6d6170732d6b6f7265612e73796769632e636f6d; asc xxx;; 5: len 13; hex 2f696e2d6170702d646174612f; asc xxx;; 6: len 14; hex 2f696e2d6170702d6d656469612f; asc xxx;; ------------------------ LATEST DETECTED DEADLOCK ------------------------ 2016-06-02 05:13:55 7f18d04c9700 *** (1) TRANSACTION: TRANSACTION 62953784732, ACTIVE 0 sec inserting mysql tables in use 1, locked 1 LOCK WAIT 5 lock struct(s), heap size 1184, 2 row lock(s), undo log entries 2 MySQL thread id 32484739, OS thread handle 0x7f0f5f36a700, query id 519225666 xxx xxx xxx update INSERT INTO xxx *** (1) WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 69 page no 2991789 n bits 1000 index `xxx` of table `xxx`.`xxx` trx table locks 3 total table locks 2 trx id 62953784732 lock mode S waiting lock hold time 0 wait time before grant 0 *** (2) TRANSACTION: TRANSACTION 62953784733, ACTIVE 0 sec starting index read mysql tables in use 1, locked 1 11 lock struct(s), heap size 2936, 5 row lock(s), undo log entries 2 MySQL thread id 32484835, OS thread handle 0x7f18d04c9700, query id 519225670 xxx xxx xxx updating UPDATE xxx *** (2) HOLDS THE LOCK(S): RECORD LOCKS space id 69 page no 2991789 n bits 1000 index `xxx` of table `xxx`.`xxx` trx table locks 6 total table locks 2 trx id 62953784733 lock_mode X locks rec but not gap lock hold time 0 wait time before grant 0 *** (2) WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 604 page no 452268 n bits 208 index `PRIMARY` of table `xxx`.`xxx` trx table locks 6 total table locks 3 trx id 62953784733 lock_mode X locks rec but not gap waiting lock hold time 0 wait time before grant 0 *** WE ROLL BACK TRANSACTION (1) ------------ TRANSACTIONS ------------ Trx id counter 62955067999 Purge done for trx's n:o < 62953200397 undo n:o < 0 state: running History list length 206500 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 62955062372, not started MySQL thread id 32603906, OS thread handle 0x7f111d4d0700, query id 521071422 xxx xxx xxx Opening tables SELECT xxx ---TRANSACTION 62955062295, not started MySQL thread id 32603905, OS thread handle 0x7f163f4d0700, query id 521071004 xxx xxx xxx Opening tables SELECT xxx ---TRANSACTION 62955062285, not started MySQL thread id 32603903, OS thread handle 0x7f0f5e5ba700, query id 521070989 xxx xxx xxx Opening tables SELECT xxx ---TRANSACTION 62955062284, not started MySQL thread id 32603904, OS thread handle 0x7f111d5f4700, query id 521070982 xxx xxx xxx Opening tables SELECT xxx ---TRANSACTION 62955062283, not started MySQL thread id 32603902, OS thread handle 0x7f0f5da52700, query id 521070986 xxx xxx xxx Opening tables SELECT xxx ---TRANSACTION 62955062281, not started MySQL thread id 32603901, OS thread handle 0x7f0f5d8e5700, query id 521070984 xxx xxx xxx Opening tables SELECT xxx ---TRANSACTION 62955062304, not started MySQL thread id 32603898, OS thread handle 0x7f14f6cd0700, query id 521071269 xxx xxx xxx Opening tables SELECT xxx ---TRANSACTION 62955062291, not started MySQL thread id 32603897, OS thread handle 0x7f0f5d4e7700, query id 521071002 xxx xxx xxx Opening tables SELECT xxx ---TRANSACTION 62955062290, not started MySQL thread id 32603896, OS thread handle 0x7f0f982d1700, query id 521070997 xxx xxx xxx Opening tables SELECT xxx ---TRANSACTION 62955062267, not started MySQL thread id 32603893, OS thread handle 0x7f0f5fa8b700, query id 521070999 xxx xxx xxx Opening tables SELECT xxx ---TRANSACTION 62955062288, not started MySQL thread id 32603891, OS thread handle 0x7f0f5f843700, query id 521070990 xxx xxx xxx Opening tables SELECT xxx ---TRANSACTION 62955062233, not started MySQL thread id 32603889, OS thread handle 0x7f111d63d700, query id 521071007 xxx xxx xxx Opening tables SELECT xxx ---TRANSACTION 62955062293, not started MySQL thread id 32603888, OS thread handle 0x7f13ae487700, query id 521071003 xxx xxx xxx Opening tables SELECT xxx ---TRANSACTION 62955062357, not started MySQL thread id 32603877, OS thread handle 0x7f0f5ef23700, query id 521071360 xxx xxx xxx Opening tables SELECT xxx ---TRANSACTION 62955062574, not started MySQL thread id 32603840, OS thread handle 0x7f0f5f5fb700, query id 521071502 xxx xxx xxx cleaning up ---TRANSACTION 62955062360, not started MySQL thread id 32598764, OS thread handle 0x7f0fd4c87700, query id 521071107 xxx xxx xxx Opening tables SELECT xxx ---TRANSACTION 62955067897, not started MySQL thread id 32319291, OS thread handle 0x7f1265c87700, query id 521081837 xxx xxx xxx cleaning up ---TRANSACTION 62955067979, not started MySQL thread id 21968161, OS thread handle 0x7f0f6003f700, query id 521081996 xxx xxx xxx cleaning up ---TRANSACTION 62955062975, not started MySQL thread id 21968146, OS thread handle 0x7f0f5f9b0700, query id 521072235 xxx xxx xxx preparing SELECT xxx ---TRANSACTION 62955062335, not started MySQL thread id 21968143, OS thread handle 0x7f0f5f445700, query id 521071078 xxx xxx xxx Opening tables SELECT xxx ---TRANSACTION 62955062417, not started MySQL thread id 21968142, OS thread handle 0x7f0f5fe40700, query id 521071217 xxx xxx xxx init COMMIT ---TRANSACTION 62955062568, not started mysql tables in use 1, locked 1 MySQL thread id 21968139, OS thread handle 0x7f14f6df4700, query id 521071489 xxx xxx xxx init UPDATE xxx ---TRANSACTION 62955067997, not started MySQL thread id 21968140, OS thread handle 0x7f0f60287700, query id 521082035 xxx xxx xxx cleaning up ---TRANSACTION 62955064318, not started MySQL thread id 152850, OS thread handle 0x7f0f5d5c2700, query id 521074814 localhost monitoring updating status UPDATE `percona`.`heartbeat` SET ts='2016-06-02T05:33:42.001720', file='mysqld-bin.000018', position='327012077', relay_master_log_file=NULL, exec_master_log_pos=NULL WHERE server_id='5' ---TRANSACTION 62592515587, not started MySQL thread id 1, OS thread handle 0x7f1a14e1b700, query id 0 Waiting for background binlog tasks ---TRANSACTION 62955063363, ACTIVE 252 sec 2 lock struct(s), heap size 360, 1 row lock(s), undo log entries 1 MySQL thread id 24027769, OS thread handle 0x7f0f57d25700, query id 521072974 xxx xxx xxx init COMMIT Trx read view will not see trx with id >= 62955063364, sees < 62955063309 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 62955063327, ACTIVE 254 sec updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 360, 1 row lock(s) MySQL thread id 21968145, OS thread handle 0x7f1265d62700, query id 521072907 xxx xxx xxx updating UPDATE xxx 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 62955063309, ACTIVE 254 sec 2 lock struct(s), heap size 360, 1 row lock(s), undo log entries 1 MySQL thread id 21968144, OS thread handle 0x7f0ed2e00700, query id 521072874 xxx xxx xxx updating status UPDATE xxx 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: 0; buffer pool: 0 34429487 OS file reads, 58443339 OS file writes, 33176948 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 60.90 writes/s, 13.52 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 854, free list len 392367, seg size 393222, 2695384 merges merged operations: insert 1090216, delete mark 12397099, delete 2178091 discarded operations: insert 0, delete mark 0, delete 0 16.71 hash searches/s, 1.81 non-hash searches/s --- LOG --- Log sequence number 5279845664826 Log flushed up to 5279845664688 Pages flushed up to 5279820803870 Last checkpoint at 5279804022288 Max checkpoint age 80826164 Checkpoint age target 78300347 Modified age 24860956 Checkpoint age 41642538 0 pending log writes, 0 pending chkp writes 29224384 log i/o's done, 8.08 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 42926080000; in additional pool allocated 0 Total memory allocated by read views 11032 Internal hash tables (constant factor + variable factor) Adaptive hash index 3717396992 (664054168 + 3053342824) Page hash 5188856 (buffer pool 0 only) Dictionary cache 167531747 (166015184 + 1516563) File system 901648 (812272 + 89376) Lock system 103769576 (103759496 + 10080) Recovery system 0 (0 + 0) Dictionary memory allocated 1516563 InnoDB: ###### Diagnostic info printed to the standard error stream InnoDB: Warning: a long semaphore wait: --Thread 139704041174784 has waited at dict0stats.cc line 2391 for 272.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x138ac00 '&dict_operation_lock' a writer (thread id 139704041174784) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0ins.cc line 1819 Last time write locked in file /var/tmp/portage/dev-db/mariadb-10.0.23/work/mysql/storage/xtradb/dict/dict0stats.cc line 2391 InnoDB: Warning: a long semaphore wait: --Thread 139704074745600 has waited at srv0srv.cc line 2671 for 271.00 seconds the semaphore: X-lock on RW-latch at 0x138ac00 '&dict_operation_lock' a writer (thread id 139704041174784) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0ins.cc line 1819 Last time write locked in file /var/tmp/portage/dev-db/mariadb-10.0.23/work/mysql/storage/xtradb/dict/dict0stats.cc line 2391 InnoDB: Warning: semaphore wait: --Thread 139704041174784 has waited at dict0stats.cc line 2391 for 272.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x138ac00 '&dict_operation_lock' a writer (thread id 139704041174784) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0ins.cc line 1819 Last time write locked in file /var/tmp/portage/dev-db/mariadb-10.0.23/work/mysql/storage/xtradb/dict/dict0stats.cc line 2391 InnoDB: Warning: Writer thread is waiting this semaphore: --Thread 139704041174784 has waited at dict0stats.cc line 2391 for 272.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x138ac00 '&dict_operation_lock' a writer (thread id 139704041174784) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0ins.cc line 1819 Last time write locked in file /var/tmp/portage/dev-db/mariadb-10.0.23/work/mysql/storage/xtradb/dict/dict0stats.cc line 2391 InnoDB: Warning: semaphore wait: --Thread 139704074745600 has waited at srv0srv.cc line 2671 for 271.00 seconds the semaphore: X-lock on RW-latch at 0x138ac00 '&dict_operation_lock' a writer (thread id 139704041174784) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0ins.cc line 1819 Last time write locked in file /var/tmp/portage/dev-db/mariadb-10.0.23/work/mysql/storage/xtradb/dict/dict0stats.cc line 2391 InnoDB: Warning: Writer thread is waiting this semaphore: --Thread 139704041174784 has waited at dict0stats.cc line 2391 for 272.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x138ac00 '&dict_operation_lock' a writer (thread id 139704041174784) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0ins.cc line 1819 Last time write locked in file /var/tmp/portage/dev-db/mariadb-10.0.23/work/mysql/storage/xtradb/dict/dict0stats.cc line 2391 InnoDB: Warning: semaphore wait: --Thread 139749994718976 has waited at srv0srv.cc line 1673 for 20.000 seconds the semaphore: Mutex at 0x136c940 '&srv_innodb_monitor_mutex', lock var 1 waiters flag 1 InnoDB: Warning: semaphore wait: --Thread 139704108316416 has waited at buf0flu.cc line 1079 for 11.000 seconds the semaphore: S-lock on RW-latch at 0x7f11227c43c0 '&block->lock' a writer (thread id 139704066352896) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.cc line 3911 Last time write locked in file /var/tmp/portage/dev-db/mariadb-10.0.23/work/mysql/storage/xtradb/row/row0row.cc line 815 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending preads 0, pwrites 0 InnoDB: ###### Diagnostic info printed to the standard error stream InnoDB: Warning: a long semaphore wait: --Thread 139704041174784 has waited at dict0stats.cc line 2391 for 303.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x138ac00 '&dict_operation_lock' a writer (thread id 139704041174784) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0ins.cc line 1819 Last time write locked in file /var/tmp/portage/dev-db/mariadb-10.0.23/work/mysql/storage/xtradb/dict/dict0stats.cc line 2391 InnoDB: Warning: a long semaphore wait: --Thread 139704074745600 has waited at srv0srv.cc line 2671 for 302.00 seconds the semaphore: X-lock on RW-latch at 0x138ac00 '&dict_operation_lock' a writer (thread id 139704041174784) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0ins.cc line 1819 Last time write locked in file /var/tmp/portage/dev-db/mariadb-10.0.23/work/mysql/storage/xtradb/dict/dict0stats.cc line 2391 InnoDB: Warning: semaphore wait: --Thread 139704041174784 has waited at dict0stats.cc line 2391 for 303.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x138ac00 '&dict_operation_lock' a writer (thread id 139704041174784) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0ins.cc line 1819 Last time write locked in file /var/tmp/portage/dev-db/mariadb-10.0.23/work/mysql/storage/xtradb/dict/dict0stats.cc line 2391 InnoDB: Warning: Writer thread is waiting this semaphore: --Thread 139704041174784 has waited at dict0stats.cc line 2391 for 303.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x138ac00 '&dict_operation_lock' a writer (thread id 139704041174784) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0ins.cc line 1819 Last time write locked in file /var/tmp/portage/dev-db/mariadb-10.0.23/work/mysql/storage/xtradb/dict/dict0stats.cc line 2391 InnoDB: Warning: semaphore wait: --Thread 139704074745600 has waited at srv0srv.cc line 2671 for 302.00 seconds the semaphore: X-lock on RW-latch at 0x138ac00 '&dict_operation_lock' a writer (thread id 139704041174784) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0ins.cc line 1819 Last time write locked in file /var/tmp/portage/dev-db/mariadb-10.0.23/work/mysql/storage/xtradb/dict/dict0stats.cc line 2391 InnoDB: Warning: Writer thread is waiting this semaphore: --Thread 139704041174784 has waited at dict0stats.cc line 2391 for 303.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x138ac00 '&dict_operation_lock' a writer (thread id 139704041174784) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0ins.cc line 1819 Last time write locked in file /var/tmp/portage/dev-db/mariadb-10.0.23/work/mysql/storage/xtradb/dict/dict0stats.cc line 2391 InnoDB: Warning: semaphore wait: --Thread 139749994718976 has waited at srv0srv.cc line 1673 for 51.000 seconds the semaphore: Mutex at 0x136c940 '&srv_innodb_monitor_mutex', lock var 1 waiters flag 1 InnoDB: Warning: semaphore wait: --Thread 139704108316416 has waited at buf0flu.cc line 1079 for 42.000 seconds the semaphore: S-lock on RW-latch at 0x7f11227c43c0 '&block->lock' a writer (thread id 139704066352896) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.cc line 3911 Last time write locked in file /var/tmp/portage/dev-db/mariadb-10.0.23/work/mysql/storage/xtradb/row/row0row.cc line 815 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending preads 0, pwrites 0 InnoDB: ###### Diagnostic info printed to the standard error stream