Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-37442

Illegal mix of collations during "mariadb-dump --system=user"

    XMLWordPrintable

Details

    Description

      Hi

      we have script that backup all users with "mariadb-dump --system=user"
      we are getting this error since we upgraded the database from Maria 11.2 to 11.8.2
      its work ok when we start new instance of 11.8.2 (without any upgrade)

      docker exec -it ${docker_id} /usr/bin/mariadb-dump --system=user

      /*M!999999- enable the sandbox mode */
      – MariaDB dump 10.19-11.8.2-MariaDB, for debian-linux-gnu (x86_64)

      -- Host: 127.0.0.1 Database:
      – ------------------------------------------------------
      – Server version 11.8.2-MariaDB-ubu2404-log

      /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
      /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
      /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
      /*!40101 SET NAMES utf8mb4 */;
      /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
      /*!40103 SET TIME_ZONE='+00:00' */;
      /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
      /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
      /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
      /*M!100616 SET @OLD_NOTE_VERBOSITY=@@NOTE_VERBOSITY, NOTE_VERBOSITY=0 */;
      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)

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              Finkelshtein Yehuda Finkel
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.