Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.4(EOL)
-
None
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
- is caused by
-
MDEV-371 Unique indexes for blobs
- Closed