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

          Ascending order - Click to sort in descending order
          darkain Vincent Milum Jr created issue -
          elenst Elena Stepanova made changes -
          Field Original Value New Value
          Assignee Jan Lindström [ jplindst ]
          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.

          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.
          elenst Elena Stepanova made changes -
          Fix Version/s 10.4 [ 22408 ]
          Affects Version/s 10.4 [ 22408 ]
          serg Sergei Golubchik made changes -
          Workflow MariaDB v3 [ 103029 ] MariaDB v4 [ 141727 ]
          janlindstrom Jan Lindström made changes -
          Assignee Jan Lindström [ jplindst ] Jan Lindström [ JIRAUSER53125 ]
          janlindstrom Jan Lindström made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          janlindstrom Jan Lindström added a comment -

          https://github.com/MariaDB/server/pull/2613

          janlindstrom Jan Lindström added a comment - https://github.com/MariaDB/server/pull/2613
          janlindstrom Jan Lindström made changes -
          Assignee Jan Lindström [ JIRAUSER53125 ] Julius Goryavsky [ sysprg ]
          Status In Progress [ 3 ] In Review [ 10002 ]
          sysprg Julius Goryavsky made changes -
          Status In Review [ 10002 ] Stalled [ 10000 ]
          sysprg Julius Goryavsky made changes -
          Status Stalled [ 10000 ] In Progress [ 3 ]
          sysprg Julius Goryavsky added a comment -

          Fix merged with head revision: https://github.com/MariaDB/server/commit/956d6c4af9e353299cce6d2ccbd7c400a1d00d70

          sysprg Julius Goryavsky added a comment - Fix merged with head revision: https://github.com/MariaDB/server/commit/956d6c4af9e353299cce6d2ccbd7c400a1d00d70
          sysprg Julius Goryavsky made changes -
          issue.field.resolutiondate 2023-05-16 22:28:52.0 2023-05-16 22:28:52.969
          sysprg Julius Goryavsky made changes -
          Fix Version/s 11.0.2 [ 28706 ]
          Fix Version/s 10.4.30 [ 28912 ]
          Fix Version/s 10.5.21 [ 28913 ]
          Fix Version/s 10.6.14 [ 28914 ]
          Fix Version/s 10.9.7 [ 28916 ]
          Fix Version/s 10.10.5 [ 28917 ]
          Fix Version/s 10.11.4 [ 28918 ]
          Fix Version/s 10.4 [ 22408 ]
          Resolution Fixed [ 1 ]
          Status In Progress [ 3 ] Closed [ 6 ]
          dbart Daniel Bartholomew made changes -
          Fix Version/s 10.4.31 [ 29010 ]
          Fix Version/s 10.5.22 [ 29011 ]
          Fix Version/s 10.6.15 [ 29013 ]
          Fix Version/s 10.9.8 [ 29015 ]
          Fix Version/s 10.10.6 [ 29017 ]
          Fix Version/s 10.11.5 [ 29019 ]
          Fix Version/s 11.0.3 [ 28920 ]
          Fix Version/s 11.1.2 [ 28921 ]
          Fix Version/s 11.0.2 [ 28706 ]
          Fix Version/s 10.4.30 [ 28912 ]
          Fix Version/s 10.5.21 [ 28913 ]
          Fix Version/s 10.6.14 [ 28914 ]
          Fix Version/s 10.9.7 [ 28916 ]
          Fix Version/s 10.10.5 [ 28917 ]
          Fix Version/s 10.11.4 [ 28918 ]

          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.