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

wsrep_incoming_addresses in show global status lies about addresses in use

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Won't Fix
    • 10.2.14
    • N/A
    • Galera
    • None

    Description

      We have noticed that the variable wsrep_incoming_addresses from show global status does not reflect the actual addresses used for WSREP communication if more than one interface is available. Please see below.

      [root@customer skysql]# netstat -an | grep 4567
      tcp        0      0 0.0.0.0:4567            0.0.0.0:*               LISTEN     
      tcp        0      0 192.168.108.134:4567    192.168.108.136:52164   ESTABLISHED
      tcp        0      0 192.168.108.134:4567    192.168.108.135:44298   ESTABLISHED
       
      [root@customer skysql]# mysql -e "show global status like 'wsrep_incoming_addresses'"
      +--------------------------+----------------------------------------------------------------+
      | Variable_name            | Value                                                          |
      +--------------------------+----------------------------------------------------------------+
      | wsrep_incoming_addresses | 192.168.102.207:3306,192.168.102.208:3306,192.168.102.209:3306 |
      +--------------------------+----------------------------------------------------------------+
      
      

      Attachments

        Activity

          People

            jplindst Jan Lindström (Inactive)
            rpizzi Rick Pizzi
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.