Bug #74762 Failing assertion: thr_get_trx(thr)->error_state == DB_SUCCESS.

Description:
2014-11-10 11:39:27 7fcb8bbfd700  InnoDB: Assertion failure in thread 140512199694080 in file que0que.cc line 1206
InnoDB: Failing assertion: thr_get_trx(thr)->error_state == DB_SUCCESS

** GDB info

#0  0x00007f1136eb6771 in pthread_kill () from /lib64/libpthread.so.0
#1  0x0000000000a9035e in my_write_core (sig=6) at /ssd/ramesh/mysql-server/mysql-5.6/mysys/stacktrace.c:422
#2  0x0000000000723688 in handle_fatal_signal (sig=6) at /ssd/ramesh/mysql-server/mysql-5.6/sql/signal_handler.cc:230
#3  <signal handler called>
#4  0x00007f1135cc25c9 in raise () from /lib64/libc.so.6
#5  0x00007f1135cc3cd8 in abort () from /lib64/libc.so.6
#6  0x0000000000bff79c in que_run_threads (thr=0x7f108e87fa18) at /ssd/ramesh/mysql-server/mysql-5.6/storage/innobase/que/que0que.cc:1206
#7  0x0000000000dbf16c in fts_eval_sql (trx=0x7f108e80e478, graph=0x7f108e87f950) at /ssd/ramesh/mysql-server/mysql-5.6/storage/innobase/fts/fts0sql.cc:286
#8  0x0000000000da9088 in fts_write_node (trx=0x7f108e80e478, graph=0x7f108e8442c8, fts_table=0x7f10897fcd80, word=0x7f10897fcd50, node=0x7f108e8440c0) at /ssd/ramesh/mysql-server/mysql-5.6/storage/innobase/fts/fts0fts.cc:3886
#9  0x0000000000c10b6b in row_merge_write_fts_word (trx=0x7f108e80e478, ins_graph=0x7f108e8442a8, word=0x7f10897fcd50, fts_table=0x7f10897fcd80, charset=0x168e0c0 <my_charset_latin1>) at /ssd/ramesh/mysql-server/mysql-5.6/storage/innobase/row/row0ftsort.cc:998
#10 0x0000000000c10dea in row_fts_insert_tuple (ins_ctx=0x7f10897fcd70, word=0x7f10897fcd50, positions=0x7f108e844180, in_doc_id=0x7f10897fcdd8, dtuple=0x7f108e82a678) at /ssd/ramesh/mysql-server/mysql-5.6/storage/innobase/row/row0ftsort.cc:1097
#11 0x0000000000c11ffe in row_fts_merge_insert (index=0x7f109a471d78, table=0x7f109a54a578, psort_info=0x7f109a49a878, id=4) at /ssd/ramesh/mysql-server/mysql-5.6/storage/innobase/row/row0ftsort.cc:1526
#12 0x0000000000c10976 in fts_parallel_merge (arg=0x7f109a454eb8) at /ssd/ramesh/mysql-server/mysql-5.6/storage/innobase/row/row0ftsort.cc:932
#13 0x00007f1136eb1df3 in start_thread () from /lib64/libpthread.so.0
#14 0x00007f1135d8301d in clone () from /lib64/libc.so.6

How to repeat:
Got 30 lines in final testcase. I could not reduce it further.

******************
DROP DATABASE test;CREATE DATABASE test;USE test;
CREATE TABLE t1(a INT)PARTITION BY RANGE (a) (PARTITION p0 VALUES LESS THAN (6),PARTITION `p1....................` VALUES LESS THAN (9),PARTITION p2 VALUES LESS THAN MAXVALUE);
ALTER TABLE t1 ADD ucs2_f CHAR(32)CHARACTER SET ucs2;
DROP TABLE t1;
CREATE TABLE t2(dummy int)ENGINE=innodb;
CREATE TABLE t1(i1 INT);
CREATE INDEX t1r ON t1(r(767));
DROP TABLE t1;
CREATE TABLE t4(id INT UNSIGNED AUTO_INCREMENT KEY,title CHAR (200),body TEXT,FULLTEXT (title,body)) ENGINE=InnoDB;
CREATE TABLE t1(c1 INT);
INSERT INTO t1 VALUES(0xACA6);
CREATE TABLE `�ԣ�`(`�ã�` ENUM('','',''),INDEX(`�ã�`)) DEFAULT CHARSET=ucs2 engine=innodb;
INSERT INTO t4(title,body)VALUES ('MySQL Tutorial','DBMS stINg database comparison ...'),('MySQL Security','When configured properly,MySQL ...');
INSERT INTO t1 VALUES(repeat(0,@@global.max_allowed_packet));
INSERT INTO t1 VALUES(0xA9D8);
INSERT INTO t1 VALUES(CONVERT(_ucs2 0x06220646 USING utf8));
INSERT INTO t1 VALUES(@@session.unique_checks);
insert t1 values(0);
set global innodb_trx_rseg_n_slots_debug=1;
ALTER TABLE t1 ADD UNIQUE(c1);
REPLACE t1 VALUES(5);
insert INTO t1 values(repeat('बांग्लादे',0));
INSERT INTO t1 VALUES(0xA5F8);
ALTER TABLE t1 CHANGE c1 c1 REAL UNSIGNED;
CREATE TABLE t7(val bit(1));
ALTER TABLE t1 CHANGE c1 c1 BLOB;
SELECT * FROM t1;
INSERT INTO t1 VALUES(-1),(-2),(-3);
ALTER TABLE t4 ADD FULLTEXT INDEX idx(title,body);
ALTER TABLE t4 ADD FULLTEXT INDEX idx(title,body);
ALTER TABLE t4 ADD FULLTEXT INDEX idx(title,body);

Hello Ramesh Sivaraman,

Thank you for the bug report and test case.
Observed that debug build of 5.6.23 affected.

Thanks,
Umesh

// 5.6.23

(gdb) bt
#0  0x0000003deac32625 in raise (sig=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:64
#1  0x0000003deac33e05 in abort () at abort.c:92
#2  0x0000000000c4c1ef in que_run_threads (thr=0x7f70a0034408) at /export/home/pb2/build/sb_0-13622626-1415294505.52/mysqlcom-pro-5.6.23/storage/innobase/que/que0que.cc:1206
#3  0x0000000000e1166c in fts_eval_sql (trx=0x7f70a0027ce8, graph=0x7f70a0034340) at /export/home/pb2/build/sb_0-13622626-1415294505.52/mysqlcom-pro-5.6.23/storage/innobase/fts/fts0sql.cc:286
#4  0x0000000000df9987 in fts_write_node (trx=0x7f70a0027ce8, graph=0x7f70a00313d0, fts_table=0x7f70cdffad10, word=0x7f70cdffad60, node=0x7f70a00311e0)
    at /export/home/pb2/build/sb_0-13622626-1415294505.52/mysqlcom-pro-5.6.23/storage/innobase/fts/fts0fts.cc:3896
#5  0x0000000000c5d6aa in row_merge_write_fts_word (trx=0x7f70a0027ce8, ins_graph=0x7f70a00313c8, word=0x7f70cdffad60, fts_table=0x7f70cdffad10, charset=0x1818980)
    at /export/home/pb2/build/sb_0-13622626-1415294505.52/mysqlcom-pro-5.6.23/storage/innobase/row/row0ftsort.cc:1003
#6  0x0000000000c5d945 in row_fts_insert_tuple (ins_ctx=0x7f70cdffad00, word=0x7f70cdffad60, positions=0x7f70a00312a0, in_doc_id=0x7f70cdffad88, dtuple=0x7f70a002cca8)
    at /export/home/pb2/build/sb_0-13622626-1415294505.52/mysqlcom-pro-5.6.23/storage/innobase/row/row0ftsort.cc:1102
#7  0x0000000000c5ea86 in row_fts_merge_insert (index=0x7f70b40983a8, table=0x7f70b40611b8, psort_info=0x7f70b40932a8, id=1)
    at /export/home/pb2/build/sb_0-13622626-1415294505.52/mysqlcom-pro-5.6.23/storage/innobase/row/row0ftsort.cc:1531
#8  0x0000000000c5d4d4 in fts_parallel_merge (arg=0x7f70b40a0f88) at /export/home/pb2/build/sb_0-13622626-1415294505.52/mysqlcom-pro-5.6.23/storage/innobase/row/row0ftsort.cc:937
#9  0x0000003deb0079d1 in start_thread (arg=0x7f70cdffb700) at pthread_create.c:301
#10 0x0000003deace89dd in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115

// 5.7.6 debug build

(gdb) bt
#0  __pthread_kill (threadid=<value optimized out>, signo=<value optimized out>) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:63
#1  0x0000000000f990a1 in my_write_core (sig=6) at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/mysys/stacktrace.c:247
#2  0x000000000092d7cc in handle_fatal_signal (sig=6) at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/sql/signal_handler.cc:219
#3  <signal handler called>
#4  0x0000003deac32625 in raise (sig=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:64
#5  0x0000003deac33e05 in abort () at abort.c:92
#6  0x0000003deac2b74e in __assert_fail_base (fmt=<value optimized out>, assertion=0x16ec2fc "0",
    file=0x16ece38 "/pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/storage/innobase/handler/handler0alter.cc", line=<value optimized out>, function=<value optimized out>)
    at assert.c:96
#7  0x0000003deac2b810 in __assert_fail (assertion=0x16ec2fc "0", file=0x16ece38 "/pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/storage/innobase/handler/handler0alter.cc",
    line=5865, function=0x16f0660 "bool commit_try_norebuild(Alter_inplace_info*, ha_innobase_inplace_ctx*, const TABLE*, trx_t*, const char*)") at assert.c:105
#8  0x000000000106c7f3 in commit_try_norebuild (ha_alter_info=0x7ff4d9fd2870, ctx=0x7ff498007270, old_table=0x7ff498065f60, trx=0x7ff4dabbbd60, table_name=0x7ff49806bf8d "t4")
    at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/storage/innobase/handler/handler0alter.cc:5865
#9  0x0000000001069619 in ha_innobase::commit_inplace_alter_table (this=0x7ff49806cff0, altered_table=0x7ff49807f850, ha_alter_info=0x7ff4d9fd2870, commit=true)
    at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/storage/innobase/handler/handler0alter.cc:6379
#10 0x0000000000998994 in handler::ha_commit_inplace_alter_table (this=0x7ff49806cff0, altered_table=0x7ff49807f850, ha_alter_info=0x7ff4d9fd2870, commit=true)
    at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/sql/handler.cc:4485
#11 0x0000000000d321e2 in mysql_inplace_alter_table (thd=0x7ff498000cf0, table_list=0x7ff498005db8, table=0x7ff498065f60, altered_table=0x7ff49807f850, ha_alter_info=0x7ff4d9fd2870,
    inplace_supported=HA_ALTER_INPLACE_SHARED_LOCK_AFTER_PREPARE, target_mdl_request=0x7ff4d9fd31f0, alter_ctx=0x7ff4d9fd1dd0)
    at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/sql/sql_table.cc:6794
#12 0x0000000000d367ec in mysql_alter_table (thd=0x7ff498000cf0, new_db=0x7ff498006330 "test", new_name=0x0, create_info=0x7ff4d9fd3c80, table_list=0x7ff498005db8, alter_info=0x7ff4d9fd3d60)
    at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/sql/sql_table.cc:8629
#13 0x0000000000e7d727 in Sql_cmd_alter_table::execute (this=0x7ff498006428, thd=0x7ff498000cf0) at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/sql/sql_alter.cc:315
#14 0x0000000000cbb4f7 in mysql_execute_command (thd=0x7ff498000cf0) at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/sql/sql_parse.cc:4785
#15 0x0000000000cbce6a in mysql_parse (thd=0x7ff498000cf0, parser_state=0x7ff4d9fd5660) at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/sql/sql_parse.cc:5397
#16 0x0000000000cb0f2c in dispatch_command (command=COM_QUERY, thd=0x7ff498000cf0, packet=0x7ff498009a21 "ALTER TABLE t4 ADD FULLTEXT INDEX idx(title,body)", packet_length=49)
    at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/sql/sql_parse.cc:1249
#17 0x0000000000cafbd4 in do_command (thd=0x7ff498000cf0) at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/sql/sql_parse.cc:833
#18 0x0000000000dbe89c in handle_connection (arg=0x381b830) at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/sql/conn_handler/connection_handler_per_thread.cc:298
#19 0x000000000138347f in pfs_spawn_thread (arg=0x3671e40) at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/storage/perfschema/pfs.cc:2137
#20 0x0000003deb0079d1 in start_thread (arg=0x7ff4d9fd6700) at pthread_create.c:301
#21 0x0000003deace89dd in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115