250423 15:01:12 [ERROR] /usr/sbin/mariadbd got signal 11 ; Sorry, we probably made a mistake, and this is a bug. Your assistance in bug reporting will enable us to fix this for the next release. To report this bug, see https://mariadb.com/kb/en/reporting-bugs about how to report a bug on https://jira.mariadb.org/. Please include the information from the server start above, to the end of the information below. Server version: 10.6.21-MariaDB-log source revision: 066e8d6aeabc13242193780341e0f845528105de The information page at https://mariadb.com/kb/en/how-to-produce-a-full-stack-trace-for-mariadbd/ contains instructions to obtain a better version of the backtrace below. Following these instructions will help MariaDB developers provide a fix quicker. Attempting backtrace. Include this in the bug report. (note: Retrieving this information may fail) Thread pointer: 0x7f2620000c58 stack_bottom = 0x7f266836a000 thread_stack 0x49000 /usr/sbin/mariadbd(my_print_stacktrace+0x2e)[0x55d71f92ea1e] /usr/sbin/mariadbd(handle_fatal_signal+0x305)[0x55d71f3f21c5] /lib64/libc.so.6(+0x3e6f0)[0x7f266b83e6f0] /usr/sbin/mariadbd(_ZNK8Item_ref10const_itemEv+0x7)[0x55d71f144067] /usr/sbin/mariadbd(_ZN4Item25cache_const_expr_analyzerEPPh+0x44)[0x55d71f41ac44] /usr/sbin/mariadbd(_ZN8Item_ref7compileEP3THDM4ItemFbPPhES4_MS2_FPS2_S1_S3_ES3_+0x54)[0x55d71f408094] /usr/sbin/mariadbd(_ZN9Item_func7compileEP3THDM4ItemFbPPhES4_MS2_FPS2_S1_S3_ES3_+0xf0)[0x55d71f4674a0] /usr/sbin/mariadbd(_ZN8Item_ref7compileEP3THDM4ItemFbPPhES4_MS2_FPS2_S1_S3_ES3_+0x9c)[0x55d71f4080dc] /usr/sbin/mariadbd(_ZN9Item_func7compileEP3THDM4ItemFbPPhES4_MS2_FPS2_S1_S3_ES3_+0xf0)[0x55d71f4674a0] /usr/sbin/mariadbd(_ZN9Item_func7compileEP3THDM4ItemFbPPhES4_MS2_FPS2_S1_S3_ES3_+0xf0)[0x55d71f4674a0] /usr/sbin/mariadbd(_ZN4JOIN17cache_const_exprsEv+0xa9)[0x55d71f210119] /usr/sbin/mariadbd(_ZN4JOIN15optimize_stage2Ev+0x901)[0x55d71f214da1] /usr/sbin/mariadbd(_ZN4JOIN14optimize_innerEv+0x148e)[0x55d71f218a9e] /usr/sbin/mariadbd(_ZN4JOIN8optimizeEv+0xaa)[0x55d71f2190ca] /usr/sbin/mariadbd(+0x79bd48)[0x55d71f163d48] /usr/sbin/mariadbd(_Z27mysql_handle_single_derivedP3LEXP10TABLE_LISTj+0x95)[0x55d71f163575] /usr/sbin/mariadbd(_ZN4JOIN14optimize_innerEv+0xc87)[0x55d71f218297] /usr/sbin/mariadbd(_ZN4JOIN8optimizeEv+0xaa)[0x55d71f2190ca] /usr/sbin/mariadbd(_Z12mysql_selectP3THDP10TABLE_LISTR4ListI4ItemEPS4_jP8st_orderS9_S7_S9_yP13select_resultP18st_select_lex_unitP13st _select_lex+0xb3)[0x55d71f219193] /usr/sbin/mariadbd(_Z13handle_selectP3THDP3LEXP13select_resultm+0x169)[0x55d71f219999] /usr/sbin/mariadbd(+0x7d5b65)[0x55d71f19db65] /usr/sbin/mariadbd(_Z21mysql_execute_commandP3THDb+0x4652)[0x55d71f1addb2] /usr/sbin/mariadbd(_ZN13sp_instr_stmt9exec_coreEP3THDPj+0x3f)[0x55d71f0f62bf] /usr/sbin/mariadbd(_ZN13sp_lex_keeper23reset_lex_and_exec_coreEP3THDPjbP8sp_instr+0x160)[0x55d71f0ff580] /usr/sbin/mariadbd(_ZN13sp_instr_stmt7executeEP3THDPj+0x5dc)[0x55d71f0fff9c] /usr/sbin/mariadbd(_ZN7sp_head7executeEP3THDb+0x9e9)[0x55d71f0f9d69] /usr/sbin/mariadbd(_ZN7sp_head17execute_procedureEP3THDP4ListI4ItemE+0x6f2)[0x55d71f0fb6a2] /usr/sbin/mariadbd(+0x7d5997)[0x55d71f19d997] /usr/sbin/mariadbd(+0x7d9b48)[0x55d71f1a1b48] /usr/sbin/mariadbd(_Z21mysql_execute_commandP3THDb+0xf4a)[0x55d71f1aa6aa] /usr/sbin/mariadbd(_Z11mysql_parseP3THDPcjP12Parser_state+0x211)[0x55d71f1af611] /usr/sbin/mariadbd(_Z16dispatch_command19enum_server_commandP3THDPcjb+0xf15)[0x55d71f1b1865] /usr/sbin/mariadbd(_Z10do_commandP3THDb+0x13f)[0x55d71f1b3dff] /usr/sbin/mariadbd(_Z24do_handle_one_connectionP7CONNECTb+0x395)[0x55d71f2c6285] /usr/sbin/mariadbd(handle_one_connection+0x5d)[0x55d71f2c65dd] /usr/sbin/mariadbd(+0xc87859)[0x55d71f64f859] /lib64/libc.so.6(+0x89c02)[0x7f266b889c02] /lib64/libc.so.6(+0x10ec40)[0x7f266b90ec40] Connection ID (thread ID): 4 Status: NOT_KILLED Query (0x7f26200adcb0): SELECT * FROM v_t_task `t` WHERE CASE WHEN NAME_CONST('IN_listc2',NULL) IS NOT NULL THEN `t`.`listc2` LIKE CONCAT("%", NAME_CONST('IN_listc2',NULL), "%") ELSE TRUE END LIMIT 0, 25 Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersec tion=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,m aterialization=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,no t_null_range_scan=off,hash_join_cardinality=off,cset_narrowing=off Writing a core file... Working directory at /var/lib/mysql Resource Limits (excludes unlimited resources): Limit Soft Limit Hard Limit Units Max stack size 8388608 unlimited bytes Max core file size 0 unlimited bytes Max processes 6945 6945 processes Max open files 32768 32768 files Max locked memory 8388608 8388608 bytes Max pending signals 6945 6945 signals Max msgqueue size 819200 819200 bytes Max nice priority 0 0 Max realtime priority 0 0 Core pattern: |/usr/lib/systemd/systemd-coredump %P %u %g %s %t %c %h Kernel version: Linux version 5.14.0-427.37.1.el9_4.x86_64 (mockbuild@iad1-prod-build001.bld.equ.rockylinux.org) (gcc (GCC) 11.4.1 20 231218 (Red Hat 11.4.1-3), GNU ld version 2.35.2-43.el9) #1 SMP PREEMPT_DYNAMIC Wed Sep 25 11:51:41 UTC 2024