Overview
Displays the history of all transfer tasks executed by tenants.
Columns
Column |
Type |
Is NULL |
Description |
|---|---|---|---|
| TENANT_ID | bigint(20) | NO | Tenant ID:
|
| TASK_ID | bigint(20) | NO | Transfer Task ID |
| CREATE_TIME | timestamp(6) | YES | Task Start Time |
| MODIFY_TIME | timestamp(6) | YES | Task completion time, including success and cancellation times |
| SRC_LS | bigint(20) | NO | Source log stream (the log data stream generated from the data source) |
| DEST_LS | bigint(20) | NO | Destination log stream |
| PART_LIST | longtext | YES | Partition list, including: user table partitions and global index partitions |
| PART_COUNT | bigint(20) | YES | Number of Partitions in the Partition List |
| NOT_EXIST_PART_LIST | longtext | YES | List of partitions that exist during lock acquisition but will be executed in this task |
| LOCK_CONFLICT_PART_LIST | longtext | YES | List of partitions that were planned for this task but encountered lock conflicts during locking |
| TABLE_LOCK_TABLET_LIST | longtext | YES | A list of tablets that successfully acquired partition-level table locks when entering the START state, used for table lock migration. This list contains only the tablets corresponding to the partitions in the PART_LIST. |
| TABLET_LIST | longtext | YES | The complete list of tablets involved in this transfer operation includes not only the tablets listed in the PART_LIST but also the tablets associated with local index tables and LOB auxiliary tables. |
| TABLET_COUNT | bigint(20) | YES | Number of Tablets in the Tablet List |
| START_SCN | bigint(20) unsigned | YES | SCN at Which the Transfer Was Initiated |
| FINISH_SCN | bigint(20) unsigned | YES | SCN at the End of Transfer |
| STATUS | varchar(64) | NO | Task status:
|
| TRACE_ID | varchar(64) | NO | Task Full Process Trace ID |
| RESULT | bigint(20) | YES | Task Result |
| 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 acquiring a table lock, the system generates an owner_id for each lock to identify its owner. When releasing the lock, the corresponding owner_id must be provided so that the system can correctly recognize and release it. |
| COMMENT | longtext | YES | Comment information. Records the cause of the current deadlock, diagnostic information, and task failure details. |
Sample query
View the history of all tenant-initiated transfer tasks.
obclient[oceanbase]> SELECT * FROM oceanbase.CDB_OB_TRANSFER_TASK_HISTORY\G
The query result is as follows:
*************************** 1. row ***************************
TENANT_ID: 1002
TASK_ID: 1
CREATE_TIME: 2025-05-09 14:29:08.549102
FINISH_TIME: 2025-05-09 14:29:13.075254
SRC_LS: 1001
DEST_LS: 1002
PART_LIST: 500002:500008,500002:500011,500002:500014
PART_COUNT: 3
NOT_EXIST_PART_LIST: NULL
LOCK_CONFLICT_PART_LIST: NULL
TABLE_LOCK_TABLET_LIST: 200003,200006,200009
TABLET_LIST: 200003:0,200006:0,200009:0
TABLET_COUNT: 3
START_SCN: 1746772151864500001
FINISH_SCN: 1746772152922156001
STATUS: COMPLETED
TRACE_ID: YB42AC1E87CF-0006349B5C8113E1-0-0
RESULT: 0
BALANCE_TASK_ID: 318280
TABLE_LOCK_OWNER_ID: 318338
COMMENT:
*************************** 2. row ***************************
TENANT_ID: 1002
TASK_ID: 2
CREATE_TIME: 2025-05-09 14:29:47.593154
FINISH_TIME: 2025-05-09 14:29:48.912310
SRC_LS: 1002
DEST_LS: 1001
PART_LIST: 500002:500008,500002:500011,500002:500014
PART_COUNT: 3
NOT_EXIST_PART_LIST: NULL
LOCK_CONFLICT_PART_LIST: NULL
TABLE_LOCK_TABLET_LIST: 200003,200006,200009
TABLET_LIST: 200003:1,200006:1,200009:1
TABLET_COUNT: 3
START_SCN: 1746772187916956001
FINISH_SCN: 1746772188599916001
STATUS: COMPLETED
TRACE_ID: YB4***********************-0-0
RESULT: 0
BALANCE_TASK_ID: 318454
TABLE_LOCK_OWNER_ID: 318466
COMMENT:
*************************** 3. row ***************************
TENANT_ID: 1002
TASK_ID: 3
CREATE_TIME: 2025-05-09 14:30:08.631035
FINISH_TIME: 2025-05-09 14:30:13.855965
SRC_LS: 1001
DEST_LS: 1003
PART_LIST: 500002:500008,500002:500011,500002:500014
PART_COUNT: 3
NOT_EXIST_PART_LIST: NULL
LOCK_CONFLICT_PART_LIST: NULL
TABLE_LOCK_TABLET_LIST: 200003,200006,200009
TABLET_LIST: 200003:2,200006:2,200009:2
TABLET_COUNT: 3
START_SCN: 1746772212533757001
FINISH_SCN: 1746772213595007001
STATUS: COMPLETED
TRACE_ID: YB4**********************-0-0
RESULT: 0
BALANCE_TASK_ID: 318539
TABLE_LOCK_OWNER_ID: 318605
COMMENT:
*************************** 4. row ***************************
TENANT_ID: 1004
TASK_ID: 1
CREATE_TIME: 2025-05-09 14:45:18.643425
FINISH_TIME: 2025-05-09 14:45:23.079501
SRC_LS: 1001
DEST_LS: 1002
PART_LIST: 500002:500011,500002:500012,500002:500013,500002:500014,500002:500015,500002:500016
PART_COUNT: 6
NOT_EXIST_PART_LIST: NULL
LOCK_CONFLICT_PART_LIST: NULL
TABLE_LOCK_TABLET_LIST: 200008,200009,200010,200011,200012,200013
TABLET_LIST: 200008:0,200009:0,200010:0,200011:0,200012:0,200013:0
TABLET_COUNT: 6
START_SCN: 1746773121749985001
FINISH_SCN: 1746773122896124001
STATUS: COMPLETED
TRACE_ID: YB4********************-0-0
RESULT: 0
BALANCE_TASK_ID: 321373
TABLE_LOCK_OWNER_ID: 321425
COMMENT:
4 rows in set
References
View tablet-level load balancing tasks in progress for all tenants: CDB_OB_TRANSFER_TASKS
View the load balancing jobs at the log stream level for all tenants:
View the load balancing tasks at the log stream level for all tenants:
View all tenant transfer partition tasks:
For operations related to Load balancing, see the Data Load Balancing section.