产品概述
应用场景
产品架构
实例类型
兼容性说明
使用规范建议
INFORMATION_SCHEMA.META_CLUSTER_JOBS 展示实例内调度任务的相关信息。字段名 | 类型 | 描述 |
rep_group_id | bigint unsigned | 执行调度任务的 RG ID |
rep_group_job_id | bigint unsigned | 任务 ID |
rep_group_job_type | varchar(64) | 任务类型 |
rep_group_job_meta | json | 任务元信息 |
rep_group_job_state | varchar(64) | 任务状态 |
create_time | datetime | 任务创建时间 |
finish_time | datetime | 任务完成时间 |
job_raft_log_index | bigint | 任务完成时 RG 的 RAFT 日志位点 |
job_vanished_rg_raft_log_index | bigint | MERGE_RG 类型任务完成时 vanished RG 的 RAFT 日志位点 |
job_commit_ts | varchar(64) | 任务完成时的时间戳 |
job_msg | text | 任务的信息 |
job_desc | text | 任务的描述 |
task_id | bigint unsigned | 发起该 Job 的 Task 的 ID |
task_type | varchar(64) | 发起该 Job 的 Task 的类型 |
cause_type | varchar(64) | 发起该 Job 的原因类型 |
schedule_rule | text | 发起该 Job 的调度规则 |
tdsql > SELECT * FROM information_schema.META_CLUSTER_JOBS WHERE rep_group_job_type LIKE "%migrate%" LIMIT 1\\G*************************** 1. row ***************************rep_group_id: 1024rep_group_job_id: 17rep_group_job_type: RG_JOB_TYPE_MIGRATE_RG_REPLICArep_group_job_meta: {"rep_group_id": 1024, "rep_group_job_id": 17, "rep_group_job_type": 5, "ReplicationGroupJobInfo": {"MigrateRepGroupReplica": {"need_report": true, "rep_group_id": 1024, "timeout_msec": 600000, "src_node_name": "node-***-001", "dst_rep_group_meta": {"uuid": 1, "kv_id": "rg_mgr_kv_0", "quorum": 1, "learners": ["node-***-002"], "node_name": "node-***-002", "update_ts": 29653634069299238, "create_time": 1767494319660804771, "leader_term": 2, "member_role": 4, "member_uuids": {"node-***-001": 0, "node-***-002": 1}, "meta_version": 3, "rep_group_id": 1024, "learner_quorum": 2, "member_version": 1, "data_space_type": 1, "rep_group_state": 16, "region_meta_list": [{"end_key": "AAAAAw==", "has_data": true, "region_id": 9, "start_key": "AAAAAg==", "create_time": 1767494323650978288, "data_obj_id": 2, "rep_group_id": 1024, "data_obj_type": 13, "data_space_type": 1}, {"end_key": "AAAAAg==", "has_data": true, "region_id": 13, "start_key": "AAAAAQ==", "create_time": 1767494325495937234, "data_obj_id": 1, "rep_group_id": 1024, "data_obj_type": 12, "data_space_type": 1}, {"end_key": "AAAABQ==", "has_data": true, "region_id": 15, "start_key": "AAAABA==", "create_time": 1767494326189137966, "data_obj_id": 4, "rep_group_id": 1024, "data_obj_type": 12, "data_space_type": 1}], "rep_group_labels": {"no-auto-merge": "1", "no-auto-split": "1", "no-auto-migrate": "1"}, "key_range_version": 3, "member_node_names": ["node-***-001", "node-***-002"], "replica_storage_formats": {"node-***-001": 1, "node-***-002": 1}}}}}rep_group_job_state: Migratedcreate_time: 2026-01-04 10:38:45finish_time: 2026-01-04 10:38:53job_raft_log_index: 0job_vanished_rg_raft_log_index: 0job_commit_ts: 0job_msg:job_desc: {"mc_host":"mc-***-0","reason":"","reported_by":"","job_detail":{"causeType":8,"description":"add a replica to make up"}}task_id: 0task_type: TASK_TYPE_UNKNOWNcause_type: CAUSE_RG_QUORUM_CHECKschedule_rule: {"migration_rule":{"src_node_name":"node-***-001","dst_node_name":"node-***-002","rm_node_name":"","removal_kind":-1,"is_force":false,"new_leader_node_name":"","is_new_replica_learner":true,"use_joint_consensus":true,"storage_format":"STORAGE_FORMAT_DEFAULT","is_new_replica_witness":false}}1 row in set (0.01 se)
文档反馈