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

Assertion `c.same_type(*o)' failed in dict_table_t::instant_column

    XMLWordPrintable

    Details

      Description

      --source include/have_innodb.inc
       
      CREATE TABLE t1 (
        a text,
        b text CHARACTER SET utf8 NOT NULL,
        pk int auto_increment,
        primary key (pk)
      ) ENGINE=InnoDB DEFAULT CHARSET utf8mb4;
       
      ALTER TABLE t1 MODIFY b TEXT NOT NULL FIRST;
       
      # Cleanup
      DROP TABLE t1;
      

      10.4 010fd61a

      mysqld: /data/src/10.4/storage/innobase/handler/handler0alter.cc:551: bool dict_table_t::instant_column(const dict_table_t&, const ulint*): Assertion `c.same_type(*o)' failed.
      200817 17:43:25 [ERROR] mysqld got signal 6 ;
       
      #7  0x00007f88bdc4df12 in __GI___assert_fail (assertion=0x56029a105314 "c.same_type(*o)", file=0x56029a104578 "/data/src/10.4/storage/innobase/handler/handler0alter.cc", line=551, function=0x56029a10d640 <dict_table_t::instant_column(dict_table_t const&, unsigned long const*)::__PRETTY_FUNCTION__> "bool dict_table_t::instant_column(const dict_table_t&, const ulint*)") at assert.c:101
      #8  0x00005602997e970c in dict_table_t::instant_column (this=0x7f88641a0bd0, table=..., col_map=0x7f8864149e28) at /data/src/10.4/storage/innobase/handler/handler0alter.cc:551
      #9  0x00005602997ecd2b in ha_innobase_inplace_ctx::instant_column (this=0x7f8864014d40) at /data/src/10.4/storage/innobase/handler/handler0alter.cc:1089
      #10 0x00005602997cad88 in innobase_instant_try (ha_alter_info=0x7f88b2faed50, ctx=0x7f8864014d40, altered_table=0x7f88b2faedf0, table=0x7f8864158dc0, trx=0x7f88b8291268) at /data/src/10.4/storage/innobase/handler/handler0alter.cc:5715
      #11 0x00005602997f0795 in commit_try_norebuild (ha_alter_info=0x7f88b2faed50, ctx=0x7f8864014d40, altered_table=0x7f88b2faedf0, old_table=0x7f8864158dc0, trx=0x7f88b8291268, table_name=0x7f8864133eb5 "t1") at /data/src/10.4/storage/innobase/handler/handler0alter.cc:10274
      #12 0x00005602997dded9 in ha_innobase::commit_inplace_alter_table (this=0x7f8864159c28, altered_table=0x7f88b2faedf0, ha_alter_info=0x7f88b2faed50, commit=true) at /data/src/10.4/storage/innobase/handler/handler0alter.cc:11026
      #13 0x00005602995479fb in handler::ha_commit_inplace_alter_table (this=0x7f8864159c28, altered_table=0x7f88b2faedf0, ha_alter_info=0x7f88b2faed50, commit=true) at /data/src/10.4/sql/handler.cc:4616
      #14 0x00005602992cdde7 in mysql_inplace_alter_table (thd=0x7f8864000af0, table_list=0x7f88640132a0, table=0x7f8864158dc0, altered_table=0x7f88b2faedf0, ha_alter_info=0x7f88b2faed50, target_mdl_request=0x7f88b2fafbc0, alter_ctx=0x7f88b2fb0700) at /data/src/10.4/sql/sql_table.cc:7797
      #15 0x00005602992d4a90 in mysql_alter_table (thd=0x7f8864000af0, new_db=0x7f88640052b0, new_name=0x7f88640056b8, create_info=0x7f88b2fb12f0, table_list=0x7f88640132a0, alter_info=0x7f88b2fb1230, order_num=0, order=0x0, ignore=false) at /data/src/10.4/sql/sql_table.cc:10156
      #16 0x000056029936cfaf in Sql_cmd_alter_table::execute (this=0x7f8864013a88, thd=0x7f8864000af0) at /data/src/10.4/sql/sql_alter.cc:520
      #17 0x00005602991ea15e in mysql_execute_command (thd=0x7f8864000af0) at /data/src/10.4/sql/sql_parse.cc:6098
      #18 0x00005602991ef64f in mysql_parse (thd=0x7f8864000af0, rawbuf=0x7f8864013198 "ALTER TABLE t1 MODIFY b TEXT NOT NULL FIRST", length=43, parser_state=0x7f88b2fb2570, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:7896
      #19 0x00005602991dbb84 in dispatch_command (command=COM_QUERY, thd=0x7f8864000af0, packet=0x7f88640083a1 "ALTER TABLE t1 MODIFY b TEXT NOT NULL FIRST", packet_length=43, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:1835
      #20 0x00005602991da326 in do_command (thd=0x7f8864000af0) at /data/src/10.4/sql/sql_parse.cc:1353
      #21 0x00005602993639c2 in do_handle_one_connection (connect=0x56029c8d4020) at /data/src/10.4/sql/sql_connect.cc:1412
      #22 0x0000560299363711 in handle_one_connection (arg=0x56029c8d4020) at /data/src/10.4/sql/sql_connect.cc:1316
      #23 0x0000560299d66667 in pfs_spawn_thread (arg=0x56029c851fd0) at /data/src/10.4/storage/perfschema/pfs.cc:1869
      #24 0x00007f88bfbd64a4 in start_thread (arg=0x7f88b2fb3700) at pthread_create.c:456
      #25 0x00007f88bdd0ad0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97
      

      Couldn't reproduce on 10.3.
      No obvious problem on a non-debug build.

        Attachments

          Activity

            People

            Assignee:
            marko Marko Mäkelä
            Reporter:
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Git Integration