Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.3(EOL)
-
None
Description
--source include/have_innodb.inc
|
|
|
CREATE TABLE t1 (a VARCHAR(8), b VARCHAR(8)) ENGINE=InnoDB; |
ALTER TABLE t1 ADD FULLTEXT(b), ADD FULLTEXT(a); |
|
|
# Cleanup
|
DROP TABLE t1; |
|
10.3 34f2f4fa431893db5550 |
mysqld: /data/src/10.3/storage/innobase/handler/handler0alter.cc:5423: bool prepare_inplace_alter_table_dict(Alter_inplace_info*, const TABLE*, const TABLE*, const char*, ulint, ulint, ulint, bool, bool): Assertion `!fts_index' failed.
|
171216 3:21:29 [ERROR] mysqld got signal 6 ;
|
|
|
#7 0x00007f21c8457ee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
|
#8 0x00005621228fb85f in prepare_inplace_alter_table_dict (ha_alter_info=0x7f21c0056520, altered_table=0x7f2170168e40, old_table=0x7f21700da2c0, table_name=0x7f217000e035 "t1", flags=33, flags2=94, fts_doc_id_col=2, add_fts_doc_id=true, add_fts_doc_id_idx=true) at /data/src/10.3/storage/innobase/handler/handler0alter.cc:5423
|
#9 0x00005621228ffba9 in ha_innobase::prepare_inplace_alter_table (this=0x7f217000c988, altered_table=0x7f2170168e40, ha_alter_info=0x7f21c0056520) at /data/src/10.3/storage/innobase/handler/handler0alter.cc:6842
|
#10 0x00005621225989bb in handler::ha_prepare_inplace_alter_table (this=0x7f217000c988, altered_table=0x7f2170168e40, ha_alter_info=0x7f21c0056520) at /data/src/10.3/sql/handler.cc:4231
|
#11 0x0000562122397b0c in mysql_inplace_alter_table (thd=0x7f2170000b00, table_list=0x7f2170014c60, table=0x7f21700da2c0, altered_table=0x7f2170168e40, ha_alter_info=0x7f21c0056520, inplace_supported=HA_ALTER_INPLACE_SHARED_LOCK_AFTER_PREPARE, target_mdl_request=0x7f21c0056590, alter_ctx=0x7f21c0057150) at /data/src/10.3/sql/sql_table.cc:7357
|
#12 0x000056212239d10b in mysql_alter_table (thd=0x7f2170000b00, new_db=0x7f2170015270 "test", new_name=0x0, create_info=0x7f21c0057d60, table_list=0x7f2170014c60, alter_info=0x7f21c0057cb0, order_num=0, order=0x0, ignore=false) at /data/src/10.3/sql/sql_table.cc:9395
|
#13 0x000056212241d5c7 in Sql_cmd_alter_table::execute (this=0x7f21700153f8, thd=0x7f2170000b00) at /data/src/10.3/sql/sql_alter.cc:331
|
#14 0x00005621222cda6d in mysql_execute_command (thd=0x7f2170000b00) at /data/src/10.3/sql/sql_parse.cc:6248
|
#15 0x00005621222d247e in mysql_parse (thd=0x7f2170000b00, rawbuf=0x7f2170014b58 "ALTER TABLE t1 ADD FULLTEXT(b), ADD FULLTEXT(a)", length=47, parser_state=0x7f21c0059610, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:7963
|
#16 0x00005621222bfe11 in dispatch_command (command=COM_QUERY, thd=0x7f2170000b00, packet=0x7f2170160d01 "ALTER TABLE t1 ADD FULLTEXT(b), ADD FULLTEXT(a)", packet_length=47, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:1825
|
#17 0x00005621222be845 in do_command (thd=0x7f2170000b00) at /data/src/10.3/sql/sql_parse.cc:1370
|
#18 0x0000562122418140 in do_handle_one_connection (connect=0x562124f230d0) at /data/src/10.3/sql/sql_connect.cc:1420
|
#19 0x0000562122417ecd in handle_one_connection (arg=0x562124f230d0) at /data/src/10.3/sql/sql_connect.cc:1326
|
#20 0x00005621228a05c6 in pfs_spawn_thread (arg=0x562124f3fce0) at /data/src/10.3/storage/perfschema/pfs.cc:1863
|
#21 0x00007f21ca12e494 in start_thread (arg=0x7f21c005a700) at pthread_create.c:333
|
#22 0x00007f21c851493f in clone () from /lib/x86_64-linux-gnu/libc.so.6
|
Attachments
Activity
| Field | Original Value | New Value |
|---|---|---|
| Fix Version/s | 10.3 [ 22126 ] | |
| Assignee | Elena Stepanova [ elenst ] | Marko Mäkelä [ marko ] |
| Description |
[Travis log|https://api.travis-ci.org/v3/job/316185970/log.txt]
{noformat:title=10.3 159a6c2e608d04732cb678c7691345b9b1dc69b1} 2017-12-14 10:45:00 19 [Note] InnoDB: Deleting the meta-data file './test/t8.cfg' 2017-12-14 10:45:00 19 [Note] InnoDB: Resuming purge mysqld: /home/travis/src/storage/innobase/handler/handler0alter.cc:5423: bool prepare_inplace_alter_table_dict(Alter_inplace_info*, const TABLE*, const TABLE*, const char*, ulint, ulint, ulint, bool, bool): Assertion `!fts_index' failed. 171214 10:45:01 [ERROR] mysqld got signal 6 ; #6 0x00007f0da9887bf6 in __assert_fail_base (fmt=0x7f0da99dc018 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x5600b394c875 "!fts_index", file=file@entry=0x5600b394a2b0 "/home/travis/src/storage/innobase/handler/handler0alter.cc", line=line@entry=5423, function=function@entry=0x5600b39511e0 <prepare_inplace_alter_table_dict(Alter_inplace_info*, TABLE const*, TABLE const*, char const*, unsigned long, unsigned long, unsigned long, bool, bool)::__PRETTY_FUNCTION__> "bool prepare_inplace_alter_table_dict(Alter_inplace_info*, const TABLE*, const TABLE*, const char*, ulint, ulint, ulint, bool, bool)") at assert.c:92 #7 0x00007f0da9887ca2 in __GI___assert_fail (assertion=0x5600b394c875 "!fts_index", file=0x5600b394a2b0 "/home/travis/src/storage/innobase/handler/handler0alter.cc", line=5423, function=0x5600b39511e0 <prepare_inplace_alter_table_dict(Alter_inplace_info*, TABLE const*, TABLE const*, char const*, unsigned long, unsigned long, unsigned long, bool, bool)::__PRETTY_FUNCTION__> "bool prepare_inplace_alter_table_dict(Alter_inplace_info*, const TABLE*, const TABLE*, const char*, ulint, ulint, ulint, bool, bool)") at assert.c:101 #8 0x00005600b316ebcc in prepare_inplace_alter_table_dict (ha_alter_info=0x7f0d858dc4c0, altered_table=0x7f0d601544f0, old_table=0x7f0d60126940, table_name=0x7f0d60116a2d "t17", flags=1, flags2=94, fts_doc_id_col=11, add_fts_doc_id=true, add_fts_doc_id_idx=true) at /home/travis/src/storage/innobase/handler/handler0alter.cc:5423 #9 0x00005600b3172faf in ha_innobase::prepare_inplace_alter_table (this=0x7f0d60134cb8, altered_table=0x7f0d601544f0, ha_alter_info=0x7f0d858dc4c0) at /home/travis/src/storage/innobase/handler/handler0alter.cc:6842 #10 0x00005600b2f15a9f in handler::ha_prepare_inplace_alter_table (this=0x7f0d60134cb8, altered_table=0x7f0d601544f0, ha_alter_info=0x7f0d858dc4c0) at /home/travis/src/sql/handler.cc:4231 #11 0x00005600b2d0e4c8 in mysql_inplace_alter_table (thd=0x7f0d6000b150, table_list=0x7f0d6001fb50, table=0x7f0d60126940, altered_table=0x7f0d601544f0, ha_alter_info=0x7f0d858dc4c0, inplace_supported=HA_ALTER_INPLACE_SHARED_LOCK_AFTER_PREPARE, target_mdl_request=0x7f0d858dc530, alter_ctx=0x7f0d858dd0f0) at /home/travis/src/sql/sql_table.cc:7202 #12 0x00005600b2d13a75 in mysql_alter_table (thd=0x7f0d6000b150, new_db=0x7f0d60020160 "test", new_name=0x0, create_info=0x7f0d858ddd00, table_list=0x7f0d6001fb50, alter_info=0x7f0d858ddc50, order_num=0, order=0x0, ignore=false) at /home/travis/src/sql/sql_table.cc:9237 #13 0x00005600b2d94c79 in Sql_cmd_alter_table::execute (this=0x7f0d60020398, thd=0x7f0d6000b150) at /home/travis/src/sql/sql_alter.cc:331 #14 0x00005600b2c45377 in mysql_execute_command (thd=0x7f0d6000b150) at /home/travis/src/sql/sql_parse.cc:6248 #15 0x00005600b2c49d51 in mysql_parse (thd=0x7f0d6000b150, rawbuf=0x7f0d6001f948 "ALTER TABLE t17 ADD FULLTEXT KEY(`col_varchar_257_latin1`), ROW_FORMAT=COMPACT, ADD FULLTEXT KEY(`col_varchar_257_utf8`), FORCE, ALGORITHM=INPLACE /* QNO 2426 CON_ID 20 */", length=171, parser_state=0x7f0d858df620, is_com_multi=false, is_next_command=false) at /home/travis/src/sql/sql_parse.cc:7963 #16 0x00005600b2c3771b in dispatch_command (command=COM_QUERY, thd=0x7f0d6000b150, packet=0x7f0d60017621 "ALTER TABLE t17 ADD FULLTEXT KEY(`col_varchar_257_latin1`), ROW_FORMAT=COMPACT, ADD FULLTEXT KEY(`col_varchar_257_utf8`), FORCE, ALGORITHM=INPLACE /* QNO 2426 CON_ID 20 */ ", packet_length=172, is_com_multi=false, is_next_command=false) at /home/travis/src/sql/sql_parse.cc:1825 #17 0x00005600b2c3615b in do_command (thd=0x7f0d6000b150) at /home/travis/src/sql/sql_parse.cc:1370 #18 0x00005600b2d8f848 in do_handle_one_connection (connect=0x5600b6550850) at /home/travis/src/sql/sql_connect.cc:1420 #19 0x00005600b2d8f5d5 in handle_one_connection (arg=0x5600b6550850) at /home/travis/src/sql/sql_connect.cc:1326 #20 0x00007f0daa449184 in start_thread (arg=0x7f0d858e0700) at pthread_create.c:312 #21 0x00007f0da9955ffd in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111 {noformat} {noformat} perl /home/travis/rqg/runall-new.pl --grammar=conf/replication/replication-ddl_sql.yy --gendata=conf/replication/replication-ddl_data.zz --duration=400 --rpl-mode=mixed --threads=6 --queries=100M --redefine=/home/travis/rqg/conf/mariadb/instant_add.yy --mysqld=--max-statement-time=30 --reporters=Backtrace,ErrorLog,Deadlock --mysqld=--slave-parallel-threads=6 --engine=InnoDB --seed=1513248169 --basedir=/home/travis/server --vardir=/home/travis/logs/vardir1_4 {noformat} Not easily reproducible. |
{code:sql}
--source include/have_innodb.inc CREATE TABLE t1 (a VARCHAR(8), b VARCHAR(8)) ENGINE=InnoDB; ALTER TABLE t1 ADD FULLTEXT(b), ADD FULLTEXT(a); # Cleanup DROP TABLE t1; {code} {noformat:title=10.3 34f2f4fa431893db5550} mysqld: /data/src/10.3/storage/innobase/handler/handler0alter.cc:5423: bool prepare_inplace_alter_table_dict(Alter_inplace_info*, const TABLE*, const TABLE*, const char*, ulint, ulint, ulint, bool, bool): Assertion `!fts_index' failed. 171216 3:21:29 [ERROR] mysqld got signal 6 ; #7 0x00007f21c8457ee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6 #8 0x00005621228fb85f in prepare_inplace_alter_table_dict (ha_alter_info=0x7f21c0056520, altered_table=0x7f2170168e40, old_table=0x7f21700da2c0, table_name=0x7f217000e035 "t1", flags=33, flags2=94, fts_doc_id_col=2, add_fts_doc_id=true, add_fts_doc_id_idx=true) at /data/src/10.3/storage/innobase/handler/handler0alter.cc:5423 #9 0x00005621228ffba9 in ha_innobase::prepare_inplace_alter_table (this=0x7f217000c988, altered_table=0x7f2170168e40, ha_alter_info=0x7f21c0056520) at /data/src/10.3/storage/innobase/handler/handler0alter.cc:6842 #10 0x00005621225989bb in handler::ha_prepare_inplace_alter_table (this=0x7f217000c988, altered_table=0x7f2170168e40, ha_alter_info=0x7f21c0056520) at /data/src/10.3/sql/handler.cc:4231 #11 0x0000562122397b0c in mysql_inplace_alter_table (thd=0x7f2170000b00, table_list=0x7f2170014c60, table=0x7f21700da2c0, altered_table=0x7f2170168e40, ha_alter_info=0x7f21c0056520, inplace_supported=HA_ALTER_INPLACE_SHARED_LOCK_AFTER_PREPARE, target_mdl_request=0x7f21c0056590, alter_ctx=0x7f21c0057150) at /data/src/10.3/sql/sql_table.cc:7357 #12 0x000056212239d10b in mysql_alter_table (thd=0x7f2170000b00, new_db=0x7f2170015270 "test", new_name=0x0, create_info=0x7f21c0057d60, table_list=0x7f2170014c60, alter_info=0x7f21c0057cb0, order_num=0, order=0x0, ignore=false) at /data/src/10.3/sql/sql_table.cc:9395 #13 0x000056212241d5c7 in Sql_cmd_alter_table::execute (this=0x7f21700153f8, thd=0x7f2170000b00) at /data/src/10.3/sql/sql_alter.cc:331 #14 0x00005621222cda6d in mysql_execute_command (thd=0x7f2170000b00) at /data/src/10.3/sql/sql_parse.cc:6248 #15 0x00005621222d247e in mysql_parse (thd=0x7f2170000b00, rawbuf=0x7f2170014b58 "ALTER TABLE t1 ADD FULLTEXT(b), ADD FULLTEXT(a)", length=47, parser_state=0x7f21c0059610, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:7963 #16 0x00005621222bfe11 in dispatch_command (command=COM_QUERY, thd=0x7f2170000b00, packet=0x7f2170160d01 "ALTER TABLE t1 ADD FULLTEXT(b), ADD FULLTEXT(a)", packet_length=47, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:1825 #17 0x00005621222be845 in do_command (thd=0x7f2170000b00) at /data/src/10.3/sql/sql_parse.cc:1370 #18 0x0000562122418140 in do_handle_one_connection (connect=0x562124f230d0) at /data/src/10.3/sql/sql_connect.cc:1420 #19 0x0000562122417ecd in handle_one_connection (arg=0x562124f230d0) at /data/src/10.3/sql/sql_connect.cc:1326 #20 0x00005621228a05c6 in pfs_spawn_thread (arg=0x562124f3fce0) at /data/src/10.3/storage/perfschema/pfs.cc:1863 #21 0x00007f21ca12e494 in start_thread (arg=0x7f21c005a700) at pthread_create.c:333 #22 0x00007f21c851493f in clone () from /lib/x86_64-linux-gnu/libc.so.6 {noformat} |
| Summary | [Draft] Assertion `!fts_index' failed in prepare_inplace_alter_table_dict | Assertion `!fts_index' failed in prepare_inplace_alter_table_dict |
| Attachment | threads [ 44790 ] |
| Fix Version/s | 10.3.4 [ 22904 ] | |
| Fix Version/s | 10.3 [ 22126 ] | |
| Resolution | Fixed [ 1 ] | |
| Status | Open [ 1 ] | Closed [ 6 ] |
| Workflow | MariaDB v3 [ 84431 ] | MariaDB v4 [ 153355 ] |