# Percona XtraDB Cluster 8.0 - cluster size as 1 at node 2 and 3 **URL:** \ **Category:** Percona XtraDB Cluster 8.x\ **Tags:** mysql, percona\ **Created:** [October 23, 2020, 1:21am UTC](https://forums.percona.com/t/percona-xtradb-cluster-8-0-cluster-size-as-1-at-node-2-and-3/8176 "2020-10-23T01:21:58Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![AneeshBabu](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/aneeshbabu/32/1393_2.png) [@AneeshBabu](https://forums.percona.com/u/AneeshBabu)\ **Post date:** [October 23, 2020, 1:21am UTC](https://forums.percona.com/t/percona-xtradb-cluster-8-0-cluster-size-as-1-at-node-2-and-3/8176/1 "2020-10-23T01:21:58Z")
Hi there… when the checked the cluster size showing as below at node 2 and node 3, what could be the problem…? Attaching the config file of 3 nodes. [Config file - PXC 8.0 .pdf](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/1X/39accefd2260dc095184a874ded61e0d74cd538d.pdf) Node -2 mysql@pxc2 \> show status like ‘%cluster\_size%’; ±-------------------±------+ | Variable\_name | Value | ±-------------------±------+ | wsrep\_cluster\_size | 1 | ±-------------------±------+ 1 row in set (0.00 sec) Node -3 mysql@pxc3 \> show status like ‘%cluster\_size%’; ±-------------------±------+ | Variable\_name | Value | ±-------------------±------+ | wsrep\_cluster\_size | 1 | ±-------------------±------+ 1 row in set (0.00 sec) Below is the status when issued the clustercheck command. root@pxc-1:~# clustercheck HTTP/1.1 503 Service Unavailable Content-Type: text/plain Connection: close Content-Length: Percona XtraDB Cluster Node is not synced or non-PRIM. [Config file - PXC 8.0 .pdf](https://forums.percona.com/uploads/short-url/8edsivd9nZvAZs0cQ9vXuaYNZQ9.pdf) (98.8 KB) ---
**Author:** ![vadimtk](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/vadimtk/32/9528_2.png) [@vadimtk](https://forums.percona.com/u/vadimtk)\ **Post date:** [October 23, 2020, 9:51am UTC](https://forums.percona.com/t/percona-xtradb-cluster-8-0-cluster-size-as-1-at-node-2-and-3/8176/2 "2020-10-23T09:51:18Z")
In your configs you should have wsrep\_cluster\_address = gcomm://192.168.0.1,192.168.0.2,192.168.0.3 on ALL your nodes, not only on Node 1 ---
**Author:** ![AneeshBabu](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/aneeshbabu/32/1393_2.png) [@AneeshBabu](https://forums.percona.com/u/AneeshBabu)\ **Post date:** [October 23, 2020, 12:47pm UTC](https://forums.percona.com/t/percona-xtradb-cluster-8-0-cluster-size-as-1-at-node-2-and-3/8176/3 "2020-10-23T12:47:55Z")
Hi @vadimtk added the wsrep\_cluster\_address = gcomm://192.168.0.1,192.168.0.2,192.168.0.3 in all the nodes 1,2,3. After bootstrapped the first node ,Started the mysql service at node 2 ,facing the below error. Attaching the error log file for your reference. [node 2 error.log](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/1X/a936711278b2a3cfe43dfc89b544b1fa9ad727f5.log) Note : I have changed the variable from ON to pxc-encrypt-cluster-traffic=OFF in all the config files. root@pxc-2:~# service mysql start Job for mysql.service failed because the control process exited with error code. See “systemctl status mysql.service” and “journalctl -xe” for details. root@pxc-2:~# systemctl status mysql.service ● mysql.service - Percona XtraDB Cluster Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled) Active: failed (Result: exit-code) since Fri 2020-10-23 17:54:16 UTC; 1min 21s ago Process: 6245 ExecStopPost=/usr/bin/mysql-systemd stop-post (code=exited, status=0/SUCCESS) Process: 3748 ExecStop=/usr/bin/mysql-systemd stop (code=exited, status=0/SUCCESS) Process: 2375 ExecStartPost=/usr/bin/mysql-systemd start-post $MAINPID (code=exited, status=0/SUCCESS) Process: 2373 ExecStartPost=/bin/sh -c systemctl unset-environment \_WSREP\_START\_POSITION (code=exited, status=0/SUCCESS) Process: 6240 ExecStart=/usr/sbin/mysqld $\_WSREP\_START\_POSITION (code=exited, status=1/FAILURE) Process: 6192 ExecStartPre=/bin/sh -c VAR=`bash /usr/bin/mysql-systemd galera-recovery`; [$? -eq 0] && systemctl set-environment \_WSREP\_START\_POSITION=$VAR || exit 1 (code=exited, s Process: 6186 ExecStartPre=/bin/sh -c systemctl unset-environment \_WSREP\_START\_POSITION (code=exited, status=0/SUCCESS) Process: 6155 ExecStartPre=/usr/bin/mysql-systemd check-grastate (code=exited, status=0/SUCCESS) Process: 6106 ExecStartPre=/usr/bin/mysql-systemd start-pre (code=exited, status=0/SUCCESS) Main PID: 6240 (code=exited, status=1/FAILURE) Status: “Server startup in progress” Oct 23 17:53:43 pxc-2 systemd[1]: Starting Percona XtraDB Cluster… Oct 23 17:54:16 pxc-2 systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE Oct 23 17:54:16 pxc-2 mysql-systemd[6245]: WARNING: mysql pid file /var/run/mysqld/mysqld.pid empty or not readable Oct 23 17:54:16 pxc-2 mysql-systemd[6245]: WARNING: mysql may be already dead Oct 23 17:54:16 pxc-2 systemd[1]: mysql.service: Failed with result ‘exit-code’. Oct 23 17:54:16 pxc-2 systemd[1]: Failed to start Percona XtraDB Cluster. lines 1-21/21 (END) [8]+ Stopped systemctl status mysql.service ---
**Author:** ![AneeshBabu](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/aneeshbabu/32/1393_2.png) [@AneeshBabu](https://forums.percona.com/u/AneeshBabu)\ **Post date:** [October 27, 2020, 4:11am UTC](https://forums.percona.com/t/percona-xtradb-cluster-8-0-cluster-size-as-1-at-node-2-and-3/8176/4 "2020-10-27T04:11:25Z")
Hi there … Can anyone look in to this issue …? ---
**Author:** ![Evgeniy\_Patlan](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/evgeniy_patlan/32/41_2.png) [@Evgeniy\_Patlan](https://forums.percona.com/u/Evgeniy_Patlan)\ **Post date:** [December 2, 2020, 9:54am UTC](https://forums.percona.com/t/percona-xtradb-cluster-8-0-cluster-size-as-1-at-node-2-and-3/8176/5 "2020-12-02T09:54:11Z")
Hi @AneeshBabuAs I can see from log ```auto 2020-10-23T17:06:18.566323Z 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():159 2020-10-23T17:06:18.566350Z 0 [ERROR] [MY-000000] [Galera] gcs/src/gcs_core.cpp:gcs_core_open():220: Failed to open backend connection: -110 (Connection timed out) 2020-10-23T17:06:18.566426Z 0 [ERROR] [MY-000000] [Galera] gcs/src/gcs.cpp:gcs_open():1700: Failed to open channel 'pxc-cluster' at 'gcomm://192.168.0.1,192.168.0.2,192.168.0.3': -110 (Connection timed out) 2020-10-23T17:06:18.566444Z 0 [ERROR] [MY-000000] [Galera] gcs connect failed: Connection timed out ``` It might be connected with SELinux polices. According to documentation it is recommended the best solution is to change the mode from enforcing to permissive by running the following command: setenforce 0 This only changes the mode at runtime. To run SELinux in permissive mode after a reboot, set SELINUX=permissive in the /etc/selinux/config configuration file. ---
**Author:** ![Naveen](https://avatars.discourse-cdn.com/v4/letter/n/f07891/32.png) [@Naveen](https://forums.percona.com/u/Naveen)\ **Post date:** [June 18, 2021, 7:52am UTC](https://forums.percona.com/t/percona-xtradb-cluster-8-0-cluster-size-as-1-at-node-2-and-3/8176/6 "2021-06-18T07:52:47Z")
Hii @AneeshBabu is ur issue solved?Iam also facing similar issue can anyone help me. ---
**Author:** ![Naveen](https://avatars.discourse-cdn.com/v4/letter/n/f07891/32.png) [@Naveen](https://forums.percona.com/u/Naveen)\ **Post date:** [June 18, 2021, 7:56am UTC](https://forums.percona.com/t/percona-xtradb-cluster-8-0-cluster-size-as-1-at-node-2-and-3/8176/7 "2021-06-18T07:56:09Z")
Hii @Evgeniy_Patlan i followed ur steps but still iam getting same error. ---
**Author:** ![Evgeniy\_Patlan](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/evgeniy_patlan/32/41_2.png) [@Evgeniy\_Patlan](https://forums.percona.com/u/Evgeniy_Patlan)\ **Post date:** [June 18, 2021, 8:14am UTC](https://forums.percona.com/t/percona-xtradb-cluster-8-0-cluster-size-as-1-at-node-2-and-3/8176/8 "2021-06-18T08:14:18Z")
@Naveen could you please share your log? ---
**Author:** ![Naveen](https://avatars.discourse-cdn.com/v4/letter/n/f07891/32.png) [@Naveen](https://forums.percona.com/u/Naveen)\ **Post date:** [June 18, 2021, 8:30am UTC](https://forums.percona.com/t/percona-xtradb-cluster-8-0-cluster-size-as-1-at-node-2-and-3/8176/9 "2021-06-18T08:30:01Z")
Hii@Evgeniy\_patlan thanks for ur rply ,that was a firewall issue.Now iam getting another issue. iam trying to add second node to my cluster(xtradb cluster 8.0) but it is giving sst error. ![perc](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/2/2fbe85edf13c76625bae4641daf2ad23e0066bfe.png) ---
**Author:** ![Naveen](https://avatars.discourse-cdn.com/v4/letter/n/f07891/32.png) [@Naveen](https://forums.percona.com/u/Naveen)\ **Post date:** [June 18, 2021, 8:32am UTC](https://forums.percona.com/t/percona-xtradb-cluster-8-0-cluster-size-as-1-at-node-2-and-3/8176/10 "2021-06-18T08:32:17Z")
@Evgeniy_Patlan It would be great if u could help me in solving this error. ---
**Author:** ![Evgeniy\_Patlan](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/evgeniy_patlan/32/41_2.png) [@Evgeniy\_Patlan](https://forums.percona.com/u/Evgeniy_Patlan)\ **Post date:** [June 18, 2021, 8:37am UTC](https://forums.percona.com/t/percona-xtradb-cluster-8-0-cluster-size-as-1-at-node-2-and-3/8176/11 "2021-06-18T08:37:23Z")
@Naveen please create ticket regarding this issue in PXC project in [jira.percona.com](http://jira.percona.com) ---
**Author:** ![Naveen](https://avatars.discourse-cdn.com/v4/letter/n/f07891/32.png) [@Naveen](https://forums.percona.com/u/Naveen)\ **Post date:** [June 18, 2021, 11:05am UTC](https://forums.percona.com/t/percona-xtradb-cluster-8-0-cluster-size-as-1-at-node-2-and-3/8176/12 "2021-06-18T11:05:43Z")
@matthewb can u see this issue once ---
**Author:** ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)\ **Post date:** [June 18, 2021, 2:34pm UTC](https://forums.percona.com/t/percona-xtradb-cluster-8-0-cluster-size-as-1-at-node-2-and-3/8176/13 "2021-06-18T14:34:22Z")
I see an issue with socat and your tcp/ip ports. Please make sure SELinux is in permissive mode, turn off any firewalls, and make sure your gcomm:// ip addresses are correct. ---
**Author:** ![Naveen](https://avatars.discourse-cdn.com/v4/letter/n/f07891/32.png) [@Naveen](https://forums.percona.com/u/Naveen)\ **Post date:** [June 18, 2021, 2:44pm UTC](https://forums.percona.com/t/percona-xtradb-cluster-8-0-cluster-size-as-1-at-node-2-and-3/8176/14 "2021-06-18T14:44:02Z")
@matthewb their is no SELinux in my machines,turned off all firewalls and ip addresses are correct. ---
**Author:** ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)\ **Post date:** [June 18, 2021, 2:58pm UTC](https://forums.percona.com/t/percona-xtradb-cluster-8-0-cluster-size-as-1-at-node-2-and-3/8176/15 "2021-06-18T14:58:15Z")
Ok, perform some networking troubleshooting basics. Try to telnet from A to B on port 4567. Do you get a response? If not, you still have networking issues. Try this, on B, run `socat - TCP-LISTEN:4444,reuseaddr` and on A run this `echo "hello" | socat - TCP:nodeB:4444` Did that work? If not, you have networking issues. ---
**Author:** ![Naveen](https://avatars.discourse-cdn.com/v4/letter/n/f07891/32.png) [@Naveen](https://forums.percona.com/u/Naveen)\ **Post date:** [June 18, 2021, 3:05pm UTC](https://forums.percona.com/t/percona-xtradb-cluster-8-0-cluster-size-as-1-at-node-2-and-3/8176/16 "2021-06-18T15:05:45Z")
@matthewb exactly 2 addresses required (there are 0) on node A and node B.This is the error iam getting.can u tell me any solutions to solve it ---
**Author:** ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)\ **Post date:** [June 18, 2021, 3:59pm UTC](https://forums.percona.com/t/percona-xtradb-cluster-8-0-cluster-size-as-1-at-node-2-and-3/8176/17 "2021-06-18T15:59:42Z")
what do you mean “there are 0”? Your servers must have IP addresses on them. How are you accessing them otherwise? ---
**Author:** ![Naveen](https://avatars.discourse-cdn.com/v4/letter/n/f07891/32.png) [@Naveen](https://forums.percona.com/u/Naveen)\ **Post date:** [June 18, 2021, 5:21pm UTC](https://forums.percona.com/t/percona-xtradb-cluster-8-0-cluster-size-as-1-at-node-2-and-3/8176/18 "2021-06-18T17:21:03Z")
on Node A :E getaddrinfo(ip):name or service not known on Node B:E bind(5,{AF= ip},16):address already in use ---
**Author:** ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)\ **Post date:** [June 18, 2021, 6:56pm UTC](https://forums.percona.com/t/percona-xtradb-cluster-8-0-cluster-size-as-1-at-node-2-and-3/8176/19 "2021-06-18T18:56:30Z")
How can node A not have an IP? How are you accessing this server? Console? Node A is clearly messed up at a deeper level. ---
**Author:** ![Naveen](https://avatars.discourse-cdn.com/v4/letter/n/f07891/32.png) [@Naveen](https://forums.percona.com/u/Naveen)\ **Post date:** [June 19, 2021, 2:55am UTC](https://forums.percona.com/t/percona-xtradb-cluster-8-0-cluster-size-as-1-at-node-2-and-3/8176/20 "2021-06-19T02:55:27Z")
Hii @matthewb i will attach screenshots of commands 1.ON node B ![NB1](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/d/d1d5059156499601d09b76973bf72e664a8ff5d9.jpeg) 2.On Node A ![NA](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/d/d83a4fe43e56df21fb9021183e5078c76cd0d910.jpeg) 3.On Node B i got output ![NB2](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/c/cf0b3b8a7caf1610a14426acc1ea54fb0abffd14.jpeg) So i think their is no network issue… [Next page](https://forums.percona.com/t/percona-xtradb-cluster-8-0-cluster-size-as-1-at-node-2-and-3/8176.md?page=2)