- Neueste
- Die meisten Stimmen
- Die meisten Kommentare
Hey, DMS CDC can fail for many reasons. Please try to share more details. Here are some general trobleshooting steps:
- Check and understand the job status after the the Full load. Ref Document: https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Monitoring.html#CHAP_Tasks.Status
- Enable cloudwatch logs for the DMS task and check the log group for any errors and warning. Ref Document: https://repost.aws/knowledge-center/dms-task-error-status
- If errors are on TARGET_APPLY side, check the target database error log for further information
Hi Joseph, Thanks for looking into it.
Job status is "load running". It already replicated all data from source to target. All row count in all the tables match.
Cloudwatch message is "Table(s) loading still in progress"
Hi Satish, The "load running" status means full load is still running. Please note that DMS uses native DB engine tools for homogeneous data migrations. The migration can take hours for large databases. Wait for some more time until the full load is complete. Next the status will change to "Load complete, replication ongoing ". Have a look at below doc for DMS Statuses of homogeneous data migrations. https://docs.aws.amazon.com/dms/latest/userguide/dm-migrating-data-statuses.html
Joesph, It is a small database. It has migrated all the data. All row counts in all the tables match up. Its been running for a day and it has not changed status.
Ok. In that case, thorough investigation is needed here. If you have a support plan, I suggest you to open a case AWS support.
I've encountered the same using DMS homogeneous migration MySQL on EC2 to MySQL on RDS. The cloudwatch log is stuck in the "Tables loading still in progress" but all of the tables are migrated.
Relevanter Inhalt
- AWS OFFICIALAktualisiert vor einem Jahr
- AWS OFFICIALAktualisiert vor 2 Jahren
- AWS OFFICIALAktualisiert vor 2 Jahren
- AWS OFFICIALAktualisiert vor 2 Jahren
Hi Joseph, Thanks for looking into it.
Job status is "load running". It already replicated all data from source to target. All row count in all the tables match.
Cloudwatch message is "Table(s) loading still in progress"