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

              nirbhay_c Nirbhay Choubey (Inactive)
              przemek@mysqlmaniac.com Przemek
              Votes:
              0 Vote for this issue
              Watchers:
              1 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.