[debian-mysql] Bug#1040784: mariadb-server: Upgrade from Debian Bullseye to Debian Bookworm may crash if innodb_log_file_buffering=OFF and physical block size is 4096 bytes

[Leonardo Martinho]

Package: mariadb-server
Version: 1:10.11.3-1
Severity: important

Dear Maintainer,

* Upgrading from Debian 11 to Debian 12 renders mariadb-server to be
unusable
* I opened a bug report on the Mariadb Jira in order to analyse and fix
the issue. In this case it seems to have to do something with the
physical block size of the hard drive the innodb is on
* The bug was fixed in a recent commit (https://github.com/MariaDB/server/commit/c358e216d989a57f4188e766799fc83a4675c5d1)
* As this is a rather major issue which prevents upgrades and crashes
mariadb hard on such device configurations, this should be included
promptly in the next version of the package

-- System Information:
Debian Release: 12.0
  APT prefers stable-security
  APT policy: (500, 'stable-security'), (500, 'stable-debug'), (500, 'stable')
Architecture: s390x

Kernel: Linux 5.10.0-23-s390x (SMP w/1 CPU thread)
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8), LANGUAGE=en_US:en
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  adduser                3.134
ii  debconf [debconf-2.0]  1.5.82
ii  galera-4               26.4.13-1
ii  gawk                   1:5.2.1-2
ii  iproute2               6.1.0-3
ii  libc6                  2.36-9
ii  libdbi-perl            1.643-4
ii  libpam0g               1.5.2-6
ii  libssl3                3.0.9-1
ii  libstdc++6             12.2.0-14
ii  lsof                   4.95.0-1
ii  mariadb-client         1:10.11.3-1
ii  mariadb-common         1:10.11.3-1
ii  mariadb-server-core    1:10.11.3-1
ii  passwd                 1:4.13+dfsg1-1+b1
ii  perl                   5.36.0-7
ii  procps                 2:4.0.2-3
ii  psmisc                 23.6-1
ii  rsync                  3.2.7-1
ii  socat                  1.7.4.4-2
ii  zlib1g                 1:1.2.13.dfsg-1

Versions of packages mariadb-server recommends:
pn  libhtml-template-perl           <none>
pn  mariadb-plugin-provider-bzip2   <none>
pn  mariadb-plugin-provider-lz4     <none>
pn  mariadb-plugin-provider-lzma    <none>
pn  mariadb-plugin-provider-lzo     <none>
pn  mariadb-plugin-provider-snappy  <none>
pn  pv                              <none>

Versions of packages mariadb-server suggests:
ii  bsd-mailx [mailx]  8.1.2-0.20220412cvs-1
pn  mariadb-test       <none>
ii  netcat-openbsd     1.219-1

-- Configuration Files:
/etc/logcheck/ignore.d.paranoid/mariadb-server [Errno 13] Permission denied: '/etc/logcheck/ignore.d.paranoid/mariadb-server'
/etc/logcheck/ignore.d.server/mariadb-server [Errno 13] Permission denied: '/etc/logcheck/ignore.d.server/mariadb-server'
/etc/logcheck/ignore.d.workstation/mariadb-server [Errno 13] Permission denied: '/etc/logcheck/ignore.d.workstation/mariadb-server'
/etc/mysql/mariadb.conf.d/50-server.cnf changed [not included]

-- debconf information excluded