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

InnoDB: Failing assertion: ib_table->stat_initialized in ha_innobase::info_low()

    XMLWordPrintable

    Details

      Description

      SET SESSION unique_checks=0;
      SET foreign_key_checks=0;
      SET GLOBAL innodb_stats_persistent=0;
      CREATE TABLE t1 (c1 MEDIUMINT);
      XA START 'a';
      INSERT INTO t1 VALUES (3);
      SET GLOBAL innodb_stats_persistent=1;
      SET GLOBAL table_open_cache=+ 1;
      INSERT INTO t1 VALUES (NULL,'a');
      
      

      Leads to:

      10.6.12 377ec1b5c906ea55fa2af9ae048a14eb9e1cf201

      InnoDB: Failing assertion: ib_table->stat_initialized
      

      10.6.12 377ec1b5c906ea55fa2af9ae048a14eb9e1cf201

      Core was generated by `/test/mtest/10.6/mariadb-10.6.12-linux-x86_64/bin/mysqld --no-defaults --core-f'.
      Program terminated with signal SIGABRT, Aborted.
      #0  __pthread_kill (threadid=<optimized out>, signo=6)
          at ../sysdeps/unix/sysv/linux/pthread_kill.c:56
      [Current thread is 1 (Thread 0x153be43fb700 (LWP 3615589))]
      (gdb) bt
      #0  __pthread_kill (threadid=<optimized out>, signo=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:56
      #1  0x000055919ea23dc5 in my_write_core (sig=6) at /test/mtest/10.6/mysys/stacktrace.c:424
      #2  0x000055919e144c67 in handle_fatal_signal (sig=6) at /test/mtest/10.6/sql/signal_handler.cc:355
      #3  <signal handler called>
      #4  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
      #5  0x0000153be7f8a859 in __GI_abort () at abort.c:79
      #6  0x000055919e7f853f in ut_dbg_assertion_failed (expr=0x55919ee4a418 "ib_table->stat_initialized", file=0x55919ee42638 "/test/mtest/10.6/storage/innobase/handler/ha_innodb.cc", line=14755) at /test/mtest/10.6/storage/innobase/ut/ut0dbg.cc:60
      #7  0x000055919e588fec in ha_innobase::info_low (this=0x153b90076940, flag=282, is_analyze=false) at /test/mtest/10.6/storage/innobase/handler/ha_innodb.cc:14755
      #8  0x000055919e589981 in ha_innobase::info (this=0x153b90076940, flag=282) at /test/mtest/10.6/storage/innobase/handler/ha_innodb.cc:15010
      #9  0x000055919e57264c in ha_innobase::open (this=0x153b90076940, name=0x153b90021b80 "./test/t1") at /test/mtest/10.6/storage/innobase/handler/ha_innodb.cc:6197
      #10 0x000055919e14f740 in handler::ha_open (this=0x153b90076940, table_arg=0x153b9005eeb8, name=0x153b90021b80 "./test/t1", mode=2, test_if_locked=18, mem_root=0x0, partitions_to_open=0x0) at /test/mtest/10.6/sql/handler.cc:3333
      #11 0x000055919df0160c in open_table_from_share (thd=0x153b90000db8, share=0x153b900215e0, alias=0x153b90014110, db_stat=33, prgflag=8, ha_open_flags=18, outparam=0x153b9005eeb8, is_create_table=false, partitions_to_open=0x0) at /test/mtest/10.6/sql/table.cc:4417
      #12 0x000055919dcf33be in open_table (thd=0x153b90000db8, table_list=0x153b900140c8, ot_ctx=0x153be43f9800) at /test/mtest/10.6/sql/sql_base.cc:2036
      #13 0x000055919dcf71e2 in open_and_process_table (thd=0x153b90000db8, tables=0x153b900140c8, counter=0x153be43f9894, flags=0, prelocking_strategy=0x153be43f9918, has_prelocking_list=false, ot_ctx=0x153be43f9800) at /test/mtest/10.6/sql/sql_base.cc:3847
      #14 0x000055919dcf84a8 in open_tables (thd=0x153b90000db8, options=@0x153b90006640: {m_options = DDL_options_st::OPT_NONE}, start=0x153be43f9878, counter=0x153be43f9894, flags=0, prelocking_strategy=0x153be43f9918) at /test/mtest/10.6/sql/sql_base.cc:4330
      #15 0x000055919dcfa4e3 in open_and_lock_tables (thd=0x153b90000db8, options=@0x153b90006640: {m_options = DDL_options_st::OPT_NONE}, tables=0x153b900140c8, derived=true, flags=0, prelocking_strategy=0x153be43f9918) at /test/mtest/10.6/sql/sql_base.cc:5303
      #16 0x000055919dcaf961 in open_and_lock_tables (thd=0x153b90000db8, tables=0x153b900140c8, derived=true, flags=0) at /test/mtest/10.6/sql/sql_base.h:509
      #17 0x000055919dd50e96 in mysql_insert (thd=0x153b90000db8, table_list=0x153b900140c8, fields=@0x153b90005ff8: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x55919f6fdee0 <end_of_list>, last = 0x153b90005ff8, elements = 0}, <No data fields>}, values_list=@0x153b90006040: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x153b90014d78, last = 0x153b90014d78, elements = 1}, <No data fields>}, update_fields=@0x153b90006028: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x55919f6fdee0 <end_of_list>, last = 0x153b90006028, elements = 0}, <No data fields>}, update_values=@0x153b90006010: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x55919f6fdee0 <end_of_list>, last = 0x153b90006010, elements = 0}, <No data fields>}, duplic=DUP_ERROR, ignore=false, result=0x0) at /test/mtest/10.6/sql/sql_insert.cc:757
      #18 0x000055919dda7e03 in mysql_execute_command (thd=0x153b90000db8, is_called_from_prepared_stmt=false) at /test/mtest/10.6/sql/sql_parse.cc:4565
      #19 0x000055919ddb3896 in mysql_parse (thd=0x153b90000db8, rawbuf=0x153b90013fe0 "INSERT INTO t1 VALUES (NULL,'a')", length=32, parser_state=0x153be43fa320) at /test/mtest/10.6/sql/sql_parse.cc:8016
      #20 0x000055919dd9fd30 in dispatch_command (command=COM_QUERY, thd=0x153b90000db8, packet=0x153b9000b799 "INSERT INTO t1 VALUES (NULL,'a')", packet_length=32, blocking=true) at /test/mtest/10.6/sql/sql_parse.cc:1896
      #21 0x000055919dd9e6ef in do_command (thd=0x153b90000db8, blocking=true) at /test/mtest/10.6/sql/sql_parse.cc:1409
      #22 0x000055919df603e5 in do_handle_one_connection (connect=0x5591a0e0bb88, put_in_cache=true) at /test/mtest/10.6/sql/sql_connect.cc:1415
      #23 0x000055919df60141 in handle_one_connection (arg=0x5591a0e03cb8) at /test/mtest/10.6/sql/sql_connect.cc:1317
      #24 0x000055919e4954d3 in pfs_spawn_thread (arg=0x5591a0d02548) at /test/mtest/10.6/storage/perfschema/pfs.cc:2201
      #25 0x0000153be84b6609 in start_thread (arg=<optimized out>) at pthread_create.c:477
      #26 0x0000153be8087133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
      

      10.6.12 c4ce012e4b3dac44e76598a5d1f2fe92f836eb30 (Optimized)

      InnoDB: Failing assertion: ib_table->stat_initialized
      

      10.6.12 c4ce012e4b3dac44e76598a5d1f2fe92f836eb30 (Optimized)

      Core was generated by `/test/MD081122-mariadb-10.6.12-linux-x86_64-opt/bin/mysqld --no-defaults --core'.
      Program terminated with signal SIGABRT, Aborted.
      #0  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
      [Current thread is 1 (Thread 0x154518cdc700 (LWP 2913317))]
      (gdb) bt
      #0  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
      #1  0x000015453144e859 in __GI_abort () at abort.c:79
      #2  0x000055d111896991 in ut_dbg_assertion_failed (expr=expr@entry=0x55d1124072e4 "ib_table->stat_initialized", file=file@entry=0x55d1124001e0 "/test/10.6_opt/storage/innobase/handler/ha_innodb.cc", line=line@entry=14779) at /test/10.6_opt/storage/innobase/ut/ut0dbg.cc:60
      #3  0x000055d1118705c2 in ha_innobase::info_low (this=0x1544e4040da0, flag=282, is_analyze=<optimized out>) at /test/10.6_opt/storage/innobase/handler/ha_innodb.cc:14779
      #4  0x000055d111ea67bf in ha_innobase::info (flag=282, this=0x1544e4040da0) at /test/10.6_opt/storage/innobase/handler/ha_innodb.cc:15034
      #5  ha_innobase::open (this=<optimized out>, name=<optimized out>) at /test/10.6_opt/storage/innobase/handler/ha_innodb.cc:6197
      #6  0x000055d111c045ae in handler::ha_open (this=0x1544e4040da0, table_arg=table_arg@entry=0x1544e401c988, name=0x1544e401a500 "./test/t1", mode=mode@entry=2, test_if_locked=test_if_locked@entry=18, mem_root=mem_root@entry=0x0, partitions_to_open=0x0) at /test/10.6_opt/sql/handler.cc:3333
      #7  0x000055d111ab2c11 in open_table_from_share (thd=thd@entry=0x1544e4000c58, share=share@entry=0x1544e401a060, alias=alias@entry=0x1544e40107b0, db_stat=db_stat@entry=33, prgflag=prgflag@entry=8, ha_open_flags=18, outparam=0x1544e401c988, is_create_table=false, partitions_to_open=0x0) at /test/10.6_opt/sql/table.cc:4417
      #8  0x000055d11196c9d4 in open_table (thd=0x1544e4000c58, table_list=0x1544e4010768, ot_ctx=0x154518cdaa90) at /test/10.6_opt/sql/sql_base.cc:2036
      #9  0x000055d11196f6ce in open_and_process_table (ot_ctx=0x154518cdaa90, has_prelocking_list=false, prelocking_strategy=0x154518cdac40, flags=0, counter=0x154518cdab2c, tables=0x1544e4010768, thd=0x1544e4000c58) at /test/10.6_opt/sql/sql_base.cc:3847
      #10 open_tables (thd=thd@entry=0x1544e4000c58, options=@0x1544e4006120: {m_options = DDL_options_st::OPT_NONE}, start=start@entry=0x154518cdab18, counter=counter@entry=0x154518cdab2c, flags=flags@entry=0, prelocking_strategy=0x154518cdac40) at /test/10.6_opt/sql/sql_base.cc:4330
      #11 0x000055d11196fe7c in open_and_lock_tables (thd=thd@entry=0x1544e4000c58, options=<optimized out>, tables=<optimized out>, tables@entry=0x1544e4010768, derived=derived@entry=true, flags=flags@entry=0, prelocking_strategy=<optimized out>) at /test/10.6_opt/sql/sql_base.cc:5303
      #12 0x000055d1119a0181 in open_and_lock_tables (flags=<optimized out>, derived=<optimized out>, tables=<optimized out>, thd=<optimized out>) at /test/10.6_opt/sql/sql_base.h:509
      #13 open_and_lock_for_insert_delayed (table_list=<optimized out>, thd=<optimized out>) at /test/10.6_opt/sql/sql_insert.cc:626
      #14 mysql_insert (thd=thd@entry=0x1544e4000c58, table_list=0x1544e4010768, fields=@0x1544e4005ad8: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x55d112a54650 <end_of_list>, last = 0x1544e4005ad8, elements = 0}, <No data fields>}, values_list=@0x1544e4005b20: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x1544e4011418, last = 0x1544e4011418, elements = 1}, <No data fields>}, update_fields=@0x1544e4005b08: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x55d112a54650 <end_of_list>, last = 0x1544e4005b08, elements = 0}, <No data fields>}, update_values=@0x1544e4005af0: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x55d112a54650 <end_of_list>, last = 0x1544e4005af0, elements = 0}, <No data fields>}, duplic=<optimized out>, ignore=<optimized out>, result=<optimized out>) at /test/10.6_opt/sql/sql_insert.cc:752
      #15 0x000055d1119db7f4 in mysql_execute_command (thd=0x1544e4000c58, is_called_from_prepared_stmt=<optimized out>) at /test/10.6_opt/sql/sql_parse.cc:4565
      #16 0x000055d1119cba65 in mysql_parse (rawbuf=<optimized out>, length=<optimized out>, parser_state=<optimized out>, thd=0x1544e4000c58) at /test/10.6_opt/sql/sql_parse.cc:8016
      #17 mysql_parse (thd=0x1544e4000c58, rawbuf=<optimized out>, length=<optimized out>, parser_state=<optimized out>) at /test/10.6_opt/sql/sql_parse.cc:7938
      #18 0x000055d1119d7aa2 in dispatch_command (command=COM_QUERY, thd=0x1544e4000c58, packet=<optimized out>, packet_length=<optimized out>, blocking=<optimized out>) at /test/10.6_opt/sql/sql_class.h:1365
      #19 0x000055d1119d98ae in do_command (thd=0x1544e4000c58, blocking=blocking@entry=true) at /test/10.6_opt/sql/sql_parse.cc:1409
      #20 0x000055d111ae05ff in do_handle_one_connection (connect=<optimized out>, connect@entry=0x55d1153e1a38, put_in_cache=put_in_cache@entry=true) at /test/10.6_opt/sql/sql_connect.cc:1416
      #21 0x000055d111ae08ed in handle_one_connection (arg=0x55d1153e1a38) at /test/10.6_opt/sql/sql_connect.cc:1318
      #22 0x000015453195f609 in start_thread (arg=<optimized out>) at pthread_create.c:477
      #23 0x000015453154b133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
      

      Bug confirmed present in:
      MariaDB: 10.6.12 (dbg), 10.6.12 (opt)

      Bug (or feature/syntax) confirmed not present in:
      MariaDB: 10.3.38 (dbg), 10.3.38 (opt), 10.4.28 (dbg), 10.4.28 (opt), 10.5.19 (dbg), 10.5.19 (opt), 10.7.8 (dbg), 10.7.8 (opt), 10.8.7 (dbg), 10.8.7 (opt), 10.9.5 (dbg), 10.9.5 (opt), 10.10.3 (dbg), 10.10.3 (opt), 10.11.1 (dbg), 10.11.1 (opt)

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              thiru Thirunarayanan Balathandayuthapani
              Reporter:
              ramesh Ramesh Sivaraman
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:

                  Git Integration

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