[debian-mysql] Bug#1026353: mariadb-server: mariadb does not start after bullseye point release 11.6

[Matthew P Zagrabelny]

Package: mariadb-server
Version: 1:10.5.18-0+deb11u1
Severity: important

Dear Maintainer,

Unattended upgrade upgraded mariadb this morning and now the service does not
start:

Start-Date: 2022-12-18  06:15:03
Commandline: /usr/bin/unattended-upgrade
Upgrade: mariadb-server:amd64 (1:10.5.15-0+deb11u1, 1:10.5.18-0+deb11u1), mariadb-server-10.5:amd64 (1:10.5.15-0+deb11u1, 1:10.5.18-0+deb11u1)
End-Date: 2022-12-18  06:15:09

# systemctl status mariadb.service
● mariadb.service - MariaDB 10.5.18 database server
     Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
     Active: failed (Result: exit-code) since Sun 2022-12-18 15:25:38 CST; 38min ago
       Docs: man:mariadbd(8)
             https://mariadb.com/kb/en/library/systemd/
    Process: 481 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
    Process: 498 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
    Process: 507 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= ||   VAR=`cd /usr/bin/..; /usr/bin/galera_recovery`; [ $? -eq 0 ]   && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited, status=0/SUCCESS)
    Process: 604 ExecStart=/usr/sbin/mariadbd $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE)
   Main PID: 604 (code=exited, status=1/FAILURE)
     Status: "MariaDB server is down"
        CPU: 190ms

Dec 18 15:25:36 mariadb-test-system systemd[1]: Starting MariaDB 10.5.18 database server...
Dec 18 15:25:37 mariadb-test-system mariadbd[604]: 2022-12-18 15:25:37 0 [Note] /usr/sbin/mariadbd (mysqld 10.5.18-MariaDB-0+deb11u1) starting as process 604 ...
Dec 18 15:25:38 mariadb-test-system systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Dec 18 15:25:38 mariadb-test-system systemd[1]: mariadb.service: Failed with result 'exit-code'.
Dec 18 15:25:38 mariadb-test-system systemd[1]: Failed to start MariaDB 10.5.18 database server.

I've run:

# strace -f /usr/sbin/mariadbd

but there isn't anything that sticks out to me.

# journalctl -xe

Dec 18 16:09:48 mariadb-test-system systemd[1]: Starting MariaDB 10.5.18 database server...
░░ Subject: A start job for unit mariadb.service has begun execution
░░ Defined-By: systemd
░░ Support: https://www.debian.org/support
░░
░░ A start job for unit mariadb.service has begun execution.
░░
░░ The job identifier is 789.
Dec 18 16:09:49 mariadb-test-system mariadbd[8369]: 2022-12-18 16:09:49 0 [Note] /usr/sbin/mariadbd (mysqld 10.5.18-MariaDB-0+deb11u1) starting as process 8369 ...
Dec 18 16:09:49 mariadb-test-system systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
░░ Subject: Unit process exited
░░ Defined-By: systemd
░░ Support: https://www.debian.org/support
░░
░░ An ExecStart= process belonging to unit mariadb.service has exited.
░░
░░ The process' exit code is 'exited' and its exit status is 1.
Dec 18 16:09:49 mariadb-test-system systemd[1]: mariadb.service: Failed with result 'exit-code'.
░░ Subject: Unit failed
░░ Defined-By: systemd
░░ Support: https://www.debian.org/support
░░
░░ The unit mariadb.service has entered the 'failed' state with result 'exit-code'.
Dec 18 16:09:49 mariadb-test-system systemd[1]: Failed to start MariaDB 10.5.18 database server.
░░ Subject: A start job for unit mariadb.service has failed
░░ Defined-By: systemd
░░ Support: https://www.debian.org/support
░░
░░ A start job for unit mariadb.service has finished with a failure.
░░
░░ The job identifier is 789 and the job result is failed.


-- System Information:
Debian Release: 11.6
  APT prefers stable-updates
  APT policy: (500, 'stable-updates'), (500, 'stable-security'), (500, 'stable')
Architecture: amd64 (x86_64)

Kernel: Linux 5.10.0-20-amd64 (SMP w/1 CPU thread)
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8), LANGUAGE not set
Shell: /bin/sh linked to /usr/bin/dash
Init: systemd (via /run/systemd/system)
LSM: AppArmor: enabled

Versions of packages mariadb-server depends on:
ii  mariadb-server-10.5  1:10.5.18-0+deb11u1

mariadb-server recommends no packages.

mariadb-server suggests no packages.

-- no debconf information