Troubleshooting replication pauses due to swapping

Question

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?

kaveh-air · Answer

We are also having this issue. Is there any update here?

mtterry · Answer

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.

macx78 · Answer

This might help some

Ilovexioahuhu!23 · Answer

This post suggests some measures to fix the problem. 
https://repost.aws/knowledge-center/dms-swap-files-consuming-space

jasanchez · Answer

We're experiencing the same issue.  
Did you manage to fix it?  
  
Thanks!

sbora · Answer

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?

Troubleshooting replication pauses due to swapping

Füge deine Antwort hinzu

Relevanter Inhalt