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
215
December 03, 2020 07:00PM
77
December 03, 2020 07:08PM
Re: Got fatal error 1236
69
December 03, 2020 07:15PM
57
December 03, 2020 11:54PM
57
December 04, 2020 04:56AM
58
December 04, 2020 10:37AM
55
December 04, 2020 11:46AM
69
December 04, 2020 01:16PM


Sorry, only registered users may post in this forum.

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.