Bug #3055 innodb_flush_log_at_trx_commit value incorrectly set from gui

• Submitted: 3 Mar 2004 3:22
• Modified: 3 Mar 2004 4:08
• Reporter: John Martin
• Status: Closed
• Category: MySQL Administrator
• Severity: S2 (Serious)
• Version: 1.0.1a
• OS: Windows (WinXP)
• Assigned to: Ulrich Bayer
• CPU Architecture: Any

[3 Mar 2004 3:22] John Martin

Description:
When setting the "Flush Logs at:" property to "Write to Log and flush every second" on the InnonDB Parameters tab, actually saves the text from the dropdown instead of the values (0, 1 or 2).

This bug prevents the db from restarting do to the configuration error.

How to repeat:
- Start mySQLAdministrator
- Click on Startup Variables
- Click on InnoDB Parameters
- Select "Write to Log and flush every second"
- Click Apply changes
- View my.cnf file and search for the tag innodb_flush_log_at_trx_commit

[3 Mar 2004 4:08] Ulrich Bayer

Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html

Additional info:

Thanks, the fix will be in the next release. We have reworked the whole startup variables code quite a bit.