← Back to team overview

maria-discuss team mailing list archive

Re: Replication Problem


Hi Thomas,

Could you please show the output of SHOW SLAVE STATUS and SHOW VARIABLES
LIKE 'gtid%' ?


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@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-discuss
> More help   : https://help.launchpad.net/ListHelp

Follow ups