# Problems getting into the cluster **URL:** \ **Category:** Percona XtraDB Cluster 5.x\ **Created:** [August 2, 2017, 12:31pm UTC](https://forums.percona.com/t/problems-getting-into-the-cluster/5786 "2017-08-02T12:31:45Z")\ **Posts on this page:** 1\ **Page:** 1
**Author:** ![bdelmedico](https://avatars.discourse-cdn.com/v4/letter/b/ec9cab/32.png) [@bdelmedico](https://forums.percona.com/u/bdelmedico)\ **Post date:** [August 2, 2017, 12:31pm UTC](https://forums.percona.com/t/problems-getting-into-the-cluster/5786/1 "2017-08-02T12:31:45Z")
I can do the replication normally, but after disconnecting and connecting the server, it does not join the cluster … Can someone give me a light? 2017-08-02T17:53:52.369513Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit\_defaults\_for\_timestamp server option (see documentation for more details). 2017-08-02T17:53:52.370503Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.18-15-57-log) starting as process 18316 … 2017-08-02T17:53:52.372473Z 0 [Note] WSREP: No pre-stored wsrep-start position found. Skipping position initialization. 2017-08-02T17:53:52.372491Z 0 [Note] WSREP: wsrep\_load(): loading provider library ‘/usr/lib/libgalera\_smm.so’ 2017-08-02T17:53:52.374751Z 0 [Note] WSREP: wsrep\_load(): Galera 3.20(r7e383f7) by Codership Oy \ loaded successfully. 2017-08-02T17:53:52.374808Z 0 [Note] WSREP: CRC-32C: using hardware acceleration. 2017-08-02T17:53:52.375110Z 0 [Note] WSREP: Found saved state: 00000000-0000-0000-0000-000000000000:-1, safe\_to\_bootsrap: 0 2017-08-02T17:53:52.387809Z 0 [Note] WSREP: Passing config to GCS: base\_dir = /var/lib/mysql/; base\_host = 172.31.44.195; 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 = PT90S; evs.install\_timeout = PT60S; evs.join\_retrans\_period = PT1S; evs.keepalive\_period = PT3S; evs.max\_install\_timeouts = 8; evs.send\_window = 512; evs.stats\_report\_period = PT1M; evs.suspect\_timeout = PT30S; evs.user\_send\_window = 512; 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 = 1048576; 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-08-02T17:53:52.398750Z 0 [Note] WSREP: GCache history reset: old(a8d37d7e-5c3b-11e7-9fbf-36d50cc17d69:0) → new(00000000-0000-0000-0000-000000000000:-1) 2017-08-02T17:53:52.399403Z 0 [Note] WSREP: Assign initial position for certification: -1, protocol version: -1 2017-08-02T17:53:52.399422Z 0 [Note] WSREP: Preparing to initiate SST/IST 2017-08-02T17:53:52.399426Z 0 [Note] WSREP: Starting replication 2017-08-02T17:53:52.399435Z 0 [Note] WSREP: Setting initial position to 00000000-0000-0000-0000-000000000000:-1 2017-08-02T17:53:52.399582Z 0 [Note] WSREP: Using CRC-32C for message checksums. 2017-08-02T17:53:52.399656Z 0 [Note] WSREP: gcomm thread scheduling priority set to other:0 2017-08-02T17:53:52.399738Z 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-08-02T17:53:52.399752Z 0 [Note] WSREP: Restoring primary-component from disk failed. Either node is booting for first time or re-booting after a graceful shutdown 2017-08-02T17:53:52.400202Z 0 [Note] WSREP: GMCast version 0 2017-08-02T17:53:52.400371Z 0 [Note] WSREP: (8ba437fc, ‘tcp://0.0.0.0:4567’) listening at tcp://0.0.0.0:4567 2017-08-02T17:53:52.400387Z 0 [Note] WSREP: (8ba437fc, ‘tcp://0.0.0.0:4567’) multicast: , ttl: 1 2017-08-02T17:53:52.400652Z 0 [Note] WSREP: EVS version 0 2017-08-02T17:53:52.400732Z 0 [Note] WSREP: gcomm: connecting to group ‘ev-cluster-teste’, peer ‘10.10.10.101:,172.31.44.195:’ 2017-08-02T17:53:52.401523Z 0 [Note] WSREP: (8ba437fc, ‘tcp://0.0.0.0:4567’) connection established to 8ba437fc tcp://172.31.44.195:4567 2017-08-02T17:53:52.401547Z 0 [Warning] WSREP: (8ba437fc, ‘tcp://0.0.0.0:4567’) address ‘tcp://172.31.44.195:4567’ points to own listening address, blacklisting 2017-08-02T17:53:52.410809Z 0 [Note] WSREP: (8ba437fc, ‘tcp://0.0.0.0:4567’) connection established to 1e73c129 tcp://10.10.10.101:4567 2017-08-02T17:53:52.410977Z 0 [Note] WSREP: (8ba437fc, ‘tcp://0.0.0.0:4567’) turning message relay requesting on, nonlive peers: 2017-08-02T17:53:52.912008Z 0 [Note] WSREP: declaring 1e73c129 at tcp://10.10.10.101:4567 stable 2017-08-02T17:53:52.915450Z 0 [Note] WSREP: Node 1e73c129 state primary 2017-08-02T17:53:52.919104Z 0 [Note] WSREP: Current view of cluster as seen by this node 2017-08-02T17:53:52.919134Z 0 [Note] WSREP: Save the discovered primary-component to disk 2017-08-02T17:53:53.401235Z 0 [Note] WSREP: gcomm: connected 2017-08-02T17:53:53.401742Z 0 [Note] WSREP: Shifting CLOSED → OPEN (TO: 0) 2017-08-02T17:53:53.401839Z 0 [Note] WSREP: Waiting for SST/IST to complete. 2017-08-02T17:53:53.401924Z 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my\_idx = 1, memb\_num = 2 2017-08-02T17:53:53.401980Z 0 [Note] WSREP: STATE EXCHANGE: Waiting for state UUID. 2017-08-02T17:53:53.402047Z 0 [Note] WSREP: STATE EXCHANGE: sent state msg: 8beec3cb-77ab-11e7-a7e9-f7133d9c259b 2017-08-02T17:53:53.402094Z 0 [Note] WSREP: STATE EXCHANGE: got state msg: 8beec3cb-77ab-11e7-a7e9-f7133d9c259b from 0 (teste-mha-01) 2017-08-02T17:53:53.405167Z 0 [Note] WSREP: STATE EXCHANGE: got state msg: 8beec3cb-77ab-11e7-a7e9-f7133d9c259b from 1 (ip-172-31-44-195) 2017-08-02T17:53:53.405256Z 2 [Note] WSREP: New cluster view: global state: a8d37d7e-5c3b-11e7-9fbf-36d50cc17d69:163765, view# 7: Primary, number of nodes: 2, my index: 1, protocol version 3 2017-08-02T17:53:53.405270Z 2 [Warning] WSREP: Gap in state sequence. Need state transfer. 2017-08-02T17:53:53.405351Z 0 [Note] WSREP: Initiating SST/IST transfer on JOINER side (wsrep\_sst\_rsync --role ‘joiner’ --address ‘172.31.44.195’ --datadir ‘/var/lib/mysql/’ --defaults-file ‘/etc/mysql/my.cnf’ --defaults-group-suffix ‘’ --parent ‘18316’ ‘’ ) 2017-08-02T17:53:53.460638Z WSREP\_SST: [INFO] Waiting for data-dir through rsync… 2017-08-02T17:53:53.480449Z 2 [Note] WSREP: Prepared SST/IST request: rsync|172.31.44.195:4444/rsync\_sst 2017-08-02T17:53:53.480508Z 2 [Note] WSREP: wsrep\_notify\_cmd is not defined, skipping notification. 2017-08-02T17:53:53.480540Z 2 [Note] WSREP: REPL Protocols: 7 (3, 2) 2017-08-02T17:53:53.480559Z 2 [Note] WSREP: Assign initial position for certification: 163765, protocol version: 3 2017-08-02T17:53:53.480598Z 0 [Note] WSREP: Service thread queue flushed. 2017-08-02T17:53:53.480627Z 2 [Note] WSREP: Check if state gap can be serviced using IST 2017-08-02T17:53:53.480652Z 2 [Note] WSREP: Local UUID: 00000000-0000-0000-0000-000000000000 != Group UUID: a8d37d7e-5c3b-11e7-9fbf-36d50cc17d69 2017-08-02T17:53:53.480700Z 2 [Note] WSREP: State gap can’t be serviced using IST. Switching to SST 2017-08-02T17:53:53.484059Z 0 [Note] WSREP: Member 1.0 (ip-172-31-44-195) requested state transfer from ‘_any_’. Selected 0.0 (teste-mha-01)(SYNCED) as donor. 2017-08-02T17:53:53.484124Z 0 [Note] WSREP: Shifting PRIMARY → JOINER (TO: 163765) 2017-08-02T17:53:53.484178Z 2 [Note] WSREP: Requesting state transfer: success, donor: 0 2017-08-02T17:53:53.484228Z 2 [Note] WSREP: GCache history reset: old(00000000-0000-0000-0000-000000000000:0) → new(a8d37d7e-5c3b-11e7-9fbf-36d50cc17d69:163765) 2017-08-02T17:53:53.783247Z 0 [Warning] WSREP: 0.0 (teste-mha-01): State transfer to 1.0 (ip-172-31-44-195) failed: -1 (Operation not permitted) 2017-08-02T17:53:53.783285Z 0 [ERROR] WSREP: gcs/src/gcs\_group.cpp:gcs\_group\_handle\_join\_msg():765: Will never receive state. Need to abort. 2017-08-02T17:53:53.783311Z 0 [Note] WSREP: gcomm: terminating thread 2017-08-02T17:53:53.783322Z 0 [Note] WSREP: gcomm: joining thread 2017-08-02T17:53:53.783427Z 0 [Note] WSREP: gcomm: closing backend 2017-08-02T17:53:55.901258Z 0 [Note] WSREP: (8ba437fc, ‘tcp://0.0.0.0:4567’) connection to peer 8ba437fc with addr tcp://172.31.44.195:4567 timed out, no messages seen in PT3S 2017-08-02T17:53:55.901359Z 0 [Note] WSREP: (8ba437fc, ‘tcp://0.0.0.0:4567’) turning message relay requesting off 2017-08-02T17:53:56.901252Z 0 [Note] WSREP: (8ba437fc, ‘tcp://0.0.0.0:4567’) connection to peer 1e73c129 with addr tcp://10.10.10.101:4567 timed out, no messages seen in PT3S 2017-08-02T17:53:56.901380Z 0 [Note] WSREP: (8ba437fc, ‘tcp://0.0.0.0:4567’) turning message relay requesting on, nonlive peers: tcp://10.10.10.101:4567 2017-08-02T17:53:58.401257Z 0 [Note] WSREP: (8ba437fc, ‘tcp://0.0.0.0:4567’) reconnecting to 1e73c129 (tcp://10.10.10.101:4567), attempt 0 2017-08-02T17:54:01.901275Z 0 [Note] WSREP: (8ba437fc, ‘tcp://0.0.0.0:4567’) connection to peer 1e73c129 with addr tcp://10.10.10.101:4567 timed out, no messages seen in PT3S 2017-08-02T17:54:03.416832Z 0 [Note] WSREP: (8ba437fc, ‘tcp://0.0.0.0:4567’) connection established to 1e73c129 tcp://10.10.10.101:4567 2017-08-02T17:54:06.901292Z 0 [Note] WSREP: (8ba437fc, ‘tcp://0.0.0.0:4567’) turning message relay requesting off 2017-08-02T17:54:13.783506Z 0 [Note] WSREP: Current view of cluster as seen by this node view (view\_id(NON\_PRIM,1e73c129,10) 2017-08-02T17:54:13.783559Z 0 [Note] WSREP: Current view of cluster as seen by this node view ((empty)) 2017-08-02T17:54:13.783710Z 0 [Note] WSREP: gcomm: closed 2017-08-02T17:54:13.783729Z 0 [Note] WSREP: /usr/sbin/mysqld: Terminated. Job for mysql.service failed because the control process exited with error code. See “systemctl status mysql.service” and “journalctl -xe” for details.