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

crash 11 during evaluating an expression

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Duplicate
    • Affects Version/s: 10.3
    • Fix Version/s: 10.2.14, 10.3.6
    • Component/s: Stored routines
    • Labels:
      None
    • Environment:
        MariaDB Enterprise 10.2.13 build 18409 bb_compatibility

      Description

      Crash happened during call a SP in oracle compatibility mode

      Error formatting macro: code: java.lang.StackOverflowError

      Server version: 10.2.13-MariaDB-log
      key_buffer_size=67108864
      read_buffer_size=131072
      max_used_connections=113
      max_threads=2002
      thread_count=120
      It is possible that mysqld could use up to
      key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 4465362 K bytes of memory
      Hope that's ok; if not, decrease some variables in the equation.

      Thread pointer: 0x561a47b90008
      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 = 0x7f3030fa2d00 thread_stack 0x40000
      (my_addr_resolve failure: fork)
      /usr/sbin/mysqld(my_print_stacktrace+0x2e) [0x56192e5813fe]
      /usr/sbin/mysqld(handle_fatal_signal+0x355) [0x56192e016fb5]
      /lib64/libpthread.so.0(+0xf5e0) [0x7f44cabac5e0]
      /usr/sbin/mysqld(THD::sp_eval_expr(Field*, Item**)+0x4b) [0x56192ddd3dcb]
      /usr/sbin/mysqld(sp_rcontext::set_variable(THD*, unsigned int, Item**)+0x23) [0x56192dde0f83]
      /usr/sbin/mysqld(sp_instr_set::exec_core(THD*, unsigned int*)+0x2f) [0x56192ddd9d3f]
      /usr/sbin/mysqld(sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*)+0x305) [0x56192ddd9835]
      /usr/sbin/mysqld(sp_head::execute(THD*, bool)+0x83e) [0x56192ddd562e]
      /usr/sbin/mysqld(sp_head::execute_procedure(THD*, List<Item>*)+0x73d) [0x56192ddd675d]
      /usr/sbin/mysqld(+0x55bbd9) [0x56192de51bd9]
      /usr/sbin/mysqld(+0x55d906) [0x56192de53906]
      /usr/sbin/mysqld(Sql_cmd_call::execute(THD*)+0x90) [0x56192de54100]
      /usr/sbin/mysqld(mysql_execute_command(THD*)+0x14fb) [0x56192de59c0b]
      /usr/sbin/mysqld(Prepared_statement::execute(String*, bool)+0x4de) [0x56192de741ee]
      /usr/sbin/mysqld(+0x57e39f) [0x56192de7439f]
      /usr/sbin/mysqld(+0x57f1ff) [0x56192de751ff]
      /usr/sbin/mysqld(mysqld_stmt_execute(THD*, char*, unsigned int)+0x27) [0x56192de75287]
      /usr/sbin/mysqld(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool)+0x14e8) [0x56192de63f48]
      /usr/sbin/mysqld(do_command(THD*)+0x149) [0x56192de657a9]
      /usr/sbin/mysqld(do_handle_one_connection(CONNECT*)+0x1aa) [0x56192df29eba]
      /usr/sbin/mysqld(handle_one_connection+0x3d) [0x56192df29fdd]
      /usr/sbin/mysqld(+0x8c59ed) [0x56192e1bb9ed]
      /lib64/libpthread.so.0(+0x7e25) [0x7f44caba4e25]
      /lib64/libc.so.6(clone+0x6d) [0x7f44c91f734d]

      Trying to get some variables.
      Some pointers may be invalid and cause the dump to abort.
      Query (0x561a567a0020): call PKG_CALCULATION.CALC_RUNNING_BALANCE_TXN('SG','ANSP','20280731','EODATD','201803121308168697','201803121309168754',NULL)
      Connection ID (thread ID): 518783
      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=on,mrr_cost_based=on,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=on,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=on,split_grouping_derived=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.
      Writing a core file at /mariadb/data/

      thread-apply output of the core is attached.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                sanja Oleksandr Byelkin
                Reporter:
                Richard Richard Stracke
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: