[From nobody Sat Jun 6 09:51:11 2026 Received: (at submit) by bugs.debian.org; 2 Feb 2026 13:40:59 +0000 X-Spam-Checker-Version: SpamAssassin 4.0.1-bugs.debian.org_2005_01_02 (2024-03-25) on buxtehude.debian.org X-Spam-Level: X-Spam-Status: No, score=-17.4 required=4.0 tests=BAYES_00, BODY_INCLUDES_PACKAGE,DKIM_ADSP_ALL,FOURLA,HAS_PACKAGE,SPF_HELO_NONE, SPF_SOFTFAIL,XMAILER_REPORTBUG autolearn=ham autolearn_force=no version=4.0.1-bugs.debian.org_2005_01_02 X-Spam-Bayes: score:0.0000 Tokens: new, 21; hammy, 150; neutral, 190; spammy, 0. spammytokens: hammytokens:0.000-+--XDebbugsCc, 0.000-+--X-Debbugs-Cc, 0.000-+--bookworm, 0.000-+--HTo:N*Debian, 0.000-+--H*Ad:N*Bug Return-path: <debian-bugs@cs-ware.de> Received: from mysql-backup.79p.de ([2a01:4f8:c0c:99ff::1]:36076) by buxtehude.debian.org with esmtp (Exim 4.96) (envelope-from <debian-bugs@cs-ware.de>) id 1vmuAl-000Kzh-26 for submit@bugs.debian.org; Mon, 02 Feb 2026 13:40:59 +0000 Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit From: Sven Strickroth <debian-bugs@cs-ware.de> To: Debian Bug Tracking System <submit@bugs.debian.org> Subject: mariadb-server: "mysqldump --system=users" fails with error "Illegal mix of collations" Message-ID: <177003965245.27736.16707773017607810030.reportbug@mysql-backup.79p.de> X-Mailer: reportbug 13.2.0 Date: Mon, 02 Feb 2026 14:40:52 +0100 Delivered-To: submit@bugs.debian.org Package: mariadb-server Version: 1:11.8.3-0+deb13u1 Severity: important X-Debbugs-Cc: debian-bugs@cs-ware.de 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 ]