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

myqsl_upgrade fails: mysql.innodb_index_stats not present

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Duplicate
    • 10.11.2
    • N/A
    • Upgrades
    • None

    Description

      [...}
      sys.x$waits_global_by_latency OK
      Phase 4/7: Running 'mysql_fix_privilege_tables'
      ERROR 1932 (42S02) at line 482: Table 'mysql.innodb_index_stats' doesn't exist in engine
      FATAL ERROR: Upgrade failed

      Attachments

        Issue Links

          Activity

            mokraemer Marc added a comment -

            maybe it would be a good idea, not to totally fail the update script, if some table is missing, if it is not really needed (in my case innodb is not used), but other update scripts fail.

            Or at least issue a help, how to solve such an issue.

            removing the file in mysql-dir solved the problem.

            mokraemer Marc added a comment - maybe it would be a good idea, not to totally fail the update script, if some table is missing, if it is not really needed (in my case innodb is not used), but other update scripts fail. Or at least issue a help, how to solve such an issue. removing the file in mysql-dir solved the problem.
            mokraemer Marc added a comment -

            It was 10.5.19 - but as you corrected the title, it would just be helpful to have some advice, or skip the failed table and continue with other updates, if possible.

            mokraemer Marc added a comment - It was 10.5.19 - but as you corrected the title, it would just be helpful to have some advice, or skip the failed table and continue with other updates, if possible.
            alice Alice Sherepa added a comment -

            Thank you! I will close this bug then, let's track it in MDEV-21651

            alice Alice Sherepa added a comment - Thank you! I will close this bug then, let's track it in MDEV-21651

            People

              Unassigned Unassigned
              mokraemer Marc
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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