[From nobody Sat Jun 6 09:51:12 2026 Received: (at submit) by bugs.debian.org; 21 May 2026 07:20:59 +0000 X-Spam-Checker-Version: SpamAssassin 4.0.1-bugs.debian.org_2005_01_02 (2024-03-25) on buxtehude.debian.org X-Spam-Level: X-Spam-Status: No, score=-11.6 required=4.0 tests=BAYES_00, BODY_INCLUDES_PACKAGE,DKIM_SIGNED,DKIM_VALID,DKIM_VALID_AU, DKIM_VALID_EF,FOURLA,HAS_PACKAGE,HTML_MESSAGE,LONGLINEURL,MULTALT, SPF_HELO_NONE,SPF_PASS autolearn=ham autolearn_force=no version=4.0.1-bugs.debian.org_2005_01_02 X-Spam-Bayes: score:0.0000 Tokens: new, 71; hammy, 122; neutral, 45; spammy, 4. spammytokens:0.993-1--pozdravem, 0.884-+--republic, 0.871-1--QUOTE, 0.847-3--Republic hammytokens:0.000-+--mariadb, 0.000-+--debian, 0.000-+--Debian, 0.000-+--NULL, 0.000-+--UD:user Return-path: <v.matys@grumpa.net> Received: from home.grumpa.net ([2a02:25b0:aaaa:9a2f::1:10]:34186) by buxtehude.debian.org with esmtps (TLS1.3:ECDHE_X25519__RSA_PSS_RSAE_SHA256__AES_256_GCM:256) (Exim 4.96) (envelope-from <v.matys@grumpa.net>) id 1wPxiD-00CM9a-25 for submit@bugs.debian.org; Thu, 21 May 2026 07:20:58 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=grumpa.net; s=grumpanet; t=1779348052; bh=vEUDor/czTMbmWqGIOUV+D3QXJ+WFHuKsX+C0BznP9w=; h=Date:From:To:Subject:From; b=kO0W4vz7dxJW084lTmMFq43A20iNXWC7/01hDIPQZ1fgMJ+T9NHy8S2qdaRnjRCKM b6SnfhGzBwxI/4WTTM05CwtYsSoV5R3TNoRARxwNxXc7uGNp3O/38xwR+HeNWBP8xo A5XcMMhXeB4gKa3yQ51GQRQPxOV1Rftoc4Cmr8Pib+uQ1+xGbYMywruY1RsuVE6SL8 0xhMMxXf8ns6fpps3RBi76ZJTFHSRunm0gFM/DZVgjPkgwvUG0E5sAFCBj+opKtRMV QF3sCzMV7sAwGXP4u9UZ8VFuOwWQ7smHWDhUQb+vTiR9Y23wzf1s4Db6s3lcubDkSp n3OUFoRohSFSA== Received: from mail.grumpa.net (home.grumpa.net [46.36.38.14]) by home.grumpa.net (Postfix) with ESMTPSA id B7AD820587 for <submit@bugs.debian.org>; Thu, 21 May 2026 09:20:52 +0200 (CEST) Received: from 2a00:5c20:300:1:cfd9:9dae:8cbf:4f7a by mail.grumpa.net with HTTP (HTTP/1.1 POST); Thu, 21 May 2026 07:20:52 +0000 MIME-Version: 1.0 Date: Thu, 21 May 2026 09:20:52 +0200 From: Viktor Matys <v.matys@grumpa.net> To: submit@bugs.debian.org Subject: Package: mariadb after upgrade to debian 13 claims problems with collation Message-ID: <c880043cf291e858b3da50d26017ab2a@grumpa.net> X-Sender: v.matys@grumpa.net Content-Type: multipart/alternative; boundary="=_718a5bcbfd82d9e819838dd01ae5f5df" X-Greylist: delayed 1338 seconds by postgrey-1.37 at buxtehude; Thu, 21 May 2026 07:20:57 UTC Delivered-To: submit@bugs.debian.org --=_718a5bcbfd82d9e819838dd01ae5f5df Content-Transfer-Encoding: 8bit Content-Type: text/plain; charset=UTF-8; format=flowed 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/ --=_718a5bcbfd82d9e819838dd01ae5f5df Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=UTF-8 <html><head><meta http-equiv=3D"Content-Type" content=3D"text/html; charset= =3DUTF-8" /></head><body style=3D'font-size: 10pt; font-family: Verdana,Gen= eva,sans-serif'> <div id=3D"editbody1" style=3D"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 "shu= tdown complete" in the log, enable and start after upgrade and checking log= "upgrade completed" or so.</p> <p>command mariadb-dump --system=3Dusers 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=3De.from_user   &= nbsp;           AND u.host=3De.from_host   &n= bsp;      WHERE e.from_user IS NULL */ /*M!100005 WHERE is_r= ole=3D'N' */': <strong>Illegal mix of collations (utf8mb4_general_ci,COERCI= BLE) and (utf8mb4_uca1400_ai_ci,</strong>COERCIBLE) for operation '=3D' (12= 67)</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=3D"font-family: 'andale mono', monospace;">+----------------= ------+-----------------------+</span><br /><span style=3D"font-family: 'an= dale mono', monospace;">| Variable_name        | Value =                 |</span><br /><span= style=3D"font-family: 'andale mono', monospace;">+----------------------+-= ----------------------+</span><br /><span style=3D"font-family: 'andale mon= o', monospace;">| collation_connection | utf8mb4_uca1400_ai_ci |</span><br = /><span style=3D"font-family: 'andale mono', monospace;">| collation_databa= se   | utf8mb4_general_ci    |</span><br /><span style=3D"fo= nt-family: 'andale mono', monospace;">| collation_server     | ut= f8mb4_uca1400_ai_ci |</span><br /><span style=3D"font-family: 'andale mono'= , monospace;">+----------------------+-----------------------+</span></p> <p>Thank you for quick solution for everybody.</p> <div id=3D"v1signature">-- <br /> <pre>s pozdravem / best regards<strong><br /><br />Viktor Matys - Grumpa.Ne= t<br /></strong>specialista na web, mail, zálohování U Kapli=C4=8Dky 442/5 Litom=C4=9B=C5=99ice Czech Republic <strong>tel: +420 721 67 44 55</strong> web: <a href=3D"http://www.grumpa.net/" target=3D"_blank" rel=3D"noopener n= oreferrer">http://www.grumpa.net/</a></pre> </div> </div> </body></html> --=_718a5bcbfd82d9e819838dd01ae5f5df-- ]