Mar 12 13:02:18 localhost mysqld: 2023-03-12 13:02:18 0 [Note] Starting MariaDB 10.4.28-MariaDB source revision c8f2e9a5c0ac5905f28b050b7df5a9ffd914b7e7 as pro cess 14549 Mar 12 13:02:18 localhost mysqld: 2023-03-12 13:02:18 0 [Note] InnoDB: Using Linux native AIO Mar 12 13:02:18 localhost mysqld: 2023-03-12 13:02:18 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins Mar 12 13:02:18 localhost mysqld: 2023-03-12 13:02:18 0 [Note] InnoDB: Uses event mutexes Mar 12 13:02:18 localhost mysqld: 2023-03-12 13:02:18 0 [Note] InnoDB: Compressed tables use zlib 1.2.7 Mar 12 13:02:18 localhost mysqld: 2023-03-12 13:02:18 0 [Note] InnoDB: Number of pools: 1 Mar 12 13:02:18 localhost mysqld: 2023-03-12 13:02:18 0 [Note] InnoDB: Using SSE2 crc32 instructions Mar 12 13:02:18 localhost mysqld: 2023-03-12 13:02:18 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M Mar 12 13:02:18 localhost mysqld: 2023-03-12 13:02:18 0 [Note] InnoDB: Completed initialization of buffer pool Mar 12 13:02:18 localhost mysqld: 2023-03-12 13:02:18 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). Mar 12 13:02:18 localhost mysqld: 2023-03-12 13:02:18 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=201332152844 Mar 12 13:02:18 localhost mysqld: 2023-03-12 13:02:18 0 [Note] InnoDB: Starting final batch to recover 10 pages from redo log. Mar 12 13:02:18 localhost mysqld: 2023-03-12 13:02:18 0 [Note] InnoDB: 128 out of 128 rollback segments are active. Mar 12 13:02:18 localhost mysqld: 2023-03-12 13:02:18 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" Mar 12 13:02:18 localhost mysqld: 2023-03-12 13:02:18 0 [Note] InnoDB: Creating shared tablespace for temporary tables Mar 12 13:02:18 localhost mysqld: 2023-03-12 13:02:18 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... Mar 12 13:02:18 localhost mysqld: 2023-03-12 13:02:18 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. Mar 12 13:02:18 localhost mysqld: 2023-03-12 13:02:18 0 [Note] InnoDB: Waiting for purge to start Mar 12 13:02:18 localhost mysqld: 2023-03-12 13:02:18 0 [Note] InnoDB: 10.4.28 started; log sequence number 201332155825; transaction id 427777442 Mar 12 13:02:18 localhost mysqld: 2023-03-12 13:02:18 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool Mar 12 13:02:18 localhost mysqld: 2023-03-12 13:02:18 0 [Note] InnoDB: Cannot open '/var/lib/mysql/ib_buffer_pool' for reading: No such file or directory Mar 12 13:02:18 localhost mysqld: 2023-03-12 13:02:18 0 [Note] Plugin 'FEEDBACK' is disabled. Mar 12 13:02:18 localhost mysqld: 2023-03-12 13:02:18 0 [Note] Server socket created on IP: '::'. Mar 12 13:02:18 localhost mysqld: 230312 13:02:18 [ERROR] mysqld got signal 11 ; Mar 12 13:02:18 localhost mysqld: This could be because you hit a bug. It is also possible that this binary Mar 12 13:02:18 localhost mysqld: or one of the libraries it was linked against is corrupt, improperly built, Mar 12 13:02:18 localhost mysqld: or misconfigured. This error can also be caused by malfunctioning hardware. Mar 12 13:02:18 localhost mysqld: To report this bug, see https://mariadb.com/kb/en/reporting-bugs Mar 12 13:02:18 localhost mysqld: We will try our best to scrape up some info that will hopefully help Mar 12 13:02:18 localhost mysqld: diagnose the problem, but since we have already crashed, Mar 12 13:02:18 localhost mysqld: something is definitely wrong and this may fail. Mar 12 13:02:18 localhost mysqld: Server version: 10.4.28-MariaDB source revision: c8f2e9a5c0ac5905f28b050b7df5a9ffd914b7e7 Mar 12 13:02:18 localhost mysqld: key_buffer_size=134217728 Mar 12 13:02:18 localhost mysqld: read_buffer_size=131072 Mar 12 13:02:18 localhost mysqld: max_used_connections=0 Mar 12 13:02:18 localhost mysqld: max_threads=153 Mar 12 13:02:18 localhost mysqld: thread_count=6 Mar 12 13:02:18 localhost mysqld: It is possible that mysqld could use up to Mar 12 13:02:18 localhost mysqld: key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 467777 K bytes of memory Mar 12 13:02:18 localhost mysqld: Hope that's ok; if not, decrease some variables in the equation. Mar 12 13:02:18 localhost mysqld: Thread pointer: 0x5611fa390788 Mar 12 13:02:18 localhost mysqld: Attempting backtrace. You can use the following information to find out Mar 12 13:02:18 localhost mysqld: where mysqld died. If you see no messages after this, something went Mar 12 13:02:18 localhost mysqld: terribly wrong... Mar 12 13:02:18 localhost mysqld: stack_bottom = 0x7ffe0ac94d20 thread_stack 0x49000 Mar 12 13:02:18 localhost mysqld: /usr/sbin/mysqld(my_print_stacktrace+0x2e)[0x5611f833098e] Mar 12 13:02:18 localhost mysqld: /usr/sbin/mysqld(handle_fatal_signal+0x317)[0x5611f7d7c0e7] Mar 12 13:02:18 localhost mysqld: sigaction.c:0(__restore_rt)[0x7f6d0f14a630] Mar 12 13:02:18 localhost mysqld: /usr/sbin/mysqld(+0x64a0d9)[0x5611f7af50d9] Mar 12 13:02:18 localhost mysqld: /usr/sbin/mysqld(_Z10acl_reloadP3THD+0xd96)[0x5611f7b002b6] Mar 12 13:02:18 localhost mysqld: /usr/sbin/mysqld(_Z8acl_initb+0x163)[0x5611f7b012c3] Mar 12 13:02:18 localhost mysqld: /usr/sbin/mysqld(_Z11mysqld_mainiPPc+0xaed)[0x5611f7abfffd] Mar 12 13:02:18 localhost mysqld: /lib64/libc.so.6(__libc_start_main+0xf5)[0x7f6d0e581555] Mar 12 13:02:18 localhost mysqld: /usr/sbin/mysqld(+0x608a54)[0x5611f7ab3a54] Mar 12 13:02:18 localhost mysqld: Trying to get some variables. Mar 12 13:02:18 localhost mysqld: Some pointers may be invalid and cause the dump to abort. Mar 12 13:02:18 localhost mysqld: Query (0x0): (null) Mar 12 13:02:18 localhost mysqld: Connection ID (thread ID): 0 Mar 12 13:02:18 localhost mysqld: Status: NOT_KILLED Mar 12 13:02:18 localhost mysqld: Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_ intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=o n,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_j oin_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=on,table_elimination=on,e xtended_keys=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=on,split_materialized=on,condition_pushdown_for_subquery=on,rowid_f ilter=on,condition_pushdown_from_having=on Mar 12 13:02:18 localhost mysqld: The manual page at https://mariadb.com/kb/en/how-to-produce-a-full-stack-trace-for-mysqld/ contains Mar 12 13:02:18 localhost mysqld: information that should help you find out what is causing the crash. Mar 12 13:02:18 localhost mysqld: We think the query pointer is invalid, but we will try to print it anyway. Mar 12 13:02:18 localhost mysqld: Query: Mar 12 13:02:18 localhost mysqld: Writing a core file... Mar 12 13:02:18 localhost mysqld: Working directory at /var/lib/mysql Mar 12 13:02:18 localhost mysqld: Resource Limits: Mar 12 13:02:18 localhost mysqld: Limit Soft Limit Hard Limit Units Mar 12 13:02:18 localhost mysqld: Max cpu time unlimited unlimited seconds Mar 12 13:02:18 localhost mysqld: Max file size unlimited unlimited bytes Mar 12 13:02:18 localhost mysqld: Max data size unlimited unlimited bytes Mar 12 13:02:18 localhost mysqld: Max stack size 8388608 unlimited bytes Mar 12 13:02:18 localhost mysqld: Max core file size 0 unlimited bytes Mar 12 13:02:18 localhost mysqld: Max resident set unlimited unlimited bytes Mar 12 13:02:18 localhost mysqld: Max processes 63478 63478 processes Mar 12 13:02:18 localhost mysqld: Max open files 32768 32768 files Mar 12 13:02:18 localhost mysqld: Max locked memory 65536 65536 bytes Mar 12 13:02:18 localhost mysqld: Max address space unlimited unlimited bytes Mar 12 13:02:18 localhost mysqld: Max file locks unlimited unlimited locks Mar 12 13:02:18 localhost mysqld: Max pending signals 63478 63478 signals Mar 12 13:02:18 localhost mysqld: Max msgqueue size 819200 819200 bytes Mar 12 13:02:18 localhost mysqld: Max nice priority 0 0 Mar 12 13:02:18 localhost mysqld: Max realtime priority 0 0 Mar 12 13:02:18 localhost mysqld: Max realtime timeout unlimited unlimited us Mar 12 13:02:18 localhost mysqld: Core pattern: core Mar 12 13:02:18 localhost mysqld: Kernel version: Linux version 3.10.0-1160.88.1.el7.x86_64 (mockbuild@kbuilder.bsys.centos.org) (gcc version 4.8.5 20150623 (R ed Hat 4.8.5-44) (GCC) ) #1 SMP Tue Mar 7 15:41:52 UTC 2023