maria-discuss team mailing list archive

[Guillaume Lefranc <guillaume@xxxxxxxxxxxx>]

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