# cluster fail

**URL:** <https://forums.percona.com/t/cluster-fail/6069>\
**Category:** Percona XtraDB Cluster 5.x\
**Created:** [December 9, 2017, 1:58pm UTC](https://forums.percona.com/t/cluster-fail/6069 "2017-12-09T13:58:18Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![pgokan](https://avatars.discourse-cdn.com/v4/letter/p/e274bd/32.png) [@pgokan](https://forums.percona.com/u/pgokan)\
**Post date:** [December 9, 2017, 1:58pm UTC](https://forums.percona.com/t/cluster-fail/6069/1 "2017-12-09T13:58:18Z")

</div>

Hello

After clustering, I started again on two servers I had. But I get an error when starting server 1 as below.  
There is no data on it right now. What is the cause of the problem?

srv1:  
Os: Ubuntu 16.04

srv2:  
Os: Ubuntu 16.04

# /etc/init.d/mysql bootstrap-pxc

# tail -f /var/log/mysqld.log

017-12-09T19:21:40.933510Z mysqld\_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended  
2017-12-09T19:21:45.927701Z mysqld\_safe Logging to ‘/var/log/mysqld.log’.  
2017-12-09T19:21:45.945611Z mysqld\_safe Starting mysqld daemon with databases from /var/lib/mysql  
2017-12-09T19:21:45.955051Z mysqld\_safe Skipping wsrep-recover for dd3abd12-dd0c-11e7-aae3-b234582bcef8:6 pair  
2017-12-09T19:21:45.956276Z mysqld\_safe Assigning dd3abd12-dd0c-11e7-aae3-b234582bcef8:6 to wsrep\_start\_position  
2017-12-09T19:21:46.142191Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit\_defaults\_for\_timestamp server option (see documentation for more details).  
2017-12-09T19:21:46.143773Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.19-17-57-log) starting as process 11235 …  
2017-12-09T19:21:46.145970Z 0 [Warning] No argument was provided to --log-bin, and --log-bin-index was not used; so replication may break when this MySQL server acts as a master and has his hostname changed!! Please use ‘–log-bin=uninginx0-bin’ to avoid this problem.  
2017-12-09T19:21:46.146376Z 0 [Note] WSREP: Setting wsrep\_ready to false  
2017-12-09T19:21:46.146407Z 0 [Note] WSREP: No pre-stored wsrep-start position found. Skipping position initialization.  
2017-12-09T19:21:46.146429Z 0 [Note] WSREP: wsrep\_load(): loading provider library ‘/usr/lib/libgalera\_smm.so’  
2017-12-09T19:21:46.149608Z 0 [Note] WSREP: wsrep\_load(): Galera 3.22(r8678538) by Codership Oy \<info@codership.com\> loaded successfully.  
2017-12-09T19:21:46.149686Z 0 [Note] WSREP: CRC-32C: using hardware acceleration.  
2017-12-09T19:21:46.150076Z 0 [Note] WSREP: Found saved state: dd3abd12-dd0c-11e7-aae3-b234582bcef8:6, safe\_to\_bootsrap: 0  
2017-12-09T19:21:46.155178Z 0 [Note] WSREP: Passing config to GCS: base\_dir = /var/lib/mysql/; base\_host = 94.130.226.187; base\_port = 4567; cert.log\_conflicts = no; debug = no; evs.auto\_evict = 0; evs.delay\_margin = PT1S; evs.delayed\_keep\_period = PT30S; evs.inactive\_check\_period = PT0.5S; evs.inactive\_timeout = PT15S; evs.join\_retrans\_period = PT1S; evs.max\_install\_timeouts = 3; evs.send\_window = 10; evs.stats\_report\_period = PT1M; evs.suspect\_timeout = PT5S; evs.user\_send\_window = 4; evs.view\_forget\_timeout = PT24H; gcache.dir = /var/lib/mysql/; gcache.keep\_pages\_count = 0; gcache.keep\_pages\_size = 0; gcache.mem\_size = 0; gcache.name = /var/lib/mysql//galera.cache; gcache.page\_size = 128M; gcache.recover = no; gcache.size = 128M; gcomm.thread\_prio = ; gcs.fc\_debug = 0; gcs.fc\_factor = 1; gcs.fc\_limit = 100; 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.segment = 0; gmcast.version = 0; pc.announce\_timeout = PT3S; pc.checksum = false; pc.ignore\_quorum = false; pc.ignore\_sb = false; pc.npvo = false; pc.recovery = 1; pc.version = 0; pc.wait\_prim = true; pc.wait\_prim\_timeout = PT30S; pc.weight = 1; protonet.backend = asio; protonet.version = 0; repl.causal\_read\_timeout = PT30S; repl.commit\_order = 3; repl.key\_format = FLAT8; repl.max\_ws\_size = 2147483647; repl.proto\_max = 7; socket.checksum = 2; socket.recv\_buf\_size = 212992;  
2017-12-09T19:21:46.169496Z 0 [Note] WSREP: GCache history reset: dd3abd12-dd0c-11e7-aae3-b234582bcef8:0 → dd3abd12-dd0c-11e7-aae3-b234582bcef8:6  
2017-12-09T19:21:46.174327Z 0 [Note] WSREP: Assign initial position for certification: 6, protocol version: -1  
2017-12-09T19:21:46.174384Z 0 [Note] WSREP: Preparing to initiate SST/IST  
2017-12-09T19:21:46.174397Z 0 [Note] WSREP: Starting replication  
2017-12-09T19:21:46.174435Z 0 [Note] WSREP: Setting initial position to dd3abd12-dd0c-11e7-aae3-b234582bcef8:6  
2017-12-09T19:21:46.174675Z 0 [Note] WSREP: Using CRC-32C for message checksums.  
2017-12-09T19:21:46.174817Z 0 [Note] WSREP: gcomm thread scheduling priority set to other:0  
2017-12-09T19:21:46.174979Z 0 [Warning] WSREP: Fail to access the file (/var/lib/mysql//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  
2017-12-09T19:21:46.175002Z 0 [Note] WSREP: Restoring primary-component from disk failed. Either node is booting for first time or re-booting after a graceful shutdown  
2017-12-09T19:21:46.175234Z 0 [Note] WSREP: GMCast version 0  
2017-12-09T19:21:46.175471Z 0 [Note] WSREP: (32583645, ‘tcp://0.0.0.0:4567’) listening at tcp://0.0.0.0:4567  
2017-12-09T19:21:46.175498Z 0 [Note] WSREP: (32583645, ‘tcp://0.0.0.0:4567’) multicast: , ttl: 1  
2017-12-09T19:21:46.176031Z 0 [Note] WSREP: EVS version 0  
2017-12-09T19:21:46.176175Z 0 [Note] WSREP: gcomm: connecting to group ‘uni\_cluster’, peer ‘94.x.x.x.x:,94.x.x.x.x:’  
2017-12-09T19:21:46.177243Z 0 [Note] WSREP: (32583645, ‘tcp://0.0.0.0:4567’) connection established to 32583645 tcp://94.x.x.x.x:4567  
2017-12-09T19:21:46.177279Z 0 [Warning] WSREP: (32583645, ‘tcp://0.0.0.0:4567’) address ‘tcp://94.x.x.x.x:4567’ points to own listening address, blacklisting  
2017-12-09T19:21:49.177657Z 0 [Note] WSREP: (32583645, ‘tcp://0.0.0.0:4567’) connection to peer 32583645 with addr tcp://94.x.x.x.x:4567 timed out, no messages seen in PT3S  
2017-12-09T19:21:49.178712Z 0 [Warning] WSREP: no nodes coming from prim view, prim not possible  
2017-12-09T19:21:49.178764Z 0 [Note] WSREP: Current view of cluster as seen by this node  
view (view\_id(NON\_PRIM,32583645,1)  
memb {  
32583645,0  
}  
joined {  
}  
left {  
}  
partitioned {  
}  
)  
2017-12-09T19:21:49.678945Z 0 [Warning] WSREP: last inactive check more than PT1.5S ago (PT3.50294S), skipping check

---

<div class="post-metadata">

**Author:** ![mirfan](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/mirfan/32/16890_2.png) [@mirfan](https://forums.percona.com/u/mirfan)\
**Post date:** [December 15, 2017, 3:24am UTC](https://forums.percona.com/t/cluster-fail/6069/2 "2017-12-15T03:24:16Z")

</div>

There are only NOTE & WARNINGS no ERRORS. Can you please provide complete error log and my.cnf settings from both nodes.

---

<div class="post-metadata">

**Author:** ![Kenn\_Takara](https://avatars.discourse-cdn.com/v4/letter/k/b2d939/32.png) [@Kenn\_Takara](https://forums.percona.com/u/Kenn_Takara)\
**Post date:** [December 15, 2017, 5:28pm UTC](https://forums.percona.com/t/cluster-fail/6069/3 "2017-12-15T17:28:25Z")

</div>

It looks as if this node is not able to communicate with the other node. Maybe the cluster names are different?
