'start mysql' never returns and no mysqld running

[bretzeltux]

Since /etc/rc2.d/S19mysql does not exists anymore, and then init.d/mysql uses /sbin/start, I am unable to use mysql server anymore:

me@mycomputer~#start mysql [ret]
...... for hours this command never returns so that ^C aborts...

me@mycomputer~#ps axw |grep mysql
( no results, no mysql!!! )

me@mycomputer~#stop mysql [ret]
no returns either!!!

This upstart [start|stop] thing seems a total failure for mysql!!!
need help!

[ghost_ryder35]

Since /etc/rc2.d/S19mysql does not exists anymore, and then init.d/mysql uses /sbin/start, I am unable to use mysql server anymore:

me@mycomputer~#start mysql [ret]
...... for hours this command never returns so that ^C aborts...

me@mycomputer~#ps axw |grep mysql
( no results, no mysql!!! )

me@mycomputer~#stop mysql [ret]
no returns either!!!

This upstart [start|stop] thing seems a total failure for mysql!!!
need help!

does the following command work?

/etc/init.d/mysql start

[bretzeltux]

It does the same thing

manually :
sudo /sbin/mysqld &

does works but not really the right thing to do ...

and...:
'Since /etc/rc2.d/S19mysql does not exists anymore, and then init.d/mysql uses /sbin/start, I am unable to use mysql server anymore:'

Why are you asking me to do what I've already reported that won't work ?

[ghost_ryder35]

It does the same thing

manually :
sudo /sbin/mysqld &

does works but not really the right thing to do ...

and...:
'Since /etc/rc2.d/S19mysql does not exists anymore, and then init.d/mysql uses /sbin/start, I am unable to use mysql server anymore:'

Why are you asking me to do what I've already reported that won't work ?

i was just trying to help troubleshoot. perhaps you should install mysql on another server and copy the init script from that one over to the broken one.

[bretzeltux]

Sorry if I looked a bit rude -

• My Server is not 'broken'
• manually starting mysqld from /sbin/mysqld - does work
• Thus what I am totaly screwed in is with 'upstart' :/sbin/start | stop for mysql - that seems itself 'screwed/screweing mysql service'
• ubuntu server 9.10/10.04 behaviour are the same(I guess same failures with desktop editions as well!)...

Is mysql installation scripts packages have been ever tested since 9.10 ???
In my book it does not ... rather it was 'assumed to work...'...

If I read other topics ( desktop/server editions ) it seems the same related problems occured for other users ...

[dannyboy79]

Looking at the mysqld upstart job (/etc/init/mysqld.conf) you can see that it "start on (net-device-up". Since mysqld is configured to bind to a specific address it fails to start if the network interface isn't up yet.

I'd suggest to update mysqld upstart job to "start on (net-device-up IFACE=ethX" to start mysqld only when the correct interface is up.

found this bug here:
https://bugs.launchpad.net/ubuntu/+s....1/+bug/566736