[MDEV-29487] mariadb-upgrade does not detect upgraded needed Created: 2022-09-07  Updated: 2022-09-07

Status: Open
Project: MariaDB Server
Component/s: Server, Upgrades
Affects Version/s: 10.6.9
Fix Version/s: None

Type: Bug Priority: Major
Reporter: Oli Sennhauser Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: None
Environment:

Linux, n.a.

Issue Links:
Relates
relates to MDEV-29486 mariadb-upgrade does not upgrade Open
relates to MDEV-29486 mariadb-upgrade does not upgrade Open

 Description   

When we did a MariaDB Galera Cluster upgrade today we first got into this:

mariadb-upgrade --user=root
This installation of MariaDB is already upgraded to 10.6.7-MariaDB.
There is no need to run mysql_upgrade again for 10.6.9-MariaDB.
You can use --force if you still want to run mysql_upgrade

When we did a mariadb-upgrade --user=root --force the upgrade utility found about 12 or so tables to upgrade:

schema1.table1
error : Table rebuild required. Please do "ALTER TABLE `table1` FORCE" or dump/reload to fix it!

This took in total about 1 hour per node! So we completely missed our maintenance time window.

When we did a CHECK TABLE ... FOR UPGRADE on a not yet upgraded node it did NOT complain. So it means this change must be introduced either in 10.6.8 or 10.6.9. Reading the release notes it seems more like 10.6.9

Add on: It would be nice to see this in the release notes that we can expect an upgrade of tables...
Generated at Thu Feb 08 10:08:58 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.