Note
This view is available starting with V4.2.1 BP2.
Overview
The DBA_OB_TRANSFER_PARTITION_TASKS view displays the current partition transfer tasks being processed under the current tenant.
Columns
Field |
Type |
Nullable |
Description |
|---|---|---|---|
| TASK_ID | bigint(20) | NO | Unique identifier of the transfer partition task. |
| CREATE_TIME | timestamp(6) | YES | Created At |
| MODIFY_TIME | timestamp(6) | YES | Information Update Time |
| TABLE_ID | bigint(20) | NO | Table ID of the partition for which data is being transferred |
| OBJECT_ID | bigint(20) | NO | Partition of TransferOBJECT_ID |
| DEST_LS | bigint(20) | NO | Destination log stream |
| BALANCE_JOB_ID | bigint(20) | NO | The associated CLB job ID during task execution. |
| TRANSFER_TASK_ID | bigint(20) | NO | Transfer task ID associated with the task during execution |
| STATUS | varchar(64) | NO | Task status:
|
| COMMENT | longtext | YES | Comments |
Sample query
Query the current pending partition transfer tasks in the tenant.
obclient> SELECT * FROM oceanbase.DBA_OB_TRANSFER_PARTITION_TASKS;
The query result is as follows:
+---------+----------------------------+----------------------------+----------+-----------+---------+----------------+------------------+--------+---------+
| TASK_ID | CREATE_TIME | MODIFY_TIME | TABLE_ID | OBJECT_ID | DEST_LS | BALANCE_JOB_ID | TRANSFER_TASK_ID | STATUS | COMMENT |
+---------+----------------------------+----------------------------+----------+-----------+---------+----------------+------------------+--------+---------+
| 4 | 2023-12-01 11:21:11.357272 | 2023-12-01 11:21:17.904857 | 500012 | 500014 | 1003 | 737367 | 9 | DOING | NULL |
+---------+----------------------------+----------------------------+----------+-----------+---------+----------------+------------------+--------+---------+
1 row in set (0.002 sec)
References
View the history of executed partition transfer tasks for the current tenant: DBA_OB_TRANSFER_PARTITION_TASK_HISTORY
For more information about transfer partition operations, see the following topics: