Details
-
Bug
-
Status: Closed (View Workflow)
-
Blocker
-
Resolution: Duplicate
-
10.11.13
-
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
- duplicates
-
MDEV-36814 MariaDB 10.11.9 Signal 11 crash on second Stored Procedure call
-
- Closed
-