Note
This view is available starting with V4.2.0.
Purpose
This view displays the history of all Transfer tasks executed in the current tenant.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| TASK_ID | bigint(20) | NO | The ID of the Transfer task. |
| CREATE_TIME | timestamp(6) | YES | The start time of the task. |
| MODIFY_TIME | timestamp(6) | YES | The end time of the task, including the time when the task is successfully completed or canceled. |
| SRC_LS | bigint(20) | NO | The log stream on the source end (the log data stream generated by the data source). |
| DEST_LS | bigint(20) | NO | The log stream on the destination end. |
| PART_LIST | longtext | YES | The list of partitions, including user table partitions and global index partitions. |
| PART_COUNT | bigint(20) | YES | The number of partitions in the partition list. |
| NOT_EXIST_PART_LIST | longtext | YES | The list of partitions that are planned to be executed in the current task but do not exist when the lock is acquired. |
| LOCK_CONFLICT_PART_LIST | longtext | YES | The list of partitions that are planned to be executed in the current task but encounter lock conflicts when the lock is acquired. |
| TABLE_LOCK_TABLET_LIST | longtext | YES | The list of tablets of partition-level table locks successfully acquired when the task enters the START state. This list is used for table lock migration. It contains only the tablets corresponding to the partitions in the PART_LIST. |
| TABLET_LIST | longtext | YES | The complete list of tablets involved in the current Transfer operation. It includes not only the tablets listed in the PART_LIST but also those associated with local index tables and LOB auxiliary tables. |
| TABLET_COUNT | bigint(20) | YES | The number of tablets in the tablet list. |
| START_SCN | bigint(20) unsigned | YES | The SCN at which the Transfer operation is initiated. |
| FINISH_SCN | bigint(20) unsigned | YES | The SCN at which the Transfer operation is completed. |
| STATUS | varchar(64) | NO | The status of the task. Valid values: INIT, START, DOING, ABORTED, COMPLETED, FAILED, and CANCELED.
|
| TRACE_ID | varchar(64) | NO | The trace ID of the entire task. |
| RESULT | bigint(20) | YES | The result of the task. |
| BALANCE_TASK_ID | bigint(20) | NO | The ID of the associated load balancing task. This Transfer task is a subtask generated by the corresponding load balancing task. |
| TABLE_LOCK_OWNER_ID | bigint(20) | YES | When a table lock is acquired, the system generates an owner_id for each table lock to identify the owner of the lock. When releasing a table lock, you must provide the corresponding owner_id so that the system can correctly identify and release the lock. |
| COMMENT | longtext | YES | The comment. It records the reason why the task is stuck, diagnostic information, and the failure details of the task. |
References
To view all tenant-level load balancing tasks (Task):
To view all tenant-level log stream load balancing jobs (Job):
To view all tenant-level log stream load balancing tasks (Task):
To view all tenant-level Transfer partition tasks (Task):
For more information about data load balancing, see Data load balancing.