I have facing node2 and node3 is wont starting but node1 is running

1

[Galera] Failed to prepare for incremental state transfer: Failed to open IST listener at tcp://20.212.201.14:4568’, asio error ‘Failed to listen: bind: Cannot assign requested address: 99 (Cannot assign requested address)
at galerautils/src/gu_asio_stream_react.cpp:listen():788’: 99 (Cannot assign requested address)
at galera/src/ist.cpp:prepare():349. IST will be unavailable.

[Galera] GCache history reset: ddd869f1-044f-11ee-8d63-0311dc43e2f4:0 → ddd869f1-044f-11ee-8d63-0311dc43e2f4:77
2023-06-09T04:35:50.292244Z 0 [Warning] [MY-000000] [Galera] 0.0 (dev-pxc-cluster-node-1): State transfer to 1.0 (dev-pxc-cluster-node-2) failed: -42 (No message of desired type)
2023-06-09T04:35:50.292276Z 0 [ERROR] [MY-000000] [Galera] gcs/src/gcs_group.cpp:gcs_group_handle_join_msg():1216: Will never receive state. Need to abort.

i want to clarify what errors is coming

2

Welcome to Percona Forums @Santhosh_Pandi,

I read this error and I wonder if you have your ports open or firewall blocking it?

Failed to open IST listener at tcp://20.212.201.14:4568’, asio error ‘Failed to listen: bind: Cannot assign requested address: 99 (Cannot assign requested address)

Refer to this document:

Thanks,
K.

3

it has mentioned IP is change it my own ip’s or it is not changed ip’s some doubt

iptables --append INPUT --in-interface eth0 \

–protocol tcp --match tcp --dport 3306
–source 192.168.0.1/24 --jump ACCEPT

iptables --append INPUT --in-interface eth0 \

–protocol tcp --match tcp --dport 4444
–source 192.168.0.1/24 --jump ACCEPT

iptables --append INPUT --in-interface eth0 \

–protocol tcp --match tcp --dport 4567
–source 192.168.0.1/24 --jump ACCEPT

iptables --append INPUT --in-interface eth0 \

–protocol tcp --match tcp --dport 4568
–source 192.168.0.1/24 --jump ACCEPT

iptables --append INPUT --in-interface eth0 \

–protocol udp --match udp --dport 4567
–source 192.168.0.1/24 --jump ACCEPT

4

I didn’t understand clearly what you wrote there… but I meant to check if the ports are open and or they’re blocked.
You can check it by telnet IP port
Also the instructions are in place just take your time to go through:
To enable packet filtering, run the commands as root on each Percona XtraDB Cluster node.

Thanks,
K

5

telnet 20.212.201.14 4568
Trying 20.212.201.14…
telnet: Unable to connect to remote host: Connection refused
telnet 20.212.201.14 4567 is up and give response it is fine

This is an issue but port’s are opend and percona xtradb cluster is running ,

Thank you

6

I am in the same boat, facing exactly this same issue.