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

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

    XMLWordPrintable

    Details

      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

            Activity

              People

              Assignee:
              thiru Thirunarayanan Balathandayuthapani
              Reporter:
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Git Integration

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