Note
This view is available starting with V4.2.0.
Purpose
This view displays the history of all executed Transfer tasks in the current tenant. The query result is empty for 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 start time of the task. |
| MODIFY_TIME | timestamp(6) | YES | The end time of the task, including the time when the task was canceled. |
| SRC_LS | bigint(20) | NO | The source log stream (the log data stream generated by the data source). |
| DEST_LS | bigint(20) | NO | The destination log stream. |
| 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 for table-level locks acquired when the task entered the START state. This list contains only tablets corresponding to partitions in the PART_LIST. It is used for table lock migration. |
| TABLET_LIST | longtext | YES | The complete list of tablets involved in this Transfer operation. It includes tablets listed in the PART_LIST, as well as 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 table 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 task failure details. |
References
To view all tenant-level load balancing tasks (Task):
To view all tenant-level log stream-level load balancing jobs (Job):
To view all tenant-level log stream-level load balancing tasks (Task):
To view all tenant-level Transfer partition tasks (Task):
For more information about data load balancing, see Data load balancing.