Note
This view is available starting with V4.0.0.
Purpose
This view displays the Transfer tasks that are being executed in the current tenant. The query result is empty in the sys tenant.
Columns
Column |
Type |
Nullable |
Description |
|---|---|---|---|
| TASK_ID | bigint(20) | NO | The ID of the Transfer task. |
| CREATE_TIME | timestamp(6) | YES | The time when the task was created. |
| MODIFY_TIME | timestamp(6) | YES | The time when the task was last modified. |
| SRC_LS | bigint(20) | NO | The log stream on the source end. The log stream is 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 this task but do not exist when the locks are acquired. |
| LOCK_CONFLICT_PART_LIST | longtext | YES | The list of partitions that are planned to be executed in this task but conflict with locks when the locks are acquired. |
| TABLE_LOCK_TABLET_LIST | longtext | YES | The list of tablets that are locked at the partition level for table lock migration when the task enters 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 current Transfer operation. This list includes not only the tablets 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 at which the Transfer operation was initiated. |
| FINISH_SCN | bigint(20) unsigned | YES | The SCN at which the Transfer operation was 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 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 table lock. When a table lock is released, the corresponding owner_id must be provided to enable the system to correctly identify and release the table lock. |
| COMMENT | longtext | YES | The comment. This column records the reason for the task being stuck, diagnostic information, and the task failure status. |
References
To view all tenant-level load balancing tasks (Task), see the following topics:
To view all tenant-level log stream load balancing jobs (Job), see the following topics:
To view all tenant-level log stream load balancing tasks (Task), see the following topics:
To view all tenant-level Transfer Partition tasks (Task), see the following topics:
For more information about data load balancing, see Data load balancing.