mysql process already running when I reboot using Linode console

5 posts / 0 new
Topic locked
Last post
#1 Fri, 03/07/2014 - 10:12
amityweb

mysql process already running when I reboot using Linode console

I have several servers with www.linode.com. If I restart my Linode from the Linode console, when it restarts the database is down. MySQL wont restart because it says a mysql process is already running. I have to login via SSH and delete the var/lib/mysql/mysql.sock file, then do a service mysql start.

So I wondered if this can be avoided? I am sure it only does it on one of my servers, the others seem to restart Ok when I reboot. So wondered if its a configuration issue somewhere.

Thanks

Fri, 03/07/2014 - 10:16
andreychek

Howdy,

Hmm, which distro/version are you using there?

-Eric

Fri, 03/07/2014 - 11:01 (Reply to #2)
amityweb

Sorry... CentOS Linux 6.5

Fri, 03/07/2014 - 11:30
andreychek

Howdy,

That issue actually appears to be a RHEL/CentOS bug... there's some information on how to correct it here:

https://bugzilla.redhat.com/show_bug.cgi?id=1037650

There's also some folks in the forums here who resolved in by just adding a line to their MySQL init script that deleted the .sock file if it exists.

-Eric

Fri, 03/07/2014 - 11:38 (Reply to #4)
amityweb

Ah great, thanks for finding that. Didnt come across that on my googling. Now I know I shall look into it more.

Thanks

Topic locked