InnoDB: Failing assertion: !index->to_be_dropped in file handler0alter.cc line 3490

--source include/have_innodb.inc

SET GLOBAL lock_wait_timeout = 3;

--connect (con11,127.0.0.1,root,,test)

--connect (con13,127.0.0.1,root,,test)

--connect (con14,127.0.0.1,root,,test)

--connection con13

	CREATE TABLE IF NOT EXISTS t1 (col1 INT, col2 INT, col3 INT, col4 TEXT, KEY ftidx(col4(40))) ENGINE = InnoDB;

--error ER_CANT_DROP_FIELD_OR_KEY

	ALTER TABLE t1 DROP KEY idx;

--connection con14

--send

	ALTER TABLE t1 ADD KEY idx ( col4(10), col2 ) /* QUERY_NO 3188 CON_ID 14 */;

--connection con13

--error ER_PARSE_ERROR

	CREATE OR REPLACE VIEW v1 AS SYNTAX ERROR;

    START TRANSACTION;

--send

	INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 4, 3, 4, REPEAT(CAST(4 AS CHAR(1)),@fill_amount));

--connection con11

--connection con14

--error ER_LOCK_WAIT_TIMEOUT

--reap

--send

	ALTER TABLE t1 DROP KEY ftidx, ADD KEY idx ( col4(10), col2 ) /* QUERY_NO 4164 CON_ID 14 */;

--connection con11

--send

	ALTER TABLE t1 ADD UNIQUE KEY uidx ( col4(10), col2 ) /* QUERY_NO 4644 CON_ID 11 */;

--connection con13

--error 0,ER_LOCK_WAIT_TIMEOUT

--reap

--disconnect con13

--connection con14

--error 0,ER_LOCK_WAIT_TIMEOUT,ER_INDEX_CORRUPT

--reap

--disconnect con14

--connection con11

--error 0,ER_LOCK_WAIT_TIMEOUT

--reap

--disconnect con11

--connection default

DROP TABLE t1;

SET GLOBAL lock_wait_timeout = DEFAULT;

2016-08-04 02:14:39 7f1f112a3700  InnoDB: Assertion failure in thread 139771408692992 in file handler0alter.cc line 3490

InnoDB: Failing assertion: !index->to_be_dropped

#5  0x00007f1f0f038448 in __GI_abort () at abort.c:89

#6  0x00007f1f07b668b9 in ha_innodb::prepare_inplace_alter_table (this=0x7f1efc88b088, altered_table=0x7f1efc45f070, ha_alter_info=0x7f1f112a0270) at /data/src/10.0/storage/innobase/handler/handler0alter.cc:3490

#7  0x000000000083a3f1 in handler::ha_prepare_inplace_alter_table (this=0x7f1efc88b088, altered_table=0x7f1efc45f070, ha_alter_info=0x7f1f112a0270) at /data/src/10.0/sql/handler.cc:4169

#8  0x00000000006fa8ed in mysql_inplace_alter_table (thd=0x7f1f03768070, table_list=0x7f1efc4241e0, table=0x7f1efc955c70, altered_table=0x7f1efc45f070, ha_alter_info=0x7f1f112a0270, inplace_supported=HA_ALTER_INPLACE_NO_LOCK_AFTER_PREPARE, target_mdl_request=0x7f1f1129fcc0, alter_ctx=0x7f1f112a0850) at /data/src/10.0/sql/sql_table.cc:7062

#9  0x00000000006fef73 in mysql_alter_table (thd=0x7f1f03768070, new_db=0x7f1efc4247c0 "test", new_name=0x0, create_info=0x7f1f112a14f0, table_list=0x7f1efc4241e0, alter_info=0x7f1f112a1460, order_num=0, order=0x0, ignore=false) at /data/src/10.0/sql/sql_table.cc:8885

#10 0x0000000000766713 in Sql_cmd_alter_table::execute (this=0x7f1efc4248c8, thd=0x7f1f03768070) at /data/src/10.0/sql/sql_alter.cc:312

#11 0x000000000064e9eb in mysql_execute_command (thd=0x7f1f03768070) at /data/src/10.0/sql/sql_parse.cc:5115

#12 0x0000000000651e16 in mysql_parse (thd=0x7f1f03768070, rawbuf=0x7f1efc424088 "ALTER TABLE t1 ADD UNIQUE KEY uidx ( col4(10), col2 ) /* QUERY_NO 4644 CON_ID 11 */", length=83, parser_state=0x7f1f112a2650) at /data/src/10.0/sql/sql_parse.cc:6575

#13 0x0000000000644922 in dispatch_command (command=COM_QUERY, thd=0x7f1f03768070, packet=0x7f1f0376e071 "ALTER TABLE t1 ADD UNIQUE KEY uidx ( col4(10), col2 ) /* QUERY_NO 4644 CON_ID 11 */", packet_length=83) at /data/src/10.0/sql/sql_parse.cc:1309

#14 0x0000000000643be5 in do_command (thd=0x7f1f03768070) at /data/src/10.0/sql/sql_parse.cc:999

#15 0x0000000000761e66 in do_handle_one_connection (thd_arg=0x7f1f03768070) at /data/src/10.0/sql/sql_connect.cc:1378

#16 0x0000000000761bd8 in handle_one_connection (arg=0x7f1f03768070) at /data/src/10.0/sql/sql_connect.cc:1293

#17 0x00000000009fa3a0 in pfs_spawn_thread (arg=0x7f1f03705e70) at /data/src/10.0/storage/perfschema/pfs.cc:1860

#18 0x00007f1f10f320a4 in start_thread (arg=0x7f1f112a3700) at pthread_create.c:309

#19 0x00007f1f0f0ea87d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111

Trying to get some variables.

Some pointers may be invalid and cause the dump to abort.

Query (0x7f1efc424088): ALTER TABLE t1 ADD UNIQUE KEY uidx ( col4(10), col2 ) /* QUERY_NO 4644 CON_ID 11 */

Connection ID (thread ID): 11

Status: NOT_KILLED