[MDEV-22365] Assertion `!col->mbmaxlen || len >= col->mbminlen * (fixed_len / col->mbmaxlen)' failed in row_merge_buf_add - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Duplicate
Affects Version/s: 10.4(EOL), 10.5
Fix Version/s: 10.4.14, 10.5.5
Component/s: Storage Engine - InnoDB
Labels:
- not-10.1
- not-10.2
- not-10.3
- regression

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.

Attachments

Issue Links

duplicates

MDEV-22771 Assertion `fields[i].same(instant.fields[i])' failed in dict_index_t::instant_add_field

Closed

is blocked by

MDEV-26294 Duplicate entries in unique index not detected when changing collation with INPLACE / NOCOPY algoritm

Closed

relates to

MDEV-22334 Assertion `col->len == len' failed in innobase_rename_or_enlarge_column_try on ALTER

Closed

Activity

Ascending order - Click to sort in descending order

Roel Van de Paar added a comment - 2020-07-06 11:58

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)

Roel Van de Paar added a comment - 2020-07-06 11:58 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)

Marko Mäkelä added a comment - 2022-02-21 13:59

This could share a root cause with ~~MDEV-26294~~.

Marko Mäkelä added a comment - 2022-02-21 13:59 This could share a root cause with MDEV-26294 .

MariaDB Server

Assertion `!col->mbmaxlen || len >= col->mbminlen * (fixed_len / col->mbmaxlen)' failed in row_merge_buf_add

Details

Description

Attachments

Issue Links

Activity

People

Dates

Git Integration