Bug 130721

Summary:	mysqld won't start
Product:	[openSUSE] SUSE LINUX 10.0	Reporter:	Jan Engelhardt <jengelh>
Component:	Development	Assignee:	Petr Ostadal <postadal>
Status:	VERIFIED FIXED	QA Contact:	E-mail List <qa-bugs>
Severity:	Normal
Priority:	P5 - None
Version:	RC 4
Target Milestone:	---
Hardware:	x86
OS:	Linux
Whiteboard:
Found By:	Beta-Customer	Services Priority:
Business Priority:		Blocker:	---
Marketing QA Status:	---	IT Deployment:	---

Description Jan Engelhardt 2005-10-26 11:43:57 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.

Comment 1 Petr Ostadal 2005-10-26 13:15:54 UTC

Try set environment variables step by step inithialized from init scrip and try find out which variable can cause it.

Comment 2 Jan Engelhardt 2005-10-28 12:46:22 UTC

If I remove the "export TMPDIR=" line, it works.

Comment 3 Jan Engelhardt 2005-10-28 12:48:13 UTC

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.

Comment 4 Petr Ostadal 2005-11-14 12:33:59 UTC

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.

Comment 6 Andreas Jaeger 2005-11-14 14:54:53 UTC

Approved for YOU update, Maintenance-Tracker-2901

Comment 7 Michal Marek 2005-12-06 13:34:10 UTC

Submitted with patchinfo for 10.0.

Comment 8 Anja Stock 2006-01-09 09:05:52 UTC

released