blueloveyu / mysql-master-ha

Automatically exported from code.google.com/p/mysql-master-ha
2 stars 0 forks source link

MHA check perl #109

Open rui-zhu opened 7 years ago

rui-zhu commented 7 years ago

[root@manager app1]# masterha_check_repl --conf=/etc/mha/app1.cnf Thu Sep 14 15:54:35 2017 - [warning] Global configuration file /etc/masterha_default.cnf not found. Skipping. Thu Sep 14 15:54:35 2017 - [info] Reading application default configurations from /etc/mha/app1.cnf.. Thu Sep 14 15:54:35 2017 - [info] Reading server configurations from /etc/mha/app1.cnf.. Thu Sep 14 15:54:35 2017 - [info] MHA::MasterMonitor version 0.55. Thu Sep 14 15:54:36 2017 - [error][/usr/share/perl5/vendor_perl/MHA/MasterMonitor.pm, ln386] Error happend on checking configurations. Use of uninitialized value in string eq at /usr/share/perl5/vendor_perl/MHA/Server.pm line 235. Thu Sep 14 15:54:36 2017 - [error][/usr/share/perl5/vendor_perl/MHA/MasterMonitor.pm, ln482] Error happened on monitoring servers. Thu Sep 14 15:54:36 2017 - [info] Got exit code 1 (Not master dead).

MySQL Replication Health is NOT OK!

224 #if log-bin is enabled, check binlog filtering rules on all servers 225 if ( $self->{log_bin} ) { 226 my ( $file, $pos, $binlog_do_db, $binlog_ignore_db ) = 227 $dbhelper->show_master_status(); 228 $self->{File} = $file; 229 $self->{Binlog_Do_DB} = $binlog_do_db; 230 $self->{Binlog_Ignore_DB} = $binlog_ignore_db; 231 } 232 233 $self->{relay_log_info_type} = 234 $dbhelper->get_relay_log_info_type( $self->{mysql_version} ); 235 if ( $self->{relay_log_info_type} eq "TABLE" ) { 236 my ( $relay_dir, $current_relay_log ) = 237 MHA::SlaveUtil::get_relay_dir_file_from_table($dbh); 238 $self->{relay_dir} = $relay_dir; 239 $self->{current_relay_log} = $current_relay_log; 240 if ( !$relay_dir || !$current_relay_log ) { 241 $log->error( 242 sprintf( 243 " Getting relay log directory or current relay logfile from replication table failed on %s!", 244 $self->get_hostinfo() ) 245 ); 246 croak; 247 } 248 } 249 else {

rui-zhu commented 7 years ago

235 if ( $self->{relay_log_info_type} eq "TABLE" ) {