# CentOS 6.5 And Percona XtraDB Cluster Just Doesn't Work? **URL:** \ **Category:** Percona XtraDB Cluster 5.x\ **Created:** [December 19, 2014, 4:25pm UTC](https://forums.percona.com/t/centos-6-5-and-percona-xtradb-cluster-just-doesnt-work/3960 "2014-12-19T16:25:17Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![skinfrakki](https://avatars.discourse-cdn.com/v4/letter/s/cc9497/32.png) [@skinfrakki](https://forums.percona.com/u/skinfrakki)\ **Post date:** [December 19, 2014, 4:25pm UTC](https://forums.percona.com/t/centos-6-5-and-percona-xtradb-cluster-just-doesnt-work/3960/1 "2014-12-19T16:25:17Z")
I can easily get Ubuntu/Debian clustering working. However, CentOS I get nothing but errors: 141219 14:42:55 mysqld\_safe mysqld from pid file /var/lib/mysql/perconadb2.hsmovedev.com.pid ended 141219 14:43:30 mysqld\_safe Starting mysqld daemon with databases from /var/lib/mysql 141219 14:43:30 mysqld\_safe WSREP: Running position recovery with --log\_error=‘/var/lib/mysql/wsrep\_recovery.WnB5jJ’ --pid-file=‘/var/lib/mysql/perconadb2.hsmovedev.com-recover.pid’ 141219 14:43:32 mysqld\_safe WSREP: Recovered position cab4275d-87c6-11e4-8794-87a6df8cd654:0 141219 14:43:32 [Note] WSREP: wsrep\_start\_position var submitted: ‘cab4275d-87c6-11e4-8794-87a6df8cd654:0’ 141219 14:43:32 [Note] WSREP: Read nil XID from storage engines, skipping position init 141219 14:43:32 [Note] WSREP: wsrep\_load(): loading provider library ‘/usr/lib64/libgalera\_smm.so’ 141219 14:43:32 [Note] WSREP: wsrep\_load(): Galera 2.11(r318911d) by Codership Oy \ loaded successfully. 141219 14:43:32 [Note] WSREP: Found saved state: cab4275d-87c6-11e4-8794-87a6df8cd654:-1 141219 14:43:32 [Note] WSREP: Reusing existing ‘/var/lib/mysql//galera.cache’. 141219 14:43:32 [Note] WSREP: Passing config to GCS: base\_host = 192.168.102.210; base\_port = 4567; cert.log\_conflicts = no; debug = no; evs.inactive\_check\_period = PT0.5S; evs.inactive\_timeout = PT15S; evs.join\_retrans\_period = PT1S; evs.max\_install\_timeouts = 3; evs.send\_window = 4; evs.stats\_report\_period = PT1M; evs.suspect\_timeout = PT5S; evs.user\_send\_window = 2; evs.view\_forget\_timeout = PT24H; gcache.dir = /var/lib/mysql/; gcache.keep\_pages\_size = 0; gcache.mem\_size = 0; gcache.name = /var/lib/mysql//galera.cache; gcache.page\_size = 128M; gcache.size = 128M; gcs.fc\_debug = 0; gcs.fc\_factor = 1.0; gcs.fc\_limit = 16; gcs.fc\_master\_slave = no; gcs.max\_packet\_size = 64500; gcs.max\_throttle = 0.25; gcs.recv\_q\_hard\_limit = 9223372036854775807; gcs.recv\_q\_soft\_limit = 0.25; gcs.sync\_donor = no; gmcast.version = 0; pc.announce\_timeout = PT3S; pc.checksum = false; pc.ignore\_quorum = false; pc.ignore\_sb = false; pc.npvo = false; pc.version = 0; pc.wait\_prim = true; pc.wait\_prim\_timeout = P30S; pc.weight = 1; protonet.backend = asio; 141219 14:43:32 [Note] WSREP: Assign initial position for certification: 0, protocol version: -1 141219 14:43:32 [Note] WSREP: wsrep\_sst\_grab() 141219 14:43:32 [Note] WSREP: Start replication 141219 14:43:32 [Note] WSREP: Setting initial position to cab4275d-87c6-11e4-8794-87a6df8cd654:0 141219 14:43:32 [Note] WSREP: protonet asio version 0 141219 14:43:32 [Note] WSREP: backend: asio 141219 14:43:32 [Note] WSREP: GMCast version 0 141219 14:43:32 [Note] WSREP: (14146b78, ‘tcp://0.0.0.0:4567’) listening at tcp://0.0.0.0:4567 141219 14:43:32 [Note] WSREP: (14146b78, ‘tcp://0.0.0.0:4567’) multicast: , ttl: 1 141219 14:43:32 [Note] WSREP: EVS version 0 141219 14:43:32 [Note] WSREP: PC version 0 141219 14:43:32 [Note] WSREP: gcomm: connecting to group ‘my\_centos\_cluster’, peer ‘192.168.102.209:,192.168.102.210:,192.168.102.211:’ 141219 14:43:32 [Warning] WSREP: (14146b78, ‘tcp://0.0.0.0:4567’) address ‘tcp://192.168.102.210:4567’ points to own listening address, blacklisting 141219 14:43:35 [Warning] WSREP: no nodes coming from prim view, prim not possible 141219 14:43:36 [Warning] WSREP: last inactive check more than PT1.5S ago (PT3.50768S), skipping check 141219 14:44:05 [ERROR] WSREP: failed to open gcomm backend connection: 110: failed to reach primary view: 110 (Connection timed out) at gcomm/src/pc.cpp:connect():141 141219 14:44:05 [ERROR] WSREP: gcs/src/gcs\_core.cpp:long int gcs\_core\_open(gcs\_core\_t\*, const char\*, const char\*, bool)():204: Failed to open backend connection: -110 (Connection timed out) 141219 14:44:05 [ERROR] WSREP: gcs/src/gcs.cpp:long int gcs\_open(gcs\_conn\_t\*, const char\*, const char\*, bool)():1303: Failed to open channel ‘my\_centos\_cluster’ at ‘gcomm://192.168.102.209,192.168.102.210,192.168.102.211’: -110 (Connection timed out) 141219 14:44:05 [ERROR] WSREP: gcs connect failed: Connection timed out 141219 14:44:05 [ERROR] WSREP: wsrep::connect() failed: 7 141219 14:44:05 [ERROR] Aborting 141219 14:44:05 [Note] WSREP: Service disconnected. 141219 14:44:06 [Note] WSREP: Some threads may fail to exit. 141219 14:44:06 [Note] /usr/sbin/mysqld: Shutdown complete 141219 14:44:06 mysqld\_safe mysqld from pid file /var/lib/mysql/perconadb2.hsmovedev.com.pid ended I followed the guide to the letter, telnet to the ports jsut fine on the master. What is the issue? ---
**Author:** ![wagnerbianchi](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/wagnerbianchi/32/802_2.png) [@wagnerbianchi](https://forums.percona.com/u/wagnerbianchi)\ **Post date:** [December 21, 2014, 7:24am UTC](https://forums.percona.com/t/centos-6-5-and-percona-xtradb-cluster-just-doesnt-work/3960/2 "2014-12-21T07:24:18Z")
Check if this one will help you: [url][http://www.percona.com/forums/questions-discussions/percona-xtradb-cluster/13405-failed-to-open-gcomm-backend-connection-110-failed-to-reach-primary-view-110[/url]](http://www.percona.com/forums/questions-discussions/percona-xtradb-cluster/13405-failed-to-open-gcomm-backend-connection-110-failed-to-reach-primary-view-110%5B/url%5D) ---
**Author:** ![skinfrakki](https://avatars.discourse-cdn.com/v4/letter/s/cc9497/32.png) [@skinfrakki](https://forums.percona.com/u/skinfrakki)\ **Post date:** [January 2, 2015, 12:53pm UTC](https://forums.percona.com/t/centos-6-5-and-percona-xtradb-cluster-just-doesnt-work/3960/3 "2015-01-02T12:53:40Z")
Really not helping. Tried both CentOS 6.5 and 7. Failures on both. Really just need a solution that works. The other thread never concluded the issue ---
**Author:** ![skinfrakki](https://avatars.discourse-cdn.com/v4/letter/s/cc9497/32.png) [@skinfrakki](https://forums.percona.com/u/skinfrakki)\ **Post date:** [January 2, 2015, 12:55pm UTC](https://forums.percona.com/t/centos-6-5-and-percona-xtradb-cluster-just-doesnt-work/3960/4 "2015-01-02T12:55:17Z")
Jan 2 11:16:53 db2 mysqld: 2015-01-02 11:16:53 2715 [Warning] WSREP: access file(gvwstate.dat) failed(No such file or directory) Jan 2 11:16:53 db2 mysqld: 2015-01-02 11:16:53 2715 [Note] WSREP: restore pc from disk failed Jan 2 11:16:53 db2 mysqld: 2015-01-02 11:16:53 2715 [Note] WSREP: GMCast version 0 Jan 2 11:16:53 db2 mysqld: 2015-01-02 11:16:53 2715 [Note] WSREP: (875ea8fb, ‘tcp://0.0.0.0:4567’) listening at tcp://0.0.0.0:4567 Jan 2 11:16:53 db2 mysqld: 2015-01-02 11:16:53 2715 [Note] WSREP: (875ea8fb, ‘tcp://0.0.0.0:4567’) multicast: , ttl: 1 Jan 2 11:16:53 db2 mysqld: 2015-01-02 11:16:53 2715 [Note] WSREP: EVS version 0 Jan 2 11:16:53 db2 mysqld: 2015-01-02 11:16:53 2715 [Note] WSREP: gcomm: connecting to group ‘my\_centos\_cluster’, peer ‘192.168.102.232:’ Jan 2 11:16:54 db2 systemd: Time has been changed Jan 2 11:16:56 db2 kernel: hv\_balloon: Received INFO\_TYPE\_MAX\_PAGE\_CNT Jan 2 11:16:56 db2 kernel: hv\_balloon: Data Size is 8 Jan 2 11:16:56 db2 mysqld: 2015-01-02 11:16:56 2715 [Warning] WSREP: no nodes coming from prim view, prim not possible Jan 2 11:16:56 db2 mysqld: 2015-01-02 11:16:56 2715 [Note] WSREP: view(view\_id(NON\_PRIM,875ea8fb,1) memb { Jan 2 11:16:56 db2 mysqld: 875ea8fb,0 Jan 2 11:16:56 db2 mysqld: } joined { Jan 2 11:16:56 db2 mysqld: } left { Jan 2 11:16:56 db2 mysqld: } partitioned { Jan 2 11:16:56 db2 mysqld: }) Jan 2 11:16:56 db2 mysqld: 2015-01-02 11:16:56 2715 [Note] WSREP: gcomm: connected Jan 2 11:16:56 db2 mysqld: 2015-01-02 11:16:56 2715 [Note] WSREP: Changing maximum packet size to 64500, resulting msg size: 32636 Jan 2 11:16:56 db2 mysqld: 2015-01-02 11:16:56 2715 [Note] WSREP: Shifting CLOSED → OPEN (TO: 0) Jan 2 11:16:56 db2 mysqld: 2015-01-02 11:16:56 2715 [Note] WSREP: Opened channel ‘my\_centos\_cluster’ Jan 2 11:16:56 db2 mysqld: 2015-01-02 11:16:56 2715 [Note] WSREP: Waiting for SST to complete. Jan 2 11:16:56 db2 mysqld: 2015-01-02 11:16:56 2715 [Note] WSREP: New COMPONENT: primary = no, bootstrap = no, my\_idx = 0, memb\_num = 1 Jan 2 11:16:56 db2 mysqld: 2015-01-02 11:16:56 2715 [Note] WSREP: Flow-control interval: [16, 16] Jan 2 11:16:56 db2 mysqld: 2015-01-02 11:16:56 2715 [Note] WSREP: Received NON-PRIMARY. Jan 2 11:16:56 db2 mysqld: 2015-01-02 11:16:56 2715 [Note] WSREP: New cluster view: global state: :-1, view# -1: non-Primary, number of nodes: 1, my index: 0, protocol version -1 Jan 2 11:16:56 db2 mysqld: 2015-01-02 11:16:56 2715 [Note] WSREP: wsrep\_notify\_cmd is not defined, skipping notification. Jan 2 11:16:57 db2 mysqld: 2015-01-02 11:16:57 2715 [Warning] WSREP: last inactive check more than PT1.5S ago (PT3.51805S), skipping check ---
**Author:** ![przemek](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/przemek/32/3_2.png) [@przemek](https://forums.percona.com/u/przemek)\ **Post date:** [January 26, 2015, 2:56am UTC](https://forums.percona.com/t/centos-6-5-and-percona-xtradb-cluster-just-doesnt-work/3960/5 "2015-01-26T02:56:13Z")
Hi skinfrakki, Percona XtraDB Cluster works on both Debian/Ubuntu as well as RedHat and Centos 5,6 and 7. In fact I think most PXC users are probably on Centos 6 now. The errors you show above means this node cannot to connect to any existing cluster member and also it is not the one to be bootstrapped. In the first log it seems the node was not able to even connect to any other node on startup, hence it timeouted, In the second log, the line: Jan 2 11:16:56 db2 mysqld: 2015-01-02 11:16:56 2715 [Warning] WSREP: no nodes coming from prim view, prim not possible shows it seems to connect somewhere, but not to any primary component. Please check if all the needed TCP ports are opened between all the nodes and also initialize your cluster on first started node with bootstrap, for example: ```auto service mysql bootstrap-pxc ``` Then once you start the next nodes, they should connect properly to this one.