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.