Resolved : mysql replica : Relay log read failure: Could not parse relay log event entry.

I’m not sure what the root cause may be. But to recover from this situation, you’d want to instruct MySQL to clear out all the relay-bin-logs beyond the following point

  • Relay_Master_Log_File: mysql-bin.000xxx
  • Exec_Master_Log_Pos: 143983426

by doing the following:

mysql> STOP SLAVE;

mysql> CHANGE MASTER TO MASTER_LOG_FILE = 'mysql-bin.000xxx', MASTER_LOG_POS = 143983426;

mysql> START SLAVE;

 

 

 

8 thoughts on “Resolved : mysql replica : Relay log read failure: Could not parse relay log event entry.

  • January 26, 2015 at 3:20 am
    Permalink

    Hi there very nice site!! Guy .. Beautiful ..
    Wonderful .. I’ll bookmark your site and take the feeds additionally?
    I am glad to seek out so many useful information here
    within the put up, we want develop extra techniques in this regard, thanks
    for sharing. . . . . .

    Reply
  • January 27, 2015 at 10:54 pm
    Permalink

    Just desire to say your article is as astounding. The clarity
    for your put up is simply excellent and that i could suppose you
    are an expert on this subject. Well together with your permission allow me
    to clutch your feed to keep up to date with forthcoming post.
    Thank you 1,000,000 and please continue the gratifying work.

    My web page … inspiration

    Reply
  • January 27, 2015 at 11:39 pm
    Permalink

    My coder is trying to persuade me to move to .net from PHP.
    I have always disliked the idea because of the expenses.
    But he’s tryiong none the less. I’ve been using WordPress on a
    variety of websites for about a year and am nervous about switching to another platform.
    I have heard excellent things about blogengine.net.
    Is there a way I can transfer all my wordpress posts into it?
    Any help would be really appreciated!

    Reply
  • January 28, 2015 at 1:50 am
    Permalink

    Hi there, i read your blog occasionally and i own a similar
    one and i was just curious if you get a lot of spam remarks?
    If so how do you stop it, any plugin or anything you can suggest?

    I get so much lately it’s driving me crazy so any assistance is very much appreciated.

    Reply
  • January 28, 2015 at 3:12 am
    Permalink

    certainly like your web-site however you have to
    take a look at the spelling on several of your posts.
    A number of them are rife with spelling problems and I find it very bothersome to
    tell the reality on the other hand I’ll definitely come back again.

    Reply
  • February 24, 2015 at 2:48 am
    Permalink

    I wasn’t sure which one is Feet, and then you could put it
    so click here now we’re actually done.

    Reply
  • March 7, 2015 at 8:45 am
    Permalink

    Which is a click here lot to build. And I’ll see you guys a few
    tips and interview advice and everything in there until cured.

    Reply
  • March 10, 2015 at 3:34 am
    Permalink

    I got this web site from my pal who shared with me regarding this website and at the moment this time I am browsing this web page and reading very informative articles or reviews at this time.

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *

%d bloggers like this: