[error][/usr/local/share/perl5/MHA/Server.pm, ln242] Getting relay log directory or current relay l...

最新推荐文章于 2023-08-29 20:57:57 发布

weixin_33937499

最新推荐文章于 2023-08-29 20:57:57 发布

阅读量1.7k

点赞数

文章标签：数据库

原文链接：https://yq.aliyun.com/articles/72275

版权

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了。