[MY-000000] [Galera] failed to open gcomm backend connection: 110

MySQL & MariaDB Percona XtraDB Cluster 8.x
1

Please help me to solution of below logs:

2024-03-18T15:25:59.756996+01:00 0 [ERROR] [MY-000000] [Galera] failed to open gcomm backend connection: 110: failed to reach primary view (pc.wait_prim_timeout): 110 (Connection timed out)
at gcomm/src/pc.cpp:connect():161
2024-03-18T15:25:59.757011+01:00 0 [ERROR] [MY-000000] [Galera] gcs/src/gcs_core.cpp:gcs_core_open():219: Failed to open backend connection: -110 (Connection timed out)
2024-03-18T15:26:00.757287+01:00 0 [Note] [MY-000000] [Galera] gcomm: terminating thread
2024-03-18T15:26:00.757337+01:00 0 [Note] [MY-000000] [Galera] gcomm: joining thread
2024-03-18T15:26:00.757481+01:00 0 [ERROR] [MY-000000] [Galera] gcs/src/gcs.cpp:gcs_open():1811: Failed to open channel ‘kpn-zsmart-secint’ at ‘gcomm://10.150.53.2’: -110 (Connection timed out)
2024-03-18T15:26:00.757495+01:00 0 [ERROR] [MY-000000] [Galera] gcs connect failed: Connection timed out
2024-03-18T15:26:00.757505+01:00 0 [ERROR] [MY-000000] [WSREP] Provider/Node (gcomm://10.150.53.2) failed to establish connection with cluster (reason: 7)
2024-03-18T15:26:00.757514+01:00 0 [ERROR] [MY-010119] [Server] Aborting
2024-03-18T15:26:00.757603+01:00 0 [Note] [MY-010120] [Server] Binlog end
2024-03-18T15:26:00.757778+01:00 0 [Note] [MY-010733] [Server] Shutting down plugin ‘daemon_keyring_proxy_plugin’
2024-03-18T15:26:00.758212+01:00 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.32-24.2) Percona XtraDB Cluster (GPL), Release rel24, Revision 2119e75, WSREP version 26.1.4.3.
2024-03-18T15:26:00.759166+01:00 0 [ERROR] [MY-010065] [Server] Failed to shutdown components infrastructure.

2

Hello Jay22,
Please make sure that connectivity and firewall rules are configured with respect to the requirements Install Percona XtraDB Cluster - Percona XtraDB Cluster

Regards,
Denis Subbota.
Managed Services, Percona.

1 Like
3

Hi Denis,
we already using the percona XtraDB cluster solutions.when the OS patching happens mysql services was already enabled for auto restart after reboot. But still service not started automatically.so we have to manually make the cluster down and needs to restart cluster.There are 2 nodes in cluster 1 is main and other is DR node.so when patching happens the DR node joins automatically but for main node we are facing the issue .its do not restart and whn we checked mysqld logs it shows only [Galera] failed to open gcomm backend connection: 110: failed to reac
h primary view (pc.wait_prim _timeout): 110 (Connection timed out)
[Galera] gcs/src/gcs.cpp:gcs_open( ):1811: Failed to open channel ‘kpn
-zsmart-prd8-cdr’ at ‘gcomm://x.x., x.x.’: -110 (Connection timed out)
[MY-000000] [Galera] gcs connect failed: Connection timed out
2024-11-26T07:11:48.041394+01:00 0 [ERROR] [MY-000000]
stablish connection with cluster (reason: 7)