Uploaded image for project: 'MariaDB MaxScale'
  1. MariaDB MaxScale
  2. MXS-3677

The GTID of Galera Nodes is not displayed by maxctrl server list | maxscale 2.5.13

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Not a Bug
    • 2.5.13
    • N/A
    • galeramon
    • None
    • CentOS Linux release 7.7.1908 (Core)
      MariaDB server - 10.5.10 (ES)

    Description

      I have installed 2 node galera cluster along with maxscale. If i run "maxctrl list servers" command It's showing only server1 GTID not other server.

      [root@ip-172-31-12-219 centos]# maxctrl list servers
      ┌─────────┬──────────────┬──────┬─────────────┬─────────────────────────┬────────┐
      │ Server │ Address │ Port │ Connections │ State │ GTID │
      ├─────────┼──────────────┼──────┼─────────────┼─────────────────────────┼────────┤
      │ server1 │ 18.207.3.40 │ 3333 │ 0 │ Master, Synced, Running │ 1-1-15 │
      ├─────────┼──────────────┼──────┼─────────────┼─────────────────────────┼────────┤
      │ server2 │ 54.237.3.158 │ 3333 │ 0 │ Slave, Synced, Running │ │
      └─────────┴──────────────┴──────┴─────────────┴─────────────────────────┴────────┘

      If I stopped the mariadb service on server1. Now server2 is promoted as a master and performed some writes on server2.

      MariaDB [test]> create table t1 (id int,name varchar(20));
      Query OK, 0 rows affected (0.010 sec)

      MariaDB [test]> insert into t1 values(1,'kjsdlad');
      Query OK, 1 row affected (0.002 sec)

      MariaDB [test]> insert into t1 values(2,'mmznb');
      Query OK, 1 row affected (0.001 sec)

      MariaDB [test]> insert into t1 values(3,'rock');
      Query OK, 1 row affected (0.002 sec)

      MariaDB [test]> insert into t1 values(4,'khlcsk');
      Query OK, 1 row affected (0.002 sec)

      MariaDB [test]> insert into t1 values(5,'lcsk');
      Query OK, 1 row affected (0.004 sec)

      In maxscale it's not showing any GTID on server2. Why this behaviour ?

      [root@ip-172-31-12-219 centos]# maxctrl list servers
      ┌─────────┬──────────────┬──────┬─────────────┬─────────────────────────┬──────┐
      │ Server │ Address │ Port │ Connections │ State │ GTID │
      ├─────────┼──────────────┼──────┼─────────────┼─────────────────────────┼──────┤
      │ server1 │ 18.207.3.40 │ 3333 │ 0 │ Down │ │
      ├─────────┼──────────────┼──────┼─────────────┼─────────────────────────┼──────┤
      │ server2 │ 54.237.3.158 │ 3333 │ 0 │ Master, Synced, Running │ │
      └─────────┴──────────────┴──────┴─────────────┴─────────────────────────┴──────┘

      Here I have attached my maxscale config for your reference please check it.

      Attachments

        Activity

          ponsuresh.pandians Pon Suresh Pandian (Inactive) created issue -
          ponsuresh.pandians Pon Suresh Pandian (Inactive) made changes -
          Field Original Value New Value
          Summary The GTID of Galera Nodes is not displayed by maxctrl server list The GTID of Galera Nodes is not displayed by maxctrl server list | maxscale 2.5.13
          markus makela markus makela added a comment -

          Looking at the source code the value is from the following query:

          SELECT @@gtid_current_pos, @@gtid_binlog_pos, @@read_only, @@server_id;
          

          What does it return on your servers?

          markus makela markus makela added a comment - Looking at the source code the value is from the following query: SELECT @@gtid_current_pos, @@gtid_binlog_pos, @@read_only, @@server_id; What does it return on your servers?

          Hi markus,

          Here i have mentioned the output please check it.

          Server1 :
          ---------

          MariaDB [(none)]> SELECT @@gtid_current_pos, @@gtid_binlog_pos, @@read_only, @@server_id;
          -----------------------------------------------------------+

          @@gtid_current_pos @@gtid_binlog_pos @@read_only @@server_id

          -----------------------------------------------------------+

          1-1-20 1-1-20 0 1

          -----------------------------------------------------------+
          1 row in set (0.000 sec)

          Server2 :
          --------

          MariaDB [(none)]> SELECT @@gtid_current_pos, @@gtid_binlog_pos, @@read_only, @@server_id;
          -----------------------------------------------------------+

          @@gtid_current_pos @@gtid_binlog_pos @@read_only @@server_id

          -----------------------------------------------------------+

            1-1-20 0 3

          -----------------------------------------------------------+
          1 row in set (0.000 sec)

          ponsuresh.pandians Pon Suresh Pandian (Inactive) added a comment - - edited Hi markus, Here i have mentioned the output please check it. Server1 : --------- MariaDB [(none)] > SELECT @@gtid_current_pos, @@gtid_binlog_pos, @@read_only, @@server_id; ------------------- ----------------- ----------- ------------+ @@gtid_current_pos @@gtid_binlog_pos @@read_only @@server_id ------------------- ----------------- ----------- ------------+ 1-1-20 1-1-20 0 1 ------------------- ----------------- ----------- ------------+ 1 row in set (0.000 sec) Server2 : -------- MariaDB [(none)] > SELECT @@gtid_current_pos, @@gtid_binlog_pos, @@read_only, @@server_id; ------------------- ----------------- ----------- ------------+ @@gtid_current_pos @@gtid_binlog_pos @@read_only @@server_id ------------------- ----------------- ----------- ------------+   1-1-20 0 3 ------------------- ----------------- ----------- ------------+ 1 row in set (0.000 sec)
          markus makela markus makela added a comment -

          I think the lack of @@gtid_current_pos is the reason why it doesn't show the GTID position.

          markus makela markus makela added a comment - I think the lack of @@gtid_current_pos is the reason why it doesn't show the GTID position.

          Hi markus,

          I am not sure exactly ,so I created a new Jira to engineering team. Waiting for their reply.

          ponsuresh.pandians Pon Suresh Pandian (Inactive) added a comment - Hi markus, I am not sure exactly ,so I created a new Jira to engineering team. Waiting for their reply.
          markus makela markus makela added a comment -

          What version of MariaDB are you using? I think this behavior might change if you use Galera from 10.6 with the GTID improvements it has.

          markus makela markus makela added a comment - What version of MariaDB are you using? I think this behavior might change if you use Galera from 10.6 with the GTID improvements it has.

          Hi Markus,

          I tried with MariaDB server - 10.5.10 (ES)

          ponsuresh.pandians Pon Suresh Pandian (Inactive) added a comment - Hi Markus, I tried with MariaDB server - 10.5.10 (ES)
          markus makela markus makela made changes -
          Environment CentOS Linux release 7.7.1908 (Core) CentOS Linux release 7.7.1908 (Core)
          MariaDB server - 10.5.10 (ES)
          markus makela markus makela added a comment -

          I'll close this as Not a Bug since this seems to be related to Galera not updating the value of the current GTID. MaxScale correctly shows the GTID for all the nodes that have one and only the ones that don't have aren't showing it.

          markus makela markus makela added a comment - I'll close this as Not a Bug since this seems to be related to Galera not updating the value of the current GTID. MaxScale correctly shows the GTID for all the nodes that have one and only the ones that don't have aren't showing it.
          markus makela markus makela made changes -
          Fix Version/s N/A [ 22001 ]
          Resolution Not a Bug [ 6 ]
          Status Open [ 1 ] Closed [ 6 ]
          serg Sergei Golubchik made changes -
          Workflow MariaDB v3 [ 123559 ] MariaDB v4 [ 139274 ]
          mariadb-jira-automation Jira Automation (IT) made changes -
          Zendesk Related Tickets 199853

          People

            Unassigned Unassigned
            ponsuresh.pandians Pon Suresh Pandian (Inactive)
            Votes:
            1 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.