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

[3 Mar 2015 10:47] Tsubasa Tanaka 
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
[3 Mar 2015 12:41] MySQL Verification Team 
Hello tanaka-san,

Thank you for the report and test case.

Thanks,
Umesh
[3 Mar 2015 12:48] MySQL Verification Team 
Hello tanaka-san,

Thank you for the report and test case.

Thanks,
Umesh
[3 Mar 2015 12:50] MySQL Verification Team 
// 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)

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.041 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.