[debian-mysql] Bug#1126850: mariadb-server: "mysqldump --system=users" fails with error "Illegal mix of collations"

[Sven Strickroth]

Package: mariadb-server
Version: 1:11.8.3-0+deb13u1
Severity: important
X-Debbugs-Cc: debian-bugs at 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