Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-5913

cmapi write local address 127.0.1.1 instead real ip address

Details

    • Bug
    • Status: Confirmed (View Workflow)
    • Critical
    • Resolution: Unresolved
    • 23.10.3
    • None
    • cmapi
    • None
    • 2025-2

    Description

      cmapi writes on debian cluster 127.0.1.1 instead real address

      Example

       <ModuleIPAddr1-1-3>127.0.1.1</ModuleIPAddr1-1-3>
              <ModuleHostName1-1-3>dnsname</ModuleHostName1-1-3>
              
                  <ClusterManager>127.0.1.1</ClusterManager>
      

      root cause is an entry in /etc/hostnames, which will be written on default on debian

      Explanation:

      https://www.debian.org/doc/manuals/debian-reference/ch05.en.html#_the_hostname_resolution

      127.0.0.1 localhost
      127.0.1.1 host_name
      

      Test:

      Create file gethostid.py

      import sys, os
      import optparse
      import socket
      remoteServer = sys.argv[1]
      remoteServerIP = socket.gethostbyaddr(remoteServer)
      print (remoteServerIP)
      

      ~$ python gethostid.py hostname
      ('hostname', [], ['127.0.1.1'])
      

      on non-debian systems real IP will be provided

      Even it works , if the dns name will be locally used,
      but columnstore.xml will be copied from node1 to other nodes,
      so other nodes get a problem, if they use

      <ModuleIPAddr1-1-3>127.0.1.1</ModuleIPAddr1-1-3>
      

      for PM1 as an IP.

      So cmapi getting IP on debian systems in another way.

      Config
      /etc/hosts

      can be a workarround, but due the fact, that is the default debian configuration,
      it can be overwritten.

      Attachments

        Activity

          Richard Richard Stracke created issue -
          Richard Richard Stracke made changes -
          Field Original Value New Value
          Component/s cmapi [ 16117 ]
          Affects Version/s 23.10.3 [ 29862 ]
          Richard Richard Stracke made changes -
          Description On debian cluster in Columnstore write

          cmapi writes on debian cluster 127.0.1.1 instead real address

          Example
          {code:java}
           <ModuleIPAddr1-1-3>127.0.1.1</ModuleIPAddr1-1-3>
                  <ModuleHostName1-1-3>dnsname</ModuleHostName1-1-3>
                  
                      <ClusterManager>127.0.1.1</ClusterManager>
          {code}


          root cause is an entry in /etc/hostnames, which will be written on default on debian

          Explanation:

          https://www.debian.org/doc/manuals/debian-reference/ch05.en.html#_the_hostname_resolution


          {code:java}
          127.0.0.1 localhost
          127.0.1.1 host_name
          {code}

          Test:

          Create file gethostid.py


          {code:java}
          import sys, os
          import optparse
          import socket
          remoteServer = sys.argv[1]
          remoteServerIP = socket.gethostbyaddr(remoteServer)
          print (remoteServerIP)
          {code}


          {code:java}
          ~$ python gethostid.py hostname
          ('hostname', [], ['127.0.1.1'])
          {code}

          on non-debian systems real IP will be provided

          Even it works , if the dns name will be locally used,
          but columnstore.xml will be copied from node1 to other nodes,
          so other nodes get a problem, if they use


          {code:java}
          <ModuleIPAddr1-1-3>127.0.1.1</ModuleIPAddr1-1-3>
          {code}

          for PM1 as an IP.

          So cmapi getting IP on debian systems in another way.

          Config
          /etc/hosts

          can be a workarround, but due the fact, that is the default debian configuration,
          it can be overwritten.

          Richard Richard Stracke made changes -
          Comment [ cmapi writes on debian cluster 127.0.1.1 instead real address

          Example
          {code:java}
           <ModuleIPAddr1-1-3>127.0.1.1</ModuleIPAddr1-1-3>
                  <ModuleHostName1-1-3>dnsname</ModuleHostName1-1-3>
                  
                      <ClusterManager>127.0.1.1</ClusterManager>
          {code}


          root cause is an entry in /etc/hostnames, which will be written on default on debian

          Explanation:

          https://www.debian.org/doc/manuals/debian-reference/ch05.en.html#_the_hostname_resolution


          {code:java}
          127.0.0.1 localhost
          127.0.1.1 host_name
          {code}

          Test:

          Create file gethostid.py


          {code:java}
          import sys, os
          import optparse
          import socket
          remoteServer = sys.argv[1]
          remoteServerIP = socket.gethostbyaddr(remoteServer)
          print (remoteServerIP)
          {code}


          {code:java}
          ~$ python gethostid.py hostname
          ('hostname', [], ['127.0.1.1'])
          {code}

          on non-debian systems real IP will be provided

          Even it works , if the dns name will be locally used,
          but columnstore.xml will be copied from node1 to other nodes,
          so other nodes get a problem, if they use


          {code:java}
          <ModuleIPAddr1-1-3>127.0.1.1</ModuleIPAddr1-1-3>
          {code}

          for PM1 as an IP.

          So cmapi getting IP on debian systems in another way.

          Config
          /etc/hosts

          can be a workarround, but due the fact, that is the default debian configuration,
          it can be overwritten.

          ]
          julien.fritsch Julien Fritsch made changes -
          Priority Major [ 3 ] Blocker [ 1 ]
          julien.fritsch Julien Fritsch made changes -
          Assignee Leonid Fedorov [ JIRAUSER48443 ]

          julien.fritsch since Richard lowered S1 to S3, I believe we can lower priority from blocker

          leonid.fedorov Leonid Fedorov added a comment - julien.fritsch since Richard lowered S1 to S3, I believe we can lower priority from blocker
          leonid.fedorov Leonid Fedorov made changes -
          Assignee Leonid Fedorov [ JIRAUSER48443 ] Alan Mologorsky [ JIRAUSER49150 ]
          julien.fritsch Julien Fritsch made changes -
          Priority Blocker [ 1 ] Critical [ 2 ]
          allen.herrera Allen Herrera made changes -
          Sprint 2025-2 [ 788 ]
          julien.fritsch Julien Fritsch made changes -
          Status Open [ 1 ] Confirmed [ 10101 ]

          People

            alan.mologorsky Alan Mologorsky
            Richard Richard Stracke
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.