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: [url]http://lists.freedesktop.org/mailman/listinfo/systemd-devel[/url]
– Unit mysql.service has failed.
would you please help me about this?
–
Umar