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

Assertion `!!new_clustered == (innobase_need_rebuild(ha_alter_info, old_table) || add_fts_doc_id)' failed in prepare_inplace_alter_table_dict

    XMLWordPrintable

    Details

      Description

      --source include/have_innodb.inc
       
      CREATE TABLE t1 (e GEOMETRY NOT NULL) ENGINE=InnoDB;
      ALTER TABLE t1 ADD UNIQUE (e(4));
       
      # Cleanup
      DROP TABLE t1;
      

      10.0 12f362c333

      mysqld: /data/src/10.0/storage/innobase/handler/handler0alter.cc:2772: bool prepare_inplace_alter_table_dict(Alter_inplace_info*, const TABLE*, const TABLE*, const char*, ulint, ulint, ulint, bool, bool): Assertion `!!new_clustered == (innobase_need_rebuild(ha_alter_info, old_table) || add_fts_doc_id)' failed.
      190116 23:50:40 [ERROR] mysqld got signal 6 ;
       
      #7  0x00007f5b41ce2ee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
      #8  0x00007f5b3a7624f8 in prepare_inplace_alter_table_dict (ha_alter_info=0x7f5b43da5220, altered_table=0x7f5b2df9f070, old_table=0x7f5b2dc9e470, table_name=0x7f5b2dc61175 "t1", flags=1, flags2=80, fts_doc_id_col=18446744073709551615, add_fts_doc_id=false, add_fts_doc_id_idx=false) at /data/src/10.0/storage/innobase/handler/handler0alter.cc:2770
      #9  0x00007f5b3a765f73 in ha_innodb::prepare_inplace_alter_table (this=0x7f5b2dc7e888, altered_table=0x7f5b2df9f070, ha_alter_info=0x7f5b43da5220) at /data/src/10.0/storage/innobase/handler/handler0alter.cc:4040
      #10 0x0000000000845071 in handler::ha_prepare_inplace_alter_table (this=0x7f5b2dc7e888, altered_table=0x7f5b2df9f070, ha_alter_info=0x7f5b43da5220) at /data/src/10.0/sql/handler.cc:4208
      #11 0x000000000070275c in mysql_inplace_alter_table (thd=0x7f5b36369070, table_list=0x7f5b2dcf8178, table=0x7f5b2dc9e470, altered_table=0x7f5b2df9f070, ha_alter_info=0x7f5b43da5220, inplace_supported=HA_ALTER_INPLACE_NO_LOCK_AFTER_PREPARE, target_mdl_request=0x7f5b43da4c70, alter_ctx=0x7f5b43da5800) at /data/src/10.0/sql/sql_table.cc:7118
      #12 0x0000000000706ffc in mysql_alter_table (thd=0x7f5b36369070, new_db=0x7f5b2dcf8758 "test", new_name=0x0, create_info=0x7f5b43da64e0, table_list=0x7f5b2dcf8178, alter_info=0x7f5b43da6450, order_num=0, order=0x0, ignore=false) at /data/src/10.0/sql/sql_table.cc:8982
      #13 0x0000000000770361 in Sql_cmd_alter_table::execute (this=0x7f5b2dcf8828, thd=0x7f5b36369070) at /data/src/10.0/sql/sql_alter.cc:312
      #14 0x0000000000654d27 in mysql_execute_command (thd=0x7f5b36369070) at /data/src/10.0/sql/sql_parse.cc:5125
      #15 0x000000000065837e in mysql_parse (thd=0x7f5b36369070, rawbuf=0x7f5b2dcf8088 "ALTER TABLE t1 ADD UNIQUE (e(4))", length=32, parser_state=0x7f5b43da7640) at /data/src/10.0/sql/sql_parse.cc:6644
      #16 0x000000000064ac38 in dispatch_command (command=COM_QUERY, thd=0x7f5b36369070, packet=0x7f5b3be30071 "ALTER TABLE t1 ADD UNIQUE (e(4))", packet_length=32) at /data/src/10.0/sql/sql_parse.cc:1301
      #17 0x0000000000649f2c in do_command (thd=0x7f5b36369070) at /data/src/10.0/sql/sql_parse.cc:1003
      #18 0x000000000076bab4 in do_handle_one_connection (thd_arg=0x7f5b36369070) at /data/src/10.0/sql/sql_connect.cc:1377
      #19 0x000000000076b826 in handle_one_connection (arg=0x7f5b36369070) at /data/src/10.0/sql/sql_connect.cc:1292
      #20 0x0000000000acd6ea in pfs_spawn_thread (arg=0x7f5b36319670) at /data/src/10.0/storage/perfschema/pfs.cc:1861
      #21 0x00007f5b439e6494 in start_thread (arg=0x7f5b43da8700) at pthread_create.c:333
      #22 0x00007f5b41d9f93f in clone () from /lib/x86_64-linux-gnu/libc.so.6
      

      Not reproducible on 5.5.
      No visible effect on a non-debug build.

        Attachments

          Activity

            People

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

              Dates

              Created:
              Updated: