Sep 29 13:32:24 db-10 mysqld: 160929 13:32:24 [ERROR] mysqld got signal 11 ; Sep 29 13:32:24 db-10 mysqld: This could be because you hit a bug. It is also possible that this binary Sep 29 13:32:24 db-10 mysqld: or one of the libraries it was linked against is corrupt, improperly built, Sep 29 13:32:24 db-10 mysqld: or misconfigured. This error can also be caused by malfunctioning hardware. Sep 29 13:32:24 db-10 mysqld: Sep 29 13:32:24 db-10 mysqld: To report this bug, see http://kb.askmonty.org/en/reporting-bugs Sep 29 13:32:24 db-10 mysqld: Sep 29 13:32:24 db-10 mysqld: We will try our best to scrape up some info that will hopefully help Sep 29 13:32:24 db-10 mysqld: diagnose the problem, but since we have already crashed, Sep 29 13:32:24 db-10 mysqld: something is definitely wrong and this may fail. Sep 29 13:32:24 db-10 mysqld: Sep 29 13:32:24 db-10 mysqld: Server version: 10.1.12-MariaDB-1~trusty Sep 29 13:32:24 db-10 mysqld: key_buffer_size=134217728 Sep 29 13:32:24 db-10 mysqld: read_buffer_size=2097152 Sep 29 13:32:24 db-10 mysqld: max_used_connections=81 Sep 29 13:32:24 db-10 mysqld: max_threads=102 Sep 29 13:32:24 db-10 mysqld: thread_count=60 Sep 29 13:32:24 db-10 mysqld: It is possible that mysqld could use up to Sep 29 13:32:24 db-10 mysqld: key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 759828 K bytes of memory Sep 29 13:32:24 db-10 mysqld: Hope that's ok; if not, decrease some variables in the equation. Sep 29 13:32:24 db-10 mysqld: Sep 29 13:32:24 db-10 mysqld: Thread pointer: 0x0x7f9b6d881008 Sep 29 13:32:24 db-10 mysqld: Attempting backtrace. You can use the following information to find out Sep 29 13:32:24 db-10 mysqld: where mysqld died. If you see no messages after this, something went Sep 29 13:32:24 db-10 mysqld: terribly wrong... Sep 29 13:32:24 db-10 mysqld: stack_bottom = 0x7f9c90b601f0 thread_stack 0x48400 Sep 29 13:32:24 db-10 mysqld: (my_addr_resolve failure: fork) Sep 29 13:32:24 db-10 mysqld: /usr/sbin/mysqld(my_print_stacktrace+0x2e) [0x7fa77714105e] Sep 29 13:32:24 db-10 mysqld: /usr/sbin/mysqld(handle_fatal_signal+0x38d) [0x7fa776c6e1bd] Sep 29 13:32:24 db-10 mysqld: /lib/x86_64-linux-gnu/libpthread.so.0(+0x10340) [0x7fa7751c5340] Sep 29 13:32:24 db-10 mysqld: /usr/sbin/mysqld(find_field_in_table(THD*, TABLE*, char const*, unsigned int, bool, unsigned int*)+0x91) [0x7fa776aad9e1] Sep 29 13:32:24 db-10 mysqld: /usr/sbin/mysqld(find_field_in_table_ref(THD*, TABLE_LIST*, char const*, unsigned int, char const*, char const*, char const*, Item**, bool, bool, unsigned int*, bool, TABLE_LIST**)+0x878) [0x7fa776aae468] Sep 29 13:32:24 db-10 mysqld: /usr/sbin/mysqld(find_field_in_tables(THD*, Item_ident*, TABLE_LIST*, TABLE_LIST*, Item**, find_item_error_report_type, bool, bool)+0x2d8) [0x7fa776aae9a8] Sep 29 13:32:24 db-10 mysqld: /usr/sbin/mysqld(Item_field::fix_fields(THD*, Item**)+0x332) [0x7fa776c8d642] Sep 29 13:32:24 db-10 mysqld: /usr/sbin/mysqld(Item_func::fix_fields(THD*, Item**)+0x19f) [0x7fa776cc868f] Sep 29 13:32:24 db-10 mysqld: /usr/sbin/mysqld(Item_cond::fix_fields(THD*, Item**)+0xb9) [0x7fa776c9e259] Sep 29 13:32:24 db-10 mysqld: /usr/sbin/mysqld(setup_on_expr(THD*, TABLE_LIST*, bool)+0x91) [0x7fa776ab0a41] Sep 29 13:32:24 db-10 mysqld: /usr/sbin/mysqld(setup_conds(THD*, TABLE_LIST*, List&, Item**)+0x1ba) [0x7fa776ab0d7a] Sep 29 13:32:24 db-10 mysqld: /usr/sbin/mysqld(JOIN::prepare(Item***, TABLE_LIST*, unsigned int, Item*, unsigned int, st_order*, bool, st_order*, Item*, st_order*, st_select_lex*, st_select_lex_unit*)+0x3c4) [0x7fa776b38964] Sep 29 13:32:24 db-10 mysqld: /usr/sbin/mysqld(st_select_lex_unit::prepare(THD*, select_result*, unsigned long)+0x968) [0x7fa776b85788] Sep 29 13:32:24 db-10 mysqld: /usr/sbin/mysqld(mysql_derived_prepare(THD*, LEX*, TABLE_LIST*)+0x1ff) [0x7fa776acbccf] Sep 29 13:32:24 db-10 mysqld: /usr/sbin/mysqld(mysql_handle_derived(LEX*, unsigned int)+0x226) [0x7fa776acc7f6] Sep 29 13:32:24 db-10 mysqld: /usr/sbin/mysqld(open_normal_and_derived_tables(THD*, TABLE_LIST*, unsigned int, unsigned int)+0x94) [0x7fa776aad934] Sep 29 13:32:24 db-10 mysqld: /usr/sbin/mysqld(+0x48b8de) [0x7fa776b498de] Sep 29 13:32:24 db-10 mysqld: /usr/sbin/mysqld(get_all_tables(THD*, TABLE_LIST*, Item*)+0x7eb) [0x7fa776b5cb2b] Sep 29 13:32:24 db-10 mysqld: /usr/sbin/mysqld(get_schema_tables_result(JOIN*, enum_schema_table_state)+0x28e) [0x7fa776b5e22e] Sep 29 13:32:24 db-10 mysqld: /usr/sbin/mysqld(JOIN::exec_inner()+0x6bd) [0x7fa776b4485d] Sep 29 13:32:24 db-10 mysqld: /usr/sbin/mysqld(JOIN::exec()+0x54) [0x7fa776b46ce4] Sep 29 13:32:24 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) [0x7fa776b43392] Sep 29 13:32:24 db-10 mysqld: /usr/sbin/mysqld(handle_select(THD*, LEX*, select_result*, unsigned long)+0x245) [0x7fa776b43e75] Sep 29 13:32:24 db-10 mysqld: /usr/sbin/mysqld(+0x428351) [0x7fa776ae6351] Sep 29 13:32:24 db-10 mysqld: /usr/sbin/mysqld(mysql_execute_command(THD*)+0x61e4) [0x7fa776af2854] Sep 29 13:32:24 db-10 mysqld: /usr/sbin/mysqld(mysql_parse(THD*, char*, unsigned int, Parser_state*)+0x26d) [0x7fa776af5fed] Sep 29 13:32:24 db-10 mysqld: /usr/sbin/mysqld(dispatch_command(enum_server_command, THD*, char*, unsigned int)+0x2460) [0x7fa776af9330] Sep 29 13:32:24 db-10 mysqld: /usr/sbin/mysqld(do_command(THD*)+0x169) [0x7fa776af9ae9] Sep 29 13:32:24 db-10 mysqld: /usr/sbin/mysqld(do_handle_one_connection(THD*)+0x18a) [0x7fa776bbd0fa] Sep 29 13:32:24 db-10 mysqld: /usr/sbin/mysqld(handle_one_connection+0x40) [0x7fa776bbd2d0] Sep 29 13:32:24 db-10 mysqld: /lib/x86_64-linux-gnu/libpthread.so.0(+0x8182) [0x7fa7751bd182] Sep 29 13:32:24 db-10 mysqld: /lib/x86_64-linux-gnu/libc.so.6(clone+0x6d) [0x7fa7748e047d] Sep 29 13:32:24 db-10 mysqld: Sep 29 13:32:24 db-10 mysqld: Trying to get some variables. Sep 29 13:32:24 db-10 mysqld: Some pointers may be invalid and cause the dump to abort. Sep 29 13:32:24 db-10 mysqld: Query (0x7f9c7fc20020): is an invalid pointer Sep 29 13:32:24 db-10 mysqld: Connection ID (thread ID): 603738 Sep 29 13:32:24 db-10 mysqld: Status: NOT_KILLED Sep 29 13:32:24 db-10 mysqld: Sep 29 13:32:24 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