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

Ordering of mysql_upgrade tasks is not optimal

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 10.0.12
    • Fix Version/s: 10.0.13
    • Component/s: None
    • Labels:
      None

      Description

      When upgrading MariaDB 5.5.31 to MariaDB 10.0.12, because of the order that mysql_upgrade performs the upgrade of the 'mysql' tables, one can see many errors like the following:

      2014-08-05 13:22:49 7ec848562700 InnoDB: Error: Fetch of persistent statistics requested for table "dbname"."table1" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead.
      2014-08-05 13:22:49 7ec848562700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
      ...

      It does this for each and every table being checked.

      MySQL/Oracle supposedly fixed this in their mysqlcheck/mysql_upgrade:

      http://bugs.mysql.com/bug.php?id=68163

      However, I am unable to run mysql_upgrade with the --skip-database option without receiving an error. I've added the "loose" prefix as well, but it doesn't seem to change anything.

        Attachments

          Activity

            People

            • Assignee:
              serg Sergei Golubchik
              Reporter:
              ccalender Chris Calender
            • Votes:
              1 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: