[MDEV-11772] roles.create_and_grant_role failed in buildbot Created: 2017-01-11  Updated: 2022-10-08  Resolved: 2022-10-08

Status: Closed
Project: MariaDB Server
Component/s: Tests
Affects Version/s: 10.0
Fix Version/s: N/A

Type: Bug Priority: Minor
Reporter: Elena Stepanova Assignee: Vicențiu Ciorbaru
Resolution: Cannot Reproduce Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-7069 Fix buildbot failures in main server ... Stalled

 Description   

http://buildbot.askmonty.org/buildbot/builders/kvm-deb-xenial-x86/builds/658/steps/test_4/logs/stdio

roles.create_and_grant_role              w1 [ fail ]
        Test ended at 2016-11-25 16:21:12
 
CURRENT_TEST: roles.create_and_grant_role
--- /usr/share/mysql/mysql-test/suite/roles/create_and_grant_role.result	2016-11-25 07:08:27.000000000 -0500
+++ /dev/shm/var/1/log/create_and_grant_role.reject	2016-11-25 16:21:12.392132977 -0500
@@ -16,6 +16,7 @@
 GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' WITH GRANT OPTION
 GRANT PROXY ON ''@'%' TO 'root'@'localhost' WITH GRANT OPTION
 GRANT USAGE ON *.* TO 'r1'
+GRANT foo   TO 'root'@'localhost' WITH ADMIN OPTION
 GRANT r1 TO 'root'@'localhost' WITH ADMIN OPTION
 drop role r1;
 select * from mysql.roles_mapping;
@@ -24,3 +25,4 @@
 Grants for root@localhost
 GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' WITH GRANT OPTION
 GRANT PROXY ON ''@'%' TO 'root'@'localhost' WITH GRANT OPTION
+GRANT foo   TO 'root'@'localhost' WITH ADMIN OPTION
 
mysqltest: Result length mismatch



 Comments   
Comment by Vicențiu Ciorbaru [ 2017-03-08 ]

This might be fixed by a related roles patch. Not sure which one but it is worth investigating.

Comment by Elena Stepanova [ 2022-10-08 ]

No recorded occurrences since 2016

Generated at Thu Feb 08 07:52:32 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.