List:Replication« Previous MessageNext Message »
From:MARK CALLAGHAN Date:December 6 2009 4:27pm
Subject:Re: ERROR 1062: Duplicate entry - replication
View as plain text  
On Sun, Dec 6, 2009 at 7:15 AM, Simon J Mudd <sjmudd@stripped> wrote:
> song.voong@stripped (Song Voong) writes:
>
>> I been getting this error and my replication stoppped.
>>
>> ERROR 1062: Duplicate entry
>>  Last_Error: Error 'Duplicate entry '1010769-50-65% Cttn, 35% Rayon' for
> key
>> 2' on query. Default database: 'm3'. Query: 'Update item_attribute SET
>> lupdateby='TINAA',item_id='1010769',value='65% Cttn, 35%
>> Rayon',source=3,attribute_definition_id='50' WHERE item_attribute_ID =
>> 118838555'
>>
>> I know I can do a  slave-skip-errors 1062 and by pass it, I been reading
> the
>> forum and it is a common issues with replication, But what is causing this?
>> I mean it is updating stuff on the master, and slave should get updated too
>> . NO?

Simon listed many good things to check. There are two other things to check:
1) confirm the slave did not crash/restart (either mysqld restart or
server reboot). Slave replication state is not crashproof and on a
crash transactions can get replayed. This is easy to check.

2) confirm applications are not connecting to the slave and changing
rows directly. This is not easy to check. Even when the slave runs
with read_only set, an account with SUPER privilege can modify rows.

-- 
Mark Callaghan
mdcallag@stripped
Thread
ERROR 1062: Duplicate entry - replicationSong Voong3 Dec
  • Re: ERROR 1062: Duplicate entry - replicationSimon J Mudd6 Dec
    • Re: ERROR 1062: Duplicate entry - replicationMARK CALLAGHAN6 Dec
      • Re: ERROR 1062: Duplicate entry - replicationSimon J Mudd6 Dec
        • Re: ERROR 1062: Duplicate entry - replicationMARK CALLAGHAN6 Dec
          • Re: ERROR 1062: Duplicate entry - replicationSimon J Mudd7 Dec