[MDEV-22365] Assertion `!col->mbmaxlen || len >= col->mbminlen * (fixed_len / col->mbmaxlen)' failed in row_merge_buf_add Created: 2020-04-24  Updated: 2022-07-28  Resolved: 2022-07-21

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - InnoDB
Affects Version/s: 10.4, 10.5
Fix Version/s: 10.4.14, 10.5.5

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Thirunarayanan Balathandayuthapani
Resolution: Duplicate Votes: 0
Labels: not-10.1, not-10.2, not-10.3, regression

Issue Links:
Blocks
is blocked by MDEV-26294 Duplicate entries in unique index not... Closed
Duplicate
duplicates MDEV-22771 Assertion `fields[i].same(instant.fie... Closed
Relates
relates to MDEV-22334 Assertion `col->len == len' failed in... Closed

 Description   

Very likely to be related to, or a duplicate of, MDEV-22334. However, it didn't fail for me on 10.4.3, so it's probably not caused by MDEV-15564 directly.

--source include/have_innodb.inc
 
 
 
CREATE TABLE t1 (a CHAR(3) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL) ENGINE=InnoDB;
 
INSERT INTO t1 VALUES ('foo');
 
ALTER TABLE t1 MODIFY a CHAR(6);
 
 
 
# Cleanup
 
DROP TABLE t1;

10.4 9398c3df

 
mysqld: /data/src/10.4/storage/innobase/row/row0merge.cc:770: ulint row_merge_buf_add(row_merge_buf_t*, dict_index_t*, const dict_table_t*, const dict_table_t*, fts_psort_t*, dtuple_t*, const row_ext_t*, doc_id_t*, mem_heap_t*, dberr_t*, mem_heap_t**, TABLE*, trx_t*): Assertion `!col->mbmaxlen || len >= col->mbminlen * (fixed_len / col->mbmaxlen)' failed.
 
200424 15:44:02 [ERROR] mysqld got signal 6 ;
 
 
 
#6  0x00007f1f1bbb040f in __assert_fail_base (fmt=0x7f1f1bd12ee0 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=0x55833b6ad8a0 "!col->mbmaxlen || len >= col->mbminlen * (fixed_len / col->mbmaxlen)", file=0x55833b6ad060 "/data/src/10.4/storage/innobase/row/row0merge.cc", line=770, function=<optimized out>) at assert.c:92
 
#7  0x00007f1f1bbbe102 in __GI___assert_fail (assertion=0x55833b6ad8a0 "!col->mbmaxlen || len >= col->mbminlen * (fixed_len / col->mbmaxlen)", file=0x55833b6ad060 "/data/src/10.4/storage/innobase/row/row0merge.cc", line=770, function=0x55833b6b3820 <row_merge_buf_add(row_merge_buf_t*, dict_index_t*, dict_table_t const*, dict_table_t const*, fts_psort_t*, dtuple_t*, row_ext_t const*, unsigned long*, mem_block_info_t*, dberr_t*, mem_block_info_t**, TABLE*, trx_t*)::__PRETTY_FUNCTION__> "ulint row_merge_buf_add(row_merge_buf_t*, dict_index_t*, const dict_table_t*, const dict_table_t*, fts_psort_t*, dtuple_t*, const row_ext_t*, doc_id_t*, mem_heap_t*, dberr_t*, mem_heap_t**, TABLE*, tr"...) at assert.c:101
 
#8  0x000055833a39de2d in row_merge_buf_add (buf=0x615000032108, fts_index=0x0, old_table=0x6190000ede08, new_table=0x6190000f4708, psort_info=0x0, row=0x6310000b48b0, ext=0x0, doc_id=0x7f1f05d09120, conv_heap=0x0, err=0x7f1f05d09020, v_heap=0x7f1f05d090e0, my_table=0x7f1f05d0d1c0, trx=0x7f1f1291a930) at /data/src/10.4/storage/innobase/row/row0merge.cc:770
 
#9  0x000055833a3a9e09 in row_merge_read_clustered_index (trx=0x7f1f1291a930, table=0x7f1f05d0d1c0, old_table=0x6190000ede08, new_table=0x6190000f4708, online=true, index=0x6190000f4410, fts_sort_idx=0x0, psort_info=0x0, files=0x6030000579d0, key_numbers=0x6190000f4420, n_index=1, defaults=0x0, add_v=0x0, col_map=0x6190000f4498, add_autoinc=18446744073709551615, sequence=..., block=0x7f1f057ba000 "", skip_pk_sort=true, tmpfd=0x7f1f05d0a0f0, stage=0x60700001ac00, pct_cost=50, crypt_block=0x0, eval_table=0x7f1f05d0d1c0, allow_not_null=false) at /data/src/10.4/storage/innobase/row/row0merge.cc:2359
 
#10 0x000055833a3b950b in row_merge_build_indexes (trx=0x7f1f1291a930, old_table=0x6190000ede08, new_table=0x6190000f4708, online=true, indexes=0x6190000f4410, key_numbers=0x6190000f4420, n_indexes=1, table=0x7f1f05d0d1c0, defaults=0x0, col_map=0x6190000f4498, add_autoinc=18446744073709551615, sequence=..., skip_pk_sort=true, stage=0x60700001ac00, add_v=0x0, eval_table=0x7f1f05d0d1c0, allow_not_null=false) at /data/src/10.4/storage/innobase/row/row0merge.cc:4705
 
#11 0x000055833a130cf9 in ha_innobase::inplace_alter_table (this=0x61d00025a910, altered_table=0x7f1f05d0d1c0, ha_alter_info=0x7f1f05d0b7a0) at /data/src/10.4/storage/innobase/handler/handler0alter.cc:8397
 
#12 0x000055833958f178 in handler::ha_inplace_alter_table (this=0x61d00025a910, altered_table=0x7f1f05d0d1c0, ha_alter_info=0x7f1f05d0b7a0) at /data/src/10.4/sql/handler.h:4368
 
#13 0x00005583395725e0 in mysql_inplace_alter_table (thd=0x62b00009a270, table_list=0x62b0000a13a8, table=0x62000003c0f0, altered_table=0x7f1f05d0d1c0, ha_alter_info=0x7f1f05d0b7a0, inplace_supported=HA_ALTER_INPLACE_COPY_NO_LOCK, target_mdl_request=0x7f1f05d0b980, alter_ctx=0x7f1f05d0c720) at /data/src/10.4/sql/sql_table.cc:7722
 
#14 0x00005583395835a0 in mysql_alter_table (thd=0x62b00009a270, new_db=0x62b00009ea30, new_name=0x62b00009ee38, create_info=0x7f1f05d0e1f0, table_list=0x62b0000a13a8, alter_info=0x7f1f05d0e110, order_num=0, order=0x0, ignore=false) at /data/src/10.4/sql/sql_table.cc:10127
 
#15 0x00005583396fc575 in Sql_cmd_alter_table::execute (this=0x62b0000a1bc8, thd=0x62b00009a270) at /data/src/10.4/sql/sql_alter.cc:502
 
#16 0x000055833932f1c0 in mysql_execute_command (thd=0x62b00009a270) at /data/src/10.4/sql/sql_parse.cc:6101
 
#17 0x000055833933abeb in mysql_parse (thd=0x62b00009a270, rawbuf=0x62b0000a1290 "ALTER TABLE t1 MODIFY a CHAR(6)", length=31, parser_state=0x7f1f05d10a70, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:7900
 
#18 0x0000558339310909 in dispatch_command (command=COM_QUERY, thd=0x62b00009a270, packet=0x629000285271 "ALTER TABLE t1 MODIFY a CHAR(6)", packet_length=31, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:1841
 
#19 0x000055833930d334 in do_command (thd=0x62b00009a270) at /data/src/10.4/sql/sql_parse.cc:1359
 
#20 0x00005583396e44fe in do_handle_one_connection (connect=0x6110000439f0) at /data/src/10.4/sql/sql_connect.cc:1412
 
#21 0x00005583396e3da0 in handle_one_connection (arg=0x6110000439f0) at /data/src/10.4/sql/sql_connect.cc:1316
 
#22 0x000055833ad05fab in pfs_spawn_thread (arg=0x616000032df0) at /data/src/10.4/storage/perfschema/pfs.cc:1869
 
#23 0x00007f1f1c438fa3 in start_thread (arg=<optimized out>) at pthread_create.c:486
 
#24 0x00007f1f1bc874cf in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95

Reproducible on current 10.4, 10.5.
Reproducible on 10.4.10, not reproducible on 10.4.3, I didn't bisect in between.
Not reproducible on 10.3.
No obvious problem on a non-debug build.

 Comments   
Comment by Roel Van de Paar [ 2020-07-06 ] 

CREATE DATABASE test;
 
USE test;
 
CREATE TABLE t (a BLOB NOT NULL, b DATE NOT NULL);
 
ALTER TABLE t CHANGE COLUMN a a CHAR(150) BINARY;
 
INSERT INTO t VALUES (1261,0);
 
ALTER TABLE t CHANGE COLUMN a a CHAR(200) NOT NULL;

Leads to:

10.5.5 e1013725ce0f3f947e728491eef75d9985e8db2f

 
mysqld: /test/10.5_dbg/storage/innobase/row/row0merge.cc:766: ulint row_merge_buf_add(row_merge_buf_t*, dict_index_t*, const dict_table_t*, const dict_table_t*, fts_psort_t*, dtuple_t*, const row_ext_t*, doc_id_t*, mem_heap_t*, dberr_t*, mem_heap_t**, TABLE*, trx_t*): Assertion `!col->mbmaxlen || len >= col->mbminlen * (fixed_len / col->mbmaxlen)' failed.

10.5.5 e1013725ce0f3f947e728491eef75d9985e8db2f

 
Core was generated by `/test/MD250620-mariadb-10.5.5-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 0x15111f359700 (LWP 2772695))]
 
(gdb) bt
 
#0  __pthread_kill (threadid=<optimized out>, signo=signo@entry=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:57
 
#1  0x000055d8ebb647d0 in my_write_core (sig=sig@entry=6) at /test/10.5_dbg/mysys/stacktrace.c:518
 
#2  0x000055d8eb31d47a 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  0x000015111d5ef801 in __GI_abort () at abort.c:79
 
#6  0x000015111d5df39a in __assert_fail_base (fmt=0x15111d7667d8 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x55d8ebfad0a8 "!col->mbmaxlen || len >= col->mbminlen * (fixed_len / col->mbmaxlen)", file=file@entry=0x55d8ebfaca68 "/test/10.5_dbg/storage/innobase/row/row0merge.cc", line=line@entry=766, function=function@entry=0x55d8ebfae200 <row_merge_buf_add(row_merge_buf_t*, dict_index_t*, dict_table_t const*, dict_table_t const*, fts_psort_t*, dtuple_t*, row_ext_t const*, unsigned long*, mem_block_info_t*, dberr_t*, mem_block_info_t**, TABLE*, trx_t*)::__PRETTY_FUNCTION__> "ulint row_merge_buf_add(row_merge_buf_t*, dict_index_t*, const dict_table_t*, const dict_table_t*, fts_psort_t*, dtuple_t*, const row_ext_t*, doc_id_t*, mem_heap_t*, dberr_t*, mem_heap_t**, TABLE*, tr"...) at assert.c:92
 
#7  0x000015111d5df412 in __GI___assert_fail (assertion=assertion@entry=0x55d8ebfad0a8 "!col->mbmaxlen || len >= col->mbminlen * (fixed_len / col->mbmaxlen)", file=file@entry=0x55d8ebfaca68 "/test/10.5_dbg/storage/innobase/row/row0merge.cc", line=line@entry=766, function=function@entry=0x55d8ebfae200 <row_merge_buf_add(row_merge_buf_t*, dict_index_t*, dict_table_t const*, dict_table_t const*, fts_psort_t*, dtuple_t*, row_ext_t const*, unsigned long*, mem_block_info_t*, dberr_t*, mem_block_info_t**, TABLE*, trx_t*)::__PRETTY_FUNCTION__> "ulint row_merge_buf_add(row_merge_buf_t*, dict_index_t*, const dict_table_t*, const dict_table_t*, fts_psort_t*, dtuple_t*, const row_ext_t*, doc_id_t*, mem_heap_t*, dberr_t*, mem_heap_t**, TABLE*, tr"...) at assert.c:101
 
#8  0x000055d8eb84a384 in row_merge_buf_add (buf=buf@entry=0x1510fc126778, fts_index=fts_index@entry=0x0, old_table=old_table@entry=0x1510fc054398, new_table=new_table@entry=0x1510fc057a98, psort_info=psort_info@entry=0x0, row=row@entry=0x1510fc1bc0b8, ext=<optimized out>, doc_id=<optimized out>, conv_heap=<optimized out>, err=<optimized out>, v_heap=<optimized out>, my_table=<optimized out>, trx=<optimized out>) at /test/10.5_dbg/storage/innobase/row/row0merge.cc:766
 
#9  0x000055d8eb84e46c in row_merge_read_clustered_index (allow_not_null=<optimized out>, eval_table=<optimized out>, crypt_block=<optimized out>, pct_cost=<optimized out>, stage=<optimized out>, tmpfd=0x15111f3534a0, skip_pk_sort=<optimized out>, block=<optimized out>, sequence=<optimized out>, add_autoinc=<optimized out>, col_map=<optimized out>, add_v=<optimized out>, defaults=<optimized out>, n_index=<optimized out>, key_numbers=<optimized out>, files=<optimized out>, psort_info=<optimized out>, fts_sort_idx=<optimized out>, index=0x1510fc057770, online=<optimized out>, new_table=<optimized out>, old_table=<optimized out>, table=<optimized out>, trx=<optimized out>) at /test/10.5_dbg/storage/innobase/row/row0merge.cc:2356
 
#10 row_merge_build_indexes (trx=<optimized out>, old_table=<optimized out>, new_table=<optimized out>, online=<optimized out>, indexes=0x1510fc057770, key_numbers=<optimized out>, n_indexes=<optimized out>, table=<optimized out>, defaults=<optimized out>, col_map=<optimized out>, add_autoinc=<optimized out>, sequence=<optimized out>, skip_pk_sort=<optimized out>, stage=<optimized out>, add_v=<optimized out>, eval_table=<optimized out>, allow_not_null=<optimized out>) at /test/10.5_dbg/storage/innobase/row/row0merge.cc:4533
 
#11 0x000055d8eb718ccc in ha_innobase::inplace_alter_table (this=0x1510fc0380a0, altered_table=0x15111f3549e0, ha_alter_info=0x15111f354940) at /test/10.5_dbg/storage/innobase/handler/handler0alter.cc:8384
 
#12 0x000055d8eb139a3c in handler::ha_inplace_alter_table (ha_alter_info=0x15111f354940, altered_table=0x15111f3549e0, this=<optimized out>) at /test/10.5_dbg/sql/handler.h:4525
 
#13 mysql_inplace_alter_table (thd=thd@entry=0x1510fc015088, table_list=0x1510fc0741b8, table=table@entry=0x1510fc0fa088, altered_table=altered_table@entry=0x15111f3549e0, ha_alter_info=ha_alter_info@entry=0x15111f354940, inplace_supported=inplace_supported@entry=HA_ALTER_INPLACE_COPY_NO_LOCK, target_mdl_request=0x15111f3557a0, alter_ctx=0x15111f356630) at /test/10.5_dbg/sql/sql_table.cc:8023
 
#14 0x000055d8eb14a1f4 in mysql_alter_table (thd=thd@entry=0x1510fc015088, new_db=new_db@entry=0x1510fc019948, new_name=new_name@entry=0x1510fc019d50, create_info=create_info@entry=0x15111f357220, table_list=<optimized out>, table_list@entry=0x1510fc0741b8, alter_info=alter_info@entry=0x15111f357150, order_num=0, order=0x0, ignore=false, if_exists=false) at /test/10.5_dbg/sql/sql_table.cc:10595
 
#15 0x000055d8eb1cdf92 in Sql_cmd_alter_table::execute (this=<optimized out>, thd=0x1510fc015088) at /test/10.5_dbg/sql/sql_alter.cc:532
 
#16 0x000055d8eb077d26 in mysql_execute_command (thd=thd@entry=0x1510fc015088) at /test/10.5_dbg/sql/sql_parse.cc:5953
 
#17 0x000055d8eb07f638 in mysql_parse (thd=thd@entry=0x1510fc015088, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x15111f358350, 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:7995
 
#18 0x000055d8eb06c110 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x1510fc015088, packet=packet@entry=0x1510fc067089 "ALTER TABLE t CHANGE COLUMN a a CHAR(200) NOT NULL", packet_length=packet_length@entry=50, 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
 
#19 0x000055d8eb06a8ea in do_command (thd=0x1510fc015088) at /test/10.5_dbg/sql/sql_parse.cc:1355
 
#20 0x000055d8eb1c615f in do_handle_one_connection (connect=<optimized out>, connect@entry=0x1510fe4d2028, put_in_cache=put_in_cache@entry=true) at /test/10.5_dbg/sql/sql_connect.cc:1411
 
#21 0x000055d8eb1c687b in handle_one_connection (arg=arg@entry=0x1510fe4d2028) at /test/10.5_dbg/sql/sql_connect.cc:1313
 
#22 0x000055d8eb62911c in pfs_spawn_thread (arg=0x15111c046508) at /test/10.5_dbg/storage/perfschema/pfs.cc:2201
 
#23 0x000015111e2d26db in start_thread (arg=0x15111f359700) at pthread_create.c:463
 
#24 0x000015111d6d088f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95

Bug confirmed present in:
MariaDB: 10.4.14 (dbg), 10.5.5 (dbg)

Bug confirmed not present in:
MariaDB: 10.1.46 (dbg), 10.1.46 (opt), 10.2.33 (dbg), 10.2.33 (opt), 10.3.24 (dbg), 10.3.24 (opt), 10.4.14 (opt), 10.5.5 (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)

Comment by Marko Mäkelä [ 2022-02-21 ]

This could share a root cause with MDEV-26294.

Generated at Thu Feb 08 09:14:10 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.