Failed to start mysql when adding node2 to my percona xtradb cluster 5.7

MySQL & MariaDB Percona XtraDB Cluster 5.x
1

Here is the error code

2023-03-31T08:37:20.941593Z 0 [Warning] WSREP: error while trying to listen ‘tcp://0.0.0.0:4567?socket.non_blocking=1’, asio error ‘bind: Address already in use’
2023-03-31T08:37:20.941822Z 0 [ERROR] WSREP: failed to open gcomm backend connection: 98: error while trying to listen ‘tcp://0.0.0.0:4567?socket.non_blocking=1’, asio error ‘bind: Address already in use’: 98 (Address already in use)
at gcomm/src/asio_tcp.cpp:listen():937
2023-03-31T08:37:20.942025Z 0 [ERROR] WSREP: gcs/src/gcs_core.cpp:gcs_core_open():208: Failed to open backend connection: -98 (Address already in use)
2023-03-31T08:37:20.942213Z 0 [Note] WSREP: gcomm: terminating thread
2023-03-31T08:37:20.942476Z 0 [Note] WSREP: gcomm: joining thread
2023-03-31T08:37:20.942733Z 0 [ERROR] WSREP: gcs/src/gcs.cpp:gcs_open():1577: Failed to open channel ‘pxc-cluster’ at ‘gcomm://10.16.47.28,10.16.49.86’: -98 (Address already in use)
2023-03-31T08:37:20.942937Z 0 [ERROR] WSREP: gcs connect failed: Address already in use
2023-03-31T08:37:20.943123Z 0 [ERROR] WSREP: Provider/Node (gcomm://10.16.47.28,10.16.49.86) failed to establish connection with cluster (reason: 7)
2023-03-31T08:37:20.943283Z 0 [ERROR] Aborting

2

Something is already listening on port 4567 on your machine which is stopping Galera from binding to that port. Are you trying to run more than one node on a single server/OS?

You can try and track down the process that is currently listening on port 4567 by running

netstat -lnp | grep 4567
3

It would be either the port is in use by another process, or that the node is already running and you’re trying to start it again

1 Like