Bug#921687: systemctl just hangs on stoping or starting mysql-server-5.7

[Eduard Bloch]

Package: systemd
Version: 240-5
Severity: important

Hi,

(NOTE: I am not a systemd hater so please don't threat me like s...)

So, out of blue my system cannot shutdown or reboot anymore. Hangs on something with mysql.

So I tried to remove it since I don't need it here. Result: it fails to
remove it, and just hangs there. I tried to update systemd, it's still
ends in a frozen dpkg, doing deadlocking package configurations.

>From user POV this is a disaster!

root      3099  5.2  0.6 124964 113668 pts/2   S+   00:28   0:01                  |       \_ apt-get install systemd
root      3131  0.2  0.1  30504 25268 pts/3    Ss+  00:28   0:00                  |           \_ /usr/bin/dpkg --status-fd 63 --configure --pending
root      3132  0.8  0.2  42360 38952 pts/3    S+   00:28   0:00                  |               \_ /usr/bin/perl -w /usr/share/debconf/frontend /var/lib/dpkg/info/mysql-server-5.7.
root      3141  0.0  0.0   6712  2812 pts/3    S+   00:28   0:00                  |                   \_ /bin/bash /var/lib/dpkg/info/mysql-server-5.7.postinst configure 5.7.25-1
root      3142  0.0  0.0   6844  3512 pts/3    S+   00:28   0:00                  |                       \_ /bin/sh /usr/sbin/invoke-rc.d mysql stop
root      3175  0.0  0.0   8300  3524 pts/3    S+   00:28   0:00                  |                           \_ systemctl stop mysql.service

Checking status:

systemctl status mysql
● mysql.service - MySQL Community Server
   Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled)
   Active: deactivating (stop-sigterm) since Fri 2019-02-08 00:23:33 CET; 9min ago
 Main PID: 1493 (mysqld)
    Tasks: 14 (limit: 4915)
   Memory: 214.4M
   CGroup: /system.slice/mysql.service
           └─1493 /usr/sbin/mysqld --daemonize --pid-file=/run/mysqld/mysqld.pid

Feb 08 20:03:21 zombie systemd[1]: Starting MySQL Community Server...
Feb 08 20:03:22 zombie systemd[1]: Started MySQL Community Server.
Feb 08 00:23:33 zombie systemd[1]: Stopping MySQL Community Server...

And what now? Makes no sense.

Greetings,
Eduard.

-- Package-specific info:

-- System Information:
Debian Release: buster/sid
  APT prefers unstable-debug
  APT policy: (500, 'unstable-debug'), (500, 'unstable'), (1, 'experimental-debug'), (1, 'experimental')
Architecture: amd64 (x86_64)
Foreign Architectures: i386

Kernel: Linux 4.20.0-trunk-amd64 (SMP w/12 CPU cores)
Locale: LANG=de_DE.UTF-8, LC_CTYPE=de_DE.UTF-8 (charmap=UTF-8), LANGUAGE=de_DE.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/bash
Init: systemd (via /run/systemd/system)
LSM: AppArmor: enabled

Versions of packages systemd depends on:
ii  adduser          3.118
ii  libacl1          2.2.52-3+b1
ii  libapparmor1     2.13.2-7
ii  libaudit1        1:2.8.4-2
ii  libblkid1        2.33.1-0.1
ii  libc6            2.28-5
ii  libcap2          1:2.25-1.2
ii  libcryptsetup12  2:2.0.6-1
ii  libgcrypt20      1.8.4-5
ii  libgnutls30      3.6.6-2
ii  libgpg-error0    1.35-1
ii  libidn11         1.33-2.2
ii  libip4tc0        1.8.2-3
ii  libkmod2         25-2
ii  liblz4-1         1.8.3-1
ii  liblzma5         5.2.4-1
ii  libmount1        2.33.1-0.1
ii  libpam0g         1.1.8-4
ii  libseccomp2      2.3.3-3
ii  libselinux1      2.8-1+b1
ii  libsystemd0      240-5
ii  mount            2.33.1-0.1
ii  util-linux       2.33.1-0.1

Versions of packages systemd recommends:
ii  dbus            1.12.12-1
ii  libpam-systemd  240-5

Versions of packages systemd suggests:
ii  policykit-1        0.105-25
pn  systemd-container  <none>

Versions of packages systemd is related to:
pn  dracut           <none>
ii  initramfs-tools  0.132
ii  udev             240-5

-- Configuration Files:
/etc/systemd/journald.conf changed:
[Journal]
SystemMaxUse=1G


-- no debconf information