Dears,
i have a setup with 1 master and 3 slaves, i had an issue on one of the slave nodes that caused the server to be stopped and caused the slave to be out of sync.
i tried the below to restart its replication with no luck:
- stop slave on the working slave
- take master log file and master log pos
- taking mysqldump
- start the slave
- restore the dump on the defected noded
- run
CHANGE MASTER TO MASTER_HOST='<mysql master node ip>',
MASTER_USER='rt_user',
MASTER_PASSWORD='<rt_user password>',
MASTER_LOG_FILE='<Master node Log File>',
MASTER_LOG_POS=<position value>;
- start slave
its still not working and im getting the below errors in the logfile:
- replica sql for channel '': worker 1 failed executing transaction 'ANONYMOUS' at source log could not execute write_rows event on table.. duplicate entry
- replica sql for channel '': worker 1 failed executing transaction 'ANONYMOUS' at source log could not execute update_rows event on table.. record not found
appreciate your help