Bug#968222: mariadb-server-core-10.3: daemon won't restart after update to latest unstable
Russell Coker
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
Faustin Lammler
Hi Russel!
This may be related to:
- https://jira.mariadb.org/browse/MDEV-23050
- https://jira.mariadb.org/browse/MDEV-23321
Faustin
Otto Kekäläinen
Hello Russel!
Can you reproduce this in a clean installation? Can you provide exact
steps how to reproduce this?
What does `find /etc/mysql -ls` yield?
What it the contents of debian-sys-maint ? Is it for example empty?
What does `mysql -e "SELECT Host,User,plugin,authentication_string
FROM user;" mysql` yield?
I suspect that since debian-sys-maint is broken (and it should not
even be needed, since root has unix_socket auth access anyway) the
mysqladmin command fails to run and thus restarting server fails as
mysqladmin did not gracefully shutdown existing mysqld processes.