Task logs let you view the task timeline and running logs. The task timeline shows the status of a task at key milestones, such as purchase, configuration, execution, failure, and completion. You can filter running logs by time range or task status to quickly find specific information.
Procedure
- Log on to the Data Transmission Service console.
Note
If you are automatically redirected to the Data Management (DMS) console, you can click the
icon in the lower-right corner and then click
to return to the classic DTS console. Based on your instance type, in the left-side navigation pane, click Data Synchronization.
At the top of the page, select the region where your instance is located.
Find the target instance and click its instance ID.
In the left-side navigation pane, click View Task Logs. The Operational Logs tab is selected by default.
From the Full Data Migration drop-down list, select Incremental Data Migration.
The log table updates to display running logs for incremental data synchronization.
The following table describes the parameters displayed in the Log Content column.
Parameter
Description
generator
The total amount of received incremental data.
collector
The total amount of valid data. This includes heartbeat data and the number of DML and DDL records for synchronized objects.
replicator
The number of synchronized transactions (DML and DDL).
ping
Network latency, displayed as Minimum/Average/Maximum. A value of -1 indicates a network connection issue; the destination database is unreachable.
execute
Transaction execution time: The time taken to assemble a transaction into an SQL statement, send it to the destination database for execution, and receive the result. Displayed as Minimum/Average/Maximum.
rt
Transaction commit time: The total time for transaction execution and commit. Displayed as Minimum/Average/Maximum.
state
The current status of the synchronization thread.
IDLE: The thread is idle.
DML: Synchronizing DML operations.
DDL: Synchronizing DDL operations.
queries
The number of large queries in the destination database. A large query is an SQL query that takes more than 60 seconds to execute.
exceptions
The current number of exceptions.
connects: The number of failed connection attempts.
replicates: The number of times the synchronization thread failed to write to the destination database.
infos
The DDL operation or table that is currently being synchronized.
Click the Task Timeline tab to view the task's key events.
The task timeline displays the following event nodes and their start times, listed from bottom to top:
Instance purchased successfully
Task started successfully
Task configured successfully
Pre-check started successfully
Schema migration started successfully
Full data migration started successfully
Data synchronization started successfully