Package: mariadb-server-10.5 Version: 1:10.5.10-2 Severity: normal Tags: upstream X-Debbugs-Cc: noonedeadp...@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
