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

Assertion `field->field_name.streq( dict_table_get_col_name(ib_table, j))' failed

    XMLWordPrintable

Details

    • Can result in hang or crash

    Description

        --source include/have_innodb.inc
        --source include/have_debug.inc
        --source include/not_embedded.inc
        CREATE TABLE t1 (a INT, b INT, c INT, v INT AS (a) VIRTUAL) ENGINE=InnoDB;
        INSERT INTO t1 (a,b,c) VALUES (11,22,33);
        --let $_expect_file_name= `select regexp_replace(@@tmpdir, '^.*/','')`
        --let $_expect_file_name= $MYSQLTEST_VARDIR/tmp/$_expect_file_name.expect
        --write_line wait $_expect_file_name
        --disable_reconnect
        SET @@debug_dbug="+d,ddl_log_alter_after_log",@debug_crash_counter=1;
        --error 0,2013,2026
        ALTER TABLE t1 MODIFY COLUMN a INT AFTER c, ALGORITHM=COPY;
        --source include/wait_until_disconnected.inc
        --let $restart_parameters= --innodb-log-recovery-target=18446744073709551615
        --source include/start_mysqld.inc
        --disable_query_log
        SELECT c.NAME INTO @dict_col0
          FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES t
          JOIN INFORMATION_SCHEMA.INNODB_SYS_COLUMNS c ON c.TABLE_ID = t.TABLE_ID
          WHERE t.NAME = 'test/t1' AND c.POS = 0;
        --enable_query_log
        --let $dict_col0= `SELECT @dict_col0`
        SELECT * FROM t1;
        if ($dict_col0 != "b")
        {
          --die Recovery left the InnoDB dictionary at POS 0 = $dict_col0 while the .frm says b
        }
        --let $restart_parameters=
        --source include/restart_mysqld.inc
        DROP TABLE t1;
      

      Leads to:

      INFO: no cores found at data*/core nor at node*/core, and no *SAN or Valgrind report found in the error log

      CS 13.0.2 b2c4e675049e23ce8c7346985f40840fcd4e583f (Debug, Clang 22.1.8-20260621) Build 09/09/2026

      mariadbd: /test/13.0_dbg/storage/innobase/handler/ha_innodb.cc:5588: void innobase_build_v_templ(const TABLE *, const dict_table_t *, dict_vcol_templ_t *, const dict_add_v_col_t *): Assertion `field->field_name.streq( dict_table_get_col_name(ib_table, j))' failed.
      

      CS 13.0.2 b2c4e675049e23ce8c7346985f40840fcd4e583f (Debug, Clang 22.1.8-20260621) Build 09/09/2026

      Core was generated by `/test/MD090926-mariadb-13.0.2-linux-x86_64-dbg/bin/mariadbd --defaults-group-su'.
      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 3715423)]
      (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  0x0000795375c4527e in __GI_raise (sig=sig@entry=6)at ../sysdeps/posix/raise.c:26
      #4  0x0000795375c288ff in __GI_abort () at ./stdlib/abort.c:79
      #5  0x0000795375c2881b in __assert_fail_base (fmt=0x795375dd1208 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x5a93e357c49f "field->field_name.streq( dict_table_get_col_name(ib_table, j))", file=file@entry=0x5a93e357c04e "/test/13.0_dbg/storage/innobase/handler/ha_innodb.cc", line=line@entry=5588, function=function@entry=0x5a93e357c3d4 "void innobase_build_v_templ(const TABLE *, const dict_table_t *, dict_vcol_templ_t *, const dict_add_v_col_t *)")at ./assert/assert.c:96
      #6  0x0000795375c3b517 in __assert_fail (assertion=0x5a93e357c49f "field->field_name.streq( dict_table_get_col_name(ib_table, j))", file=0x5a93e357c04e "/test/13.0_dbg/storage/innobase/handler/ha_innodb.cc", line=5588, function=0x5a93e357c3d4 "void innobase_build_v_templ(const TABLE *, const dict_table_t *, dict_vcol_templ_t *, const dict_add_v_col_t *)")at ./assert/assert.c:105
      #7  0x00005a93e2c0e8ed in innobase_build_v_templ (table=0x71528c030880, ib_table=0x71528c036e88, s_templ=0x71528c02b4c0, add_v=0x0)at /test/13.0_dbg/storage/innobase/handler/ha_innodb.cc:5587
      #8  0x00005a93e2c10087 in ha_innobase::open (this=0x71528c033600, name=0x71528c031470 "./test/t1")at /test/13.0_dbg/storage/innobase/handler/ha_innodb.cc:5981
      #9  0x00005a93e284169a in handler::ha_open (this=0x71528c033600, table_arg=0x71528c030880, name=0x71528c031470 "./test/t1", mode=2, test_if_locked=18, mem_root=0x0, partitions_to_open=0x0)at /test/13.0_dbg/sql/handler.cc:3937
      #10 0x00005a93e25a56e8 in open_table_from_share (thd=0x71528c000d60, share=0x71528c030db0, alias=0x71528c019c00, db_stat=33, prgflag=8, ha_open_flags=18, outparam=0x71528c030880, is_create_table=false, partitions_to_open=0x0) at /test/13.0_dbg/sql/table.cc:4719
      #11 0x00005a93e237204e in open_table (thd=0x71528c000d60, table_list=0x71528c019bb0, ot_ctx=0x79535712ab38)at /test/13.0_dbg/sql/sql_base.cc:2322
      #12 0x00005a93e23770e1 in open_and_process_table (thd=0x71528c000d60, tables=0x71528c019bb0, counter=0x79535712abec, flags=0, prelocking_strategy=0x79535712ac50, has_prelocking_list=false, ot_ctx=0x79535712ab38) at /test/13.0_dbg/sql/sql_base.cc:4297
      #13 0x00005a93e2375f2b in open_tables (thd=0x71528c000d60, options=@0x71528c00688c: {m_options = DDL_options_st::OPT_NONE}, start=0x79535712ac00, counter=0x79535712abec, flags=0, prelocking_strategy=0x79535712ac50) at /test/13.0_dbg/sql/sql_base.cc:4780
      #14 0x00005a93e2378efa in open_and_lock_tables (thd=0x71528c000d60, options=@0x71528c00688c: {m_options = DDL_options_st::OPT_NONE}, tables=0x71528c019bb0, derived=true, flags=0, prelocking_strategy=0x79535712ac50) at /test/13.0_dbg/sql/sql_base.cc:5803
      #15 0x00005a93e238700e in open_and_lock_tables (thd=0x71528c000d60, tables=0x71528c019bb0, derived=true, flags=0)at /test/13.0_dbg/sql/sql_base.h:545
      #16 0x00005a93e243f46a in execute_sqlcom_select (thd=0x71528c000d60, all_tables=0x71528c019bb0) at /test/13.0_dbg/sql/sql_parse.cc:6137
      #17 0x00005a93e2435f28 in mysql_execute_command (thd=0x71528c000d60, is_called_from_prepared_stmt=false) at /test/13.0_dbg/sql/sql_parse.cc:3991
      #18 0x00005a93e242ed18 in mysql_parse (thd=0x71528c000d60, rawbuf=0x71528c019480 "SELECT * FROM t1", length=16, parser_state=0x79535712c9f0) at /test/13.0_dbg/sql/sql_parse.cc:7943
      #19 0x00005a93e242c46e in dispatch_command (command=COM_QUERY, thd=0x71528c000d60, packet=0x71528c00b691 "SELECT * FROM t1", packet_length=16, blocking=true) at /test/13.0_dbg/sql/sql_parse.cc:1903
      #20 0x00005a93e242f79a in do_command (thd=0x71528c000d60, blocking=true)at /test/13.0_dbg/sql/sql_parse.cc:1437
      #21 0x00005a93e260175e in do_handle_one_connection (connect=0x5a9401a71ed0, put_in_cache=true) at /test/13.0_dbg/sql/sql_connect.cc:1514
      #22 0x00005a93e2601541 in handle_one_connection (arg=0x5a9401a71ed0)at /test/13.0_dbg/sql/sql_connect.cc:1426
      #23 0x0000795375c9cb84 in start_thread (arg=<optimized out>)at ./nptl/pthread_create.c:447
      #24 0x0000795375d29ecc in clone3 ()at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:78
      

      Bug Detection Matrix

          Rel    o/d  Build   Commit                                    UniqueID observed             
      CS  10.11  dbg  090926  2753b5919a10abd32ba822877c6a1cbf602d3748  No bug found                  
      CS  10.11  opt  090926  2753b5919a10abd32ba822877c6a1cbf602d3748  Assert: no error log(s) found - exiting
      CS  11.4   dbg  090926  42038e1145dd43b3910055c364fb720a8a152d61  No bug found                  
      CS  11.4   opt  090926  42038e1145dd43b3910055c364fb720a8a152d61  Assert: no error log(s) found - exiting
      CS  11.8   dbg  090926  e2e060ce3d8c3ce11b6c7ba28ced0f1a30c50a54  No bug found                  
      CS  11.8   opt  090926  e2e060ce3d8c3ce11b6c7ba28ced0f1a30c50a54  Assert: no error log(s) found - exiting
      CS  12.3   dbg  090926  e9f84a1fdf7093191e55b55dc14b08b9d4ebaa20  No bug found                  
      CS  12.3   opt  090926  e9f84a1fdf7093191e55b55dc14b08b9d4ebaa20  Assert: no error log(s) found - exiting
      CS  13.0   dbg  090926  b2c4e675049e23ce8c7346985f40840fcd4e583f  field->field_name.streq( dict_table_get_col_name(ib_table, j))|SIGABRT|innobase_build_v_templ|ha_innobase::open|handler::ha_open|open_table_from_share
      CS  13.0   opt  090926  b2c4e675049e23ce8c7346985f40840fcd4e583f  Assert: no error log(s) found - exiting
      CS  13.1   dbg  090926  02c842c30dcb05a962eaac58c69920e6be3369cf  field->field_name.streq( dict_table_get_col_name(ib_table, j))|SIGABRT|innobase_build_v_templ|ha_innobase::open|handler::ha_open|open_table_from_share
      CS  13.1   opt  090926  02c842c30dcb05a962eaac58c69920e6be3369cf  Assert: no error log(s) found - exiting
      ES  10.6   dbg  090926  aa3fb9800c358182ee2a1f8cca8ffbdd6d0a37eb  No bug found                  
      ES  10.6   opt  090926  aa3fb9800c358182ee2a1f8cca8ffbdd6d0a37eb  Assert: no error log(s) found - exiting
      ES  11.4   dbg  090926  32807340954440071ca8ae8e2de51fb180d134c6  No bug found                  
      ES  11.4   opt  090926  32807340954440071ca8ae8e2de51fb180d134c6  Assert: no error log(s) found - exiting
      ES  11.8   dbg  090926  c4af6f687a2dd983072457429aa2294f11957650  No bug found                  
      ES  11.8   opt  090926  c4af6f687a2dd983072457429aa2294f11957650  Assert: no error log(s) found - exiting
      ES  12.3   dbg  090926  c3bd5108d81f19e33efb93f7b6ae971293732fd0  No bug found                  
      ES  12.3   opt  090926  c3bd5108d81f19e33efb93f7b6ae971293732fd0  Assert: no error log(s) found - exiting
      

      Attachments

        Activity

          People

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

            Dates

              Created:
              Updated:

              Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0d
                0d
                Logged:
                Time Spent - 1.5h
                1.5h

                Git Integration

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