160527 9:34:05 [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 https://mariadb.com/kb/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.25-MariaDB key_buffer_size=16777216 read_buffer_size=262144 max_used_connections=601 max_threads=1502 thread_count=95 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 1199599 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 140007088617216 has waited at lock0lock.cc line 4603 for 241.00 seconds the semaphore: Mutex at 0x7f54a0e68068 '&lock_sys->mutex', lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 140007090112256 has waited at lock0lock.cc line 7104 for 241.00 seconds the semaphore: Mutex at 0x7f54a0e68068 '&lock_sys->mutex', lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 140001579693824 has waited at lock0lock.cc line 6174 for 241.00 seconds the semaphore: Mutex at 0x7f54a0e68068 '&lock_sys->mutex', lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 140007088916224 has waited at lock0lock.cc line 4603 for 241.00 seconds the semaphore: Mutex at 0x7f54a0e68068 '&lock_sys->mutex', lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 140001579394816 has waited at btr0cur.cc line 591 for 241.00 seconds the semaphore: S-lock on RW-latch at 0x7f5450c96910 '&new_index->lock' a writer (thread id 140001579693824) 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 591 Last time write locked in file /var/tmp/portage/dev-db/mariadb-10.0.25/work/mysql/storage/xtradb/btr/btr0cur.cc line 582 InnoDB: Warning: a long semaphore wait: --Thread 139999476012800 has waited at btr0cur.cc line 591 for 241.00 seconds the semaphore: S-lock on RW-latch at 0x7f5450c96910 '&new_index->lock' a writer (thread id 140001579693824) 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 591 Last time write locked in file /var/tmp/portage/dev-db/mariadb-10.0.25/work/mysql/storage/xtradb/btr/btr0cur.cc line 582 InnoDB: Warning: a long semaphore wait: --Thread 139999462217472 has waited at btr0cur.cc line 591 for 241.00 seconds the semaphore: S-lock on RW-latch at 0x7f5450c96910 '&new_index->lock' a writer (thread id 140001579693824) 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 591 Last time write locked in file /var/tmp/portage/dev-db/mariadb-10.0.25/work/mysql/storage/xtradb/btr/btr0cur.cc line 582 InnoDB: Warning: a long semaphore wait: --Thread 139999457732352 has waited at btr0cur.cc line 591 for 241.00 seconds the semaphore: S-lock on RW-latch at 0x7f5450c96910 '&new_index->lock' a writer (thread id 140001579693824) 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 591 Last time write locked in file /var/tmp/portage/dev-db/mariadb-10.0.25/work/mysql/storage/xtradb/btr/btr0cur.cc line 582 InnoDB: Warning: semaphore wait: --Thread 140007088617216 has waited at lock0lock.cc line 4603 for 241.00 seconds the semaphore: Mutex at 0x7f54a0e68068 '&lock_sys->mutex', lock var 1 waiters flag 1 InnoDB: Warning: semaphore wait: --Thread 140007090112256 has waited at lock0lock.cc line 7104 for 241.00 seconds the semaphore: Mutex at 0x7f54a0e68068 '&lock_sys->mutex', lock var 1 waiters flag 1 InnoDB: Warning: semaphore wait: --Thread 140001579693824 has waited at lock0lock.cc line 6174 for 241.00 seconds the semaphore: Mutex at 0x7f54a0e68068 '&lock_sys->mutex', lock var 1 waiters flag 1 InnoDB: Warning: semaphore wait: --Thread 140007088916224 has waited at lock0lock.cc line 4603 for 241.00 seconds the semaphore: Mutex at 0x7f54a0e68068 '&lock_sys->mutex', lock var 1 waiters flag 1 InnoDB: Warning: semaphore wait: --Thread 140001579394816 has waited at btr0cur.cc line 591 for 241.00 seconds the semaphore: S-lock on RW-latch at 0x7f5450c96910 '&new_index->lock' a writer (thread id 140001579693824) 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 591 Last time write locked in file /var/tmp/portage/dev-db/mariadb-10.0.25/work/mysql/storage/xtradb/btr/btr0cur.cc line 582 InnoDB: Warning: Writer thread is waiting this semaphore: --Thread 140001579693824 has waited at lock0lock.cc line 6174 for 241.00 seconds the semaphore: Mutex at 0x7f54a0e68068 '&lock_sys->mutex', lock var 1 waiters flag 1 InnoDB: Warning: semaphore wait: --Thread 139999476012800 has waited at btr0cur.cc line 591 for 241.00 seconds the semaphore: S-lock on RW-latch at 0x7f5450c96910 '&new_index->lock' a writer (thread id 140001579693824) 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 591 Last time write locked in file /var/tmp/portage/dev-db/mariadb-10.0.25/work/mysql/storage/xtradb/btr/btr0cur.cc line 582 InnoDB: Warning: Writer thread is waiting this semaphore: --Thread 140001579693824 has waited at lock0lock.cc line 6174 for 241.00 seconds the semaphore: Mutex at 0x7f54a0e68068 '&lock_sys->mutex', lock var 1 waiters flag 1 InnoDB: Warning: semaphore wait: --Thread 139999462217472 has waited at btr0cur.cc line 591 for 241.00 seconds the semaphore: S-lock on RW-latch at 0x7f5450c96910 '&new_index->lock' a writer (thread id 140001579693824) 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 591 Last time write locked in file /var/tmp/portage/dev-db/mariadb-10.0.25/work/mysql/storage/xtradb/btr/btr0cur.cc line 582 InnoDB: Warning: Writer thread is waiting this semaphore: --Thread 140001579693824 has waited at lock0lock.cc line 6174 for 241.00 seconds the semaphore: Mutex at 0x7f54a0e68068 '&lock_sys->mutex', lock var 1 waiters flag 1 InnoDB: Warning: semaphore wait: --Thread 139999457732352 has waited at btr0cur.cc line 591 for 241.00 seconds the semaphore: S-lock on RW-latch at 0x7f5450c96910 '&new_index->lock' a writer (thread id 140001579693824) 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 591 Last time write locked in file /var/tmp/portage/dev-db/mariadb-10.0.25/work/mysql/storage/xtradb/btr/btr0cur.cc line 582 InnoDB: Warning: Writer thread is waiting this semaphore: --Thread 140001579693824 has waited at lock0lock.cc line 6174 for 241.00 seconds the semaphore: Mutex at 0x7f54a0e68068 '&lock_sys->mutex', lock var 1 waiters flag 1 InnoDB: Warning: semaphore wait: --Thread 140018111248128 has waited at lock0lock.cc line 4603 for 240.00 seconds the semaphore: Mutex at 0x7f54a0e68068 '&lock_sys->mutex', lock var 1 waiters flag 1 InnoDB: Warning: semaphore wait: --Thread 140000559290112 has waited at lock0lock.cc line 4603 for 240.00 seconds the semaphore: Mutex at 0x7f54a0e68068 '&lock_sys->mutex', lock var 1 waiters flag 1 InnoDB: Warning: semaphore wait: --Thread 139999680902912 has waited at srv0srv.cc line 2667 for 238.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x1389ac0 '&dict_operation_lock' a writer (thread id 139999680902912) 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.25/work/mysql/storage/xtradb/srv/srv0srv.cc line 2667 InnoDB: Warning: Writer thread is waiting this semaphore: --Thread 139999680902912 has waited at srv0srv.cc line 2667 for 238.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x1389ac0 '&dict_operation_lock' a writer (thread id 139999680902912) 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.25/work/mysql/storage/xtradb/srv/srv0srv.cc line 2667 InnoDB: Warning: semaphore wait: --Thread 139999647332096 has waited at dict0stats.cc line 2394 for 235.00 seconds the semaphore: X-lock on RW-latch at 0x1389ac0 '&dict_operation_lock' a writer (thread id 139999680902912) 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.25/work/mysql/storage/xtradb/srv/srv0srv.cc line 2667 InnoDB: Warning: Writer thread is waiting this semaphore: --Thread 139999680902912 has waited at srv0srv.cc line 2667 for 238.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x1389ac0 '&dict_operation_lock' a writer (thread id 139999680902912) 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.25/work/mysql/storage/xtradb/srv/srv0srv.cc line 2667 InnoDB: Warning: semaphore wait: --Thread 140045567952640 has waited at lock0lock.cc line 4603 for 233.00 seconds the semaphore: Mutex at 0x7f54a0e68068 '&lock_sys->mutex', lock var 1 waiters flag 1 InnoDB: Warning: semaphore wait: --Thread 139999475414784 has waited at lock0lock.cc line 4603 for 233.00 seconds the semaphore: Mutex at 0x7f54a0e68068 '&lock_sys->mutex', lock var 1 waiters flag 1 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending preads 0, pwrites 0 ===================================== 2016-05-27 09:38:22 7f5437bfc700 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 53 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 1827626 srv_active, 0 srv_shutdown, 27483 srv_idle srv_master_thread log flush and writes: 1855108 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 43814717 --Thread 140007088617216 has waited at lock0lock.cc line 4603 for 256.00 seconds the semaphore: Mutex at 0x7f54a0e68068 '&lock_sys->mutex', lock var 1 waiters flag 1 --Thread 140007090112256 has waited at lock0lock.cc line 7104 for 256.00 seconds the semaphore: Mutex at 0x7f54a0e68068 '&lock_sys->mutex', lock var 1 waiters flag 1 --Thread 140001579693824 has waited at lock0lock.cc line 6174 for 256.00 seconds the semaphore: Mutex at 0x7f54a0e68068 '&lock_sys->mutex', lock var 1 waiters flag 1 --Thread 140007088916224 has waited at lock0lock.cc line 4603 for 256.00 seconds the semaphore: Mutex at 0x7f54a0e68068 '&lock_sys->mutex', lock var 1 waiters flag 1 --Thread 140001579394816 has waited at btr0cur.cc line 591 for 256.00 seconds the semaphore: S-lock on RW-latch at 0x7f5450c96910 '&new_index->lock' a writer (thread id 140001579693824) 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 591 Last time write locked in file /var/tmp/portage/dev-db/mariadb-10.0.25/work/mysql/storage/xtradb/btr/btr0cur.cc line 582 --Thread 139999476012800 has waited at btr0cur.cc line 591 for 256.00 seconds the semaphore: S-lock on RW-latch at 0x7f5450c96910 '&new_index->lock' a writer (thread id 140001579693824) 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 591 Last time write locked in file /var/tmp/portage/dev-db/mariadb-10.0.25/work/mysql/storage/xtradb/btr/btr0cur.cc line 582 --Thread 139999462217472 has waited at btr0cur.cc line 591 for 256.00 seconds the semaphore: S-lock on RW-latch at 0x7f5450c96910 '&new_index->lock' a writer (thread id 140001579693824) 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 591 Last time write locked in file /var/tmp/portage/dev-db/mariadb-10.0.25/work/mysql/storage/xtradb/btr/btr0cur.cc line 582 --Thread 139999457732352 has waited at btr0cur.cc line 591 for 256.00 seconds the semaphore: S-lock on RW-latch at 0x7f5450c96910 '&new_index->lock' a writer (thread id 140001579693824) 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 591 Last time write locked in file /var/tmp/portage/dev-db/mariadb-10.0.25/work/mysql/storage/xtradb/btr/btr0cur.cc line 582 --Thread 140018111248128 has waited at lock0lock.cc line 4603 for 255.00 seconds the semaphore: Mutex at 0x7f54a0e68068 '&lock_sys->mutex', lock var 1 waiters flag 1 --Thread 140000559290112 has waited at lock0lock.cc line 4603 for 255.00 seconds the semaphore: Mutex at 0x7f54a0e68068 '&lock_sys->mutex', lock var 1 waiters flag 1 --Thread 139999680902912 has waited at srv0srv.cc line 2667 for 253.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x1389ac0 '&dict_operation_lock' a writer (thread id 139999680902912) 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.25/work/mysql/storage/xtradb/srv/srv0srv.cc line 2667 --Thread 139999647332096 has waited at dict0stats.cc line 2394 for 250.00 seconds the semaphore: X-lock on RW-latch at 0x1389ac0 '&dict_operation_lock' a writer (thread id 139999680902912) 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.25/work/mysql/storage/xtradb/srv/srv0srv.cc line 2667 --Thread 140045567952640 has waited at lock0lock.cc line 4603 for 248.00 seconds the semaphore: Mutex at 0x7f54a0e68068 '&lock_sys->mutex', lock var 1 waiters flag 1 --Thread 139999475414784 has waited at lock0lock.cc line 4603 for 248.00 seconds the semaphore: Mutex at 0x7f54a0e68068 '&lock_sys->mutex', lock var 1 waiters flag 1 OS WAIT ARRAY INFO: signal count 42620462 Mutex spin waits 311201762, rounds 1371622977, OS waits 9807697 RW-shared spins 30083180, rounds 781099723, OS waits 22732170 RW-excl spins 31826298, rounds 558926674, OS waits 10317375 Spin rounds per wait: 4.41 mutex, 25.96 RW-shared, 17.56 RW-excl ------------------------ LATEST FOREIGN KEY ERROR ------------------------ 2016-05-26 15:51:54 7f542a16e700 Transaction: TRANSACTION 61748006980, ACTIVE 0 sec inserting mysql tables in use 1, locked 1 9 lock struct(s), heap size 2936, 5 row lock(s), undo log entries 3 MySQL thread id 135053513, OS thread handle 0x7f542a16e700, query id 2265435492 xxxxxx xxxx xxxxx update INSERT INTO xxxxxx (xxxx, xxxx, xxxx, xxxx, xxxx, xxxx, xxxx) VALUES (2, '2016-05-26 15:51:54', '2016-05-26 15:51:54', 88820608, '25646', 396, 82440256) Foreign key constraint fails for table `xxxx`.`xxxx`: , CONSTRAINT `xxxx` FOREIGN KEY (`xxxx`) REFERENCES `xxxx` (`xxxx`) ON DELETE SET NULL ON UPDATE NO ACTION Trying to add in child table, in index `xxxx` tuple: DATA TUPLE: 2 fields; 0: len 4; hex 84e9f040; asc @;; 1: len 4; hex 9a8450de; asc P ;; But in parent table `xxxx`.`xxxx`, in index `PRIMARY`, the closest match we can find is record: PHYSICAL RECORD: n_fields 14; compact format; info bits 0 0: len 4; hex 84e9f041; asc A;; 1: len 6; hex 000dc71c367d; asc 6};; 2: len 7; hex 5d0004c00e27d7; asc ] ' ;; 3: SQL NULL; 4: len 4; hex 85a83cca; asc < ;; 5: len 4; hex 8000645b; asc d[;; 6: len 2; hex 8001; asc ;; 7: SQL NULL; 8: len 1; hex 00; asc ;; 9: SQL NULL; 10: len 4; hex 571e4bf2; asc W K ;; 11: len 4; hex 571e4bf2; asc W K ;; 12: len 2; hex 0002; asc ;; 13: len 2; hex 0001; asc ;; FAIL TO OBTAIN LOCK MUTEX, SKIP LOCK INFO PRINTING -------- 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 324182950 OS file reads, 545894280 OS file writes, 282739287 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 0.11 writes/s, 0.11 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 393220, seg size 393222, 33546443 merges merged operations: insert 25238307, delete mark 88490065, delete 12771420 discarded operations: insert 0, delete mark 0, delete 0 8.83 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 5190742667034 Log flushed up to 5190742667034 Pages flushed up to 5190742667034 Last checkpoint at 5190713243795 Max checkpoint age 80826164 Checkpoint age target 78300347 Modified age 0 Checkpoint age 29423239 0 pending log writes, 0 pending chkp writes 240580865 log i/o's done, 0.04 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 42926080000; in additional pool allocated 0 Total memory allocated by read views 12128 Internal hash tables (constant factor + variable factor) Adaptive hash index 2951985664 (664054168 + 2287931496) Page hash 5188856 (buffer pool 0 only) Dictionary cache 167524060 (166015184 + 1508876) File system 901192 (812272 + 88920) Lock system 103772456 (103759496 + 12960) Recovery system 0 (0 + 0) Dictionary memory allocated 1508876 InnoDB: ###### Diagnostic info printed to the standard error stream InnoDB: Warning: a long semaphore wait: --Thread 140007088617216 has waited at lock0lock.cc line 4603 for 272.00 seconds the semaphore: Mutex at 0x7f54a0e68068 '&lock_sys->mutex', lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 140007090112256 has waited at lock0lock.cc line 7104 for 272.00 seconds the semaphore: Mutex at 0x7f54a0e68068 '&lock_sys->mutex', lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 140001579693824 has waited at lock0lock.cc line 6174 for 272.00 seconds the semaphore: Mutex at 0x7f54a0e68068 '&lock_sys->mutex', lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 140007088916224 has waited at lock0lock.cc line 4603 for 272.00 seconds the semaphore: Mutex at 0x7f54a0e68068 '&lock_sys->mutex', lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 140001579394816 has waited at btr0cur.cc line 591 for 272.00 seconds the semaphore: S-lock on RW-latch at 0x7f5450c96910 '&new_index->lock' a writer (thread id 140001579693824) 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 591 Last time write locked in file /var/tmp/portage/dev-db/mariadb-10.0.25/work/mysql/storage/xtradb/btr/btr0cur.cc line 582 InnoDB: Warning: a long semaphore wait: --Thread 139999476012800 has waited at btr0cur.cc line 591 for 272.00 seconds the semaphore: S-lock on RW-latch at 0x7f5450c96910 '&new_index->lock' a writer (thread id 140001579693824) 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 591 Last time write locked in file /var/tmp/portage/dev-db/mariadb-10.0.25/work/mysql/storage/xtradb/btr/btr0cur.cc line 582 InnoDB: Warning: a long semaphore wait: --Thread 139999462217472 has waited at btr0cur.cc line 591 for 272.00 seconds the semaphore: S-lock on RW-latch at 0x7f5450c96910 '&new_index->lock' a writer (thread id 140001579693824) 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 591 Last time write locked in file /var/tmp/portage/dev-db/mariadb-10.0.25/work/mysql/storage/xtradb/btr/btr0cur.cc line 582 InnoDB: Warning: a long semaphore wait: --Thread 139999457732352 has waited at btr0cur.cc line 591 for 272.00 seconds the semaphore: S-lock on RW-latch at 0x7f5450c96910 '&new_index->lock' a writer (thread id 140001579693824) 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 591 Last time write locked in file /var/tmp/portage/dev-db/mariadb-10.0.25/work/mysql/storage/xtradb/btr/btr0cur.cc line 582 InnoDB: Warning: a long semaphore wait: --Thread 140018111248128 has waited at lock0lock.cc line 4603 for 271.00 seconds the semaphore: Mutex at 0x7f54a0e68068 '&lock_sys->mutex', lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 140000559290112 has waited at lock0lock.cc line 4603 for 271.00 seconds the semaphore: Mutex at 0x7f54a0e68068 '&lock_sys->mutex', lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 139999680902912 has waited at srv0srv.cc line 2667 for 269.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x1389ac0 '&dict_operation_lock' a writer (thread id 139999680902912) 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.25/work/mysql/storage/xtradb/srv/srv0srv.cc line 2667 InnoDB: Warning: a long semaphore wait: --Thread 139999647332096 has waited at dict0stats.cc line 2394 for 266.00 seconds the semaphore: X-lock on RW-latch at 0x1389ac0 '&dict_operation_lock' a writer (thread id 139999680902912) 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.25/work/mysql/storage/xtradb/srv/srv0srv.cc line 2667 InnoDB: Warning: a long semaphore wait: --Thread 140045567952640 has waited at lock0lock.cc line 4603 for 264.00 seconds the semaphore: Mutex at 0x7f54a0e68068 '&lock_sys->mutex', lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 139999475414784 has waited at lock0lock.cc line 4603 for 264.00 seconds the semaphore: Mutex at 0x7f54a0e68068 '&lock_sys->mutex', lock var 1 waiters flag 1 InnoDB: Warning: semaphore wait: --Thread 140007088617216 has waited at lock0lock.cc line 4603 for 272.00 seconds the semaphore: Mutex at 0x7f54a0e68068 '&lock_sys->mutex', lock var 1 waiters flag 1 InnoDB: Warning: semaphore wait: --Thread 140007090112256 has waited at lock0lock.cc line 7104 for 272.00 seconds the semaphore: Mutex at 0x7f54a0e68068 '&lock_sys->mutex', lock var 1 waiters flag 1 InnoDB: Warning: semaphore wait: --Thread 140001579693824 has waited at lock0lock.cc line 6174 for 272.00 seconds the semaphore: Mutex at 0x7f54a0e68068 '&lock_sys->mutex', lock var 1 waiters flag 1 InnoDB: Warning: semaphore wait: --Thread 140007088916224 has waited at lock0lock.cc line 4603 for 272.00 seconds the semaphore: Mutex at 0x7f54a0e68068 '&lock_sys->mutex', lock var 1 waiters flag 1 InnoDB: Warning: semaphore wait: --Thread 140001579394816 has waited at btr0cur.cc line 591 for 272.00 seconds the semaphore: S-lock on RW-latch at 0x7f5450c96910 '&new_index->lock' a writer (thread id 140001579693824) 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 591 Last time write locked in file /var/tmp/portage/dev-db/mariadb-10.0.25/work/mysql/storage/xtradb/btr/btr0cur.cc line 582 InnoDB: Warning: Writer thread is waiting this semaphore: --Thread 140001579693824 has waited at lock0lock.cc line 6174 for 272.00 seconds the semaphore: Mutex at 0x7f54a0e68068 '&lock_sys->mutex', lock var 1 waiters flag 1 InnoDB: Warning: semaphore wait: --Thread 139999476012800 has waited at btr0cur.cc line 591 for 272.00 seconds the semaphore: S-lock on RW-latch at 0x7f5450c96910 '&new_index->lock' a writer (thread id 140001579693824) 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 591 Last time write locked in file /var/tmp/portage/dev-db/mariadb-10.0.25/work/mysql/storage/xtradb/btr/btr0cur.cc line 582 InnoDB: Warning: Writer thread is waiting this semaphore: --Thread 140001579693824 has waited at lock0lock.cc line 6174 for 272.00 seconds the semaphore: Mutex at 0x7f54a0e68068 '&lock_sys->mutex', lock var 1 waiters flag 1 InnoDB: Warning: semaphore wait: --Thread 139999462217472 has waited at btr0cur.cc line 591 for 272.00 seconds the semaphore: S-lock on RW-latch at 0x7f5450c96910 '&new_index->lock' a writer (thread id 140001579693824) 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 591 Last time write locked in file /var/tmp/portage/dev-db/mariadb-10.0.25/work/mysql/storage/xtradb/btr/btr0cur.cc line 582 InnoDB: Warning: Writer thread is waiting this semaphore: --Thread 140001579693824 has waited at lock0lock.cc line 6174 for 272.00 seconds the semaphore: Mutex at 0x7f54a0e68068 '&lock_sys->mutex', lock var 1 waiters flag 1 InnoDB: Warning: semaphore wait: --Thread 139999457732352 has waited at btr0cur.cc line 591 for 272.00 seconds the semaphore: S-lock on RW-latch at 0x7f5450c96910 '&new_index->lock' a writer (thread id 140001579693824) 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 591 Last time write locked in file /var/tmp/portage/dev-db/mariadb-10.0.25/work/mysql/storage/xtradb/btr/btr0cur.cc line 582 InnoDB: Warning: Writer thread is waiting this semaphore: --Thread 140001579693824 has waited at lock0lock.cc line 6174 for 272.00 seconds the semaphore: Mutex at 0x7f54a0e68068 '&lock_sys->mutex', lock var 1 waiters flag 1 InnoDB: Warning: semaphore wait: --Thread 140018111248128 has waited at lock0lock.cc line 4603 for 271.00 seconds the semaphore: Mutex at 0x7f54a0e68068 '&lock_sys->mutex', lock var 1 waiters flag 1 InnoDB: Warning: semaphore wait: --Thread 140000559290112 has waited at lock0lock.cc line 4603 for 271.00 seconds the semaphore: Mutex at 0x7f54a0e68068 '&lock_sys->mutex', lock var 1 waiters flag 1 InnoDB: Warning: semaphore wait: --Thread 139999680902912 has waited at srv0srv.cc line 2667 for 269.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x1389ac0 '&dict_operation_lock' a writer (thread id 139999680902912) 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.25/work/mysql/storage/xtradb/srv/srv0srv.cc line 2667 InnoDB: Warning: Writer thread is waiting this semaphore: --Thread 139999680902912 has waited at srv0srv.cc line 2667 for 269.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x1389ac0 '&dict_operation_lock' a writer (thread id 139999680902912) 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.25/work/mysql/storage/xtradb/srv/srv0srv.cc line 2667 InnoDB: Warning: semaphore wait: --Thread 139999647332096 has waited at dict0stats.cc line 2394 for 266.00 seconds the semaphore: X-lock on RW-latch at 0x1389ac0 '&dict_operation_lock' a writer (thread id 139999680902912) 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.25/work/mysql/storage/xtradb/srv/srv0srv.cc line 2667 InnoDB: Warning: Writer thread is waiting this semaphore: --Thread 139999680902912 has waited at srv0srv.cc line 2667 for 269.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x1389ac0 '&dict_operation_lock' a writer (thread id 139999680902912) 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.25/work/mysql/storage/xtradb/srv/srv0srv.cc line 2667 InnoDB: Warning: semaphore wait: --Thread 140045567952640 has waited at lock0lock.cc line 4603 for 264.00 seconds the semaphore: Mutex at 0x7f54a0e68068 '&lock_sys->mutex', lock var 1 waiters flag 1 InnoDB: Warning: semaphore wait: --Thread 139999475414784 has waited at lock0lock.cc line 4603 for 264.00 seconds the semaphore: Mutex at 0x7f54a0e68068 '&lock_sys->mutex', lock var 1 waiters flag 1 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 140007088617216 has waited at lock0lock.cc line 4603 for 303.00 seconds the semaphore: Mutex at 0x7f54a0e68068 '&lock_sys->mutex', lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 140007090112256 has waited at lock0lock.cc line 7104 for 303.00 seconds the semaphore: Mutex at 0x7f54a0e68068 '&lock_sys->mutex', lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 140001579693824 has waited at lock0lock.cc line 6174 for 303.00 seconds the semaphore: Mutex at 0x7f54a0e68068 '&lock_sys->mutex', lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 140007088916224 has waited at lock0lock.cc line 4603 for 303.00 seconds the semaphore: Mutex at 0x7f54a0e68068 '&lock_sys->mutex', lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 140001579394816 has waited at btr0cur.cc line 591 for 303.00 seconds the semaphore: S-lock on RW-latch at 0x7f5450c96910 '&new_index->lock' a writer (thread id 140001579693824) 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 591 Last time write locked in file /var/tmp/portage/dev-db/mariadb-10.0.25/work/mysql/storage/xtradb/btr/btr0cur.cc line 582 InnoDB: Warning: a long semaphore wait: --Thread 139999476012800 has waited at btr0cur.cc line 591 for 303.00 seconds the semaphore: S-lock on RW-latch at 0x7f5450c96910 '&new_index->lock' a writer (thread id 140001579693824) 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 591 Last time write locked in file /var/tmp/portage/dev-db/mariadb-10.0.25/work/mysql/storage/xtradb/btr/btr0cur.cc line 582 InnoDB: Warning: a long semaphore wait: --Thread 139999462217472 has waited at btr0cur.cc line 591 for 303.00 seconds the semaphore: S-lock on RW-latch at 0x7f5450c96910 '&new_index->lock' a writer (thread id 140001579693824) 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 591 Last time write locked in file /var/tmp/portage/dev-db/mariadb-10.0.25/work/mysql/storage/xtradb/btr/btr0cur.cc line 582 InnoDB: Warning: a long semaphore wait: --Thread 139999457732352 has waited at btr0cur.cc line 591 for 303.00 seconds the semaphore: S-lock on RW-latch at 0x7f5450c96910 '&new_index->lock' a writer (thread id 140001579693824) 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 591 Last time write locked in file /var/tmp/portage/dev-db/mariadb-10.0.25/work/mysql/storage/xtradb/btr/btr0cur.cc line 582 InnoDB: Warning: a long semaphore wait: --Thread 140018111248128 has waited at lock0lock.cc line 4603 for 302.00 seconds the semaphore: Mutex at 0x7f54a0e68068 '&lock_sys->mutex', lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 140000559290112 has waited at lock0lock.cc line 4603 for 302.00 seconds the semaphore: Mutex at 0x7f54a0e68068 '&lock_sys->mutex', lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 139999680902912 has waited at srv0srv.cc line 2667 for 300.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x1389ac0 '&dict_operation_lock' a writer (thread id 139999680902912) 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.25/work/mysql/storage/xtradb/srv/srv0srv.cc line 2667 InnoDB: Warning: a long semaphore wait: --Thread 139999647332096 has waited at dict0stats.cc line 2394 for 297.00 seconds the semaphore: X-lock on RW-latch at 0x1389ac0 '&dict_operation_lock' a writer (thread id 139999680902912) 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.25/work/mysql/storage/xtradb/srv/srv0srv.cc line 2667 InnoDB: Warning: a long semaphore wait: --Thread 140045567952640 has waited at lock0lock.cc line 4603 for 295.00 seconds the semaphore: Mutex at 0x7f54a0e68068 '&lock_sys->mutex', lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 139999475414784 has waited at lock0lock.cc line 4603 for 295.00 seconds the semaphore: Mutex at 0x7f54a0e68068 '&lock_sys->mutex', lock var 1 waiters flag 1 InnoDB: Warning: semaphore wait: --Thread 140007088617216 has waited at lock0lock.cc line 4603 for 303.00 seconds the semaphore: Mutex at 0x7f54a0e68068 '&lock_sys->mutex', lock var 1 waiters flag 1 InnoDB: Warning: semaphore wait: --Thread 140007090112256 has waited at lock0lock.cc line 7104 for 303.00 seconds the semaphore: Mutex at 0x7f54a0e68068 '&lock_sys->mutex', lock var 1 waiters flag 1 InnoDB: Warning: semaphore wait: --Thread 140001579693824 has waited at lock0lock.cc line 6174 for 303.00 seconds the semaphore: Mutex at 0x7f54a0e68068 '&lock_sys->mutex', lock var 1 waiters flag 1 InnoDB: Warning: semaphore wait: --Thread 140007088916224 has waited at lock0lock.cc line 4603 for 303.00 seconds the semaphore: Mutex at 0x7f54a0e68068 '&lock_sys->mutex', lock var 1 waiters flag 1 InnoDB: Warning: semaphore wait: --Thread 140001579394816 has waited at btr0cur.cc line 591 for 303.00 seconds the semaphore: S-lock on RW-latch at 0x7f5450c96910 '&new_index->lock' a writer (thread id 140001579693824) 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 591 Last time write locked in file /var/tmp/portage/dev-db/mariadb-10.0.25/work/mysql/storage/xtradb/btr/btr0cur.cc line 582 InnoDB: Warning: Writer thread is waiting this semaphore: --Thread 140001579693824 has waited at lock0lock.cc line 6174 for 303.00 seconds the semaphore: Mutex at 0x7f54a0e68068 '&lock_sys->mutex', lock var 1 waiters flag 1 InnoDB: Warning: semaphore wait: --Thread 139999476012800 has waited at btr0cur.cc line 591 for 303.00 seconds the semaphore: S-lock on RW-latch at 0x7f5450c96910 '&new_index->lock' a writer (thread id 140001579693824) 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 591 Last time write locked in file /var/tmp/portage/dev-db/mariadb-10.0.25/work/mysql/storage/xtradb/btr/btr0cur.cc line 582 InnoDB: Warning: Writer thread is waiting this semaphore: --Thread 140001579693824 has waited at lock0lock.cc line 6174 for 303.00 seconds the semaphore: Mutex at 0x7f54a0e68068 '&lock_sys->mutex', lock var 1 waiters flag 1 InnoDB: Warning: semaphore wait: --Thread 139999462217472 has waited at btr0cur.cc line 591 for 303.00 seconds the semaphore: S-lock on RW-latch at 0x7f5450c96910 '&new_index->lock' a writer (thread id 140001579693824) 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 591 Last time write locked in file /var/tmp/portage/dev-db/mariadb-10.0.25/work/mysql/storage/xtradb/btr/btr0cur.cc line 582 InnoDB: Warning: Writer thread is waiting this semaphore: --Thread 140001579693824 has waited at lock0lock.cc line 6174 for 303.00 seconds the semaphore: Mutex at 0x7f54a0e68068 '&lock_sys->mutex', lock var 1 waiters flag 1 InnoDB: Warning: semaphore wait: --Thread 139999457732352 has waited at btr0cur.cc line 591 for 303.00 seconds the semaphore: S-lock on RW-latch at 0x7f5450c96910 '&new_index->lock' a writer (thread id 140001579693824) 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 591 Last time write locked in file /var/tmp/portage/dev-db/mariadb-10.0.25/work/mysql/storage/xtradb/btr/btr0cur.cc line 582 InnoDB: Warning: Writer thread is waiting this semaphore: --Thread 140001579693824 has waited at lock0lock.cc line 6174 for 303.00 seconds the semaphore: Mutex at 0x7f54a0e68068 '&lock_sys->mutex', lock var 1 waiters flag 1 InnoDB: Warning: semaphore wait: --Thread 140018111248128 has waited at lock0lock.cc line 4603 for 302.00 seconds the semaphore: Mutex at 0x7f54a0e68068 '&lock_sys->mutex', lock var 1 waiters flag 1 InnoDB: Warning: semaphore wait: --Thread 140000559290112 has waited at lock0lock.cc line 4603 for 302.00 seconds the semaphore: Mutex at 0x7f54a0e68068 '&lock_sys->mutex', lock var 1 waiters flag 1 InnoDB: Warning: semaphore wait: --Thread 139999680902912 has waited at srv0srv.cc line 2667 for 300.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x1389ac0 '&dict_operation_lock' a writer (thread id 139999680902912) 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.25/work/mysql/storage/xtradb/srv/srv0srv.cc line 2667 InnoDB: Warning: Writer thread is waiting this semaphore: --Thread 139999680902912 has waited at srv0srv.cc line 2667 for 300.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x1389ac0 '&dict_operation_lock' a writer (thread id 139999680902912) 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.25/work/mysql/storage/xtradb/srv/srv0srv.cc line 2667 InnoDB: Warning: semaphore wait: --Thread 139999647332096 has waited at dict0stats.cc line 2394 for 297.00 seconds the semaphore: X-lock on RW-latch at 0x1389ac0 '&dict_operation_lock' a writer (thread id 139999680902912) 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.25/work/mysql/storage/xtradb/srv/srv0srv.cc line 2667 InnoDB: Warning: Writer thread is waiting this semaphore: --Thread 139999680902912 has waited at srv0srv.cc line 2667 for 300.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x1389ac0 '&dict_operation_lock' a writer (thread id 139999680902912) 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.25/work/mysql/storage/xtradb/srv/srv0srv.cc line 2667 InnoDB: Warning: semaphore wait: --Thread 140045567952640 has waited at lock0lock.cc line 4603 for 295.00 seconds the semaphore: Mutex at 0x7f54a0e68068 '&lock_sys->mutex', lock var 1 waiters flag 1 InnoDB: Warning: semaphore wait: --Thread 139999475414784 has waited at lock0lock.cc line 4603 for 295.00 seconds the semaphore: Mutex at 0x7f54a0e68068 '&lock_sys->mutex', lock var 1 waiters flag 1 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