Note
This view is available starting with V4.2.0.
Purpose
This view displays the history of 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 completion time of the task, including the time when the task was canceled. |
| SRC_LS | bigint(20) | NO | The log stream (from the data source) of the source. |
| DEST_LS | bigint(20) | NO | The log stream of the destination. |
| 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 were planned to be executed in this task but did not exist when the lock was acquired. |
| LOCK_CONFLICT_PART_LIST | longtext | YES | The list of partitions that were planned to be executed in this task but encountered lock conflicts when the lock was acquired. |
| TABLE_LOCK_TABLET_LIST | longtext | YES | The list of tablets that were successfully locked at the partition level when the task entered the START state. This list contains only tablets corresponding to partitions in the PART_LIST. |
| TABLET_LIST | longtext | YES | The complete list of tablets involved in the Transfer operation. This list includes not only the tablets listed in the PART_LIST but also tablets 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 when the Transfer operation was initiated. |
| FINISH_SCN | bigint(20) unsigned | YES | The SCN when the Transfer operation was completed. |
| STATUS | varchar(64) | NO | The status of the task. Valid values:
|
| 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 the lock, the corresponding owner_id must be provided to ensure the system can correctly identify and release the lock. |
| COMMENT | longtext | YES | The comment. It records the reason for the current stall, diagnostic information, and the failure status of the task. |
References
View all tenant-level load balancing tasks (Task):
View all tenant-level log stream-level load balancing jobs (Job):
View all tenant-level log stream-level load balancing tasks (Task):
View all tenant-level Transfer partition tasks (Task):
For more information about data load balancing, see Data load balancing.