Hi Thomas, Could you please show the output of SHOW SLAVE STATUS and SHOW VARIABLES LIKE 'gtid%' ?
Thanks Guillaume Lefranc signal18.io consulting Le mer. 4 juil. 2018 à 12:31, Thomas Plant <thomas@plant.systems> a écrit : > Hello, > > I'd have a question about MariaDB 10.1 replication, which has been > interrupted by a power outage in our datacenter. > We started the master server and had a duplicate id in a table on the > slave, so replication stopped. We did not have time to adjust this at > the moment, there were a lot of other systems to start and check if all > was alright. > > Today I had time to look at the error, removed the duplicate ID from the > table and started the slave thread again using 'start slave;'. > > But now I get another error: > > Last_IO_Error: Got fatal error 1236 from master when reading data from > binary log: 'Error: connecting slave requested to start from GTID > 0-2-2948175468, which is not in the master's binlog. Since the master's > binlog contains GTIDs with higher sequence numbers, it probably means > that the slave has diverged due to executing extra erroneous transactions' > > Can this be resolved? Or will I have to start replication from scratch? > > Greetings, > Thomas > > _______________________________________________ > Mailing list: https://launchpad.net/~maria-discuss > Post to : maria-discuss@lists.launchpad.net > Unsubscribe : https://launchpad.net/~maria-discuss > More help : https://help.launchpad.net/ListHelp >
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
