tencent cloud

All product documents
Data Transfer Service
DocumentationData Transfer ServiceError HandlingSlow or Stuck Migration
Slow or Stuck Migration
Download PDF
Last updated: 2024-07-08 15:45:26
Slow or Stuck Migration
Last updated: 2024-07-08 15:45:26
Download PDF

Issue

The migration/sync task takes too long or gets stuck.

Possible Causes

The migrated data volume is high.
The source database has a slow SQL statement.
The source database content is non-compliant.
The bandwidth is restricted or there are network jitters.
No data is written to the source database during incremental migration or sync.
Note:
If you select Full + Incremental migration as the migration type, after the full migration task is completed, the incremental migration task will continue, and you need to manually stop it by clicking Done in the Operation column; otherwise, the task will keep running, which is not the case of a stuck task.

Solutions

High migrated data volume

The data volume is high, slowing down the migration/sync task.

Slow SQL statement in source database

Check whether the source database has a slow SQL statement; if so, process the statement; if not, check other causes.

Non-compliant source database content

The content in the source database is non-compliant. For example, if the source database has tables without a primary key, large queries involving such tables will slow down the task. We recommend you add a primary key to such tables or not migrate them.

Network problem

If you use CCN for access, check the bandwidth configured in CCN. CCN only provides bandwidth below 10 Kbps between all regions free of charge, which is insufficient for DTS to transfer data. In this case, you need to configure a higher bandwidth.
If you use a self-built database, check whether the network bandwidth is restricted.

No data written to source database during incremental migration or sync

In incremental migration or sync, if no data is written to the source database for a long time or there is an empty binlog, you can write data to the source database to resume the task.
Was this page helpful?
You can also Contact Sales or Submit a Ticket for help.
Yes
No

Feedback

Contact Us

Contact our sales team or business advisors to help your business.

Contact Us
Technical Support

Open a ticket if you're looking for further assistance. Our Ticket is 7x24 avaliable.

Submit a Ticket
7x24 Phone Support
Hong Kong, China
+852 800 906 020 (Toll Free)
United States
+1 844 606 0804 (Toll Free)
United Kingdom
+44 808 196 4551 (Toll Free)
Canada
+1 888 605 7930 (Toll Free)
Australia
+61 1300 986 386 (Toll Free)
EdgeOne hotline
+852 300 80699
More local hotlines coming soon