Problem description
If a DTS synchronization task involves whole database synchronization, or a table without a primary key is not synchronized to the destination database, an error message may occur when the table does not exist.
Possible cause
DTS does not support synchronizing tables without primary keys to AnalyticDB for MySQL.
Solution
Alibaba Cloud reminds you that:
- Before you perform operations that may cause risks, such as modifying instance configurations or data, we recommend that you check the disaster recovery and fault tolerance capabilities of the instances to ensure data security.
- If you modify the configurations and data of instances including but not limited to ECS and RDS instances, we recommend that you create snapshots or enable RDS log backup.
- If you have authorized or submitted security information such as the logon account and password in the Alibaba Cloud Management console, we recommend that you modify such information in a timely manner.
DTS does not support synchronizing tables without primary keys to AnalyticDB for MySQL. To synchronize these tables to AnalyticDB for MySQL, you must manually create a table in the destination database and ensure that the new table has a primary key. After the table is created, restart the DTS task.
Application scope
- AnalyticDB for MySQL