Troubleshooting replication pauses due to swapping
Hi, I have a mysql -> redshift replication that is frequently pausing CDC with the following message: "Reading from source endpoint temporary paused as total storage used by swap files exceeded the limit for task"
I've tried increasing the values for BatchApplyMemoryLimit & MemoryLimitTotal, but it hasn't seemed to change the behavior, any suggestion on how I should troubleshoot this issue?
We are getting same message in our prod DMS jobs. DMS jobs are from different sources to a RDS oracle instance.
Did you find any solution?
I am getting this as well. any ideas? tips? i'm doing a single On Prem Oracle Instance to a Single AWS RDS Oracle Instance.
This might help some https://stackoverflow.com/questions/66040310/aws-dms-swap-files-consumes-all-the-space
Relevant questions
MySQL DMS continuous replication with schema changes.
Accepted Answerasked 5 years agoDelayed Replication w/ Aurora MySQL
Accepted Answerasked 3 years agoTroubleshooting replication pauses due to swapping
asked 2 years agoDMS CDC for SQL Server - Replication
Accepted AnswerAWS DMS doing a SELECT on TEXT column during continuous replication
asked 3 months agoHow do I get a Redshift Auqa cluster to stop pausing and actually pause?
asked 24 days agoRDS read-only replication cluster keeps pausing
asked 2 months agoIs there a limit to the number of logical replication subscribers a publisher can have?
Accepted Answerasked 5 months agoDoes AWS S3 CRR/SRR replication order match the order of object creation?
asked 2 years agoIssues with ongoing loads/replication/delta loads using DMS
Accepted Answerasked 3 years ago