Hi Guys,
We are running mySQL slave replication on our servers and our slave breaks connection due to an error to one specific table.
The query is
Error 'Duplicate entry '24954' for key 1' on query. Default database: 'sitename_vb'. Query: 'INSERT INTO vb3_vbseo_linkback
(t_time, t_src_url, t_dest_url, t_type, t_postid, t_postcount, t_threadid, t_page,
t_title, t_text, t_approve, t_incoming, t_wait)
It consistently breaks every minute. We then have to ignore the query and then start the replication again. Is there a way around this? This is urgent since we now have had to shut down the slave .. any leads will be appreciated.
Thanks


LinkBack URL
About LinkBacks





Reply With Quote