Bug #58479 Parameter value set in Part:[mysqld] covered by same parameter set in Part:[mysq

• Submitted: 25 Nov 2010 5:18
• Modified: 25 Nov 2010 19:14
• Reporter: He yunfei
• Status: Not a Bug
• Category: MySQL Server
• Severity: S2 (Serious)
• Version: 5.5.7 r2
• OS: Linux (rhel 5u4)
• CPU Architecture: Any
• Tags: system parameter log-error

[25 Nov 2010 5:18] He yunfei

Description:
As normal,Mysql would use Parameter value which set with Part:mysqld even if it also set with Part:[mysqld_safe]; 
But at version :5.5.7-rc-log, Mysql use values with [mysqld_safe] first;

How to repeat:

# my.cnf
[mysqld]
log-error=/home/mysql/data/mysql/master-error.log

[mysqld_safe]
log_error=massssster-error.log

==========================

service mysql start;

root@127.0.0.1 : (none) 13:10:13> select version() ; 
+--------------+
| version()    |
+--------------+
| 5.5.7-rc-log |
+--------------+
1 row in set (0.00 sec)

root@127.0.0.1 : (none) 13:10:18> show variables like 'log_error%';
+---------------+---------------------------------------------+
| Variable_name | Value                                       |
+---------------+---------------------------------------------+
| log_error     | /home/mysql/data/mysql/massssster-error.log |
+---------------+---------------------------------------------+
1 row in set (0.00 sec)

Suggested fix:
It should be mysqld first;

[25 Nov 2010 19:14] Sveta Smirnova

Thank you for taking the time to write to us, but this is not a bug. Please double-check the documentation available at http://dev.mysql.com/doc/ and the instructions on
how to report a bug at http://bugs.mysql.com/how-to-report.php

This is not order, but how mysqld_safe handles log_error and log-error difference. See bug #40368 which is fixed in 5.5 series.