Your message dated Sat, 04 Jul 2026 10:03:26 +0000
with message-id <[email protected]>
and subject line Bug#1126850: fixed in mariadb 1:10.11.18-0+deb12u1
has caused the Debian Bug report #1126850,
regarding mariadb-server: "mysqldump --system=users" fails with error "Illegal
mix of collations"
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.)
--
1126850: https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=1126850
Debian Bug Tracking System
Contact [email protected] with problems
--- Begin Message ---
Package: mariadb-server
Version: 1:11.8.3-0+deb13u1
Severity: important
X-Debbugs-Cc: [email protected]
Dear Maintainer,
using "mysqldump --system=users" for backing up MariaDB users fails with the
following error:
mysqldump: Couldn't execute 'SELECT CONCAT(QUOTE(u.user), '@', QUOTE(u.Host))
AS u FROM mysql.user u /*!80001 LEFT JOIN mysql.role_edges e ON
u.user=e.from_user AND u.host=e.from_host WHERE
e.from_user IS NULL */ /*M!100005 WHERE is_role='N' */': Illegal mix of
collations (utf8mb4_general_ci,COERCIBLE) and (utf8mb4_uca1400_ai_ci,COERCIBLE)
for operation '=' (1267)
I experience this error on a fresh install and also on a system upgraded from
bookworm.
On Debian Bookworm this command successfully provides a SQL dump for backup.
Best,
Sven
-- System Information:
Debian Release: 13.3
APT prefers stable-updates
APT policy: (500, 'stable-updates'), (500, 'stable-security'), (500, 'stable')
Architecture: amd64 (x86_64)
Kernel: Linux 6.18.5+deb14-amd64 (SMP w/2 CPU threads; PREEMPT)
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)
Versions of packages mariadb-server depends on:
ii adduser 3.152
ii debconf [debconf-2.0] 1.5.91
ii galera-4 26.4.23-0+deb13u1
ii gawk 1:5.2.1-2+b1
ii init-system-helpers 1.69~deb13u1
ii iproute2 6.15.0-1
ii libc6 2.41-12+deb13u1
ii libdbi-perl 1.647-1
ii libgcc-s1 14.2.0-19
ii libpam0g 1.7.0-5
ii libssl3t64 3.5.4-1~deb13u2
ii libstdc++6 14.2.0-19
ii lsof 4.99.4+dfsg-2
ii mariadb-client 1:11.8.3-0+deb13u1
ii mariadb-common 1:11.8.3-0+deb13u1
ii mariadb-server-core 1:11.8.3-0+deb13u1
ii passwd 1:4.17.4-2
ii perl 5.40.1-6
ii procps 2:4.0.4-9
ii psmisc 23.7-2
ii rsync 3.4.1+ds1-5+deb13u1
ii socat 1.8.0.3-1
ii zlib1g 1:1.3.dfsg+really1.3.1-1+b1
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.1
pn mariadb-test <none>
ii netcat-openbsd 1.229-1
-- debconf information:
mariadb-server/nis_warning:
mariadb-server/old_data_directory_saved:
mariadb-server/postrm_remove_databases: false
--- End Message ---
--- Begin Message ---
Source: mariadb
Source-Version: 1:10.11.18-0+deb12u1
Done: Otto Kekäläinen <[email protected]>
We believe that the bug you reported is fixed in the latest version of
mariadb, 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 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: Sat, 27 Jun 2026 11:11:11 +0000
Source: mariadb
Built-For-Profiles: derivative.ubuntu noudeb
Architecture: source
Version: 1:10.11.18-0+deb12u1
Distribution: bookworm
Urgency: medium
Maintainer: Debian MySQL Maintainers <[email protected]>
Changed-By: Otto Kekäläinen <[email protected]>
Closes: 1104533 1110683 1126850 1127431 1137221
Changes:
mariadb (1:10.11.18-0+deb12u1) bookworm; urgency=medium
.
[ Otto Kekäläinen ]
* New upstream maintenance 10.11.18 includes several fixes as listed at
https://mariadb.com/docs/release-notes/community-server/10.11/10.11.18
and fixes for the following CVE tracked security issues:
- CVE-2026-49261
- CVE-2026-48165
- CVE-2026-48163
* Previous upstream maintenance 10.11.17 included several fixes as listed at
https://mariadb.com/docs/release-notes/community-server/10.11/10.11.17
and fixes for the following CVE tracked security issues:
- CVE-2026-44173
- CVE-2026-44172
- CVE-2026-44171
- CVE-2026-44170
- CVE-2026-44168
* Previous upstream maintenance 10.11.16 included several fixes as listed at
https://mariadb.com/docs/release-notes/community-server/10.11/10.11.16
and fixes for the following CVE tracked security issues:
- CVE-2026-3494
- CVE-2026-34303
* Previous upstream maintenance 10.11.15 included several fixes as listed at
https://mariadb.com/docs/release-notes/community-server/10.11/10.11.15
and fixes for the following CVE tracked security issues:
- CVE-2026-21968
- CVE-2025-13699
* New upstream versions included fixes for these Debian tracked issues:
- MDEV-38698 Upgrade did not fix charset and collation for mysql.user,
leading to "Illegal mix of collations" errors on upgrades or when trying
to restore backups (Closes: #1104533, #1126850, #1137221)
- MDEV-39479 Mroonga hangs on invalid index flag (Closes: #1110683)
- MDEV-38811 Crash in information_schema.table_constraints when running in
'skip-grant-tables' mode (Closes: #1127431, affected e.g. Akonadi)
* Add debian/source/local-options to suppress WolfSSL and ColumnStore line
ending errors
* Include new upstream test file pam_mariadb_mtr.so
* Update configuration traces to match changes in system variables
- new variable 'innodb-buffer-pool-in-core-dump' (default: FALSE)
- new default value 0->8796093022208 in 'innodb-buffer-pool-size-max'
* Salsa CI: Use CI fixes from other branches to make pipeline fully green
* Make autopkgtest emit debug info on service start failures
.
[ Daniel Black ]
* MDEV-37411: Re-enable AIO in Debian to fix earlier incomplete fix that was
done after new upstream 11.8.3 release introduced innodb_linux_aio
* MDEV-15502: With recent changes in upstream systemd, the tmpfiles are now
required, otherwise starting MariaDB would fail on error:
"cannot create /run/mysqld/wsrep-start-position: Directory nonexistent"
* MDEV-34902: debian-start erroneously reports issues (includes security fix)
Checksums-Sha1:
f5093defa5851631a3efb0f7a5dcf5cc21cc609b 5373 mariadb_10.11.18-0+deb12u1.dsc
7c7c0ce535cc5b7e0d29387bb4cae6c79ec75d88 114604451 mariadb_10.11.18.orig.tar.gz
6fa6c9c2c3c3fa1ca7fa5a51d33bfcd1e6d6ca6d 833 mariadb_10.11.18.orig.tar.gz.asc
09d4ae6716bc0499166ee65ac4859241e5470a0e 270392
mariadb_10.11.18-0+deb12u1.debian.tar.xz
f15610800fbdc7b8ebf810e25452a8174a003e44 10765
mariadb_10.11.18-0+deb12u1_source.buildinfo
Checksums-Sha256:
bf86fbf8c9cf5d40329d63cbadfbc776e19d7caacef480befda181f10fbcd1f9 5373
mariadb_10.11.18-0+deb12u1.dsc
a46852c68075be7c31c7b33fee233c5b5a00c8c28117f5204d124e4f2fd56fa8 114604451
mariadb_10.11.18.orig.tar.gz
43b4f664182b4fb1930ad209bcf5689903fbfc66b64f65838947c357d71dae70 833
mariadb_10.11.18.orig.tar.gz.asc
b5e013be56bb9ff2d2bc3e18920686370e65fbfe38c040185f9044a09ed9ea76 270392
mariadb_10.11.18-0+deb12u1.debian.tar.xz
54366bc42f6e842840680220bb72117b61e8d9a552f5ea838e5c14a8cced8945 10765
mariadb_10.11.18-0+deb12u1_source.buildinfo
Files:
287243c9d68b8b11c000e67ef355bb1e 5373 database optional
mariadb_10.11.18-0+deb12u1.dsc
e79863d7926aa1fd4af99874e552dee5 114604451 database optional
mariadb_10.11.18.orig.tar.gz
7e39040dc9279eb4d5754d484b1a28db 833 database optional
mariadb_10.11.18.orig.tar.gz.asc
21a0b5ac94501f85b29afd302615791b 270392 database optional
mariadb_10.11.18-0+deb12u1.debian.tar.xz
04f9f71e099b27f5b716122e32ddf88a 10765 database optional
mariadb_10.11.18-0+deb12u1_source.buildinfo
-----BEGIN PGP SIGNATURE-----
iQIzBAEBCgAdFiEEY+78PeFNUUbOfyS/NLitfZUp55MFAmpG3oYACgkQNLitfZUp
55MuXxAAjCY9RqmBfgGB7nPca+AraQXV3AR9RGp4q+zFtErdP9lTAT35CapT/gPc
xPC24baX6RMtFw0PXOLrmxMsOs2rKJfbzA3QdSt+yp/OxMSu0CrcJK6/f9MXrWzl
4CJcZBhlbeNkSJROXJqM84ww2BgwoiFlCO16A2igWdmN+NDE8HbBojk8pqhiawWl
7fGyFrFN+/nr7JpVY9/IhGNeLscrBDGCf3t4S6gWTl8zDzbix2sg2pm7Sb7DL4IK
14+xWrdLprBBofFdrand5D82guDmXCaWC//YuihnDFFziu9xuiEo+KxZA8v95K+H
qDPp6MpRg5Lmx+qrn/fq4Sb4NiJDei7J1kINsskIlynCTAMaggLJDIG5dt+zMi1a
sUcfk5LH62EciEyi+RQJN6Vy4cv0gtrGfFe86oy655RUt6sGvQqRySC2YDqXbdH8
YgtfGQTtFkaT5ATbRn9q1qT0SBg8fKOrfPFB1JOSQTI2Z2EX0oPpUDE6C5+2SGP8
nC7aIDeapD+WqYSUxEDM598BZMHPndB1utG5P2uLzoeZk+I0wM3NzyrwrCgKhC/X
tq9kLnPM4BxuA89hR8j1cQQtOO1B8RQHetyUZIooSMmxP9xO4bJQxwgMIdAWROl5
BS1N+43udQy9Zw08TA798V/YNtrxhxHf7ge/Q3RSgMkXNaYoDck=
=TTzj
-----END PGP SIGNATURE-----
pgpoymZdKVMD0.pgp
Description: PGP signature
--- End Message ---
