Bug #57868 replication,record error in log but the slave not stop.
Submitted: 31 Oct 2010 7:07 Modified: 1 Nov 2010 12:43
Reporter: ri chen Email Updates:
Status: Unsupported Impact on me:
None 
Category:MySQL Server: Errors Severity:S2 (Serious)
Version:4.0.27 OS:Linux (suse with kernel 2.6.16.60-0.21)
Assigned to: CPU Architecture:Any
Tags: replication

[31 Oct 2010 7:07] ri chen
Description:
hi all:
i use the version 4.0.27 to do the replication.

the question is that the error-log in slave is like this:
ERROR: 1062  Duplicate entry 'sports_h-info-20101031132859-0' for key 1
ERROR: 1062  Duplicate entry 'sports_h-info-20101031140653-0' for key 1
ERROR: 1062  Duplicate entry 'sports_h-info-20101031143642-0' for key 1
ERROR: 1062  Duplicate entry 'sports_h-info-20101031143707-0' for key 1
ERROR: 1062  Duplicate entry 'sports_h-info-20101031143734-0' for key 1

and it increases everyday,while the slave not stop and seems like everything is ok.
 
*************************** 1. row ***************************
          Master_Host: 172.27.31.45
          Master_User: repl
          Master_Port: 3306
        Connect_retry: 60
      Master_Log_File: master_bin.434
  Read_Master_Log_Pos: 399183174
       Relay_Log_File: relay_bin.436
        Relay_Log_Pos: 688832434
Relay_Master_Log_File: master_bin.434
     Slave_IO_Running: Yes
    Slave_SQL_Running: Yes
      Replicate_do_db: 
  Replicate_ignore_db: 
           Last_errno: 0
           Last_error: 
         Skip_counter: 0
  Exec_master_log_pos: 399183174
      Relay_log_space: 688832434
1 row in set (0.00 sec)

now what i want is which command cause this error ,but i can't find it ,because there is no infomation in "show slave status" or in err-log...help!!!

just tell me how to find the problematical command so that i can fix it.

Does anyone meet the same situation?? and i don't know what to do now ,i need your help ,my friends,please.

addition:
1,i do not ingore this error number in my.cnf

How to repeat:
i am waiting for how to repeat..
[1 Nov 2010 12:43] Miguel Solorzano
Could you please upgrade for current version server. 

http://www.mysql.com/about/legal/lifecycle/