---BUFFER POOL 15 Buffer pool size 96324 Free buffers 30671 Database pages 62997 Old database pages 23274 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 1766, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 52455, created 10542, written 223937 13.90 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 874 / 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: 62997, unzip_LRU len: 0 I/O sum[0]:cur[4521], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 0 queries inside InnoDB, 0 queries in queue 0 read views open inside InnoDB Process ID=27426, Main thread ID=140655912138496, state: sleeping Number of rows inserted 20689312, updated 1012678, deleted 7366829, read 331159089 0.00 inserts/s, 27.15 updates/s, 0.00 deletes/s, 376.08 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 ============================ InnoDB: ###### Diagnostic info printed to the standard error stream 2021-03-15 7:50:42 0 [ERROR] [FATAL] InnoDB: Semaphore wait has lasted > 600 seconds. We intentionally crash the serv er because it appears to be hung. 210315 7:50:42 [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.4.17-MariaDB-log key_buffer_size=134217728 read_buffer_size=131072 max_used_connections=139 max_threads=258 thread_count=145 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 698828 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x0 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 /usr/sbin/mysqld(my_print_stacktrace+0x2e)[0x557586716ffe] /usr/sbin/mysqld(handle_fatal_signal+0x30f)[0x5575861a89ef] sigaction.c:0(__restore_rt)[0x7ff43ad09630] :0(__GI_raise)[0x7ff438fd9387] :0(__GI_abort)[0x7ff438fdaa78] /usr/sbin/mysqld(+0xbc1d50)[0x55758649fd50] /usr/sbin/mysqld(+0xb7a362)[0x557586458362] pthread_create.c:0(start_thread)[0x7ff43ad01ea5] /lib64/libc.so.6(clone+0x6d)[0x7ff4390a196d] The manual page at https://mariadb.com/kb/en/how-to-produce-a-full-stack-trace-for-mysqld/ contains information that should help you find out what is causing the crash. Writing a core file... Working directory at /var/lib/mysql Resource Limits: Fatal signal 11 while backtracing 2021-03-15 7:50:48 0 [Note] InnoDB: Using Linux native AIO 2021-03-15 7:50:48 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2021-03-15 7:50:48 0 [Note] InnoDB: Uses event mutexes 2021-03-15 7:50:48 0 [Note] InnoDB: Compressed tables use zlib 1.2.7 2021-03-15 7:50:48 0 [Note] InnoDB: Number of pools: 1 2021-03-15 7:50:48 0 [Note] InnoDB: Using SSE2 crc32 instructions 2021-03-15 7:50:48 0 [Note] InnoDB: Initializing buffer pool, total size = 24G, instances = 16, chunk size = 128M 2021-03-15 7:50:50 0 [Note] InnoDB: Completed initialization of buffer pool 2021-03-15 7:50:51 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2021-03-15 7:50:51 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=1105648006756 2021-03-15 7:50:52 0 [Note] InnoDB: 2 transaction(s) which must be rolled back or cleaned up in total 13 row operations to undo 2021-03-15 7:50:52 0 [Note] InnoDB: Trx id counter is 158087575 2021-03-15 7:50:52 0 [Note] InnoDB: Starting final batch to recover 14 pages from redo log. 2021-03-15 7:50:53 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2021-03-15 7:50:53 0 [Note] InnoDB: Starting in background the rollback of recovered transactions 2021-03-15 7:50:53 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2021-03-15 7:50:53 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2021-03-15 7:50:53 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2021-03-15 7:50:53 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2021-03-15 7:50:53 0 [Note] InnoDB: Waiting for purge to start 2021-03-15 7:50:53 0 [Note] InnoDB: 10.4.17 started; log sequence number 1105648049940; transaction id 158087576 2021-03-15 7:50:53 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2021-03-15 7:50:53 0 [Note] Plugin 'FEEDBACK' is disabled. 2021-03-15 7:50:53 0 [Note] Server socket created on IP: '0.0.0.0'. 2021-03-15 7:50:53 0 [Note] Reading of all Master_info entries succeeded 2021-03-15 7:50:53 0 [Note] Added new Master_info '' to hash table 2021-03-15 7:50:53 0 [Note] /usr/sbin/mysqld: ready for connections. Version: '10.4.17-MariaDB-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server 2021-03-15 7:50:53 0 [Note] InnoDB: Rolled back recovered transaction 158084550 2021-03-15 7:50:53 0 [Note] InnoDB: Rolled back recovered transaction 158084557 2021-03-15 7:50:53 0 [Note] InnoDB: Rollback of non-prepared transactions completed 2021-03-15 8:06:39 0 [Note] InnoDB: Buffer pool(s) load completed at 210315 8:06:39