CODEWITHSUNDEEP
postgresqlamazon-rdsamazon-auroraaws-dmscitus
Ashish Karpe
Ashish Karpe

Reputation: 5794

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

Upvotes: 4

Views: 19009

Answers (3)

user22481848
user22481848

Reputation: 21

For Full load task, Select permission for DMS user is enough. But for the CDC (Ongoing replication tasks), superuser permission is required for the DMS user over Database.

Upvotes: 2

Alexander Witte
Alexander Witte

Reputation: 215

I had a similar error to this using Aurora PostgreSQL v14.5 and AWS DMS. I was using a DMS Full load + CDC job (using pglogical behind the scenes) to migrate from one table to another (on the same system).

Issue was resolved by rolling back my PostgreSQL version from 14.5 to 13.7.

Upvotes: 2

Ashish Karpe
Ashish Karpe

Reputation: 5794

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

Upvotes: 2

Related Questions