Sprint:
Sprint 4 (25.02.2025)
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.
{"report":{"fcp":1418.2000002861023,"ttfb":469.30000019073486,"pageVisibility":"visible","entityId":22835,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"a89aecc5-5d68-4a5f-8f71-2dccdb4e6e6a","navigationType":0,"readyForUser":1510,"redirectCount":0,"resourceLoadedEnd":1711.9000000953674,"resourceLoadedStart":476.5,"resourceTiming":[{"duration":350.09999990463257,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":476.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":476.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":826.5999999046326,"responseStart":0,"secureConnectionStart":0},{"duration":350.90000009536743,"initiatorType":"link","name":"https://jira.mariadb.org/s/7ebd35e77e471bc30ff0eba799ebc151-CDN/lu2cib/820016/12ta74/494e4c556ecbb29f90a3d3b4f09cb99c/_/download/contextbatch/css/jira.browse.project,project.issue.navigator,jira.view.issue,jira.general,jira.global,atl.general,-_super/batch.css?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true&whisper-enabled=true","startTime":476.80000019073486,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":476.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":827.7000002861023,"responseStart":0,"secureConnectionStart":0},{"duration":409.40000009536743,"initiatorType":"script","name":"https://jira.mariadb.org/s/0917945aaa57108d00c5076fea35e069-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":476.90000009536743,"connectEnd":476.90000009536743,"connectStart":476.90000009536743,"domainLookupEnd":476.90000009536743,"domainLookupStart":476.90000009536743,"fetchStart":476.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":476.90000009536743,"responseEnd":886.3000001907349,"responseStart":886.3000001907349,"secureConnectionStart":476.90000009536743},{"duration":497.7999997138977,"initiatorType":"script","name":"https://jira.mariadb.org/s/2d8175ec2fa4c816e8023260bd8c1786-CDN/lu2cib/820016/12ta74/494e4c556ecbb29f90a3d3b4f09cb99c/_/download/contextbatch/js/jira.browse.project,project.issue.navigator,jira.view.issue,jira.general,jira.global,atl.general,-_super/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&locale=en&slack-enabled=true&whisper-enabled=true","startTime":477.2000002861023,"connectEnd":477.2000002861023,"connectStart":477.2000002861023,"domainLookupEnd":477.2000002861023,"domainLookupStart":477.2000002861023,"fetchStart":477.2000002861023,"redirectEnd":0,"redirectStart":0,"requestStart":477.2000002861023,"responseEnd":975,"responseStart":975,"secureConnectionStart":477.2000002861023},{"duration":502.69999980926514,"initiatorType":"script","name":"https://jira.mariadb.org/s/a9324d6758d385eb45c462685ad88f1d-CDN/lu2cib/820016/12ta74/c92c0caa9a024ae85b0ebdbed7fb4bd7/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en","startTime":477.40000009536743,"connectEnd":477.40000009536743,"connectStart":477.40000009536743,"domainLookupEnd":477.40000009536743,"domainLookupStart":477.40000009536743,"fetchStart":477.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":477.40000009536743,"responseEnd":980.0999999046326,"responseStart":980.0999999046326,"secureConnectionStart":477.40000009536743},{"duration":502.90000009536743,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":477.59999990463257,"connectEnd":477.59999990463257,"connectStart":477.59999990463257,"domainLookupEnd":477.59999990463257,"domainLookupStart":477.59999990463257,"fetchStart":477.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":477.59999990463257,"responseEnd":980.5,"responseStart":980.5,"secureConnectionStart":477.59999990463257},{"duration":503.19999980926514,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":477.80000019073486,"connectEnd":477.80000019073486,"connectStart":477.80000019073486,"domainLookupEnd":477.80000019073486,"domainLookupStart":477.80000019073486,"fetchStart":477.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":477.80000019073486,"responseEnd":981,"responseStart":981,"secureConnectionStart":477.80000019073486},{"duration":579.0999999046326,"initiatorType":"link","name":"https://jira.mariadb.org/s/b04b06a02d1959df322d9cded3aeecc1-CDN/lu2cib/820016/12ta74/a2ff6aa845ffc9a1d22fe23d9ee791fc/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":477.90000009536743,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":477.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1057,"responseStart":0,"secureConnectionStart":0},{"duration":504,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":478.09999990463257,"connectEnd":478.09999990463257,"connectStart":478.09999990463257,"domainLookupEnd":478.09999990463257,"domainLookupStart":478.09999990463257,"fetchStart":478.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":478.09999990463257,"responseEnd":982.0999999046326,"responseStart":982.0999999046326,"secureConnectionStart":478.09999990463257},{"duration":578.7999997138977,"initiatorType":"link","name":"https://jira.mariadb.org/s/3ac36323ba5e4eb0af2aa7ac7211b4bb-CDN/lu2cib/820016/12ta74/d176f0986478cc64f24226b3d20c140d/_/download/contextbatch/css/com.atlassian.jira.projects.sidebar.init,-_super,-project.issue.navigator,-jira.view.issue/batch.css?jira.create.linked.issue=true","startTime":478.30000019073486,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":478.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1057.0999999046326,"responseStart":0,"secureConnectionStart":0},{"duration":504.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/5d5e8fe91fbc506585e83ea3b62ccc4b-CDN/lu2cib/820016/12ta74/d176f0986478cc64f24226b3d20c140d/_/download/contextbatch/js/com.atlassian.jira.projects.sidebar.init,-_super,-project.issue.navigator,-jira.view.issue/batch.js?jira.create.linked.issue=true&locale=en","startTime":478.40000009536743,"connectEnd":478.40000009536743,"connectStart":478.40000009536743,"domainLookupEnd":478.40000009536743,"domainLookupStart":478.40000009536743,"fetchStart":478.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":478.40000009536743,"responseEnd":982.9000000953674,"responseStart":982.9000000953674,"secureConnectionStart":478.40000009536743},{"duration":1114.8999996185303,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":486.7000002861023,"connectEnd":486.7000002861023,"connectStart":486.7000002861023,"domainLookupEnd":486.7000002861023,"domainLookupStart":486.7000002861023,"fetchStart":486.7000002861023,"redirectEnd":0,"redirectStart":0,"requestStart":486.7000002861023,"responseEnd":1601.5999999046326,"responseStart":1601.5999999046326,"secureConnectionStart":486.7000002861023},{"duration":1224.8000001907349,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":487.09999990463257,"connectEnd":487.09999990463257,"connectStart":487.09999990463257,"domainLookupEnd":487.09999990463257,"domainLookupStart":487.09999990463257,"fetchStart":487.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":487.09999990463257,"responseEnd":1711.9000000953674,"responseStart":1711.9000000953674,"secureConnectionStart":487.09999990463257},{"duration":534.5,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":1070.0999999046326,"connectEnd":1070.0999999046326,"connectStart":1070.0999999046326,"domainLookupEnd":1070.0999999046326,"domainLookupStart":1070.0999999046326,"fetchStart":1070.0999999046326,"redirectEnd":0,"redirectStart":0,"requestStart":1070.0999999046326,"responseEnd":1604.5999999046326,"responseStart":1604.5999999046326,"secureConnectionStart":1070.0999999046326},{"duration":359.09999990463257,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":1400.8000001907349,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1400.8000001907349,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1759.9000000953674,"responseStart":0,"secureConnectionStart":0},{"duration":265.1000003814697,"initiatorType":"link","name":"https://jira.mariadb.org/s/d5715adaadd168a9002b108b2b039b50-CDN/lu2cib/820016/12ta74/be4b45e9cec53099498fa61c8b7acba4/_/download/contextbatch/css/jira.project.sidebar,-_super,-project.issue.navigator,-jira.general,-jira.browse.project,-jira.view.issue,-jira.global,-atl.general,-com.atlassian.jira.projects.sidebar.init/batch.css?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true&whisper-enabled=true","startTime":1612.0999999046326,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1612.0999999046326,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1877.2000002861023,"responseStart":0,"secureConnectionStart":0},{"duration":223.30000019073486,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/e65b778d185daf5aee24936755b43da6/_/download/contextbatch/js/browser-metrics-plugin.contrib,-_super,-project.issue.navigator,-jira.view.issue,-atl.general/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true&whisper-enabled=true","startTime":1613.0999999046326,"connectEnd":1613.0999999046326,"connectStart":1613.0999999046326,"domainLookupEnd":1613.0999999046326,"domainLookupStart":1613.0999999046326,"fetchStart":1613.0999999046326,"redirectEnd":0,"redirectStart":0,"requestStart":1613.0999999046326,"responseEnd":1836.4000000953674,"responseStart":1836.4000000953674,"secureConnectionStart":1613.0999999046326}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":296,"responseStart":469,"responseEnd":482,"domLoading":474,"domInteractive":1821,"domContentLoadedEventStart":1821,"domContentLoadedEventEnd":1877,"domComplete":2193,"loadEventStart":2193,"loadEventEnd":2193,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1741.9000000953674},{"name":"bigPipe.sidebar-id.end","time":1742.8000001907349},{"name":"bigPipe.activity-panel-pipe-id.start","time":1743.0999999046326},{"name":"bigPipe.activity-panel-pipe-id.end","time":1744.4000000953674},{"name":"activityTabFullyLoaded","time":1893.8000001907349}],"measures":[],"correlationId":"ab6915ccf785ee","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":104,"dbReadsTimeInMs":14,"dbConnsTimeInMs":23,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
Bug
Minor
MDEV-22315 MySQL -> MariaDB upgrades
Raised the priority a bit because there is another bug report
MDEV-7302about the same problem.