Your message dated Fri, 29 Aug 2025 06:02:28 +0000
with message-id <[email protected]>
and subject line Bug#1104533: fixed in mariadb 1:11.8.3-0+deb13u1
has caused the Debian Bug report #1104533,
regarding debian-start: ERROR 1267 (HY000): 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.)
--
1104533: https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=1104533
Debian Bug Tracking System
Contact [email protected] with problems
--- Begin Message ---
Package: mariadb-server
Version: 1:11.8.1-4
Severity: normal
After upgrading from bookworm to trixie, starting mariadb produces this
error message in journal:
May 01 18:17:39 back debian-start[148992]: --------------
May 01 18:17:39 back debian-start[148992]: SELECT count(*) FROM mysql.user
WHERE user='root' and password='' and password_expired='N' and plugin in ('',
'mysql_native_password', 'mysql_old_password')
May 01 18:17:39 back debian-start[148992]: --------------
May 01 18:17:39 back debian-start[148992]: ERROR 1267 (HY000) at line 1:
Illegal mix of collations (utf8mb4_general_ci,COERCIBLE) and
(utf8mb4_uca1400_ai_ci,COERCIBLE) for operation '='
mariadb-server dows start and appears to run fine.
I can also reproduce the error manually with the following query:
MariaDB [(none)]> SELECT * FROM mysql.user where password_expired='N';
ERROR 1267 (HY000): Illegal mix of collations (utf8mb4_general_ci,COERCIBLE)
and (utf8mb4_uca1400_ai_ci,COERCIBLE) for operation '='
Please let me know if I can provide any more information.
Samuli
-- System Information:
Debian Release: trixie/sid
APT prefers testing
APT policy: (900, 'testing'), (700, 'unstable'), (500, 'experimental')
Architecture: amd64 (x86_64)
Kernel: Linux 6.12.22-cloud-amd64 (SMP w/2 CPU threads; PREEMPT)
Locale: LANG=en_IE.UTF-8, LC_CTYPE=en_IE.UTF-8 (charmap=UTF-8),
LANGUAGE=en_IE: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.150
ii debconf [debconf-2.0] 1.5.91
ii galera-4 26.4.21-1
ii gawk 1:5.2.1-2+b1
ii init-system-helpers 1.68
ii iproute2 6.14.0-3
ii libc6 2.41-7
ii libdbi-perl 1.647-1
ii libgcc-s1 14.2.0-19
ii libpam0g 1.7.0-3
ii libssl3t64 3.5.0-1
ii libstdc++6 14.2.0-19
ii lsof 4.99.4+dfsg-2
ii mariadb-client 1:11.8.1-4
ii mariadb-common 1:11.8.1-4
ii mariadb-server-core 1:11.8.1-4
ii passwd 1:4.17.4-2
ii perl 5.40.1-3
ii procps 2:4.0.4-8
ii psmisc 23.7-2
ii rsync 3.4.1+ds1-3
ii socat 1.8.0.3-1
ii zlib1g 1:1.3.dfsg+really1.3.1-1+b1
Versions of packages mariadb-server recommends:
ii libhtml-template-perl 2.97-2
ii mariadb-plugin-provider-bzip2 1:11.8.1-4
ii mariadb-plugin-provider-lz4 1:11.8.1-4
ii mariadb-plugin-provider-lzma 1:11.8.1-4
ii mariadb-plugin-provider-lzo 1:11.8.1-4
ii mariadb-plugin-provider-snappy 1:11.8.1-4
ii pv 1.9.31-1
Versions of packages mariadb-server suggests:
ii bsd-mailx [mailx] 8.1.2-0.20220412cvs-1
pn mariadb-test <none>
ii netcat-openbsd 1.228-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'
-- debconf information:
mariadb-server/old_data_directory_saved:
mariadb-server/nis_warning:
mariadb-server/postrm_remove_databases: false
--- End Message ---
--- Begin Message ---
Source: mariadb
Source-Version: 1:11.8.3-0+deb13u1
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: Tue, 26 Aug 2025 09:05:45 -0700
Source: mariadb
Architecture: source
Version: 1:11.8.3-0+deb13u1
Distribution: trixie
Urgency: medium
Maintainer: Debian MySQL Maintainers <[email protected]>
Changed-By: Otto Kekäläinen <[email protected]>
Closes: 1104533
Changes:
mariadb (1:11.8.3-0+deb13u1) trixie; urgency=medium
.
* New upstream maintenance release 11.8.3. For details about fixes please see
https://mariadb.com/kb/en/mariadb-11-8-3-release-notes/
* Drop Hurd patches that are now included upstream
* Update configuration traces to include new upstream system variables:
- analyze-max-length (default: 4294967295)
- innodb-linux-aio (default: auto)
* Suppress new native AIO warning introduced in upstream a87bb96 to avoid
mariadb-test-run failing on something that isn't a real issue
* New upstream release includes fix for MDEV-36815 that yielded "ERROR 1267
(HY000): Illegal mix of collations" on some systems when restarting the
MariaDB service in Debian (Closes: #1104533)
* Remove obsolete cleanup as upstream moved pam_mariadb_mtr.so in c05b1fe
* Salsa CI: Remove Buster upgrades and ignore missing Trixie ones
* Start branch debian/13-trixie for stable updates
Checksums-Sha1:
3743ff4c773121a95162ca07aedf5732544d07e1 5653 mariadb_11.8.3-0+deb13u1.dsc
264b1d3853d7ce82b822e577f307e414ec699168 119640174 mariadb_11.8.3.orig.tar.gz
f4e5be6e8e481566dc763eac7c68614d52e58e18 833 mariadb_11.8.3.orig.tar.gz.asc
2457076ff0ea26786650515a7cf6b9c6e0b118a0 287972
mariadb_11.8.3-0+deb13u1.debian.tar.xz
e0f56b8463d39d22a4d48865b707b2b210cf6d36 13371
mariadb_11.8.3-0+deb13u1_source.buildinfo
Checksums-Sha256:
ec78ef72089a5ea9f14cf3dded2cb3fe341a52a286569cc9b2a78a9116872475 5653
mariadb_11.8.3-0+deb13u1.dsc
1014a85c768de8f9e9c6d4bf0b42617f3b1588be1ad371f71674ea32b87119c0 119640174
mariadb_11.8.3.orig.tar.gz
829244b8592ab5938379889c1a43c4f7b20fcb9f97855d22d70df717a2660178 833
mariadb_11.8.3.orig.tar.gz.asc
9894b4fc61b3c05bb174ae8166840641694b7efa618a305a759b3a8a4ef639af 287972
mariadb_11.8.3-0+deb13u1.debian.tar.xz
50530ec7a176af9352add53097c94c80f2ca44584e4e70a976d008787ff938db 13371
mariadb_11.8.3-0+deb13u1_source.buildinfo
Files:
0e3c1fef8df5f506bbc3a71be0eefbe9 5653 database optional
mariadb_11.8.3-0+deb13u1.dsc
3c81bc728598f5b53067220c7b729747 119640174 database optional
mariadb_11.8.3.orig.tar.gz
34bd2a8a697c0ede2151f402b28d3ff1 833 database optional
mariadb_11.8.3.orig.tar.gz.asc
3ff08698da5ae694d85c70c34b4f67cd 287972 database optional
mariadb_11.8.3-0+deb13u1.debian.tar.xz
b484f02bf45d48b63d88eace325774a2 13371 database optional
mariadb_11.8.3-0+deb13u1_source.buildinfo
-----BEGIN PGP SIGNATURE-----
iQIzBAEBCgAdFiEEmbRSsR88dMO0U+RvvthEn87o2ogFAmiw5pQACgkQvthEn87o
2oj0QQ/8Dz5ouV0UUCPtjfibK5at7xtGfVzSx74GNOMYmPuXBeXhsNdiBg1dN+da
o9kxQVe4yd3LyhVXn3nXJXLxKHsZ14V4UJ9C2cMwRbAqnyWOcgQZq8NR1CYBjeug
NLRhuaVp4v8+A6FxviaCqViWhv0CuScBEILkrOp1xuUDdl5OLDynkjMQzFuiS5kF
7i95v7ABEUUywZiU0nDeMiXUpZGKrE5ZINotRkvQ0NhLSFRzaDa0erqOBpmEVwxs
+T1RPkMBMkOfI7T5hWDr+/clj7uSClx9GwKQGS9bTStBvZ0VIBEsT6VqTKddAzAt
stjF6TNxStDPL+wDO8dvl5HbdNMOk/p+c/rpLJkwPb50gUrJbsJb2Dy7R6gPBa6K
/5f9ceNrjaMGELIIDNEZ+wx09cfSNy0by2bEpsdDsoV1kZcQCstXAH5WDvzwC352
J+hKT6bJgR4OTv/gV7pFGFHmB+IxjllXR3W2wtilgwPjGKweysuUQ73y7QZveMg7
9DexuwPJcGhIYNjtyijm5xE9XzhGpF/A0co12FPQIHTrLTOcuoHwXDRAzW/vvLfu
3fBDjYAB7JICg4xxU3/OVblExUPW2v9WNrJ19zDkQ34OJtq3kydQvUBWqy5jXiRe
wTPKKAKxMgx/fIsfdCroK7RFc8E7EMf3t5pmigph9CTJZpCLeEs=
=r41/
-----END PGP SIGNATURE-----
pgpCWKndjC_re.pgp
Description: PGP signature
--- End Message ---
