Updates From My Change Stream Are Missing
Issue
Updates from my change stream are missing.
Environment
Connector: MongoDB
Resolution
If you haven't received any errors, you can resolve this issue by appending either of the following queries to your MongoDB connection string:
readPreference=primary
readPreference=primaryPreferred
See MongoDB's Read Preference Modes documentation for more information.
If you receive related errors or the issue persists, contact Fivetran support.
Cause
This issue may occur if your MongoDB cluster experiences issues while replicating data to your replica set secondary.