Mon Sep 7 22:17:00 2020 - [info] Connecting to root@192.168.142.134(192.168.142.134:22)..
Checking slave recovery environment settings..
Opening /home/mysql/data/relay-log.info ... ok.
Relay log found at /home/mysql/data, up to mysql-relay-bin.000002
Temporary relay log file is /home/mysql/data/mysql-relay-bin.000002
Checking if super_read_only is defined and turned on.. not present or turned off, ignoring.
Testing mysql connection and privileges..
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1175 (HY000) at line 1: Unknown error 1175
mysql command failed with rc 1:0!
at /usr/local/bin/apply_diff_relay_logs line 404.
main::check() called at /usr/local/bin/apply_diff_relay_logs line 536
eval {...} called at /usr/local/bin/apply_diff_relay_logs line 514
main::main() called at /usr/local/bin/apply_diff_relay_logs line 121
Mon Sep 7 22:17:00 2020 - [error][/usr/lib/perl5/site_perl/5.18.2/MHA/MasterMonitor.pm, ln208] Slaves settings check failed!
Mon Sep 7 22:17:00 2020 - [error][/usr/lib/perl5/site_perl/5.18.2/MHA/MasterMonitor.pm, ln416] Slave configuration failed.
Mon Sep 7 22:17:00 2020 - [error][/usr/lib/perl5/site_perl/5.18.2/MHA/MasterMonitor.pm, ln427] Error happened on checking configurations. at /usr/local/bin/masterha_check_repl line 48.
Mon Sep 7 22:17:00 2020 - [error][/usr/lib/perl5/site_perl/5.18.2/MHA/MasterMonitor.pm, ln525] Error happened on monitoring servers.
Mon Sep 7 22:17:00 2020 - [info] Got exit code 1 (Not master dead).
lcl401615068
commented
2 years ago
Mon Sep 7 22:17:00 2020 - [info] Connecting to root@192.168.142.134(192.168.142.134:22).. Checking slave recovery environment settings.. Opening /home/mysql/data/relay-log.info ... ok. Relay log found at /home/mysql/data, up to mysql-relay-bin.000002 Temporary relay log file is /home/mysql/data/mysql-relay-bin.000002 Checking if super_read_only is defined and turned on.. not present or turned off, ignoring. Testing mysql connection and privileges.. mysql: [Warning] Using a password on the command line interface can be insecure. ERROR 1175 (HY000) at line 1: Unknown error 1175 mysql command failed with rc 1:0! at /usr/local/bin/apply_diff_relay_logs line 404. main::check() called at /usr/local/bin/apply_diff_relay_logs line 536 eval {...} called at /usr/local/bin/apply_diff_relay_logs line 514 main::main() called at /usr/local/bin/apply_diff_relay_logs line 121 Mon Sep 7 22:17:00 2020 - [error][/usr/lib/perl5/site_perl/5.18.2/MHA/MasterMonitor.pm, ln208] Slaves settings check failed! Mon Sep 7 22:17:00 2020 - [error][/usr/lib/perl5/site_perl/5.18.2/MHA/MasterMonitor.pm, ln416] Slave configuration failed. Mon Sep 7 22:17:00 2020 - [error][/usr/lib/perl5/site_perl/5.18.2/MHA/MasterMonitor.pm, ln427] Error happened on checking configurations. at /usr/local/bin/masterha_check_repl line 48. Mon Sep 7 22:17:00 2020 - [error][/usr/lib/perl5/site_perl/5.18.2/MHA/MasterMonitor.pm, ln525] Error happened on monitoring servers. Mon Sep 7 22:17:00 2020 - [info] Got exit code 1 (Not master dead).
MySQL Replication Health is NOT OK!
Please ask the gods what's going on?