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

InnoDB: Failing assertion: stat_value != UINT64_UNDEFINED

    XMLWordPrintable

Details

    • 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

          Activity

            People

              thiru Thirunarayanan Balathandayuthapani
              saahil Saahil Alam
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0d
                  0d
                  Logged:
                  Time Spent - 1h 40m
                  1h 40m

                  Git Integration

                    Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.