<html><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /></head><body style='font-size: 10pt; font-family: Verdana,Geneva,sans-serif'>
<div id="editbody1" style="font-size: 10pt; font-family: Verdana,Geneva,sans-serif;">
<p>Package: mariadb</p>
<p><br /></p>
<p>Hello,</p>
<p>I upgraded Debian 12 to 13.</p>
<p>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.</p>
<p>command mariadb-dump --system=users fails with error message:</p>
<p>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' */': <strong>Illegal mix of collations (utf8mb4_general_ci,COERCIBLE) and (utf8mb4_uca1400_ai_ci,</strong>COERCIBLE) for operation '=' (1267)</p>
<p>What to do to prevent this situation? What to do when situation already occured? What another hidden "mines" this upgrade brings to us?</p>
<p>Command mariadb-upgrade didn't help even with parameter --force.</p>
<p>SHOW VARIABLES LIKE 'collation%';</p>
<p><span style="font-family: 'andale mono', monospace;">+----------------------+-----------------------+</span><br /><span style="font-family: 'andale mono', monospace;">| Variable_name | Value |</span><br /><span style="font-family: 'andale mono', monospace;">+----------------------+-----------------------+</span><br /><span style="font-family: 'andale mono', monospace;">| collation_connection | utf8mb4_uca1400_ai_ci |</span><br /><span style="font-family: 'andale mono', monospace;">| collation_database | utf8mb4_general_ci |</span><br /><span style="font-family: 'andale mono', monospace;">| collation_server | utf8mb4_uca1400_ai_ci |</span><br /><span style="font-family: 'andale mono', monospace;">+----------------------+-----------------------+</span></p>
<p>Thank you for quick solution for everybody.</p>
<div id="v1signature">-- <br />
<pre>s pozdravem / best regards<strong><br /><br />Viktor Matys - Grumpa.Net<br /></strong>specialista na web, mail, zálohování
U Kapličky 442/5
Litoměřice
Czech Republic
<strong>tel: +420 721 67 44 55</strong>
web: <a href="http://www.grumpa.net/" target="_blank" rel="noopener noreferrer">http://www.grumpa.net/</a></pre>
</div>
</div>
</body></html>