I think one of Linux’s blessings can also be a curse.
You can have a machine that doesn’t get rebooted for weeks if not months and when it needs to be rebooted (usually to get moved or have the hardware reconfigured) things that have been working suddenly stop.
I had this happen today and this story might help someone who finds themselves in the same boat.
I have a machine running Bugzilla on Fedora FC2. Bugzilla requires mysql, I have 3.23 installed. Everything was fine, Bugzilla has been churning away for months, until today. I had to shutdown the machine in order to move it.
Bugzilla soon started to complain it couldn’t get into the database. No problem I think as I go an attempt to restart mysqld, instead of the restart message I get:
“mysqld dead but subsys locked”.
I do all the magic I usually do if mysql gets hosed, but to no avail.
Checking the log file in
/var/log/mysqld.log
I see the following at the top:
050503 11:54:14 mysqld started
/usr/libexec/mysqld: unrecognized option `–ft_min_word_len=2′
/usr/libexec/mysqld Ver 3.23.54 for redhat-linux-gnu on i386
Copyright (C) 2000 MySQL AB, by Monty and others
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
Starts the MySQL server
Usage: /usr/libexec/mysqld [OPTIONS]
It appears that somehow the `–ft_min_word_len=2′ option got added to my /etc/my.cnf file, and that option was preventing mysql from restarting. By removing that line everything was back to normal.
It appears that Bugzilla is the application that made this change to the /etc/my.cnf file
Looking at the bug reports at Bugzilla it doesn’t appear that there is any problem removing this configuration line.