Guest User

Untitled

a guest
May 23rd, 2018
71
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.88 KB | None | 0 0
  1. 160523 13:07:29 [ERROR] Slave SQL: Error 'Duplicate entry '914166' for key
  2. 'PRIMARY'' on query. Default database: 'zo_dev_20121216'. Query: 'UPDATE
  3. activity
  4. SET
  5. activity_type_id = 9,
  6. subject = 'Send departure email',
  7. date_due = '2016-05-26 01:00',
  8. date_start = '2016-05-23 01:00',
  9. activity_status_id = 1,
  10. content = 'Send departure email'
  11. WHERE
  12. id = 2888555', Error_code: 1062
  13. 160523 13:07:29 [Warning] Slave: Duplicate entry '914166' for key 'PRIMARY'
  14. Error_code: 1062
  15. 160523 13:07:29 [ERROR] Error running query, slave SQL thread aborted. Fix
  16. the problem, and restart the slave SQL thread with "SLAVE START". We stopped
  17. at log 'mysql-bin.000004' position 14847360
  18.  
  19. stop slave;
  20.  
  21. set global sql_slave_skip_counter = 1;
  22.  
  23. start slave;
  24.  
  25. select * from zo_dev_20121216.activity where id = 914166;
  26.  
  27. select * from zo_dev_20121216.activity where id = 914166;
Add Comment
Please, Sign In to add comment