Sep 1 08:37:46 db-10 mysqld: 160901 8:37:46 [ERROR] mysqld got signal 11 ; Sep 1 08:37:46 db-10 mysqld: This could be because you hit a bug. It is also possible that this binary Sep 1 08:37:46 db-10 mysqld: or one of the libraries it was linked against is corrupt, improperly built, Sep 1 08:37:46 db-10 mysqld: or misconfigured. This error can also be caused by malfunctioning hardware. Sep 1 08:37:46 db-10 mysqld: Sep 1 08:37:46 db-10 mysqld: To report this bug, see http://kb.askmonty.org/en/reporting-bugs Sep 1 08:37:46 db-10 mysqld: Sep 1 08:37:46 db-10 mysqld: We will try our best to scrape up some info that will hopefully help Sep 1 08:37:46 db-10 mysqld: diagnose the problem, but since we have already crashed, Sep 1 08:37:46 db-10 mysqld: something is definitely wrong and this may fail. Sep 1 08:37:46 db-10 mysqld: Sep 1 08:37:46 db-10 mysqld: Server version: 10.1.12-MariaDB-1~trusty Sep 1 08:37:46 db-10 mysqld: key_buffer_size=134217728 Sep 1 08:37:46 db-10 mysqld: read_buffer_size=2097152 Sep 1 08:37:46 db-10 mysqld: max_used_connections=70 Sep 1 08:37:46 db-10 mysqld: max_threads=102 Sep 1 08:37:46 db-10 mysqld: thread_count=49 Sep 1 08:37:46 db-10 mysqld: It is possible that mysqld could use up to Sep 1 08:37:46 db-10 mysqld: key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 759828 K bytes of memory Sep 1 08:37:46 db-10 mysqld: Hope that's ok; if not, decrease some variables in the equation. Sep 1 08:37:46 db-10 mysqld: Sep 1 08:37:46 db-10 mysqld: Thread pointer: 0x0x7fa5c4250008 Sep 1 08:37:46 db-10 mysqld: Attempting backtrace. You can use the following information to find out Sep 1 08:37:46 db-10 mysqld: where mysqld died. If you see no messages after this, something went Sep 1 08:37:46 db-10 mysqld: terribly wrong... Sep 1 08:37:46 db-10 mysqld: stack_bottom = 0x7fb0d10941f0 thread_stack 0x48400 Sep 1 08:37:46 db-10 mysqld: (my_addr_resolve failure: fork) Sep 1 08:37:46 db-10 mysqld: /usr/sbin/mysqld(my_print_stacktrace+0x2e) [0x7fb0d3e1105e] Sep 1 08:37:46 db-10 mysqld: /usr/sbin/mysqld(handle_fatal_signal+0x38d) [0x7fb0d393e1bd] Sep 1 08:37:46 db-10 mysqld: /lib/x86_64-linux-gnu/libpthread.so.0(+0x10340) [0x7fb0d1e95340] Sep 1 08:37:46 db-10 mysqld: /usr/sbin/mysqld(Arg_comparator::compare_int_signed()+0x55) [0x7fb0d3965d85] Sep 1 08:37:46 db-10 mysqld: /usr/sbin/mysqld(Item_func_eq::val_int()+0x2a) [0x7fb0d396945a] Sep 1 08:37:46 db-10 mysqld: /usr/sbin/mysqld(Item::val_bool()+0x9c) [0x7fb0d394eecc] Sep 1 08:37:46 db-10 mysqld: /usr/sbin/mysqld(Item_func_if::str_op(String*)+0x26) [0x7fb0d39664f6] Sep 1 08:37:46 db-10 mysqld: /usr/sbin/mysqld(Item_func_hybrid_field_type::val_str(String*)+0x100) [0x7fb0d3999d60] Sep 1 08:37:46 db-10 mysqld: /usr/sbin/mysqld(Item_copy_string::copy()+0x21) [0x7fb0d394d121] Sep 1 08:37:46 db-10 mysqld: /usr/sbin/mysqld(copy_fields(TMP_TABLE_PARAM*)+0x49) [0x7fb0d38070a9] Sep 1 08:37:46 db-10 mysqld: /usr/sbin/mysqld(end_send_group(JOIN*, st_join_table*, bool)+0x15e) [0x7fb0d380a50e] Sep 1 08:37:46 db-10 mysqld: /usr/sbin/mysqld(+0x460ce5) [0x7fb0d37eece5] Sep 1 08:37:46 db-10 mysqld: /usr/sbin/mysqld(sub_select(JOIN*, st_join_table*, bool)+0x17e) [0x7fb0d37f73ee] Sep 1 08:37:46 db-10 mysqld: /usr/sbin/mysqld(+0x460ce5) [0x7fb0d37eece5] Sep 1 08:37:46 db-10 mysqld: /usr/sbin/mysqld(sub_select(JOIN*, st_join_table*, bool)+0x17e) [0x7fb0d37f73ee] Sep 1 08:37:46 db-10 mysqld: /usr/sbin/mysqld(+0x460ce5) [0x7fb0d37eece5] Sep 1 08:37:46 db-10 mysqld: /usr/sbin/mysqld(sub_select(JOIN*, st_join_table*, bool)+0x17e) [0x7fb0d37f73ee] Sep 1 08:37:46 db-10 mysqld: /usr/sbin/mysqld(+0x460ce5) [0x7fb0d37eece5] Sep 1 08:37:46 db-10 mysqld: /usr/sbin/mysqld(sub_select(JOIN*, st_join_table*, bool)+0x17e) [0x7fb0d37f73ee] Sep 1 08:37:46 db-10 mysqld: /usr/sbin/mysqld(+0x460ce5) [0x7fb0d37eece5] Sep 1 08:37:46 db-10 mysqld: /usr/sbin/mysqld(sub_select(JOIN*, st_join_table*, bool)+0x17e) [0x7fb0d37f73ee] Sep 1 08:37:46 db-10 mysqld: /usr/sbin/mysqld(+0x460ce5) [0x7fb0d37eece5] Sep 1 08:37:46 db-10 mysqld: /usr/sbin/mysqld(sub_select(JOIN*, st_join_table*, bool)+0x1c4) [0x7fb0d37f7434] Sep 1 08:37:46 db-10 mysqld: /usr/sbin/mysqld(+0x460ce5) [0x7fb0d37eece5] Sep 1 08:37:46 db-10 mysqld: /usr/sbin/mysqld(sub_select(JOIN*, st_join_table*, bool)+0x17e) [0x7fb0d37f73ee] Sep 1 08:37:46 db-10 mysqld: /usr/sbin/mysqld(+0x460ce5) [0x7fb0d37eece5] Sep 1 08:37:46 db-10 mysqld: /usr/sbin/mysqld(sub_select(JOIN*, st_join_table*, bool)+0x17e) [0x7fb0d37f73ee] Sep 1 08:37:46 db-10 mysqld: /usr/sbin/mysqld(+0x460ce5) [0x7fb0d37eece5] Sep 1 08:37:46 db-10 mysqld: /usr/sbin/mysqld(sub_select(JOIN*, st_join_table*, bool)+0x17e) [0x7fb0d37f73ee] Sep 1 08:37:46 db-10 mysqld: /usr/sbin/mysqld(sub_select(JOIN*, st_join_table*, bool)+0x479) [0x7fb0d37f76e9] Sep 1 08:37:46 db-10 mysqld: /usr/sbin/mysqld(sub_select(JOIN*, st_join_table*, bool)+0x479) [0x7fb0d37f76e9] Sep 1 08:37:46 db-10 mysqld: /usr/sbin/mysqld(+0x460ce5) [0x7fb0d37eece5] Sep 1 08:37:46 db-10 mysqld: /usr/sbin/mysqld(sub_select(JOIN*, st_join_table*, bool)+0x17e) [0x7fb0d37f73ee] Sep 1 08:37:46 db-10 mysqld: /usr/sbin/mysqld(sub_select(JOIN*, st_join_table*, bool)+0x479) [0x7fb0d37f76e9] Sep 1 08:37:46 db-10 mysqld: /usr/sbin/mysqld(sub_select(JOIN*, st_join_table*, bool)+0x479) [0x7fb0d37f76e9] Sep 1 08:37:46 db-10 mysqld: /usr/sbin/mysqld(+0x460ce5) [0x7fb0d37eece5] Sep 1 08:37:46 db-10 mysqld: /usr/sbin/mysqld(sub_select(JOIN*, st_join_table*, bool)+0x17e) [0x7fb0d37f73ee] Sep 1 08:37:46 db-10 mysqld: /usr/sbin/mysqld(+0x476fed) [0x7fb0d3804fed] Sep 1 08:37:46 db-10 mysqld: /usr/sbin/mysqld(JOIN::exec_inner()+0xb4c) [0x7fb0d3814cec] Sep 1 08:37:46 db-10 mysqld: /usr/sbin/mysqld(JOIN::exec()+0x54) [0x7fb0d3816ce4] Sep 1 08:37:46 db-10 mysqld: /usr/sbin/mysqld(mysql_select(THD*, Item***, TABLE_LIST*, unsigned int, List&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*)+0x112) [0x7fb0d3813392] Sep 1 08:37:46 db-10 mysqld: /usr/sbin/mysqld(mysql_derived_fill(THD*, LEX*, TABLE_LIST*)+0x11b) [0x7fb0d379b86b] Sep 1 08:37:46 db-10 mysqld: /usr/sbin/mysqld(mysql_handle_single_derived(LEX*, TABLE_LIST*, unsigned int)+0xe4) [0x7fb0d379cb74] Sep 1 08:37:46 db-10 mysqld: /usr/sbin/mysqld(st_join_table::preread_init()+0xcf) [0x7fb0d37f70df] Sep 1 08:37:46 db-10 mysqld: /usr/sbin/mysqld(sub_select(JOIN*, st_join_table*, bool)+0x2f8) [0x7fb0d37f7568] Sep 1 08:37:46 db-10 mysqld: /usr/sbin/mysqld(+0x476fed) [0x7fb0d3804fed] Sep 1 08:37:46 db-10 mysqld: /usr/sbin/mysqld(JOIN::exec_inner()+0xb4c) [0x7fb0d3814cec] Sep 1 08:37:46 db-10 mysqld: /usr/sbin/mysqld(JOIN::exec()+0x54) [0x7fb0d3816ce4] Sep 1 08:37:46 db-10 mysqld: /usr/sbin/mysqld(mysql_select(THD*, Item***, TABLE_LIST*, unsigned int, List&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*)+0x112) [0x7fb0d3813392] Sep 1 08:37:46 db-10 mysqld: /usr/sbin/mysqld(handle_select(THD*, LEX*, select_result*, unsigned long)+0x245) [0x7fb0d3813e75] Sep 1 08:37:46 db-10 mysqld: /usr/sbin/mysqld(+0x428351) [0x7fb0d37b6351] Sep 1 08:37:46 db-10 mysqld: /usr/sbin/mysqld(mysql_execute_command(THD*)+0x61e4) [0x7fb0d37c2854] Sep 1 08:37:46 db-10 mysqld: /usr/sbin/mysqld(sp_instr_stmt::exec_core(THD*, unsigned int*)+0x15) [0x7fb0d3a4a7c5] Sep 1 08:37:46 db-10 mysqld: /usr/sbin/mysqld(sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*)+0x83) [0x7fb0d3a51373] Sep 1 08:37:46 db-10 mysqld: /usr/sbin/mysqld(sp_instr_stmt::execute(THD*, unsigned int*)+0x204) [0x7fb0d3a51924] Sep 1 08:37:46 db-10 mysqld: /usr/sbin/mysqld(sp_head::execute(THD*, bool)+0x786) [0x7fb0d3a4d7f6] Sep 1 08:37:46 db-10 mysqld: /usr/sbin/mysqld(sp_head::execute_procedure(THD*, List*)+0x617) [0x7fb0d3a4eea7] Sep 1 08:37:46 db-10 mysqld: /usr/sbin/mysqld(mysql_execute_command(THD*)+0x6889) [0x7fb0d37c2ef9] Sep 1 08:37:46 db-10 mysqld: /usr/sbin/mysqld(mysql_parse(THD*, char*, unsigned int, Parser_state*)+0x26d) [0x7fb0d37c5fed] Sep 1 08:37:46 db-10 mysqld: /usr/sbin/mysqld(dispatch_command(enum_server_command, THD*, char*, unsigned int)+0x2460) [0x7fb0d37c9330] Sep 1 08:37:46 db-10 mysqld: /usr/sbin/mysqld(do_command(THD*)+0x169) [0x7fb0d37c9ae9] Sep 1 08:37:46 db-10 mysqld: /usr/sbin/mysqld(do_handle_one_connection(THD*)+0x18a) [0x7fb0d388d0fa] Sep 1 08:37:46 db-10 mysqld: /usr/sbin/mysqld(handle_one_connection+0x40) [0x7fb0d388d2d0] Sep 1 08:37:46 db-10 mysqld: /lib/x86_64-linux-gnu/libpthread.so.0(+0x8182) [0x7fb0d1e8d182] Sep 1 08:37:46 db-10 mysqld: /lib/x86_64-linux-gnu/libc.so.6(clone+0x6d) [0x7fb0d15b047d] Sep 1 08:37:46 db-10 mysqld: Sep 1 08:37:46 db-10 mysqld: Trying to get some variables. Sep 1 08:37:46 db-10 mysqld: Some pointers may be invalid and cause the dump to abort. Sep 1 08:37:46 db-10 mysqld: Query (0x7fa3222c1020): is an invalid pointer Sep 1 08:37:46 db-10 mysqld: Connection ID (thread ID): 164362 Sep 1 08:37:46 db-10 mysqld: Status: NOT_KILLED Sep 1 08:37:46 db-10 mysqld: Sep 1 08:37:46 db-10 mysqld: 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 Sep 1 08:37:46 db-10 mysqld: Sep 1 08:37:46 db-10 mysqld: The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains Sep 1 08:37:46 db-10 mysqld: information that should help you find out what is causing the crash. Sep 1 08:37:46 db-10 mysqld_safe: Number of processes running now: 0 Sep 1 08:37:46 db-10 mysqld_safe: mysqld restarted Sep 1 08:37:46 db-10 mysqld: 2016-09-01 8:37:46 140357241124800 [Note] /usr/sbin/mysqld (mysqld 10.1.12-MariaDB-1~trusty) starting as process 133467 ...