table not replicating in DMS from MySQL RDS to Redshift RDS

0

Hi,

I am using Amazon DMS to replicate my table from MySQL RDS to Redshift. I have created multiple task to replicate the tables from MySQL to Redshift. All the task are working fine and replicating the data except for one table. I deleted and recreated the task for that table but again its not replicating. I enabled the log for the same. the logs just show this message "ROTATE_EVENT (mysql_endpoint_capture.c:3132)". Please can someone help. I am in a fix as to what to do.

Thanks in advance..
Regards
Parvez

Edited by: Parvez on Mar 19, 2019 2:22 AM

Edited by: Parvez on Mar 19, 2019 2:22 AM

Parvez
asked 4 years ago76 views
1 Answer
0

I found the solution in the below post. Was not having primary key in my table.

https://forums.aws.amazon.com/thread.jspa?threadID=232498

Parvez
answered 4 years 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