DMS task fails--Migrating from Postgresql to Aurora Postgresql the replication task fails with the below error

Question

Migrating from Postgresql to Aurora Postgresql the replication task fails with the below error

Last Error Slot is already active. Task error notification received from subtask 0, thread 0 [reptask/replicationtask.c:2883] [1020461] Error executing source loop; Stream component failed at subtask 0, component st_0_TGFPHBXI72KDZXYDCPGEL5K55MWGVDHLDE5MWCI; Stream component 'st_0_TGFPHBXI72KDZXYDCPGEL5K55MWGVDHLDE5MWCI' terminated [reptask/replicationtask.c:2891] [1020461] Stop Reason FATAL_ERROR Error Level FATAL

After further review found the below error

2022-08-31T01:28:52 [SOURCE_CAPTURE  ]E:  Slot 'g7xqq5o3bcmkmwkb_451820587_83ea282a_3cb2_4a5f_995a_786dff4f3fa6' state found as 'already active' while expected as
 'inactive'. [1020461]  (postgres_endpoint_capture.c:354)

Please let me know how to fix this issue.

Thanks

Venu

Answer

Hi Venu,

This sounds very much like you've run out of replication slots in your source PostgreSQL database. 
This AWS support article should help get you back up and running:

https://aws.amazon.com/premiumsupport/knowledge-center/dms-postgresql-fail-slots-in-use/

If you are running PostgreSQL on-prem you can modify the max_replication_slots value mentioned in the article by modifying the postgresql.conf file and restarting your database.

Kate

DMS task fails--Migrating from Postgresql to Aurora Postgresql the replication task fails with the below error

Relevanter Inhalt