Overview
Displays the current transfer tasks being executed under this tenant.
Columns
Column |
Type |
Is NULL |
Description |
|---|---|---|---|
| TASK_ID | bigint(20) | NO | Transfer Task ID |
| CREATE_TIME | timestamp(6) | YES | Creation Time |
| MODIFY_TIME | timestamp(6) | YES | Information Update Time |
| 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 current transfer tasks being executed under this tenant.
obclient [oceanbase]> SELECT * FROM oceanbase.DBA_OB_TRANSFER_TASKS\G
The query result is as follows:
*************************** 1. row ***************************
TASK_ID: 3
CREATE_TIME: 2024-06-14 14:39:42.356430
MODIFY_TIME: 2024-06-14 14:38:44.315350
SRC_LS: 1002
DEST_LS: 1001
PART_LIST: 500224:500224,500229:500229,500234:500234,500239:500239,500244:500244,500249:500249,500254:500254
PART_COUNT: 7
NOT_EXIST_PART_LIST: NULL
LOCK_CONFLICT_PART_LIST: NULL
TABLE_LOCK_TABLET_LIST: NULL
TABLET_LIST: 200089:0,200090:0,200091:0,200092:0,200093:0,200094:0,200095:0,1152921504606847076:0,1152921504606847077:0,1152921504606847078:0,1152921504606847079:0,1152921504606847080:0,1152921504606847081:0,1152921504606847082:0,1152921504606847083:0,1152921504606847084:0,1152921504606847085:0,1152921504606847086:0,1152921504606847087:0,1152921504606847088:0,1152921504606847089:0,1152921504606847090:0,1152921504606847091:0,1152921504606847092:0,1152921504606847093:0,1152921504606847094:0,1152921504606847095:0,1152921504606847096:0,1152921504606847097:0,1152921504606847098:0,1152921504606847099:0,1152921504606847100:0,1152921504606847101:0,1152921504606847102:0,1152921504606847103:0
TABLET_COUNT: 35
START_SCN: 1718347182784953001
FINISH_SCN: 0
STATUS: DOING
TRACE_ID: YB4*******************************************-0-0
RESULT: 0
BALANCE_TASK_ID: 374414
TABLE_LOCK_OWNER_ID: 374434
COMMENT:
1 row in set
References
View the historical load balancing task (Task) information at the tablet level for this tenant: DBA_OB_TRANSFER_TASK_HISTORY
View the load balancing jobs at the log stream level for the current tenant:
View the load balancing tasks at the log stream level of the current tenant:
View the transfer partition tasks of the current tenant:
For operations related to Load balancing, see the Data Load Balancing section.