> Is it in read only mode?
Furthermore, are all users logging in as non-SUPER users? Note: root bypasses the
> -----Original Message-----
> From: Manuel Arostegui [mailto:manuel@stripped]
> Sent: Thursday, February 14, 2013 1:55 PM
> To: Robert Citek
> Cc: mysql
> Subject: Re: slave replication with lots of 'duplicate entry' errors
> 2013/2/13 Robert Citek <robert.citek@stripped>
> > On Wed, Feb 13, 2013 at 8:59 AM, Robert Citek
> > 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?
> 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',
> And if you're using the right IP, there's no reason to have duplicate
> entries unless someone is writing directly into the slave.