# Percona xtradb cluster a node can't join server **URL:** https://forums.percona.com/t/percona-xtradb-cluster-a-node-cant-join-server/29305 **Category:** Uncategorized **Created:** [March 22, 2024, 9:05am UTC](https://forums.percona.com/t/percona-xtradb-cluster-a-node-cant-join-server/29305 "2024-03-22T09:05:13Z") **Posts on this page:** 1 **Page:** 1
### Author: ![Jay22](https://avatars.discourse-cdn.com/v4/letter/j/bb73d2/32.png) [@Jay22](https://forums.percona.com/u/Jay22) #### Post date: [March 22, 2024, 9:05am UTC](https://forums.percona.com/t/percona-xtradb-cluster-a-node-cant-join-server/29305/1 "2024-03-22T09:05:13Z")
I facing below error Please help me on this: 024-03-18T15:25:26.749137+01:00 0 [Note] [MY-000000] [Galera] Service thread queue flushed. 2024-03-18T15:25:26.749247+01:00 0 [Note] [MY-000000] [Galera] ####### Assign initial position for certification: 16ab83af-6413-11ee-a747-db1da5a3b98e:1258516, protocol version: -1 2024-03-18T15:25:26.749282+01:00 0 [Note] [MY-000000] [Galera] GCache history reset: 16ab83af-6413-11ee-a747-db1da5a3b98e:0 → 16ab83af-6413-11ee-a747-db1da5a3b98e:1258516 2024-03-18T15:25:26.749875+01:00 0 [Note] [MY-000000] [WSREP] Starting replication 2024-03-18T15:25:26.749891+01:00 0 [Note] [MY-000000] [Galera] Connecting with bootstrap option: 0 2024-03-18T15:25:26.749911+01:00 0 [Note] [MY-000000] [Galera] Setting GCS initial position to 16ab83af-6413-11ee-a747-db1da5a3b98e:1258516 2024-03-18T15:25:26.749997+01:00 0 [Note] [MY-000000] [Galera] protonet asio version 0 2024-03-18T15:25:26.750988+01:00 0 [Note] [MY-000000] [Galera] Using CRC-32C for message checksums. 2024-03-18T15:25:26.751013+01:00 0 [Note] [MY-000000] [Galera] backend: asio 2024-03-18T15:25:26.751082+01:00 0 [Note] [MY-000000] [Galera] gcomm thread scheduling priority set to other:0 2024-03-18T15:25:26.751225+01:00 0 [Note] [MY-000000] [Galera] Fail to access the file (/mysql/data//gvwstate.dat) error (No such file or directory). It is possible if node is booting for first time or re-booting after a graceful shutdown 2024-03-18T15:25:26.751251+01:00 0 [Note] [MY-000000] [Galera] Restoring primary-component from disk failed. Either node is booting for first time or re-booting after a graceful shutdown 2024-03-18T15:25:26.751501+01:00 0 [Note] [MY-000000] [Galera] GMCast version 0 2024-03-18T15:25:26.751622+01:00 0 [Note] [MY-000000] [Galera] (5d5cb26a-b70c, ‘ssl://0.0.0.0:4567’) listening at ssl://0.0.0.0:4567 2024-03-18T15:25:26.751632+01:00 0 [Note] [MY-000000] [Galera] (5d5cb26a-b70c, ‘ssl://0.0.0.0:4567’) multicast: , ttl: 1 2024-03-18T15:25:26.751935+01:00 0 [Note] [MY-000000] [Galera] EVS version 1 2024-03-18T15:25:26.752052+01:00 0 [Note] [MY-000000] [Galera] gcomm: connecting to group ‘kpn-zsmart-secint’, peer ‘10.150.53.2:’ 2024-03-18T15:25:26.756082+01:00 0 [Note] [MY-000000] [Galera] (5d5cb26a-b70c, ‘ssl://0.0.0.0:4567’) Found matching local endpoint for a connection, blacklisting address ssl://10.150.53.2:4567 2024-03-18T15:25:29.752965+01:00 0 [Note] [MY-000000] [Galera] announce period timed out (pc.announce\_timeout) 2024-03-18T15:25:29.753213+01:00 0 [Note] [MY-000000] [Galera] EVS version upgrade 0 → 1 2024-03-18T15:25:29.753252+01:00 0 [Note] [MY-000000] [Galera] PC protocol upgrade 0 → 1 2024-03-18T15:25:29.753329+01:00 0 [Warning] [MY-000000] [Galera] no nodes coming from prim view, prim not possible 2024-03-18T15:25:29.753358+01:00 0 [Note] [MY-000000] [Galera] Current view of cluster as seen by this node view (view\_id(NON\_PRIM,5d5cb26a-b70c,1) memb { 5d5cb26a-b70c,0 } joined { } left { } partitioned { } ) 2024-03-18T15:25:30.253460+01:00 0 [Warning] [MY-000000] [Galera] last inactive check more than PT1.5S (3\*evs.inactive\_check\_period) ago (PT3.50153S), skipping check 2024-03-18T15:25:59.756826+01:00 0 [Note] [MY-000000] [Galera] PC protocol downgrade 1 → 0 2024-03-18T15:25:59.756885+01:00 0 [Note] [MY-000000] [Galera] Current view of cluster as seen by this node view ((empty)) 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. 2024-03-18T15:26:00.759363+01:00 0 [Note] [MY-000000] [Galera] dtor state: CLOSED 2024-03-18T15:26:00.759392+01:00 0 [Note] [MY-000000] [Galera] MemPool(TrxHandleSlave): hit ratio: 0, misses: 0, in use: 0, in pool: 0 2024-03-18T15:26:00.761486+01:00 0 [Note] [MY-000000] [Galera] apply mon: entered 0 2024-03-18T15:26:00.763568+01:00 0 [Note] [MY-000000] [Galera] apply mon: entered 0 2024-03-18T15:26:00.766516+01:00 0 [Note] [MY-000000] [Galera] apply mon: entered 0 2024-03-18T15:26:00.766553+01:00 0 [Note] [MY-000000] [Galera] cert index usage at exit 0 2024-03-18T15:26:00.766560+01:00 0 [Note] [MY-000000] [Galera] cert trx map usage at exit 0 2024-03-18T15:26:00.766566+01:00 0 [Note] [MY-000000] [Galera] deps set usage at exit 0 2024-03-18T15:26:00.766576+01:00 0 [Note] [MY-000000] [Galera] avg deps dist 0 2024-03-18T15:26:00.766583+01:00 0 [Note] [MY-000000] [Galera] avg cert interval 0 2024-03-18T15:26:00.766589+01:00 0 [Note] [MY-000000] [Galera] cert index size 0 2024-03-18T15:26:00.766651+01:00 0 [Note] [MY-000000] [Galera] Service thread queue flushed. 2024-03-18T15:26:00.766704+01:00 0 [Note] [MY-000000] [Galera] wsdb trx map usage 0 conn query map usage 0 2024-03-18T15:26:00.766716+01:00 0 [Note] [MY-000000] [Galera] MemPool(LocalTrxHandle): hit ratio: 0, misses: 0, in use: 0, in pool: 0 2024-03-18T15:26:00.766814+01:00 0 [Note] [MY-000000] [Galera] Shifting CLOSED → DESTROYED (TO: 0) 2024-03-18T15:26:00.767403+01:00 0 [Note] [MY-000000] [Galera] Flushing memory map to disk… INFO: Skipping wsrep-recover for 16ab83af-6413-11ee-a747-db1da5a3b98e:1258516 pair INFO: Assigning 16ab83af-6413-11ee-a747-db1da5a3b98e:1258516 to wsrep\_start\_position 2024-03-18T15:29:26.031215+01:00 0 [Warning] [MY-010139] [Server] Changed limits: max\_open\_files: 16364 (requested 101010) 2024-03-18T15:29:26.031222+01:00 0 [Warning] [MY-010142] [Server] Changed limits: table\_open\_cache: 7677 (requested 50000) 2024-03-18T15:29:26.248847+01:00 0 [Warning] [MY-011068] [Server] The syntax ‘log\_slave\_updates’ is deprecated and will be removed in a future release. Please use log\_replica\_updates instead. 2024-03-18T15:29:26.248858+01:00 0 [Warning] [MY-011068] [Server] The syntax ‘expire-logs-days’ is deprecated and will be removed in a future release. Please use binlog\_expire\_logs\_seconds instead. 2024-03-18T15:29:26.248869+01:00 0 [Warning] [MY-011070] [Server] ‘Disabling symbolic links using --skip-symbolic-links (or equivalent) is the default. Consider not using this option as it’ is deprecated and will be removed in a future release. 2024-03-18T15:29:26.248964+01:00 0 [Warning] [MY-011068] [Server] The syntax ‘wsrep\_slave\_threads’ is deprecated and will be removed in a future release. Please use wsrep\_applier\_threads instead. 2024-03-18T15:29:26.251123+01:00 0 [Warning] [MY-010097] [Server] Insecure configuration for --secure-log-path: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path. 2024-03-18T15:29:26.252173+01:00 0 [Note] [MY-013932] [Server] BuildID[sha1]=358c16a0bb428d0033482250bb792bc91e543d3f 2024-03-18T15:29:26.252180+01:00 0 [Note] [MY-010949] [Server] Basedir set to /usr/. 2024-03-18T15:29:26.252188+01:00 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.32-24.2) starting as process 19502 2024-03-18T15:29:26.260257+01:00 0 [Note] [MY-010303] [Server] Skipping generation of SSL certificates as options related to SSL are specified. 2024-03-18T15:29:26.261957+01:00 0 [Warning] [MY-010068] [Server] CA certificate /mysql/certs/ca.pem is self signed. 2024-03-18T15:29:26.262005+01:00 0 [System] [MY-013602] [Server] Channel mysql\_main configured to support TLS. Encrypted connections are now supported for this channel. 2024-03-18T15:29:26.262017+01:00 0 [Note] [MY-000000] [WSREP] New joining cluster node configured to use specified SSL artifacts 2024-03-18T15:29:26.262080+01:00 0 [Note] [MY-000000] [Galera] Loading provider /usr/lib64/galera4/libgalera\_smm.so initial position: 16ab83af-6413-11ee-a747-db1da5a3b98e:1258516 2024-03-18T15:29:26.262106+01:00 0 [Note] [MY-000000] [Galera] wsrep\_load(): loading provider library ‘/usr/lib64/galera4/libgalera\_smm.so’ 2024-03-18T15:29:26.263285+01:00 0 [Note] [MY-000000] [Galera] wsrep\_load(): Galera 4.14(779b689) by Codership Oy [info@codership.com](mailto:info@codership.com) (modified by Percona [https://percona.com/](https://percona.com/)) loaded successfully. 2024-03-18T15:29:26.263324+01:00 0 [Note] [MY-000000] [Galera] CRC-32C: using 64-bit x86 acceleration. 2024-03-18T15:29:26.263631+01:00 0 [Warning] [MY-000000] [Galera] SSL compression is not effective. The option socket.ssl\_compression is deprecated and will be removed in future releases. 2024-03-18T15:29:26.263645+01:00 0 [Warning] [MY-000000] [Galera] Parameter ‘socket.ssl\_compression’ is deprecated and will be removed in future versions 2024-03-18T15:29:26.264559+01:00 0 [Note] [MY-000000] [Galera] Found saved state: 16ab83af-6413-11ee-a747-db1da5a3b98e:1258516, safe\_to\_bootstrap: 1 2024-03-18T15:29:26.264936+01:00 0 [Note] [MY-000000] [Galera] GCache DEBUG: opened preamble: Version: 2 UUID: 16ab83af-6413-11ee-a747-db1da5a3b98e Seqno: -1 - -1 Offset: -1 Synced: 1 EncVersion: 1 Encrypted: 0 MasterKeyConst UUID: 2586b3d1-425d-11ee-a432-4fe8db1b9907 MasterKey UUID: 00000000-0000-0000-0000-000000000000 MasterKey ID: 0 2024-03-18T15:29:26.264956+01:00 0 [Note] [MY-000000] [Galera] Recovering GCache ring buffer: version: 2, UUID: 16ab83af-6413-11ee-a747-db1da5a3b98e, offset: -1