maria-discuss team mailing list archive

[Alessandro Ren <dirty.ren@xxxxxxxxx>]

  About replication, I dont let it stop on duplicate keys, I prefer to use
slave-skip-errors = all and let the primary key on the tables take care of
duplicate records.
  Replication will only stop if something is corrupted, which may be your
case. Some position the the binlog got lost in the power outage and you
will have to reposition the master slave binlog, probably loosing some data
on one side.

   []s.


On Wed, Jul 4, 2018 at 8:02 AM, Guillaume Lefranc <guillaume@xxxxxxxxxxxx>
wrote:

> 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
>>
>
> _______________________________________________
> 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
>
>