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

versioning.truncate_privilege : GRANT fails with "Access denied", for root user

    XMLWordPrintable

Details

    Description

      To reproduce, run versioning.truncate_privilege after main.mysql_upgrade_noengine, like this

      perl mysql-test-run.pl --no-reorder main.mysql_upgrade_noengine versioning.truncate_privilege

      main.mysql_upgrade_noengine 'innodb'     [ pass ]   7889
      versioning.truncate_privilege 'innodb'   [ fail ]
              Test ended at 2020-03-25 22:34:42
       
      CURRENT_TEST: versioning.truncate_privilege
      mysqltest: At line 37: query 'grant all on *.* to mysqltest_1@localhost' failed: 1045: Access denied for user 'root'@'localhost' (using password: NO)
       
      The result from queries just before the failure was:
      < snip >
      connection root;
      create table mysqltest.t (a int) with system versioning;
      

      See also
      http://buildbot.askmonty.org/buildbot/builders/win32-debug/builds/16679/steps/test/logs/stdio
      http://buildbot.askmonty.org/buildbot/builders/winx64-debug/builds/18261/steps/test/logs/stdio

      If I revert 19e998d20c2b209305057fddb8fddf243d4f0619 ( MDEV-22030), everything this fixes it.

      Attachments

        Issue Links

          Activity

            People

              bar Alexander Barkov
              wlad Vladislav Vaintroub
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.