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
posta 5 anni fa453 visualizzazioni
1 Risposta
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
con risposta 5 anni fa

Accesso non effettuato. Accedi per postare una risposta.

Una buona risposta soddisfa chiaramente la domanda, fornisce un feedback costruttivo e incoraggia la crescita professionale del richiedente.

Linee guida per rispondere alle domande