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
原文:https://www.cnblogs.com/Coye/p/13667035.html