Description:
------------------
---TRANSACTION 8872, ACTIVE (PREPARED) 173 sec
mysql tables in use 1, locked 1
2 lock struct(s), heap size 1136, 1 row lock(s), undo log entries 1
MySQL thread id 5577, OS thread handle 140183639803648, query id 24263 172.17.42.1 root waiting for handler commit
DELETE FROM `osmagic_license`.`kl_license_certificate` WHERE `id` = 37
---TRANSACTION 8864, ACTIVE 942 sec preparing
mysql tables in use 1, locked 1
2 lock struct(s), heap size 1136, 2 row lock(s), undo log entries 1
MySQL thread id 5405, OS thread handle 140174243981056, query id 23728 172.17.42.1 root waiting for handler commit
DELETE FROM `kl_license`
--------
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] , aio writes: [0, 0, 0, 0] ,
ibuf aio reads:, log i/o's:, sync i/o's:
Pending flushes (fsync) log: 1; buffer pool: 2
1274 OS file reads, 25447 OS file writes, 19445 OS fsyncs
0 pending preads, 1 pending pwrites
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 34679, node heap has 1 buffer(s)
Hash table size 34679, node heap has 2 buffer(s)
Hash table size 34679, node heap has 1 buffer(s)
Hash table size 34679, node heap has 4 buffer(s)
Hash table size 34679, node heap has 3 buffer(s)
Hash table size 34679, node heap has 3 buffer(s)
Hash table size 34679, node heap has 4 buffer(s)
Hash table size 34679, node heap has 6 buffer(s)
126.49 hash searches/s, 14.95 non-hash searches/s
---
LOG
---
Log sequence number 38911855
Log buffer assigned up to 38911855
Log buffer completed up to 38911147
Log written up to 38910662
Log flushed up to 38910503
Added dirty pages up to 38911855
Pages flushed up to 38910503
Last checkpoint at 38910503
12329 log i/o's done, 0.00 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 137363456
Dictionary memory allocated 1185821
Buffer pool size 8192
Free buffers 6325
Database pages 1843
Old database pages 660
Modified db pages 10
Pending reads 0
Pending writes: LRU 0, flush list 2, single page 0
Pages made young 11, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 1249, created 594, written 9132
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: 1843, 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
1 read views open inside InnoDB
Process ID=1, Main thread ID=140183775418112 , state=enforcing dict cache limit
Number of rows inserted 5449, updated 6619, deleted 94, read 72030
0.05 inserts/s, 0.00 updates/s, 0.00 deletes/s, 129.29 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================
InnoDB: ###### Diagnostic info printed to the standard error stream
2020-02-26T08:37:17.245991Z 0 [ERROR] [MY-012872] [InnoDB] [FATAL] Semaphore wait has lasted > 600 seconds. We intentionally crash the server because it appears to be hung.
2020-02-26T08:37:17.246154Z 0 [ERROR] [MY-013183] [InnoDB] Assertion failure: ut0ut.cc:532 thread 140183803483904
InnoDB: We intentionally generate a memory trap.
InnoDB: Submit a detailed bug report to http://bugs.mysql.com.
InnoDB: If you get repeated assertion failures or crashes, even
InnoDB: immediately after the mysqld startup, there may be
InnoDB: corruption in the InnoDB tablespace. Please refer to
InnoDB: http://dev.mysql.com/doc/refman/8.0/en/forcing-innodb-recovery.html
InnoDB: about forcing recovery.
08:37:17 UTC - mysqld got signal 6 ;
Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware.
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 = 0 thread_stack 0x46000
/opt/bitnami/mysql/bin/mysqld(my_print_stacktrace(unsigned char const*, unsigned long)+0x2e) [0x558dc61244fe]
/opt/bitnami/mysql/bin/mysqld(handle_fatal_signal+0x351) [0x558dc5254391]
/lib/x86_64-linux-gnu/libpthread.so.0(+0x110e0) [0x7f7f4792d0e0]
/lib/x86_64-linux-gnu/libc.so.6(gsignal+0xcf) [0x7f7f45b73fff]
/lib/x86_64-linux-gnu/libc.so.6(abort+0x16a) [0x7f7f45b7542a]
/opt/bitnami/mysql/bin/mysqld(ut_dbg_assertion_failed(char const*, char const*, unsigned long)+0x2e3) [0x558dc63e6fe3]
/opt/bitnami/mysql/bin/mysqld(ib::fatal::~fatal()+0x16c) [0x558dc63ea0ec]
/opt/bitnami/mysql/bin/mysqld(srv_error_monitor_thread()+0x733) [0x558dc63818e3]
/opt/bitnami/mysql/bin/mysqld(std::thread::_State_impl<std::_Bind_simple<Runnable (void (*)())> >::_M_run()+0xb3) [0x558dc6287643]
/usr/lib/x86_64-linux-gnu/libstdc++.so.6(+0xb9e6f) [0x7f7f464b4e6f]
/lib/x86_64-linux-gnu/libpthread.so.0(+0x74a4) [0x7f7f479234a4]
/lib/x86_64-linux-gnu/libc.so.6(clone+0x3f) [0x7f7f45c29d0f]
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.
How to repeat:
tell me how to fix the bug,why bug can be make?
