Bug #85284 Parameter innodb_ft_aux_table makes database cannot be started

• Submitted: 3 Mar 2017 0:40
• Modified: 3 Mar 2017 6:42
• Reporter: kfpanda kf
• Status: Verified
• Category: MySQL Server: InnoDB storage engine
• Severity: S3 (Non-critical)
• Version: 5.7.17
• OS: Any
• CPU Architecture: Any

[3 Mar 2017 0:40] kfpanda kf

Description:
Hello,
first,i create a table as below.

 CREATE TABLE `db1`.`t11` (
  `id` int(11) DEFAULT NULL,
  `name` varchar(30) DEFAULT NULL,
  FULLTEXT KEY `idx` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

next,i set variable innodb_ft_aux_table.

mysql> set global innodb_ft_aux_table='db1/t11';
Query OK, 0 rows affected (0.00 sec)

then, i add "innodb_ft_aux_table='db1/t11'" into my.cnf(section: mysqld)

then,i restart mysql, error occurs in error log:

2017-03-03T00:29:15.452397Z 0 [ERROR] /usr/local/mysql/bin/mysqld: option '--innodb-ft-aux-table' cannot take an argument
2017-03-03T00:29:15.452431Z 0 [ERROR] Parsing options for plugin 'InnoDB' failed.
2017-03-03T00:29:15.452441Z 0 [ERROR] Failed to initialize plugins.
2017-03-03T00:29:15.452447Z 0 [ERROR] Aborting
 

How to repeat:
Hello,
first,i create a table as below.

 CREATE TABLE `db1`.`t11` (
  `id` int(11) DEFAULT NULL,
  `name` varchar(30) DEFAULT NULL,
  FULLTEXT KEY `idx` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

next,i set variable innodb_ft_aux_table.

mysql> set global innodb_ft_aux_table='db1/t11';
Query OK, 0 rows affected (0.00 sec)

then, i add "innodb_ft_aux_table='db1/t11'" into my.cnf(section: mysqld)

then,i restart mysql, error occurs in error log:

2017-03-03T00:29:15.452397Z 0 [ERROR] /usr/local/mysql/bin/mysqld: option '--innodb-ft-aux-table' cannot take an argument
2017-03-03T00:29:15.452431Z 0 [ERROR] Parsing options for plugin 'InnoDB' failed.
2017-03-03T00:29:15.452441Z 0 [ERROR] Failed to initialize plugins.
2017-03-03T00:29:15.452447Z 0 [ERROR] Aborting
 

Suggested fix:
I hope the variable innodb_ft_aux_table can be maintained in my.cnf.

[3 Mar 2017 6:42] MySQL Verification Team

Hello!

Thank you for the report.

Thanks,
Umesh