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

Crash while trying to find matching condition handler

    XMLWordPrintable

Details

    Description

      The following crash was noted while running MariaDB custom build from bb-10.2-compatibility branch (commit 565c1f592103f5bf40cfa2fbfa994fbe6339c208 tarbuildnum 17025):

      Thread pointer: 0x7f35980008c8
      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 = 0x7f36a5e33d70 thread_stack 0x40000
      (my_addr_resolve failure: fork)
      /usr/sbin/mysqld(my_print_stacktrace+0x2e) [0x55c5f7a7144e]
      /usr/sbin/mysqld(handle_fatal_signal+0x30d) [0x55c5f75006dd]
      /lib64/libpthread.so.0(+0xf5e0) [0x7f4bc33d25e0]
      /usr/sbin/mysqld(sp_pcontext::find_handler(Sql_condition_identity const&) const+0x1c) [0x55c5f72cb37c]
      /usr/sbin/mysqld(sp_rcontext::handle_sql_condition(THD*, unsigned int*, sp_instr const*)+0x413) [0x55c5f72cd243]
      /usr/sbin/mysqld(sp_head::execute(THD*, bool)+0x8f1) [0x55c5f72c1a51]
      /usr/sbin/mysqld(sp_head::execute_procedure(THD*, List<Item>*)+0x737) [0x55c5f72c2a77]
      /usr/sbin/mysqld(+0x55a48b) [0x55c5f733d48b]
      /usr/sbin/mysqld(+0x55c286) [0x55c5f733f286]
      /usr/sbin/mysqld(Sql_cmd_call::execute(THD*)+0x90) [0x55c5f733fa80]
      /usr/sbin/mysqld(mysql_execute_command(THD*)+0x134d) [0x55c5f73453dd]
      /usr/sbin/mysqld(sp_instr_stmt::exec_core(THD*, unsigned int*)+0x36) [0x55c5f72bdca6]
      /usr/sbin/mysqld(sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*)+0x99) [0x55c5f72c58e9]
      /usr/sbin/mysqld(sp_instr_stmt::execute(THD*, unsigned int*)+0x205) [0x55c5f72c5ee5]
      /usr/sbin/mysqld(sp_head::execute(THD*, bool)+0x7ee) [0x55c5f72c194e]
      /usr/sbin/mysqld(sp_head::execute_procedure(THD*, List<Item>*)+0x737) [0x55c5f72c2a77]
      /usr/sbin/mysqld(+0x55a48b) [0x55c5f733d48b]
      /usr/sbin/mysqld(+0x55c286) [0x55c5f733f286]
      /usr/sbin/mysqld(Sql_cmd_call::execute(THD*)+0x90) [0x55c5f733fa80]
      /usr/sbin/mysqld(mysql_execute_command(THD*)+0x134d) [0x55c5f73453dd]
      /usr/sbin/mysqld(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool)+0x2fe) [0x55c5f734d0fe]
      /usr/sbin/mysqld(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool)+0x2025) [0x55c5f7350085]
      /usr/sbin/mysqld(do_command(THD*)+0x149) [0x55c5f7350c89]
      /usr/sbin/mysqld(do_handle_one_connection(CONNECT*)+0x1aa) [0x55c5f74155aa]
      /usr/sbin/mysqld(handle_one_connection+0x3d) [0x55c5f74156cd]
      /lib64/libpthread.so.0(+0x7e25) [0x7f4bc33cae25]
      /lib64/libc.so.6(clone+0x6d) [0x7f4bc1a1d34d]
       
       
      Trying to get some variables.
      Some pointers may be invalid and cause the dump to abort.
      Query (0x7f359a3565e8): p_l_c( NAME_CONST('p_BusinessDate',TIMESTAMP'2017-11-25 17:38:35'))
      Connection ID (thread ID): 78710
      Status: NOT_KILLED
      

      It is not clear how to reproduce, code of p_l_c() procedure (name changed) and several other related stored procedures can not be shared here.

      Attachments

        Issue Links

          Activity

            People

              bar Alexander Barkov
              valerii Valerii Kravchuk
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.