Bug #37572 Spurious startup errors from mysqld_safe on 64-bit linux
Submitted: 22 Jun 2008 17:33 Modified: 23 Jun 2008 6:45
Reporter: Jon Stephens Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server: General Severity:S3 (Non-critical)
Version:5.1.26-bzr OS:Linux (64-bit opensuse 10.2)
Assigned to: CPU Architecture:Any

[22 Jun 2008 17:33] Jon Stephens
Description:
Attempting to run mysqld_safe from bin directory yields the following error message:

jon@tonfisk:~/bin/mysql-5.1/bin> ./mysqld_safe &
[1] 18383
jon@tonfisk:~/bin/mysql-5.1/bin> ./mysqld_safe: line 297: my_print_defaults: command not found
./mysqld_safe: line 303: my_print_defaults: command not found
080622 18:59:18 mysqld_safe Logging to '/home/jon/mysql-5.1/var/tonfisk.err'.
080622 18:59:18 mysqld_safe The file /home/jon/mysql-5.1/libexec/mysqld
does not exist or is not executable. Please cd to the mysql installation
directory and restart this script from there as follows:
./bin/mysqld_safe&
See http://dev.mysql.com/doc/mysql/en/mysqld-safe.html for more information
./mysqld_safe: line 96: /home/jon/mysql-5.1/var/tonfisk.err: No such file or directory

[1]+  Exit 1                  ./mysqld_safe

mysqld_safe is in the bin directory and is executable. my_print_defaults is also in the bin directory and is executable. mysqld is in the libexec directory and is executable. -hostname-.err file is in the var directory and is writeable.

I first started noticing this problem with a 5.1 server built 2008-06-14, and have the same issue with a 5.1 server built today. Issue does not appear in 5.0, 6.0, or telco trees. Issue does not occur on 32-bit version of OS.

All executables built as follows:

[my-bzr-root]/BUILD/autorun.sh
./configure --with-plugins=all --prefix=/home/jon/bin/[version]
make
make install [as user jon]

All files owned by user jon.

How to repeat:
See description.

Suggested fix:
Should be possible to invoke mysqld_safe from any directory, including the bin directory in which it is installed.

Looks similar to Bug #32679 - possible regression? However, this issue is not occurring in 6.0, and it's happening with 64-bit OS only.
[22 Jun 2008 20:53] Sveta Smirnova
Thank you for the report.

I can not repeat described behavior. Also current bzr tree is 5.1.27. could you please upgrade, try again and inform us about results??
[23 Jun 2008 6:45] Jon Stephens
Nuked the install directory and my 5.1 clone, rebuilt from fresh bzr clone, problem went away.

"Move along, nothing to see here..."