MySQL Forums
Forum List  »  Replication

Slave Replication Error
Posted by: Tyler Ingram
Date: May 04, 2005 07:47AM


I'm fairly new to this replication stuff and I had my webhost set it up.

Currently my Slave is not updating from the remote master.

I do a SHOW MASTER STATUS on the remote and its up and running without errors. Though I run SHOW SLAVE STATUS on the local machine and it has an error:

error ' Duplicate entry '25173' for key 1' on query 'INSERT INTO users VALUES('','780', '922-6766', 'digicom', '(hidden)', 'Canada', 'Dealer A')'

And Slave_Running is No

Does the replication just halt completely until this Duplicate entry is fixed?? How did this duplication happen in the first place? The master is the one we edit, no one but myself has access to the Slave (for editing purposes anyway)



Options: ReplyQuote

Written By
Slave Replication Error
May 04, 2005 07:47AM
May 04, 2005 08:35AM
May 05, 2005 03:47PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.