Bug #76243 rc script does not respect both delimiters for service timeout startup
Submitted: 10 Mar 2015 13:17 Modified: 9 Aug 12:28
Reporter: John Cesario Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.5.41 OS:Linux (RH)
Assigned to: CPU Architecture:Any

[10 Mar 2015 13:17] John Cesario
Description:
service-startup-timeout is documented here: http://dev.mysql.com/doc/refman/5.5/en/mysql-server.html#option_mysql_server_service-start....

The RC script does not respect the option if using _ for delimiters

head -n 3 /etc/my.cnf
[mysql.server]
service-startup-timeout = 1800

% 13:14 <vagrant@db1:/data/mysql $ > sudo bash -x  /etc/init.d/mysql status 2>&1 | grep service_startup_timeout
+ service_startup_timeout=900
+ service_startup_timeout=1800

% 13:14 <vagrant@db1:/data/mysql $ > head -n 3 /etc/my.cnf
[mysql.server]
service_startup_timeout = 1800

% 13:14 <vagrant@db1:/data/mysql $ > sudo bash -x  /etc/init.d/mysql status 2>&1 | grep service_startup_timeout
+ service_startup_timeout=900

How to repeat:
add the following to /etc/my.cnf: 

<<<
[mysql.server]
service_startup_timeout = 1800
<<<

sudo bash -x /etc/init.d/mysql start
sudo bash -x /etc/init.d/mysql stop

Note the value of service-startup-timeout is unchanged from default

Suggested fix:
Respect both _ and - in /etc/my.cnf
[10 Mar 2015 15:55] Peter Laursen
In my understanding *options* are specifiedw ith "-" ; whereas variables are specifie dwith a "_" (like this-is-an-option & this_is_a_variable). 

A server variable will often inherit its value from an option specified on the options file or on the command line but an option is still not a variable and vice versa.

http://dev.mysql.com/doc/refman/5.6/en/server-options.html
http://dev.mysql.com/doc/refman/5.6/en/server-system-variables.html

But I also think that MySQL is not everywhere consistent in this respect (I believe I remember some old reports where such *incorrect typing* of options is accepted). 

-- Peter
-- not a MySQL/Oracle person
[1 Jul 13:14] Sinisa Milivojevic
Hi Mr. Cesario,

Thank you for your bug report.

Unlike the options specified under [mysqld] header, all other options have to use dash sign '-' and not '_'. Let us know if it helps ................
[9 Aug 1:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".