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

MariaDB 10.11.13 crash got signal 11 during stored procedure call (nested)

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Blocker
    • Resolution: Duplicate
    • 10.11.13
    • N/A
    • Stored routines
    • None
    • Rocky Linux 9, Mariadb 10.11.13
    • Not for Release Notes

    Description

      We upgraded Mariadb from 10.5.18 to 10.11.13 about a month ago and since then we have been facing many mariadb crash issues one of which is given below.
      We are getting mariadb crash error with below log on nested stored procedure call for part when concat function is being used for dynamic parameters. A sample demo procedure and full stack trace has been attached herewith as well.

      Stack Trace:

      250722 6:07:22 [ERROR] /usr/local/mysql/bin/mariadbd got signal 11 ;
      Sorry, we probably made a mistake, and this is a bug.

      Your assistance in bug reporting will enable us to fix this for the next release.
      To report this bug, see https://mariadb.com/kb/en/reporting-bugs about how to report
      a bug on https://jira.mariadb.org/.

      Please include the information from the server start above, to the end of the
      information below.

      Server version: 10.11.13-MariaDB-log source revision: 8fb09426b98583916ccfd4f8c49741adc115bac3

      WSREP: Suppressing further logging
      WSREP: Shutting down network communications

      The information page at https://mariadb.com/kb/en/how-to-produce-a-full-stack-trace-for-mariadbd/
      contains instructions to obtain a better version of the backtrace below.
      Following these instructions will help MariaDB developers provide a fix quicker.

      Attempting backtrace. Include this in the bug report.
      (note: Retrieving this information may fail)

      Thread pointer: 0x7fbde82f4308
      stack_bottom = 0x7fbe480ed000 thread_stack 0x49000
      mysys/stacktrace.c:216(my_print_stacktrace)[0x55ebe5463ace]
      sql/signal_handler.cc:230(handle_fatal_signal)[0x55ebe4ead4df]
      2025-07-22 6:07:22 0 [Note] /usr/local/mysql/bin/mariadbd (initiated by: unknown): Normal shutdown
      2025-07-22 6:07:22 0 [Note] WSREP: Shutdown replication
      2025-07-22 6:07:22 0 [Note] WSREP: Server status change synced -> disconnecting
      2025-07-22 6:07:22 0 [Note] WSREP: Closing send monitor...
      2025-07-22 6:07:22 0 [Note] WSREP: Closed send monitor.
      2025-07-22 6:07:22 0 [Note] WSREP: gcomm: terminating thread
      2025-07-22 6:07:22 0 [Note] WSREP: gcomm: joining thread
      2025-07-22 6:07:22 0 [Note] WSREP: gcomm: closing backend
      2025-07-22 6:07:22 0 [Note] WSREP: (eab1e8e1-907d, 'tcp://0.0.0.0:4567') turning message relay requesting on, nonlive peers: tcp://x.x.x.x:4567 tcp://x.x.x.x:4567
      /lib64/libc.so.6(+0x3ebf0)[0x7fc96d63ebf0]
      sql/item.cc:2762(Type_std_attributes::agg_item_set_converter(DTCollation const&, st_mysql_const_lex_string const&, Item*, unsigned int, unsigned int, int, Type_std_attributes::Single_coll_err const))[0x55ebe4ed8fe2]
      2025-07-22 6:07:23 0 [Note] WSREP: Failed to establish connection: Operation aborted.
      sql/item_strfunc.cc:723(Item_func_concat::fix_length_and_dec(THD*))[0x55ebe4f5497a]
      sql/item_func.cc:381(Item_func::fix_fields(THD*, Item**))[0x55ebe4f1f9cf]
      sql/item_strfunc.cc:138(Item_str_func::fix_fields(THD*, Item**))[0x55ebe4f50472]
      sql/sp_head.cc:399(THD::sp_fix_func_item(Item**))[0x55ebe4bb9a4c]
      sql/sp_head.cc:429(THD::sp_fix_func_item_for_assignment(Field const*, Item**))[0x55ebe4bb9b52]
      sql/field.cc:1503(Field::sp_prepare_and_store_item(THD*, Item**))[0x55ebe4e8bc1e]
      sql/sql_class.h:8187(Sp_eval_expr_state::stop())[0x55ebe4bb9be8]
      sql/sp_rcontext.cc:641(sp_rcontext::set_variable(THD*, unsigned int, Item**))[0x55ebe4bc8063]
      sql/sp_rcontext.h:194(sp_rcontext::set_parameter(THD*, unsigned int, Item**))[0x55ebe4bbcb84]
      sql/sp_head.cc:2398(sp_head::execute_procedure(THD*, List<Item>*))[0x55ebe4bbd056]
      sql/sql_parse.cc:3092(do_execute_sp(THD*, sp_head*))[0x55ebe4c5b94a]
      sql/sql_parse.cc:3334(Sql_cmd_call::execute(THD*))[0x55ebe4c5dd4a]
      sql/sql_parse.cc:6167(mysql_execute_command(THD*, bool))[0x55ebe4c64e63]
      sql/sp_head.cc:3947(sp_instr_stmt::exec_core(THD*, unsigned int*))[0x55ebe4bb79c8]
      sql/sp_head.cc:3665(sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*))[0x55ebe4bc06e6]
      sql/sp_head.cc:3850(sp_instr_stmt::execute(THD*, unsigned int*))[0x55ebe4bc11a7]
      sql/sp_head.cc:1464(sp_head::execute(THD*, bool))[0x55ebe4bbba54]
      psi/mysql_sp.h:79(sp_head::execute_procedure(THD*, List<Item>*))[0x55ebe4bbd40f]
      sql/sql_parse.cc:3092(do_execute_sp(THD*, sp_head*))[0x55ebe4c5b94a]
      sql/sql_parse.cc:3334(Sql_cmd_call::execute(THD*))[0x55ebe4c5dd4a]
      sql/sql_parse.cc:6167(mysql_execute_command(THD*, bool))[0x55ebe4c64e63]
      sql/sp_head.cc:3947(sp_instr_stmt::exec_core(THD*, unsigned int*))[0x55ebe4bb79c8]
      sql/sp_head.cc:3665(sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*))[0x55ebe4bc06e6]
      sql/sp_head.cc:3850(sp_instr_stmt::execute(THD*, unsigned int*))[0x55ebe4bc11a7]
      sql/sp_head.cc:1464(sp_head::execute(THD*, bool))[0x55ebe4bbba54]
      psi/mysql_sp.h:79(inline_mysql_end_sp)[0x55ebe4bbd40f]
      sql/sql_parse.cc:3092(do_execute_sp(THD*, sp_head*))[0x55ebe4c5b94a]
      sql/sql_parse.cc:3334(Sql_cmd_call::execute(THD*))[0x55ebe4c5dd4a]
      sql/sql_parse.cc:6167(mysql_execute_command(THD*, bool))[0x55ebe4c64e63]
      sql/sql_parse.cc:8180(mysql_parse(THD*, char*, unsigned int, Parser_state*))[0x55ebe4c699db]
      sql/sql_class.h:4567(THD::get_stmt_da())[0x55ebe4c6a18a]
      sql/sql_parse.cc:1892(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool))[0x55ebe4c6c80a]
      sql/sql_parse.cc:1420(do_command(THD*, bool))[0x55ebe4c6d4ae]
      sql/threadpool_common.cc:438(tp_callback(TP_connection*))[0x55ebe4e2d491]
      2025-07-22 6:07:23 0 [Note] WSREP: Failed to establish connection: Operation aborted.
      sql/threadpool_generic.cc:1551(worker_main(void*))[0x55ebe5027b60]
      perfschema/pfs.cc:2204(pfs_spawn_thread)[0x55ebe51039c2]
      2025-07-22 6:07:23 0 [Note] WSREP: (eab1e8e1-907d, 'tcp://0.0.0.0:4567') reconnecting to ae57fe5d-80ad (tcp://x.x.x.x:4567), attempt 0
      2025-07-22 6:07:23 0 [Note] WSREP: (eab1e8e1-907d, 'tcp://0.0.0.0:4567') reconnecting to 93fa1ec6-a019 (tcp://x.x.x.x:4567), attempt 0
      /lib64/libc.so.6(+0x8a19a)[0x7fc96d68a19a]
      /lib64/libc.so.6(+0x10f210)[0x7fc96d70f210]

      Connection ID (thread ID): 83896
      Status: NOT_KILLED
      Query (0x7fbdde4942e0): CALL logExecutedQuery( NAME_CONST('logTable',_utf8mb3'test.test_engine' COLLATE 'utf8mb3_general_ci'), NAME_CONST('clientID',_utf8mb3'21' COLLATE 'utf8mb3_general_ci'), NAME_CONST('clientName',_utf8mb3'ims' COLLATE 'utf8mb3_general_ci'), 'getConfigurationParameterValue',CONCAT('get parameter value for ', NAME_CONST('configParam',_utf8mb3'UpdateTaskStatus' COLLATE 'utf8mb3_general_ci'),' from configuration table'),'SUCCESS',CONCAT('parameter ', NAME_CONST('configParam',_utf8mb3'UpdateTaskStatus' COLLATE 'utf8mb3_general_ci'),' , values : "',@checkParameterValue,'". '),0)

      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,orderby_uses_equalities=on,condition_pushdown_for_derived=on,split_materialized=on,condition_pushdown_for_subquery=off,rowid_filter=off,condition_pushdown_from_having=off,not_null_range_scan=off,hash_join_cardinality=off,cset_narrowing=off

      Writing a core file...
      Working directory at /data/mysql
      Resource Limits (excludes unlimited resources):
      Limit Soft Limit Hard Limit Units
      Max stack size 8388608 unlimited bytes
      Max processes 124225 124225 processes
      Max open files 65535 65535 files
      Max locked memory 8388608 8388608 bytes
      Max pending signals 124225 124225 signals
      Max msgqueue size 819200 819200 bytes
      Max nice priority 0 0
      Max realtime priority 0 0
      Core pattern: |/usr/lib/systemd/systemd-coredump %P %u %g %s %t %c %h

      Kernel version: Linux version 5.14.0-503.29.1.el9_5.x86_64 (mockbuild@iad1-prod-build001.bld.equ.rockylinux.org) (gcc (GCC) 11.5.0 20240719 (Red Hat 11.5.0-5), GNU ld version 2.35.2-54.el9) #1 SMP PREEMPT_DYNAMIC Wed Mar 5 20:42:50 UTC 2025

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              techgeek tech geek
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.