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
demandé il y a 5 ans437 vues
1 réponse
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
répondu il y a 5 ans

Vous n'êtes pas connecté. Se connecter pour publier une réponse.

Une bonne réponse répond clairement à la question, contient des commentaires constructifs et encourage le développement professionnel de la personne qui pose la question.

Instructions pour répondre aux questions