[debian-mysql] Bug#968222: mariadb-server-core-10.3: daemon won't restart after update to latest unstable

[Russell Coker]

Package: mariadb-server-core-10.3
Version: 1:10.3.23-1
Severity: normal

After updating to the latest unstable packages I have an old mysql process left over.  For some
reason debian-sys-maint doesn't work but I have made no changes to that.

# systemctl status mysql.service
● mysql.service - LSB: Start and stop the mysql database server daemon
     Loaded: loaded (/etc/init.d/mysql; generated)
     Active: active (running) since Tue 2020-08-11 14:39:08 AEST; 1min 6s ago
       Docs: man:systemd-sysv-generator(8)
    Process: 43468 ExecStart=/etc/init.d/mysql start (code=exited, status=0/SUCCESS)
      Tasks: 33 (limit: 19144)
     Memory: 154.0M
     CGroup: /system.slice/mysql.service
             ├─1211 /bin/sh /usr/bin/mysqld_safe
             ├─1433 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib/x86_64-linux-gnu/mariadb19/plugin --user=mysql --skip-log-error --pid-file=/run/mysqld/mysqld.pid --socket=/var/run/mysqld/mysqld.sock
             └─1434 logger -t mysqld -p daemon error

Aug 11 14:39:08 xev systemd[1]: mysql.service: Found left-over process 1211 (mysqld_safe) in control group while starting unit. Ignoring.
Aug 11 14:39:08 xev systemd[1]: This usually indicates unclean termination of a previous run, or service implementation deficiencies.
Aug 11 14:39:08 xev systemd[1]: mysql.service: Found left-over process 1433 (mysqld) in control group while starting unit. Ignoring.
Aug 11 14:39:08 xev systemd[1]: This usually indicates unclean termination of a previous run, or service implementation deficiencies.
Aug 11 14:39:08 xev systemd[1]: mysql.service: Found left-over process 1434 (logger) in control group while starting unit. Ignoring.
Aug 11 14:39:08 xev systemd[1]: This usually indicates unclean termination of a previous run, or service implementation deficiencies.
Aug 11 14:39:08 xev systemd[1]: Starting LSB: Start and stop the mysql database server daemon...
Aug 11 14:39:08 xev mysqld[1434]: 2020-08-11 14:39:08 20 [Warning] Access denied for user 'debian-sys-maint'@'localhost'
Aug 11 14:39:08 xev mysql[43468]: Starting MariaDB database server: mysqld already running.
Aug 11 14:39:08 xev systemd[1]: Started LSB: Start and stop the mysql database server daemon.

-- System Information:
Debian Release: bullseye/sid
  APT prefers testing
  APT policy: (800, 'testing'), (700, 'unstable'), (1, 'experimental')
Architecture: amd64 (x86_64)
Foreign Architectures: i386

Kernel: Linux 5.7.0-2-amd64 (SMP w/4 CPU threads)
Locale: LANG=en_AU.UTF-8, LC_CTYPE=en_AU.UTF-8 (charmap=UTF-8), LANGUAGE=en_AU:en
Shell: /bin/sh linked to /bin/dash
Init: systemd (via /run/systemd/system)
LSM: SELinux: enabled - Mode: Permissive - Policy name: default

Versions of packages mariadb-server-core-10.3 depends on:
ii  libaio1         0.3.112-8
ii  libc6           2.31-2
ii  libcrypt1       1:4.4.16-1
ii  liblz4-1        1.9.2-2
ii  libpcre3        2:8.39-13
ii  libsnappy1v5    1.1.8-1
ii  libstdc++6      10.1.0-6
ii  libsystemd0     246-2
ii  mariadb-common  1:10.3.23-1
ii  zlib1g          1:1.2.11.dfsg-2

mariadb-server-core-10.3 recommends no packages.

mariadb-server-core-10.3 suggests no packages.

-- debconf-show failed