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

Create role statement replicated inconsistently in Galera Cluster

    XMLWordPrintable

    Details

      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

            Activity

              People

              Assignee:
              nirbhay_c Nirbhay Choubey (Inactive)
              Reporter:
              przemek@mysqlmaniac.com Przemek
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: