crash4.log

04-crash-mariadb-10.0.23-2.log (text/plain), 23.35 KB, created by Tomáš Mózes on 2016-06-02 07:45:49 UTC

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