Bug #55029 Error while setting value 'FALSE' to 'innodb in my.ini

• Submitted: 6 Jul 2010 15:23
• Modified: 17 Sep 2010 10:10
• Reporter: Tommy Tremblay
• Status: Closed
• Category: MySQL Workbench: Administration
• Severity: S1 (Critical)
• Version: 5.2.24, 5.2.25
• OS: Any (2008R2 with MySQL 5.1.48, Mac OS X)
• Assigned to: Maksym Yehorov
• CPU Architecture: Any
• Tags: error, false, innodb, log, my.ini, value

[6 Jul 2010 15:23] Tommy Tremblay

Description:
When modifying the config file in Workbench to desactivate innodb, the MySQL server won't restart.

How to repeat:
Open MySQL Workbench, go to "Server Administration" ---> "InnoDB Parameters" ---> Uncheck "Activate InnoDB" ---> Apply and restart MySQL Server.  You will get this in your error log:

100706 10:38:42 [ERROR] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Error while setting value 'FALSE' to 'innodb'

Suggested fix:
Open my.ini and remove the line:

innodb = FALSE

replace by:

skip-innodb

save and restart MySQL server.

[6 Jul 2010 20:18] MySQL Verification Team

I got an exception error when unchecked or check it on Windows Vista and Workbench version 5.2.25.

[7 Jul 2010 4:13] Valeriy Kravchuk

Verified with 5.2.25 on Mac OS X. No exceptions or warnings. Just wrong entry is added to my.cnf.

[12 Jul 2010 8:23] Maksym Yehorov

Fixed

[30 Aug 2010 13:03] Maksym Yehorov

Fixed innodb handling. innodb format is different for different server versions. Due to that skip-innodb moved to a separate option and placed next to innodb in the same config page section.

[16 Sep 2010 19:45] Johannes Taxacher

fix confirmed in repository

[17 Sep 2010 10:10] Tony Bedford

An entry has been added to the 5.2.28 changelog:

If the MySQL server configuration file was modified using the Administrator to deactivate InnoDB, the MySQL server failed to restart, and generated the following error in the log:

 [ERROR] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Error while
setting value 'FALSE' to 'innodb'