Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am setting up master-master replication with MySQL.

Writes are done only to Master1. Master2 is slave of Master1 and is replicating perfectly. When I set Master1 as slave of Master2, I get lots of the following errors:

Lock wait timeout exceeded

When I stop replicating on Master1 (with STOP SLAVE), the errors stop too.

What could cause this? I figured it could be some sort of circular replication loop. But why?

share|improve this question

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.