[MDEV-4151] Error message on an attempt of RPM upgrade from one major version to another mixes up MySQL and MariaDB - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Minor
Resolution: Fixed
Affects Version/s: 10.0.1, 5.5.29
Fix Version/s: 10.5.29, 10.6.22, 10.11.12, 11.4.6, 11.8.2
Component/s: Documentation, Packaging
Labels:

Sprint:
Sprint 4 (25.02.2025)

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.

Attachments

Issue Links

is duplicated by

MDEV-7302 rpm upgrade error message gives wrong instruction for finding installed packages

Closed

is part of

MDEV-22315 MySQL -> MariaDB upgrades

Open

MDEV-22329 Packages issues when upgrading

Open

relates to

MDEV-9584 Upgrading MariaDB 5.5 to 10.1.11 fails with RPM

Stalled

Activity

Ascending order - Click to sort in descending order

Elena Stepanova created issue - 2013-02-08 15:39

Elena Stepanova made changes - 2013-02-08 15:39

Field	Original Value	New Value
Link		This issue relates to TODO-27 [ TODO-27 ]

Sergei Golubchik made changes - 2013-03-11 22:25

Fix Version/s		5.5.31 [ 12700 ]
Fix Version/s	5.5.30 [ 11800 ]

Sergei Golubchik made changes - 2013-03-26 12:19

Assignee

Colin Charles [ colin ]

Sergei Golubchik [ serg ]

Sergei Golubchik made changes - 2013-04-28 16:58

Fix Version/s		10.0.3 [ 12900 ]
Fix Version/s	10.0.2 [ 11900 ]

Sergei Golubchik made changes - 2013-05-24 12:55

Fix Version/s		5.5.32 [ 13000 ]
Fix Version/s	5.5.31 [ 12700 ]

Sergei Golubchik made changes - 2013-06-04 15:39

Fix Version/s		10.0.4 [ 13101 ]
Fix Version/s	10.0.3 [ 12900 ]

Sergei Golubchik made changes - 2013-06-13 15:51

Assignee

Sergei Golubchik [ serg ]

Sergei Golubchik made changes - 2013-07-18 19:39

Fix Version/s		5.5.33 [ 13300 ]
Fix Version/s	5.5.32 [ 13000 ]

Sergei Golubchik made changes - 2013-08-16 16:27

Fix Version/s		10.0.5 [ 13201 ]
Fix Version/s	10.0.4 [ 13101 ]

Sergei Golubchik made changes - 2013-09-16 19:04

Fix Version/s		5.5.34 [ 13500 ]
Fix Version/s	5.5.33 [ 13300 ]

Sergei Golubchik made changes - 2013-09-20 18:22

Fix Version/s		5.5.34 [ 13700 ]
Fix Version/s	5.5.33a [ 13500 ]

Sergei Golubchik made changes - 2013-11-05 23:01

Fix Version/s		10.0.6 [ 13202 ]
Fix Version/s	10.0.5 [ 13201 ]

Sergei Golubchik made changes - 2013-11-18 21:52

Fix Version/s		10.0.7 [ 14100 ]
Fix Version/s	10.0.6 [ 13202 ]

Sergei Golubchik made changes - 2013-11-21 21:02

Fix Version/s		5.5.35 [ 14000 ]
Fix Version/s	5.5.34 [ 13700 ]

Sergei Golubchik made changes - 2013-12-28 17:50

Fix Version/s		10.0.8 [ 14200 ]
Fix Version/s	10.0.7 [ 14100 ]

Sergei Golubchik made changes - 2014-01-29 10:10

Fix Version/s		5.5.36 [ 14600 ]
Fix Version/s	5.5.35 [ 14000 ]

Sergei Golubchik made changes - 2014-02-10 16:13

Fix Version/s		10.0.9 [ 14400 ]
Fix Version/s	10.0.8 [ 14200 ]

Sergei Golubchik made changes - 2014-02-24 21:51

Fix Version/s		5.5.37 [ 15000 ]
Fix Version/s	5.5.36 [ 14600 ]

Sergei Golubchik made changes - 2014-03-09 22:02

Fix Version/s		10.0.10 [ 14500 ]
Fix Version/s	10.0.9 [ 14400 ]

Sergei Golubchik made changes - 2014-03-31 14:23

Fix Version/s		10.0.11 [ 15200 ]
Fix Version/s	10.0.10 [ 14500 ]

Sergei Golubchik made changes - 2014-04-15 23:53

Fix Version/s		5.5.38 [ 15400 ]
Fix Version/s	5.5.37 [ 15000 ]

Sergei Golubchik made changes - 2014-05-10 23:13

Fix Version/s		10.0.12 [ 15201 ]
Fix Version/s	10.0.11 [ 15200 ]

Sergei Golubchik made changes - 2014-06-06 10:26

Fix Version/s		5.5.39 [ 15800 ]
Fix Version/s	5.5.38 [ 15400 ]

Sergei Golubchik made changes - 2014-06-13 15:06

Workflow

defaullt [ 26136 ]

MariaDB v2 [ 43882 ]

Sergei Golubchik made changes - 2014-06-16 13:27

Fix Version/s		10.0.13 [ 16000 ]
Fix Version/s	10.0.12 [ 15201 ]

Elena Stepanova made changes - 2014-12-12 00:11

Link

This issue is duplicated by ~~MDEV-7302~~ [ ~~MDEV-7302~~ ]

Elena Stepanova made changes - 2014-12-12 00:12

Priority

Trivial [ 5 ]

Minor [ 4 ]

Rasmus Johansson (Inactive) made changes - 2015-05-18 17:51

Workflow

MariaDB v2 [ 43882 ]

MariaDB v3 [ 65464 ]

Elena Stepanova made changes - 2016-03-19 22:23

Link

This issue relates to MDEV-9584 [ MDEV-9584 ]

Anel Husakovic made changes - 2020-04-22 14:30

Link

This issue is part of MDEV-22329 [ MDEV-22329 ]

Anel Husakovic made changes - 2020-04-22 15:38

Link

This issue is part of MDEV-22315 [ MDEV-22315 ]

Ian Gilfillan made changes - 2020-11-09 17:04

Fix Version/s		10.2 [ 14601 ]
Fix Version/s	5.5 [ 15800 ]
Fix Version/s	10.0 [ 16000 ]

Ian Gilfillan made changes - 2020-11-09 17:05

Component/s

Packaging [ 10700 ]

Ian Gilfillan made changes - 2020-11-09 17:05

Labels

beginner-friendly

Ian Gilfillan made changes - 2020-11-09 17:05

Summary

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

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

Sergei Golubchik made changes - 2021-12-06 21:32

Workflow

MariaDB v3 [ 65464 ]

MariaDB v4 [ 139488 ]

Sergei Golubchik made changes - 2024-12-16 10:34

Link

This issue is part of ~~MDEV-26568~~ [ ~~MDEV-26568~~ ]

Sergei Golubchik made changes - 2024-12-16 10:35

Link

This issue is part of ~~MDEV-26568~~ [ ~~MDEV-26568~~ ]

Sergey Vojtovich made changes - 2025-02-12 08:21

Labels

beginner-friendly

beginner-friendly contribution

Vicențiu Ciorbaru made changes - 2025-02-20 09:37

Labels

beginner-friendly contribution

beginner-friendly contribution foundation

Vicențiu Ciorbaru made changes - 2025-02-20 09:37

Assignee

Sergey Vojtovich [ svoj ]

Vlad Radu made changes - 2025-02-20 09:38

Sprint

Sprint 4 (25.02.2025) [ 786 ]

Vlad Radu made changes - 2025-02-20 09:38

Rank

Ranked lower

Sergey Vojtovich made changes - 2025-02-25 19:10

Status

Open [ 1 ]

Confirmed [ 10101 ]

Sergey Vojtovich made changes - 2025-02-25 19:10

Assignee	Sergey Vojtovich [ svoj ]	Sergei Golubchik [ serg ]
Status	Confirmed [ 10101 ]	In Review [ 10002 ]

Sergey Vojtovich made changes - 2025-02-25 19:13

Due Date

2025-04-01

Sergei Golubchik made changes - 2025-02-26 13:40

Fix Version/s		10.11 [ 27614 ]
Fix Version/s		11.4 [ 29301 ]
Fix Version/s	10.2(EOL) [ 14601 ]

Vicențiu Ciorbaru made changes - 2025-03-05 10:23

Assignee

Sergei Golubchik [ serg ]

Vicențiu Ciorbaru [ cvicentiu ]

Vicențiu Ciorbaru made changes - 2025-03-05 10:23

Status

In Review [ 10002 ]

Stalled [ 10000 ]

Vicențiu Ciorbaru made changes - 2025-03-05 10:24

Component/s		Documentation [ 10903 ]
Fix Version/s		10.5.29 [ 29996 ]
Fix Version/s		10.6.22 [ 29997 ]
Fix Version/s		10.11.12 [ 29998 ]
Fix Version/s		11.4.6 [ 29999 ]
Fix Version/s		11.8.2 [ 30001 ]
Fix Version/s	10.11 [ 27614 ]
Fix Version/s	11.4 [ 29301 ]
Resolution		Fixed [ 1 ]
Status	Stalled [ 10000 ]	Closed [ 6 ]

People

Assignee:: Vicențiu Ciorbaru

Reporter:: Elena Stepanova

Votes:: 1 Vote for this issue

Watchers:: 7 Start watching this issue

Dates

Due:: 2025-04-01

Created:: 2013-02-08 15:39

Updated:: 2025-03-05 12:44

Resolved:: 2025-03-05 10:24

Git Integration

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

MariaDB Server

Details

Description

Attachments

Issue Links

Activity

People

Dates

Git Integration