[debian-mysql] Bug#989400: mariadb-server-10.5: MariaDB fail to execute CONVERT TO CHARACTER

[Dmitriy Rabotyagov]

Package: mariadb-server-10.5
Version: 1:10.5.10-2
Severity: normal
Tags: upstream
X-Debbugs-Cc: noonedeadpunk at ya.ru

Dear Maintainer,

MariaDB 10.5.10 package has introduced a "floating" bug, when server may fail to execute like
`ALTER TABLE tablename CONVERT TO CHARACTER SET utf8`

This results in failing migrations, for example, of the OpenStack Cinder:
https://bf8b3683a4d2b36abe64-1877198ef7d2100f38eb37f99c1c7298.ssl.cf1.rackcdn.com/783606/20/check/openstack-ansible-deploy-aio_lxc-debian-bullseye/aa42a18/logs/ara-report/results/2512.html

More logs can be found: https://zuul.opendev.org/t/openstack/build/aa42a18e3f9b417e91ee6470afb5ecbb/logs

Downgrading mariadb-server for buster and ubuntu distributions to 10.5.9 allowed us not to face this issue,
while it have another issue with loosing root permissions after upgrade (but it could be easily worked around with
`UPDATE mysql.global_priv SET Priv = '549755813887' where User = 'root' and Host = 'localhost'`)

Related bug report has been submitted to mariadb maintainers: https://jira.mariadb.org/browse/MDEV-25673

What makes things worse, that mariadb does not provide bullseye packages yet, so there's no option to pick up from
buggy version you're ok with.

Would be great to have some options in upstream repo to pick from, then apt pinning might be used by users to pick up
from appropriate version until 10.5.11 will be relased, that hopefully fixes both issues and won't bring anything too
breaking again.


-- System Information:
Debian Release: 11.0
  APT prefers testing
  APT policy: (500, 'testing')
Architecture: amd64 (x86_64)

Kernel: Linux 5.10.0-6-amd64 (SMP w/4 CPU threads)
Locale: LANG=C.UTF-8, LC_CTYPE=C.UTF-8 (charmap=UTF-8) (ignored: LC_ALL set to C.UTF-8), LANGUAGE not set
Shell: /bin/sh linked to /usr/bin/dash
Init: systemd (via /run/systemd/system)

Versions of packages mariadb-server-10.5 depends on:
ii  adduser                   3.118
ii  debconf [debconf-2.0]     1.5.75
ii  galera-4                  26.4.7-3
ii  gawk                      1:5.1.0-1
ii  iproute2                  5.10.0-4
ii  libc6                     2.31-12
ii  libdbi-perl               1.643-3+b1
ii  libpam0g                  1.4.0-7
ii  libssl1.1                 1.1.1k-1
ii  libstdc++6                10.2.1-6
ii  lsb-base                  11.1.0
ii  lsof                      4.93.2+dfsg-1.1
ii  mariadb-client-10.5       1:10.5.10-2
ii  mariadb-common            1:10.5.10-2
ii  mariadb-server-core-10.5  1:10.5.10-2
ii  passwd                    1:4.8.1-1
ii  perl                      5.32.1-4
ii  procps                    2:3.3.17-5
ii  psmisc                    23.4-2
ii  rsync                     3.2.3-4
ii  socat                     1.7.4.1-3
ii  zlib1g                    1:1.2.11.dfsg-2

Versions of packages mariadb-server-10.5 recommends:
pn  libhtml-template-perl  <none>

Versions of packages mariadb-server-10.5 suggests:
pn  mailx           <none>
pn  mariadb-test    <none>
pn  netcat-openbsd  <none>

-- debconf information:
  mariadb-server-10.5/nis_warning:
* mysql-server/root_password: 9816a835ad4129d0460500ff66aa4ff
  mariadb-server-10.5/old_data_directory_saved:
  mariadb-server-10.5/postrm_remove_databases: false
* mysql-server/root_password_again: 9816a835ad4129d0460500ff66aa4ff