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

    • Type: Bug
    • Status: Confirmed (View Workflow)
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: 10.3, 10.4
    • Fix Version/s: 10.3, 10.4
    • Component/s: Scripts & Clients
    • Labels:
      None
    • Environment:
      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

              Assignee:
              sanja Oleksandr Byelkin
              Reporter:
              ngdangthien Nguyen Dang Thien
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated: