Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

MHA mysql command failed with rc 1:0! #141

Open
shiyajing opened this issue Sep 7, 2020 · 1 comment
Open

MHA mysql command failed with rc 1:0! #141

shiyajing opened this issue Sep 7, 2020 · 1 comment

Comments

@shiyajing
Copy link

Mon Sep 7 22:17:00 2020 - [info] Connecting to [email protected](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?

@lcl401615068
Copy link

open GTID,will be ok ?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants