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/
