# SST not working with xtrabackup-v2, only with rsync.  IPv6 issue ?

**URL:** <https://forums.percona.com/t/sst-not-working-with-xtrabackup-v2-only-with-rsync-ipv6-issue/6138>\
**Category:** Percona XtraDB Cluster 5.x\
**Created:** [January 19, 2018, 6:13am UTC](https://forums.percona.com/t/sst-not-working-with-xtrabackup-v2-only-with-rsync-ipv6-issue/6138 "2018-01-19T06:13:36Z")\
**Posts on this page:** 1\
**Showing post:** 4

<div class="post-metadata">

**Author:** ![marcio](https://avatars.discourse-cdn.com/v4/letter/m/f19dbf/32.png) [@marcio](https://forums.percona.com/u/marcio)\
**Post date:** [January 25, 2018, 10:56am UTC](https://forums.percona.com/t/sst-not-working-with-xtrabackup-v2-only-with-rsync-ipv6-issue/6138/4 "2018-01-25T10:56:49Z")

</div>

Hello.  
I have found two solutions and I’m using the 2nd.

1st solution - (not good, need edit the script):  
edit /usr/bin/wsrep\_sst\_xtrabackup-v2, line 532:  
replace  
tcmd=“socat -u TCP-LISTEN:${TSST\_PORT},reuseaddr${sockopt} stdio”  
to  
tcmd=“socat -u TCP6-LISTEN:${TSST\_PORT},reuseaddr${sockopt} stdio”

restart mysql and sst will work using xtrabackup-v2.

2nd solution: (good, edit the config file):  
before any changes, check joiner log:  
2018-01-25T15:23:38.623734Z WSREP\_SST: [DEBUG] The xtrabackup version is 2.4.9  
2018-01-25T15:23:38.941069Z WSREP\_SST: [DEBUG] Streaming with xbstream  
2018-01-25T15:23:38.942338Z WSREP\_SST: [DEBUG] Using socat as streamer  
2018-01-25T15:23:39.006472Z WSREP\_SST: [DEBUG] Evaluating timeout -k 110 100 socat -u TCP-LISTEN:4444,reuseaddr,retry=30 stdio | pv -f -i 10 -N joiner -F ‘%N =\> Rate:%r Avg:%a Elapsed:%t %e Bytes: %b %p’ | xbstream $xbstreameopts -x; RC=( ${PIPESTATUS[@]} )

edit my.cnf and add parameter:  
[sst]  
sockopt=“pf=ip6”

save the file, restart mysql and sst will work using xtrabackup-v2.

after restart I see in joiner log:  
2018-01-25T15:25:42.423590Z WSREP\_SST: [DEBUG] The xtrabackup version is 2.4.9  
2018-01-25T15:25:42.767761Z WSREP\_SST: [DEBUG] Streaming with xbstream  
2018-01-25T15:25:42.769007Z WSREP\_SST: [DEBUG] Using socat as streamer  
2018-01-25T15:25:42.836480Z WSREP\_SST: [DEBUG] Evaluating timeout -k 110 100 socat -u TCP-LISTEN:4444,reuseaddr,pf=ip6,retry=30 stdio | pv -f -i 10 -N joiner -F ‘%N =\> Rate:%r Avg:%a Elapsed:%t %e Bytes: %b %p’ | xbstream $xbstreameopts -x; RC=( ${PIPESTATUS[@]} )

I found this parameter in socat docs, but nothing in the xtrabackup docs.  
I believe socat is only accepting IPv4 connections by default, after adding the parameter sockopt=“pf=ip6” all works fine.  
Now, I can stop mysql, erase the data folder and sst transfer all data from any donor.

If this solution is okay for the community, I will mark it as solved.  
BR

---

_[View the full topic](https://forums.percona.com/t/sst-not-working-with-xtrabackup-v2-only-with-rsync-ipv6-issue/6138)._