List:General Discussion« Previous MessageNext Message »
From:Manuel Arostegui Date:February 14 2013 9:54pm
Subject:Re: slave replication with lots of 'duplicate entry' errors
View as plain text  
2013/2/13 Robert Citek <robert.citek@stripped>

> On Wed, Feb 13, 2013 at 8:59 AM, Robert Citek <robert.citek@stripped>
> wrote:
> > Any other possibilities?  Do other scenarios become likely if there
> > are two or more tables?
> >
> > Of those, which are the most likely?
>
> [from off-list responder]:
> > Other possibility: The replication is reading from master not from the
> point when the dump was done, but some time before and is fetching insert
> statements which are already in the dump.
>
> To prevent that I used the coordinates in the dump file included with
> --master-data=2.  Could the coordinates still be off?


Hello,

Are you sure nothing is getting inserted directly into the slave? Is it in
read only mode?
If you're starting replication using the values provided by --master-data=2
(which should be something like):

 -- Position to start replication or point-in-time recovery from

-- CHANGE MASTER TO MASTER_LOG_FILE='mysql-bin.000974',
MASTER_LOG_POS=240814775;

And if you're using the right IP, there's no reason to have duplicate
entries unless someone is writing directly into the slave.

Manuel.

Thread
slave replication with lots of 'duplicate entry' errorsRobert Citek13 Feb
  • Re: slave replication with lots of 'duplicate entry' errorsRobert Citek13 Feb
    • Re: slave replication with lots of 'duplicate entry' errorsManuel Arostegui14 Feb
      • RE: slave replication with lots of 'duplicate entry' errorsRick James14 Feb
        • Re: slave replication with lots of 'duplicate entry' errorsRobert Citek14 Feb
          • RE: slave replication with lots of 'duplicate entry' errorsRick James14 Feb
            • Re: slave replication with lots of 'duplicate entry' errorsRobert Citek15 Feb
      • Re: slave replication with lots of 'duplicate entry' errorsRobert Citek14 Feb
        • Re: slave replication with lots of 'duplicate entry' errorsSinger Wang14 Feb
          • Re: slave replication with lots of 'duplicate entry' errorsRobert Citek14 Feb
        • Re: slave replication with lots of 'duplicate entry' errorsManuel Arostegui15 Feb