----- Original Message ----- > From: "Néstor" <rot...@gmail.com> > > I spoke to soon!!! > Here is the error about 1.5 hours after replication has started. > 121205 16:39:51 [ERROR] Slave: Error 'Duplicate entry '3468897' > for
Yes, that's what you get for running SQL_SLAVE_SKIP_COUNTER without knowing what the problem is. Your database is now nicely out of sync, and hopefully it's just the watchdog. The *proper* way of resolving this is to resync the entire database. You *may* get away with deleting watchdog entry 3468897 and restarting replication as someone has suggested, but I suspect you'll find another half-million of them. Look at the Percona Toolkit, specifically mk-table-checksum and mk-table-sync, understand how they work and then apply them. If there's too many differences by now, your only recourse will be to completely reprovision the slave, though. -- Linux Bier Wanderung 2012, now also available in Belgium! August, 12 to 19, Diksmuide, Belgium - http://lbw2012.tuxera.be -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
