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

Maunal purge_relay_logs crash my replication #108

Open
GoogleCodeExporter opened this issue Jul 30, 2015 · 2 comments
Open

Maunal purge_relay_logs crash my replication #108

GoogleCodeExporter opened this issue Jul 30, 2015 · 2 comments

Comments

@GoogleCodeExporter
Copy link
Contributor

Try to manual purge the relay log on MHA second master, my command as below:
purge_relay_logs --user=root --password=123123 --port=3306 
-disable_relay_log_purge --workdir=/usr/local/mysql/data/ >> 
/usr/local/mysql/data/purge_relay_logs.log 2>&1

after run the command, will clear all of my relay logs, then my replication 
crashed and get this error:

Last_SQL_Error: Relay log read failure: Could not parse relay log event entry. 
The possible reasons are: the master's binary log is corrupted (you can check 
this by running 'mysqlbinlog' on the binary log), the slave's relay log is 
corrupted (you can check this by running 'mysqlbinlog' on the relay log), a 
network problem, or a bug in the master's or slave's MySQL code. If you want to 
check the master's binary log or slave's relay log, you will be able to know 
their names by issuing 'SHOW SLAVE STATUS' on this slave.

Anybody can tell me how to clear those relay logs on MHA? thanks.

Best Regards
Garey

Original issue reported on code.google.com by [email protected] on 2 Mar 2015 at 8:08

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

No branches or pull requests

1 participant