Node2 did not connect in node1

MySQL & MariaDB Percona XtraDB Cluster 5.x
1

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

any one help me

2

Please provide your my.cnf. It looks like you have misconfigured your wsrep_* parameters and MySQL cannot bind to the interface/IP you have specified

3

it is my.cnf config

[mysqld]

datadir=/var/lib/mysql
user=mysql
log_error=/var/log/mysql/error.log
socket=/var/lib/mysql/mysql.sock
pid_file=/var/run/mysqld/mysqld.pid
# Path to Galera library
wsrep_provider=/usr/lib/libgalera_smm.so

# Cluster connection URL contains the IPs of node#1, node#2 and node#3
wsrep_cluster_address=gcomm://20.212.157.189,20.212.201.14,20.164.218.83

# In order for Galera to work correctly binlog format should be ROW
binlog_format=ROW
pxc_strict_mode=ENFORCING
# Using the MyISAM storage engine is not recommended
default_storage_engine=InnoDB

# This InnoDB autoincrement locking mode is a requirement for Galera
innodb_autoinc_lock_mode=2

# Node #1 address
wsrep_node_address=20.212.157.189
pxc-encrypt-cluster-traffic=OFF
# SST method
wsrep_sst_method=xtrabackup-v2

# Cluster name
wsrep_cluster_name=my_ubuntu_cluster

some error it throws node2 was ([Warning] [MY-000000] [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.
) and again one error was failed: -42 (No message of desired type)
2023-06-13T04:39:03.964583Z 0 [ERROR] [MY-000000] [Galera] gcs/src/gcs_group.cpp:gcs_group_handle_join_msg():1216: Will never receive state. Need to abort.

4

Ensure this is the correct IP for node1 (Use ip a to check local interfaces). Check the same setting on node2’s my.cnf and ensure the IP matches that of node2. Ensure there are no firewalls between these nodes. Ports 3306, 4444, 4567, 4568 must be allowed.

5

Hi Mathew,

     Hope you doing well,

     we are using azure cloud server and we are using both private and public IP which IP should use for percona configuration.

        Above mentioned IP is public ip  and above all ports are allowed by firewall.All three nodes are same in  my.cnf .
        Is private ip want to use for configuration.?
6

You should not be using public IPs without firewall. I can access your systems:

# ssh 20.212.157.189
The authenticity of host '20.212.157.189 (20.212.157.189)' can't be established.
...
Warning: Permanently added '20.212.157.189' (ED25519) to the list of known hosts.
root@20.212.157.189's password:

Remove your public IPs or create firewalls to restrict access to specific IPs.

For MySQL node address, you should be using private IPs.

7

Greetings,
i have changed the private IP is wrep_node_address but i got sst errors

[ERROR] [MY-000000] [WSREP-SST] ******************* FATAL ERROR **********************
2023-06-14T04:58:06.779562Z 0 [ERROR] [MY-000000] [WSREP-SST] Possible timeout in receving first data from donor in gtid/keyring stage
2023-06-14T04:58:06.779585Z 0 [ERROR] [MY-000000] [WSREP-SST] Line 1381
2023-06-14T04:58:06.779602Z 0 [ERROR] [MY-000000] [WSREP-SST] ******************************************************
2023-06-14T04:58:06.779893Z 0 [ERROR] [MY-000000] [WSREP-SST] Cleanup after exit with status:32
2023-06-14T04:58:06.796608Z 0 [ERROR] [MY-000000] [WSREP] Process completed with error: wsrep_sst_xtrabackup-v2 --role ‘joiner’ --address ‘10.15.0.4’ --datadir ‘/var/lib/mysql/’ --basedir ‘/usr/’ --plugindir ‘/usr/lib/mysql/plugin/’ --defaults-file ‘/etc/mysql/my.cnf’ --defaults-group-suffix ‘’ --parent ‘2140921’ --mysqld-version ‘8.0.32-24.2’ ‘’ : 32 (Broken pipe)
2023-06-14T04:58:06.796696Z 0 [ERROR] [MY-000000] [WSREP] Failed to read uuid:seqno from joiner script.
2023-06-14T04:58:06.796719Z 0 [ERROR] [MY-000000] [WSREP] SST script aborted with error 32 (Broken pipe)
2023-06-14T04:58:06.796900Z 3 [Note] [MY-000000] [Galera] Processing SST received
2023-06-14T04:58:06.796949Z 3 [Note] [MY-000000] [Galera] SST request was cancelled
2023-06-14T04:58:06.796995Z 3 [ERROR] [MY-000000] [Galera] State transfer request failed unrecoverably: 32 (Broken pipe). Most likely it is due to inability to communicate with the cluster primary component. Restart required.

8

As I said above, “Ports 3306, 4444, 4567, 4568 must be allowed” Please test each port using socat or nc and verify connectivity to all nodes with all ports.

9

Thank you matthewb all if its ok replication succes but i have login in mysql it shows error ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2)

10

Try logging in via TCP/IP mysql -h 127.0.0.1 If that works, then your socket default setting in my.cnf is not correct.

11

yeah everything fine thank you