Data Migration Service from RDS to Redshift Failed

Question

Last Error Error 1236 reading binary log. Task error notification received from subtask 0, thread 0 [reptask/replicationtask.c:2883] [1020493] Error executing source loop; Stream component failed at subtask 0, component st_0_GI7QJS2UGYJBQ2O7OEJDBDVH3ZAU2QC53GUFBTQ; Stream component 'st_0_GI7QJS2UGYJBQ2O7OEJDBDVH3ZAU2QC53GUFBTQ' terminated [reptask/replicationtask.c:2891] [1020493] Stop Reason FATAL_ERROR Error Level FATAL

Here is the error message I received? Can someone help explaining why this happens and how can I resolve this?

Stuart Scott · Answer

I'm not familiar enough with DMS to explain the reasoning behind this error, however I did see that someone had a similar problem with the same error which is discussed here: https://stackoverflow.com/questions/69579734/aws-dms-task-failed-with-error-error-executing-source-loop-stream-component-fa - It may lead you to resolving your problem

Giovanni Lauria · Answer

The `Error 1236 reading binary log` in AWS DMS typically occurs due to issues with the binary logs in MySQL. This can happen if the binary log has been purged, the retention period is too low, or the DMS task has issues. To resolve, increase the binary log retention period if needed and restart the DMS task. If the issue persists, contact AWS Support.

Data Migration Service from RDS to Redshift Failed

Add your answer

Relevant content