Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.0.26-galera
-
None
Description
CREATE ROLE ... WITH ADMIN ... is replicated correctly in the cluster, but CREATE ROLE ... alone leaves the secondary nodes with different results in mysql.roles_mapping, information_schema.APPLICABLE_ROLES, show grants, etc.
Example:
node1 {root} ((none)) > select @@version,@@version_comment; |
+--------------------------------+-------------------------------------------------------+ |
| @@version | @@version_comment |
|
+--------------------------------+-------------------------------------------------------+ |
| 10.0.26-MariaDB-1~wheezy-wsrep | mariadb.org binary distribution, wsrep_25.13.raf7f02e | |
+--------------------------------+-------------------------------------------------------+ |
1 row in set (0.00 sec) |
|
|
node1 {root} ((none)) > CREATE ROLE foo; |
Query OK, 0 rows affected (0.01 sec) |
|
|
node1 {root} ((none)) > SELECT * FROM mysql.roles_mapping; |
+-----------+------+------+--------------+ |
| Host | User | Role | Admin_option | |
+-----------+------+------+--------------+ |
| localhost | root | foo | Y |
|
+-----------+------+------+--------------+ |
1 row in set (0.00 sec) |
|
|
node1 {root} ((none)) > select * from information_schema.APPLICABLE_ROLES; |
+----------------+-----------+--------------+ |
| GRANTEE | ROLE_NAME | IS_GRANTABLE |
|
+----------------+-----------+--------------+ |
| root@localhost | foo | YES |
|
+----------------+-----------+--------------+ |
1 row in set (0.00 sec) |
|
|
-- second node in the same Galera cluster:
|
node2 {root} ((none)) > select @@version,@@version_comment; |
+--------------------------------+-------------------------------------------------------+ |
| @@version | @@version_comment |
|
+--------------------------------+-------------------------------------------------------+ |
| 10.0.26-MariaDB-1~wheezy-wsrep | mariadb.org binary distribution, wsrep_25.13.raf7f02e | |
+--------------------------------+-------------------------------------------------------+ |
1 row in set (0.00 sec) |
|
|
node2 {root} ((none)) > SELECT * FROM mysql.roles_mapping; |
+------+------+------+--------------+ |
| Host | User | Role | Admin_option | |
+------+------+------+--------------+ |
| | | foo | Y |
|
+------+------+------+--------------+ |
1 row in set (0.00 sec) |
|
|
node2 {root} ((none)) > select * from information_schema.APPLICABLE_ROLES; |
Empty set (0.00 sec) |
Attachments
Issue Links
- links to