search

yoshinorim / mha4mysql-manager

Development tree of Master High Availability Manager and tools for MySQL (MHA), Manager part
http://code.google.com/p/mysql-master-ha/
GNU General Public License v2.0
1.47k stars 500 forks source link

[error][/usr/share/perl5/MHA/ServerManager.pm, ln188] There is no alive server. We can't do failover #112

Open lanhong opened 6 years ago

lanhong commented 6 years ago

环境：ubuntu16.04，mysql5.7，mha 源码安装的，0.58版本 错误1：masterha运行一段时间后自动死掉，查看mysql所有节点都是正常的，masterha的manager.log日志报错如下： environment：ubuntu16/04,msyql5.7, mha version is 0.58. source code install error: masterha pid is lost after running one day. all of mysql nodes is right. the error log of manager.log show: Tue Jun 26 03:06:56 2018 - [debug] Got MySQL error when connecting 192.168.42.39(192.168.42.39:3306) :2026:SSL connection error: unable to use random device Tue Jun 26 03:06:56 2018 - [debug] Got MySQL error when connecting 192.168.42.40(192.168.42.40:3306) :2026:SSL connection error: unable to use random device Tue Jun 26 03:06:57 2018 - [error][/usr/share/perl5/MHA/ServerManager.pm, ln188] There is no alive server. We can't do failover Tue Jun 26 03:06:57 2018 - [warning] Got Error: at /usr/share/perl5/MHA/MasterMonitor.pm line 562. Tue Jun 26 03:06:57 2018 - [info] Got exit code 1 (Not master dead).

Hoastar commented 6 years ago

烦请指点一二。问题如: [warning] master_ip_failover_script is not defined. Tue Sep 25 22:08:21 2018 - [warning] shutdown_script is not defined. Tue Sep 25 22:08:21 2018 - [info] Set master ping interval 2 seconds. Tue Sep 25 22:08:21 2018 - [warning] secondary_check_script is not defined. It is highly recommended setting it to check master reachability from two or more routes. Tue Sep 25 22:08:21 2018 - [info] Starting ping health check on 192.168.122.80(192.168.122.80:3306).. Tue Sep 25 22:08:29 2018 - [warning] Got error when monitoring master: at /usr/share/perl5/vendor_perl/MHA/MasterMonitor.pm line 489. Tue Sep 25 22:08:29 2018 - [error][/usr/share/perl5/vendor_perl/MHA/MasterMonitor.pm, ln491] Target master's advisory lock is already held by someone. Please check whether you monitor the same master from multiple monitoring processes. Tue Sep 25 22:08:29 2018 - [error][/usr/share/perl5/vendor_perl/MHA/MasterMonitor.pm, ln511] Error happened on health checking. at /usr/bin/masterha_master_monitor line 48. Tue Sep 25 22:08:29 2018 - [error][/usr/share/perl5/vendor_perl/MHA/MasterMonitor.pm, ln525] Error happened on monitoring servers.

meishibiexuejava commented 3 years ago

[root@10-9-165-193 ~]# masterha_check_repl --conf=/etc/mha/app1.cnf Fri Aug 13 00:19:54 2021 - [info] Reading default configuration from /etc/masterha_default.cnf.. Fri Aug 13 00:19:54 2021 - [info] Reading application default configuration from /etc/mha/app1.cnf.. Fri Aug 13 00:19:54 2021 - [info] Reading server configuration from /etc/mha/app1.cnf.. Fri Aug 13 00:19:54 2021 - [info] MHA::MasterMonitor version 0.58. Fri Aug 13 00:19:55 2021 - [error][/usr/share/perl5/vendor_perl/MHA/ServerManager.pm, ln188] There is no alive server. We can't do failover Fri Aug 13 00:19:55 2021 - [error][/usr/share/perl5/vendor_perl/MHA/MasterMonitor.pm, ln427] Error happened on checking configurations. at /usr/share/perl5/vendor_perl/MHA/MasterMonitor.pm line 329. Fri Aug 13 00:19:55 2021 - [error][/usr/share/perl5/vendor_perl/MHA/MasterMonitor.pm, ln525] Error happened on monitoring servers. Fri Aug 13 00:19:55 2021 - [info] Got exit code 1 (Not master dead).

fangkai2017 commented 3 years ago

[root@10-9-165-193 ~]# masterha_check_repl --conf=/etc/mha/app1.cnf Fri Aug 13 00:19:54 2021 - [info] Reading default configuration from /etc/masterha_default.cnf.. Fri Aug 13 00:19:54 2021 - [info] Reading application default configuration from /etc/mha/app1.cnf.. Fri Aug 13 00:19:54 2021 - [info] Reading server configuration from /etc/mha/app1.cnf.. Fri Aug 13 00:19:54 2021 - [info] MHA::MasterMonitor version 0.58. Fri Aug 13 00:19:55 2021 - [error][/usr/share/perl5/vendor_perl/MHA/ServerManager.pm, ln188] There is no alive server. We can't do failover Fri Aug 13 00:19:55 2021 - [error][/usr/share/perl5/vendor_perl/MHA/MasterMonitor.pm, ln427] Error happened on checking configurations. at /usr/share/perl5/vendor_perl/MHA/MasterMonitor.pm line 329. Fri Aug 13 00:19:55 2021 - [error][/usr/share/perl5/vendor_perl/MHA/MasterMonitor.pm, ln525] Error happened on monitoring servers. Fri Aug 13 00:19:55 2021 - [info] Got exit code 1 (Not master dead).

你好，我也遇到这个问题了。请问你最后解决了吗？怎么解决的

dreamsleet commented 3 years ago

我的之前是正常，异常中断后，日志显示应该是当时与sql服务器的连接中断了，检测时出现这个错误应该也是类似与sql服务器的通讯问题，防火墙，修改了端口等

dreamsleet commented 3 years ago

另外还可能是sql服务器中配置的mha管理账号权限有问题