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

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

0

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

1 Answer
0

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

profile picture
answered a month ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions