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

3 node cluster issue

umarumar EntrantCurrent User Role Beginner
Hello,

I have a 3 node Percona XDB Cluster, today I have rebooted one of the node, but after the reboot the mysql service unable to start, here is the journalctl -xe output

-- Unit mysql.service has begun starting up.
Jan 17 07:32:39 scixdb3.scicloud.net mysqld_safe[10058]: 170117 07:32:39 mysqld_safe Logging to '/var/log/mysqld.log'.
Jan 17 07:32:39 scixdb3.scicloud.net mysqld_safe[10058]: 170117 07:32:39 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
Jan 17 07:32:39 scixdb3.scicloud.net mysqld_safe[10058]: 170117 07:32:39 mysqld_safe Skipping wsrep-recover for 18ad3ee5-9757-11e6-8015-cbfb14d9bf10:578938 pair
Jan 17 07:32:39 scixdb3.scicloud.net mysqld_safe[10058]: 170117 07:32:39 mysqld_safe Assigning 18ad3ee5-9757-11e6-8015-cbfb14d9bf10:578938 to wsrep_start_position
Jan 17 07:33:14 scixdb3.scicloud.net mysqld_safe[10058]: 170117 07:33:14 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
Jan 17 07:33:15 scixdb3.scicloud.net mysql-systemd[10059]: /usr/bin/mysql-systemd: line 134: kill: (10058) - No such process
Jan 17 07:33:15 scixdb3.scicloud.net mysql-systemd[10059]: ERROR! mysqld_safe with PID 10058 has already exited: FAILURE
Jan 17 07:33:15 scixdb3.scicloud.net systemd[1]: mysql.service: control process exited, code=exited status=1
Jan 17 07:33:15 scixdb3.scicloud.net mysql-systemd[10510]: WARNING: mysql pid file /var/run/mysqld/mysqld.pid empty or not readable
Jan 17 07:33:15 scixdb3.scicloud.net mysql-systemd[10510]: ERROR! mysql already dead
Jan 17 07:33:15 scixdb3.scicloud.net systemd[1]: mysql.service: control process exited, code=exited status=2
Jan 17 07:33:15 scixdb3.scicloud.net mysql-systemd[10540]: WARNING: mysql pid file /var/run/mysqld/mysqld.pid empty or not readable
Jan 17 07:33:15 scixdb3.scicloud.net mysql-systemd[10540]: WARNING: mysql may be already dead
Jan 17 07:33:15 scixdb3.scicloud.net systemd[1]: Failed to start Percona XtraDB Cluster.
-- Subject: Unit mysql.service has failed
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Unit mysql.service has failed.

would you please help me about this?

--

Umar
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.