oceanbase.CDB_OB_TRANSFER_TASKS|V4.6.0|OceanBase Database|docs|OceanBase Documentations

Column	Type	Nullable	Description
TENANT_ID	bigint(20)	NO	The tenant ID. 1: the ID of the sys tenant. Other values: the ID of a user tenant or a meta tenant.
TASK_ID	bigint(20)	NO	The ID of the Transfer task.
CREATE_TIME	timestamp(6)	NO	The time when the task was created.
MODIFY_TIME	timestamp(6)	NO	The time when the information was last updated.
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 are planned to be executed in the current task but do not exist when the lock is acquired.
LOCK_CONFLICT_PART_LIST	longtext	YES	The list of partitions that are planned to be executed in the current task but encounter lock conflicts when the lock is acquired.
TABLE_LOCK_TABLET_LIST	longtext	YES	The list of tablets that are locked at the partition level for table lock migration when the task enters the START state. 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 the current Transfer operation. This list includes not only the tablets in the PART_LIST but also those 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 task status. `INIT`: The task was created. `START`: The Transfer operation started. `DOING`: The Transfer operation is in progress. `ABORTED`: The Transfer operation failed and was terminated. `COMPLETED`: The task was successfully executed. `FAILED`: The task failed. `CANCELED`: The task was canceled.
TRACE_ID	varchar(64)	NO	The trace ID for the entire task.
RESULT	bigint(20)	YES	The 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 a table lock is acquired, the system generates an owner_id for each table lock to identify the owner of the lock. When the table lock is released, the corresponding owner_id must be provided to ensure the system can correctly identify and release the lock.
COMMENT	longtext	YES	The comment information. This field records the reason for the current stall, diagnostic information, and details of the task failure.

TENANT_ID

bigint(20)

NO

The tenant ID.

1: the ID of the sys tenant.
Other values: the ID of a user tenant or a meta tenant.

TASK_ID

bigint(20)

NO

The ID of the Transfer task.

CREATE_TIME

timestamp(6)

NO

The time when the task was created.

MODIFY_TIME

timestamp(6)

NO

The time when the information was last updated.

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 are planned to be executed in the current task but do not exist when the lock is acquired.

LOCK_CONFLICT_PART_LIST

longtext

YES

The list of partitions that are planned to be executed in the current task but encounter lock conflicts when the lock is acquired.

TABLE_LOCK_TABLET_LIST

longtext

YES

The list of tablets that are locked at the partition level for table lock migration when the task enters the START state. 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 the current Transfer operation. This list includes not only the tablets in the PART_LIST but also those 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 task status.

INIT: The task was created.
START: The Transfer operation started.
DOING: The Transfer operation is in progress.
ABORTED: The Transfer operation failed and was terminated.
COMPLETED: The task was successfully executed.
FAILED: The task failed.
CANCELED: The task was canceled.

TRACE_ID

varchar(64)

NO

The trace ID for the entire task.

RESULT

bigint(20)

YES

The 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 a table lock is acquired, the system generates an owner_id for each table lock to identify the owner of the lock. When the table lock is released, the corresponding owner_id must be provided to ensure the system can correctly identify and release the lock.

COMMENT

longtext

YES

The comment information. This field records the reason for the current stall, diagnostic information, and details of the task failure.

oceanbase.CDB_OB_TRANSFER_TASKS

Note

Purpose

Columns

Sample query

References