天天看点

[error][/usr/local/share/perl5/MHA/Server.pm, ln242] Getting relay log directory or current relay logfile from repication table failed

mha切换后检查主从复制出现:

[root@devops-mha-150 logs]# masterha_check_repl -conf=/etc/mha/10.66.150.117.cnf

tue mar 14 12:27:23 2017 - [info] reading default configuratoins from /etc/masterha_default.cnf..

tue mar 14 12:27:23 2017 - [info] reading application default configurations from /etc/mha/10.66.150.117.cnf..

tue mar 14 12:27:23 2017 - [info] reading server configurations from /etc/mha/10.66.150.117.cnf..

tue mar 14 12:27:23 2017 - [info] mha::mastermonitor version 0.56.

tue mar 14 12:27:24 2017 - error getting relay log directory or current relay logfile from repication table failed on devops-mysql-150-116(10.66.150.116:3306)!

tue mar 14 12:27:24 2017 - error error happend on checking configurations. at /usr/loca/share/perl5/mha/servermanager.pm line 269.

tue mar 14 12:27:24 2017 - error error happened on monitoring servers.

tue mar 14 12:27:24 2017 - [info] got exit code 1 (not master dead).

| relay_log_info_repository | table

为table的时候mha检查切换有问题。 这台作为master机器的relay_log_info_repository忘记改为file

改为file就ok了。

继续阅读