Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
10.5.11, 10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5, 10.6
-
CentOS 7
Description
Running a quite long CTE [over 170 lines] in a procedure suddenly crashes the server. It looks to me that it started with 10.5.11 as before i worked perfectly. Below the dump. For the moment I don't want to publish the CTE but I can do it privately.
Running the CTE command NOT in a stored procedure works so I have for the moment a work-around.
{{Server version: 10.5.11-MariaDB
key_buffer_size=134217728
read_buffer_size=131072
max_used_connections=2
max_threads=153
thread_count=2
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 467873 K bytes of memory
Hope that's ok; if not, decrease some variables in the equation.
Thread pointer: 0x7fdf0c0009b8
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
stack_bottom = 0x7fdf68117c90 thread_stack 0x49000
??:0(my_print_stacktrace)[0x559fcba7579e]
??:0(handle_fatal_signal)[0x559fcb47a457]
sigaction.c:0(__restore_rt)[0x7fdf81fa4630]
??:0(Item_cond_and::mark_as_condition_AND_part(TABLE_LIST*))[0x559fcb4b2d96]
??:0(setup_conds(THD*, TABLE_LIST*, List<TABLE_LIST>&, Item**))[0x559fcb20de29]
??:0(JOIN::prepare(TABLE_LIST*, Item*, unsigned int, st_order*, bool, st_order*, Item*, st_order*, st_select_lex*, st_select_lex_unit*))[0x559fcb2bedcf]
??:0(st_select_lex_unit::prepare_join(THD*, st_select_lex*, select_result*, unsigned long long, bool))[0x559fcb31b7ed]
??:0(st_select_lex_unit::prepare(TABLE_LIST*, select_result*, unsigned long long))[0x559fcb31fda6]
??:0(TABLE_LIST::find_derived_handler(THD*))[0x559fcb2335b2]
??:0(mysql_handle_single_derived(LEX*, TABLE_LIST*, unsigned int))[0x559fcb2325ad]
??:0(st_select_lex::handle_derived(LEX*, unsigned int))[0x559fcb24d3d7]
??:0(TABLE_LIST::handle_derived(LEX*, unsigned int))[0x559fcb335f06]
??:0(st_select_lex::handle_derived(LEX*, unsigned int))[0x559fcb24d3d7]
??:0(TABLE_LIST::handle_derived(LEX*, unsigned int))[0x559fcb335f06]
??:0(mysql_prepare_insert(THD*, TABLE_LIST*, List<Item>&, List<Item>, List<Item>&, List<Item>&, enum_duplicates, Item*, bool))[0x559fcb239bd2]
??:0(mysql_insert_select_prepare(THD*, select_result*))[0x559fcb23e216]
??:0(mysql_execute_command(THD*))[0x559fcb278900]
??:0(sp_instr_stmt::exec_core(THD*, unsigned int*))[0x559fcb1ce506]
??:0(sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*))[0x559fcb1d6fe2]
??:0(sp_instr_stmt::execute(THD*, unsigned int*))[0x559fcb1d79dc]
??:0(sp_head::execute(THD*, bool))[0x559fcb1d2524]
??:0(sp_head::execute_procedure(THD*, List<Item>*))[0x559fcb1d3c1f]
??:0(comp_ne_creator(bool))[0x559fcb26aaca]
??:0(Sql_cmd_call::execute(THD*))[0x559fcb26f48a]
??:0(mysql_execute_command(THD*))[0x559fcb2772be]
??:0(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x559fcb27b1c5]
??:0(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x559fcb27d891]
??:0(do_command(THD*))[0x559fcb27f03f]
??:0(do_handle_one_connection(CONNECT*, bool))[0x559fcb369b52]
??:0(handle_one_connection)[0x559fcb369e14]
??:0(MyCTX_nopad::finish(unsigned char*, unsigned int*))[0x559fcb6c756d]
pthread_create.c:0(start_thread)[0x7fdf81f9cea5]
??:0(__clone)[0x7fdf814b79fd]
}}
{{Connection ID (thread ID): 10
Status: NOT_KILLED
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}}
Attachments
Issue Links
- causes
-
MDEV-26202 Unexpected failure with query using indirectly a recursive CTE twice
- Closed
- relates to
-
MDEV-26108 Crash with query referencing twice CTE that uses embedded recursive CTE
- Closed
-
MDEV-26825 Bogus error for query with two usage of CTE referring another CTE
- Closed