[debian-mysql] Bug#1137221: Package: mariadb after upgrade to debian 13 claims problems with collation

[Viktor Matys]

Package: mariadb

Hello,

I upgraded Debian 12 to 13.

I followed upgrade notices about stop and disable mariadb, checking 
"shutdown complete" in the log, enable and start after upgrade and 
checking log "upgrade completed" or so.

command mariadb-dump --system=users fails with error message:

mariadb-dump: 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)

What to do to prevent this situation? What to do when situation already 
occured? What another hidden "mines" this upgrade brings to us?

Command mariadb-upgrade didn't help even with parameter --force.

SHOW VARIABLES LIKE 'collation%';

+----------------------+-----------------------+
| Variable_name        | Value                 |
+----------------------+-----------------------+
| collation_connection | utf8mb4_uca1400_ai_ci |
| collation_database   | utf8mb4_general_ci    |
| collation_server     | utf8mb4_uca1400_ai_ci |
+----------------------+-----------------------+

Thank you for quick solution for everybody.

-- 

s pozdravem / best regards

Viktor Matys - Grumpa.Net
specialista na web, mail, zálohování
U Kapličky 442/5
Litoměřice
Czech Republic

tel: +420 721 67 44 55
web: http://www.grumpa.net/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://alioth-lists.debian.net/pipermail/pkg-mysql-maint/attachments/20260521/c73ca985/attachment.htm>