Question
Why did the MongoDB connector initiate a full historical re-sync without explanation?
Environment
Connector: MongoDB
Answer
To prevent this from happening, please contact your Database Administrator to set your Mongo Oplog Retention Period to between 24 hours and 7 days, as per our Mongo DB Setup Guide.
Cause
When the oplog retention is set to lower than the recommended value of 24 hours, it becomes increasingly more likely that we lose the location of the sync progress.
If this occurs, the connector will automatically re-sync to recover. No action is needed.