MySQL Bugs: #4783: Administrator setting critical ini file options prevents service startup

Bug #4783	Administrator setting critical ini file options prevents service startup
Submitted:	28 Jul 2004 11:04	Modified:	30 Jul 2004 23:03
Reporter:	Andreas Götz	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Administrator	Severity:	S3 (Non-critical)
Version:	1.0.8	OS:	Windows (WinXP)
Assigned to:	Ulrich Bayer	CPU Architecture:	Any

Description:
Toying with Administrator, I've set the following options via UI:

#Log queries that are executed without benefit of any index.
log-queries-not-using-indexes

#Logs will be rotated after expire-log-days days
expire_logs_days=14

Running MySQL 4.0.20d this caused the service to not startup after reboot.

How to repeat:
.

Suggested fix:
Add a warning when adminsitrator is running on not fully supported MySQL version or don't set ini file options that cause problems on a specific version.

Thanks for reporting. The version check for this option is missing (see xml\mysqladmin_startup_variables_description.xml). We will add this asap.

Mhhm. Checked this file and mine actually says

<checkbox position="1" id="log-queries-not-using-indexes" version_start="4.1.0">

It seems as if the check is not executed, not that the information from the xml file is incorrect?

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:

The xml-file is ok but there was a bug in the application.