[error][/usr/local/share/perl5/MHA/MasterMonitor.pm, ln222] Failed to get master_ip_failover_script

最新推荐文章于 2024-07-01 02:24:16 发布
原创 最新推荐文章于 2024-07-01 02:24:16 发布 · 8k 阅读 · 2 ·
CC 4.0 BY-SA版权
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。

[root@mysqlcentos01 bin]# masterha_check_repl --conf=/data/mhamanager/3306/log/mha.cnf  
Fri Aug 25 16:37:25 2017 - [warning] Global configuration file /etc/masterha_default.cnf not found. Skipping.
Fri Aug 25 16:37:25 2017 - [info] Reading application default configurations from /data/mhamanager/3306/log/mha.cnf..
Fri Aug 25 16:37:25 2017 - [info] Reading server configurations from /data/mhamanager/3306/log/mha.cnf..
Fri Aug 25 16:37:25 2017 - [info] MHA::MasterMonitor version 0.56.
Fri Aug 25 16:37:26 2017 - [info] Dead Servers:
Fri Aug 25 16:37:26 2017 - [info] Alive Servers:
Fri Aug 25 16:37:26 2017 - [info]   10.194.41.231(10.194.41.231:3306)
Fri Aug 25 16:37:26 2017 - [info]   10.194.41.228(10.194.41.228:3306)
Fri Aug 25 16:37:26 2017 - [info]   10.194.41.227(10.194.41.227:3306)
Fri Aug 25 16:37:26 2017 - [info] Alive Slaves:
Fri Aug 25 16:37:26 2017 - [info]   10.194.41.228(10.194.41.228:3306)  Version=5.7.18-log (oldest major version between slaves) log-bin:enabled
Fri Aug 25 16:37:26 2017 - [info]     GTID ON
Fri Aug 25 16:37:26 2017 - [info]     Replicating from 10.194.41.231(10.194.41.231:3306)
Fri Aug 25 16:37:26 2017 - [info]   10.194.41.227(10.194.41.227:3306)  Version=5.7.18-log (oldest major version between slaves) log-bin:enabled
Fri Aug 25 16:37:26 2017 - [info]     GTID ON
Fri Aug 25 16:37:26 2017 - [info]     Replicating from 10.194.41.231(10.194.41.231:3306)
Fri Aug 25 16:37:26 2017 - [info]     Primary candidate for the new Master (candidate_master is set)
Fri Aug 25 16:37:26 2017 - [info] Current Alive Master: 10.194.41.231(10.194.41.231:3306)
Fri Aug 25 16:37:26 2017 - [info] Checking slave configurations..
Fri Aug 25 16:37:26 2017 - [warning]  relay_log_purge=0 is not set on slave 10.194.41.228(10.194.41.228:3306).
Fri Aug 25 16:37:26 2017 - [warning]  relay_log_purge=0 is not set on slave 10.194.41.227(10.194.41.227:3306).
Fri Aug 25 16:37:26 2017 - [info] Checking replication filtering settings..
Fri Aug 25 16:37:26 2017 - [info]  binlog_do_db= , binlog_ignore_db= 
Fri Aug 25 16:37:26 2017 - [info]  Replication filtering check ok.
Fri Aug 25 16:37:26 2017 - [info] GTID is supported. Skipping all SSH and Node package checking.
Fri Aug 25 16:37:26 2017 - [info] Checking SSH publickey authentication settings on the current master..
Fri Aug 25 16:37:31 2017 - [warning] HealthCheck: Got timeout on checking SSH connection to 10.194.41.231! at /usr/local/share/perl5/MHA/HealthCheck.pm line 298.
Fri Aug 25 16:37:31 2017 - [info] 
10.194.41.231 (current master)
 +--10.194.41.228
 +--10.194.41.227

Fri Aug 25 16:37:31 2017 - [info] Checking replication health on 10.194.41.228..
Fri Aug 25 16:37:31 2017 - [info]  ok.
Fri Aug 25 16:37:31 2017 - [info] Checking replication health on 10.194.41.227..
Fri Aug 25 16:37:31 2017 - [info]  ok.
Fri Aug 25 16:37:31 2017 - [info] Checking master_ip_failover_script status:
Fri Aug 25 16:37:31 2017 - [info]   /usr/local/bin/master_ip_failover --command=status --ssh_user=root --orig_master_host=10.194.41.231 --orig_master_ip=10.194.41.231 --orig_master_port=3306 
Bareword "FIXME_xxx" not allowed while "strict subs" in use at /usr/local/bin/master_ip_failover line 100.
Execution of /usr/local/bin/master_ip_failover aborted due to compilation errors.
Fri Aug 25 16:37:31 2017 - [error][/usr/local/share/perl5/MHA/MasterMonitor.pm, ln222]  Failed to get master_ip_failover_script status with return code 255:0.
Fri Aug 25 16:37:31 2017 - [error][/usr/local/share/perl5/MHA/MasterMonitor.pm, ln401] Error happend on checking configurations.  at /usr/local/bin/masterha_check_repl line 48.
Fri Aug 25 16:37:31 2017 - [error][/usr/local/share/perl5/MHA/MasterMonitor.pm, ln500] Error happened on monitoring servers.
Fri Aug 25 16:37:31 2017 - [info] Got exit code 1 (Not master dead).


MySQL Replication Health is NOT OK!

[root@mysqlcentos01 bin]# 

http://blog.youkuaiyun.com/kokuma/article/details/72900645

错误集：MHA高可用集群部署及故障切换[error][/usr/local/share/perl5/MHA/MasterMonitor.pm, ln427]
qq_35456705的博客
03-03 5264
MHA高可用集群部署及故障切换排错 文章目录MHA高可用集群部署及故障切换排错一、在 manager 节点上测试 ssh 无密码认证时和在 manager 节点上测试 mysql 主从连接情况时报错：二、错误分析1.查看配置服务器无密码认证有没有问题（1）在 manager 节点上配置到所有数据库节点的无密码认证2.查看app1.cnf文件是否配置出错 一、在 manager 节点上测试 ssh 无密码认证时和在 manager 节点上测试 mysql 主从连接情况时报错： masterha_check_s
精华总结：MHA构建中的各种报错与解决
CN_TangZheng的博客
01-10 4011
文章目录前言一：报错与解决1.1：报错： [error][/usr/local/share/perl5/MHA/MasterMonitor.pm, ln364] None of slaves can be master. Check failover configuration file or log-bin settings in my.cnf1.2：报错： User myslave does ...
搭建mysql mha执行masterha_check_repl时报错Failed to get master_ip_failover_script status with return code 2...
最新发布
weixin_33581743的博客
07-01 162
登录后复制 问题描述：搭建mysql mha执行masterha_check_repl时报错Failed to get master_ip_failover_script status with return code 255:0，如下所示： 系统：rhel 7.9 64位 mha安装包：mha4mysql-node-0...
MHA报错[error][/usr/share/perl5/vendor_perl/MHA/MasterMonitor.pm, ln161] Binlog setting check failed!
热门推荐
ss954773878的博客
09-02 1万+
当时的环境报错 查看了很多资料，都没有很好的说明，大多是percona工具的报错，其实这是一个动态库的问题 先确认是否安装了MHA的相关依赖 #yum install -y perl-Config-Tiny epel-release perl-Log-Dispatch perl-Parallel-ForkManager perl-Time-HiRes 确认安装后，执行 #ldconfig -p ...
MHA排障报错——[error][/usr/local/share/perl5/……at /usr/local/bin/masterha_check_repl line 48.
CN_LiTianpeng的博客
09-19 1801
报错原因 在master_ip_failover脚本文件中有一些内容是我们不需要的，因此需要注释掉 [root@localhost ~]# masterha_check_repl -conf=/etc/masterha/app1.cnf //检查MHA状况 …… Sun Sep 20 01:05:06 2020 - [error][/usr/local/share/perl5/MHA/MasterMonitor.pm, ln229] Failed to get master_ip_failover_s
masterha_check_repl --conf=/etc/masterha/app1.cnf的各种报错及解决方法
qq_34457768的博客
03-07 5648
masterha_check_repl --conf=/etc/masterha/app1.cnf的各种报错及解决方法   1、错误：User repl does not exist or does not have REPLICATION SLAVE privilege! Other slaves can not start replication from this host 解决方...
排错集锦：在MHA 的配置过程中masterha_check_repl -conf=/etc/masterha/app1.cnf 失败
lv74134的博客
07-24 1266
问题：配置MHA时候，测试主从复制 masterha_check_repl -conf=/etc/masterha/app1.cnf Can't exec "mysqlbinlog": 没有那个文件或目录 at /usr/local/share/perl5/MHA/BinlogManager.pm line 106. mysqlbinlog version command failed with rc 1:0, please verify PATH, LD_LIBRARY_PATH, and client
MHA构建中的报错集合配解决方案
chenchen的博客
12-08 860
1：报错： [error][/usr/local/share/perl5/MHA/MasterMonitor.pm, ln364] None of slaves can be master. Check failover configuration file or log-bin settings in my.cnf 报错描述 [root@mha_manager ~]# masterha_check_repl -conf=/etc/masterha/app1.cnf ...省略内容 Fri Jan 10 0
mha搭建mysql服务器集群时的一些报错汇总
weixin_45833713的博客
12-16 1025
报错总结: 1.在检查mha的ssh配置检查中的报错. 解决办法:检查数据库服务器之间能否免密登录,mha管理服务器上能否免密登录到各服务器上. [root@57 mha4mysql-manager-0.56]# masterha_check_ssh --conf=/etc/mha/app1.cnf Sun Dec 15 17:03:27 2019 - [warning] Global conf...
MySQL高可用之MHA的搭建--错误整合
that is it的博客
07-12 7670
1.检查整个复制环境状况时，出现错误 masterha_check_repl –conf=/etc/masterha/app1.cnf 错误一：mysql日志文件未找到和mysql命令未找到 Can't exec "mysqlbinlog": No such file or directory at /usr/local/share/perl5/MHA/BinlogManager.pm ...
MySQL之MHA集群的详细教程
hahaxixi131的博客
01-03 2313
文章目录MHA集群（MySQL服务高可用集群）MHA简介MHA工作过程拓扑结构部署MHA集群集群环境准备1.安装依赖包2.配置ssh密钥对认证登录3.配置一主多从同步结构配置管理节点（192.168.4.57）1.安装软件包2.相关命令3.编写主配置文件4.修改故障切换脚本，指定VIP地址配置数据节点（数据库服务器51、52、53）1.把VIP地址192.168.4.100 配置在主服务器192.168.4.51上，并在所有数据节点安装mha_node包2.添加授权用户（主服务51）3.在52和53添加同步
master_ip_failover_script问题终极解决方案
weixin_34194379的博客
08-15 842
[root@kube-node5 run]# masterha_check_repl --conf=/etc/mha/app2.cnf Wed Aug 15 14:47:52 2018 - [warning] Global configuration file /etc/masterha_default.cnf not found. Skipping. Wed Aug 15 14:47:5...
故障分析 | MHA 切换的一个“坑”
ActionTech的博客
08-19 599
作者：张洛丹 原爱可生 DBA 团队成员，现陆金所 DBA 团队成员，对技术执著有追求！ 本文来源：原创投稿 *爱可生开源社区出品，原创内容未经授权不得随意使用，转载请联系小编并注明来源。 背景 在一次变更中使用 MHA 进行主从切换，命令如下： masterha_master_switch --master_state=alive --conf=/etc/mha/mha3306.cnf --new_master_host=xx.xx.xx.xx --new_master_port=3306 --in.
在 linux 系统下安装 perl
蝈蝈俊.net
08-28 5541
    linux 和 perl 都属于自由软件，将二者结合真是妙不可言。    遵循以下步骤一般就可安装好 perl ，perl 就能在 linux 下欢唱。    1。取得最新版本的 perl，当前版本为 5.6.0,即 stable.tar.gz。    2。解文件包：      gunzip stable.tar.gz      tar xvf stable.tar      得到目
mysql MHA脚本masterha_master_switch手动操作常见错误
u010719917的专栏
05-23 3893
Mon May 21 16:56:06 2018 - [error][/usr/local/share/perl5/MHA/MasterFailover.pm, ln1261] Failed to activate master IP address for centos129 with return code 10:0解决办法：？ [warning] Got timeout on MySQL ...
MHA复制功能检测报错以及解决思路
chaos_oper的博客
07-28 1367
MHA实现MySQL高可用的时候，MHA复制功能检测老是出现各种问题，故总结一下常见报错以及如何解决的 1.某个库 Dead Servers 检测从库状态发现一切正常，那是哪里出问题了呢？ Sun Jul 28 09:27:40 2019 - [info] Dead Servers: Sun Jul 28 09:27:40 2019 - [info] 172.25.13.13(172.25.1...
mysql switch binlog_MySQL 有关MHA搭建与切换的几个错误log汇总
weixin_36042403的博客
01-27 407
1：masterha_check_repl 副本集方面报错replicates is not defined in the configuration file!具体信息如下：# /usr/local/bin/masterha_check_repl --conf=/etc/mha/app1.cnfThu Nov 21 15:33:15 2018 - [warning] Global confi...
[error][/usr/local/share/perl5/MHA/Server.pm, ln242] Getting relay log directory or current relay l...
weixin_33937499的博客
03-14 1839
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/masterh...
Can't locate Log/Dispatch.pm in @INC (@INC contains: /usr/local/lib64/perl5 /usr/local/share/perl5 /usr/lib64/perl5/vendor_perl /usr/share/perl5/vendor_perl /usr/lib64/perl5 /usr/share/perl5 .) at /usr/local/share/perl5/MHA/SSHCheck.pm line 29. BEGIN failed--compilation aborted at /usr/local/share/perl5/MHA/SSHCheck.pm line 29. Compilation failed in require at /usr/local/bin/masterha_check_ssh line 25. BEGIN failed--compilation aborted at /usr/local/bin/masterha_check_ssh line 25.
07-25
- *2* [Can't locate Params/Validate.pm in @INC (@INC contains: /usr/local/lib64/perl5 /](https://blog.csdn.net/weixin_30838873/article/details/96170433)[target="_blank" data-report-click={"spm":"1018....
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值