Oct 02 07:00:03 sql1 mariadbd[1831]: 2022-10-02  7:00:03 0 [Note] /usr/sbin/mariadbd (server 10.6.10-MariaDB) starting as process 1831 ...
Oct 02 07:00:03 sql1 mariadbd[1831]: 2022-10-02  7:00:03 0 [Note] InnoDB: Compressed tables use zlib 1.2.7
Oct 02 07:00:03 sql1 mariadbd[1831]: 2022-10-02  7:00:03 0 [Note] InnoDB: Number of pools: 1
Oct 02 07:00:03 sql1 mariadbd[1831]: 2022-10-02  7:00:03 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
Oct 02 07:00:03 sql1 mariadbd[1831]: 2022-10-02  7:00:03 0 [Note] InnoDB: Using Linux native AIO
Oct 02 07:00:03 sql1 mariadbd[1831]: 2022-10-02  7:00:03 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728
Oct 02 07:00:03 sql1 mariadbd[1831]: 2022-10-02  7:00:03 0 [Note] InnoDB: Completed initialization of buffer pool
Oct 02 07:00:03 sql1 mariadbd[1831]: 2022-10-02  7:00:03 0 [Note] InnoDB: 128 rollback segments are active.
Oct 02 07:00:03 sql1 mariadbd[1831]: 2022-10-02  7:00:03 0 [Note] InnoDB: Creating shared tablespace for temporary tables
Oct 02 07:00:03 sql1 mariadbd[1831]: 2022-10-02  7:00:03 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
Oct 02 07:00:03 sql1 mariadbd[1831]: 2022-10-02  7:00:03 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
Oct 02 07:00:03 sql1 mariadbd[1831]: 2022-10-02  7:00:03 0 [Note] InnoDB: 10.6.10 started; log sequence number 74045; transaction id 51
Oct 02 07:00:03 sql1 mariadbd[1831]: 2022-10-02  7:00:03 0 [Note] Plugin 'FEEDBACK' is disabled.
Oct 02 07:00:03 sql1 mariadbd[1831]: 2022-10-02  7:00:03 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
Oct 02 07:00:03 sql1 mariadbd[1831]: 2022-10-02  7:00:03 0 [Note] Server socket created on IP: '0.0.0.0'.
Oct 02 07:00:03 sql1 mariadbd[1831]: 2022-10-02  7:00:03 0 [Note] Server socket created on IP: '::'.
Oct 02 07:00:03 sql1 mariadbd[1831]: 2022-10-02  7:00:03 0 [Note] /usr/sbin/mariadbd: ready for connections.
Oct 02 07:00:03 sql1 mariadbd[1831]: Version: '10.6.10-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MariaDB Server
Oct 02 07:00:03 sql1 mariadbd[1831]: 2022-10-02  7:00:03 0 [Note] InnoDB: Buffer pool(s) load completed at 221002  7:00:03
Oct 02 07:00:10 sql1 mariadbd[1831]: 221002  7:00:10 [ERROR] mysqld got signal 11 ;
Oct 02 07:00:10 sql1 mariadbd[1831]: This could be because you hit a bug. It is also possible that this binary
Oct 02 07:00:10 sql1 mariadbd[1831]: or one of the libraries it was linked against is corrupt, improperly built,
Oct 02 07:00:10 sql1 mariadbd[1831]: or misconfigured. This error can also be caused by malfunctioning hardware.
Oct 02 07:00:10 sql1 mariadbd[1831]: To report this bug, see https://mariadb.com/kb/en/reporting-bugs
Oct 02 07:00:10 sql1 mariadbd[1831]: We will try our best to scrape up some info that will hopefully help
Oct 02 07:00:10 sql1 mariadbd[1831]: diagnose the problem, but since we have already crashed,
Oct 02 07:00:10 sql1 mariadbd[1831]: something is definitely wrong and this may fail.
Oct 02 07:00:10 sql1 mariadbd[1831]: Server version: 10.6.10-MariaDB
Oct 02 07:00:10 sql1 mariadbd[1831]: key_buffer_size=134217728
Oct 02 07:00:10 sql1 mariadbd[1831]: read_buffer_size=131072
Oct 02 07:00:10 sql1 mariadbd[1831]: max_used_connections=1
Oct 02 07:00:10 sql1 mariadbd[1831]: max_threads=153
Oct 02 07:00:10 sql1 mariadbd[1831]: thread_count=1
Oct 02 07:00:10 sql1 mariadbd[1831]: It is possible that mysqld could use up to
Oct 02 07:00:10 sql1 mariadbd[1831]: key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 467959 K  bytes of memory
Oct 02 07:00:10 sql1 mariadbd[1831]: Hope that's ok; if not, decrease some variables in the equation.
Oct 02 07:00:10 sql1 mariadbd[1831]: Thread pointer: 0x7fa6040010c8
Oct 02 07:00:10 sql1 mariadbd[1831]: Attempting backtrace. You can use the following information to find out
Oct 02 07:00:10 sql1 mariadbd[1831]: where mysqld died. If you see no messages after this, something went
Oct 02 07:00:10 sql1 mariadbd[1831]: terribly wrong...
Oct 02 07:00:10 sql1 mariadbd[1831]: stack_bottom = 0x7fa6248ffcc0 thread_stack 0x49000
Oct 02 07:00:11 sql1 mariadbd[1831]: /usr/sbin/mariadbd(my_print_stacktrace+0x2e)[0x562d92bc26ae]
Oct 02 07:00:11 sql1 mariadbd[1831]: /usr/sbin/mariadbd(handle_fatal_signal+0x307)[0x562d92611527]
Oct 02 07:00:16 sql1 mariadbd[1831]: sigaction.c:0(__restore_rt)[0x7fa63f752630]
Oct 02 07:00:16 sql1 mariadbd[1831]: /usr/sbin/mariadbd(_ZN4JOIN14optimize_innerEv+0x2729)[0x562d9244a979]
Oct 02 07:00:17 sql1 mariadbd[1831]: /usr/sbin/mariadbd(_ZN4JOIN8optimizeEv+0xc5)[0x562d9244bab5]
Oct 02 07:00:17 sql1 mariadbd[1831]: /usr/sbin/mariadbd(_Z12mysql_selectP3THDP10TABLE_LISTR4ListI4ItemEPS4_jP8st_orderS9_S7_S9_yP13select_resultP18st_select_lex_unitP13st_select_lex+0xb8)[0x562d9244bb88]
Oct 02 07:00:18 sql1 mariadbd[1831]: /usr/sbin/mariadbd(_Z13handle_selectP3THDP3LEXP13select_resultm+0x1e4)[0x562d9244c494]
Oct 02 07:00:18 sql1 mariadbd[1831]: /usr/sbin/mariadbd(+0x66ba08)[0x562d922ada08]
Oct 02 07:00:19 sql1 mariadbd[1831]: /usr/sbin/mariadbd(_Z21mysql_execute_commandP3THDb+0x3491)[0x562d923eda51]
Oct 02 07:00:20 sql1 mariadbd[1831]: /usr/sbin/mariadbd(_Z11mysql_parseP3THDPcjP12Parser_state+0x20b)[0x562d923efdeb]
Oct 02 07:00:20 sql1 mariadbd[1831]: Printing to addr2line failed
Oct 02 07:00:20 sql1 mariadbd[1831]: /usr/sbin/mariadbd(_Z16dispatch_command19enum_server_commandP3THDPcjb+0x1227)[0x562d923f1fe7]
Oct 02 07:00:20 sql1 mariadbd[1831]: /usr/sbin/mariadbd(_Z10do_commandP3THDb+0x123)[0x562d923f36a3]
Oct 02 07:00:20 sql1 mariadbd[1831]: /usr/sbin/mariadbd(_Z24do_handle_one_connectionP7CONNECTb+0x187)[0x562d924e9597]
Oct 02 07:00:20 sql1 mariadbd[1831]: /usr/sbin/mariadbd(handle_one_connection+0x34)[0x562d924e9834]
Oct 02 07:00:20 sql1 mariadbd[1831]: /usr/sbin/mariadbd(+0xc123cc)[0x562d928543cc]
Oct 02 07:00:20 sql1 mariadbd[1831]: nptl/pthread_create.c:307(start_thread)[0x7fa63f74aea5]
Oct 02 07:00:20 sql1 mariadbd[1831]: x86_64/clone.S:113(__clone)[0x7fa63ec65b0d]
Oct 02 07:00:20 sql1 mariadbd[1831]: Trying to get some variables.
Oct 02 07:00:20 sql1 mariadbd[1831]: Some pointers may be invalid and cause the dump to abort.
Oct 02 07:00:20 sql1 mariadbd[1831]: Query (0x7fa604010d90): (SELECT bx.itahweit, v.aithixis/2 aithixis, 2 angooyie, JSON_UNQUOTE(JSON_EXTRACT(eebiavit, '$.claumexf')) claumexf FROM d.vohgajoo bx LEFT JOIN d.imaewaey v ON v.itizahra='en' AND v.angooyie=2 AND v.binaeshe=bx.ohtighit WHERE bx.ohtighit IN (4985) AND bx.theibaej=1 ORDER BY bx.meingeic IN ('f','t') DESC, JSON_EXTRACT(bx.eebiavit, '$.balmrusb') DESC LIMIT 1) ORDER BY angooyie=16, aithixis DESC
Oct 02 07:00:20 sql1 mariadbd[1831]: Connection ID (thread ID): 3
Oct 02 07:00:20 sql1 mariadbd[1831]: Status: NOT_KILLED
Oct 02 07:00:20 sql1 mariadbd[1831]: 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
Oct 02 07:00:20 sql1 mariadbd[1831]: The manual page at https://mariadb.com/kb/en/how-to-produce-a-full-stack-trace-for-mysqld/ contains
Oct 02 07:00:20 sql1 mariadbd[1831]: information that should help you find out what is causing the crash.
Oct 02 07:00:20 sql1 mariadbd[1831]: Writing a core file...
Oct 02 07:00:20 sql1 mariadbd[1831]: Working directory at /var/lib/mysql
Oct 02 07:00:20 sql1 mariadbd[1831]: Resource Limits:
Oct 02 07:00:20 sql1 mariadbd[1831]: Limit                     Soft Limit           Hard Limit           Units
Oct 02 07:00:20 sql1 mariadbd[1831]: Max cpu time              unlimited            unlimited            seconds
Oct 02 07:00:20 sql1 mariadbd[1831]: Max file size             unlimited            unlimited            bytes
Oct 02 07:00:20 sql1 mariadbd[1831]: Max data size             unlimited            unlimited            bytes
Oct 02 07:00:20 sql1 mariadbd[1831]: Max stack size            8388608              unlimited            bytes
Oct 02 07:00:20 sql1 mariadbd[1831]: Max core file size        unlimited            unlimited            bytes
Oct 02 07:00:20 sql1 mariadbd[1831]: Max resident set          unlimited            unlimited            bytes
Oct 02 07:00:20 sql1 mariadbd[1831]: Max processes             3764                 3764                 processes
Oct 02 07:00:20 sql1 mariadbd[1831]: Max open files            32768                32768                files
Oct 02 07:00:20 sql1 mariadbd[1831]: Max locked memory         65536                65536                bytes
Oct 02 07:00:20 sql1 mariadbd[1831]: Max address space         unlimited            unlimited            bytes
Oct 02 07:00:20 sql1 mariadbd[1831]: Max file locks            unlimited            unlimited            locks
Oct 02 07:00:20 sql1 mariadbd[1831]: Max pending signals       3764                 3764                 signals
Oct 02 07:00:20 sql1 mariadbd[1831]: Max msgqueue size         819200               819200               bytes
Oct 02 07:00:20 sql1 mariadbd[1831]: Max nice priority         0                    0
Oct 02 07:00:20 sql1 mariadbd[1831]: Max realtime priority     0                    0
Oct 02 07:00:20 sql1 mariadbd[1831]: Max realtime timeout      unlimited            unlimited            us
Oct 02 07:00:20 sql1 mariadbd[1831]: Core pattern: core
Oct 02 07:00:20 sql1 mariadbd[1831]: Kernel version: Linux version 3.10.0-1160.76.1.el7.x86_64 (mockbuild@kbuilder.bsys.centos.org) (gcc version 4.8.5 20150623 (Red Hat 4.8.5-44) (GCC) ) #1 SMP Wed Aug 10 16:21:17 UTC 2022