Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.3(EOL), 10.4(EOL), 10.5, 10.6, 10.7(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL), 10.11, 11.0(EOL)
Description
USE test;
|
CREATE TABLE t(c CHAR(255) CHARACTER SET UTF32, KEY k1(c)) ENGINE=MyISAM;
|
INSERT INTO t VALUES(100000);
|
ALTER TABLE t ENGINE=InnoDB;
|
Leads to:
|
10.5.4 6877ef9a7c9c7ee55d67e4baaf4e8f7b874c9f89 |
mysqld: /test/10.5_dbg/storage/innobase/btr/btr0cur.cc:1099: ulint btr_node_ptr_max_size(const dict_index_t*): Assertion `!field->prefix_len || field->fixed_len == field->prefix_len' failed.
|
|
10.5.4 6877ef9a7c9c7ee55d67e4baaf4e8f7b874c9f89 |
Core was generated by `/test/MD060620-mariadb-10.5.4-linux-x86_64-dbg/bin/mysqld --no-defaults --core-'.
|
Program terminated with signal SIGABRT, Aborted.
|
#0 __pthread_kill (threadid=<optimized out>, signo=signo@entry=6)
|
at ../sysdeps/unix/sysv/linux/pthread_kill.c:57
|
[Current thread is 1 (Thread 0x154e9e4c1700 (LWP 3147773))]
|
(gdb) bt
|
(gdb) (gdb) #0 __pthread_kill (threadid=<optimized out>, signo=signo@entry=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:57
|
#1 0x000055a4d822000d in my_write_core (sig=sig@entry=6) at /test/10.5_dbg/mysys/stacktrace.c:518
|
#2 0x000055a4d79c9bbc in handle_fatal_signal (sig=6) at /test/10.5_dbg/sql/signal_handler.cc:330
|
#3 <signal handler called>
|
#4 __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:51
|
#5 0x0000154ea6e0f801 in __GI_abort () at abort.c:79
|
#6 0x0000154ea6dff39a in __assert_fail_base (fmt=0x154ea6f867d8 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x55a4d86ad5e8 "!field->prefix_len || field->fixed_len == field->prefix_len", file=file@entry=0x55a4d86ad558 "/test/10.5_dbg/storage/innobase/btr/btr0cur.cc", line=line@entry=1099, function=function@entry=0x55a4d86b3960 <btr_node_ptr_max_size(dict_index_t const*)::__PRETTY_FUNCTION__> "ulint btr_node_ptr_max_size(const dict_index_t*)") at assert.c:92
|
#7 0x0000154ea6dff412 in __GI___assert_fail (assertion=assertion@entry=0x55a4d86ad5e8 "!field->prefix_len || field->fixed_len == field->prefix_len", file=file@entry=0x55a4d86ad558 "/test/10.5_dbg/storage/innobase/btr/btr0cur.cc", line=line@entry=1099, function=function@entry=0x55a4d86b3960 <btr_node_ptr_max_size(dict_index_t const*)::__PRETTY_FUNCTION__> "ulint btr_node_ptr_max_size(const dict_index_t*)") at assert.c:101
|
#8 0x000055a4d8009c76 in btr_node_ptr_max_size (index=index@entry=0x154e864bda18) at /test/10.5_dbg/storage/innobase/btr/btr0cur.cc:1099
|
#9 0x000055a4d802284d in btr_cur_search_to_nth_level_func (index=index@entry=0x154e864bda18, level=level@entry=0, tuple=tuple@entry=0x154e864b4930, mode=mode@entry=PAGE_CUR_LE, latch_mode=<optimized out>, latch_mode@entry=514, cursor=cursor@entry=0x154e9e4baf80, ahi_latch=0x0, file=0x55a4d8663680 "/test/10.5_dbg/storage/innobase/row/row0ins.cc", line=2947, mtr=0x154e9e4bb500, autoinc=0) at /test/10.5_dbg/storage/innobase/btr/btr0cur.cc:1524
|
#10 0x000055a4d7edc7ee in row_ins_sec_index_entry_low (flags=flags@entry=3, mode=mode@entry=2, index=index@entry=0x154e864bda18, offsets_heap=<optimized out>, offsets_heap@entry=0x154e86457a18, heap=heap@entry=0x154e86458418, entry=entry@entry=0x154e864b4930, trx_id=29, thr=0x154e86558bb0) at /test/10.5_dbg/storage/innobase/row/row0ins.cc:2944
|
#11 0x000055a4d7ee2051 in row_ins_sec_index_entry (index=index@entry=0x154e864bda18, entry=entry@entry=0x154e864b4930, thr=thr@entry=0x154e86558bb0, check_foreign=check_foreign@entry=true) at /test/10.5_dbg/storage/innobase/row/row0ins.cc:3266
|
#12 0x000055a4d7ee3acf in row_ins_index_entry (thr=0x154e86558bb0, entry=0x154e864b4930, index=0x154e864bda18) at /test/10.5_dbg/storage/innobase/row/row0ins.cc:3313
|
#13 row_ins_index_entry_step (thr=0x154e86558bb0, node=0x154e86558590) at /test/10.5_dbg/storage/innobase/row/row0ins.cc:3480
|
#14 row_ins (thr=0x154e86558bb0, node=0x154e86558590) at /test/10.5_dbg/storage/innobase/row/row0ins.cc:3617
|
#15 row_ins_step (thr=thr@entry=0x154e86558bb0) at /test/10.5_dbg/storage/innobase/row/row0ins.cc:3756
|
#16 0x000055a4d7f039f1 in row_insert_for_mysql (mysql_rec=mysql_rec@entry=0x154e86525ca0 <incomplete sequence \375>, prebuilt=0x154e86558098, ins_mode=ROW_INS_NORMAL) at /test/10.5_dbg/storage/innobase/row/row0mysql.cc:1461
|
#17 0x000055a4d7d9c8d8 in ha_innobase::write_row (this=0x154e865248a0, record=0x154e86525ca0 <incomplete sequence \375>) at /test/10.5_dbg/storage/innobase/handler/ha_innodb.cc:7729
|
#18 0x000055a4d79dda26 in handler::ha_write_row (this=0x154e865248a0, buf=0x154e86525ca0 <incomplete sequence \375>) at /test/10.5_dbg/sql/handler.cc:6999
|
#19 0x000055a4d77f8025 in copy_data_between_tables (alter_ctx=0x154e9e4be630, keys_onoff=<optimized out>, deleted=<synthetic pointer>, copied=<synthetic pointer>, order=<optimized out>, order_num=0, ignore=false, create=@0x154e9e4be750: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x0, last = 0x0, elements = 0}, <No data fields>}, to=0x154e86557088, from=0x154e864aa088, thd=0x154e86415088) at /test/10.5_dbg/sql/sql_table.cc:11231
|
#20 mysql_alter_table (thd=thd@entry=0x154e86415088, new_db=new_db@entry=0x154e86419950, new_name=new_name@entry=0x154e86419d58, create_info=create_info@entry=0x154e9e4bf220, table_list=<optimized out>, table_list@entry=0x154e86474188, alter_info=alter_info@entry=0x154e9e4bf150, order_num=0, order=0x0, ignore=false, if_exists=false) at /test/10.5_dbg/sql/sql_table.cc:10610
|
#21 0x000055a4d787a82c in Sql_cmd_alter_table::execute (this=<optimized out>, thd=0x154e86415088) at /test/10.5_dbg/sql/sql_alter.cc:532
|
#22 0x000055a4d7724a13 in mysql_execute_command (thd=thd@entry=0x154e86415088) at /test/10.5_dbg/sql/sql_parse.cc:5950
|
#23 0x000055a4d772c322 in mysql_parse (thd=thd@entry=0x154e86415088, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x154e9e4c0350, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /test/10.5_dbg/sql/sql_parse.cc:7992
|
#24 0x000055a4d7718e1c in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x154e86415088, packet=packet@entry=0x154e86467089 "ALTER TABLE t ENGINE=InnoDB", packet_length=packet_length@entry=27, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /test/10.5_dbg/sql/sql_parse.cc:1874
|
#25 0x000055a4d77175f6 in do_command (thd=0x154e86415088) at /test/10.5_dbg/sql/sql_parse.cc:1355
|
#26 0x000055a4d78729f9 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x154e88515808, put_in_cache=put_in_cache@entry=true) at /test/10.5_dbg/sql/sql_connect.cc:1411
|
#27 0x000055a4d7873115 in handle_one_connection (arg=arg@entry=0x154e88515808) at /test/10.5_dbg/sql/sql_connect.cc:1313
|
#28 0x000055a4d7cd2104 in pfs_spawn_thread (arg=0x154ea5845888) at /test/10.5_dbg/storage/perfschema/pfs.cc:2201
|
#29 0x0000154ea7af26db in start_thread (arg=0x154e9e4c1700) at pthread_create.c:463
|
#30 0x0000154ea6ef088f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
|
Bug confirmed present in:
MariaDB: 10.2.33 (dbg), 10.3.24 (dbg), 10.4.14 (dbg), 10.5.4 (dbg)
Bug confirmed not present in:
MariaDB: 10.1.46 (dbg), 10.1.46 (opt), 10.2.33 (opt), 10.3.24 (opt), 10.4.14 (opt), 10.5.4 (opt)
MySQL: 5.5.62 (dbg), 5.5.62 (opt), 5.6.47 (dbg), 5.6.47 (opt), 5.7.29 (dbg), 5.7.29 (opt), 8.0.19 (dbg), 8.0.19 (opt)
Attachments
Activity
A slightly different stack with this testcase:
CREATE TABLE t (a CHAR(255) CHARACTER SET UTF32,KEY k1 (a (254))) ENGINE=InnoDB; |
INSERT INTO t VALUES(); |
!field->prefix_len || field->fixed_len == field->prefix_len|SIGABRT|btr_node_ptr_max_size|btr_cur_search_to_nth_level|row_ins_sec_index_entry_low|row_ins_sec_index_entry
|
Found an additional stack with this testcase:
CREATE TABLE t (c CHAR(255) CHARACTER SET UTF32,KEY(c(254))) ENGINE=InnoDB ; |
INSERT INTO t VALUES (2),(4),(6),(8),(10),(12),(14),(16),(18),(20),(22),(24),(26),(23),(27); |
INSERT INTO t VALUES (0xA9DB); |
Leads to:
!field->prefix_len || field->fixed_len == field->prefix_len|SIGABRT|btr_node_ptr_max_size|btr_cur_t::search_leaf|row_ins_sec_index_entry_low|row_ins_sec_index_entry
|
FYI, the testcase in the last comment provides a wide variety of the stacks across versions:
!field->prefix_len || field->fixed_len == field->prefix_len|SIGABRT|btr_node_ptr_max_size|btr_cur_search_to_nth_level|row_ins_sec_index_entry_low|row_ins_sec_index_entry
|
!field->prefix_len || field->fixed_len == field->prefix_len|SIGABRT|btr_node_ptr_max_size|btr_cur_t::search_leaf|row_ins_sec_index_entry_low|row_ins_sec_index_entry
|
!field->prefix_len || field->fixed_len == field->prefix_len|SIGABRT|ut_dbg_assertion_failed|dict_index_node_ptr_max_size|btr_cur_search_to_nth_level|row_ins_sec_index_entry_low
|
SIGABRT|my_server_abort|my_abort|ut_dbg_assertion_failed|dict_index_node_ptr_max_size
|
So it is likely a good candidate as main MTR test.
The assertion would fail during the very first call to ha_innobase::write_row(), as part of the ALTER TABLE statement.
|
10.5 55cb2c2916a26b699ed8260427002243682c7110 |
(rr) p *field
|
$1 = {col = 0x7fdf78041d00, name = {m_name = 0x7fdf78041dd8 "c"},
|
prefix_len = 1000, fixed_len = 0}
|
(rr) p *field.col
|
$2 = {prtype = 3932414, mtype = 13, len = 1020, mbminlen = 4, mbmaxlen = 4,
|
ind = 0, ord_part = 1, max_prefix = 1000, def_val = {data = 0x0,
|
len = 4294967294}}
|
If the table is created with ENGINE=InnoDB to begin with, there will be two calls to ha_innobase::write_row() but no crash:
--source include/have_innodb.inc
|
CREATE TABLE t(c CHAR(255) CHARACTER SET UTF32, KEY k1(c)) ENGINE=InnoDB; |
INSERT INTO t VALUES(100000); |
ALTER TABLE t ALGORITHM=COPY, ENGINE=InnoDB; |
If I omit the INSERT statement and replace the first ENGINE=InnoDB with ENGINE=MyISAM, there will be no crash, and the .frm files at the end would differ as follows:
000010 fd 03 00 00 00 00 00 00 00 00 00 02 1c 00 08 00
|
000020 00 05 00 00 00 00 08 00 00 00 00 00 00 00 00 f9
|
000030 01 00 00 ad 88 01 00 10 00 00 00 00 00 00 00 00
|
-000040 00 10 e3 23 db a1 02 38 11 ef 9f dc 10 7b 44 b1
|
-000050 7c 6a 5c 06 00 00 01 01 00 00 05 00 43 00 e8 03
|
-000060 01 00 00 10 01 80 02 00 00 00 80 e8 03 ff 6b 31
|
+000040 00 10 8f fd 14 c4 02 38 11 ef bc d1 10 7b 44 b1
|
+000050 7c 6a 5c 06 00 00 01 01 00 00 05 00 43 00 fc 03
|
+000060 01 00 00 00 01 80 02 00 00 00 80 fc 03 ff 6b 31
|
000070 ff 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
|
000080 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
|
*
|
Some of the .frm file format difference could be due to some UUID or timestamp, but there must be something related to the column definition as well. The SHOW CREATE TABLE output differs as well:
@@ -1,4 +1,4 @@
|
CREATE TABLE `t` (
|
`c` char(255) CHARACTER SET utf32 COLLATE utf32_general_ci DEFAULT NULL,
|
- KEY `k1` (`c`(250))
|
+ KEY `k1` (`c`)
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; |
When the table is created with ENGINE=InnoDB to begin with, an index on the full column will be defined. If it is altered from ENGINE=MyISAM, then a prefix index is supposed to be created, because apparently MyISAM is limiting the length of a key to 1000 octets.
Here is a simpler test case to reproduce the InnoDB bug:
--source include/have_innodb.inc
|
CREATE TABLE t(c CHAR(255) CHARACTER SET UTF32, KEY k1(c(250))) ENGINE=InnoDB; |
INSERT INTO t VALUES(100000); |
|
10.5 55cb2c2916a26b699ed8260427002243682c7110 |
mariadbd: /mariadb/10.5/storage/innobase/btr/btr0cur.cc:1123: ulint btr_node_ptr_max_size(const dict_index_t*): Assertion `!field->prefix_len || field->fixed_len == field->prefix_len' failed.
|
Similar but not identical testcase and stack.
Leads to:
10.10.0 e1caa4bd5e8b4645944b85d4b603bf9fc9ef6ca4 (Debug)
mysqld: /test/10.10_dbg/storage/innobase/btr/btr0cur.cc:1091: ulint btr_node_ptr_max_size(const dict_index_t*): Assertion `!field->prefix_len || field->fixed_len == field->prefix_len' failed.10.10.0 e1caa4bd5e8b4645944b85d4b603bf9fc9ef6ca4 (Debug)
Core was generated by `/test/MD290722-mariadb-10.10.0-linux-x86_64-dbg/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 0x153e2c059700 (LWP 1671381))](gdb) bt#0 __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50#1 0x0000153e463db859 in __GI_abort () at abort.c:79#2 0x0000153e463db729 in __assert_fail_base (fmt=0x153e46571588 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=0x56281d6ff9c0 "!field->prefix_len || field->fixed_len == field->prefix_len", file=0x56281d6ff8b0 "/test/10.10_dbg/storage/innobase/btr/btr0cur.cc", line=1091, function=<optimized out>) at assert.c:92#3 0x0000153e463ecfd6 in __GI___assert_fail (assertion=assertion@entry=0x56281d6ff9c0 "!field->prefix_len || field->fixed_len == field->prefix_len", file=file@entry=0x56281d6ff8b0 "/test/10.10_dbg/storage/innobase/btr/btr0cur.cc", line=line@entry=1091, function=function@entry=0x56281d6ff988 "ulint btr_node_ptr_max_size(const dict_index_t*)") at assert.c:101#4 0x000056281d105989 in btr_node_ptr_max_size (index=index@entry=0x153d94025080) at /test/10.10_dbg/storage/innobase/btr/btr0cur.cc:1091#5 0x000056281d11ec96 in btr_cur_search_to_nth_level_func (index=index@entry=0x153d94025080, level=level@entry=0, tuple=tuple@entry=0x153d94073560, mode=mode@entry=PAGE_CUR_LE, latch_mode=<optimized out>, latch_mode@entry=130, cursor=cursor@entry=0x153e2c056f00, ahi_latch=0x0, mtr=0x153e2c057170, autoinc=0) at /test/10.10_dbg/storage/innobase/btr/btr0cur.cc:1495#6 0x000056281d051b60 in btr_pcur_open_low (mtr=0x153e2c057170, autoinc=0, cursor=0x153e2c056f00, latch_mode=130, mode=PAGE_CUR_LE, tuple=0x153d94073560, level=0, index=0x153d94025080) at /test/10.10_dbg/storage/innobase/include/btr0pcur.inl:346#7 row_search_index_entry (index=index@entry=0x153d94025080, entry=entry@entry=0x153d94073560, mode=130, pcur=pcur@entry=0x153e2c056f00, mtr=mtr@entry=0x153e2c057170) at /test/10.10_dbg/storage/innobase/row/row0row.cc:1304#8 0x000056281d0784a2 in row_upd_sec_index_entry (node=node@entry=0x153d94070b80, thr=thr@entry=0x153d94070e48) at /test/10.10_dbg/storage/innobase/row/row0upd.cc:1939#9 0x000056281d07ba62 in row_upd_sec_step (thr=0x153d94070e48, node=0x153d94070b80) at /test/10.10_dbg/storage/innobase/row/row0upd.cc:2094#10 row_upd (thr=0x153d94070e48, node=0x153d94070b80) at /test/10.10_dbg/storage/innobase/row/row0upd.cc:2818#11 row_upd_step (thr=thr@entry=0x153d94070e48) at /test/10.10_dbg/storage/innobase/row/row0upd.cc:2933#12 0x000056281d022cce in row_update_for_mysql (prebuilt=0x153d9402a3a0) at /test/10.10_dbg/storage/innobase/row/row0mysql.cc:1689#13 0x000056281ce9b636 in ha_innobase::delete_row (this=0x153d940292a0, record=0x153d94029b10 <incomplete sequence \375>) at /test/10.10_dbg/storage/innobase/handler/ha_innodb.cc:8706#14 0x000056281cb99af3 in handler::ha_delete_row (this=0x153d940292a0, buf=0x153d94029b10 <incomplete sequence \375>) at /test/10.10_dbg/sql/handler.cc:7683#15 0x000056281c84936c in TABLE::delete_row (this=0x153d94028a58) at /test/10.10_dbg/sql/sql_delete.cc:281#16 multi_delete::send_data (this=0x153d94014c08, values=<optimized out>) at /test/10.10_dbg/sql/sql_delete.cc:1376#17 0x000056281c914ff9 in select_result_sink::send_data_with_check (sent=<optimized out>, u=<optimized out>, items=@0x153d94005a90: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x153d94014bb8, last = 0x153d94014bb8, elements = 1}, <No data fields>}, this=<optimized out>) at /test/10.10_dbg/sql/sql_class.h:5699#18 end_send (join=0x153d94014c70, join_tab=0x153d940163c8, end_of_records=<optimized out>) at /test/10.10_dbg/sql/sql_select.cc:22976#19 0x000056281c8e5d13 in evaluate_join_record (join=join@entry=0x153d94014c70, join_tab=join_tab@entry=0x153d94016010, error=error@entry=0) at /test/10.10_dbg/sql/sql_select.cc:21970#20 0x000056281c8fa1bb in sub_select (join=0x153d94014c70, join_tab=0x153d94016010, end_of_records=false) at /test/10.10_dbg/sql/sql_select.cc:21740#21 0x000056281c930397 in do_select (procedure=<optimized out>, join=0x153d94014c70) at /test/10.10_dbg/sql/sql_select.cc:21285#22 JOIN::exec_inner (this=this@entry=0x153d94014c70) at /test/10.10_dbg/sql/sql_select.cc:4804#23 0x000056281c930930 in JOIN::exec (this=this@entry=0x153d94014c70) at /test/10.10_dbg/sql/sql_select.cc:4582#24 0x000056281c92e6b4 in mysql_select (thd=thd@entry=0x153d94000db8, tables=0x153d94014448, fields=@0x153d94005a90: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x153d94014bb8, last = 0x153d94014bb8, elements = 1}, <No data fields>}, conds=conds@entry=0x0, og_num=og_num@entry=0, order=order@entry=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2202446072704, result=0x153d94014c08, unit=0x153d94004ff0, select_lex=0x153d940057f0) at /test/10.10_dbg/sql/sql_select.cc:5062#25 0x000056281c8a7e91 in mysql_execute_command (thd=thd@entry=0x153d94000db8, is_called_from_prepared_stmt=is_called_from_prepared_stmt@entry=false) at /test/10.10_dbg/sql/sql_parse.cc:4862#26 0x000056281c893534 in mysql_parse (thd=thd@entry=0x153d94000db8, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x153e2c058330) at /test/10.10_dbg/sql/sql_parse.cc:8037#27 0x000056281c8a0b1c in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x153d94000db8, packet=packet@entry=0x153d9400b6e9 "DELETE t2.* FROM t t2", packet_length=packet_length@entry=21, blocking=blocking@entry=true) at /test/10.10_dbg/sql/sql_class.h:1366#28 0x000056281c8a3226 in do_command (thd=0x153d94000db8, blocking=blocking@entry=true) at /test/10.10_dbg/sql/sql_parse.cc:1407#29 0x000056281ca04744 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x56281ff84498, put_in_cache=put_in_cache@entry=true) at /test/10.10_dbg/sql/sql_connect.cc:1418#30 0x000056281ca04c4d in handle_one_connection (arg=0x56281ff84498) at /test/10.10_dbg/sql/sql_connect.cc:1312#31 0x0000153e468ec609 in start_thread (arg=<optimized out>) at pthread_create.c:477#32 0x0000153e464d8133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95MySQL 5.7.38 (Debug)
InnoDB: Failing assertion: !field->prefix_len || field->fixed_len == field->prefix_lenMySQL 5.7.38 (Debug)
Core was generated by `/test/MS310522-mysql-5.7.38-linux-x86_64-dbg/bin/mysqld --no-defaults --core-fi'.Program terminated with signal SIGABRT, Aborted.#0 __pthread_kill (threadid=<optimized out>, signo=signo@entry=6)at ../sysdeps/unix/sysv/linux/pthread_kill.c:56[Current thread is 1 (Thread 0x14e905a49700 (LWP 1675662))](gdb) bt#0 __pthread_kill (threadid=<optimized out>, signo=signo@entry=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:56#1 0x000055bfe3ba9315 in my_write_core (sig=sig@entry=6) at /test/5.7_dbg/include/my_thread.h:105#2 0x000055bfe325552d in handle_fatal_signal (sig=6) at /test/5.7_dbg/sql/signal_handler.cc:227#3 <signal handler called>#4 __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50#5 0x000014e921a00859 in __GI_abort () at abort.c:79#6 0x000055bfe3e71906 in ut_dbg_assertion_failed (expr=expr@entry=0x55bfe43fcf08 "!field->prefix_len || field->fixed_len == field->prefix_len", file=file@entry=0x55bfe43fce70 "/test/5.7_dbg/storage/innobase/dict/dict0dict.cc", line=line@entry=2376) at /test/5.7_dbg/storage/innobase/ut/ut0dbg.cc:75#7 0x000055bfe3f44419 in dict_index_node_ptr_max_size (index=index@entry=0x14e8c800b1a0) at /test/5.7_dbg/storage/innobase/dict/dict0dict.cc:2376#8 0x000055bfe3eaa351 in btr_cur_search_to_nth_level (index=index@entry=0x14e8c800b1a0, level=level@entry=0, tuple=tuple@entry=0x14e8c800c420, mode=mode@entry=PAGE_CUR_LE, latch_mode=<optimized out>, latch_mode@entry=2562, cursor=cursor@entry=0x14e905a45990, has_search_latch=0, file=0x55bfe43d34c0 "/test/5.7_dbg/storage/innobase/row/row0ins.cc", line=3033, mtr=0x14e905a45d50) at /test/5.7_dbg/storage/innobase/btr/btr0cur.cc:1032#9 0x000055bfe3d410c5 in row_ins_sec_index_entry_low (flags=flags@entry=0, mode=mode@entry=2, index=index@entry=0x14e8c800b1a0, offsets_heap=<optimized out>, offsets_heap@entry=0x14e8c801f958, heap=heap@entry=0x14e8c80220d8, entry=entry@entry=0x14e8c800c420, trx_id=0, thr=0x14e8c8024198, dup_chk_only=false) at /test/5.7_dbg/storage/innobase/row/row0ins.cc:3030#10 0x000055bfe3d424e9 in row_ins_sec_index_entry (index=index@entry=0x14e8c800b1a0, entry=entry@entry=0x14e8c800c420, thr=thr@entry=0x14e8c8024198, dup_chk_only=dup_chk_only@entry=false) at /test/5.7_dbg/storage/innobase/row/row0ins.cc:3415#11 0x000055bfe3d42907 in row_ins_index_entry (index=0x14e8c800b1a0, entry=0x14e8c800c420, thr=thr@entry=0x14e8c8024198) at /test/5.7_dbg/storage/innobase/row/row0ins.cc:3466#12 0x000055bfe3d429d6 in row_ins_index_entry_step (node=node@entry=0x14e8c8023b48, thr=thr@entry=0x14e8c8024198) at /test/5.7_dbg/storage/innobase/row/row0ins.cc:3614#13 0x000055bfe3d42aca in row_ins (node=node@entry=0x14e8c8023b48, thr=thr@entry=0x14e8c8024198) at /test/5.7_dbg/storage/innobase/row/row0ins.cc:3752#14 0x000055bfe3d43546 in row_ins_step (thr=thr@entry=0x14e8c8024198) at /test/5.7_dbg/storage/innobase/row/row0ins.cc:3888#15 0x000055bfe3d5ecfb in row_insert_for_mysql_using_ins_graph (mysql_rec=<optimized out>, prebuilt=<optimized out>) at /test/5.7_dbg/storage/innobase/row/row0mysql.cc:1746#16 0x000055bfe3d62c0c in row_insert_for_mysql (mysql_rec=mysql_rec@entry=0x14e8c80218b0 <incomplete sequence \375>, prebuilt=<optimized out>) at /test/5.7_dbg/storage/innobase/row/row0mysql.cc:1866#17 0x000055bfe3bfdf72 in ha_innobase::write_row (this=0x14e8c8019fc0, record=0x14e8c80218b0 <incomplete sequence \375>) at /test/5.7_dbg/storage/innobase/handler/ha_innodb.cc:7667#18 0x000055bfe32c9f8d in handler::ha_write_row (this=0x14e8c8019fc0, buf=0x14e8c80218b0 <incomplete sequence \375>) at /test/5.7_dbg/sql/handler.cc:8173#19 0x000055bfe3a93052 in write_record (thd=thd@entry=0x14e8c8000e10, table=table@entry=0x14e8c8020ef0, info=info@entry=0x14e905a472a0, update=update@entry=0x14e905a47320) at /test/5.7_dbg/sql/sql_insert.cc:1895#20 0x000055bfe3a945a5 in Sql_cmd_insert::mysql_insert (this=this@entry=0x14e8c8005bd8, thd=thd@entry=0x14e8c8000e10, table_list=table_list@entry=0x14e8c8005648) at /test/5.7_dbg/sql/sql_insert.cc:776#21 0x000055bfe3a94b02 in Sql_cmd_insert::execute (this=0x14e8c8005bd8, thd=0x14e8c8000e10) at /test/5.7_dbg/sql/sql_insert.cc:3142#22 0x000055bfe38aaa97 in mysql_execute_command (thd=thd@entry=0x14e8c8000e10, first_level=first_level@entry=true) at /test/5.7_dbg/sql/sql_parse.cc:3609#23 0x000055bfe38affd9 in mysql_parse (thd=thd@entry=0x14e8c8000e10, parser_state=parser_state@entry=0x14e905a48530) at /test/5.7_dbg/sql/sql_parse.cc:5600#24 0x000055bfe38b2231 in dispatch_command (thd=thd@entry=0x14e8c8000e10, com_data=com_data@entry=0x14e905a48df0, command=COM_QUERY) at /test/5.7_dbg/sql/sql_parse.cc:1493#25 0x000055bfe38b430e in do_command (thd=thd@entry=0x14e8c8000e10) at /test/5.7_dbg/sql/sql_parse.cc:1032#26 0x000055bfe39af428 in handle_connection (arg=arg@entry=0x55bfe6c5e080) at /test/5.7_dbg/sql/conn_handler/connection_handler_per_thread.cc:313#27 0x000055bfe40b6535 in pfs_spawn_thread (arg=0x55bfe6a09810) at /test/5.7_dbg/storage/perfschema/pfs.cc:2197#28 0x000014e921f26609 in start_thread (arg=<optimized out>) at pthread_create.c:477#29 0x000014e921afd133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95MySQL 8.0.29 (Debug)
Core was generated by `/test/MS310522-mysql-8.0.29-linux-x86_64-dbg/bin/mysqld --no-defaults --core-fi'.Program terminated with signal SIGABRT, Aborted.#0 __pthread_kill (threadid=<optimized out>, signo=signo@entry=6)at ../sysdeps/unix/sysv/linux/pthread_kill.c:56[Current thread is 1 (Thread 0x151690e5a700 (LWP 4070692))](gdb) bt#0 __pthread_kill (threadid=<optimized out>, signo=signo@entry=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:56#1 0x000056100f851553 in my_write_core (sig=sig@entry=6) at /test/8.0_dbg/include/my_thread.h:78#2 0x000056100e484038 in handle_fatal_signal (sig=6) at /test/8.0_dbg/sql/signal_handler.cc:202#3 <signal handler called>#4 __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50#5 0x00001516b4efd859 in __GI_abort () at abort.c:79#6 0x000056100e48410d in my_server_abort () at /test/8.0_dbg/sql/signal_handler.cc:258#7 0x000056100f849b59 in my_abort () at /test/8.0_dbg/mysys/my_init.cc:258#8 0x000056100fc9412e in ut_dbg_assertion_failed (expr=expr@entry=0x561010f6d720 "!field->prefix_len || field->fixed_len == field->prefix_len", file=file@entry=0x561010f6d4c8 "/test/8.0_dbg/storage/innobase/dict/dict0dict.cc", line=line@entry=2072) at /test/8.0_dbg/storage/innobase/ut/ut0dbg.cc:99#9 0x000056100fdfdfbe in dict_index_node_ptr_max_size (index=index@entry=0x1516040bc8b8) at /test/8.0_dbg/storage/innobase/dict/dict0dict.cc:2072#10 0x000056100fd1a4fd in btr_cur_search_to_nth_level (index=index@entry=0x1516040bc8b8, level=level@entry=0, tuple=tuple@entry=0x151604026b78, mode=mode@entry=PAGE_CUR_LE, latch_mode=<optimized out>, latch_mode@entry=2562, cursor=cursor@entry=0x151690e55bb0, has_search_latch=0, file=0x561010f48e68 "/test/8.0_dbg/storage/innobase/row/row0ins.cc", line=2891, mtr=0x151690e55f70) at /test/8.0_dbg/storage/innobase/btr/btr0cur.cc:888#11 0x000056100fb36fd8 in row_ins_sec_index_entry_low (flags=flags@entry=0, mode=<optimized out>, mode@entry=2, index=index@entry=0x1516040bc8b8, offsets_heap=<optimized out>, offsets_heap@entry=0x151604120200, heap=heap@entry=0x151604095a10, entry=entry@entry=0x151604026b78, trx_id=0, thr=0x151604124368, dup_chk_only=false) at /test/8.0_dbg/storage/innobase/row/row0ins.cc:2890#12 0x000056100fb3c6ca in row_ins_sec_index_entry (index=index@entry=0x1516040bc8b8, entry=entry@entry=0x151604026b78, thr=thr@entry=0x151604124368, dup_chk_only=dup_chk_only@entry=false) at /test/8.0_dbg/storage/innobase/row/row0ins.cc:3201#13 0x000056100fb3d04e in row_ins_index_entry (index=0x1516040bc8b8, entry=0x151604026b78, multi_val_pos=@0x151604123d68: 0, thr=thr@entry=0x151604124368) at /test/8.0_dbg/storage/innobase/row/row0ins.cc:3301#14 0x000056100fb3d175 in row_ins_index_entry_step (node=node@entry=0x151604123cb0, thr=thr@entry=0x151604124368) at /test/8.0_dbg/storage/innobase/row/row0ins.cc:3433#15 0x000056100fb3d7fa in row_ins (node=node@entry=0x151604123cb0, thr=thr@entry=0x151604124368) at /test/8.0_dbg/storage/innobase/row/row0ins.cc:3552#16 0x000056100fb3dcbe in row_ins_step (thr=thr@entry=0x151604124368) at /test/8.0_dbg/storage/innobase/row/row0ins.cc:3676#17 0x000056100fb4d13c in row_insert_for_mysql_using_ins_graph (mysql_rec=<optimized out>, prebuilt=<optimized out>) at /test/8.0_dbg/storage/innobase/row/row0mysql.cc:1582#18 0x000056100fb4d4f2 in row_insert_for_mysql (mysql_rec=mysql_rec@entry=0x151604122350 <incomplete sequence \375>, prebuilt=<optimized out>) at /test/8.0_dbg/storage/innobase/row/row0mysql.cc:1712#19 0x000056100f949a2d in ha_innobase::write_row (this=0x151604120c80, record=0x151604122350 <incomplete sequence \375>) at /test/8.0_dbg/storage/innobase/handler/ha_innodb.cc:8912#20 0x000056100e5e3f55 in handler::ha_write_row (this=0x151604120c80, buf=0x151604122350 <incomplete sequence \375>) at /test/8.0_dbg/sql/handler.cc:7969#21 0x000056100e9578ea in write_record (thd=thd@entry=0x151604000be0, table=table@entry=0x15160411f880, info=info@entry=0x151690e57530, update=update@entry=0x151690e575b0) at /test/8.0_dbg/sql/sql_insert.cc:2165#22 0x000056100e958380 in Sql_cmd_insert_values::execute_inner (this=0x151604099330, thd=0x151604000be0) at /test/8.0_dbg/sql/sql_insert.cc:635#23 0x000056100e33d031 in Sql_cmd_dml::execute (this=0x151604099330, thd=0x151604000be0) at /test/8.0_dbg/sql/sql_select.cc:584#24 0x000056100e2b4417 in mysql_execute_command (thd=thd@entry=0x151604000be0, first_level=first_level@entry=true) at /test/8.0_dbg/sql/sql_parse.cc:3575#25 0x000056100e2b8495 in dispatch_sql_command (thd=0x151604000be0, parser_state=parser_state@entry=0x151690e58b50) at /test/8.0_dbg/sql/sql_parse.cc:5207#26 0x000056100e2bae87 in dispatch_command (thd=<optimized out>, thd@entry=0x151604000be0, com_data=com_data@entry=0x151690e59b60, command=COM_QUERY) at /test/8.0_dbg/sql/sql_parse.cc:1957#27 0x000056100e2bdf2c in do_command (thd=thd@entry=0x151604000be0) at /test/8.0_dbg/sql/sql_parse.cc:1352#28 0x000056100e471fe0 in handle_connection (arg=arg@entry=0x5610151d1a10) at /test/8.0_dbg/sql/conn_handler/connection_handler_per_thread.cc:302#29 0x00005610100c3ecc in pfs_spawn_thread (arg=0x5610151d7110) at /test/8.0_dbg/storage/perfschema/pfs.cc:2942#30 0x00001516b58af609 in start_thread (arg=<optimized out>) at pthread_create.c:477#31 0x00001516b4ffa133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95Bug confirmed present in:
MariaDB: 10.3.36 (dbg), 10.4.26 (dbg), 10.5.17 (dbg), 10.6.9 (dbg), 10.7.5 (dbg), 10.8.4 (dbg), 10.9.2 (dbg), 10.10.0 (dbg)
MySQL: 5.7.38 (dbg), 8.0.29 (dbg)
Bug (or feature/syntax) confirmed not present in:
MariaDB: 10.3.36 (opt), 10.4.26 (opt), 10.5.17 (opt), 10.6.9 (opt), 10.7.5 (opt), 10.8.4 (opt), 10.9.2 (opt), 10.10.0 (opt)
MySQL: 5.5.62 (dbg), 5.5.62 (opt), 5.6.51 (dbg), 5.6.51 (opt), 5.7.38 (opt), 8.0.29 (opt)
UniqueID's/stacks seen for this testcase across versions (MariaDB + MySQL)
!field->prefix_len || field->fixed_len == field->prefix_len|SIGABRT|btr_node_ptr_max_size|btr_cur_search_to_nth_level_func|btr_pcur_open_low|row_search_index_entry!field->prefix_len || field->fixed_len == field->prefix_len|SIGABRT|btr_node_ptr_max_size|btr_cur_search_to_nth_level_func|row_ins_sec_index_entry_low|row_ins_sec_index_entry!field->prefix_len || field->fixed_len == field->prefix_len|SIGABRT|ut_dbg_assertion_failed|dict_index_node_ptr_max_size|btr_cur_search_to_nth_level|row_ins_sec_index_entry_lowSIGABRT|my_server_abort|my_abort|ut_dbg_assertion_failed|dict_index_node_ptr_max_sizeThe second one of this list is also the one for the original testcase of this bug. Please add both testcases to MTR. Thank you