title: MySQL Replication Error(1062)
body: <p>I am new to MySQL and after a long search I am able to configure master-slave ROW based replication. I thought it would be safe and I would not have to recheck it again and again.</p>
  
  <p>But today when I did <code>SHOW SLAVE STATUS;</code> on slave then I found following</p>
  
  <blockquote>
    <p>could not execute Write_rows event on
    table mydatabasename.atable; Duplicate
    entry '174465' for key 'PRIMARY',
    Error_code: 1062; handler error
    HA_ERR_FOUND_DUPP_KEY; the event's
    master log mysql-bin.000004,
    end_log_pos 60121977</p>
  </blockquote>
  
  <p>Can someone tell me how this can even come when master has no such error and schema on both server is the same then how could this happen. And how to fix it to make this work again and how to prevent such thing in future.</p>
  
  <p>Please also let me know what else unexpected I should expect other than this.</p>