Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > linux.debian.user > #202638

mysqld working fine but systemctl reports failed.

From Bernie Elbourn <berni421@gmail.com>
Newsgroups linux.debian.user
Subject mysqld working fine but systemctl reports failed.
Date 2018-11-20 13:10 +0100
Message-ID <wWd0R-eK-3@gated-at.bofh.it> (permalink)
Organization linux.* mail to news gateway

Show all headers | View raw


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

Back to linux.debian.user | Previous | Next | Find similar | Unroll thread


Thread

mysqld working fine but systemctl reports failed. Bernie Elbourn <berni421@gmail.com> - 2018-11-20 13:10 +0100

csiph-web