Export to GitHub

mysql-master-ha - issue #93

MySQL Enterprise use MHA report errors


Posted on Aug 11, 2014 by Happy Lion

What steps will reproduce the problem? 1.MySQL Enterprise use MHA report errors (None of slaves can be master.)

What is the expected output? What do you see instead? Wed Nov 26 14:02:58 2014 - [warning] Global configuration file /etc/masterha_default.cnf not found. Skipping. Wed Nov 26 14:02:58 2014 - [info] Reading application default configuration from /etc/app1.cnf.. Wed Nov 26 14:02:58 2014 - [info] Reading server configuration from /etc/app1.cnf.. Wed Nov 26 14:02:58 2014 - [info] MHA::MasterMonitor version 0.56. Wed Nov 26 14:02:58 2014 - [info] GTID failover mode = 0 Wed Nov 26 14:02:58 2014 - [info] Dead Servers: Wed Nov 26 14:02:58 2014 - [info] 192.168.100.33(192.168.100.33:3306) Wed Nov 26 14:02:58 2014 - [info] Alive Servers: Wed Nov 26 14:02:58 2014 - [info] 192.168.100.32(192.168.100.32:3306) Wed Nov 26 14:02:58 2014 - [info] 192.168.100.34(192.168.100.34:3306) Wed Nov 26 14:02:58 2014 - [info] Alive Slaves: Wed Nov 26 14:02:58 2014 - [info] 192.168.100.34(192.168.100.34:3306) Version=5.6.19-enterprise-commercial-advanced-log (oldest major version between slaves) log-bin:enabled Wed Nov 26 14:02:58 2014 - [info] Replicating from 192.168.100.32(192.168.100.32:3306) Wed Nov 26 14:02:58 2014 - [info] Not candidate for the new Master (no_master is set) Wed Nov 26 14:02:58 2014 - [info] Current Alive Master: 192.168.100.32(192.168.100.32:3306) Wed Nov 26 14:02:58 2014 - [info] Checking slave configurations.. Wed Nov 26 14:02:58 2014 - [info] Checking replication filtering settings.. Wed Nov 26 14:02:58 2014 - [info] binlog_do_db= , binlog_ignore_db= Wed Nov 26 14:02:58 2014 - [info] Replication filtering check ok. Wed Nov 26 14:02:58 2014 - [error][/usr/share/perl5/vendor_perl/MHA/MasterMonitor.pm, ln361] None of slaves can be master. Check failover configuration file or log-bin settings in my.cnf Wed Nov 26 14:02:58 2014 - [error][/usr/share/perl5/vendor_perl/MHA/MasterMonitor.pm, ln424] Error happened on checking configurations. at /usr/bin/masterha_check_repl line 48 Wed Nov 26 14:02:58 2014 - [error][/usr/share/perl5/vendor_perl/MHA/MasterMonitor.pm, ln523] Error happened on monitoring servers. Wed Nov 26 14:02:58 2014 - [info] Got exit code 1 (Not master dead).

MySQL Replication Health is NOT OK!

What version of the product are you using? On what operating system? mysql-advanced-5.6.19-linux-glibc2.5-x86_64.rpm.zip centos6.3

Please provide any additional information below.

Comment #1

Posted on Aug 12, 2014 by Grumpy Bear

The error log says a slave 192.168.100.34 is replicating from 192.168.100.32, not from a dead server (192.168.100.33). To make MHA work, all slaves have to replicate from a dead server.

  • Yoshinori

Status: New

Labels:
Type-Defect Priority-Medium