crash1.log

01-crash-mariadb-10.0.25-1.log (text/plain), 40.55 KB, created by Tomáš Mózes on 2016-06-02 07:45:12 UTC

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