By using AWS re:Post, you agree to the Terms of Use

DMS : Source RDS : Last Error Error 1236 reading binary log.

0

While using DMS to transfer data from MySQL RDS to S3, this error comes (not frequently, only monthly), and cdc task gets stopped.

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

Can someone help, when I restart the cdc task it is normal again, but when i choose to resume it gives same error.

Also : In cloudwatch metrics I can see CDC latency source : and there is a spike on same time of error and in source RDS cloudwatch also there is spike on Read IOPS.

  • Last Error Error 1236 reading binary log. Task error notification received from subtask 0, thread 0 [reptask/replicationtask.c:2880] [1020493] Error executing source loop; Stream component failed at subtask 0, component st_0_WD5U7BSFYILYXESHRTVIQR7CPX5E7X5DGTUGQ7Q; Stream component 'st_0_WD5U7BSFYILYXESHRTVIQR7CPX5E7X5DGTUGQ7Q' terminated [reptask/replicationtask.c:2888] [1020493] Stop Reason FATAL_ERROR Error Level FATAL Started June 27, 2022, 13:10:19 (UTC+05:30)