210813 4:47:36 [ERROR] mysqld got signal 6 ; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. To report this bug, see https://mariadb.com/kb/en/reporting-bugs We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. Server version: 10.5.9-MariaDB-debug 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 = 467968 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x62b0000af288 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 = 0x7f025bbff580 thread_stack 0x5fc00 /usr/local/mysql/bin/mariadbd(__interceptor_backtrace+0x5b)[0x8dd7db] :0(_mi_get_pack_key)[0x870c377] sql/item_windowfunc.h:636(Item_sum_cume_dist::reset_field())[0x33ede22] sigaction.c:0(__restore_rt)[0x7f02871233c0] ??:0(gsignal)[0x7f02862bf18b] ??:0(abort)[0x7f028629e859] /lib/x86_64-linux-gnu/libc.so.6(+0x25729)[0x7f028629e729] ??:0(__assert_fail)[0x7f02862aff36] sql/sql_repl.cc:4319(show_binlogs_get_fields(THD*, List*))[0x1c675f9] ??:0(st_select_lex::build_pushable_cond_for_having_pushdown(THD*, Item*))[0x18c8fbc] ??:0(Lex_trim_st::make_item_func_trim_std(THD*) const)[0x18a88ee] ??:0(LEX::make_item_func_substr(THD*, Item*, Item*))[0x18a5a5d] sql_select.cc:0(create_hj_key_for_table(JOIN*, st_join_table*, keyuse_t*, unsigned long long))[0x202872a] sql_db.cc:0(mysql_rm_db_internal(THD*, st_mysql_const_lex_string const*, bool, bool))[0x1639dff] sql/sql_class.cc:5886(start_new_trans)[0x15a9fad] ??:0(open_purge_table(THD*, char const*, unsigned long, char const*, unsigned long))[0x1591329] sql/sql_class.cc:6284(THD::decide_logging_format(TABLE_LIST*))[0x15b2502] ??:0(TABLE_SHARE::init_from_binary_frm_image(THD*, bool, unsigned char const*, unsigned long, unsigned char const*, unsigned long))[0x262b03d] ??:0(TABLE_SHARE::init_from_binary_frm_image(THD*, bool, unsigned char const*, unsigned long, unsigned char const*, unsigned long))[0x26294fd] :0(maria_repair)[0x5608773] nptl/pthread_create.c:478(start_thread)[0x7f0287117609] ??:0(clone)[0x7f028639b293] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0x7f026510f8a8): create table t_lzzzzz as select case when (select c_l2iidekuu from t_yqc order by c_l2iidekuu limit 1 offset 1) < ( select ref_1.c_l1awww as c0 from t_yqc as ref_1 where ref_0.c2 is not NULL union select (select c_l2iidekuu from t_yqc order by c_l2iidekuu limit 1 offset 2) as c0 from t_t1wbg as ref_2 where EXISTS ( select (select c1 from t_t1wbg order by c1 limit 1 offset 3) as c0, (select c1 from t_t1wbg order by c1 limit 1 offset 3) as c1, (select c1 from t_t1wbg order by c1 limit 1 offset 3) as c2, (select c1 from t_t1wbg order by c1 limit 1 offset 3) as c3, (select c1 from t_t1wbg order by c1 limit 1 offset 3) as c4, (select c1 from t_t1wbg order by c1 limit 1 offset 3) as c5, (select c3 from t_t1wbg order by c3 limit 1 offset 2) as c6 from t_t1wbg as ref_3 where (select c_l2iidekuu from t_yqc order by c_l2iidekuu limit 1 offset 4) > (select count(c_wzidrf) from t_yqc) AND (((((((((((((((((((((((((((((((((((((((((((((((((((0<>0)) or (1=1 AND 0<>0)) or (1=1)) or ((select c_l2iidekuu from t_yqc order by c_l2iidekuu limit 1 offset 3) = (select count(c_l2iidekuu) from t_yqc) )) or (1=1)) or (ref_2.c2 not like 'dg_mtmf3')) or ((select c_l2iidekuu from t_yqc order by c_l2iidekuu limit 1 offset 5) >= 27)) or ((select count(c_l2iidekuu) from t_yqc) <> (select c_l2iidekuu from t_yqc order by c_l2iidekuu limit 1 offset 5) )) or ((select c_l2iidekuu from t_yqc order by c_l2iidekuu limit 1 offset 2) <> (select c_l2iidekuu from t_yqc order by c_l2iidekuu limit 1 offset 2) )) or (0<>0)) or (66 >= (select count(c_l2iidekuu) from t_yqc) )) or (0<>0)) or (1=1)) or ((0<>0) or ((select c_l2iidekuu from t_yqc order by c_l2iidekuu limit 1 offset 3) = (select c_l2iidekuu from t_yqc order by c_l2iidekuu limit 1 offset 2) ))) or (1=1)) or (ref_2.c3 >= ( select ref_0.c0 as c0 from t_yqc as ref_4 where ref_4.c_l1awww = ref_4.c_l1awww))) or ((select c_l2iidekuu from t_yqc order by c_l2iidekuu limit 1 offset 2) > (select c_l2iidekuu from t_yqc order by c_l2iidekuu limit 1 offset 3) )) or (1=1)) or (1=1)) or (0<>0)) or (ref_2.c3 not in ( select ref_5.c3 as c0 from t_t1wbg as ref_5 where ref_5.c2 in ( select ref_6.c0 as c0 from t_t1wbg as ref_6 where 0<>0 window z20j6 as ( partition by ref_6.c0 order by ref_6.c0 desc) order by c0 desc) union select ref_7.c_www7ttttt as c0 from t_yqc as ref_7 where 1=1))) or (0<>0)) or ((select c_l2iidekuu from t_yqc order by c_l2iidekuu limit 1 offset 2) >= (select c_l2iidekuu from t_yqc order by c_l2iidekuu limit 1 offset 1) AND 1=1)) or (1=1)) or ((select c_l2iidekuu from t_yqc order by c_l2iidekuu limit 1 offset 4) <> (select count(c_wzidrf) from t_yqc) )) or (EXISTS ( select ref_8.c_l2iidekuu as c0, ref_8.c_l2iidekuu as c1, ref_8.c_wzidrf as c2, ref_2.c0 as c3, (select c_l2iidekuu from t_yqc order by c_l2iidekuu limit 1 offset 1) as c4, ref_3.c2 as c5, ref_3.c1 as c6 from t_yqc as ref_8 where ref_8.c_lu3elqgz <> ref_8.c_m window ikwsvx5 as ( partition by ref_2.c3 order by (select c_wzidrf from t_yqc order by c_wzidrf limit 1 offset 3) desc) limit 24))) or (1=1)) or (1=1)) or (1=1)) or ((1=1) or (ref_0.c3 not like '_'))) or ((select count(c_l2iidekuu) from t_yqc) between (select c_l2iidekuu from t_yqc order by c_l2iidekuu limit 1 offset 3) and (select c_l2iidekuu from t_yqc order by c_l2iidekuu limit 1 offset 3) )) or (EXISTS ( select (select c1 from t_t1wbg order by c1 limit 1 offset 2) as c0, ref_0.c1 as c1, ref_9.c1 as c2, ref_3.c3 as c3, ref_9.c3 as c4, ref_9.c3 as c5 from t_t1wbg as ref_9 where 1=1 limit 170) AND (select c_l2iidekuu from t_yqc order by c_l2iidekuu limit 1 offset 2) <> (select c_l2iidekuu from t_yqc order by c_l2iidekuu limit 1 offset 4) AND EXISTS ( select ref_2.c3 as c0, ref_10.c2 as c1, (select c_wwwwwwwww from t_yqc order by c_wwwwwwwww limit 1 offset 2) as c2, (select c_m from t_yqc order by c_m limit 1 offset 2) as c3, (select c_l from t_yqc order by c_l limit 1 offset 2) as c4, ref_10.c2 as c5, ref_2.c3 as c6, ref_3.c0 as c7 from t_t1wbg as ref_10 where 0<>0) AND 1=1 AND ((select count(c_l2iidekuu) from t_yqc) <> (select count(c_wzidrf) from t_yqc) ) and (1=1) AND 0<>0 AND (select c_l2iidekuu from t_yqc order by c_l2iidekuu limit 1 offset 3) = (select c_l2iidekuu from t_yqc order by c_l2iidekuu limit 1 offset 2) AND (0<>0) and ((select c_l2iidekuu from t_yqc order by c_l2iidekuu limit 1 offset 5) <= (select c_l2iidekuu from t_yqc order by c_l2iidekuu limit 1 offset 5) ) AND (select c_l2iidekuu from t_yqc order by c_l2iidekuu limit 1 offset 5) > (select c_l2iidekuu from t_yqc order by c_l2iidekuu limit 1 offset 3) AND 1=1 AND (select c_l2iidekuu from t_yqc order by c_l2iidekuu limit 1 offset 1) >= (select c_l2iidekuu from t_yqc order by c_l2iidekuu limit 1 offset 5) AND 0<>0 AND (select c_l2iidekuu from t_yqc order by c_l2iidekuu limit 1 offset 1) >= 85 AND EXISTS ( select (select c_l2iidekuu from t_yqc order by c_l2iidekuu limit 1 offset 1) as c0, ref_3.c2 as c1, ref_3.c1 as c2 from t_t1wbg as ref_11 where ref_3.c0 < ( select ref_11.c0 as c0 from t_t1wbg as ref_12 where 0<>0 union select ref_2.c3 as c0 from t_t1wbg as ref_13 where (select c_l2iidekuu from t_yqc order by c_l2iidekuu limit 1 offset 1) between (select c_l2iidekuu from t_yqc order by c_l2iidekuu limit 1 offset 2) and 56) window ikwsvx1 as ( partition by ref_3.c1 order by ref_3.c3 desc) order by c0, c1, c2 desc limit 194) AND ((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((1=1) or (1=1)) or ((1=1) or (1=1))) or (((1=1) or (1=1)) or ((1=1) or (1=1)))) or ((((1=1) or (1=1)) or ((1=1) or (1=1))) or (((1=1) or (1=1)) or ((1=1) or (1=1))))) or (((((1=1) or (1=1)) or ((1=1) or (1=1))) or (((1=1) or (1=1)) or ((1=1) or (1=1)))) or ((((1=1) or (1=1)) or ((1=1) or (1=1))) or (((1=1) or (1=1)) or ((1=1) or (1=1)))))) or ((((((1=1) or (1=1)) or ((1=1) or (1=1))) or (((1=1) or (1=1)) or ((1=1) or (1=1)))) or ((((1=1) or (1=1)) or ((1=1) or (1=1))) or (((1=1) or (1=1)) or ((1=1) or (1=1))))) or (((((1=1) or (1=1)) or ((1=1) or (1=1))) or (((1=1) or (1=1)) or ((1=1) or (1=1)))) or ((((1=1) or (1=1)) or ((1=1) or (1=1))) or (((1=1) or (1=1)) or ((1=1) or (1=1))))))) or (((((((1=1) or (1=1)) or ((1=1) or (1=1))) or (((1=1) or (1=1)) or ((1=1) or (1=1)))) or ((((1=1) or (1=1)) or ((1=1) or (1=1))) or (((1=1) or (1=1)) or ((1=1) or (1=1))))) or (((((1=1) or (1=1)) or ((1=1) or (1=1))) or (((1=1) or (1=1)) or ((1=1) or (1=1)))) or (0<>0))) or (ref_2.c3 >= ( select (select c0 from t_t1wbg order by c0 limit 1 offset 2) as c0 from t_yqc as ref_14 where 1=1 window d6 as ( partition by ref_0.c0 order by ref_0.c2 desc) union select ref_2.c3 as c0 from t_t1wbg as ref_15 where 1=1)))) or (1=1)) or (1=1)) or (1=1)) or (0<>0)) or (1=1)) or (ref_2.c2 not like 'dg_mtmf3')) or (1=1)) or (0<>0)) or (1=1)) or (1=1)) or (1=1)) or (ref_0.c0 >= ( select ref_3.c0 as c0 from t_t1wbg as ref_16 where 0<>0))) or (1=1)) or (1=1)) or (80 = (select min(c_l2iidekuu) from t_yqc) )) or (ref_2.c0 is not NULL AND (select c_l2iidekuu from t_yqc order by c_l2iidekuu limit 1 offset 1) >= (select max(c_l2iidekuu) from t_yqc) )) or ((0<>0) or (1=1))) or ((select c_l2iidekuu from t_yqc order by c_l2iidekuu limit 1 offset 5) >= (select c_l2iidekuu from t_yqc order by c_l2iidekuu limit 1 offset 2) )) or (1=1)) or (0<>0)) or (1=1)) or (1=1)) or (ref_2.c0 not in ( select ref_17.c3 as c0 from t_t1wbg as ref_17 where 0<>0 window atylc as ( partition by ref_17.c2 order by ref_17.c2 desc)))) or (0<>0)) or ((1=1) and ((select c_l2iidekuu from t_yqc order by c_l2iidekuu limit 1 offset 1) <= (select max(c_l2iidekuu) from t_yqc) ))) or (0<>0)) or (ref_2.c3 is NULL)) or (1=1)) or (0<>0)) or (1=1)) or (0<>0)) or (ref_0.c3 in ( select ref_18.c_wzidrf as c0 from t_yqc as ref_18 where ref_18.c_wzidrf is not NULL union all select distinct ref_19.c2 as c0 from t_t1wbg as ref_19 where ref_19.c1 is not NULL))) or (1=1)) or (1=1)) or (0<>0)) or (1=1)) or (ref_2.c0 > ( select (select c0 from t_t1wbg order by c0 limit 1 offset 5) as c0 from t_t1wbg as ref_20 where 1=1 union select ref_2.c0 as c0 from t_yqc as ref_21 where 0<>0))) or (75 > (select c_l2iidekuu from t_yqc order by c_l2iidekuu limit 1 offset 5) )) or (0<>0)) or (0<>0)) or (0<>0)) or ((select c_l2iidekuu from t_yqc order by c_l2iidekuu limit 1 offset 4) = (select c_l2iidekuu from t_yqc order by c_l2iidekuu limit 1 offset 5) )) or (ref_2.c5 not like 's%rr')) or ((select c1 from t_t1wbg order by c1 limit 1 offset 3) in ( select ref_22.c3 as c0 from t_t1wbg as ref_22 where ref_22.c3 like '%' AND 1=1 AND 4 <> 9 AND (80 <= 4) or (56 > 37) AND 1=1 AND (((((((0<>0) or (1=1)) or (1=1)) or (0<>0)) or (1=1)) or (1=1)) or (0<>0)) or (ref_22.c0 like 'rk%7bt') AND ref_22.c0 <> ( select distinct ref_23.c2 as c0 from t_t1wbg as ref_23 where 1=1 union all select ref_24.c_l as c0 from t_yqc as ref_24 where ref_22.c1 is NULL) AND 1=1 AND 0<>0 AND 1=1 AND 1=1 union select ref_25.c_www7ttttt as c0 from t_yqc as ref_25 where 1=1) AND 1=1 AND 1=1 AND ref_2.c3 is not NULL AND 85 between (select c_l2iidekuu from t_yqc order by c_l2iidekuu limit 1 offset 2) and (select c_l2iidekuu from t_yqc order by c_l2iidekuu limit 1 offset 1) )) or (1=1)) or (1=1)) or ((select c_l2iidekuu from t_yqc order by c_l2iidekuu limit 1 offset 4) <> (select count(c_wzidrf) from t_yqc) )) or (EXISTS ( select ref_26.c_l2iidekuu as c0, ref_26.c_l2iidekuu as c1, ref_26.c_wzidrf as c2, ref_2.c0 as c3, (select c_l2iidekuu from t_yqc order by c_l2iidekuu limit 1 offset 1) as c4, ref_3.c2 as c5, ref_3.c1 as c6 from t_yqc as ref_26 where ref_26.c_lu3elqgz <> ref_26.c_m window ikwsvx5 as ( partition by ref_2.c3 order by (select c_wzidrf from t_yqc order by c_wzidrf limit 1 offset 3) desc) limit 24))) or (1=1)) or (1=1)) or (1=1)) or ((select c_l2iidekuu from t_yqc order by c_l2iidekuu limit 1 offset 1) between (select c_l2iidekuu from t_yqc order by c_l2iidekuu limit 1 offset 3) and (select c_l2iidekuu from t_yqc order by c_l2iidekuu limit 1 offset 3) )) or (EXISTS ( select (select c1 from t_t1wbg order by c1 limit 1 offset 2) as c0, ref_0.c1 as c1, ref_27.c1 as c2, ref_3.c3 as c3, ref_27.c3 as c4, ref_27.c3 as c5 from t_t1wbg as ref_27 where 1=1 limit 170) AND (select c_l2iidekuu from t_yqc order by c_l2iidekuu limit 1 offset 2) <> (select c_l2iidekuu from t_yqc order by c_l2iidekuu limit 1 offset 4) AND EXISTS ( select ref_2.c3 as c0, ref_28.c2 as c1, (select c_wwwwwwwww from t_yqc order by c_wwwwwwwww limit 1 offset 2) as c2, (select c_m from t_yqc order by c_m limit 1 offset 2) as c3, (select c_l from t_yqc order by c_l limit 1 offset 2) as c4, ref_28.c2 as c5, ref_2.c3 as c6, Connection ID (thread ID): 15 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 The manual page at https://mariadb.com/kb/en/how-to-produce-a-full-stack-trace-for-mysqld/ contains information that should help you find out what is causing the crash. Writing a core file... Working directory at /usr/local/mysql/data Resource Limits: Limit Soft Limit Hard Limit Units Max cpu time unlimited unlimited seconds Max file size unlimited unlimited bytes Max data size unlimited unlimited bytes Max stack size 8388608 unlimited bytes Max core file size 0 unlimited bytes Max resident set unlimited unlimited bytes Max processes 79615 79615 processes Max open files 1048576 1048576 files Max locked memory 67108864 67108864 bytes Max address space unlimited unlimited bytes Max file locks unlimited unlimited locks Max pending signals 79615 79615 signals Max msgqueue size 819200 819200 bytes Max nice priority 0 0 Max realtime priority 0 0 Max realtime timeout unlimited unlimited us Core pattern: |/usr/share/apport/apport %p %s %c %d %P %E 210813 04:47:37 mysqld_safe Number of processes running now: 0 210813 04:47:37 mysqld_safe mysqld restarted