# Percona XtraDB, Question to the experts!!!    ;)

**URL:** <https://forums.percona.com/t/percona-xtradb-question-to-the-experts/4334>\
**Category:** Percona XtraDB Cluster 5.x\
**Created:** [August 7, 2015, 2:22am UTC](https://forums.percona.com/t/percona-xtradb-question-to-the-experts/4334 "2015-08-07T02:22:47Z")\
**Posts on this page:** 1\
**Showing post:** 4

<div class="post-metadata">

**Author:** ![edudril](https://avatars.discourse-cdn.com/v4/letter/e/3da27b/32.png) [@edudril](https://forums.percona.com/u/edudril)\
**Post date:** [August 10, 2015, 6:42am UTC](https://forums.percona.com/t/percona-xtradb-question-to-the-experts/4334/4 "2015-08-10T06:42:39Z")

</div>

I Attach the LOG server B

150810 13:57:35 mysqld\_safe Starting mysqld daemon with databases from /DATAMYSQL/data1  
150810 13:57:35 mysqld\_safe Skipping wsrep-recover for d829d797-3b46-11e5-9872-8a946f5b1e06:2732 pair  
150810 13:57:35 mysqld\_safe Assigning d829d797-3b46-11e5-9872-8a946f5b1e06:2732 to wsrep\_start\_position  
2015-08-10 13:57:35 0 [Note] WSREP: wsrep\_start\_position var submitted: ‘d829d797-3b46-11e5-9872-8a946f5b1e06:2732’  
2015-08-10 13:57:35 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit\_defaults\_for\_timestamp server option (see do cumentation for more details).  
2015-08-10 13:57:35 30483 [Note] WSREP: Read nil XID from storage engines, skipping position init  
2015-08-10 13:57:35 30483 [Note] WSREP: wsrep\_load(): loading provider library ‘/usr/lib64/galera3/libgalera\_smm.so’  
2015-08-10 13:57:35 30483 [Note] WSREP: wsrep\_load(): Galera 3.6(r3a949e6) by Codership Oy \<info@codership.com\> loaded successfully.  
2015-08-10 13:57:35 30483 [Note] WSREP: CRC-32C: using hardware acceleration.  
2015-08-10 13:57:35 30483 [Note] WSREP: Found saved state: d829d797-3b46-11e5-9872-8a946f5b1e06:2732  
2015-08-10 13:57:35 30483 [Note] WSREP: Passing config to GCS: base\_host = 10.252.141.83; base\_port = 4567; cert.log\_conflicts = no; debug = no; evs.in active\_check\_period = PT0.5S; evs.inactive\_timeout = PT15S; evs.join\_retrans\_period = PT1S; evs.max\_install\_timeouts = 3; evs.send\_window = 4; evs.stat s\_report\_period = PT1M; evs.suspect\_timeout = PT5S; evs.user\_send\_window = 2; evs.view\_forget\_timeout = PT24H; gcache.dir = /DATAMYSQL/data1/; gcache.k eep\_pages\_size = 0; gcache.mem\_size = 0; gcache.name = /DATAMYSQL/data1//galera.cache; gcache.page\_size = 1G; gcache.size = 4G; gcs.fc\_debug = 0; gcs.f c\_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 = 922337203685 4775807; 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 = P30S; pc.w  
2015-08-10 13:57:35 30483 [Note] WSREP: Service thread queue flushed.  
2015-08-10 13:57:35 30483 [Note] WSREP: Assign initial position for certification: 2732, protocol version: -1  
2015-08-10 13:57:35 30483 [Note] WSREP: wsrep\_sst\_grab()  
2015-08-10 13:57:35 30483 [Note] WSREP: Start replication  
2015-08-10 13:57:35 30483 [Note] WSREP: Setting initial position to d829d797-3b46-11e5-9872-8a946f5b1e06:2732  
2015-08-10 13:57:35 30483 [Note] WSREP: protonet asio version 0  
2015-08-10 13:57:35 30483 [Note] WSREP: Using CRC-32C (optimized) for message checksums.  
2015-08-10 13:57:35 30483 [Note] WSREP: backend: asio  
2015-08-10 13:57:35 30483 [Warning] WSREP: access file(gvwstate.dat) failed(No such file or directory)  
2015-08-10 13:57:35 30483 [Note] WSREP: restore pc from disk failed  
2015-08-10 13:57:35 30483 [Note] WSREP: GMCast version 0  
2015-08-10 13:57:35 30483 [Note] WSREP: (fd6ee2ea, ‘tcp://0.0.0.0:4567’) listening at tcp://0.0.0.0:4567  
2015-08-10 13:57:35 30483 [Note] WSREP: (fd6ee2ea, ‘tcp://0.0.0.0:4567’) multicast: , ttl: 1  
2015-08-10 13:57:35 30483 [Note] WSREP: EVS version 0  
2015-08-10 13:57:35 30483 [Note] WSREP: PC version 0  
2015-08-10 13:57:35 30483 [Note] WSREP: gcomm: connecting to group ‘mysqlclusterpre’, peer ‘10.252.141.82:,10.252.141.83:’  
2015-08-10 13:57:35 30483 [Warning] WSREP: (fd6ee2ea, ‘tcp://0.0.0.0:4567’) address ‘tcp://10.252.141.83:4567’ points to own listening address, blackli sting  
2015-08-10 13:57:35 30483 [Note] WSREP: (fd6ee2ea, ‘tcp://0.0.0.0:4567’) address ‘tcp://10.252.141.83:4567’ pointing to uuid fd6ee2ea is blacklisted, s kipping  
2015-08-10 13:57:35 30483 [Note] WSREP: (fd6ee2ea, ‘tcp://0.0.0.0:4567’) turning message relay requesting on, nonlive peers:  
2015-08-10 13:57:36 30483 [Note] WSREP: declaring fd8eae56 at tcp://10.252.141.82:4567 stable  
2015-08-10 13:57:36 30483 [Note] WSREP: Node fd8eae56 state prim  
2015-08-10 13:57:36 30483 [Note] WSREP: save pc into disk  
2015-08-10 13:57:36 30483 [Note] WSREP: gcomm: connected  
2015-08-10 13:57:36 30483 [Note] WSREP: Changing maximum packet size to 64500, resulting msg size: 32636  
2015-08-10 13:57:36 30483 [Note] WSREP: Shifting CLOSED → OPEN (TO: 0)  
2015-08-10 13:57:36 30483 [Note] WSREP: Opened channel ‘mysqlclusterpre’  
2015-08-10 13:57:36 30483 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my\_idx = 0, memb\_num = 2  
2015-08-10 13:57:36 30483 [Note] WSREP: Waiting for SST to complete.  
2015-08-10 13:57:36 30483 [Note] WSREP: STATE\_EXCHANGE: sent state UUID: fe083d53-3f56-11e5-ba02-0a7273d42abe  
2015-08-10 13:57:36 30483 [Note] WSREP: STATE EXCHANGE: sent state msg: fe083d53-3f56-11e5-ba02-0a7273d42abe  
2015-08-10 13:57:36 30483 [Note] WSREP: STATE EXCHANGE: got state msg: fe083d53-3f56-11e5-ba02-0a7273d42abe from 0 (myinfprese02)  
2015-08-10 13:57:36 30483 [Note] WSREP: STATE EXCHANGE: got state msg: fe083d53-3f56-11e5-ba02-0a7273d42abe from 1 (myinfprema02)  
2015-08-10 13:57:36 30483 [Note] WSREP: Quorum results:  
version = 3,  
component = PRIMARY,  
conf\_id = 1,  
members = 1/2 (joined/total),  
act\_id = 2731,  
last\_appl. = -1,  
protocols = 0/6/3 (gcs/repl/appl),  
group UUID = d829d797-3b46-11e5-9872-8a946f5b1e06  
2015-08-10 13:57:36 30483 [Note] WSREP: Flow-control interval: [23, 23]  
2015-08-10 13:57:36 30483 [Note] WSREP: Shifting OPEN → PRIMARY (TO: 2731)  
2015-08-10 13:57:36 30483 [Note] WSREP: Closing send monitor…  
2015-08-10 13:57:36 30483 [Note] WSREP: Closed send monitor.  
2015-08-10 13:57:36 30483 [Note] WSREP: gcomm: terminating thread  
2015-08-10 13:57:36 30483 [Note] WSREP: gcomm: joining thread  
2015-08-10 13:57:36 30483 [Note] WSREP: gcomm: closing backend  
2015-08-10 13:57:37 30483 [Note] WSREP: New COMPONENT: primary = no, bootstrap = no, my\_idx = 0, memb\_num = 1  
2015-08-10 13:57:37 30483 [Note] WSREP: gcomm: closed  
2015-08-10 13:57:37 30483 [Note] WSREP: Flow-control interval: [16, 16]  
2015-08-10 13:57:37 30483 [Note] WSREP: Received NON-PRIMARY.  
2015-08-10 13:57:37 30483 [Note] WSREP: Shifting PRIMARY → OPEN (TO: 2731)  
2015-08-10 13:57:37 30483 [Note] WSREP: Received self-leave message.  
2015-08-10 13:57:37 30483 [Note] WSREP: Flow-control interval: [0, 0]  
2015-08-10 13:57:37 30483 [Note] WSREP: Received SELF-LEAVE. Closing connection.  
2015-08-10 13:57:37 30483 [Note] WSREP: Shifting OPEN → CLOSED (TO: 2731)  
2015-08-10 13:57:37 30483 [Note] WSREP: RECV thread exiting 0: Success  
2015-08-10 13:57:37 30483 [Note] WSREP: recv\_thread() joined.  
2015-08-10 13:57:37 30483 [Note] WSREP: Closing replication queue.  
2015-08-10 13:57:37 30483 [Note] WSREP: Closing slave action queue.  
2015-08-10 13:57:37 30483 [ERROR] WSREP: Local state seqno (2732) is greater than group seqno (2731): states diverged. Aborting to avoid potential data loss. Remove ‘/DATAMYSQL/data1//grastate.dat’ file and restart if you wish to continue. (FATAL)  
at galera/src/replicator\_str.cpp:state\_transfer\_required():33  
2015-08-10 13:57:37 30483 [Note] WSREP: applier thread exiting (code:8)  
2015-08-10 13:57:37 30483 [ERROR] Aborting

2015-08-10 13:57:39 30483 [Note] WSREP: Service disconnected.  
2015-08-10 13:57:39 30483 [Note] WSREP: rollbacker thread exiting  
2015-08-10 13:57:40 30483 [Note] WSREP: Some threads may fail to exit.  
2015-08-10 13:57:40 30483 [Note] Binlog end  
2015-08-10 13:57:40 30483 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete

Error in my\_thread\_global\_end(): 1 threads didn’t exit  
150810 13:57:45 mysqld\_safe mysqld from pid file /DATAMYSQL/data1/mysql.pid ended

---

_[View the full topic](https://forums.percona.com/t/percona-xtradb-question-to-the-experts/4334)._
