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

Assertion `index.fields[i].col->same_format( *oindex.fields[i].col)' failed in dict_table_t::prepare_instant

    XMLWordPrintable

    Details

      Description

      --source include/have_innodb.inc
       
      CREATE TABLE t1 (a CHAR NOT NULL) ENGINE=InnoDB ROW_FORMAT=REDUNDANT;
      ALTER TABLE t1 DEFAULT COLLATE = latin1_general_cs;
      ALTER TABLE t1 MODIFY a CHAR, ALGORITHM=INSTANT;
       
      # Cleanup
      DROP TABLE t1;
      

      10.4 e9c1701e

      mysqld: /data/src/10.4/storage/innobase/handler/handler0alter.cc:270: void dict_table_t::prepare_instant(const dict_table_t&, const ulint*, unsigned int&): Assertion `index.fields[i].col->same_format( *oindex.fields[i].col)' failed.
      190727 15:29:08 [ERROR] mysqld got signal 6 ;
       
      #6  0x00007fc42aaa4e67 in __assert_fail_base (fmt=<optimized out>, assertion=assertion@entry=0x5640e67131a8 "index.fields[i].col->same_format( *oindex.fields[i].col)", file=file@entry=0x5640e6712f38 "/data/src/10.4/storage/innobase/handler/handler0alter.cc", line=line@entry=270, function=function@entry=0x5640e671b7c0 <dict_table_t::prepare_instant(dict_table_t const&, unsigned long const*, unsigned int&)::__PRETTY_FUNCTION__> "void dict_table_t::prepare_instant(const dict_table_t&, const ulint*, unsigned int&)") at assert.c:92
      #7  0x00007fc42aaa4f12 in __GI___assert_fail (assertion=0x5640e67131a8 "index.fields[i].col->same_format( *oindex.fields[i].col)", file=0x5640e6712f38 "/data/src/10.4/storage/innobase/handler/handler0alter.cc", line=270, function=0x5640e671b7c0 <dict_table_t::prepare_instant(dict_table_t const&, unsigned long const*, unsigned int&)::__PRETTY_FUNCTION__> "void dict_table_t::prepare_instant(const dict_table_t&, const ulint*, unsigned int&)") at assert.c:101
      #8  0x00005640e5ed0dfb in dict_table_t::prepare_instant (this=0x7fc3d81424b8, old=..., col_map=0x7fc3d8142268, first_alter_pos=@0x7fc3d80146d8: 0) at /data/src/10.4/storage/innobase/handler/handler0alter.cc:270
      #9  0x00005640e5ed63d8 in ha_innobase_inplace_ctx::prepare_instant (this=0x7fc3d8014570) at /data/src/10.4/storage/innobase/handler/handler0alter.cc:1070
      #10 0x00005640e5ebfae8 in prepare_inplace_alter_table_dict (ha_alter_info=0x7fc4240717c0, altered_table=0x7fc424071850, old_table=0x7fc3d8151630, table_name=0x7fc3d800be8d "t1", flags=0, flags2=80, fts_doc_id_col=18446744073709551615, add_fts_doc_id=false, add_fts_doc_id_idx=false) at /data/src/10.4/storage/innobase/handler/handler0alter.cc:6688
      #11 0x00005640e5ec4e07 in ha_innobase::prepare_inplace_alter_table (this=0x7fc3d8152498, altered_table=0x7fc424071850, ha_alter_info=0x7fc4240717c0) at /data/src/10.4/storage/innobase/handler/handler0alter.cc:8154
      #12 0x00005640e5c5cb5b in handler::ha_prepare_inplace_alter_table (this=0x7fc3d8152498, altered_table=0x7fc424071850, ha_alter_info=0x7fc4240717c0) at /data/src/10.4/sql/handler.cc:4555
      #13 0x00005640e59f8e33 in mysql_inplace_alter_table (thd=0x7fc3d8000b00, table_list=0x7fc3d8013220, table=0x7fc3d8151630, altered_table=0x7fc424071850, ha_alter_info=0x7fc4240717c0, inplace_supported=HA_ALTER_INPLACE_INSTANT, target_mdl_request=0x7fc424072620, alter_ctx=0x7fc424073150) at /data/src/10.4/sql/sql_table.cc:7632
      #14 0x00005640e59ffb25 in mysql_alter_table (thd=0x7fc3d8000b00, new_db=0x7fc3d80052b0, new_name=0x7fc3d80056b8, create_info=0x7fc424073d30, table_list=0x7fc3d8013220, alter_info=0x7fc424073c70, order_num=0, order=0x0, ignore=false) at /data/src/10.4/sql/sql_table.cc:10029
      #15 0x00005640e5a91413 in Sql_cmd_alter_table::execute (this=0x7fc3d80139f8, thd=0x7fc3d8000b00) at /data/src/10.4/sql/sql_alter.cc:508
      #16 0x00005640e591f0e5 in mysql_execute_command (thd=0x7fc3d8000b00) at /data/src/10.4/sql/sql_parse.cc:6098
      #17 0x00005640e5924355 in mysql_parse (thd=0x7fc3d8000b00, rawbuf=0x7fc3d8013118 "ALTER TABLE t1 MODIFY a CHAR, ALGORITHM=INSTANT", length=47, parser_state=0x7fc424075180, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:7908
      #18 0x00005640e59105fe in dispatch_command (command=COM_QUERY, thd=0x7fc3d8000b00, packet=0x7fc3d819df71 "ALTER TABLE t1 MODIFY a CHAR, ALGORITHM=INSTANT", packet_length=47, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:1843
      #19 0x00005640e590ed44 in do_command (thd=0x7fc3d8000b00) at /data/src/10.4/sql/sql_parse.cc:1360
      #20 0x00005640e5a88282 in do_handle_one_connection (connect=0x5640e8c97950) at /data/src/10.4/sql/sql_connect.cc:1404
      #21 0x00005640e5a87fd1 in handle_one_connection (arg=0x5640e8c97950) at /data/src/10.4/sql/sql_connect.cc:1306
      #22 0x00005640e63b396f in pfs_spawn_thread (arg=0x5640e8c162d0) at /data/src/10.4/storage/perfschema/pfs.cc:1862
      #23 0x00007fc42c6194a4 in start_thread (arg=0x7fc424076700) at pthread_create.c:456
      #24 0x00007fc42ab61d0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97
      

      Non-debug build doesn't crash.
      The test case is not applicable to 10.3.
      The issue might be related to MDEV-20190.

        Attachments

          Issue Links

            Activity

              People

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

                Dates

                Created:
                Updated:
                Resolved: