Uploaded image for project: 'Percona XtraDB Cluster'
  1. Percona XtraDB Cluster
  2. PXC-1753

LP #1380747: SST on IPv6 fails for xtrabackup-v2

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Done
    • Priority: Low
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None

      Description

      **Reported in Launchpad by Mario Splivalo last update 22-09-2016 10:51:08

      I have three nodes configured on a ipv4+ipv6 mixed network. Both of my nodes have ipv4 and ipv6 addresses, however I have configured percona to use only ipv6. I am able to connect to 3306 port from/to each of the machines using only ipv6.

      Due to issues with having IPv6 addresses in the configuration file I added the hostnames of the participating nodes in /etc/hosts file, with accompanying IPv6 addresses so that I'm sure that all the traffic goes over IPv6.

      However, joiners can't receive data from donor because 'socat' on joiner is only listeninig on ipv4:

      mysql 20553 20394 0 18:17 pts/1 00:00:00 socat -u TCP-LISTEN:4444,reuseaddr stdio

      If, using the hostname, I try to connect, from donnor node to joiner node, I can't connect:

      root@machine-1:/var/lib/mysql# telnet machine-2 4444
      Trying 2001:db8:1:0:f816:3eff:fea4:2dd8...
      telnet: Unable to connect to remote host: Connection refused

      When I use ipv4 address, all is good:

      root@machine-1:/var/lib/mysql# host machine-2
      machine-2.openstacklocal has address 10.5.19.139
      root@machine-1:/var/lib/mysql# telnet 10.5.19.139 4444
      Trying 10.5.19.139...
      Connected to 10.5.19.139.
      Escape character is '^]'.

      Of course, when I force socat to use TCP6-LISTEN (by hacking into the /usr/bin/wsrep_sst_xtrabackup-v2) SST finishes fine.

      (As a workaround, when using rsync as a wsrep_sst_method, I am able to complete the SST, regardless of the issue mentioned in bug #1315528).

        Smart Checklist

          Attachments

            Activity

              People

              • Assignee:
                krunal.bauskar Krunal Bauskar
                Reporter:
                lpjirasync lpjirasync (Inactive)
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated: