Feb 23 10:43:03 localhost mariadbd[2960]: 210223 10:43:03 [ERROR] mysqld got signal 11 ; Feb 23 10:43:03 localhost mariadbd[2960]: This could be because you hit a bug. It is also possible that this binary Feb 23 10:43:03 localhost mariadbd[2960]: or one of the libraries it was linked against is corrupt, improperly built, Feb 23 10:43:03 localhost mariadbd[2960]: or misconfigured. This error can also be caused by malfunctioning hardware. Feb 23 10:43:03 localhost mariadbd[2960]: To report this bug, see https://mariadb.com/kb/en/reporting-bugs Feb 23 10:43:03 localhost mariadbd[2960]: We will try our best to scrape up some info that will hopefully help Feb 23 10:43:03 localhost mariadbd[2960]: diagnose the problem, but since we have already crashed, Feb 23 10:43:03 localhost mariadbd[2960]: something is definitely wrong and this may fail. Feb 23 10:43:03 localhost mariadbd[2960]: Server version: 10.5.8-MariaDB-3-log Feb 23 10:43:03 localhost mariadbd[2960]: key_buffer_size=134217728 Feb 23 10:43:03 localhost mariadbd[2960]: read_buffer_size=268435456 Feb 23 10:43:03 localhost mariadbd[2960]: max_used_connections=1 Feb 23 10:43:03 localhost mariadbd[2960]: max_threads=102 Feb 23 10:43:03 localhost mariadbd[2960]: thread_count=3 Feb 23 10:43:03 localhost mariadbd[2960]: It is possible that mysqld could use up to Feb 23 10:43:03 localhost mariadbd[2960]: key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 27290117 K bytes of memory Feb 23 10:43:03 localhost mariadbd[2960]: Hope that's ok; if not, decrease some variables in the equation. Feb 23 10:43:03 localhost mariadbd[2960]: Thread pointer: 0x7fd8c80008e8 Feb 23 10:43:03 localhost mariadbd[2960]: Attempting backtrace. You can use the following information to find out Feb 23 10:43:03 localhost mariadbd[2960]: where mysqld died. If you see no messages after this, something went Feb 23 10:43:03 localhost mariadbd[2960]: terribly wrong... Feb 23 10:43:03 localhost mariadbd[2960]: stack_bottom = 0x7fd9280d2d78 thread_stack 0x49000 Feb 23 10:43:03 localhost mariadbd[2960]: ??:0(my_print_stacktrace)[0x555789f3b47e] Feb 23 10:43:03 localhost mariadbd[2960]: ??:0(handle_fatal_signal)[0x555789a4c2d5] Feb 23 10:43:03 localhost mariadbd[2960]: runtime/sys_linux_amd64.s:390(runtime.sigfwd)[0x7fd92ab8df1d] Feb 23 10:43:03 localhost mariadbd[2960]: Trying to get some variables. Feb 23 10:43:03 localhost mariadbd[2960]: Some pointers may be invalid and cause the dump to abort. Feb 23 10:43:03 localhost mariadbd[2960]: Query (0x7fd8c8035870): SELECT * FROM ( Feb 23 10:43:03 localhost mariadbd[2960]: Feb 23 10:43:03 localhost mariadbd[2960]: SELECT id,ST_DISTANCE(p1,p2) dist FROM ( Feb 23 10:43:03 localhost mariadbd[2960]: SELECT * FROM ( Feb 23 10:43:03 localhost mariadbd[2960]: SELECT seq id, POINT(lon,lat) p1 FROM Feb 23 10:43:03 localhost mariadbd[2960]: (SELECT seq,floor(RAND()*90) lon,floor(RAND()*180) lat FROM seq_1_to_10) s Feb 23 10:43:03 localhost mariadbd[2960]: )t Feb 23 10:43:03 localhost mariadbd[2960]: Feb 23 10:43:03 localhost mariadbd[2960]: JOIN ( Feb 23 10:43:03 localhost mariadbd[2960]: SELECT seq id2, POINT(lon,lat) p2 FROM Feb 23 10:43:03 localhost mariadbd[2960]: (SELECT seq,floor(RAND()*90) lon,floor(RAND()*180) lat FROM seq_1_to_10) s Feb 23 10:43:03 localhost mariadbd[2960]: )t2 ON t.id = t2.id2 Feb 23 10:43:03 localhost mariadbd[2960]: Feb 23 10:43:03 localhost mariadbd[2960]: )t Feb 23 10:43:03 localhost mariadbd[2960]: Feb 23 10:43:03 localhost mariadbd[2960]: )t WHERE dist <= 1000 Feb 23 10:43:03 localhost mariadbd[2960]: Connection ID (thread ID): 7 Feb 23 10:43:03 localhost mariadbd[2960]: Status: NOT_KILLED Feb 23 10:43:03 localhost mariadbd[2960]: 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=on,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_join_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,extended_keys=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=on,split_materialized=on,condition_pushdown_for_subquery=on,rowid_filter=on,condition_pushdown_from_having=on,not_null_range_scan=off Feb 23 10:43:03 localhost mariadbd[2960]: The manual page at https://mariadb.com/kb/en/how-to-produce-a-full-stack-trace-for-mysqld/ contains Feb 23 10:43:03 localhost mariadbd[2960]: information that should help you find out what is causing the crash. Feb 23 10:43:03 localhost mariadbd[2960]: Writing a core file... Feb 23 10:43:03 localhost mariadbd[2960]: Working directory at /var/lib/mysql Feb 23 10:43:03 localhost mariadbd[2960]: Resource Limits: Feb 23 10:43:03 localhost mariadbd[2960]: Limit Soft Limit Hard Limit Units Feb 23 10:43:03 localhost mariadbd[2960]: Max cpu time unlimited unlimited seconds Feb 23 10:43:03 localhost mariadbd[2960]: Max file size unlimited unlimited bytes Feb 23 10:43:03 localhost mariadbd[2960]: Max data size unlimited unlimited bytes Feb 23 10:43:03 localhost mariadbd[2960]: Max stack size 8388608 unlimited bytes Feb 23 10:43:03 localhost mariadbd[2960]: Max core file size 0 unlimited bytes Feb 23 10:43:03 localhost mariadbd[2960]: Max resident set unlimited unlimited bytes Feb 23 10:43:03 localhost mariadbd[2960]: Max processes 63425 63425 processes Feb 23 10:43:03 localhost mariadbd[2960]: Max open files 16384 16384 files Feb 23 10:43:03 localhost mariadbd[2960]: Max locked memory 65536 65536 bytes Feb 23 10:43:03 localhost mariadbd[2960]: Max address space unlimited unlimited bytes Feb 23 10:43:03 localhost mariadbd[2960]: Max file locks unlimited unlimited locks Feb 23 10:43:03 localhost mariadbd[2960]: Max pending signals 63425 63425 signals Feb 23 10:43:03 localhost mariadbd[2960]: Max msgqueue size 819200 819200 bytes Feb 23 10:43:03 localhost mariadbd[2960]: Max nice priority 0 0 Feb 23 10:43:03 localhost mariadbd[2960]: Max realtime priority 0 0 Feb 23 10:43:03 localhost mariadbd[2960]: Max realtime timeout unlimited unlimited us Feb 23 10:43:03 localhost mariadbd[2960]: Core pattern: core Feb 23 10:43:03 localhost systemd[1]: mariadb.service: Main process exited, code=killed, status=11/SEGV