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

The output of show WSREP_STATUS differs from select information_schema.WSREP_STATUS

    Details

    • Type: Bug
    • Status: In Progress (View Workflow)
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: 10.3.6
    • Fix Version/s: 10.3, 10.4
    • Component/s: Galera, Plugins
    • Labels:
      None
    • Environment:
      CentOS 7.4

      Description

      The output of show WSREP_STATUS differs from select information_schema.WSREP_STATUS

      note :there is not difference regarding the other WSREP_INFO table WSREP_MEMBERSHIP ; both commands 'show WSREP_INFO' and
      'select * from information_schema.WSREP_INFO ' return one and the same

      install WSREP_INFO plugin on Galera Nodes

      MariaDB [foo]> SHOW TABLES FROM information_schema LIKE 'WSREP%';
      Empty set (0.000 sec)
       
      MariaDB [foo]> INSTALL SONAME 'wsrep_info';
      Query OK, 0 rows affected (0.034 sec)
       
      MariaDB [foo]>  SHOW TABLES FROM information_schema LIKE 'WSREP%';
      +---------------------------------------+
      | Tables_in_information_schema (WSREP%) |
      +---------------------------------------+
      | WSREP_STATUS                          |
      | WSREP_MEMBERSHIP                      |
      +---------------------------------------+
      2 rows in set (0.000 sec)
      
      

      MariaDB [(none)]>  select * from information_schema.WSREP_STATUS \G
      *************************** 1. row ***************************
               NODE_INDEX: 1
              NODE_STATUS: Synced
           CLUSTER_STATUS: Primary
             CLUSTER_SIZE: 2
       CLUSTER_STATE_UUID: 3c15149f-5766-11e8-9a99-22bc53d40581
      CLUSTER_STATE_SEQNO: 26977
          CLUSTER_CONF_ID: 37
                      GAP: NO
         PROTOCOL_VERSION: 3
      1 row in set (0.000 sec)
      
      

      MariaDB [foo]> SHOW WSREP_STATUS \G
      *************************** 1. row ***************************
          Node_Index: 0
         Node_Status: Synced
      Cluster_Status: Primary
        Cluster_Size: 2
      1 row in set (0.000 sec)
      
      

      MariaDB [(none)]> SHOW GRANTS  ;
      +----------------------------------------------------------------------------------------------------------------------------------------+
      | Grants for root@localhost                                                                                                              |
      +----------------------------------------------------------------------------------------------------------------------------------------+
      | GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD '*E6CC90B878B948C35E92B003C792C46C58C4AF40' WITH GRANT OPTION |
      | GRANT PROXY ON ''@'%' TO 'root'@'localhost' WITH GRANT OPTION                                                                          |
      +----------------------------------------------------------------------------------------------------------------------------------------+
      2 rows in set (0.000 sec)
      
      

        Attachments

          Activity

            People

            • Assignee:
              sysprg Julius Goryavsky
              Reporter:
              winstone Zdravelina Sokolovska
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated: