Bugzilla – Bug 130721
mysqld won't start
Last modified: 2006-01-09 09:05:52 UTC
For some very obscure reason, rcmysqld doesnot start the sql server. Running the script with "bash -x /etc/init.d/mysql start" shows: + echo -n 'Starting service MySQL ' Starting service MySQL + /usr/bin/mysqld_safe --user=mysql --pid-file=/var/lib/mysql/mysqld.pid --socket=/var/lib/mysql/mysql.sock Starting mysqld daemon with databases from /var/lib/mysql STOPPING server from pid file /var/lib/mysql/mysqld.pid 051026 13:41:51 mysqld ended + (( i=0 )) + (( i<50 )) + sleep 0.2 + test -S /var/lib/mysql/mysql.sock + i= + break + test -z '' + rc_status -v starting the above command "/usr/bin/mysqld_safe --user=mysql --pid-file=/var/lib/mysql/mysqld.pid --socket=/var/lib/mysql/mysql.sock" by hand on the shell starts the daemon.
Try set environment variables step by step inithialized from init scrip and try find out which variable can cause it.
If I remove the "export TMPDIR=" line, it works.
I don't have a /var/lib/mysql/tmp directory. But I never removed any, so SUSE does not create it. What also bothers me is that /etc/init.d/mysql hangs forever now. This is due to mysqld_safe not being put in the background.
Sorry for too late response, I was ill. The /var/lib/mysql/tmp directory is created in %pre phase, and something fails in %pre phase before this command was reached in your case (but I can't reproduce it on any system I have tested). I don't know why pnemec@ author of this change give this command to %pre phase instead to %install phase (maybe some mistake), I will fix it for STABLE.
Approved for YOU update, Maintenance-Tracker-2901
Submitted with patchinfo for 10.0.
released