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


Subject
Views
Written By
Posted
3526
December 03, 2020 07:00PM
774
December 03, 2020 07:08PM
Re: Got fatal error 1236
617
December 03, 2020 07:15PM
492
December 03, 2020 11:54PM
470
December 04, 2020 04:56AM
484
December 04, 2020 10:37AM
564
December 04, 2020 11:46AM
544
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.