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

Error message when upgrading from 10.1 or 10.2 to 10.3

    XMLWordPrintable

Details

    • Bug
    • Status: Confirmed (View Workflow)
    • Minor
    • Resolution: Unresolved
    • 10.3(EOL), 10.4(EOL)
    • 10.4(EOL)
    • Scripts & Clients
    • None
    • Rhel7

    Description

      I got the following errors when trying to upgrade from old version to 10.3. It happens during phase 3 but it is not FATAL and the upgrade finished successfully:

      mysql_upgrade log

      Phase 1/7: Checking and upgrading mysql database
      ....
      Phase 2/7: Installing used storage engines... Skipped
      Phase 3/7: Fixing views
      ......
      db.domainpaths
      Error : Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 100215, now running 100313. Please use mysql_upgrade to fix this error
      error : Corrupt
      db.domainpreviewview
      Error : Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 100215, now running 100313. Please use mysql_upgrade to fix this error
      error : Corrupt
      db.domainprofileview OK
      .....
      Phase 7/7: Running 'FLUSH PRIVILEGES'
      OK
      12/12/2019 15:05:57 : MariaDB server is upgraded successfully!

      Step to duplicate:

      • Install old version 10.1/10.2
      • Stop MariaDB
      • Remove old installation:
        rpm -e --nodeps $(rpm -qa 'mysql*') 2>/dev/null
        rpm -e --nodeps $(rpm -qa 'mariadb*') 2>/dev/null
        rpm -e --nodeps $(rpm -qa 'MariaDB*') 2>/dev/null
        rpm -e --nodeps $(rpm -qa 'jemalloc*') 2>/dev/null
        rpm -e --nodeps $(rpm -qa 'galera*') 2>/dev/null
      • remove old configuration: rm -rf /etc/init.d/mysql.rpmsave
      • Install new version 10.3
      • Start MariaDB
      • Run mysql_upgrade

      Running mysql_upgrade again as suggestion shows:
      This installation of MySQL is already upgraded to 10.3.21-MariaDB, use --force if you still need to run mysql_upgrade

      If I force the 2nd upgrade, sometimes everything is run ok, but sometimes the upgrade hang and it never finishes.

      Attachments

        Issue Links

          Activity

            People

              sanja Oleksandr Byelkin
              ngdangthien Nguyen Dang Thien
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.