WSREP: State transfer request failed unrecoverably: 113 (No route to host)

MySQL & MariaDB Percona XtraDB Cluster 5.x
1

I am using Percona XtraDB Cluster 5.5.34-25.9. When I set the wsrep_sst_donor using CNAME(mymisc2db2.db.stratus.com) instead of hostname, it failed to state transfer with the error

140505 15:13:35 [ERROR] WSREP: Requesting state transfer failed: -113(No route to host)
140505 15:13:35 [ERROR] WSREP: State transfer request failed unrecoverably: 113 (No route to host). Most likely it is due to inability to communicate with the cluster primary component. Restart required.

If I change the host name(slc4b01c-713813.stratus.slc.com) instead, it works well .

nslookup slc4b01c-713813.stratus.slc.com
Server: 10.102.157.115
Address: 10.102.157.115#53

Name: slc4b01c-713813.stratus.slc.com
Address: 10.94.68.15

nslookup mymisc2db2.db.stratus.com
Server: 10.102.157.115
Address: 10.102.157.115#53

mymisc2db2.db.stratus.com canonical name = slc4b01c-713813.stratus.slc.com.
Name: slc4b01c-713813.stratus.slc.com
Address: 10.94.68.15

Can someone help check why I can’t use canonical name as wsrep_sst_donor? How can I troubleshooting this?
Thanks for your help in advance.

Thanks
Shenglin

2

Hey there,

No cname and ips are working there.
You need to specify wsrep_node_name of the donor node;
For example if Server: 10.102.157.115 holding wsrep_node_name = “mymisc2db2”
in order to use this node as donor one you need to specify in config file on the new PXC node

wsrep_sst_donor=mymisc2db2

Regards,
Denis Subbota.
Managed Services, Percona.

1 Like