Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.3.14, 10.3.18, 10.4.8
-
None
-
Centos 7.6
Description
We are getting the following error whenever the insert query get executed in slave.
191014 15:57:21 [ERROR] mysqld got signal 11 ;
|
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.3.13-MariaDB-log
|
key_buffer_size=1073741824
|
read_buffer_size=524288000
|
max_used_connections=3
|
max_threads=153
|
thread_count=12
|
It is possible that mysqld could use up to
|
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 239820094 K bytes of memory
|
Hope that's ok; if not, decrease some variables in the equation.
|
|
Thread pointer: 0x7f88e40012a8
|
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 = 0x7f9c240cf5d0 thread_stack 0x49000
|
/usr/local/mariadb/bin/mysqld(my_print_stacktrace+0x2e)[0x5617cb4ff1be]
|
/usr/local/mariadb/bin/mysqld(handle_fatal_signal+0x357)[0x5617cafa26e7]
|
/lib64/libpthread.so.0(+0xf5d0)[0x7f9c296925d0]
|
/lib64/libc.so.6(+0x14d814)[0x7f9c28dfa814]
|
/usr/local/mariadb/bin/mysqld(insert_dynamic+0x2a)[0x5617cb4d716a]
|
/usr/local/mariadb/bin/mysqld(+0x7f2035)[0x5617cb016035]
|
/usr/local/mariadb/bin/mysqld(_ZN22Item_func_get_user_var18fix_length_and_decEv+0x49)[0x5617cb016569]
|
/usr/local/mariadb/bin/mysqld(_ZN9Item_func10fix_fieldsEP3THDPP4Item+0x15c)[0x5617cb00bf7c]
|
mysys/array.c:103(insert_dynamic)[0x5617cb00bf5f]
|
sql/item_func.cc:5422(get_var_with_binlog(THD*, enum_sql_command, st_mysql_const_lex_string*, user_var_entry**))[0x5617cb0358d2]
|
sql/item_func.cc:5448(Item_func_get_user_var::fix_length_and_dec())[0x5617cb00bf5f]
|
sql/item_strfunc.cc:111(Item_str_func::fix_fields(THD*, Item**))[0x5617cb0167b8]
|
sql/item_func.cc:363(Item_func::fix_fields(THD*, Item**))[0x5617cad25f98]
|
sql/set_var.cc:874(set_var_user::check(THD*))[0x5617cad27d39]
|
sql/set_var.cc:733(sql_set_variables(THD*, List<set_var_base>*, bool))[0x5617cadd0310]
|
sql/sql_parse.cc:5141(mysql_execute_command(THD*))[0x5617cad396d5]
|
sql/sp_head.cc:3596(sp_instr_stmt::exec_core(THD*, unsigned int*))[0x5617cad41139]
|
sql/sp_head.cc:3322(sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*))[0x5617cad41b7b]
|
sql/sp_head.cc:3501(sp_instr_stmt::execute(THD*, unsigned int*))[0x5617cad3d050]
|
sql/sp_head.cc:1356(sp_head::execute(THD*, bool))[0x5617cad3ebba]
|
sql/sp_head.cc:2014(sp_head::execute_function(THD*, Item**, unsigned int, Field*, sp_rcontext**, Query_arena*))[0x5617cafbf698]
|
sql/item.cc:3004(Item_sp::execute_impl(THD*, Item**, unsigned int))[0x5617cafbf8e1]
|
sql/item.cc:2912(Item_sp::execute(THD*, bool*, Item**, unsigned int))[0x5617cb022948]
|
sql/item_func.h:2915(Item_func_sp::val_str(String*))[0x5617cafd5b8d]
|
sql/item_cmpfunc.cc:762(Arg_comparator::compare_string())[0x5617cafd663a]
|
sql/item_cmpfunc.cc:1729(Item_func_eq::val_int())[0x5617caef2970]
|
sql/sql_type.cc:3211(Type_handler_int_result::Item_val_bool(Item*) const)[0x5617cafd40fa]
|
sql/item_cmpfunc.cc:5038(Item_cond_and::val_int())[0x5617caef2970]
|
sql/sql_type.cc:3211(Type_handler_int_result::Item_val_bool(Item*) const)[0x5617cafd5c2d]
|
sql/item_cmpfunc.cc:2891(Item_func_case_searched::find_item())[0x5617cafd34c6]
|
sql/item_cmpfunc.cc:2926(Item_func_case::str_op(String*))[0x5617cafc4d01]
|
sql/item.cc:6815(Item::save_str_in_field(Field*, bool))[0x5617cafb66b6]
|
sql/item.cc:6864(Item::save_in_field(Field*, bool))[0x5617cad79288]
|
sql/sql_base.cc:8567(fill_record(THD*, TABLE*, Field**, List<Item>&, bool, bool))[0x5617cae640db]
|
sql/sql_union.cc:128(select_unit::send_data(List<Item>&))[0x5617cae13fdf]
|
sql/sql_select.cc:20579(end_send(JOIN*, st_join_table*, bool))[0x5617cae029d8]
|
sql/sql_select.cc:19441(sub_select(JOIN*, st_join_table*, bool))[0x5617cadf893c]
|
sql/sql_class.h:3872(THD::get_stmt_da())[0x5617cae026de]
|
sql/sql_select.cc:19403(sub_select(JOIN*, st_join_table*, bool))[0x5617cadf893c]
|
sql/sql_class.h:3872(THD::get_stmt_da())[0x5617cae026de]
|
sql/sql_select.cc:19403(sub_select(JOIN*, st_join_table*, bool))[0x5617cadf893c]
|
sql/sql_class.h:3872(THD::get_stmt_da())[0x5617cae026de]
|
sql/sql_select.cc:19403(sub_select(JOIN*, st_join_table*, bool))[0x5617cadf893c]
|
sql/sql_class.h:3872(THD::get_stmt_da())[0x5617cae026de]
|
sql/sql_select.cc:19403(sub_select(JOIN*, st_join_table*, bool))[0x5617cadf893c]
|
sql/sql_class.h:3872(THD::get_stmt_da())[0x5617cae0273c]
|
sql/sql_select.cc:19403(sub_select(JOIN*, st_join_table*, bool))[0x5617cadf893c]
|
sql/sql_class.h:3872(THD::get_stmt_da())[0x5617cae026de]
|
sql/sql_select.cc:19403(sub_select(JOIN*, st_join_table*, bool))[0x5617cadf893c]
|
sql/sql_class.h:3872(THD::get_stmt_da())[0x5617cae0273c]
|
sql/sql_select.cc:19403(sub_select(JOIN*, st_join_table*, bool))[0x5617cae23e5b]
|
sql/sql_select.cc:18936(do_select)[0x5617cae24073]
|
sql/sql_select.cc:3835(JOIN::exec())[0x5617cae666d4]
|
sql/sql_union.cc:1470(st_select_lex_unit::exec())[0x5617cae69172]
|
sql/sql_union.cc:41(mysql_union(THD*, LEX*, select_result*, st_select_lex_unit*, unsigned long))[0x5617cae24b75]
|
sql/sql_class.h:3862(handle_select(THD*, LEX*, select_result*, unsigned long))[0x5617cadd19bd]
|
sql/sql_parse.cc:4837(mysql_execute_command(THD*))[0x5617cadd349c]
|
sql/sql_parse.cc:8095(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x5617cb09e42a]
|
sql/log_event.cc:5681(Query_log_event::do_apply_event(rpl_group_info*, char const*, unsigned int))[0x5617cad29ea3]
|
sql/log_event.h:1483(Log_event::apply_event(rpl_group_info*))[0x5617cad336db]
|
/lib64/libpthread.so.0(+0x7dd5)[0x7f9c2968add5]
|
/lib64/libc.so.6(clone+0x6d)[0x7f9c28daaead]
|
|
Trying to get some variables.
|
Some pointers may be invalid and cause the dump to abort.
|
Query (0x7f88e47537e0): SET @V_Communication_Channel_R = concat(@V_Email,@V_SMS,@V_PN,@V_WhatsApp)
|
Connection ID (thread ID): 16
|
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=off,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=on,split_materialized=on
|
|
The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
|
information that should help you find out what is causing the crash.
|