260708 14:56:21 [ERROR] /data/db/vendor/mariadb/server/install-asan/bin/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/docs/general-resources/community/community/bug-tracking/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: 13.1.0-MariaDB-asan source revision: 34dd221590eb9d6dbda701031fcf8a84df9821fd The information page at https://mariadb.com/docs/server/reference/product-development/mariadb-fault-finding/how-to-produce-a-full-stack-trace-for-mariadbdcontains 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: 0x52c0001b0220 stack_bottom = 0x77b81e9e5000 thread_stack 0xb00000 sanitizer_common/sanitizer_common_interceptors.inc:4193(__interceptor_backtrace.part.0)[0x7fb83e245c0e] mysys/stacktrace.c:216(my_print_stacktrace)[0x55971e28114b] sql/signal_handler.cc:227(handle_fatal_signal)[0x55971d03e6f2] libc_sigaction.c:0(__restore_rt)[0x7fb83d442520] sql/item.h:3919(Item_field::type_handler() const)[0x55971d0ee366] sql/sql_type.h:7952(Type_handler_hybrid_field_type::set_handler(Type_handler const*))[0x55971d433392] sql/item_subselect.cc:4078(subselect_union_engine::fix_length_and_dec(Item_cache**))[0x55971d433e8b] sql/item_subselect.cc:1317(Item_singlerow_subselect::fix_length_and_dec())[0x55971d4092c7] sql/item_subselect.cc:334(Item_subselect::fix_fields(THD*, Item**))[0x55971d42708b] sql/item_func.cc:394(Item_func::fix_fields(THD*, Item**))[0x55971d238b56] sql/item.h:1160(Item::fix_fields_if_needed_for_scalar(THD*, Item**))[0x55971d17d4cc] sql/table.cc:7409(create_view_field(THD*, TABLE_LIST*, Item**, st_mysql_const_lex_string*))[0x55971caa8bda] sql/sql_base.cc:6380(find_field_in_table_ref(THD*, TABLE_LIST*, Lex_ident_column const&, char const*, char const*, char const*, List*, Item**, bool, bool, unsigned short*, bool, TABLE_LIST**) [clone .localalias])[0x55971c50071d] sql/sql_base.cc:7085(find_field_in_tables(THD*, Item_ident*, TABLE_LIST*, TABLE_LIST*, List*, Item**, find_item_error_report_type, bool, bool))[0x55971c5033db] sql/item.cc:6588(Item_field::fix_fields(THD*, Item**))[0x55971d0e0464] sql/item_func.cc:394(Item_func::fix_fields(THD*, Item**))[0x55971d238b56] sql/item_func.cc:394(Item_func::fix_fields(THD*, Item**))[0x55971d238b56] sql/item_func.cc:394(Item_func::fix_fields(THD*, Item**))[0x55971d238b56] sql/item_func.cc:394(Item_func::fix_fields(THD*, Item**))[0x55971d238b56] sql/item_func.cc:394(Item_func::fix_fields(THD*, Item**))[0x55971d238b56] sql/item_func.cc:394(Item_func::fix_fields(THD*, Item**))[0x55971d238b56] sql/item.h:1160(Item::fix_fields_if_needed_for_scalar(THD*, Item**))[0x55971c50637d] sql/sql_select.cc:1598(JOIN::prepare(TABLE_LIST*, Item*, unsigned int, st_order*, bool, st_order*, Item*, st_order*, st_select_lex*, st_select_lex_unit*))[0x55971c85df02] sql/sql_select.cc:5409(mysql_select(THD*, TABLE_LIST*, List&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x55971c8c87d6] sql/sql_select.cc:636(handle_select(THD*, LEX*, select_result*, unsigned long long))[0x55971c8c94d5] sql/sql_parse.cc:6217(execute_sqlcom_select(THD*, TABLE_LIST*))[0x55971c6bf98e] sql/sql_parse.cc:3991(mysql_execute_command(THD*, bool))[0x55971c6f0919] sql/sql_prepare.cc:5367(Prepared_statement::execute(String*, bool, select_result*, Server_side_cursor**))[0x55971c76ceff] sql/sql_prepare.cc:4726(Prepared_statement::execute_loop(String*, bool, select_result*, Server_side_cursor**, InstrSlice const&, unsigned char*, unsigned char*))[0x55971c76e4f5] sql/sql_prepare.cc:3518(mysql_stmt_execute_common(THD*, unsigned long, unsigned char*, unsigned char*, unsigned long, bool, bool, bool))[0x55971c771faa] sql/sql_prepare.cc:3288(mysqld_stmt_execute(THD*, char*, unsigned int))[0x55971c772681] sql/sql_parse.cc:1830(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool))[0x55971c6ff0f5] sql/sql_parse.cc:1439(do_command(THD*, bool))[0x55971c7041c6] sql/sql_connect.cc:1510(do_handle_one_connection(CONNECT*, bool))[0x55971cb664ad] sql/sql_connect.cc:1422(handle_one_connection)[0x55971cb6688d] perfschema/pfs.cc:2201(pfs_spawn_thread)[0x55971d9461e9] nptl/pthread_create.c:442(start_thread)[0x7fb83d494ac3] x86_64/clone3.S:83(__clone3)[0x7fb83d5268d0] Connection ID (thread ID): 6 Status: NOT_KILLED Query (0x52d00037c3e8): select distinct (cast(((count((select count(t1219.c4) from t1219)) over (partition by subq_0.a1 order by subq_0.a2) &0xffffffff)+2147483648)&0xffffffff as signed)-2147483648) as a1, ((cast(((subq_0.a2 &0xffffffff)+2147483648)&0xffffffff as signed)-2147483648) between ((cast(((coalesce( (subq_0.a2 * (cast(((subq_0.a4 &0xffffffff)+2147483648)&0xffffffff as signed)-2147483648)), (cast(((subq_0.a2 &0xffff)+32768)&0xffff as signed)-32768) ) &0xffff)+32768)&0xffff as signed)-32768) % subq_0.a4) and (cast(((subq_0.a2 &0xffffffff)+2147483648)&0xffffffff as signed)-2147483648)) as a2, (1=1) as a3, (NOT NOT (cast(((((cast(((subq_0.a4 &0xffffffff)+2147483648)&0xffffffff as signed)-2147483648) && ((NOT NOT (subq_0.a4 <= ?)) or (subq_0.a4 between (cast(((subq_0.a2 &0xffffffff)+2147483648)&0xffffffff as signed)-2147483648) and subq_0.a2))) &0xff)+128)&0xff as signed)-128)) as a4, left(cast(subq_0.a3 as char), subq_0.a2) as a5 from (select ((cast(((ref_0.a3 &0xffffffff)+2147483648)&0xffffffff as signed)-2147483648) ^ ?) as a1, ((cast(? as char) < ( select cast(? as char) as a1 from t1323 as ref_3 where (cast(? as char) <> ( select cast(? as char) as a1 from t1320 as ref_4 where (0<>0) limit 1 )) union all ( select cast(? as char) as a1 from t1310 as ref_5 where ((1=1) or (0<>0)) ) limit 1 )) and (0<>0)) as a2, ? as a3, ref_0.a8 as a4 from t1299 as ref_0 where EXISTS ( select ? as a1 from t1288 as ref_1 where EXISTS ( select ref_1.a5 as a1 from t1240 as ref_2 where (? like 'a854_') ) limit 66 ) order by a1, a2, a3, a4 asc) as subq_0 where (cast(subq_0.a1 as char) < ( select cast(subq_0.a3 as char) as a1 from t1223 as ref_6 where (NOT NOT (cast(ref_6.c4 as double) <= subq_0.a4)) union all ( select cast(subq_0.a1 as char) as a1 from ((t1243 as ref_7 left outer join v1269 as ref_8 on ((NOT NOT (? <> cast(? as char))))) right outer join ((t1254 as ref_9 left outer join t1288 as ref_10 on ((cast(? as char) >= ( select cast(? as char) as a1 from t1191 as ref_11 where (1=1) order by a1 asc limit 1 )))) left outer join t1236 as ref_12 on ((? like 'o%n'))) on ((NOT NOT ((cast(((ref_10.a6 &0xffffff)+8388608)&0xffffff as signed)-8388608) || ref_9.c6)))) where (NOT NOT (? < cast(ref_8.a1 as char))) ) order by a1 limit 1 )) order by a1, a2, a3, a4, a5 desc Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,duplicateweedout=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,hash_join_cardinality=on,cset_narrowing=on,sargable_casefold=on,reorder_outer_joins=off Writing a core file... Working directory at /data/nvme3/db/vendor/mariadb/server/asan-runtime/data Resource Limits (excludes unlimited resources): Limit Soft Limit Hard Limit Units Max stack size 8388608 unlimited bytes Max core file size 8589934592 8589934592 bytes Max processes 2062076 2062076 processes Max open files 1048576 1048576 files Max locked memory 67581202432 67581202432 bytes Max pending signals 2062076 2062076 signals Max msgqueue size 819200 819200 bytes Max nice priority 0 0 Max realtime priority 0 0 Core pattern: |/usr/local/bin/coredump_handler /var/cores/core-%h-%e-%u-%g-%p-%t-%c - %c Kernel version: Linux version 6.8.0-124-generic (buildd@lcy02-amd64-109) (x86_64-linux-gnu-gcc-12 (Ubuntu 12.3.0-1ubuntu1~22.04.3) 12.3.0, GNU ld (GNU Binutils for Ubuntu) 2.38) #124~22.04.1-Ubuntu SMP PREEMPT_DYNAMIC Tue May 26 21:05:19 UTC