MySQL Bugs: #76121: Warning 1235, "FTS auxiliary tables will not be flushed" is printed twice.

Bug #76121	Warning 1235, "FTS auxiliary tables will not be flushed" is printed twice.
Submitted:	3 Mar 2015 10:47	Modified:	3 Mar 2015 12:41
Reporter:	Tsubasa Tanaka (OCA)	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Server: InnoDB storage engine	Severity:	S3 (Non-critical)
Version:	5.6.23, 5.6.24	OS:	Linux (CentOS 6.5)
Assigned to:		CPU Architecture:	Any
Tags:	flush tables for export, fulltext

Description:
Execute "FLUSH TABLE FOR EXPORT" to InnoDB table with FullText Index, warning message is printed twice.

How to repeat:
mysql56> CREATE TABLE articles (
    ->       id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
    ->       title VARCHAR(200),
    ->       body TEXT,
    ->       FULLTEXT (title,body)
    ->     ) ENGINE=InnoDB;
Query OK, 0 rows affected (0.15 sec)

mysql56> FLUSH TABLE articles FOR EXPORT;
Query OK, 0 rows affected, 2 warnings (0.00 sec)

mysql56> SHOW WARNINGS;
+---------+------+----------------------------------------------------------------------------------------------------------------------------------------------+
| Level   | Code | Message                                                                                                                                      |
+---------+------+----------------------------------------------------------------------------------------------------------------------------------------------+
| Warning | 1235 | InnoDB: This version of MySQL doesn't yet support 'FLUSH TABLES on tables that have an FTS index. FTS auxiliary tables will not be flushed.' |
| Warning | 1235 | InnoDB: This version of MySQL doesn't yet support 'FLUSH TABLES on tables that have an FTS index. FTS auxiliary tables will not be flushed.' |
+---------+------+----------------------------------------------------------------------------------------------------------------------------------------------+
2 rows in set (0.00 sec)

### backtrace

## 1st calling

#0  ib_senderrf (thd=0x18fbcd0, level=IB_LOG_LEVEL_WARN, code=1235)
    at /home/ttanaka/mysql-5.6.23/storage/innobase/handler/ha_innodb.cc:16950
#1  0x0000000000a3a355 in row_quiesce_set_state (table=0x7fffa4024868, state=QUIESCE_START, trx=0x7fffa4022bc8)
    at /home/ttanaka/mysql-5.6.23/storage/innobase/row/row0quiesce.cc:663
#2  0x000000000099b41d in ha_innobase::store_lock (this=0x7fffa4021790, thd=0x18fbcd0, to=0x7fffa4042bc8,
    lock_type=TL_READ_NO_INSERT) at /home/ttanaka/mysql-5.6.23/storage/innobase/handler/ha_innodb.cc:12909
#3  0x00000000007e1f4d in get_lock_data (thd=0x18fbcd0, table_ptr=<value optimized out>, count=1,
    flags=<value optimized out>) at /home/ttanaka/mysql-5.6.23/sql/lock.cc:720
#4  0x00000000007e26db in mysql_lock_tables (thd=0x18fbcd0, tables=0x7fffa40055a0, count=1, flags=4096)
    at /home/ttanaka/mysql-5.6.23/sql/lock.cc:301
#5  0x0000000000687782 in lock_tables (thd=0x18fbcd0, tables=0x7fffa4005038, count=<value optimized out>,
    flags=<value optimized out>) at /home/ttanaka/mysql-5.6.23/sql/sql_base.cc:5970
#6  0x0000000000690472 in open_and_lock_tables (thd=0x18fbcd0, tables=0x7fffa4005038, derived=false, flags=4096,
    prelocking_strategy=<value optimized out>) at /home/ttanaka/mysql-5.6.23/sql/sql_base.cc:5734
#7  0x00000000006f1fc8 in flush_tables_for_export (thd=0x18fbcd0, all_tables=0x7fffa4005038)
    at /home/ttanaka/mysql-5.6.23/sql/sql_reload.cc:551
#8  0x00000000006db293 in mysql_execute_command (thd=0x18fbcd0) at /home/ttanaka/mysql-5.6.23/sql/sql_parse.cc:4185
#9  0x00000000006dcf47 in mysql_parse (thd=0x18fbcd0, rawbuf=<value optimized out>, length=<value optimized out>,
    parser_state=<value optimized out>) at /home/ttanaka/mysql-5.6.23/sql/sql_parse.cc:6357
#10 0x00000000006de8fc in dispatch_command (command=COM_QUERY, thd=0x18fbcd0, packet=0x7fffc7597af0 "м\217\001",
    packet_length=25) at /home/ttanaka/mysql-5.6.23/sql/sql_parse.cc:1332
#11 0x00000000006a655d in do_handle_one_connection (thd_arg=<value optimized out>)
    at /home/ttanaka/mysql-5.6.23/sql/sql_connect.cc:982
#12 0x00000000006a6692 in handle_one_connection (arg=0x18fbcd0) at /home/ttanaka/mysql-5.6.23/sql/sql_connect.cc:898
#13 0x000000000097acf7 in pfs_spawn_thread (arg=0x1950470) at /home/ttanaka/mysql-5.6.23/storage/perfschema/pfs.cc:1860
#14 0x0000003eb84079d1 in start_thread () from /lib64/libpthread.so.0
#15 0x0000003eb7ce886d in clone () from /lib64/libc.so.6

## 2nd calling

#0  ib_senderrf (thd=0x18fbcd0, level=IB_LOG_LEVEL_WARN, code=1235)
    at /home/ttanaka/mysql-5.6.23/storage/innobase/handler/ha_innodb.cc:16950
#1  0x0000000000a3a355 in row_quiesce_set_state (table=0x7fffa4024868, state=QUIESCE_COMPLETE, trx=0x7fffa4022bc8)
    at /home/ttanaka/mysql-5.6.23/storage/innobase/row/row0quiesce.cc:663
#2  0x0000000000a3b531 in row_quiesce_table_start (table=0x7fffa4024868, trx=0x7fffa4022bc8)
    at /home/ttanaka/mysql-5.6.23/storage/innobase/row/row0quiesce.cc:568
#3  0x00000000009a0e2a in ha_innobase::external_lock (this=0x7fffa4021790, thd=0x18fbcd0, lock_type=0)
    at /home/ttanaka/mysql-5.6.23/storage/innobase/handler/ha_innodb.cc:12180
#4  0x000000000058d91b in handler::ha_external_lock (this=0x7fffa4021790, thd=0x18fbcd0, lock_type=0)
    at /home/ttanaka/mysql-5.6.23/sql/handler.cc:7190
#5  0x00000000007e2782 in lock_external (thd=0x18fbcd0, tables=<value optimized out>, count=<value optimized out>,
    flags=4096) at /home/ttanaka/mysql-5.6.23/sql/lock.cc:362
#6  mysql_lock_tables (thd=0x18fbcd0, tables=<value optimized out>, count=<value optimized out>, flags=4096)
    at /home/ttanaka/mysql-5.6.23/sql/lock.cc:306
#7  0x0000000000687782 in lock_tables (thd=0x18fbcd0, tables=0x7fffa4005038, count=<value optimized out>,
    flags=<value optimized out>) at /home/ttanaka/mysql-5.6.23/sql/sql_base.cc:5970
#8  0x0000000000690472 in open_and_lock_tables (thd=0x18fbcd0, tables=0x7fffa4005038, derived=false, flags=4096,
    prelocking_strategy=<value optimized out>) at /home/ttanaka/mysql-5.6.23/sql/sql_base.cc:5734
#9  0x00000000006f1fc8 in flush_tables_for_export (thd=0x18fbcd0, all_tables=0x7fffa4005038)
    at /home/ttanaka/mysql-5.6.23/sql/sql_reload.cc:551
#10 0x00000000006db293 in mysql_execute_command (thd=0x18fbcd0) at /home/ttanaka/mysql-5.6.23/sql/sql_parse.cc:4185
#11 0x00000000006dcf47 in mysql_parse (thd=0x18fbcd0, rawbuf=<value optimized out>, length=<value optimized out>,
    parser_state=<value optimized out>) at /home/ttanaka/mysql-5.6.23/sql/sql_parse.cc:6357
#12 0x00000000006de8fc in dispatch_command (command=COM_QUERY, thd=0x18fbcd0, packet=0x7fffc7597af0 "м\217\001",
    packet_length=25) at /home/ttanaka/mysql-5.6.23/sql/sql_parse.cc:1332
#13 0x00000000006a655d in do_handle_one_connection (thd_arg=<value optimized out>)
    at /home/ttanaka/mysql-5.6.23/sql/sql_connect.cc:982
#14 0x00000000006a6692 in handle_one_connection (arg=0x18fbcd0) at /home/ttanaka/mysql-5.6.23/sql/sql_connect.cc:898
#15 0x000000000097acf7 in pfs_spawn_thread (arg=0x1950470) at /home/ttanaka/mysql-5.6.23/storage/perfschema/pfs.cc:1860
#16 0x0000003eb84079d1 in start_thread () from /lib64/libpthread.so.0
#17 0x0000003eb7ce886d in clone () from /lib64/libc.so.6

Hello tanaka-san,

Thank you for the report and test case.

Thanks,
Umesh

Hello tanaka-san,

Thank you for the report and test case.

Thanks,
Umesh

// 5.6.24
// Related - http://bugs.mysql.com/bug.php?id=76120

mysql> FLUSH TABLE d1.articles FOR EXPORT;
Query OK, 0 rows affected, 2 warnings (0.01 sec)

mysql> SHOW WARNINGS;
+---------+------+----------------------------------------------------------------------------------------------------------------------------------------------+
| Level   | Code | Message                                                                                                                                      |
+---------+------+----------------------------------------------------------------------------------------------------------------------------------------------+
| Warning | 1235 | InnoDB: This version of MySQL doesn't yet support 'FLUSH TABLES on tables that have an FTS index. FTS auxiliary tables will not be flushed.' |
| Warning | 1235 | InnoDB: This version of MySQL doesn't yet support 'FLUSH TABLES on tables that have an FTS index. FTS auxiliary tables will not be flushed.' |
+---------+------+----------------------------------------------------------------------------------------------------------------------------------------------+
2 rows in set (0.00 sec)

mysql> show variables like '%version%';
+-------------------------+---------------------------------------------------------+
| Variable_name           | Value                                                   |
+-------------------------+---------------------------------------------------------+
| innodb_version          | 5.6.24                                                  |
| protocol_version        | 10                                                      |
| slave_type_conversions  |                                                         |
| version                 | 5.6.24-enterprise-commercial-advanced                   |
| version_comment         | MySQL Enterprise Server - Advanced Edition (Commercial) |
| version_compile_machine | x86_64                                                  |
| version_compile_os      | Linux                                                   |
+-------------------------+---------------------------------------------------------+
7 rows in set (0.00 sec)