MySQL Forums
Forum List  »  Replication

Re: Got fatal error 1236
Posted by: Tommy Peterson
Date: December 03, 2020 07:15PM

Thanks for the reply. I saw the first article you provided. I saw a couple on stackoverflow. But none of them fix my problem. They basically just reiterate the process I followed with the exception of "CHANGE MASTER TO MASTER_HOST=" step which I understand I don't have to (besides all of that is still set when I show slave status). But if I try to change the log/position to what show master status on the slave says I get an error saying I cannot change it when auto is on.

I'm just wondering what the message means. How can the slave be different than the master . . . have more GTIDs . . . when I just restored a dump of master to the slave?

Again do I have to shut down master or lock users out to do this?

Options: ReplyQuote

Written By
December 03, 2020 07:00PM
December 03, 2020 07:08PM
Re: Got fatal error 1236
December 03, 2020 07:15PM
December 03, 2020 11:54PM
December 04, 2020 04:56AM
December 04, 2020 10:37AM
December 04, 2020 11:46AM
December 04, 2020 01:16PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.