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

Failure when using mysql_upgrade if 'root'@'localhost' does not exist

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Fixed
    • 10.6.4
    • 10.6.6
    • Upgrades
    • None

    Description

      mysql> mysql_upgrade -u*** -p --socket=/tmp/mysql.sock1 --force -s
      Enter password:
      The --upgrade-system-tables option was used, user tables won't be touched.
      Phase 1/7: Checking and upgrading mysql database
      Processing databases
      mysql
      mysql.column_stats OK
      mysql.columns_priv OK
      ...
      mysql.transaction_registry OK
      Phase 2/7: Installing used storage engines... Skipped
      Phase 3/7: Fixing views... Skipped
      Phase 4/7: Running 'mysql_fix_privilege_tables'
      ERROR 1449 (HY000) at line 832: The user specified as a definer ('root'@'localhost') does not exist
      FATAL ERROR: Upgrade failed
      

      If you do not use "force", the upgrade runs, but then setting a new value in SYS_CONFIG gives an error:

      MariaDB [sys]> update sys_config set value = 128 where variable = 'statement_truncate_len';
      ERROR 1449 (HY000): The user specified as a definer ('root'@'localhost') does not exist
      

      Attachments

        Activity

          wlad, the reporter says the bug is still present in 10.6.5-2. Please, check if the bug is indeed fixed, and add a test case to make sure it won't re-appear in the future (no matter how and what we merge or rebase).

          serg Sergei Golubchik added a comment - wlad , the reporter says the bug is still present in 10.6.5-2. Please, check if the bug is indeed fixed, and add a test case to make sure it won't re-appear in the future (no matter how and what we merge or rebase).

          The bug is of course fixed. It did not made it into 10.6.5, so I'm fixing the "Fix version". It was possible to choose that in ""Fixed in" field, and 10.6.5 was not released, so I do not feel any guilt about that.

          wlad Vladislav Vaintroub added a comment - The bug is of course fixed. It did not made it into 10.6.5, so I'm fixing the "Fix version". It was possible to choose that in ""Fixed in" field, and 10.6.5 was not released, so I do not feel any guilt about that.

          People

            wlad Vladislav Vaintroub
            mpflaum Maria M Pflaum
            Votes:
            0 Vote for this issue
            Watchers:
            4 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.