Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.6, 10.11, 11.4, 11.8, 12.3
-
None
-
Q3/2026 Server Maintenance
Description
Customer's MariaDB server crashed.
Possible query
(gdb) print thd->query_string
|
$1 = {string = {str = 0x7f67fd1a5a10 "select * from performance_schema.status_by_thread order by thread_id, variable_name", length = 83}, cs = 0x5598635b45c0 <my_charset_utf8mb3_general_ci>}
|
Backtrace
(gdb) bt
|
#0 0x00007f77ca8b5aa1 in pthread_kill () from /tmp/epsqndbp01/tmp/crash_bundle/lib64/libpthread.so.0
|
#1 0x000055986248fe7e in handle_fatal_signal (sig=6) at /home/jenkins/workspace/Build-Package/build/sqlsignal_handler.cc:357
|
#2 <signal handler called>
|
#3 0x00007f77c9d04387 in raise () from /tmp/epsqndbp01/tmp/crash_bundle/lib64/libc.so.6
|
#4 0x00007f77c9d05a78 in abort () from /tmp/epsqndbp01/tmp/crash_bundle/lib64/libc.so.6
|
#5 0x00007f77c9cfd1a6 in __assert_fail_base () from /tmp/epsqndbp01/tmp/crash_bundle/lib64/libc.so.6
|
#6 0x00007f77c9cfd252 in __assert_fail () from /tmp/epsqndbp01/tmp/crash_bundle/lib64/libc.so.6
|
#7 0x000055986270c2ff in PFS_table_context::initialize (this=0x7f7771dd72e8) at /home/jenkins/workspace/Build-Package/build/storage/perfschema/pfs_engine_table.cc:161
|
#8 0x00005598627510bd in table_status_by_thread_context::table_status_by_thread_context (restore=<optimized out>, current_version=7, this=<optimized out>) at /home/jenkins/workspace/Build-Package/build/storage/perfschema/table_status_by_thread.h:94
|
#9 table_status_by_thread::rnd_init (this=0x7f77705c6a40, scan=<optimized out>) at /home/jenkins/workspace/Build-Package/build/storage/perfschema/table_status_by_thread.cc:120
|
#10 0x00005598626f7ce6 in ha_perfschema::rnd_init (this=0x7f636de49ca0, scan=<optimized out>) at /home/jenkins/workspace/Build-Package/build/storage/perfschema/ha_perfschema.cc:332
|
#11 0x0000559862498cd7 in handler::ha_rnd_init (scan=scan@entry=false, this=0x7f636de49ca0) at /home/jenkins/workspace/Build-Package/build/sql/handler.h:3537
|
#12 handler::ha_rnd_init_with_error (this=0x7f636de49ca0, scan=scan@entry=false) at /home/jenkins/workspace/Build-Package/build/sql/handler.cc:3745
|
#13 0x00005598625e61d7 in init_read_record (info=info@entry=0x7f67fd1a8e70, thd=<optimized out>, table=0x7f636de46c78, select=0x0, filesort=0x7f77700127f0, use_record_cache=use_record_cache@entry=1, print_error=<optimized out>, print_error@entry=true, disable_rr_cache=<optimized out>, disable_rr_cache@entry=false) at /home/jenkins/workspace/Build-Package/build/sql/records.cc:245
|
#14 0x0000559862293e76 in join_init_read_record (tab=0x7f67fd1a8d98) at /home/jenkins/workspace/Build-Package/build/sql/sql_select.cc:23011
|
#15 0x0000559862288d22 in sub_select (join=0x7f67fd1a7528, join_tab=0x7f67fd1a8d98, end_of_records=<optimized out>) at /home/jenkins/workspace/Build-Package/build/sql/sql_select.cc:21989
|
#16 0x00005598622b9bb7 in do_select (procedure=<optimized out>, join=0x7f67fd1a7528) at /home/jenkins/workspace/Build-Package/build/sql/sql_select.cc:21515
|
#17 JOIN::exec_inner (this=this@entry=0x7f67fd1a7528) at /home/jenkins/workspace/Build-Package/build/sql/sql_select.cc:4934
|
#18 0x00005598622b9ef9 in JOIN::exec (this=this@entry=0x7f67fd1a7528) at /home/jenkins/workspace/Build-Package/build/sql/sql_select.cc:4712
|
#19 0x00005598622b8089 in mysql_select (thd=thd@entry=0x7f67fe260808, tables=0x7f67fd1a6188, fields=..., conds=0x0, og_num=2, order=0x7f67fd1a7230, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=result@entry=0x7f67fd1a7500, unit=unit@entry=0x7f67fe264a10, select_lex=select_lex@entry=0x7f67fd1a5b10) at /home/jenkins/workspace/Build-Package/build/sql/sql_select.cc:5248
|
#20 0x00005598622b8934 in handle_select (thd=thd@entry=0x7f67fe260808, lex=lex@entry=0x7f67fe264948, result=result@entry=0x7f67fd1a7500, setup_tables_done_option=setup_tables_done_option@entry=0) at /home/jenkins/workspace/Build-Package/build/sql/sql_select.cc:573
|
#21 0x00005598620f7b37 in execute_sqlcom_select (thd=thd@entry=0x7f67fe260808, all_tables=0x7f67fd1a6188) at /home/jenkins/workspace/Build-Package/build/sql/sql_parse.cc:6405
|
#22 0x000055986224bccf in mysql_execute_command (thd=thd@entry=0x7f67fe260808, is_called_from_prepared_stmt=is_called_from_prepared_stmt@entry=false) at /home/jenkins/workspace/Build-Package/build/sql/sql_parse.cc:4001
|
#23 0x000055986224e16b in mysql_parse (thd=thd@entry=0x7f67fe260808, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x7f66b1be0280) at /home/jenkins/workspace/Build-Package/build/sql/sql_parse.cc:8173
|
#24 0x00005598622504a9 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x7f67fe260808, packet=packet@entry=0x7f67fe43cf89 "", packet_length=packet_length@entry=83, blocking=blocking@entry=false) at /home/jenkins/workspace/Build-Package/build/sql/sql_parse.cc:1903
|
#25 0x0000559862251b1e in do_command (thd=thd@entry=0x7f67fe260808, blocking=blocking@entry=false) at /home/jenkins/workspace/Build-Package/build/sql/sql_parse.cc:1417
|
#26 0x0000559862412ec1 in threadpool_process_request (thd=0x7f67fe260808) at /home/jenkins/workspace/Build-Package/build/sql/threadpool_common.cc:436
|
#27 tp_callback (c=0x559866449f60) at /home/jenkins/workspace/Build-Package/build/sql/threadpool_common.cc:250
|
#28 0x000055986261fdb0 in worker_main (param=param@entry=0x5598662b44a8) at /home/jenkins/workspace/Build-Package/build/sql/threadpool_generic.cc:1578
|
#29 0x00005598626fecac in pfs_spawn_thread (arg=0x7f680af5e108) at /home/jenkins/workspace/Build-Package/build/storage/perfschema/pfs.cc:2201
|
#30 0x00007f77ca8b0ea5 in start_thread () from /tmp/epsqndbp01/tmp/crash_bundle/lib64/libpthread.so.0
|
#31 0x00007f77c9dccb0d in clone () from /tmp/epsqndbp01/tmp/crash_bundle/lib64/libc.so.6
|
The error logs are not available.
I've tried to reproduce the issue by running sysbench and running a select on table
performance_schema.status_by_thread
|
simultaneously but no luck.
It looks similar to MDEV-33031.
But since that's closed I am not sure if it is related or not.
