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
