MySQL Replication Health is NOT OK!

[luxinle]

MySQL Replication Health is NOT OK!

[GoogleCodeExporter]

MHA fails to get datadir but this should not happen. Would you please provide 
more information? If you do not like to publish, please e-mail to myself (you 
can get my email on my blog)?

- Set "log-level=debug" at [server_default] section in /etc/app1.cnf, and paste 
all log outputs
- MySQL client and server version

Original comment by [email protected] on 8 Nov 2011 at 10:00

[GoogleCodeExporter]

As i required it immediately I solved it by checking if datadir is defined and 
if its not defined i manually defined it.
if(!defined($datadir)){
        $datadir="path/to/mysql";
  }


but we cant do this on every system.Need  to fix it!

I commented d above part and made the changes to /etc/app1 as you had 
instructed ,i got these errors


Tue Nov  8 21:00:15 2011 - [info] Reading default configuratoins from 
/etc/masterha_default.cnf..
Tue Nov  8 21:00:15 2011 - [info] Reading application default configurations 
from /etc/app1.cnf..
Tue Nov  8 21:00:15 2011 - 
[error][/usr/local/share/perl/5.10.1/MHA/MasterMonitor.pm, ln315] Error happend 
on checking configurations. Parameter name log-level is invalid!
 at /usr/local/share/perl/5.10.1/MHA/MasterMonitor.pm line 190
Tue Nov  8 21:00:15 2011 - 
[error][/usr/local/share/perl/5.10.1/MHA/MasterMonitor.pm, ln396] Error 
happened on monitoring servers.
Tue Nov  8 21:00:15 2011 - [info] Got exit code 1 (Not master dead).

Original comment by [email protected] on 8 Nov 2011 at 3:32

[GoogleCodeExporter]

Ah, log_level=debug, not log-level. Sorry.

Original comment by [email protected] on 8 Nov 2011 at 3:37

[GoogleCodeExporter]

This is what im getting


Tue Nov  8 21:16:12 2011 - [info] Reading default configuratoins from 
/etc/masterha_default.cnf..
Tue Nov  8 21:16:12 2011 - [info] Reading application default configurations 
from /etc/app1.cnf..
Tue Nov  8 21:16:12 2011 - [info] Reading server configurations from 
/etc/app1.cnf..
Tue Nov  8 21:16:12 2011 - [info] MHA::MasterMonitor version 0.52.
Tue Nov  8 21:16:12 2011 - [debug] Connecting to servers..
Tue Nov  8 21:16:12 2011 - [debug]  Connected to: 127.0.0.1(127.0.0.1:3308), 
user=root
Tue Nov  8 21:16:12 2011 - 
[error][/usr/local/share/perl/5.10.1/MHA/MasterMonitor.pm, ln315] Error happend 
on checking configurations. Use of uninitialized value $datadir in 
concatenation (.) or string at /usr/local/share/perl/5.10.1/MHA/SlaveUtil.pm 
line 128.
Tue Nov  8 21:16:12 2011 - 
[error][/usr/local/share/perl/5.10.1/MHA/MasterMonitor.pm, ln396] Error 
happened on monitoring servers.
Tue Nov  8 21:16:12 2011 - [info] Got exit code 1 (Not master dead).

MySQL Replication Health is NOT OK!

Original comment by [email protected] on 8 Nov 2011 at 3:47

[GoogleCodeExporter]

What's the output of the following?

mysql --host=127.0.0.1 --port=3308 --user=root

select version();
select @@global.datadir;

Original comment by [email protected] on 8 Nov 2011 at 3:53

[GoogleCodeExporter]

select vserion()- 4.1.22-standard-log
select @@global.datadir-ERROR 1193 (HY000): Unknown system variable 'datadir'

Original comment by [email protected] on 8 Nov 2011 at 4:03

[GoogleCodeExporter]

OK. I got the reason of the error. MHA does not support MySQL 4.1 or earlier. 
The reason is binary log format in MySQL 4.1 (or earlier) is older. I do not 
have any plan to support it. I'll mark "WontFix" of this issue. 

I'll consider returning better error messages.

Suggestion: Please consider upgrading to MySQL 5.0 or higher version.

Original comment by [email protected] on 8 Nov 2011 at 4:13

[GoogleCodeExporter]

I have installed mutliple versions of Mysql on same machine.I have mysql 5.1.1 
as the slave to mysql 4.1, so had to deal with it. Anyways thanx for your time!

Original comment by [email protected] on 8 Nov 2011 at 4:26

[GoogleCodeExporter]

Original comment by [email protected] on 9 Nov 2011 at 4:25

• Changed state: WontFix