[CentOS] MySQL stale socket
jakems at fedoraproject.org
Mon Dec 16 10:12:38 UTC 2013
On Mon, 16 Dec 2013 10:51:54 +0100
Luigi Rosa <lists at luigirosa.com> wrote:
> I have a server with a faulty power supply that resets the server
> every 4/5 hours.
> While I wait for the supplier to change the PS, I am facing an issue
> with MySQL.
> When the system comes back on, mysqld script starts the daemon, but
> the connections via /var/lib/mysql/mysql.sock don't work because
> MySQL doesn't delete and recreate the stale socket.
> Apart from editing /etc/init.d/mysqld to force the deletion of a
> stale socket are there any other way to solve this issue?
> Thank you un advance.
> CentOS mailing list
> CentOS at centos.org
As a *temporary* solution you could do the following:
# chkconfig mysqld off
# nano /etc/rc.local
Add at bottom:
service mysqld start
Next time the machine boots it should remove the sock file, and then
Once your PSU is fixed, remove those lines and run:
# chkconfig mysqld on
Job done! :-D
Hope this helps.
Jake Shipton (JakeMS)
GPG Key: 0xE3C31D8F
GPG Fingerprint: 7515 CC63 19BD 06F9 400A DE8A 1D0B A5CF E3C3 1D8F
More information about the CentOS