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

Assertion failure in file storage/innobase/fts/fts0fts.cc upon modifying column into a blob

    XMLWordPrintable

Details

    Description

      Note: The failure became possible after MDEV-371, without it ALTER is rejected due to the missing length in the key definition.

      --source include/have_innodb.inc
       
      CREATE TABLE t1 (
        pk INT,
        a INT,
        b VARCHAR(1024),
        PRIMARY KEY (pk),
        KEY (a),
        FULLTEXT KEY(b)
      ) ENGINE=InnoDB;
       
      ALTER TABLE t1 MODIFY a LINESTRING;
       
      # Cleanup
      DROP TABLE t1;
      

      10.4 fb01193c

      2019-02-25 00:14:51 0x7f4913fff700  InnoDB: Assertion failure in file /data/src/10.4/storage/innobase/fts/fts0fts.cc line 332
      InnoDB: We intentionally generate a memory trap.
       
      #5  0x00007f491ece63fa in abort () from /lib/x86_64-linux-gnu/libc.so.6
      #6  0x000055f9150fdeb6 in ut_dbg_assertion_failed (expr=0x0, file=0x55f9157ba5c8 "/data/src/10.4/storage/innobase/fts/fts0fts.cc", line=332) at /data/src/10.4/storage/innobase/ut/ut0dbg.cc:60
      #7  0x000055f91522c551 in fts_get_charset (prtype=1283) at /data/src/10.4/storage/innobase/fts/fts0fts.cc:332
      #8  0x000055f91522dbe6 in fts_index_get_charset (index=0x7f48c81a9948) at /data/src/10.4/storage/innobase/fts/fts0fts.cc:968
      #9  0x000055f91522dd22 in fts_cache_index_cache_create (table=0x7f48c807a458, index=0x7f48c81a9948) at /data/src/10.4/storage/innobase/fts/fts0fts.cc:1020
      #10 0x000055f9151b9e68 in dict_index_build_internal_fts (index=0x7f48c8081bb8) at /data/src/10.4/storage/innobase/dict/dict0dict.cc:3129
      #11 0x000055f9151b7e4e in dict_index_add_to_cache (index=0x7f48c8081bb8, page_no=4294967295, strict=true, err=0x7f4913ff9924, add_v=0x0) at /data/src/10.4/storage/innobase/dict/dict0dict.cc:2354
      #12 0x000055f9151a9d2d in dict_create_index_step (thr=0x7f48c81a6ff0) at /data/src/10.4/storage/innobase/dict/dict0crea.cc:1346
      #13 0x000055f914fe30cd in que_thr_step (thr=0x7f48c81a6ff0) at /data/src/10.4/storage/innobase/que/que0que.cc:1052
      #14 0x000055f914fe327d in que_run_threads_low (thr=0x7f48c81a6ff0) at /data/src/10.4/storage/innobase/que/que0que.cc:1104
      #15 0x000055f914fe346e in que_run_threads (thr=0x7f48c81a6ff0) at /data/src/10.4/storage/innobase/que/que0que.cc:1144
      #16 0x000055f9150402c8 in row_create_index_for_mysql (index=0x7f48c8081bb8, trx=0x7f4918aee268, field_lengths=0x0) at /data/src/10.4/storage/innobase/row/row0mysql.cc:2560
      #17 0x000055f914ef4f8b in create_index (trx=0x7f4918aee268, form=0x7f4913ffa200, table=0x7f48c807a458, key_num=2) at /data/src/10.4/storage/innobase/handler/ha_innodb.cc:11228
      #18 0x000055f914ee11fe in create_table_info_t::create_table (this=0x7f4913ff9ca0, create_fk=true) at /data/src/10.4/storage/innobase/handler/ha_innodb.cc:12451
      #19 0x000055f914ef56e8 in ha_innobase::create (this=0x7f48c8078b48, name=0x7f4913ffc94d "./test/#sql-2bdd_9", form=0x7f4913ffa200, create_info=0x7f4913ffccd0, file_per_table=true, trx=0x7f4918aee268) at /data/src/10.4/storage/innobase/handler/ha_innodb.cc:12683
      #20 0x000055f914ee1ad1 in ha_innobase::create (this=0x7f48c8078b48, name=0x7f4913ffc94d "./test/#sql-2bdd_9", form=0x7f4913ffa200, create_info=0x7f4913ffccd0) at /data/src/10.4/storage/innobase/handler/ha_innodb.cc:12736
      #21 0x000055f914b9aaf0 in handler::ha_create (this=0x7f48c8078b48, name=0x7f4913ffc94d "./test/#sql-2bdd_9", form=0x7f4913ffa200, info_arg=0x7f4913ffccd0) at /data/src/10.4/sql/handler.cc:4816
      #22 0x000055f914b9bb65 in ha_create_table (thd=0x7f48c8000b00, path=0x7f4913ffc94d "./test/#sql-2bdd_9", db=0x7f48c8015c48 "test", table_name=0x7f48c8015568 "t1", create_info=0x7f4913ffccd0, frm=0x7f4913ffb8a0) at /data/src/10.4/sql/handler.cc:5190
      #23 0x000055f91493762d in mysql_alter_table (thd=0x7f48c8000b00, new_db=0x7f48c8005290, new_name=0x7f48c8005690, create_info=0x7f4913ffccd0, table_list=0x7f48c80155a0, alter_info=0x7f4913ffcc10, order_num=0, order=0x0, ignore=false) at /data/src/10.4/sql/sql_table.cc:9976
      #24 0x000055f9149c5922 in Sql_cmd_alter_table::execute (this=0x7f48c8015d70, thd=0x7f48c8000b00) at /data/src/10.4/sql/sql_alter.cc:499
      #25 0x000055f914856aca in mysql_execute_command (thd=0x7f48c8000b00) at /data/src/10.4/sql/sql_parse.cc:6346
      #26 0x000055f91485bc72 in mysql_parse (thd=0x7f48c8000b00, rawbuf=0x7f48c80154a8 "ALTER TABLE t1 MODIFY a LINESTRING", length=34, parser_state=0x7f4913ffe180, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:8157
      #27 0x000055f914847360 in dispatch_command (command=COM_QUERY, thd=0x7f48c8000b00, packet=0x7f48c8139fd1 "ALTER TABLE t1 MODIFY a LINESTRING", packet_length=34, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:1829
      #28 0x000055f914845b34 in do_command (thd=0x7f48c8000b00) at /data/src/10.4/sql/sql_parse.cc:1358
      #29 0x000055f9149bf837 in do_handle_one_connection (connect=0x55f917e1dd10) at /data/src/10.4/sql/sql_connect.cc:1399
      #30 0x000055f9149bf5a8 in handle_one_connection (arg=0x55f917e1dd10) at /data/src/10.4/sql/sql_connect.cc:1302
      #31 0x000055f914eb6979 in pfs_spawn_thread (arg=0x55f917e63b80) at /data/src/10.4/storage/perfschema/pfs.cc:1862
      #32 0x00007f49209b4494 in start_thread (arg=0x7f4913fff700) at pthread_create.c:333
      #33 0x00007f491ed9a93f in clone () from /lib/x86_64-linux-gnu/libc.so.6
      

      Attachments

        Issue Links

          Activity

            People

              serg Sergei Golubchik
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.