首页 > 其他 > 详细

masterha_check_repl 报错

时间:2020-09-14 16:18:17      阅读:119      评论:0      收藏:0      [点我收藏+]

Percona MySQL 5.5.18

[root@host4713 ~]# masterha_check_repl --conf=/root/mha/conf/mha.cnf 
Mon Sep 14 14:58:43 2020 - [warning] Global configuration file /etc/masterha_default.cnf not found. Skipping.
Mon Sep 14 14:58:43 2020 - [info] Reading application default configurations from /root/mha/conf/mha.cnf..
Mon Sep 14 14:58:43 2020 - [info] Reading server configurations from /root/mha/conf/mha.cnf..
Mon Sep 14 14:58:43 2020 - [info] MHA::MasterMonitor version 0.55.
Mon Sep 14 14:58:43 2020 - [info] Dead Servers:
Mon Sep 14 14:58:43 2020 - [info] Alive Servers:
Mon Sep 14 14:58:43 2020 - [info]   10.20.47.12(10.20.47.12:3306)
Mon Sep 14 14:58:43 2020 - [info]   10.20.47.13(10.20.47.13:3306)
Mon Sep 14 14:58:43 2020 - [info] Alive Slaves:
Mon Sep 14 14:58:43 2020 - [info]   10.20.47.12(10.20.47.12:3306)  Version=5.5.18-rel23.0-log (oldest major version between slaves) log-bin:enabled
Mon Sep 14 14:58:43 2020 - [info]     Replicating from 10.20.47.13(10.20.47.13:3306)
Mon Sep 14 14:58:43 2020 - [info]     Primary candidate for the new Master (candidate_master is set)
Mon Sep 14 14:58:43 2020 - [info] Current Alive Master: 10.20.47.13(10.20.47.13:3306)
Mon Sep 14 14:58:43 2020 - [info] Checking slave configurations..
Mon Sep 14 14:58:43 2020 - [warning]  relay_log_purge=0 is not set on slave 10.20.47.12(10.20.47.12:3306).
Mon Sep 14 14:58:43 2020 - [info] Checking replication filtering settings..
Mon Sep 14 14:58:43 2020 - [info]  binlog_do_db= , binlog_ignore_db= 
Mon Sep 14 14:58:43 2020 - [info]  Replication filtering check ok.
Mon Sep 14 14:58:43 2020 - [info] Starting SSH connection tests..
Mon Sep 14 14:58:44 2020 - [info] All SSH connection tests passed successfully.
Mon Sep 14 14:58:44 2020 - [info] Checking MHA Node version..
Mon Sep 14 14:58:44 2020 - [info]  Version check ok.
Mon Sep 14 14:58:44 2020 - [info] Checking SSH publickey authentication settings on the current master..
Mon Sep 14 14:58:44 2020 - [info] HealthCheck: SSH to 10.20.47.13 is reachable.
Mon Sep 14 14:58:44 2020 - [info] Master MHA Node version is 0.54.
Mon Sep 14 14:58:44 2020 - [info] Checking recovery script configurations on the current master..
Mon Sep 14 14:58:44 2020 - [info]   Executing command: save_binary_logs --command=test --start_pos=4 --binlog_dir=/mysql/binlog --output_file=/root/mha/log/save_binary_logs_test --manager_version=0.55 --start_file=mysql-bin.000060 
Mon Sep 14 14:58:44 2020 - [info]   Connecting to root@10.20.47.13(10.20.47.13).. 
  Creating /root/mha/log if not exists..    ok.
  Checking output directory is accessible or not..
   ok.
  Binlog found at /mysql/binlog, up to mysql-bin.000060
Mon Sep 14 14:58:44 2020 - [info] Master setting check done.
Mon Sep 14 14:58:44 2020 - [info] Checking SSH publickey authentication and checking recovery script configurations on all alive slave servers..
Mon Sep 14 14:58:44 2020 - [info]   Executing command : apply_diff_relay_logs --command=test --slave_user=‘admin‘ --slave_host=10.20.47.12 --slave_ip=10.20.47.12 --slave_port=3306 --workdir=/root/mha/log --target_version=5.5.18-rel23.0-log --manager_version=0.55 --relay_log_info=/mysql/data/relay-log.info  --relay_dir=/mysql/data/  --slave_pass=xxx
Mon Sep 14 14:58:44 2020 - [info]   Connecting to root@10.20.47.12(10.20.47.12:22).. 
  Checking slave recovery environment settings..
    Opening /mysql/data/relay-log.info ... ok.
    Relay log found at /mysql/data, up to host4712-relay-bin.000138
    Temporary relay log file is /mysql/data/host4712-relay-bin.000138
    Testing mysql connection and privileges.. done.
    Testing mysqlbinlog output..sh: line 1: 20131 Segmentation fault      (core dumped) mysqlbinlog /mysql/data/host4712-relay-bin.000138 --start-position=4 --stop-position=4 > /root/mha/log/slavediff_tmp_10.20.47.12.log
mysqlbinlog failed with rc 139:0!
 at /usr/bin/apply_diff_relay_logs line 380
	main::check() called at /usr/bin/apply_diff_relay_logs line 486
	eval {...} called at /usr/bin/apply_diff_relay_logs line 466
	main::main() called at /usr/bin/apply_diff_relay_logs line 112
Mon Sep 14 14:58:44 2020 - [error][/usr/share/perl5/vendor_perl/MHA/MasterMonitor.pm, ln195] Slaves settings check failed!
Mon Sep 14 14:58:44 2020 - [error][/usr/share/perl5/vendor_perl/MHA/MasterMonitor.pm, ln375] Slave configuration failed.
Mon Sep 14 14:58:44 2020 - [error][/usr/share/perl5/vendor_perl/MHA/MasterMonitor.pm, ln386] Error happend on checking configurations.  at /usr/bin/masterha_check_repl line 48
Mon Sep 14 14:58:44 2020 - [error][/usr/share/perl5/vendor_perl/MHA/MasterMonitor.pm, ln482] Error happened on monitoring servers.
Mon Sep 14 14:58:44 2020 - [info] Got exit code 1 (Not master dead).

MySQL Replication Health is NOT OK!

环境的问题。。。总是有。。。。

需要解决

ln -s /home/mysql/bin/mysqlbinlog /usr/bin/mysqlbinlog

masterha_check_repl 报错

原文:https://www.cnblogs.com/Coye/p/13667035.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!