[error][/usr/local/share/perl5/MHA/Server.pm, ln242] Getting relay log directory or current relay logfile from repication table failed

MHA切换后检查主从复制出现：
[root@Devops-mha-150 logs]# masterha_check_repl -conf=/etc/mha/10.66.150.117.cnf
Tue Mar 14 12:27:23 2017 - [info] Reading default configuratoins from /etc/masterha_default.cnf..
Tue Mar 14 12:27:23 2017 - [info] Reading application default configurations from /etc/mha/10.66.150.117.cnf..
Tue Mar 14 12:27:23 2017 - [info] Reading server configurations from /etc/mha/10.66.150.117.cnf..
Tue Mar 14 12:27:23 2017 - [info] MHA::MasterMonitor version 0.56.
Tue Mar 14 12:27:24 2017 - [error][/usr/local/share/perl5/MHA/Server.pm, ln242] Getting relay log directory or current relay logfile from repication table failed on Devops-mysql-150-116(10.66.150.116:3306)!
Tue Mar 14 12:27:24 2017 - [error][/usr/local/share/perl5/MHA/MasterMonitor.pm, ln401] Error happend on checking configurations. at /usr/loca/share/perl5/MHA/ServerManager.pm line 269.
Tue Mar 14 12:27:24 2017 - [error][/usr/local/share/perl5/MHA/MasterMonitor.pm, ln500] Error happened on monitoring servers.
Tue Mar 14 12:27:24 2017 - [info] Got exit code 1 (Not master dead).

| relay_log_info_repository | TABLE

为TABLE的时候mha检查切换有问题。 这台作为master机器的relay_log_info_repository忘记改为FILE

改为FILE就ok了。

时间： 2024-09-12 08:43:56

[error][/usr/local/share/perl5/MHA/Server.pm, ln242] Getting relay log directory or current relay logfile from repication table failed的相关文章

解决[ERROR] /usr/libexec/mysqld: unknown variable

1. [ERROR] /usr/libexec/mysqld: unknown variable 'table_open_cache=64′ 打开/etc/my.cnf 注释掉table_open_cache=64 2. [ERROR] /usr/local/mysql//libexec/mysqld: unknown variable 'binlog_format=MIXED' 打开/etc/my.cnf 注释掉'binlog_format=MIXED'

configure: error: Cannot find libmysqlclient under /usr/local/mysql.

执行下面语句: ./configure --prefix=/usr/local/php --with-config-file-path=/usr/local/php/etc --with-mysql=/usr/local/mysql  --with-mysqli=/usr/local/mysql/bin/mysql_config --with-iconv-dir=/usr/local --with-freetype-dir --with-jpeg-dir --with-png-dir --wit

mysql起动报错The server quit without updating PID file /usr/local/mysql/data/

mysql起动报错The server quit without updating PID file (/usr/local/mysql/data/ 查看错误日志显示: mysqld_safe mysqld from pid file /usr/local/mysql/data/mysql.pid ended 肯定是配置文件问题: 新安装的测试机  hostname server01  centos 6.5 环境   mysql 5.6.12 单机 64位 二进制包安装 my.cnf 里面只有一

CentOS下启动apache报错，Syntax error on line 235 of /usr/local/apache2/conf/httpd.conf

问题描述 CentOS下启动apacheservice httpd startSyntax error on line 235 of /usr/local/apache2/conf/httpd.conf:Cannot load /usr/local/apache2/modules/libphp5.so into server: /usr/local/apache2/modules/libphp5.so: symbol deflate, version libmysqlclient_16 not

解决Nginx: [error] open() ＂/usr/local/Nginx/logs/Nginx.pid

  重新启动服务器,访问web服务发现无法浏览啦!登陆服务器之后进到nginx使用./nginx -s reload重新读取配置文件,发现报nginx: [error] open() "/usr/local/nginx/logs/nginx.pid" failed (2: No such file or directory)错误,进到logs文件发现的确没有nginx.pid文件 [root@localhost sbin]# ./nginx -s reload nginx: [erro

解决nginx: [error] open() ＂/usr/local/nginx/logs/nginx.pid＂ failed错误

风信网(ithov.com) 原创文章: 重新启动服务器,访问web服务发现无法浏览啦!登陆服务器之后进到nginx使用./nginx -s reload重新读取配置文件,发现报nginx: [error] open() "/usr/local/nginx/logs/nginx.pid" failed (2: No such file or directory)错误,进到logs文件发现 的确没有nginx.pid文件 &http://www.aliyun.com/zixun/

解决Nginx: [error] open() ＂/usr/local/Nginx/logs/Nginx.pid错误

重新启动服务器,访问web服务发现无法浏览啦!登陆服务器之后进到nginx使用./nginx -s reload重新读取配置文件,发现报nginx: [error] open() "/usr/local/nginx/logs/nginx.pid" failed (2: No such file or directory)错误,进到logs文件发现的确没有nginx.pid文件   [root@localhost sbin]# ./nginx -s reload nginx: [erro

解决The source directory ＂/usr/local＂ does not appear to contain CMakeLists.txt错误

风信网(ithov.com)原创文章:今天编译mysql-5.6.15-linux-glibc2.5-x86_64.tar.gz版本,决是报错,信息如下: [root@localhost mysql]# scripts/mysql_install_db --user=http://www.aliyun.com/zixun/aggregation/33.html">mysql --basedir=/usr/local/mysql --datadir=/data/mysql/data --fo

php *.php和/usr/local/php/bin/php *.php的区别

说一个基本概念,很多人可能会遇到过这种情况,有些PHP程序因为部署原因会在linux命令行下执行,这样就会用到php命令执行,例如: php index.php 很方便,但也会出现一些问题,例如: PHP Fatal error:  Class 'PDO' not found in PHP Fatal error:  Class 'Curl' not found in PHP Fatal error:  Class 'Redis' not found in ...等等,我们统称为Class no