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

mariadb-upgrade does not detect upgraded needed

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.6.9
    • None
    • Server, Upgrades
    • None
    • Linux, n.a.

    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...

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              oli Oli Sennhauser
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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