Advertisement
Guest User

Untitled

a guest
May 26th, 2016
79
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.06 KB | None | 0 0
  1. 120104 11:07:54 [Warning] Slave: Duplicate entry '94459' for key 'PRIMARY' Error_code: 1062
  2. 120104 11:07:54 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'mysql1-bin.000362' position 3384732
  3.  
  4. Slave_IO_State: Waiting for master to send event
  5. Master_Host: 10.4.16.245
  6. Master_User: replicant
  7. Master_Port: 3306
  8. Connect_Retry: 60
  9. Master_Log_File: mysql-bin.001527
  10. Read_Master_Log_Pos: 554619670
  11. Relay_Log_File: relay-bin.004561
  12. Relay_Log_Pos: 554619815
  13. Relay_Master_Log_File: mysql-bin.001527
  14. Slave_IO_Running: Yes
  15. Slave_SQL_Running: Yes
  16. Replicate_Do_DB:
  17. Replicate_Ignore_DB: phpmyadmin
  18. Replicate_Do_Table:
  19. Replicate_Ignore_Table:
  20. Replicate_Wild_Do_Table:
  21. Replicate_Wild_Ignore_Table:
  22. Last_Errno: 0
  23. Last_Error:
  24. Skip_Counter: 0
  25. Exec_Master_Log_Pos: 554619670
  26. Relay_Log_Space: 554620007
  27. Until_Condition: None
  28. Until_Log_File:
  29. Until_Log_Pos: 0
  30. Master_SSL_Allowed: No
  31. Master_SSL_CA_File:
  32. Master_SSL_CA_Path:
  33. Master_SSL_Cert:
  34. Master_SSL_Cipher:
  35. Master_SSL_Key:
  36. Seconds_Behind_Master: 0
  37. Master_SSL_Verify_Server_Cert: No
  38. Last_IO_Errno: 0
  39. Last_IO_Error:
  40. Last_SQL_Errno: 0
  41. Last_SQL_Error:
  42.  
  43. CHANGE MASTER TO master_log_file='mysql-bin.001527',master_log_pos=554619670;
  44.  
  45. $ service mysql restart --skip-slave-start
  46.  
  47. mysql> SHOW SLAVE STATUSG
  48.  
  49. CHANGE MASTER TO master_log_file='mysql1-bin.000362'. master_log_pos=3384732;
  50.  
  51. CHANGE MASTER TO
  52. MASTER_HOST='IP Address of Master',
  53. MASTER_PORT=3306,
  54. MASTER_USER='Replication Username',
  55. MASTER_PASSWORD='Replication Password',
  56. MASTER_LOG_FILE='mysql1-bin.000362',
  57. MASTER_LOG_POS=3384732;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement