-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
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.
Ciao, luigi
- -- / +--[Luigi Rosa]-- \
Microsoft may issue tablets by Christmas. No word yet on whether they'll contain potassium cyanide or saxitoxin. --fark.com
On Mon, 16 Dec 2013 10:51:54 +0100 Luigi Rosa lists@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.
Ciao, luigi
CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
Hi,
As a *temporary* solution you could do the following:
# chkconfig mysqld off # nano /etc/rc.local Add at bottom: rm /var/lib/mysql/mysql.sock service mysqld start Now Save.
Next time the machine boots it should remove the sock file, and then start mysqld.
Once your PSU is fixed, remove those lines and run:
# chkconfig mysqld on
Job done! :-D
Hope this helps.
Kind Regards, Jake Shipton (JakeMS) GPG Key: 0xE3C31D8F GPG Fingerprint: 7515 CC63 19BD 06F9 400A DE8A 1D0B A5CF E3C3 1D8F
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
I can confirm that this is a bug added to the latest releases og MySQL.
I tested it only in VM (both VMware and XEN).
How to reproduce.
* start a CentOS VM with MySQL * abruptly turn the VM off (not shutdown, of course) * restart VM * MySQL starts but the connections via /var/lib/mysql/mysql.sock do not work
Jake Shipton said the following on 16/12/2013 11:12:
On Mon, 16 Dec 2013 10:51:54 +0100 Luigi Rosa lists@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.
Ciao, luigi
_______________________________________________ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
Hi,
As a *temporary* solution you could do the following:
# chkconfig mysqld off # nano /etc/rc.local Add at bottom: rm /var/lib/mysql/mysql.sock service mysqld start Now Save.
Next time the machine boots it should remove the sock file, and then start mysqld.
Once your PSU is fixed, remove those lines and run:
# chkconfig mysqld on
Job done! :-D
Hope this helps.
Kind Regards, Jake Shipton (JakeMS) GPG Key: 0xE3C31D8F GPG Fingerprint: 7515 CC63 19BD 06F9 400A DE8A 1D0B A5CF E3C3 1D8F _______________________________________________ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
Ciao, luigi
- -- / +--[Luigi Rosa]-- \
ANOTHER GLITCH IN THE CALL We don't need no indirection We don't need no flow control No data typing or declarations Did you leave those lists alone Hey! Hacker! Leave those lists alone! All in all, it's just a pure-Lisp function call
On Fri, 20 Dec 2013, Luigi Rosa wrote:
I can confirm that this is a bug added to the latest releases og MySQL.
I tested it only in VM (both VMware and XEN).
How to reproduce.
- start a CentOS VM with MySQL
- abruptly turn the VM off (not shutdown, of course)
- restart VM
- MySQL starts but the connections via /var/lib/mysql/mysql.sock do not work
I've seen this too, and not just on VMs.
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
Paul Heinlein said the following on 20/12/2013 16:50:
On Fri, 20 Dec 2013, Luigi Rosa wrote:
I can confirm that this is a bug added to the latest releases og MySQL.
I tested it only in VM (both VMware and XEN).
How to reproduce.
- start a CentOS VM with MySQL * abruptly turn the VM off (not shutdown,
of course) * restart VM * MySQL starts but the connections via /var/lib/mysql/mysql.sock do not work
I've seen this too, and not just on VMs.
A friend just told me that he saw this issue recently on a Debian server, so is definitively a MySQL problem.
Ciao, luigi
- -- / +--[Luigi Rosa]-- \
Customer: I have Windows Vista on my computer. Tech: Yes. Customer: My computer isn't working right. Tech: Yes. You already told me that.
-
Jake Shipton -
Luigi Rosa -
Paul Heinlein