I got the same problem. In theory there should be some method to avoid duplicate entry during replication, but in practise all that way seems to fail, mybe I'm not using it properly ( see my threads on this topic ). The only can help you go on , but is a dirty trick is remove the file from the slave and restart the replication.
some like that: set sql_log_bin = 0; delete from log_siv where id > 84600; set sql_log_bin = 1; PS. I'm interested to deep that subject, so please keep me update if you find some other hints on that topic. Regards, Enzo -----Messaggio originale----- Da: PaginaDeSpud [mailto:[EMAIL PROTECTED] Inviato: mercoledì 28 dicembre 2005 22.38 A: mysql@lists.mysql.com Oggetto: inconsistent replication? Hi, Some hours ago i setup the replication for my cluster and it's the third time i need to reset the replication and copy the whole database from master to slave due to errors like this: 051228 17:13:35 [ERROR] Slave: Error 'Duplicate entry '9947776' for key 1' on query. Default database: 'genteya'. Query: 'INSERT INTO `comentarios` (id, idcom, nickcom, comentario, reply, ip, fecha) VALUES ('84600', '264452', 'cipr22valencia', 'graias por los puntitos cielo pero si hay algo que me gustaria mas que salir en primera paguina es conocerte mas jijiji aver si te veo por mi *** o me das el tuyo un kiss y toma+++ puntitos ', 'S', '81.202.240.73', '1135811423')', Error_code: 1062 051228 17:13:35 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'mysql-bin.000004' position 184226200 I don't know why, but primary keys are inserted in slave with different (autoincrement) numbers than master, and replication shut down in slave. CREATE TABLE `comentarios` ( `index` int(25) NOT NULL auto_increment, `id` int(9) NOT NULL default '0', `idcom` int(9) NOT NULL default '0', `nickcom` varchar(15) NOT NULL default '', `comentario` text NOT NULL, `reply` char(1) NOT NULL default '', `ip` varchar(15) NOT NULL default '', `fecha` bigint(20) NOT NULL default '0', PRIMARY KEY (`index`), KEY `idcom` (`idcom`), KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 Any idea? Thanks. Ivan Lopez. Logosur. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
