> Is it in read only mode? Furthermore, are all users logging in as non-SUPER users? Note: root bypasses the readonly flag!
> -----Original Message----- > From: Manuel Arostegui [mailto:man...@tuenti.com] > 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.ci...@gmail.com> > > > On Wed, Feb 13, 2013 at 8:59 AM, Robert Citek > <robert.ci...@gmail.com> > > 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. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql