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

Error message on an attempt of RPM upgrade from one major version ro another mixes up MySQL and MariaDB

        Details

        • Type: Bug
        • Status: Open
        • Priority: Minor
        • Resolution: Unresolved
        • Affects Version/s: 10.0.1, 5.5.29
        • Fix Version/s: 10.0, 5.5
        • Component/s: None
        • Labels:
          None

          Description

          When RPM/yum upgrade from one major version to another is attempted, it fails with a verbose error message. The text explains why such an upgrade is not recommended and suggests the right way to do it. Sometimes it mentions MySQL instead of MySQL/MariaDB which makes it rather unclear. More importantly, it suggests to find conflicting packages by grepping for 'mysql' which simply doesn't work if the old version is also MariaDB.

          An example of the text generated on upgrade from MariaDB 5.5.29 to MariaDB 10.0.1 is below.

          A MySQL or MariaDB server package (MariaDB-server-5.5.29-1) is installed.

Upgrading directly from MySQL 5.5 to MariaDB 10.0 may not
be safe in all cases.  A manual dump and restore using mysqldump is
recommended.  It is important to review the MariaDB manual's Upgrading
section for version-specific incompatibilities.

A manual upgrade is required.

- Ensure that you have a complete, working backup of your data and my.cnf
  files
- Shut down the MySQL server cleanly
- Remove the existing MySQL packages.  Usually this command will
  list the packages you should remove:
  rpm -qa | grep -i '^mysql-'

  You may choose to use 'rpm --nodeps -ev <package-name>' to remove
  the package which contains the mysqlclient shared library.  The
  library will be reinstalled by the MariaDB-shared package.
- Install the new MariaDB packages supplied by Monty Program AB
- Ensure that the MariaDB server is started
- Run the 'mysql_upgrade' program

This is a brief description of the upgrade process.  Important details
can be found in the MariaDB manual, in the Upgrading section.A MySQL or MariaDB server package (MariaDB-server-5.5.29-1) is installed.

Upgrading directly from MySQL 5.5 to MariaDB 10.0 may not
be safe in all cases.  A manual dump and restore using mysqldump is
recommended.  It is important to review the MariaDB manual's Upgrading
section for version-specific incompatibilities.

A manual upgrade is required.

- Ensure that you have a complete, working backup of your data and my.cnf
  files
- Shut down the MySQL server cleanly
- Remove the existing MySQL packages.  Usually this command will
  list the packages you should remove:
  rpm -qa | grep -i '^mysql-'

  You may choose to use 'rpm --nodeps -ev <package-name>' to remove
  the package which contains the mysqlclient shared library.  The
  library will be reinstalled by the MariaDB-shared package.
- Install the new MariaDB packages supplied by Monty Program AB
- Ensure that the MariaDB server is started
- Run the 'mysql_upgrade' program

This is a brief description of the upgrade process.  Important details
can be found in the MariaDB manual, in the Upgrading section.

            Gliffy Diagrams

              Attachments

                Issue Links

                is duplicated by

                Bug - A problem which impairs or prevents the functions of the product. MDEV-7302 rpm upgrade error message gives wrong instruction for finding installed packages

                • Trivial - Cosmetic problem like misspelt words or misaligned text.
                • Closed

                  Activity

                  Ascending order - Click to sort in descending order
                  Hide
                  Permalink
                  elenst Elena Stepanova added a comment -

                  Raised the priority a bit because there is another bug report MDEV-7302 about the same problem.

                  Show
                  elenst Elena Stepanova added a comment - Raised the priority a bit because there is another bug report MDEV-7302 about the same problem.
                  Hide
                  Permalink
                  kolbe Kolbe Kegel added a comment -

                  Open nearly 2 years! Can we just get this fixed up? It seems really like an easy fix!

                  Show
                  kolbe Kolbe Kegel added a comment - Open nearly 2 years! Can we just get this fixed up? It seems really like an easy fix!

                    People

                    • Assignee:
                      Unassigned
                      Reporter:
                      elenst Elena Stepanova
                    • Votes:
                      1 Vote for this issue
                      Watchers:
                      4 Start watching this issue

                      Dates

                      • Created:
                        Updated: