Your message dated Mon, 26 Jul 2021 00:33:56 +0000
with message-id <[email protected]>
and subject line Bug#989400: fixed in mariadb-10.5 1:10.5.11-1
has caused the Debian Bug report #989400,
regarding mariadb-server-10.5: MariaDB fail to execute CONVERT TO CHARACTER
to be marked as done.
This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.
(NB: If you are a system administrator and have no idea what this
message is talking about, this may indicate a serious mail system
misconfiguration somewhere. Please contact [email protected]
immediately.)
--
989400: https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=989400
Debian Bug Tracking System
Contact [email protected] with problems
--- Begin Message ---
Package: mariadb-server-10.5
Version: 1:10.5.10-2
Severity: normal
Tags: upstream
X-Debbugs-Cc: [email protected]
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
--- End Message ---
--- Begin Message ---
Source: mariadb-10.5
Source-Version: 1:10.5.11-1
Done: Otto Kekäläinen <[email protected]>
We believe that the bug you reported is fixed in the latest version of
mariadb-10.5, which is due to be installed in the Debian FTP archive.
A summary of the changes between this version and the previous one is
attached.
Thank you for reporting the bug, which will now be closed. If you
have further comments please address them to [email protected],
and the maintainer will reopen the bug report if appropriate.
Debian distribution maintenance software
pp.
Otto Kekäläinen <[email protected]> (supplier of updated mariadb-10.5 package)
(This message was generated automatically at their request; if you
believe that there is a problem with it please contact the archive
administrators by mailing [email protected])
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA512
Format: 1.8
Date: Sun, 25 Jul 2021 15:38:34 -0700
Source: mariadb-10.5
Binary: libmariadb-dev libmariadb-dev-compat libmariadb3 libmariadbd19
libmariadbd-dev mariadb-common mariadb-client-core-10.5 mariadb-client-10.5
mariadb-server-core-10.5 mariadb-server-10.5 mariadb-server mariadb-client
mariadb-backup mariadb-plugin-connect mariadb-plugin-s3 mariadb-plugin-rocksdb
mariadb-plugin-oqgraph mariadb-plugin-mroonga mariadb-plugin-spider
mariadb-plugin-gssapi-server mariadb-plugin-gssapi-client
mariadb-plugin-cracklib-password-check mariadb-test mariadb-test-data
Architecture: source
Version: 1:10.5.11-1
Distribution: unstable
Urgency: medium
Maintainer: Debian MySQL Maintainers <[email protected]>
Changed-By: Otto Kekäläinen <[email protected]>
Description:
libmariadb-dev - MariaDB database development files
libmariadb-dev-compat - MariaDB Connector/C, compatibility symlinks
libmariadb3 - MariaDB database client library
libmariadbd-dev - MariaDB embedded database, development files
libmariadbd19 - MariaDB embedded database, shared library
mariadb-backup - Backup tool for MariaDB server
mariadb-client - MariaDB database client (metapackage depending on the latest
vers
mariadb-client-10.5 - MariaDB database client binaries
mariadb-client-core-10.5 - MariaDB database core client binaries
mariadb-common - MariaDB common configuration files
mariadb-plugin-connect - Connect storage engine for MariaDB
mariadb-plugin-cracklib-password-check - CrackLib Password Validation Plugin
for MariaDB
mariadb-plugin-gssapi-client - GSSAPI authentication plugin for MariaDB client
mariadb-plugin-gssapi-server - GSSAPI authentication plugin for MariaDB server
mariadb-plugin-mroonga - Mroonga storage engine for MariaDB
mariadb-plugin-oqgraph - OQGraph storage engine for MariaDB
mariadb-plugin-rocksdb - RocksDB storage engine for MariaDB
mariadb-plugin-s3 - Amazon S3 archival storage engine for MariaDB
mariadb-plugin-spider - Spider storage engine for MariaDB
mariadb-server - MariaDB database server (metapackage depending on the latest
vers
mariadb-server-10.5 - MariaDB database server binaries
mariadb-server-core-10.5 - MariaDB database core server files
mariadb-test - MariaDB database regression test suite
mariadb-test-data - MariaDB database regression test suite - data files
Closes: 972564 976147 976985 977137 989400 990708 991399
Changes:
mariadb-10.5 (1:10.5.11-1) unstable; urgency=medium
.
* New upstream version 10.5.11. Includes several important bug fixes,
including a replication hang (Closes: #991399, Closes: #989400)
* Cleanup, documentation and testing:
* Drop backported patch for armfh build now in 10.5.11 from upstream.
* Drop patch no longer needed with latest gcc-10 (Closes: #972564)
* Save autopkgtests results as JUnit-compatible XML-report
* Salsa-CI: Verify wrap-and-sort usage and correctness of patches/series
* Remove rocksdb_build_git_date from RocksDB binaries to make them
build in a reproducible way, thus making the entire MariaDB finally
reproducible (Closes: #976985)
.
[ Andreas Beckmann ]
* Ease switching from galera-3 to galera-4 on upgrades from buster
(Closes: #990708, Closes: #976147, Closes: #977137)
Checksums-Sha1:
9d0ad2c56238ce6b82662aab29a76b820d8252e0 4779 mariadb-10.5_10.5.11-1.dsc
f62668be013b1ab51ab7e001d026e17257ad8d30 99037098
mariadb-10.5_10.5.11.orig.tar.gz
2d7bf5e72f799fce82ba77544a67ef5f2aaf8dfa 195
mariadb-10.5_10.5.11.orig.tar.gz.asc
bb6eade9d361a3174d7a0ba052129956b741cd7d 222816
mariadb-10.5_10.5.11-1.debian.tar.xz
e87cea5832146a996e60b3ff2b2890c75e45f3b6 9413
mariadb-10.5_10.5.11-1_source.buildinfo
Checksums-Sha256:
7500de9a591ac6e86608ebe914f24c955ec871689d65c9f45d5dc6051c9f97c3 4779
mariadb-10.5_10.5.11-1.dsc
761053605fe30ce393f324852117990350840a93b3e6305ef4d2f8c8305cc47a 99037098
mariadb-10.5_10.5.11.orig.tar.gz
721280e17bb67741af4b44580258edcd8b723c07a7ce8b08f954bfdb5dfc087c 195
mariadb-10.5_10.5.11.orig.tar.gz.asc
ccc4d7520fd856515ecf3631245b46a02bbec2c929298712d74c211a8fe3276f 222816
mariadb-10.5_10.5.11-1.debian.tar.xz
d16e576d47f6d743d023e515ce461162e2ec4de2a48c3efd2b70505146884166 9413
mariadb-10.5_10.5.11-1_source.buildinfo
Files:
bbfba0f5424f1b5ff05f9fb9a7f2afc5 4779 database optional
mariadb-10.5_10.5.11-1.dsc
28d7eef4f997362485da85c982346954 99037098 database optional
mariadb-10.5_10.5.11.orig.tar.gz
5ec646beef265b7626de3bca855afc78 195 database optional
mariadb-10.5_10.5.11.orig.tar.gz.asc
b552985368314c3457f2622390141738 222816 database optional
mariadb-10.5_10.5.11-1.debian.tar.xz
8a0b6fdea418deecf1bd2c5a9ddf7051 9413 database optional
mariadb-10.5_10.5.11-1_source.buildinfo
-----BEGIN PGP SIGNATURE-----
iQIzBAEBCgAdFiEEmbRSsR88dMO0U+RvvthEn87o2ogFAmD97NAACgkQvthEn87o
2ojHbw/+KDf+5TOWwjXd6ZHxXEC9pet2K/DtvmLw6fcv5IibI5bP+O0mZ/jIkt/A
LlvbtqFdP5peqUImM+17GbV0fZmR4y0XnfBid56F2XOXicfQO7cpAq1jw9Y8//Vk
bOO/FT56LE1fYHmab6KlCuFS6vKIPvDKeYkIYWqoM84mssu6h9pDn/nRi5SC/Fri
3g/8gaPQif5m/h/LueNzcGQM+hDcvWR0OsshkOCJ3wfDQUswSiunvrLm9v7qho2e
oGVzU+0lYCizGteEWswcfolhnFgUXQYpYHP+kTym9FJARlWsH+vmmEWvTFWa5Z7S
BEMvzX3N4p4zeKQ/vuJH8tfCj6E/P4o5a7yr7YvNecVGTXcuRwHvo88b+fgE9qmJ
3BuIuGgs3/6bYpp/U8XpTyKLO0Iq+U5eF05VdYeO5BOzF37xDirY8F6nnNGW+6G6
RmuOwE9NqVCDaszsItQLhOfpwP1pNnMZyppB6DocXgNC3pRXImwA65OsxSy3cYsW
pARA/VBJQB90zubOgFZkNBmVJfZtS2UaJefT6RlBwI5931Pwx+Y2ldvwbsZGK4v2
fK+eBsW54MCYS0V+4Mvm6KvLewyfrpZz3KmENoWIaG2x5JoRpT75quXxMjuDoZX4
2rMTSpM93uriKLIsoSTiYX9Au8LpD5bnAullYBvV2hXKWx+UeaM=
=KNmn
-----END PGP SIGNATURE-----
--- End Message ---
