postgresqlamazon-rdsamazon-auroraaws-dmscitus

AWS DMS Task failed with error: Error executing source loop; Stream component failed at subtask 0


I want to migrate my PostgresDB hosted in Citus cloud service to AWS RDS Aurora Postgres. I am using AWS DMS service. Have created task but getting following errors:

Last failure message Last Error Stream Component Fatal error. Task error notification received from subtask 0, thread 0 [reptask/replicationtask.c:2860] [1020101] Error executing source loop; Stream component failed at subtask 0, component st_0_QOIS7XIGJDKNPY6RXMGYRLJQHY2P7IQBWIBA5NQ; Stream component 'st_0_QOIS7XIGJDKNPY6RXMGYRLJQHY2P7IQBWIBA5NQ' terminated [reptask/replicationtask.c:2868] [1020101] Stop Reason FATAL_ERROR Error Level FATAL

Frankly speaking not able to understand what is wrong here, so any help is appreciated.

cloudwatch logs:

enter image description here


Solution

  • I changed type to Full load it worked so it is not working for ongoing replication Citus Cloud service don't support it.