Details
-
Bug
-
Status: In Review (View Workflow)
-
Critical
-
Resolution: Unresolved
-
10.11, 11.4, 11.8, 12.3, 13.0, 13.1
-
Can result in hang or crash
Description
Testcase is CLI/MTR Compatible
--source include/have_innodb.inc
|
CREATE TABLE t (a INT) ENGINE=InnoDB; |
UPDATE mysql.innodb_index_stats SET stat_value=18446744073709551615; |
RENAME TABLE t TO t2; |
SELECT * FROM t2; |
Leads to:
|
CS 10.11.19 aba2caa893cdfa880dbb9a4f2d8e6dfaa7ed8ebe (Optimized, Clang 22.1.8-20260621) Build 10/08/2026 |
InnoDB: Failing assertion: stat_value != UINT64_UNDEFINED
|
|
CS 10.11.19 aba2caa893cdfa880dbb9a4f2d8e6dfaa7ed8ebe (Optimized, Clang 22.1.8-20260621) Build 10/08/2026 |
Core was generated by `/test/MD100826-mariadb-10.11.19-linux-x86_64-opt/bin/mariadbd --no-defaults --l'.
|
Program terminated with signal SIGABRT, Aborted.
|
#0 __pthread_kill_implementation (no_tid=0, signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:44
|
 |
[Current thread is 1 (LWP 508330)]
|
(gdb) bt
|
#0 __pthread_kill_implementation (no_tid=0, signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:44
|
#1 __pthread_kill_internal (signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:78
|
#2 __GI___pthread_kill (threadid=<optimized out>, signo=signo@entry=6)at ./nptl/pthread_kill.c:89
|
#3 0x000077c7b344527e in __GI_raise (sig=sig@entry=6)at ../sysdeps/posix/raise.c:26
|
#4 0x000077c7b34288ff in __GI_abort () at ./stdlib/abort.c:79
|
#5 0x00005e75fb47fe61 in ut_dbg_assertion_failed (expr=0x5e75fbf2408d "stat_value != UINT64_UNDEFINED", file=0x5e75fbf23358 "/test/10.11_opt/storage/innobase/dict/dict0stats.cc", line=3303) at /test/10.11_opt/storage/innobase/ut/ut0dbg.cc:60
|
#6 0x00005e75fbbdedd0 in dict_stats_fetch_index_stats_step (node_void=<optimized out>, arg_void=0x77c7aa4f7d80)at /test/10.11_opt/storage/innobase/dict/dict0stats.cc:3303
|
#7 0x00005e75fbb5599d in fetch_step (thr=thr@entry=0x6fc6d0063e90)at /test/10.11_opt/storage/innobase/row/row0sel.cc:2478
|
#8 0x00005e75fbb17c80 in que_thr_step (thr=0x6fc6d0063e90)at /test/10.11_opt/storage/innobase/que/que0que.cc:537
|
#9 que_run_threads_low (thr=0x6fc6d0063e90)at /test/10.11_opt/storage/innobase/que/que0que.cc:609
|
#10 que_run_threads (thr=0x6fc6d0063e90)at /test/10.11_opt/storage/innobase/que/que0que.cc:629
|
#11 0x00005e75fbbde31c in dict_stats_fetch_from_ps (table=<optimized out>)at /test/10.11_opt/storage/innobase/dict/dict0stats.cc:3553
|
#12 0x00005e75fba92c4a in ha_innobase::statistics_init (this=this@entry=0x6fc6d005dad8, table=table@entry=0x5e75ff94e400, recalc=false) at /test/10.11_opt/storage/innobase/handler/ha_innodb.cc:5755
|
#13 0x00005e75fb4be3a8 in ha_innobase::info_low (this=this@entry=0x6fc6d005dad8, flag=flag@entry=282, is_analyze=false)at /test/10.11_opt/storage/innobase/handler/ha_innodb.cc:14842
|
#14 0x00005e75fba93418 in ha_innobase::info (this=0x6fc6d005dad8, flag=282)at /test/10.11_opt/storage/innobase/handler/ha_innodb.cc:15130
|
#15 ha_innobase::open (this=0x6fc6d005dad8, name=<optimized out>)at /test/10.11_opt/storage/innobase/handler/ha_innodb.cc:6043
|
#16 0x00005e75fb7f0c33 in handler::ha_open (this=0x6fc6d005dad8, table_arg=table_arg@entry=0x6fc6d005bd28, name=0x6fc6d005a1d8 "./test/t2", mode=2, test_if_locked=18, mem_root=mem_root@entry=0x0, partitions_to_open=0x0) at /test/10.11_opt/sql/handler.cc:3578
|
#17 0x00005e75fb6a22d8 in open_table_from_share (thd=thd@entry=0x6fc6d0000c68, share=share@entry=0x6fc6d0059d40, alias=alias@entry=0x6fc6d00113c0, db_stat=db_stat@entry=33, prgflag=prgflag@entry=8, ha_open_flags=<optimized out>, outparam=0x6fc6d005bd28, is_create_table=<optimized out>, partitions_to_open=0x0)at /test/10.11_opt/sql/table.cc:4497
|
#18 0x00005e75fb555e32 in open_table (thd=thd@entry=0x6fc6d0000c68, table_list=table_list@entry=0x6fc6d0011370, ot_ctx=ot_ctx@entry=0x77c7aa4f9a00) at /test/10.11_opt/sql/sql_base.cc:2291
|
#19 0x00005e75fb558979 in open_and_process_table (thd=0x6fc6d0000c68, tables=0x6fc6d0011370, counter=0x77c7aa4f9b1c, flags=0, prelocking_strategy=0x77c7aa4f9b80, ot_ctx=0x77c7aa4f9a00, has_prelocking_list=<optimized out>)at /test/10.11_opt/sql/sql_base.cc:4262
|
#20 open_tables (thd=thd@entry=0x6fc6d0000c68, options=@0x6fc6d0006500: {m_options = DDL_options_st::OPT_NONE}, start=start@entry=0x77c7aa4f9b10, counter=counter@entry=0x77c7aa4f9b1c, flags=flags@entry=0, prelocking_strategy=prelocking_strategy@entry=0x77c7aa4f9b80)at /test/10.11_opt/sql/sql_base.cc:4747
|
#21 0x00005e75fb55a224 in open_and_lock_tables (thd=0x7bbd7, thd@entry=0x6fc6d0000c68, options=<error reading variable: Cannot access memory at address 0x7c1aa>, tables=0x6fc6d0011370, derived=true, flags=454, flags@entry=0, prelocking_strategy=0x0, prelocking_strategy@entry=0x77c7aa4f9b80)at /test/10.11_opt/sql/sql_base.cc:5774
|
#22 0x00005e75fb5c5271 in open_and_lock_tables (thd=0x6fc6d0000c68, tables=0x6fc6d0011370, derived=true, flags=0)at /test/10.11_opt/sql/sql_base.h:519
|
#23 execute_sqlcom_select (thd=thd@entry=0x6fc6d0000c68, all_tables=0x6fc6d0011370) at /test/10.11_opt/sql/sql_parse.cc:6367
|
#24 0x00005e75fb5c004b in mysql_execute_command (thd=thd@entry=0x6fc6d0000c68, is_called_from_prepared_stmt=false)at /test/10.11_opt/sql/sql_parse.cc:4032
|
#25 0x00005e75fb5bb8fd in mysql_parse (thd=thd@entry=0x6fc6d0000c68, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x77c7aa4fa560)at /test/10.11_opt/sql/sql_parse.cc:8204
|
#26 0x00005e75fb5ba030 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x6fc6d0000c68, packet=packet@entry=0x6fc6d0008749 "SELECT * FROM t2", packet_length=packet_length@entry=16, blocking=true)at /test/10.11_opt/sql/sql_parse.cc:1924
|
#27 0x00005e75fb5bbd80 in do_command (thd=thd@entry=0x6fc6d0000c68, blocking=true) at /test/10.11_opt/sql/sql_parse.cc:1434
|
#28 0x00005e75fb6d48dd in do_handle_one_connection (connect=<optimized out>, connect@entry=0x5e75ff9c1e18, put_in_cache=true)at /test/10.11_opt/sql/sql_connect.cc:1486
|
#29 0x00005e75fb6d4706 in handle_one_connection (arg=arg@entry=0x5e75ff9c1e18)at /test/10.11_opt/sql/sql_connect.cc:1398
|
#30 0x00005e75fba0d38e in pfs_spawn_thread (arg=0x5e75ff94e398)at /test/10.11_opt/storage/perfschema/pfs.cc:2201
|
#31 0x000077c7b349cb84 in start_thread (arg=<optimized out>)at ./nptl/pthread_create.c:447
|
#32 0x000077c7b3529d6c in clone3 ()at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:78
|
|
CS 10.11.19 aba2caa893cdfa880dbb9a4f2d8e6dfaa7ed8ebe (Debug, Clang 22.1.8-20260621) Build 10/08/2026 |
InnoDB: Failing assertion: stat_value != UINT64_UNDEFINED
|
|
CS 10.11.19 aba2caa893cdfa880dbb9a4f2d8e6dfaa7ed8ebe (Debug, Clang 22.1.8-20260621) Build 10/08/2026 |
Core was generated by `/test/MD100826-mariadb-10.11.19-linux-x86_64-dbg/bin/mariadbd --no-defaults --l'.
|
Program terminated with signal SIGABRT, Aborted.
|
#0 __pthread_kill_implementation (no_tid=0, signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:44
|
 |
[Current thread is 1 (LWP 508270)]
|
(gdb) bt
|
#0 __pthread_kill_implementation (no_tid=0, signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:44
|
#1 __pthread_kill_internal (signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:78
|
#2 __GI___pthread_kill (threadid=<optimized out>, signo=signo@entry=6)at ./nptl/pthread_kill.c:89
|
#3 0x0000774c4a24527e in __GI_raise (sig=sig@entry=6)at ../sysdeps/posix/raise.c:26
|
#4 0x0000774c4a2288ff in __GI_abort () at ./stdlib/abort.c:79
|
#5 0x00005fe719c7ae4d in ut_dbg_assertion_failed (expr=0x5fe71a27f452 "stat_value != UINT64_UNDEFINED", file=0x5fe71a27daa1 "/test/10.11_dbg/storage/innobase/dict/dict0stats.cc", line=3303) at /test/10.11_dbg/storage/innobase/ut/ut0dbg.cc:60
|
#6 0x00005fe719d5b2b2 in dict_stats_fetch_index_stats_step (node_void=0x6f4b4c085f18, arg_void=0x774c244c6be0)at /test/10.11_dbg/storage/innobase/dict/dict0stats.cc:3303
|
#7 0x00005fe719be8ad3 in fetch_step (thr=0x6f4b4c087de8)at /test/10.11_dbg/storage/innobase/row/row0sel.cc:2478
|
#8 0x00005fe719b4afc7 in que_thr_step (thr=0x6f4b4c087de8)at /test/10.11_dbg/storage/innobase/que/que0que.cc:537
|
#9 0x00005fe719b4a786 in que_run_threads_low (thr=0x6f4b4c087de8)at /test/10.11_dbg/storage/innobase/que/que0que.cc:609
|
#10 0x00005fe719b4a5a7 in que_run_threads (thr=0x6f4b4c087de8)at /test/10.11_dbg/storage/innobase/que/que0que.cc:629
|
#11 0x00005fe719d5a8ae in dict_stats_fetch_from_ps (table=0x6f4b4c024660)at /test/10.11_dbg/storage/innobase/dict/dict0stats.cc:3553
|
#12 0x00005fe7199c876a in ha_innobase::statistics_init (this=0x6f4b4c080ee8, table=0x6f4b4c024660, recalc=false)at /test/10.11_dbg/storage/innobase/handler/ha_innodb.cc:5755
|
#13 0x00005fe7199e2198 in ha_innobase::info_low (this=0x6f4b4c080ee8, flag=282, is_analyze=false)at /test/10.11_dbg/storage/innobase/handler/ha_innodb.cc:14842
|
#14 0x00005fe7199c9f1d in ha_innobase::info (this=0x6f4b4c080ee8, flag=282)at /test/10.11_dbg/storage/innobase/handler/ha_innodb.cc:15130
|
#15 0x00005fe7199c9694 in ha_innobase::open (this=0x6f4b4c080ee8, name=0x6f4b4c07dd48 "./test/t2")at /test/10.11_dbg/storage/innobase/handler/ha_innodb.cc:6043
|
#16 0x00005fe71964b339 in handler::ha_open (this=0x6f4b4c080ee8, table_arg=0x6f4b4c07f708, name=0x6f4b4c07dd48 "./test/t2", mode=2, test_if_locked=18, mem_root=0x0, partitions_to_open=0x0)at /test/10.11_dbg/sql/handler.cc:3578
|
#17 0x00005fe71940e8c8 in open_table_from_share (thd=0x6f4b4c000d58, share=0x6f4b4c07d720, alias=0x6f4b4c013bc0, db_stat=33, prgflag=8, ha_open_flags=18, outparam=0x6f4b4c07f708, is_create_table=false, partitions_to_open=0x0) at /test/10.11_dbg/sql/table.cc:4497
|
#18 0x00005fe719207c6b in open_table (thd=0x6f4b4c000d58, table_list=0x6f4b4c013b70, ot_ctx=0x774c244c8dd8)at /test/10.11_dbg/sql/sql_base.cc:2291
|
#19 0x00005fe71920cd51 in open_and_process_table (thd=0x6f4b4c000d58, tables=0x6f4b4c013b70, counter=0x774c244c8e8c, flags=0, prelocking_strategy=0x774c244c8ef0, has_prelocking_list=false, ot_ctx=0x774c244c8dd8) at /test/10.11_dbg/sql/sql_base.cc:4262
|
#20 0x00005fe71920bb2b in open_tables (thd=0x6f4b4c000d58, options=@0x6f4b4c0065c0: {m_options = DDL_options_st::OPT_NONE}, start=0x774c244c8ea0, counter=0x774c244c8e8c, flags=0, prelocking_strategy=0x774c244c8ef0) at /test/10.11_dbg/sql/sql_base.cc:4747
|
#21 0x00005fe71920eafa in open_and_lock_tables (thd=0x6f4b4c000d58, options=@0x6f4b4c0065c0: {m_options = DDL_options_st::OPT_NONE}, tables=0x6f4b4c013b70, derived=true, flags=0, prelocking_strategy=0x774c244c8ef0) at /test/10.11_dbg/sql/sql_base.cc:5774
|
#22 0x00005fe7191c3c2e in open_and_lock_tables (thd=0x6f4b4c000d58, tables=0x6f4b4c013b70, derived=true, flags=0)at /test/10.11_dbg/sql/sql_base.h:519
|
#23 0x00005fe7192bd69a in execute_sqlcom_select (thd=0x6f4b4c000d58, all_tables=0x6f4b4c013b70) at /test/10.11_dbg/sql/sql_parse.cc:6367
|
#24 0x00005fe7192b3266 in mysql_execute_command (thd=0x6f4b4c000d58, is_called_from_prepared_stmt=false)at /test/10.11_dbg/sql/sql_parse.cc:4032
|
#25 0x00005fe7192ac078 in mysql_parse (thd=0x6f4b4c000d58, rawbuf=0x6f4b4c0134c0 "SELECT * FROM t2", length=16, parser_state=0x774c244caa20) at /test/10.11_dbg/sql/sql_parse.cc:8204
|
#26 0x00005fe7192a995a in dispatch_command (command=COM_QUERY, thd=0x6f4b4c000d58, packet=0x6f4b4c00af49 "SELECT * FROM t2", packet_length=16, blocking=true) at /test/10.11_dbg/sql/sql_parse.cc:1924
|
#27 0x00005fe7192acafa in do_command (thd=0x6f4b4c000d58, blocking=true)at /test/10.11_dbg/sql/sql_parse.cc:1434
|
#28 0x00005fe71946187e in do_handle_one_connection (connect=0x5fe754e6d2c8, put_in_cache=true) at /test/10.11_dbg/sql/sql_connect.cc:1486
|
#29 0x00005fe719461665 in handle_one_connection (arg=0x5fe754f69b48)at /test/10.11_dbg/sql/sql_connect.cc:1398
|
#30 0x0000774c4a29cb84 in start_thread (arg=<optimized out>)at ./nptl/pthread_create.c:447
|
#31 0x0000774c4a329d6c in clone3 ()at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:78
|
|
Bug Detection Matrix |
Rel o/d Build Commit UniqueID observed
|
CS 10.6 dbg 100826 0931994096b84ecc9ffc8eb3517c7e09e6e8631e No bug found
|
CS 10.6 opt 100826 0931994096b84ecc9ffc8eb3517c7e09e6e8631e No bug found
|
CS 10.11 dbg 100826 aba2caa893cdfa880dbb9a4f2d8e6dfaa7ed8ebe stat_value != UINT64_UNDEFINED|SIGABRT|ut_dbg_assertion_failed|dict_stats_fetch_index_stats_step|fetch_step|que_thr_step
|
CS 10.11 opt 100826 aba2caa893cdfa880dbb9a4f2d8e6dfaa7ed8ebe stat_value != UINT64_UNDEFINED|SIGABRT|ut_dbg_assertion_failed|dict_stats_fetch_index_stats_step|fetch_step|que_thr_step
|
CS 11.4 dbg 100826 f6418ff7b2a0ecbc158f53331735994446bed0ac stat_value != UINT64_UNDEFINED|SIGABRT|ut_dbg_assertion_failed|dict_stats_fetch_index_stats_step|fetch_step|que_thr_step
|
CS 11.4 opt 100826 f6418ff7b2a0ecbc158f53331735994446bed0ac stat_value != UINT64_UNDEFINED|SIGABRT|ut_dbg_assertion_failed|dict_stats_fetch_index_stats_step|fetch_step|que_thr_step
|
CS 11.8 dbg 100826 da0beac410cc761be4ee52b90fded6c7fa2f8947 stat_value != UINT64_UNDEFINED|SIGABRT|ut_dbg_assertion_failed|dict_stats_fetch_index_stats_step|fetch_step|que_thr_step
|
CS 11.8 opt 100826 da0beac410cc761be4ee52b90fded6c7fa2f8947 stat_value != UINT64_UNDEFINED|SIGABRT|ut_dbg_assertion_failed|dict_stats_fetch_index_stats_step|fetch_step|que_thr_step
|
CS 12.3 dbg 100826 6b174bfb25be06f7efdab149183665e1a36b3dd5 stat_value != UINT64_UNDEFINED|SIGABRT|ut_dbg_assertion_failed|dict_stats_fetch_index_stats_step|fetch_step|que_thr_step
|
CS 12.3 opt 100826 6b174bfb25be06f7efdab149183665e1a36b3dd5 stat_value != UINT64_UNDEFINED|SIGABRT|ut_dbg_assertion_failed|dict_stats_fetch_index_stats_step|fetch_step|que_thr_step
|
CS 13.0 dbg 100826 1a4bb1bbfde5fa17ba148cb62678902f11c66a1a stat_value != UINT64_UNDEFINED|SIGABRT|ut_dbg_assertion_failed|dict_stats_fetch_index_stats_step|fetch_step|que_thr_step
|
CS 13.0 opt 100826 1a4bb1bbfde5fa17ba148cb62678902f11c66a1a stat_value != UINT64_UNDEFINED|SIGABRT|ut_dbg_assertion_failed|dict_stats_fetch_index_stats_step|fetch_step|que_thr_step
|
CS 13.1 dbg 100826 a217e1000f37a429a9c1d1c308952a959276b77e stat_value != UINT64_UNDEFINED|SIGABRT|ut_dbg_assertion_failed|dict_stats_fetch_index_stats_step|fetch_step|que_thr_step
|
CS 13.1 opt 100826 a217e1000f37a429a9c1d1c308952a959276b77e stat_value != UINT64_UNDEFINED|SIGABRT|ut_dbg_assertion_failed|dict_stats_fetch_index_stats_step|fetch_step|que_thr_step
|
ES 10.6 dbg 100826 fcecb2620f25965723d640decede7c018bcb1dcc No bug found
|
ES 10.6 opt 100826 fcecb2620f25965723d640decede7c018bcb1dcc No bug found
|
ES 11.4 dbg 100826 3b34189bfe675c18c4ced3ef531d016ea74c76f4 stat_value != UINT64_UNDEFINED|SIGABRT|ut_dbg_assertion_failed|dict_stats_fetch_index_stats_step|fetch_step|que_thr_step
|
ES 11.4 opt 100826 3b34189bfe675c18c4ced3ef531d016ea74c76f4 stat_value != UINT64_UNDEFINED|SIGABRT|ut_dbg_assertion_failed|dict_stats_fetch_index_stats_step|fetch_step|que_thr_step
|
ES 11.8 dbg 100826 4694e931d10fecf733c34f83ea2146d31b708eb3 stat_value != UINT64_UNDEFINED|SIGABRT|ut_dbg_assertion_failed|dict_stats_fetch_index_stats_step|fetch_step|que_thr_step
|
ES 11.8 opt 100826 4694e931d10fecf733c34f83ea2146d31b708eb3 stat_value != UINT64_UNDEFINED|SIGABRT|ut_dbg_assertion_failed|dict_stats_fetch_index_stats_step|fetch_step|que_thr_step
|
ES 12.3 dbg 100826 ad4d36b69e4813957c35d5e148b93a51a61c91c6 stat_value != UINT64_UNDEFINED|SIGABRT|ut_dbg_assertion_failed|dict_stats_fetch_index_stats_step|fetch_step|que_thr_step
|
ES 12.3 opt 100826 ad4d36b69e4813957c35d5e148b93a51a61c91c6 stat_value != UINT64_UNDEFINED|SIGABRT|ut_dbg_assertion_failed|dict_stats_fetch_index_stats_step|fetch_step|que_thr_step
|
Attachments
Issue Links
- causes
-
MCDEV-4633 Loading...