=====================================
|
2020-06-02 03:12:49 0x7fab5f7fe700 INNODB MONITOR OUTPUT
|
=====================================
|
Per second averages calculated from the last 20 seconds
|
-----------------
|
BACKGROUND THREAD
|
-----------------
|
srv_master_thread loops: 1 srv_active, 0 srv_shutdown, 0 srv_idle
|
srv_master_thread log flush and writes: 0
|
----------
|
SEMAPHORES
|
----------
|
-------------
|
RW-LATCH INFO
|
-------------
|
RW-LOCK: 0x7fab44012468
|
RW-LOCK: 0x563c94808300
|
Locked: thread 140374240290560 file row0mysql.cc line 3921 X-LOCK
|
RW-LOCK: 0x7fab6cea61b0
|
Total number of rw-locks 1075
|
OS WAIT ARRAY INFO: reservation count 26
|
--Thread 140374009960192 has waited at dict0dict.cc line 997 for 899.00 seconds the semaphore:
|
Mutex at 0x563c96273b70, Mutex DICT_SYS created dict0dict.cc:1087, lock var 2
|
Last time reserved in file /data/src/10.2/storage/innobase/row/row0mysql.cc line 2185
|
OS WAIT ARRAY INFO: signal count 22
|
RW-shared spins 4, rounds 36, OS waits 1
|
RW-excl spins 5, rounds 93, OS waits 3
|
RW-sx spins 0, rounds 0, OS waits 0
|
Spin rounds per wait: 9.00 RW-shared, 18.60 RW-excl, 0.00 RW-sx
|
------------
|
TRANSACTIONS
|
------------
|
Trx id counter 23867771
|
Purge done for trx's n:o < 1289 undo n:o < 0 state: running but idle
|
History list length 0
|
Total number of lock structs in row lock hash table 1
|
LIST OF TRANSACTIONS FOR EACH SESSION:
|
---TRANSACTION 23867768, ACTIVE 0 sec dropping table
|
0 lock struct(s), heap size 1152, 0 row lock(s)
|
MySQL thread id 10, OS thread handle 140374240290560, query id 26 localhost root Unlocking tables
|
DROP DATABASE db
|
---TRANSACTION 421849229652584, not started
|
0 lock struct(s), heap size 1152, 0 row lock(s)
|
---TRANSACTION 1284, ACTIVE 899 sec
|
2 lock struct(s), heap size 1152, 1 row lock(s)
|
MySQL thread id 9, OS thread handle 140374240597760, query id 24 localhost root
|
---TRANSACTION 23867770, ACTIVE 0 sec
|
0 lock struct(s), heap size 1152, 0 row lock(s)
|
--------
|
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 (write thread)
|
I/O thread 5 state: waiting for completed aio requests (write thread)
|
Pending normal aio reads: [0, 0] , aio writes: [0, 0] ,
|
ibuf aio reads:, log i/o's:, sync i/o's:
|
Pending flushes (fsync) log: 0; buffer pool: 0
|
188 OS file reads, 173 OS file writes, 14 OS fsyncs
|
0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s
|
-------------------------------------
|
INSERT BUFFER AND ADAPTIVE HASH INDEX
|
-------------------------------------
|
Ibuf: size 1, free list len 0, seg size 2, 0 merges
|
merged operations:
|
insert 0, delete mark 0, delete 0
|
discarded operations:
|
insert 0, delete mark 0, delete 0
|
Hash table size 2267, node heap has 0 buffer(s)
|
Hash table size 2267, node heap has 0 buffer(s)
|
Hash table size 2267, node heap has 0 buffer(s)
|
Hash table size 2267, node heap has 0 buffer(s)
|
Hash table size 2267, node heap has 0 buffer(s)
|
Hash table size 2267, node heap has 0 buffer(s)
|
Hash table size 2267, node heap has 1 buffer(s)
|
Hash table size 2267, node heap has 0 buffer(s)
|
8915.60 hash searches/s, 17831.11 non-hash searches/s
|
---
|
LOG
|
---
|
Log sequence number 2595218
|
Log flushed up to 1708106
|
Pages flushed up to 1708106
|
Last checkpoint at 1628870
|
0 pending log flushes, 0 pending chkp writes
|
14 log i/o's done, 0.00 log i/o's/second
|
----------------------
|
BUFFER POOL AND MEMORY
|
----------------------
|
Total large memory allocated 8798208
|
Dictionary memory allocated 29184
|
Buffer pool size 512
|
Free buffers 201
|
Database pages 310
|
Old database pages 0
|
Modified db pages 1
|
Percent of dirty pages(LRU & free pages): 0.195
|
Max dirty pages percent: 75.000
|
Pending reads 0
|
Pending writes: LRU 0, flush list 0, single page 0
|
Pages made young 0, not young 0
|
0.00 youngs/s, 0.00 non-youngs/s
|
Pages read 174, created 136, written 162
|
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
|
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
|
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
|
LRU len: 310, unzip_LRU len: 0
|
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
|
--------------
|
ROW OPERATIONS
|
--------------
|
0 queries inside InnoDB, 0 queries in queue
|
0 read views open inside InnoDB
|
Process ID=12816, Main thread ID=140374009960192, state: doing background drop tables
|
Number of rows inserted 0, updated 0, deleted 0, read 0
|
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
|
Number of system rows inserted 0, updated 0, deleted 0, read 0
|
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
|
----------------------------
|
END OF INNODB MONITOR OUTPUT
|
============================
|
2020-06-02 3:12:50 140374240597760 [Warning] Aborted connection 9 to db: 'db' user: 'root' host: 'localhost' (Got an error reading communication packets)
|
200602 3:12:50 [ERROR] mysqld got signal 6 ;
|
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.2.33-MariaDB-debug-log
|
key_buffer_size=1048576
|
read_buffer_size=131072
|
max_used_connections=2
|
max_threads=153
|
thread_count=8
|
It is possible that mysqld could use up to
|
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 63103 K bytes of memory
|
Hope that's ok; if not, decrease some variables in the equation.
|
|
Thread pointer: 0x0
|
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 0x49000
|
mysys/stacktrace.c:267(my_print_stacktrace)[0x563c93e0885b]
|
sql/signal_handler.cc:209(handle_fatal_signal)[0x563c936bda94]
|
/lib/x86_64-linux-gnu/libpthread.so.0(+0x110e0)[0x7fab745360e0]
|
unix/syscall-template.S:84(__poll)[0x7fab726578bd]
|
2020-06-02 3:12:50 140374240290560 [Warning] Aborted connection 10 to db: 'test' user: 'root' host: 'localhost' (Got an error writing communication packets)
|
sql/mysqld.cc:6667(handle_connections_sockets())[0x563c93359b50]
|
sql/mysqld.cc:6138(mysqld_main(int, char**))[0x563c93358e32]
|
sql/main.cc:26(main)[0x563c9334d6d0]
|
csu/libc-start.c:325(__libc_start_main)[0x7fab725982e1]
|
/data/bld/10.2-debug/bin/mysqld(_start+0x2a)[0x563c9334d5aa]
|
The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
|
information that should help you find out what is causing the crash.
|
Writing a core file...
|
Working directory at /data/bld/10.2-debug/mysql-test/var/mysqld.1/data
|
Resource Limits:
|
Limit Soft Limit Hard Limit Units
|
Max cpu time unlimited unlimited seconds
|
Max file size unlimited unlimited bytes
|
Max data size unlimited unlimited bytes
|
Max stack size 8388608 unlimited bytes
|
Max core file size unlimited unlimited bytes
|
Max resident set unlimited unlimited bytes
|
Max processes 128123 128123 processes
|
Max open files 1024 1024 files
|
Max locked memory 65536 65536 bytes
|
Max address space unlimited unlimited bytes
|
Max file locks unlimited unlimited locks
|
Max pending signals 128123 128123 signals
|
Max msgqueue size 819200 819200 bytes
|
Max nice priority 0 0
|
Max realtime priority 0 0
|
Max realtime timeout unlimited unlimited us
|
Core pattern: core
|
threads.txt