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


Groups > linux.debian.user > #202638

mysqld working fine but systemctl reports failed.

Path csiph.com!feeder.erje.net!2.eu.feeder.erje.net!news2.arglkargh.de!news.mixmin.net!aioe.org!bofh.it!news.nic.it!robomod
From Bernie Elbourn <berni421@gmail.com>
Newsgroups linux.debian.user
Subject mysqld working fine but systemctl reports failed.
Date Tue, 20 Nov 2018 13:10:01 +0100
Message-ID <wWd0R-eK-3@gated-at.bofh.it> (permalink)
X-Original-To debian-user@lists.debian.org
X-Mailbox-Line From debian-user-request@lists.debian.org Tue Nov 20 12:02:28 2018
Old-Return-Path <berni421@gmail.com>
X-Amavis-Spam-Status No, score=-3.348 tagged_above=-10000 required=5.3 tests=[BAYES_00=-2, BODY_8BITS=1.5, DKIM_ADSP_CUSTOM_MED=0.001, FORGED_GMAIL_RCVD=1, FREEMAIL_ENVFROM_END_DIGIT=0.25, FREEMAIL_FROM=0.001, LDO_WHITELIST=-5, NML_ADSP_CUSTOM_MED=0.9, RCVD_IN_DNSWL_NONE=-0.0001] autolearn=no autolearn_force=no
X-Policyd-Weight DYN_NJABL=SKIP(0) NOT_IN_SBL_XBL_SPAMHAUS=-1.5 BL_NJABL=SKIP(-1.5) CL_IP_EQ_HELO_IP=-2 (check from: .gmail. - helo: .mout.kundenserver. - helo-domain: .kundenserver.) FROM/MX_MATCHES_NOT_HELO(DOMAIN)=0; rate: -5
User-Agent Mozilla/5.0 (X11; Linux x86_64; rv:60.0) Gecko/20100101 Thunderbird/60.3.0
MIME-Version 1.0
Content-Type text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding 8bit
Content-Language en-GB
X-Provags-ID V03:K1:+N0tA+aCSNibuxXyBAtM+3AJqjm5/rRWmkGG+X9SDmXbBJBb6Yk TBTR4UIDJTxjTa6AZY6J7c4w/XxbC2chjQM9ZeMgngI++e75f/wo7bnNogqAkaOYl0koqBh LfpYLuBI75qfy2ItXh2svPZAXbu/Wf3SIJahSykDTkU788vm7HS1h2OxhPKH2t3C9NL7gar HgKFxVNhf0xlsKqb7/u0g==
X-Ui-Out-Filterresults notjunk:1;V01:K0:DOj97dLh0WA=:Y8gf9vkektcrOITUtsVxFk G7CSW8/H88AjkCtk74Mc8BMc9JGB4iweWm9BFyvKkdyltIB/yEqv5SYrrBf/zeVWpihVkqiKD j8+msg0CpUDtkeMb1I/Z+9CPQqzaghdEl++D1QBDWKi4vZA7HAu8X4vJRXvR6VkJKIiyjFOyZ VnUYMXS1m9tsfQEztlW4Xj2wKixhLs56IT089u6p8mC6/vIYMgXWn17CZmEcd6KDs6d7TwCJq oariitK00PNf3MvaMD5fM0g6FALzP+zd45be/X/SfJ7tfgejVZgwnimwux0UIZIFIraYYZr54 0MfaAdScuPLE1pwcWziKGDOAZwK2g2SzVgLcJxhetXFYtz98KNC9dN+NYdP68yYC/m4fAaoKt uUKMJxW5Gh0sqamCgm+jyNIH3ihLv57QiWXN/DoNfL43D8FXC7jk6SqhDKcN2jAbdJRmfJTY5 O2iF6BKC3KbIrdQwNnIj7H7OTLJrioyd8ia8bkaRNhby6QJUO4ZaO9AMrgRMkdcWAAkYkJnd7 6xkK3h8vN5pF0jzCJwbN/V+/rVoB0RAd1zoGhTI2T+4y0q261XEKINs+b2Pl7tvjTIveoh6wC GrqG8f4XPUe8faNcNcAV+p4UzTbXZquF/jnJzCm6Adcu5F7K1w54hOYrcWluQzc5uH4OML+aN VssaXl3pmwMTSI1fKNyXChdNzlHhTDzvgiuUZtDIbWakH5/VoLIgPdDc8/DeY6klkRgA4Llud eGrmva2TZC7DnX2qtx+gMBWpMr5YbSLXiBQMHUQ5EaR2SpQVCC5rSnkOTfIXKGZ7AL2p2FSdf Leq+vrX+9c9p0pywzkH26WcOiW3CQ==
X-Mailing-List <debian-user@lists.debian.org> archive/latest/742602
List-ID <debian-user.lists.debian.org>
List-URL <https://lists.debian.org/debian-user/>
List-Archive https://lists.debian.org/msgid-search/a6483a39-39b9-1195-bf22-492255cd1707@gmail.com
Approved robomod@news.nic.it
Lines 38
Organization linux.* mail to news gateway
Sender robomod@news.nic.it
X-Original-Date Tue, 20 Nov 2018 12:02:08 +0000
X-Original-Message-ID <a6483a39-39b9-1195-bf22-492255cd1707@gmail.com>
Xref csiph.com linux.debian.user:202638

Show key headers only | 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