Bug #80579 Failing assertion: result != FTS_INVALID in file fts0fts.cc line 2209
Submitted: 2 Mar 2016 5:58 Modified: 2 Mar 2016 6:25
Reporter: Ramesh Sivaraman (OCA) Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: FULLTEXT search Severity:S3 (Non-critical)
Version:5.6.29, 5.7.11 OS:CentOS
Assigned to: CPU Architecture:Any
Tags: debug

[2 Mar 2016 5:58] Ramesh Sivaraman
Description:
GDB info

#0 0x00007fa41c347741 in pthread_kill () from /lib64/libpthread.so.0
#1 0x0000000000ac2f52 in my_write_core (sig=6) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.28-76.1/mysys/stacktrace.c:422
#2 0x0000000000734429 in handle_fatal_signal (sig=6) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.28-76.1/sql/signal_handler.cc:236
#3 <signal handler called>
#4 0x00007fa41ad3e5f7 in raise () from /lib64/libc.so.6
#5 0x00007fa41ad3fce8 in abort () from /lib64/libc.so.6
#6 0x0000000000dbbecd in fts_trx_row_get_new_state (old_state=FTS_INSERT, event=FTS_INSERT) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.28-76.1/storage/innobase/fts/fts0fts.cc:2209
#7 0x0000000000dbc32e in fts_trx_table_add_op (ftt=0x7fa3e3c4a588, doc_id=29, state=FTS_INSERT, fts_indexes=0x0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.28-76.1/storage/innobase/fts/fts0fts.cc:2400
#8 0x0000000000dbc48e in fts_trx_add_op (trx=0x7fa3e3cb9478, table=0x7fa3e3ca5378, doc_id=29, state=FTS_INSERT, fts_indexes=0x0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.28-76.1/storage/innobase/fts/fts0fts.cc:2448
#9 0x0000000000c4978f in row_insert_for_mysql (mysql_rec=0x7fa3e3c26c10 "\374\035", prebuilt=0x7fa3e3c5d078) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.28-76.1/storage/innobase/row/row0mysql.cc:1442
#10 0x0000000000b4381f in ha_innobase::write_row (this=0x7fa3e3c49510, record=0x7fa3e3c26c10 "\374\035") at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.28-76.1/storage/innobase/handler/ha_innodb.cc:7403
#11 0x00000000006506ef in handler::ha_write_row (this=0x7fa3e3c49510, buf=0x7fa3e3c26c10 "\374\035") at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.28-76.1/sql/handler.cc:7708
#12 0x00000000007ca351 in write_record (thd=0x7fa3f3fcd000, table=0x7fa3e3c89800, info=0x7fa41c901940, update=0x7fa41c9019c0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.28-76.1/sql/sql_insert.cc:1947
#13 0x00000000007c8164 in mysql_insert (thd=0x7fa3f3fcd000, table_list=0x7fa3e3c1f3f0, fields=..., values_list=..., update_fields=..., update_values=..., duplic=DUP_ERROR, ignore=false) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.28-76.1/sql/sql_insert.cc:1085
#14 0x00000000007eb776 in mysql_execute_command (thd=0x7fa3f3fcd000) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.28-76.1/sql/sql_parse.cc:3907
#15 0x00000000007f3b69 in mysql_parse (thd=0x7fa3f3fcd000, rawbuf=0x7fa3e3c1f010 "INSERT INTO t1(FTS_DOC_ID,title,body)VALUES (29,'MySQL Tutorial','DBMS stands for DataBase ...'),(30,'How To Use MySQL Well','After you went through a ...'),(32,'Optimizing MySQL','In this tutorial we will show ...'),(34,'1001 MySQL Tricks','1. Never run mysqld as root. 2. ...'),(39,'MySQL vs. YourSQL','In the following database comparison ...'),(40,'MySQL Security','When configured properly,MySQL ...')", length=406, parser_state=0x7fa41c902f40) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.28-76.1/sql/sql_parse.cc:6973
#16 0x00000000007e58e2 in dispatch_command (command=COM_QUERY, thd=0x7fa3f3fcd000, packet=0x7fa3ecf39001 "INSERT INTO t1(FTS_DOC_ID,title,body)VALUES (29,'MySQL Tutorial','DBMS stands for DataBase ...'),(30,'How To Use MySQL Well','After you went through a ...'),(32,'Optimizing MySQL','In this tutorial we will show ...'),(34,'1001 MySQL Tricks','1. Never run mysqld as root. 2. ...'),(39,'MySQL vs. YourSQL','In the following database comparison ...'),(40,'MySQL Security','When configured properly,MySQL ...')", packet_length=406) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.28-76.1/sql/sql_parse.cc:1442
#17 0x00000000007e4750 in do_command (thd=0x7fa3f3fcd000) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.28-76.1/sql/sql_parse.cc:1054
#18 0x00000000007ab724 in do_handle_one_connection (thd_arg=0x7fa3f3fcd000) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.28-76.1/sql/sql_connect.cc:1541
#19 0x00000000007ab1a4 in handle_one_connection (arg=0x7fa3f3fcd000) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.28-76.1/sql/sql_connect.cc:1444
#20 0x0000000000b082d5 in pfs_spawn_thread (arg=0x7fa402bff240) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.28-76.1/storage/perfschema/pfs.cc:1860
#21 0x00007fa41c342dc5 in start_thread () from /lib64/libpthread.so.0
#22 0x00007fa41adff21d in clone () from /lib64/libc.so.6

How to repeat:
Testcase

DROP DATABASE test;CREATE DATABASE test;USE test;
CREATE TABLE t1(FTS_DOC_ID BIGINT UNSIGNED NOT NULL,title CHAR (1),body TEXT) ENGINE=InnoDB;
CREATE FULLTEXT INDEX idx2 ON t1(body);
xa start'','';
set global innodb_limit_optimistic_insert_debug=2;
SET UNIQUE_CHECKS=0;
SET GLOBAL innodb_change_buffering_debug=1;
INSERT INTO t1(FTS_DOC_ID,title,body)VALUES (29,'MySQL Tutorial','DBMS stands for DataBase ...'),(30,'How To Use MySQL Well','After you went through a ...'),(32,'Optimizing MySQL','In this tutorial we will show ...'),(34,'1001 MySQL Tricks','1. Never run mysqld as root. 2. ...'),(39,'MySQL vs. YourSQL','In the following database comparison ...'),(40,'MySQL Security','When configured properly,MySQL ...');
INSERT INTO t1(FTS_DOC_ID,title,body)VALUES (29,'MySQL Tutorial','DBMS stands for DataBase ...'),(30,'How To Use MySQL Well','After you went through a ...'),(32,'Optimizing MySQL','In this tutorial we will show ...'),(34,'1001 MySQL Tricks','1. Never run mysqld as root. 2. ...'),(39,'MySQL vs. YourSQL','In the following database comparison ...'),(40,'MySQL Security','When configured properly,MySQL ...');
[2 Mar 2016 6:25] Umesh Shastry
Hello Ramesh,

Thank you for the report and test case.
Observed that 5.6.29/5.6.31 daily debug builds are affected.

Thanks,
Umesh