- 新しい順
- 投票が多い順
- コメントが多い順
Hello, From the provided description you are running in to a Duplicate key error. Below are some suggestions that can be followed to mitigate the issue. When the task is in Full Load please disable foreign keys and triggers on the target table. For Full Load remove the Auto Increment property on the table and add it after the full load is done with a maximum value for the column by resetting it.
[+] https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Source.MySQL.html#CHAP_Source.MySQL.Limitations [+] https://aws.amazon.com/blogs/database/debugging-your-aws-dms-migrations-what-to-do-when-things-go-wrong-part-1/ [+] https://aws.amazon.com/blogs/database/debugging-your-aws-dms-migrations-what-to-do-when-things-go-wrong-part-2/ [+] https://aws.amazon.com/blogs/database/debugging-your-aws-dms-migrations-what-to-do-when-things-go-wrong-part-3/
関連するコンテンツ
- 質問済み 6年前
- AWS公式更新しました 2年前