tencent cloud

TDSQL Boundless

DocumentaçãoTDSQL BoundlessGeneral ReferenceSQL ReferenceData DictionaryINFORMATION_SCHEMAMETA_CLUSTER_TASKS

META_CLUSTER_TASKS

PDF
Modo Foco
Tamanho da Fonte
Última atualização: 2026-03-06 18:48:08

Function

INFORMATION_SCHEMA.META_CLUSTER_TASKS displays tasks executed by the MC.
Task is the concept of internal tasks in MC, primarily handling instance-level tasks, such as: full backup and recovery, uninstalling nodes, isolation and recovery of instances, creation and deletion of data objects, and so on.

Field Description

Field Name
Type
Description
task_id
bigint unsigned
Task ID.
create_time
datetime
Time when the task was created.
finish_time
datetime
Time when the task ended.
task_type
varchar(64)
Task type.
task_status
varchar(64)
Task status
task_desc
text
Task description.
task_meta
text
Task metadata, stored in JSON format. It contains all key parameters and object information involved during task execution, serving as the primary reference for troubleshooting.
task_cause
varchar(64)
Task trigger reason type.
task_progress
text
Task progress.

Examples

tdsql > SELECT * FROM information_schema.META_CLUSTER_TASKS limit 1\\G
*************************** 1. row ***************************
      task_id: 29653634035744781
  create_time: 2026-01-04 10:38:44
  finish_time: 2026-01-04 10:38:44
    task_type: TASK_TYPE_CREATE_DATA_OBJECTS
  task_status: TASK_STATUS_SUCCEED
    task_desc: 
    task_meta: {"CreateDataObjects":{"task_id":29653634035744781,"data_objects":[{"data_obj_id":2,"data_obj_name":"****","data_obj_type":13,"data_obj_id_hierarchy":[2],"binary_key_range":{"start_key":"AAAAAg==","end_key":"AAAAAw=="},"has_data":true,"data_space_type":1,"create_task_id":29653634035744781,"distribution_policy_id":1}],"rep_group_jobs":[{"rep_group_job_id":10,"rep_group_id":1024,"rep_group_job_type":11,"ReplicationGroupJobInfo":{"CreateRegionInRepGroup":{"rep_group_id":1024,"meta_version":1,"new_region_meta_list":[{"region_id":9,"start_key":"AAAAAg==","end_key":"AAAAAw==","data_space_type":1,"member":{"region_id":9,"member_node_names":["node-***-001"]},"region_labels":{"no-auto-merge":"1","no-auto-split":"1"},"rep_group_id":1024,"data_obj_id":2,"has_data":true,"data_obj_type":13}]}}}],"ddl_job_desc":"Empty"}}
   task_cause: CAUSE_API_TRIGGER
task_progress: <nil>
1 row in set (0.02 sec)
Example result interpretation:
Task summary: This record describes a task for creating data objects (task_type: TASK_TYPE_CREATE_DATA_OBJECTS).
Execution result: The task has been successfully completed (task_status: TASK_STATUS_SUCCEED).
Trigger method: triggered by an API call (task_cause: CAUSE_API_TRIGGER).
Key details: The task_meta field contains complete task details, such as the creation of a data object with ID 2 and the corresponding Region created in replication group (Replication Group) ID 1024.
Anterior: META_CLUSTER_STATUSPróximo: PARTITION_POLICIES

Ajuda e Suporte

Esta página foi útil?

comentários