【 使用环境 】生产环境
【 OB or 其他组件 】
【 使用版本 】
【问题描述】能确认任务还在进行中,OCP上只是2小时触发超时了然后失败了,这种等后台执行好了是重试还是跳过?
obclient(root@sys)[oceanbase]> SELECT LS_ID,TASK_TYPE,TASK_ID,TASK_STATUS,PRIORITY,TARGET_REPLICA_SVR_IP,SOURCE_REPLICA_SVR_IP,TASK_EXEC_SVR_IP,MODIFY_TIME FROM oceanbase.CDB_OB_LS_REPLICA_TASKS WHERE tenant_id = 1004 ORDER BY ls_id ;
±------±----------------±----------------------------------±------------±---------±----------------------±----------------------±-----------------±--------------------+
| LS_ID | TASK_TYPE | TASK_ID | TASK_STATUS | PRIORITY | TARGET_REPLICA_SVR_IP | SOURCE_REPLICA_SVR_IP | TASK_EXEC_SVR_IP | MODIFY_TIME |
±------±----------------±----------------------------------±------------±---------±----------------------±----------------------±-----------------±--------------------+
| 1002 | MIGRATE REPLICA | YB42C0A8C06B-00064977381AF05A-0-0 | INPROGRESS | HIGH | 192.168.192.104 | 192.168.192.110 | 192.168.192.104 | 2026-06-10 12:40:43 |
| 1202 | MIGRATE REPLICA | YB42C0A8C06B-00064977381AF054-0-0 | INPROGRESS | HIGH | 192.168.192.104 | 192.168.192.110 | 192.168.192.104 | 2026-06-10 12:40:32 |
| 1203 | MIGRATE REPLICA | YB42C0A8C06B-00064977381AEFD2-0-0 | INPROGRESS | HIGH | 192.168.192.104 | 192.168.192.110 | 192.168.192.104 | 2026-06-10 12:38:35 |
±------±----------------±----------------------------------±------------±---------±----------------------±----------------------±-----------------±--------------------+
3 rows in set (0.009 sec)
obclient(root@sys)[oceanbase]> SELECT /*+ ocp_query */ TENANT_ID, JOB_ID, JOB_TYPE, JOB_STATUS, PROGRESS FROM oceanbase.DBA_OB_TENANT_JOBS WHERE TENANT_ID = 1004 AND JOB_TYPE = ‘ALTER_RESOURCE_TENANT_UNIT_NUM’;
±----------±-------±-------------------------------±-----------±---------+
| TENANT_ID | JOB_ID | JOB_TYPE | JOB_STATUS | PROGRESS |
±----------±-------±-------------------------------±-----------±---------+
| 1004 | 4 | ALTER_RESOURCE_TENANT_UNIT_NUM | SUCCESS | 100 |
| 1004 | 12 | ALTER_RESOURCE_TENANT_UNIT_NUM | SUCCESS | 100 |
| 1004 | 13 | ALTER_RESOURCE_TENANT_UNIT_NUM | INPROGRESS | 0 |
±----------±-------±-------------------------------±-----------±---------+
3 rows in set (0.005 sec)
