- Newest
- Most votes
- Most comments
I would recommend you to look into the below workaround to resolve the issue.
a) In some cases, the source table will not be fetched by DMS, such as through tools such as Percona pt-online-schema-change A similar alarm appears when the field is modified. Although you may not use such a tool, it is recommended that you modify the source endpoint and add Extra connection attributes(ECA) “cleanSrcMetadataOnMismatch= true” [1], which clears and rebuilds the table metadata cache when the source table structure is not the same as the replicated instance cache table structure to avoid similar problems.
b) Create a new task with same settings and mapping rules and check if you're still facing the issue. Also, enable detailed debugging logs on source_capture, source_unload, target_load, target_apply and task_manager components.[2]
References :
[1] Extra connection attributes when using MySQL as a source for AWS DMS - https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Source.MySQL.html#CHAP_Source.MySQL.ConnectionAttrib
[2] Logging task settings - https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Tasks.CustomizingTasks.TaskSettings.Logging.html
Please do not hesitate to contact the AWS Support team if the above workaround doesn't help. We would be happy to help.
Relevant content
- asked 7 months ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 2 years ago
I added the extra connection attribute cleanSrcMetadataOnMismatch= true as suggested but am still unable to replicate new columns. Now my task ends up in a failed state with the following message.
Last Error Cleaned source metadata because of mismatch. Please fix the column mismatch between source and target DBs and resume the task. Task error notification received from subtask 0, thread 0 [reptask/replicationtask.c:2883] [1020479] Error executing source loop; Stream component failed at subtask 0, component st_0_dev-dba2-instance-1; Stream component 'st_0_dev-dba2-instance-1' terminated [reptask/replicationtask.c:2891] [1020479] Stop Reason FATAL_ERROR Error Level FATAL