Faced the same problem today. Seems like the default stream format was changed from tar to xbstream when doing xtrabackup SST. Because of this 5.5.31 sends tar and 5.5.33 expects xbstream format(and errors with invalid magic, which I believe is a binary header that identifies xbstream).
Good news is it can be configured: http://www.percona.com/doc/percona-x…ackup_sst.html
[sst]
streamfmt=tar
After this change, state transfer completes, however I got stuck just after state is transferred:
WSREP_SST: [INFO] Evaluating nc -dl 4444 | pv -f -i 10 -N joiner | tar xfi - ; RC=( ${PIPESTATUS[@]} ) (20130921 04:47:14.457)
Nothing happens on the donor and the joiner gets stuck. There are no errors. Perhaps it is because I switched from socat to nc (via my.cnf), now I am tring with socat.
Update:
Same happens with socat:
On joiner:
WSREP_SST: [INFO] Proceeding with SST (20130921 05:18:07.838)
WSREP_SST: [INFO] Cleaning the existing datadir (20130921 05:18:07.840)
removed /var/lib/mysql/data/ib_logfile0' removed
/var/lib/mysql/data/ib_logfile1’
removed `/var/lib/mysql/data/ibdata1’
WSREP_SST: [INFO] Evaluating socat -u TCP-LISTEN:4444,reuseaddr stdio | pv -f -i 10 -N joiner | tar xfi - ; RC=( ${PIPESTATUS[@]} ) (20130921 05:18:07.846)
130921 5:18:08 [Note] WSREP: 0 (XXXXXXXXXXX): State transfer to 4 (XXXXXXXXXXX) complete.
130921 5:18:08 [Note] WSREP: Member 0 (XXXXXXXXXXX) synced with group.
joiner: 0B 0:00:10 [ 0B/s ] [<=> ]
joiner: 0B 0:00:20 [ 0B/s ] [<=> ]
On donor:
130921 12:18:08 [Note] WSREP: Shifting DONOR/DESYNCED -> JOINED (TO: 408859845)
130921 12:18:08 [Note] WSREP: Member 0 (XXXXXXXXXXX) synced with group.
130921 12:18:08 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 408859850)
130921 12:18:08 [Note] WSREP: Synchronized with group, ready for connections
130921 12:18:08 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
Looks like joiner is waiting for data that donor is not sending.