Overview
The CDB_OB_TRANSFER_PARTITION_TASK_HISTORY view displays the history of all Transfer Partition tasks executed by tenants.
Columns
Field |
Type |
Nullable |
Description |
|---|---|---|---|
| TENANT_ID | bigint(20) | NO | User Tenant ID |
| TASK_ID | bigint(20) | NO | Unique identifier of the partition transfer task. |
| CREATE_TIME | timestamp(6) | NO | Creation Time |
| FINISH_TIME | timestamp(6) | NO | Task completion time, including success and cancellation |
| TABLE_ID | bigint(20) | NO | Table ID of the partition for which data is being transferred |
| OBJECT_ID | bigint(20) | NO | Partition of Transfer OBJECT_ID |
| DEST_LS | bigint(20) | NO | Destination log stream |
| BALANCE_JOB_ID | bigint(20) | NO | CLB Work ID Associated with 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
View the history of transfer partition tasks executed by the tenant with ID 1006.
obclient> SELECT * FROM oceanbase.CDB_OB_TRANSFER_PARTITION_TASK_HISTORY WHERE TENANT_ID = 1006;
The query result is as follows:
+-----------+---------+----------------------------+----------------------------+----------+-----------+---------+----------------+------------------+-----------+-------------------------------+
| TENANT_ID | TASK_ID | CREATE_TIME | FINISH_TIME | TABLE_ID | OBJECT_ID | DEST_LS | BALANCE_JOB_ID | TRANSFER_TASK_ID | STATUS | COMMENT |
+-----------+---------+----------------------------+----------------------------+----------+-----------+---------+----------------+------------------+-----------+-------------------------------+
| 1006 | 1 | 2023-11-29 16:02:17.501500 | 2023-11-29 16:03:18.000000 | 500003 | 500009 | 1003 | 17304 | 2 | COMPLETED | Partition transfer to dest LS |
| 1006 | 2 | 2023-11-30 11:04:20.805526 | 2023-11-30 11:59:39.000000 | 500026 | 500026 | 1001 | 377170 | 2952 | COMPLETED | Partition transfer to dest LS |
| 1006 | 3 | 2023-12-01 11:26:43.757677 | 2023-12-01 11:27:26.000000 | 500003 | 500009 | 1001 | 760894 | 2954 | COMPLETED | Partition transfer to dest LS |
+-----------+---------+----------------------------+----------------------------+----------+-----------+---------+----------------+------------------+-----------+-------------------------------+
3 rows in set
References
Query all transfer partition tasks being processed by tenants: oceanbase.CDB_OB_TRANSFER_PARTITION_TASKS
View the history of partition transfer tasks performed by the current tenant: oceanbase.DBA_OB_TRANSFER_PARTITION_TASK_HISTORY
For more information about how to transfer partitions, see Transfer Partition.
For more information about Load balancing, see the Data Load Balancing section.