Comments (9)
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
from mysql-master-ha.
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
from mysql-master-ha.
Ah, log_level=debug, not log-level. Sorry.
Original comment by [email protected]
on 8 Nov 2011 at 3:37
from mysql-master-ha.
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
from mysql-master-ha.
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
from mysql-master-ha.
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
from mysql-master-ha.
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
from mysql-master-ha.
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
from mysql-master-ha.
Original comment by [email protected]
on 9 Nov 2011 at 4:25
- Changed state: WontFix
from mysql-master-ha.
Related Issues (20)
- Not support for detecting poor perfomance masters HOT 1
- Manual switching | alive Old master does't become new slave HOT 3
- MHA automatic failover stop when I shutdown Master machine
- If Active Master goes Down, Slave running MHA manager can become Master?. HOT 2
- MHA IP failover / firewall issues
- got the error during the failover test "Applying all logs succeeded. But starting slave failed" HOT 3
- masterha_check_repl skips all slave checks on MySQL 5.6 with GTID enabled HOT 3
- Do mysql master failover only when there are more than one slaves HOT 3
- Maunal purge_relay_logs crash my replication HOT 2
- Failover aborts due to 1053 - Query partially completed on the master HOT 2
- masterha_manager can not start on 3306 ,but 3313 ok
- Does mysql-master-ha work if I already have traditional mysql replication running? HOT 1
- masterha_check_repl says ssh config failed, BUT masterha_check_ssh was okay HOT 1
- alert-only mode instead of failover
- Master Failover completed successfully. Error Establishing Database Connection. HOT 2
- Documentation not available HOT 1
- masterha_check_repl crashing HOT 2
- MHA Scalability HOT 1
- mysql innodb locks during checks on slaves
- Plaintext password in output HOT 3
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from mysql-master-ha.