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

Galera 4 unable to query cluster state if not primary component

Details

    Description

      select * from mysql.wsrep_cluster;
      ERROR 1047 (08S01): WSREP has not yet prepared node for application use
       
      select * from mysql.wsrep_cluster_members;
      ERROR 1047 (08S01): WSREP has not yet prepared node for application use
       
      select * from mysql.wsrep_streaming_log;
      Empty set (0.001 sec)
      

      For some reason, wsrep_streaming_log works (but is empty), but wsrep_cluster and wsrep_cluster_members both fail.

      For sysadmin purposes, it would be nice to have this information available

      Attachments

        Activity

          Just an FYI, the primary reason I need this.

          With Galera 4, wsrep_incoming_addresses shows "AUTO" now, and the only way to see (that I'm aware of) which nodes are connected is via these tables. When a network split occurs, I use the information about which nodes can still communicate with which other nodes to determiner course of action. It two nodes are broken off from the main cluster at the same time, I use the information of if they can still communicate with one-another while non-primary to determine which route should be taken to resolve the issue.

          darkain Vincent Milum Jr added a comment - Just an FYI, the primary reason I need this. With Galera 4, wsrep_incoming_addresses shows "AUTO" now, and the only way to see (that I'm aware of) which nodes are connected is via these tables. When a network split occurs, I use the information about which nodes can still communicate with which other nodes to determiner course of action. It two nodes are broken off from the main cluster at the same time, I use the information of if they can still communicate with one-another while non-primary to determine which route should be taken to resolve the issue.
          janlindstrom Jan Lindström added a comment - https://github.com/MariaDB/server/pull/2613
          sysprg Julius Goryavsky added a comment - Fix merged with head revision: https://github.com/MariaDB/server/commit/956d6c4af9e353299cce6d2ccbd7c400a1d00d70

          People

            sysprg Julius Goryavsky
            darkain Vincent Milum Jr
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.