Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
13.0, 13.1
-
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
|