# my master node dont wakeup after rebbot

**URL:** <https://forums.percona.com/t/my-master-node-dont-wakeup-after-rebbot/6631>\
**Category:** Percona XtraDB Cluster 5.x\
**Created:** [October 15, 2018, 8:08am UTC](https://forums.percona.com/t/my-master-node-dont-wakeup-after-rebbot/6631 "2018-10-15T08:08:54Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![retrosfin](https://avatars.discourse-cdn.com/v4/letter/r/71c47a/32.png) [@retrosfin](https://forums.percona.com/u/retrosfin)\
**Post date:** [October 15, 2018, 8:08am UTC](https://forums.percona.com/t/my-master-node-dont-wakeup-after-rebbot/6631/1 "2018-10-15T08:08:54Z")

</div>

i have the follow error:

Loaded: loaded (/usr/lib/systemd/system/mysql@.service; disabled; vendor preset: disabled)  
Active: failed (Result: exit-code) since Mon 2018-10-15 15:28:39 CEST; 1min 4s ago  
Process: 14583 ExecStopPost=/usr/bin/mysql-systemd stop-post (code=exited, status=0/SUCCESS)  
Process: 14554 ExecStop=/usr/bin/mysql-systemd stop (code=exited, status=2)  
Process: 14136 ExecStartPost=/usr/bin/mysql-systemd start-post $MAINPID (code=exited, status=1/FAILURE)  
Process: 14135 ExecStart=/usr/bin/mysqld\_safe --basedir=/usr ${EXTRA\_ARGS} (code=exited, status=0/SUCCESS)  
Process: 14087 ExecStartPre=/usr/bin/mysql-systemd start-pre (code=exited, status=0/SUCCESS)  
Main PID: 14135 (code=exited, status=0/SUCCESS)

Oct 15 15:28:39 servidor-1.localdomain mysql-systemd[14136]: ERROR! mysqld\_safe with PID 14135 has already exited: FAILURE  
Oct 15 15:28:39 servidor-1.localdomain systemd[1]: [mysql&#64;bootstrap.service](mailto:mysql&#64;bootstrap.service): control process exited, code=exited status=1  
Oct 15 15:28:39 servidor-1.localdomain mysql-systemd[14554]: WARNING: mysql pid file /run/mysqld/mysql.pid empty or not readable  
Oct 15 15:28:39 servidor-1.localdomain mysql-systemd[14554]: ERROR! mysql already dead  
Oct 15 15:28:39 servidor-1.localdomain systemd[1]: [mysql&#64;bootstrap.service](mailto:mysql&#64;bootstrap.service): control process exited, code=exited status=2  
Oct 15 15:28:39 servidor-1.localdomain systemd[1]: Failed to start Percona XtraDB Cluster with config /etc/sysconfig/mysql.bootstrap.  
Oct 15 15:28:39 servidor-1.localdomain systemd[1]: Unit [mysql&#64;bootstrap.service](mailto:mysql&#64;bootstrap.service) entered failed state.  
Oct 15 15:28:39 servidor-1.localdomain systemd[1]: [mysql&#64;bootstrap.service](mailto:mysql&#64;bootstrap.service) failed.  
Oct 15 15:28:39 servidor-1.localdomain mysql-systemd[14583]: WARNING: mysql pid file /run/mysqld/mysql.pid empty or not readable  
Oct 15 15:28:39 servidor-1.localdomain mysql-systemd[14583]: WARNING: mysql may be already dead

* * *

my my.cnf is :

[mysqld]

user = mysql

log\_bin  
binlog\_format = ROW

innodb\_buffer\_pool\_size = 1000M  
innodb\_flush\_log\_at\_trx\_commit = 0  
innodb\_flush\_method = O\_DIRECT  
innodb\_log\_files\_in\_group = 2  
innodb\_log\_file\_size = 60M  
innodb\_file\_per\_table = 1

datadir = /var/lib/mysql

wsrep\_cluster\_address = gcomm://192.168.1.1, 192.168.2  
wsrep\_provider = /usr/lib64/galera3/libgalera\_smm.so  
wsrep\_slave\_threads = 8  
wsrep\_cluster\_name = [db.com](http://db.com)  
wsrep\_node\_name = Node1  
wsrep\_node\_address = 192.168.1.1

default\_storage\_engine=InnoDB  
innodb\_locks\_unsafe\_for\_binlog = 1  
innodb\_autoinc\_lock\_mode = 2

wsrep\_sst\_method=xtrabackup-v2  
wsrep\_sst\_auth=“11111111e”

[mysqld\_safe]  
pid-file = /run/mysqld/mysql.pid  
syslog

!includedir /etc/my.cnf.d

–

My SO is: CENTOS 7

i hace disabled firewall and

sellinux disabled too

the command used for wake up the master

systemctl start [mysql&#64;bootstrap.service[SUP][IMG]https://jira.percona.com/images/icons/mail\_small.gif[/IMG][/SUP]](mailto:mysql&#64;bootstrap.service)

---

<div class="post-metadata">

**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:** [October 24, 2018, 6:58am UTC](https://forums.percona.com/t/my-master-node-dont-wakeup-after-rebbot/6631/2 "2018-10-24T06:58:58Z")

</div>

When investigating problems with starting, remember to always check the error log. The systemd status does not provide the details.  
The error log will be likely in /var/log/mysqld.log or similar or maybe logging to syslog. Best to specify the error log file explicitly with log\_error setting.  
Check also what configuration is under /etc/my.cnf.d/

Btw, I can see wrong used variable:

```auto
wsrep_sst_auth="11111111e"

```

It should be in a form of

```auto
wsrep_sst_auth="user:pass"

```

[URL][Index of wsrep system variables - Percona XtraDB Cluster](https://www.percona.com/doc/percona-xtradb-cluster/5.7/wsrep-system-index.html#wsrep_sst_auth%5B/URL%5D)
