Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.5.2
-
None
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
- is caused by
-
MDEV-22030 Don't grant REPLICATION MASTER ADMIN automatically on upgrade from an older JSON user table
- Closed