1.[root@mha-manager bin]# masterha_check_repl --conf=/etc/masterha_default.cnf
Mon Jun 17 13:54:48 2013 - [info] Reading default configuratoins from
/etc/masterha_default.cnf..
Mon Jun 17 13:54:48 2013 - [info] Reading application default configurations
from /etc/masterha_default.cnf..
Mon Jun 17 13:54:48 2013 - [info] Reading server configurations from
/etc/masterha_default.cnf..
Mon Jun 17 13:54:48 2013 - [info] MHA::MasterMonitor version 0.53.
Mon Jun 17 13:54:48 2013 - [info] Dead Servers:
Mon Jun 17 13:54:48 2013 - [info] Alive Servers:
Mon Jun 17 13:54:48 2013 - [info] 172.24.24.45(172.24.24.45:3306)
Mon Jun 17 13:54:48 2013 - [info] 172.24.24.145(172.24.24.145:3306)
Mon Jun 17 13:54:48 2013 - [info] Alive Slaves:
Mon Jun 17 13:54:48 2013 - [info] 172.24.24.145(172.24.24.145:3306)
Version=5.5.27-log (oldest major version between slaves) log-bin:enabled
Mon Jun 17 13:54:48 2013 - [info] Replicating from
172.24.24.45(172.24.24.45:3306)
Mon Jun 17 13:54:48 2013 - [info] Current Alive Master:
172.24.24.45(172.24.24.45:3306)
Mon Jun 17 13:54:48 2013 - [info] Checking slave configurations..
Mon Jun 17 13:54:48 2013 - [info] Checking replication filtering settings..
Mon Jun 17 13:54:48 2013 - [info] binlog_do_db= , binlog_ignore_db=
Mon Jun 17 13:54:48 2013 - [info] Replication filtering check ok.
Mon Jun 17 13:54:48 2013 - [info] Starting SSH connection tests..
Mon Jun 17 13:54:50 2013 - [info] All SSH connection tests passed successfully.
Mon Jun 17 13:54:50 2013 - [info] Checking MHA Node version..
Mon Jun 17 13:54:50 2013 - [info] Version check ok.
Mon Jun 17 13:54:50 2013 - [info] Checking SSH publickey authentication
settings on the current master..
Mon Jun 17 13:54:51 2013 - [info] HealthCheck: SSH to 172.24.24.45 is reachable.
Mon Jun 17 13:54:52 2013 - [info] Master MHA Node version is 0.53.
Mon Jun 17 13:54:52 2013 - [info] Checking recovery script configurations on
the current master..
Mon Jun 17 13:54:52 2013 - [info] Executing command: save_binary_logs
--command=test --start_pos=4 --binlog_dir=/usr/local/mysql/data
--output_file=/var/log/masterha/save_binary_logs_test --manager_version=0.53
--start_file=mysql-bin.000004
Mon Jun 17 13:54:52 2013 - [info] Connecting to
root@172.24.24.45(172.24.24.45)..
Creating /var/log/masterha if not exists.. ok.
Checking output directory is accessible or not..
ok.
Binlog found at /usr/local/mysql/data, up to mysql-bin.000004
Mon Jun 17 13:54:52 2013 - [info] Master setting check done.
Mon Jun 17 13:54:52 2013 - [info] Checking SSH publickey authentication and
checking recovery script configurations on all alive slave servers..
Mon Jun 17 13:54:52 2013 - [info] Executing command : apply_diff_relay_logs
--command=test --slave_user=mha --slave_host=172.24.24.145
--slave_ip=172.24.24.145 --slave_port=3306 --workdir=/var/log/masterha
--target_version=5.5.27-log --manager_version=0.53
--relay_log_info=/usr/local/mysql/data/relay-log.info
--relay_dir=/usr/local/mysql/data/ --slave_pass=xxx
Mon Jun 17 13:54:52 2013 - [info] Connecting to
root@172.24.24.145(172.24.24.145:22)..
Checking slave recovery environment settings..
Opening /usr/local/mysql/data/relay-log.info ... ok.
Relay log found at /usr/local/mysql/data, up to mha-2-relay-log.000004
Temporary relay log file is /usr/local/mysql/data/mha-2-relay-log.000004
Testing mysql connection and privileges.. done.
Testing mysqlbinlog output.. done.
Cleaning up test file(s).. done.
Mon Jun 17 13:54:53 2013 - [info] Slaves settings check done.
Mon Jun 17 13:54:53 2013 - [info]
172.24.24.45 (current master)
+--172.24.24.145
Mon Jun 17 13:54:53 2013 - [info] Checking replication health on 172.24.24.145..
Mon Jun 17 13:54:53 2013 - [info] ok.
Mon Jun 17 13:54:53 2013 - [info] Checking master_ip_failover_script status:
Mon Jun 17 13:54:53 2013 - [info] /usr/local/bin/master_ip_failover
--command=status --ssh_user=root --orig_master_host=172.24.24.45
--orig_master_ip=172.24.24.45 --orig_master_port=3306
Bareword "FIXME_xxx" not allowed while "strict subs" in use at
/usr/local/bin/master_ip_failover line 88.
Execution of /usr/local/bin/master_ip_failover aborted due to compilation
errors.
Mon Jun 17 13:54:53 2013 - [error][/usr/local/share/perl5/MHA/MasterMonitor.pm,
ln214] Failed to get master_ip_failover_script status with return code 255:0.
Mon Jun 17 13:54:53 2013 - [error][/usr/local/share/perl5/MHA/MasterMonitor.pm,
ln383] Error happend on checking configurations. at
/usr/local/bin/masterha_check_repl line 48
Mon Jun 17 13:54:53 2013 - [error][/usr/local/share/perl5/MHA/MasterMonitor.pm,
ln478] Error happened on monitoring servers.
Mon Jun 17 13:54:53 2013 - [info] Got exit code 1 (Not master dead).
MySQL Replication Health is NOT OK!
please help me.Can you give me master_ip_failover.
my master IP 172.24.24.45 slave ip 172.24.24.145
Thanks!
Original issue reported on code.google.com by ssf...@gmail.com on 17 Jun 2013 at 6:05
Original issue reported on code.google.com by
ssf...@gmail.comon 17 Jun 2013 at 6:05