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]
