Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-14228

MariaDB crashes with function

    XMLWordPrintable

    Details

      Description

      171016 19:22:54 [ERROR] mysqld got signal 11 ;
      Thread pointer: 0x7fbe940008c8
      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 = 0x7fbf9ac6ed70 thread_stack 0x40000
      (my_addr_resolve failure: fork)
      /usr/sbin/mysqld(my_print_stacktrace+0x2e) [0x562e645ba80e]
      /usr/sbin/mysqld(handle_fatal_signal+0x30d) [0x562e640495cd]
      /lib64/libpthread.so.0(+0xf5e0) [0x7fcb411805e0]
      /usr/sbin/mysqld(Arg_comparator::set_cmp_func(Item_func_or_sum*, Item**, Item**)+0x3d) [0x562e64080a9d]
      /usr/sbin/mysqld(Arg_comparator::set_cmp_func_for_row_arguments()+0x1af) [0x562e640812ef]
      /usr/sbin/mysqld(Arg_comparator::set_cmp_func(Item_func_or_sum*, Item**, Item**)+0x8a) [0x562e64080aea]
      /usr/sbin/mysqld(Item_func::setup_args_and_comparator(THD*, Arg_comparator*)+0x61) [0x562e64080b61]
      /usr/sbin/mysqld(Item_func::fix_fields(THD*, Item**)+0x152) [0x562e640aeb52]
      /usr/sbin/mysqld(Item_cond::fix_fields(THD*, Item**)+0x108) [0x562e6407c158]
      /usr/sbin/mysqld(Item_cond::fix_fields(THD*, Item**)+0x108) [0x562e6407c158]
      /usr/sbin/mysqld(sp_prepare_func_item(THD*, Item**, unsigned int)+0x94) [0x562e63e0b9d4]
      /usr/sbin/mysqld(sp_instr_jump_if_not::exec_core(THD*, unsigned int*)+0x1e) [0x562e63e0ba0e]
      /usr/sbin/mysqld(sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*)+0x325) [0x562e63e113a5]
      /usr/sbin/mysqld(sp_head::execute(THD*, bool)+0x7ee) [0x562e63e0d37e]
      /usr/sbin/mysqld(sp_head::execute_function(THD*, Item**, unsigned int, Field*)+0x67f) [0x562e63e0ed1f]
      /usr/sbin/mysqld(Item_func_sp::execute_impl(THD*)+0xfd) [0x562e640bb2ed]
      /usr/sbin/mysqld(Item_func_sp::execute()+0x2c) [0x562e640bb3fc]
      /usr/sbin/mysqld(Item_func_sp::val_str(String*)+0x58) [0x562e640c4768]
      /usr/sbin/mysqld(Type_handler::Item_send_str(Item*, Protocol*, st_value*) const+0x1c) [0x562e63faf86c]
      /usr/sbin/mysqld(Protocol::send_result_set_row(List<Item>*)+0x13f) [0x562e63df0e5f]
      /usr/sbin/mysqld(select_send::send_data(List<Item>&)+0x53) [0x562e63e58a63]
      /usr/sbin/mysqld(JOIN::exec_inner()+0xaa4) [0x562e63ee3e94]
      /usr/sbin/mysqld(JOIN::exec()+0x33) [0x562e63ee4043]
      /usr/sbin/mysqld(mysql_select(THD*, TABLE_LIST*, unsigned int, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*)+0x11a) [0x562e63ee419a]
      /usr/sbin/mysqld(handle_select(THD*, LEX*, select_result*, unsigned long)+0x15e) [0x562e63ee4bfe]
      /usr/sbin/mysqld(+0x475855) [0x562e63db0855]
      /usr/sbin/mysqld(mysql_execute_command(THD*)+0x6933) [0x562e63e93a63]
      /usr/sbin/mysqld(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool)+0x392) [0x562e63e969a2]
      /usr/sbin/mysqld(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool)+0x295d) [0x562e63e9a41d]
      /usr/sbin/mysqld(do_command(THD*)+0x149) [0x562e63e9b149]
      /usr/sbin/mysqld(do_handle_one_connection(CONNECT*)+0x1aa) [0x562e63f5f29a]
      /usr/sbin/mysqld(handle_one_connection+0x3d) [0x562e63f5f3bd]
      /lib64/libpthread.so.0(+0x7e25) [0x7fcb41178e25]
      /lib64/libc.so.6(clone+0x6d) [0x7fcb3f7cb34d]
       
      Trying to get some variables.
      Some pointers may be invalid and cause the dump to abort.
      Query (0x7fbe9400fd40): select function_name()
      Connection ID (thread ID): 26257
      Status: NOT_KILLED
      

      After that, it crashes one after another (two times more) and we can see this in error log.

      stack_bottom = 0x7ff76c0fcd70 thread_stack 0x40000
      *** buffer overflow detected ***: /usr/sbin/mysqld terminated
      

      That function details and error logs are attached with support ticket.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              bar Alexander Barkov
              Reporter:
              niljoshi Nilnandan Joshi
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Git Integration