mysqld working fine but systemctl reports failed.
I am seeing potentially "false" errors in todays reboot on a jessie system...
Nov 20 09:51:40 xxxx /etc/init.d/mysql[1857]: #007/usr/bin/mysqladmin: connect to server at 'localhost' failed
Nov 20 09:51:40 xxxx /etc/init.d/mysql[1857]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Nov 20 09:51:40 xxxx /etc/init.d/mysql[1857]:
Nov 20 09:51:40 xxxx mysql[705]: Starting MySQL database server: mysqld . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . failed!
Oddly databases seem to be running sweetly, and using systemctl to stop and start mysql work fine too:
systemctl status mysql
● mysql.service - LSB: Start and stop the mysql database server daemon
Loaded: loaded (/etc/init.d/mysql)
Active: active (running) since Tue 2018-11-20 11:12:44 GMT; 20min ago
Process: 18953 ExecStop=/etc/init.d/mysql stop (code=exited, status=0/SUCCESS)
Process: 18994 ExecStart=/etc/init.d/mysql start (code=exited, status=0/SUCCESS)
CGroup: /system.slice/mysql.service
├─19021 /bin/sh /usr/bin/mysqld_safe
└─19366 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib/mysql/plugin --user=...
Nov 20 11:12:44 xxxx mysql[18994]: Starting MySQL database server: mysqld ..
Nov 20 11:12:44 xxxx mysql[18994]: Checking for tables which need an upgrade, are corrupt or were
Nov 20 11:12:44 xxxx mysql[18994]: not closed cleanly..
Nov 20 11:12:44 xxxx systemd[1]: Started LSB: Start and stop the mysql database server daemon.
Incidentally systemd and mysql was upgraded prior to the reboot. The mysql update did take a long time .... a few
minutes ... but no errors reported.
Setting up mysql-client-5.5 (5.5.62-0+deb8u1) ...
Setting up mysql-server-core-5.5 (5.5.62-0+deb8u1) ...
Setting up mysql-server-5.5 (5.5.62-0+deb8u1) ...
Setting up mysql-server (5.5.62-0+deb8u1) ...
Setting up mysql-client (5.5.62-0+deb8u1) ..
All very perplexing ... one to ignore?
Thanks
Bernie
Reply to: