# First joiner cannot start **URL:** \ **Category:** Percona XtraDB Cluster 5.x\ **Created:** [October 31, 2018, 6:22am UTC](https://forums.percona.com/t/first-joiner-cannot-start/6663 "2018-10-31T06:22:20Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![elkhedewy](https://avatars.discourse-cdn.com/v4/letter/e/5fc32e/32.png) [@elkhedewy](https://forums.percona.com/u/elkhedewy)\ **Post date:** [October 31, 2018, 6:22am UTC](https://forums.percona.com/t/first-joiner-cannot-start/6663/1 "2018-10-31T06:22:20Z")
Hello, I have a problem with xtradb cluster 5.6 with centos 7. After starting the donor systemctl start [mysql@bootstrap.service](mailto:mysql@bootstrap.service) It works fine.but when try to start the joiner using service mysql start i get the error log on the joiner: ==\> /var/log/messages \<== > [@](#): > > Oct 31 13:47:27 ppdb02 systemd: Starting Percona XtraDB Cluster… > Oct 31 13:47:28 ppdb02 mysql-systemd: 2018-10-31 13:47:28 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit\_defaults\_for\_timestamp server option (see documentation for more details). > Oct 31 13:47:28 ppdb02 mysql-systemd: 2018-10-31 13:47:28 0 [Note] Ignoring --secure-file-priv value as server is running with --bootstrap. > Oct 31 13:47:28 ppdb02 mysql-systemd: 2018-10-31 13:47:28 0 [Note] /usr/sbin/mysqld (mysqld 5.6.41-84.1-56) starting as process 1291 … > Oct 31 13:47:28 ppdb02 mysql-systemd: 2018-10-31 13:47:28 1291 [Note] WSREP: Setting wsrep\_ready to false > Oct 31 13:47:28 ppdb02 mysql-systemd: 2018-10-31 13:47:28 1291 [Note] WSREP: Read nil XID from storage engines, skipping position init > Oct 31 13:47:28 ppdb02 mysql-systemd: 2018-10-31 13:47:28 1291 [Note] WSREP: wsrep\_load(): loading provider library ‘none’ > Oct 31 13:47:28 ppdb02 mysql-systemd: 2018-10-31 13:47:28 1291 [Note] WSREP: Setting wsrep\_ready to true > Oct 31 13:47:28 ppdb02 mysql-systemd: 2018-10-31 13:47:28 1291 [Note] InnoDB: innodb\_empty\_free\_list\_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB. > Oct 31 13:47:28 ppdb02 mysql-systemd: 2018-10-31 13:47:28 1291 [Note] InnoDB: Using atomics to ref count buffer pool pages > Oct 31 13:47:28 ppdb02 mysql-systemd: 2018-10-31 13:47:28 1291 [Note] InnoDB: The InnoDB memory heap is disabled > Oct 31 13:47:28 ppdb02 mysql-systemd: 2018-10-31 13:47:28 1291 [Note] InnoDB: Mutexes and rw\_locks use GCC atomic builtins > Oct 31 13:47:28 ppdb02 mysql-systemd: 2018-10-31 13:47:28 1291 [Note] InnoDB: Memory barrier is not used > Oct 31 13:47:28 ppdb02 mysql-systemd: 2018-10-31 13:47:28 1291 [Note] InnoDB: Compressed tables use zlib 1.2.7 > Oct 31 13:47:28 ppdb02 mysql-systemd: 2018-10-31 13:47:28 1291 [Note] InnoDB: Using Linux native AIO > Oct 31 13:47:28 ppdb02 mysql-systemd: 2018-10-31 13:47:28 1291 [Note] InnoDB: Using CPU crc32 instructions > Oct 31 13:47:28 ppdb02 mysql-systemd: 2018-10-31 13:47:28 1291 [Note] InnoDB: Initializing buffer pool, size = 128.0M > Oct 31 13:47:28 ppdb02 mysql-systemd: 2018-10-31 13:47:28 1291 [Note] InnoDB: Completed initialization of buffer pool > Oct 31 13:47:28 ppdb02 mysql-systemd: 2018-10-31 13:47:28 1291 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created! > Oct 31 13:47:28 ppdb02 mysql-systemd: 2018-10-31 13:47:28 1291 [Note] InnoDB: Setting file ./ibdata1 size to 12 MB > Oct 31 13:47:28 ppdb02 mysql-systemd: 2018-10-31 13:47:28 1291 [Note] InnoDB: Database physically writes the file full: wait… > Oct 31 13:47:28 ppdb02 mysql-systemd: 2018-10-31 13:47:28 1291 [Note] InnoDB: Setting log file ./ib\_logfile101 size to 48 MB > Oct 31 13:47:28 ppdb02 mysql-systemd: 2018-10-31 13:47:28 1291 [Note] InnoDB: Setting log file ./ib\_logfile1 size to 48 MB > Oct 31 13:47:29 ppdb02 mysql-systemd: 2018-10-31 13:47:29 1291 [Note] InnoDB: Renaming log file ./ib\_logfile101 to ./ib\_logfile0 > Oct 31 13:47:29 ppdb02 mysql-systemd: 2018-10-31 13:47:29 1291 [Warning] InnoDB: New log files created, LSN=45781 > Oct 31 13:47:29 ppdb02 mysql-systemd: 2018-10-31 13:47:29 1291 [Note] InnoDB: Doublewrite buffer not found: creating new > Oct 31 13:47:29 ppdb02 mysql-systemd: 2018-10-31 13:47:29 1291 [Note] InnoDB: Doublewrite buffer created > Oct 31 13:47:29 ppdb02 mysql-systemd: 2018-10-31 13:47:29 1291 [Note] InnoDB: 128 rollback segment(s) are active. > Oct 31 13:47:29 ppdb02 mysql-systemd: 2018-10-31 13:47:29 1291 [Warning] InnoDB: Creating foreign key constraint system tables. > Oct 31 13:47:29 ppdb02 mysql-systemd: 2018-10-31 13:47:29 1291 [Note] InnoDB: Foreign key constraint system tables created > Oct 31 13:47:29 ppdb02 mysql-systemd: 2018-10-31 13:47:29 1291 [Note] InnoDB: Creating tablespace and datafile system tables. > Oct 31 13:47:29 ppdb02 mysql-systemd: 2018-10-31 13:47:29 1291 [Note] InnoDB: Tablespace and datafile system tables created. > Oct 31 13:47:29 ppdb02 mysql-systemd: 2018-10-31 13:47:29 1291 [Note] InnoDB: Creating zip\_dict and zip\_dict\_cols system tables. > Oct 31 13:47:29 ppdb02 mysql-systemd: 2018-10-31 13:47:29 1291 [Note] InnoDB: zip\_dict and zip\_dict\_cols system tables created. > Oct 31 13:47:29 ppdb02 mysql-systemd: 2018-10-31 13:47:29 1291 [Note] InnoDB: Waiting for purge to start > Oct 31 13:47:29 ppdb02 mysql-systemd: 2018-10-31 13:47:29 1291 [Note] InnoDB: Percona XtraDB ([http://www.percona.com](http://www.percona.com)) 5.6.41-84.1 started; log sequence number 0 > Oct 31 13:47:29 ppdb02 mysql-systemd: 2018-10-31 13:47:29 1291 [Note] RSA private key file not found: /var/lib/mysql//private\_key.pem. Some authentication plugins will not work. > Oct 31 13:47:29 ppdb02 mysql-systemd: 2018-10-31 13:47:29 1291 [Note] RSA public key file not found: /var/lib/mysql//public\_key.pem. Some authentication plugins will not work. > Oct 31 13:47:29 ppdb02 mysql-systemd: 2018-10-31 13:47:29 1291 [Note] WSREP: Service disconnected. > Oct 31 13:47:29 ppdb02 mysql-systemd: 2018-10-31 13:47:29 1291 [Note] WSREP: Waiting to close threads… > Oct 31 13:47:34 ppdb02 mysql-systemd: 2018-10-31 13:47:34 1291 [Note] WSREP: Some threads may fail to exit. > Oct 31 13:47:34 ppdb02 mysql-systemd: 2018-10-31 13:47:34 1291 [Note] Binlog end > Oct 31 13:47:34 ppdb02 mysql-systemd: 2018-10-31 13:47:34 1291 [Note] InnoDB: FTS optimize thread exiting. > Oct 31 13:47:34 ppdb02 mysql-systemd: 2018-10-31 13:47:34 1291 [Note] InnoDB: Starting shutdown… > Oct 31 13:47:35 ppdb02 mysql-systemd: 2018-10-31 13:47:35 1291 [Note] InnoDB: Waiting for page\_cleaner to finish flushing of buffer pool > Oct 31 13:47:37 ppdb02 mysql-systemd: 2018-10-31 13:47:37 1291 [Note] InnoDB: Shutdown completed; log sequence number 1631996 > Oct 31 13:47:37 ppdb02 mysql-systemd: 2018-10-31 13:47:37 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit\_defaults\_for\_timestamp server option (see documentation for more details). > Oct 31 13:47:37 ppdb02 mysql-systemd: 2018-10-31 13:47:37 0 [Note] Ignoring --secure-file-priv value as server is running with --bootstrap. > Oct 31 13:47:37 ppdb02 mysql-systemd: 2018-10-31 13:47:37 0 [Note] /usr/sbin/mysqld (mysqld 5.6.41-84.1-56) starting as process 1315 … > Oct 31 13:47:37 ppdb02 mysql-systemd: 2018-10-31 13:47:37 1315 [Note] WSREP: Setting wsrep\_ready to false > Oct 31 13:47:37 ppdb02 mysql-systemd: 2018-10-31 13:47:37 1315 [Note] WSREP: Read nil XID from storage engines, skipping position init > Oct 31 13:47:37 ppdb02 mysql-systemd: 2018-10-31 13:47:37 1315 [Note] WSREP: wsrep\_load(): loading provider library ‘none’ > Oct 31 13:47:37 ppdb02 mysql-systemd: 2018-10-31 13:47:37 1315 [Note] WSREP: Setting wsrep\_ready to true > Oct 31 13:47:37 ppdb02 mysql-systemd: 2018-10-31 13:47:37 1315 [Note] InnoDB: innodb\_empty\_free\_list\_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB. > Oct 31 13:47:37 ppdb02 mysql-systemd: 2018-10-31 13:47:37 1315 [Note] InnoDB: Using atomics to ref count buffer pool pages > Oct 31 13:47:37 ppdb02 mysql-systemd: 2018-10-31 13:47:37 1315 [Note] InnoDB: The InnoDB memory heap is disabled > Oct 31 13:47:37 ppdb02 mysql-systemd: 2018-10-31 13:47:37 1315 [Note] InnoDB: Mutexes and rw\_locks use GCC atomic builtins > Oct 31 13:47:37 ppdb02 mysql-systemd: 2018-10-31 13:47:37 1315 [Note] InnoDB: Memory barrier is not used > Oct 31 13:47:37 ppdb02 mysql-systemd: 2018-10-31 13:47:37 1315 [Note] InnoDB: Compressed tables use zlib 1.2.7 > Oct 31 13:47:37 ppdb02 mysql-systemd: 2018-10-31 13:47:37 1315 [Note] InnoDB: Using Linux native AIO > Oct 31 13:47:37 ppdb02 mysql-systemd: 2018-10-31 13:47:37 1315 [Note] InnoDB: Using CPU crc32 instructions > Oct 31 13:47:37 ppdb02 mysql-systemd: 2018-10-31 13:47:37 1315 [Note] InnoDB: Initializing buffer pool, size = 128.0M > Oct 31 13:47:37 ppdb02 mysql-systemd: 2018-10-31 13:47:37 1315 [Note] InnoDB: Completed initialization of buffer pool > Oct 31 13:47:37 ppdb02 mysql-systemd: 2018-10-31 13:47:37 1315 [Note] InnoDB: Highest supported file format is Barracuda. > Oct 31 13:47:37 ppdb02 mysql-systemd: 2018-10-31 13:47:37 1315 [Note] InnoDB: 128 rollback segment(s) are active. > Oct 31 13:47:37 ppdb02 mysql-systemd: 2018-10-31 13:47:37 1315 [Note] InnoDB: Waiting for purge to start > Oct 31 13:47:37 ppdb02 mysql-systemd: 2018-10-31 13:47:37 1315 [Note] InnoDB: Percona XtraDB ([http://www.percona.com](http://www.percona.com)) 5.6.41-84.1 started; log sequence number 1631996 > Oct 31 13:47:37 ppdb02 mysql-systemd: 2018-10-31 13:47:37 1315 [Note] RSA private key file not found: /var/lib/mysql//private\_key.pem. Some authentication plugins will not work. > Oct 31 13:47:37 ppdb02 mysql-systemd: 2018-10-31 13:47:37 1315 [Note] RSA public key file not found: /var/lib/mysql//public\_key.pem. Some authentication plugins will not work. > Oct 31 13:47:37 ppdb02 mysql-systemd: 2018-10-31 13:47:37 1315 [Note] WSREP: Service disconnected. > Oct 31 13:47:37 ppdb02 mysql-systemd: 2018-10-31 13:47:37 1315 [Note] WSREP: Waiting to close threads… > Oct 31 13:47:42 ppdb02 mysql-systemd: 2018-10-31 13:47:42 1315 [Note] WSREP: Some threads may fail to exit. > Oct 31 13:47:42 ppdb02 mysql-systemd: 2018-10-31 13:47:42 1315 [Note] Binlog end > Oct 31 13:47:42 ppdb02 mysql-systemd: 2018-10-31 13:47:42 1315 [Note] InnoDB: FTS optimize thread exiting. > Oct 31 13:47:42 ppdb02 mysql-systemd: 2018-10-31 13:47:42 1315 [Note] InnoDB: Starting shutdown… > Oct 31 13:47:43 ppdb02 mysql-systemd: 2018-10-31 13:47:43 1315 [Note] InnoDB: Waiting for page\_cleaner to finish flushing of buffer pool > Oct 31 13:47:45 ppdb02 mysql-systemd: 2018-10-31 13:47:45 1315 [Note] InnoDB: Shutdown completed; log sequence number 1632006 > Oct 31 13:47:45 ppdb02 mysql-systemd: PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! > Oct 31 13:47:45 ppdb02 mysql-systemd: To do so, start the server, then issue the following commands: > Oct 31 13:47:45 ppdb02 mysql-systemd: /usr/bin/mysqladmin -u root password ‘new-password’ > Oct 31 13:47:45 ppdb02 mysql-systemd: /usr/bin/mysqladmin -u root -h ppdb02 password ‘new-password’ > Oct 31 13:47:45 ppdb02 mysql-systemd: Alternatively you can run: > Oct 31 13:47:45 ppdb02 mysql-systemd: /usr/bin/mysql\_secure\_installation > Oct 31 13:47:45 ppdb02 mysql-systemd: which will also give you the option of removing the test > Oct 31 13:47:45 ppdb02 mysql-systemd: databases and anonymous user created by default. This is > Oct 31 13:47:45 ppdb02 mysql-systemd: strongly recommended for production servers. > Oct 31 13:47:45 ppdb02 mysql-systemd: See the manual for more instructions. > Oct 31 13:47:45 ppdb02 mysql-systemd: Please report any problems with Percona XtraDB Cluster 5.6 at [https://jira.percona.com/projects/PXC/issues](https://jira.percona.com/projects/PXC/issues) > Oct 31 13:47:45 ppdb02 mysql-systemd: The latest information about Percona XtraDB Cluster 5.6 is available on the web at > Oct 31 13:47:45 ppdb02 mysql-systemd: [http://www.percona.com/doc/percona-xtradb-cluster/5.6/](http://www.percona.com/doc/percona-xtradb-cluster/5.6/) > Oct 31 13:47:45 ppdb02 mysql-systemd: Support Percona XtraDB Cluster 5.6 by buying support at [http://www.percona.com/products/mysql-support](http://www.percona.com/products/mysql-support) > Oct 31 13:47:45 ppdb02 mysql-systemd: WARNING: Default config file /etc/my.cnf exists on the system > Oct 31 13:47:45 ppdb02 mysql-systemd: This file will be read by default by the MySQL server > Oct 31 13:47:45 ppdb02 mysql-systemd: If you do not want to use this, either remove it, or use the > Oct 31 13:47:45 ppdb02 mysql-systemd: --defaults-file argument to mysqld\_safe when starting the server > Oct 31 13:47:45 ppdb02 mysqld\_safe: Logging to ‘/var/lib/mysql/ppdb02.err’. > Oct 31 13:47:45 ppdb02 mysqld\_safe: 181031 13:47:45 mysqld\_safe Starting mysqld daemon with databases from /var/lib/mysql > Oct 31 13:47:45 ppdb02 mysqld\_safe: 181031 13:47:45 mysqld\_safe Skipping wsrep-recover for empty datadir: /var/lib/mysql > Oct 31 13:47:45 ppdb02 mysqld\_safe: 181031 13:47:45 mysqld\_safe Assigning 00000000-0000-0000-0000-000000000000:-1 to wsrep\_start\_position > tail: ‘/var/lib/mysql/ppdb02.err’ has appeared; following end of new file ==\> /var/lib/mysql/ppdb02.err \<== > [@](#): > > 2018-10-31 13:47:45 1560 [Note] WSREP: Setting wsrep\_ready to false > 2018-10-31 13:47:45 1560 [Note] WSREP: Read nil XID from storage engines, skipping position init > 2018-10-31 13:47:45 1560 [Note] WSREP: wsrep\_load(): loading provider library ‘/usr/lib64/galera3/libgalera\_smm.so’ > 2018-10-31 13:47:46 1560 [Note] WSREP: wsrep\_load(): Galera 3.28(rf216443) by Codership Oy \ loaded successfully. > 2018-10-31 13:47:46 1560 [Note] WSREP: CRC-32C: using hardware acceleration. > 2018-10-31 13:47:46 1560 [Warning] WSREP: Could not open state file for reading: ‘/var/lib/mysql//grastate.dat’ > 2018-10-31 13:47:46 1560 [Note] WSREP: Found saved state: 00000000-0000-0000-0000-000000000000:-1, safe\_to\_bootstrap: 1 > 2018-10-31 13:47:46 1560 [Note] WSREP: Passing config to GCS: base\_dir = /var/lib/mysql/; base\_host = 10.151.158.53; 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 = 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\_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.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.segment = 0; gmcast.version = 0; pc.announce\_timeout = P > 2018-10-31 13:47:46 1560 [Note] WSREP: GCache history reset: 00000000-0000-0000-0000-000000000000:0 → 00000000-0000-0000-0000-000000000000:-1 > 2018-10-31 13:47:46 1560 [Note] WSREP: Assign initial position for certification: -1, protocol version: -1 > 2018-10-31 13:47:46 1560 [Note] WSREP: wsrep\_sst\_grab() > 2018-10-31 13:47:46 1560 [Note] WSREP: Start replication > 2018-10-31 13:47:46 1560 [Note] WSREP: Setting initial position to 00000000-0000-0000-0000-000000000000:-1 > 2018-10-31 13:47:46 1560 [Note] WSREP: protonet asio version 0 > 2018-10-31 13:47:46 1560 [Note] WSREP: Using CRC-32C for message checksums. > 2018-10-31 13:47:46 1560 [Note] WSREP: backend: asio > 2018-10-31 13:47:46 1560 [Note] WSREP: gcomm thread scheduling priority set to other:0 > 2018-10-31 13:47:46 1560 [Warning] WSREP: access file(/var/lib/mysql//gvwstate.dat) failed(No such file or directory) > 2018-10-31 13:47:46 1560 [Note] WSREP: restore pc from disk failed > 2018-10-31 13:47:46 1560 [Note] WSREP: GMCast version 0 > 2018-10-31 13:47:46 1560 [Note] WSREP: (c89e2379, ‘tcp://0.0.0.0:4567’) listening at tcp://0.0.0.0:4567 > 2018-10-31 13:47:46 1560 [Note] WSREP: (c89e2379, ‘tcp://0.0.0.0:4567’) multicast: , ttl: 1 > 2018-10-31 13:47:46 1560 [Note] WSREP: EVS version 0 > 2018-10-31 13:47:46 1560 [Note] WSREP: gcomm: connecting to group ‘patientportal\_cluster’, peer ‘10.151.158.54:’ > 2018-10-31 13:47:46 1560 [Note] WSREP: (c89e2379, ‘tcp://0.0.0.0:4567’) connection established to f13cb957 tcp://10.151.158.54:4567 > 2018-10-31 13:47:46 1560 [Note] WSREP: (c89e2379, ‘tcp://0.0.0.0:4567’) turning message relay requesting on, nonlive peers: > 2018-10-31 13:47:46 1560 [Note] WSREP: declaring f13cb957 at tcp://10.151.158.54:4567 stable > 2018-10-31 13:47:46 1560 [Note] WSREP: Node f13cb957 state prim > 2018-10-31 13:47:46 1560 [Note] WSREP: view(view\_id(PRIM,c89e2379,20) memb { > c89e2379,0 > f13cb957,0 > } joined { > } left { > } partitioned { > }) > 2018-10-31 13:47:46 1560 [Note] WSREP: save pc into disk > 2018-10-31 13:47:47 1560 [Note] WSREP: gcomm: connected > 2018-10-31 13:47:47 1560 [Note] WSREP: Changing maximum packet size to 64500, resulting msg size: 32636 > 2018-10-31 13:47:47 1560 [Note] WSREP: Shifting CLOSED → OPEN (TO: 0) > 2018-10-31 13:47:47 1560 [Note] WSREP: Opened channel ‘patientportal\_cluster’ > 2018-10-31 13:47:47 1560 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my\_idx = 0, memb\_num = 2 > 2018-10-31 13:47:47 1560 [Note] WSREP: Waiting for SST to complete. > 2018-10-31 13:47:47 1560 [Note] WSREP: STATE\_EXCHANGE: sent state UUID: c93759ba-dd02-11e8-a9bf-0e0491c2749d > 2018-10-31 13:47:47 1560 [Note] WSREP: STATE EXCHANGE: sent state msg: c93759ba-dd02-11e8-a9bf-0e0491c2749d > 2018-10-31 13:47:47 1560 [Note] WSREP: STATE EXCHANGE: got state msg: c93759ba-dd02-11e8-a9bf-0e0491c2749d from 0 (ppdb02) > 2018-10-31 13:47:47 1560 [Note] WSREP: STATE EXCHANGE: got state msg: c93759ba-dd02-11e8-a9bf-0e0491c2749d from 1 (ppdb03) > 2018-10-31 13:47:47 1560 [Note] WSREP: Quorum results: > version = 4, > component = PRIMARY, > conf\_id = 19, > members = 1/2 (joined/total), > act\_id = 12, > last\_appl. = -1, > protocols = 0/9/3 (gcs/repl/appl), > group UUID = f13dad00-dcfc-11e8-8c32-ef5fdea501de > 2018-10-31 13:47:47 1560 [Note] WSREP: Flow-control interval: [23, 23] > 2018-10-31 13:47:47 1560 [Note] WSREP: Trying to continue unpaused monitor > 2018-10-31 13:47:47 1560 [Note] WSREP: Shifting OPEN → PRIMARY (TO: 12) > 2018-10-31 13:47:47 1560 [Note] WSREP: State transfer required: > Group state: f13dad00-dcfc-11e8-8c32-ef5fdea501de:12 > Local state: 00000000-0000-0000-0000-000000000000:-1 > 2018-10-31 13:47:47 1560 [Note] WSREP: New cluster view: global state: f13dad00-dcfc-11e8-8c32-ef5fdea501de:12, view# 20: Primary, number of nodes: 2, my index: 0, protocol version 3 > 2018-10-31 13:47:47 1560 [Note] WSREP: Setting wsrep\_ready to true > 2018-10-31 13:47:47 1560 [Warning] WSREP: Gap in state sequence. Need state transfer. > 2018-10-31 13:47:47 1560 [Note] WSREP: Setting wsrep\_ready to false > 2018-10-31 13:47:47 1560 [Note] WSREP: Running: 'wsrep\_sst\_xtrabackup-v2 --role ‘joiner’ --address ‘10.151.158.53’ --datadir ‘/var/lib/mysql/’ --defaults-file ‘/etc/my.cnf’ --defaults-group-suffix ‘’ --parent ‘1560’ --mysqld-version ‘5.6.41-84.1-56’ ‘’ ’ > 2018-10-31 13:47:47 1560 [ERROR] WSREP: Failed to read ‘ready ’ from: wsrep\_sst\_xtrabackup-v2 --role ‘joiner’ --address ‘10.151.158.53’ --datadir ‘/var/lib/mysql/’ --defaults-file ‘/etc/my.cnf’ --defaults-group-suffix ‘’ --parent ‘1560’ --mysqld-version ‘5.6.41-84.1-56’ ‘’ > Read: ‘(null)’ > 2018-10-31 13:47:47 1560 [ERROR] WSREP: Process completed with error: wsrep\_sst\_xtrabackup-v2 --role ‘joiner’ --address ‘10.151.158.53’ --datadir ‘/var/lib/mysql/’ --defaults-file ‘/etc/my.cnf’ --defaults-group-suffix ‘’ --parent ‘1560’ --mysqld-version ‘5.6.41-84.1-56’ ‘’ : 2 (No such file or directory) > 2018-10-31 13:47:47 1560 [ERROR] WSREP: Failed to prepare for ‘xtrabackup-v2’ SST. Unrecoverable. > 2018-10-31 13:47:47 1560 [ERROR] Aborting > > 2018-10-31 13:47:49 1560 [Note] WSREP: Closing send monitor… > 2018-10-31 13:47:49 1560 [Note] WSREP: Closed send monitor. > 2018-10-31 13:47:49 1560 [Note] WSREP: gcomm: terminating thread > 2018-10-31 13:47:49 1560 [Note] WSREP: gcomm: joining thread > 2018-10-31 13:47:49 1560 [Note] WSREP: gcomm: closing backend > 2018-10-31 13:47:49 1560 [Note] WSREP: (c89e2379, ‘tcp://0.0.0.0:4567’) turning message relay requesting off > 2018-10-31 13:47:52 1560 [Note] WSREP: (c89e2379, ‘tcp://0.0.0.0:4567’) connection to peer f13cb957 with addr tcp://10.151.158.54:4567 timed out, no messages seen in PT3S > 2018-10-31 13:47:52 1560 [Note] WSREP: (c89e2379, ‘tcp://0.0.0.0:4567’) turning message relay requesting on, nonlive peers: tcp://10.151.158.54:4567 > 2018-10-31 13:47:54 1560 [Note] WSREP: (c89e2379, ‘tcp://0.0.0.0:4567’) reconnecting to f13cb957 (tcp://10.151.158.54:4567), attempt 0 > 2018-10-31 13:47:54 1560 [Note] WSREP: evs::proto(c89e2379, LEAVING, view\_id(REG,c89e2379,20)) suspecting node: f13cb957 > 2018-10-31 13:47:54 1560 [Note] WSREP: evs::proto(c89e2379, LEAVING, view\_id(REG,c89e2379,20)) suspected node without join message, declaring inactive > 2018-10-31 13:47:54 1560 [Note] WSREP: view(view\_id(NON\_PRIM,c89e2379,20) memb { > c89e2379,0 > } joined { > } left { > } partitioned { > f13cb957,0 > }) > 2018-10-31 13:47:54 1560 [Note] WSREP: view((empty)) > 2018-10-31 13:47:54 1560 [Note] WSREP: gcomm: closed > 2018-10-31 13:47:54 1560 [Note] WSREP: New COMPONENT: primary = no, bootstrap = no, my\_idx = 0, memb\_num = 1 > 2018-10-31 13:47:54 1560 [Note] WSREP: Flow-control interval: [16, 16] > 2018-10-31 13:47:54 1560 [Note] WSREP: Trying to continue unpaused monitor > 2018-10-31 13:47:54 1560 [Note] WSREP: Received NON-PRIMARY. > 2018-10-31 13:47:54 1560 [Note] WSREP: Shifting PRIMARY → OPEN (TO: 12) > 2018-10-31 13:47:54 1560 [Note] WSREP: Received self-leave message. > 2018-10-31 13:47:54 1560 [Note] WSREP: Flow-control interval: [0, 0] > 2018-10-31 13:47:54 1560 [Note] WSREP: Trying to continue unpaused monitor > 2018-10-31 13:47:54 1560 [Note] WSREP: Received SELF-LEAVE. Closing connection. > 2018-10-31 13:47:54 1560 [Note] WSREP: Shifting OPEN → CLOSED (TO: 12) > 2018-10-31 13:47:54 1560 [Note] WSREP: RECV thread exiting 0: Success > 2018-10-31 13:47:54 1560 [Note] WSREP: recv\_thread() joined. > 2018-10-31 13:47:54 1560 [Note] WSREP: Closing replication queue. > 2018-10-31 13:47:54 1560 [Note] WSREP: Closing slave action queue. > 2018-10-31 13:47:54 1560 [Note] WSREP: Service disconnected. > 2018-10-31 13:47:54 1560 [Note] WSREP: Waiting to close threads… > 2018-10-31 13:47:54 1560 [Note] WSREP: rollbacker thread exiting > 2018-10-31 13:47:59 1560 [Note] WSREP: Some threads may fail to exit. > 2018-10-31 13:47:59 1560 [Note] Binlog end > 2018-10-31 13:47:59 1560 [Note] /usr/sbin/mysqld: Shutdown complete Any ideas about: 2018-10-31 13:47:47 1560 [Note] WSREP: Running: 'wsrep\_sst\_xtrabackup-v2 --role ‘joiner’ --address ‘10.151.158.53’ --datadir ‘/var/lib/mysql/’ --defaults-file ‘/etc/my.cnf’ --defaults-group-suffix ‘’ --parent ‘1560’ --mysqld-version ‘5.6.41-84.1-56’ ‘’ ’ 2018-10-31 13:47:47 1560 [ERROR] WSREP: Failed to read ‘ready ’ from: wsrep\_sst\_xtrabackup-v2 --role ‘joiner’ --address ‘10.151.158.53’ --datadir ‘/var/lib/mysql/’ --defaults-file ‘/etc/my.cnf’ --defaults-group-suffix ‘’ --parent ‘1560’ --mysqld-version ‘5.6.41-84.1-56’ ‘’ Read: ‘(null)’ 2018-10-31 13:47:47 1560 [ERROR] WSREP: Process completed with error: wsrep\_sst\_xtrabackup-v2 --role ‘joiner’ --address ‘10.151.158.53’ --datadir ‘/var/lib/mysql/’ --defaults-file ‘/etc/my.cnf’ --defaults-group-suffix ‘’ --parent ‘1560’ --mysqld-version ‘5.6.41-84.1-56’ ‘’ : 2 (No such file or directory) 2018-10-31 13:47:47 1560 [ERROR] WSREP: Failed to prepare for ‘xtrabackup-v2’ SST. Unrecoverable. 2018-10-31 13:47:47 1560 [ERROR] Aborting ---
**Author:** ![elkhedewy](https://avatars.discourse-cdn.com/v4/letter/e/5fc32e/32.png) [@elkhedewy](https://forums.percona.com/u/elkhedewy)\ **Post date:** [October 31, 2018, 7:05am UTC](https://forums.percona.com/t/first-joiner-cannot-start/6663/2 "2018-10-31T07:05:40Z")
Sorry for this topic, but i found that selinux is causing the problem. i disabled it and everything work smoothly ---
**Author:** ![lorraine.pocklington](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/lorraine.pocklington/32/37_2.png) [@lorraine.pocklington](https://forums.percona.com/u/lorraine.pocklington)\ **Post date:** [October 31, 2018, 11:59am UTC](https://forums.percona.com/t/first-joiner-cannot-start/6663/3 "2018-10-31T11:59:43Z")
Thanks for the update - there’s a recent blog post here that might be of interest? [url][https://www.percona.com/blog/2018/06/21/enforcing-selinux-with-percona-xtradb-cluster/[/url]](https://www.percona.com/blog/2018/06/21/enforcing-selinux-with-percona-xtradb-cluster/%5B/url%5D)