Not the answer you need?
Register and ask your own question!

my master node dont wakeup after rebbot

retrosfinretrosfin EntrantCurrent User Role Beginner
i have the follow error:

Loaded: loaded (/usr/lib/systemd/system/[email protected]; 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]: [email protected]: 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]: [email protected]: 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 [email protected] entered failed state.
Oct 15 15:28:39 servidor-1.localdomain systemd[1]: [email protected] 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
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 [EMAIL="mysql@bootstrap.service"][email protected]mail_small.gif[/EMAIL]

Comments

  • przemekprzemek Percona Support Engineer Percona Staff Role
    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:
    wsrep_sst_auth="11111111e"
    
    It should be in a form of
    wsrep_sst_auth="user:pass"
    

    https://www.percona.com/doc/percona-xtradb-cluster/5.7/wsrep-system-index.html#wsrep_sst_auth
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.