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

MariaDB-upgrade command fails

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Duplicate
    • 10.6.12
    • N/A
    • Upgrades
    • None
    • Rocky Linux 8

    Description

      Hi Team,

      Currently I have one primary / replica server, installed with MariaDB 10.4.16 CS version..

      Now I want to add two read replicas 10.6 ES version under 10.4 CS master server.. So I took mysqldump(backup) from 10.4 server and restored to 10.6 ES server..

      Backup Command :

      mysqldump -u root -p'xxx' --routines --events --triggers --master-data=2 --single-transaction --all-databases > fullbackup.sql

      Restore Command :

      mysql -u root -p'xxx' < fullbackup.sql

      Then I ran mariadb-upgrade command.. It throws errors, here I attached complete upgrade logs..

      Then I tried with commenting below three lines and I had the same errors,

      #character-set-server=utf8mb4
      #collation-server=utf8mb4_general_ci
      #init-connect='SET NAMES utf8mb4'

      I then tried "old_mode" to empty

      old_mode=""

      And mariadb-upgrade ran OK. Later I tried to uncomment the first 3 lines (character-set) and just keep old_mode="" it ran OK too..

      character-set-server=utf8mb4
      collation-server=utf8mb4_general_ci
      init-connect='SET NAMES utf8mb4'
      old_mode=""

      Attachments

        1. mariadb_custom_server.cnf
          3 kB
          Pon Suresh Pandian
        2. mariadb-upgrade-output.log
          48 kB
          Pon Suresh Pandian

        Issue Links

          Activity

            People

              Unassigned Unassigned
              ponsuresh.pandians Pon Suresh Pandian (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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