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
질문됨 5년 전447회 조회
1개 답변
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
답변함 5년 전

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인

관련 콘텐츠