Trying to install a Percona Xtradb Cluster 8.0 on three nodes with Docker.
The first node’s (the bootstrap node) container runs without any problem.
The second node’s container exits with the following error log:
2023-05-25T14:30:19.920088Z 2 [Warning] [MY-000000] [Galera] Failed to prepare for incremental state transfer: Failed to open IST listener at ssl://192.168.0.4: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.
2023-05-25T14:30:19.921602Z 0 [Note] [MY-000000] [Galera] Member 0.0 (dev-kube-auto-percona) requested state transfer from '*any*'. Selected 1.0 (dev-kube-auto-percona)(SYNCED) as donor.
2023-05-25T14:30:19.921678Z 0 [Note] [MY-000000] [Galera] Shifting PRIMARY -> JOINER (TO: 135)
2023-05-25T14:30:19.921865Z 2 [Note] [MY-000000] [Galera] Requesting state transfer: success, donor: 1
2023-05-25T14:30:19.921911Z 2 [Note] [MY-000000] [Galera] Resetting GCache seqno map due to different histories.
2023-05-25T14:30:19.922037Z 2 [Note] [MY-000000] [Galera] GCache history reset: e425874f-fae4-11ed-88ee-de0035b7c7a3:0 -> e425874f-fae4-11ed-88ee-de0035b7c7a3:135
2023-05-25T14:30:19.923787Z 0 [Warning] [MY-000000] [Galera] 1.0 (dev-kube-auto-percona): State transfer to 0.0 (dev-kube-auto-percona) failed: -42 (No message of desired type)
2023-05-25T14:30:19.923821Z 0 [ERROR] [MY-000000] [Galera] gcs/src/gcs_group.cpp:gcs_group_handle_join_msg():1216: Will never receive state. Need to abort.
2023-05-25T14:30:19.924015Z 0 [Note] [MY-000000] [Galera] gcomm: terminating thread
First node ip: 192.168.0.2
Second node ip: 192.168.0.4
No network connectivity issues between servers, no permission issues, no docker volume mount issues.
Here is the my.cnf config file:
[mysqld]
wsrep_node_address = "LOCAL_IP_ADDRESS_OF_THE_NODE"
wsrep_node_incoming_address = "LOCAL_IP_ADDRESS_OF_THE_NODE"
wsrep_provider_options="socket.ssl_key=/cert/server-key.pem;socket.ssl_cert=/cert/server-cert.pem;socket.ssl_ca=/cert/ca.pem"
ssl-ca = /cert/ca.pem
ssl-cert = /cert/server-cert.pem
ssl-key = /cert/server-key.pem
[client]
ssl-ca = /cert/ca.pem
ssl-cert = /cert/client-cert.pem
ssl-key = /cert/client-key.pem
[sst]
encrypt = 4
ssl-ca = /cert/ca.pem
ssl-cert = /cert/server-cert.pem
ssl-key = /cert/server-key.pem