[debian-mysql] Bug#892732: Complete description

[BERGER, MARC]

Sorry for the previous message with incomplete lines. Its not that easy to pass the descrption from my Debian machin where I cannot send emails to my Ms Win machine ☹

Package: mysql-server
Version: 5.5.9999+default
Severity: important

Dear Maintainer,

   When i call 'sudo service mysql restart' it sometimes fails with a log like :
Mar  8 16:20:22 localhost systemd[1]: Stopping LSB: Start and stop the mysql database server daemon...
Mar  8 16:20:22 localhost mysql[1847]: Stopping MySQL database server: mysqld.
Mar  8 16:20:22 localhost systemd[1]: Stopped LSB: Start and stop the mysql database server daemon.
Mar  8 16:20:22 localhost systemd[1]: Starting LSB: Start and stop the mysql database server daemon...
Mar  8 16:20:54 localhost /etc/init.d/mysql[2492]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Mar  8 16:20:54 localhost /etc/init.d/mysql[2492]: #007/usr/bin/mysqladmin: connect to server at 'localhost' failed
Mar  8 16:20:54 localhost /etc/init.d/mysql[2492]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Mar  8 16:20:54 localhost /etc/init.d/mysql[2492]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!


   I made some tests and it appears that after the 'stop' step the mysql server is sometimes not really 'dead' yet. I can sometimes see it still running when I use the following command line:
                sudo  systemctl stop  mysql; ps -ef | grep -i sql; sudo  systemctl start mysql

 Of course, when it happens, the start treatment of  /etc/init.d/mysql will assume that a server is already running. It will skip the start this service and directly go to the part where it tries to connect to the Mysql server thorugh the socket. As the server is now dead it fails and I get these errors in the syslog.
 And of course the service is not started.

 I 'think' that this behavior could be caused by a massive select query running on the MySQL database at the moment the stop step of the init script is called.

Best Regards,
Marc

Ce message et toutes les pièces jointes (ci-après le "message") sont établis à l’intention exclusive des destinataires désignés. Il contient des informations confidentielles et pouvant être protégé par le secret professionnel. Si vous recevez ce message par erreur, merci d'en avertir immédiatement l'expéditeur et de détruire le message. Toute utilisation de ce message non conforme à sa destination, toute diffusion ou toute publication, totale ou partielle, est interdite, sauf autorisation expresse de l’émetteur. L'internet ne garantissant pas l'intégrité de ce message lors de son acheminement, Atos (et ses filiales) décline(nt) toute responsabilité au titre de son contenu. Bien que ce message ait fait l’objet d’un traitement anti-virus lors de son envoi, l’émetteur ne peut garantir l’absence totale de logiciels malveillants dans son contenu et ne pourrait être tenu pour responsable des dommages engendrés par la transmission de l’un d’eux.

This message and any attachments (the "message") are intended solely for the addressee(s). It contains confidential information, that may be privileged. If you receive this message in error, please notify the sender immediately and delete the message. Any use of the message in violation of its purpose, any dissemination or disclosure, either wholly or partially is strictly prohibited, unless it has been explicitly authorized by the sender. As its integrity cannot be secured on the internet, Atos and its subsidiaries decline any liability for the content of this message. Although the sender endeavors to maintain a computer virus-free network, the sender does not warrant that this transmission is virus-free and will not be liable for any damages resulting from any virus transmitted.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.alioth.debian.org/pipermail/pkg-mysql-maint/attachments/20180312/fa93491e/attachment.html>