【 使用环境 】测试环境
【 OB or 其他组件 】 OB
【 使用版本 】 4.3.5.5
【问题描述】增加租户副本, 命令行修改租户 tnt_20260126 的 Locality, 任务 ALTER_TENANT_LOCALITY 一直是执行中。
前面有个问题是在ocp删除副本,也是一直卡在 Wait alter locality ,后来删除集群重建再测试删除副本,秒成功。这次测试增加,又卡住了。
ocp社区版 删除租户副本 任务一直Wait alter locality 一直是执行中 - 社区问答- OceanBase社区-分布式数据库
obclient(root@sys)[oceanbase]> ALTER TENANT tnt_20260126 locality="FULL{1}@zone1, FULL{1}@zone2, FULL{1}@zone3";
Query OK, 0 rows affected (0.134 sec)
obclient(root@sys)[oceanbase]> SELECT * FROM oceanbase.DBA_OB_TENANT_JOBS WHERE JOB_TYPE = 'ALTER_TENANT_LOCALITY';
+--------+-----------------------+------------+-------------+----------+----------------------------+----------------------------+-----------+----------------------------------------------------------------------------------+-----------------------------------------------------------------------------------------+----------------+-------------+
| JOB_ID | JOB_TYPE | JOB_STATUS | RESULT_CODE | PROGRESS | START_TIME | MODIFY_TIME | TENANT_ID | SQL_TEXT | EXTRA_INFO | RS_SVR_IP | RS_SVR_PORT |
+--------+-----------------------+------------+-------------+----------+----------------------------+----------------------------+-----------+----------------------------------------------------------------------------------+-----------------------------------------------------------------------------------------+----------------+-------------+
| 4 | ALTER_TENANT_LOCALITY | SUCCESS | 0 | 100 | 2026-01-29 09:55:07.663139 | 2026-01-29 09:55:38.787132 | 1002 | ALTER TENANT `tnt_20260126` LOCALITY = 'FULL{1}@zone1, FULL{1}@zone2' | FROM: 'FULL{1}@zone1, FULL{1}@zone2, FULL{1}@zone3', TO: 'FULL{1}@zone1, FULL{1}@zone2' | 192.168.56.151 | 2882 |
| 5 | ALTER_TENANT_LOCALITY | INPROGRESS | NULL | 0 | 2026-01-29 19:16:34.121401 | 2026-01-29 19:16:34.121401 | 1002 | ALTER TENANT tnt_20260126 locality="FULL{1}@zone1, FULL{1}@zone2, FULL{1}@zone3" | FROM: 'FULL{1}@zone1, FULL{1}@zone2', TO: 'FULL{1}@zone1, FULL{1}@zone2, FULL{1}@zone3' | 192.168.56.151 | 2882 |
+--------+-----------------------+------------+-------------+----------+----------------------------+----------------------------+-----------+----------------------------------------------------------------------------------+-----------------------------------------------------------------------------------------+----------------+-------------+
2 rows in set (0.011 sec)
obclient(root@sys)[oceanbase]> select * from __all_server_event_history where module like '%storage_ha%' and value1 like '%1002%' and name6 = 'is_failed' and value6 != '0' order by gmt_create desc limit 50;
+----------------------------+----------------+----------+------------+-----------------------------+-----------+--------+-------+--------+-------+-----------------------+-------+-----------------------+---------+-----------------------------------+-----------+--------+------------+
| gmt_create | svr_ip | svr_port | module | event | name1 | value1 | name2 | value2 | name3 | value3 | name4 | value4 | name5 | value5 | name6 | value6 | extra_info |
+----------------------------+----------------+----------+------------+-----------------------------+-----------+--------+-------+--------+-------+-----------------------+-------+-----------------------+---------+-----------------------------------+-----------+--------+------------+
| 2026-01-29 19:51:04.886794 | 192.168.56.153 | 2882 | storage_ha | ls_ha_finish | tenant_id | 1002 | ls_id | 1 | src | "192.168.56.153:2882" | dst | "192.168.56.153:2882" | task_id | YB42C0A83897-0006497CECEF5204-0-0 | is_failed | -4184 | ADD_LS_OP |
| 2026-01-29 19:50:54.823930 | 192.168.56.153 | 2882 | storage_ha | migration_finish_task | tenant_id | 1002 | ls_id | 1 | src | "192.168.56.153:2882" | dst | "192.168.56.153:2882" | task_id | YB42C0A83897-0006497CECEF5204-0-0 | is_failed | 1 | ADD_LS_OP |
| 2026-01-29 19:50:04.291887 | 192.168.56.153 | 2882 | storage_ha | ls_ha_finish | tenant_id | 1002 | ls_id | 1 | src | "192.168.56.153:2882" | dst | "192.168.56.153:2882" | task_id | YB42C0A83897-0006497CECEF51F2-0-0 | is_failed | -4184 | ADD_LS_OP |
| 2026-01-29 19:49:54.019033 | 192.168.56.153 | 2882 | storage_ha | migration_finish_task | tenant_id | 1002 | ls_id | 1 | src | "192.168.56.153:2882" | dst | "192.168.56.153:2882" | task_id | YB42C0A83897-0006497CECEF51F2-0-0 | is_failed | 1 | ADD_LS_OP |
| 2026-01-29 19:49:04.277383 | 192.168.56.153 | 2882 | storage_ha | ls_ha_finish | tenant_id | 1002 | ls_id | 1 | src | "192.168.56.153:2882" | dst | "192.168.56.153:2882" | task_id | YB42C0A83897-0006497CECEF51D1-0-0 | is_failed | -4184 | ADD_LS_OP |
| 2026-01-29 19:48:04.436173 | 192.168.56.153 | 2882 | storage_ha | migration_finish_task | tenant_id | 1002 | ls_id | 1 | src | "192.168.56.153:2882" | dst | "192.168.56.153:2882" | task_id | YB42C0A83897-0006497CECEF51D1-0-0 | is_failed | 1 | ADD_LS_OP |
| 2026-01-29 19:47:04.155201 | 192.168.56.153 | 2882 | storage_ha | ls_ha_finish | tenant_id | 1002 | ls_id | 1 | src | "192.168.56.153:2882" | dst | "192.168.56.153:2882" | task_id | YB42C0A83897-0006497CECEF51B0-0-0 | is_failed | -4184 | ADD_LS_OP |
| 2026-01-29 19:46:04.282279 | 192.168.56.153 | 2882 | storage_ha | migration_finish_task | tenant_id | 1002 | ls_id | 1 | src | "192.168.56.153:2882" | dst | "192.168.56.153:2882" | task_id | YB42C0A83897-0006497CECEF51B0-0-0 | is_failed | 1 | ADD_LS_OP |
| 2026-01-29 19:46:04.282170 | 192.168.56.153 | 2882 | storage_ha | data_tablets_migration_task | tenant_id | 1002 | ls_id | 1 | src | "192.168.56.153:2882" | dst | "192.168.56.153:2882" | task_id | YB42C0A83897-0006497CECEF51B0-0-0 | is_failed | 1 | ADD_LS_OP |
| 2026-01-29 19:45:03.728130 | 192.168.56.153 | 2882 | storage_ha | ls_ha_finish | tenant_id | 1002 | ls_id | 1 | src | "192.168.56.153:2882" | dst | "192.168.56.153:2882" | task_id | YB42C0A83897-0006497CECEF5189-0-0 | is_failed | -4184 | ADD_LS_OP |
| 2026-01-29 19:44:04.179132 | 192.168.56.153 | 2882 | storage_ha | migration_finish_task | tenant_id | 1002 | ls_id | 1 | src | "192.168.56.153:2882" | dst | "192.168.56.153:2882" | task_id | YB42C0A83897-0006497CECEF5189-0-0 | is_failed | 1 | ADD_LS_OP |
| 2026-01-29 19:43:02.878922 | 192.168.56.153 | 2882 | storage_ha | ls_ha_finish | tenant_id | 1002 | ls_id | 1 | src | "192.168.56.153:2882" | dst | "192.168.56.153:2882" | task_id | YB42C0A83897-0006497CECEF5168-0-0 | is_failed | -4184 | ADD_LS_OP |
| 2026-01-29 19:42:04.723784 | 192.168.56.153 | 2882 | storage_ha | migration_finish_task | tenant_id | 1002 | ls_id | 1 | src | "192.168.56.153:2882" | dst | "192.168.56.153:2882" | task_id | YB42C0A83897-0006497CECEF5168-0-0 | is_failed | 1 | ADD_LS_OP |
| 2026-01-29 19:41:02.121032 | 192.168.56.153 | 2882 | storage_ha | ls_ha_finish | tenant_id | 1002 | ls_id | 1 | src | "192.168.56.153:2882" | dst | "192.168.56.153:2882" | task_id | YB42C0A83897-0006497CECEF5153-0-0 | is_failed | -4184 | ADD_LS_OP |
| 2026-01-29 19:40:52.618369 | 192.168.56.153 | 2882 | storage_ha | migration_finish_task | tenant_id | 1002 | ls_id | 1 | src | "192.168.56.153:2882" | dst | "192.168.56.153:2882" | task_id | YB42C0A83897-0006497CECEF5153-0-0 | is_failed | 1 | ADD_LS_OP |
| 2026-01-29 19:40:01.886524 | 192.168.56.153 | 2882 | storage_ha | ls_ha_finish | tenant_id | 1002 | ls_id | 1 | src | "192.168.56.153:2882" | dst | "192.168.56.153:2882" | task_id | YB42C0A83897-0006497CECEF5132-0-0 | is_failed | -4184 | ADD_LS_OP |
| 2026-01-29 19:39:06.379731 | 192.168.56.153 | 2882 | storage_ha | migration_finish_task | tenant_id | 1002 | ls_id | 1 | src | "192.168.56.153:2882" | dst | "192.168.56.153:2882" | task_id | YB42C0A83897-0006497CECEF5132-0-0 | is_failed | 1 | ADD_LS_OP |
| 2026-01-29 19:38:01.475697 | 192.168.56.153 | 2882 | storage_ha | ls_ha_finish | tenant_id | 1002 | ls_id | 1 | src | "192.168.56.153:2882" | dst | "192.168.56.153:2882" | task_id | YB42C0A83897-0006497CECEF510E-0-0 | is_failed | -4184 | ADD_LS_OP |
| 2026-01-29 19:37:04.860768 | 192.168.56.153 | 2882 | storage_ha | migration_finish_task | tenant_id | 1002 | ls_id | 1 | src | "192.168.56.153:2882" | dst | "192.168.56.153:2882" | task_id | YB42C0A83897-0006497CECEF510E-0-0 | is_failed | 1 | ADD_LS_OP |
| 2026-01-29 19:36:00.501163 | 192.168.56.153 | 2882 | storage_ha | ls_ha_finish | tenant_id | 1002 | ls_id | 1 | src | "192.168.56.153:2882" | dst | "192.168.56.153:2882" | task_id | YB42C0A83897-0006497CECEF50ED-0-0 | is_failed | -4184 | ADD_LS_OP |
| 2026-01-29 19:35:04.939073 | 192.168.56.153 | 2882 | storage_ha | migration_finish_task | tenant_id | 1002 | ls_id | 1 | src | "192.168.56.153:2882" | dst | "192.168.56.153:2882" | task_id | YB42C0A83897-0006497CECEF50ED-0-0 | is_failed | 1 | ADD_LS_OP |
| 2026-01-29 19:34:00.077651 | 192.168.56.153 | 2882 | storage_ha | ls_ha_finish | tenant_id | 1002 | ls_id | 1 | src | "192.168.56.153:2882" | dst | "192.168.56.153:2882" | task_id | YB42C0A83897-0006497CECEF50C9-0-0 | is_failed | -4184 | ADD_LS_OP |
| 2026-01-29 19:33:05.683197 | 192.168.56.153 | 2882 | storage_ha | migration_finish_task | tenant_id | 1002 | ls_id | 1 | src | "192.168.56.153:2882" | dst | "192.168.56.153:2882" | task_id | YB42C0A83897-0006497CECEF50C9-0-0 | is_failed | 1 | ADD_LS_OP |
| 2026-01-29 19:31:59.976855 | 192.168.56.153 | 2882 | storage_ha | ls_ha_finish | tenant_id | 1002 | ls_id | 1 | src | "192.168.56.153:2882" | dst | "192.168.56.153:2882" | task_id | YB42C0A83897-0006497CECEF50A5-0-0 | is_failed | -4184 | ADD_LS_OP |
| 2026-01-29 19:31:04.595620 | 192.168.56.153 | 2882 | storage_ha | migration_finish_task | tenant_id | 1002 | ls_id | 1 | src | "192.168.56.153:2882" | dst | "192.168.56.153:2882" | task_id | YB42C0A83897-0006497CECEF50A5-0-0 | is_failed | 1 | ADD_LS_OP |
| 2026-01-29 19:29:59.729346 | 192.168.56.153 | 2882 | storage_ha | ls_ha_finish | tenant_id | 1002 | ls_id | 1 | src | "192.168.56.153:2882" | dst | "192.168.56.153:2882" | task_id | YB42C0A83897-0006497CECEF5081-0-0 | is_failed | -4184 | ADD_LS_OP |
| 2026-01-29 19:29:03.557320 | 192.168.56.153 | 2882 | storage_ha | migration_finish_task | tenant_id | 1002 | ls_id | 1 | src | "192.168.56.153:2882" | dst | "192.168.56.153:2882" | task_id | YB42C0A83897-0006497CECEF5081-0-0 | is_failed | 1 | ADD_LS_OP |
| 2026-01-29 19:27:59.569495 | 192.168.56.153 | 2882 | storage_ha | ls_ha_finish | tenant_id | 1002 | ls_id | 1 | src | "192.168.56.153:2882" | dst | "192.168.56.153:2882" | task_id | YB42C0A83897-0006497CECEF505D-0-0 | is_failed | -4184 | ADD_LS_OP |
| 2026-01-29 19:27:04.812512 | 192.168.56.153 | 2882 | storage_ha | migration_finish_task | tenant_id | 1002 | ls_id | 1 | src | "192.168.56.153:2882" | dst | "192.168.56.153:2882" | task_id | YB42C0A83897-0006497CECEF505D-0-0 | is_failed | 1 | ADD_LS_OP |
| 2026-01-29 19:25:59.209344 | 192.168.56.153 | 2882 | storage_ha | ls_ha_finish | tenant_id | 1002 | ls_id | 1 | src | "192.168.56.153:2882" | dst | "192.168.56.153:2882" | task_id | YB42C0A83897-0006497CECEF504B-0-0 | is_failed | -4184 | ADD_LS_OP |
| 2026-01-29 19:25:53.066213 | 192.168.56.153 | 2882 | storage_ha | migration_finish_task | tenant_id | 1002 | ls_id | 1 | src | "192.168.56.153:2882" | dst | "192.168.56.153:2882" | task_id | YB42C0A83897-0006497CECEF504B-0-0 | is_failed | 1 | ADD_LS_OP |
| 2026-01-29 19:24:58.996890 | 192.168.56.153 | 2882 | storage_ha | ls_ha_finish | tenant_id | 1002 | ls_id | 1 | src | "192.168.56.153:2882" | dst | "192.168.56.153:2882" | task_id | YB42C0A83897-0006497CECEF5039-0-0 | is_failed | -4184 | ADD_LS_OP |
| 2026-01-29 19:24:52.166510 | 192.168.56.153 | 2882 | storage_ha | migration_finish_task | tenant_id | 1002 | ls_id | 1 | src | "192.168.56.153:2882" | dst | "192.168.56.153:2882" | task_id | YB42C0A83897-0006497CECEF5039-0-0 | is_failed | 1 | ADD_LS_OP |
| 2026-01-29 19:23:58.530645 | 192.168.56.153 | 2882 | storage_ha | ls_ha_finish | tenant_id | 1002 | ls_id | 1 | src | "192.168.56.153:2882" | dst | "192.168.56.153:2882" | task_id | YB42C0A83897-0006497CECEF5027-0-0 | is_failed | -4184 | ADD_LS_OP |
| 2026-01-29 19:23:51.839895 | 192.168.56.153 | 2882 | storage_ha | migration_finish_task | tenant_id | 1002 | ls_id | 1 | src | "192.168.56.153:2882" | dst | "192.168.56.153:2882" | task_id | YB42C0A83897-0006497CECEF5027-0-0 | is_failed | 1 | ADD_LS_OP |
| 2026-01-29 19:22:57.698516 | 192.168.56.153 | 2882 | storage_ha | ls_ha_finish | tenant_id | 1002 | ls_id | 1 | src | "192.168.56.153:2882" | dst | "192.168.56.153:2882" | task_id | YB42C0A83897-0006497CECEF5015-0-0 | is_failed | -4184 | ADD_LS_OP |
| 2026-01-29 19:22:50.699730 | 192.168.56.153 | 2882 | storage_ha | migration_finish_task | tenant_id | 1002 | ls_id | 1 | src | "192.168.56.153:2882" | dst | "192.168.56.153:2882" | task_id | YB42C0A83897-0006497CECEF5015-0-0 | is_failed | 1 | ADD_LS_OP |
| 2026-01-29 19:21:57.364012 | 192.168.56.153 | 2882 | storage_ha | ls_ha_finish | tenant_id | 1002 | ls_id | 1 | src | "192.168.56.153:2882" | dst | "192.168.56.153:2882" | task_id | YB42C0A83897-0006497CECEF5003-0-0 | is_failed | -4184 | ADD_LS_OP |
| 2026-01-29 19:21:50.253589 | 192.168.56.153 | 2882 | storage_ha | migration_finish_task | tenant_id | 1002 | ls_id | 1 | src | "192.168.56.153:2882" | dst | "192.168.56.153:2882" | task_id | YB42C0A83897-0006497CECEF5003-0-0 | is_failed | 1 | ADD_LS_OP |
| 2026-01-29 19:20:57.140745 | 192.168.56.153 | 2882 | storage_ha | ls_ha_finish | tenant_id | 1002 | ls_id | 1 | src | "192.168.56.153:2882" | dst | "192.168.56.153:2882" | task_id | YB42C0A83897-0006497CECEF4FF1-0-0 | is_failed | -4184 | ADD_LS_OP |
| 2026-01-29 19:20:48.352398 | 192.168.56.153 | 2882 | storage_ha | migration_finish_task | tenant_id | 1002 | ls_id | 1 | src | "192.168.56.153:2882" | dst | "192.168.56.153:2882" | task_id | YB42C0A83897-0006497CECEF4FF1-0-0 | is_failed | 1 | ADD_LS_OP |
| 2026-01-29 19:19:57.057461 | 192.168.56.153 | 2882 | storage_ha | ls_ha_finish | tenant_id | 1002 | ls_id | 1 | src | "192.168.56.153:2882" | dst | "192.168.56.153:2882" | task_id | YB42C0A83897-0006497CECEF4FD0-0-0 | is_failed | -4184 | ADD_LS_OP |
| 2026-01-29 19:19:05.364406 | 192.168.56.153 | 2882 | storage_ha | migration_finish_task | tenant_id | 1002 | ls_id | 1 | src | "192.168.56.153:2882" | dst | "192.168.56.153:2882" | task_id | YB42C0A83897-0006497CECEF4FD0-0-0 | is_failed | 1 | ADD_LS_OP |
| 2026-01-29 19:17:57.000997 | 192.168.56.153 | 2882 | storage_ha | ls_ha_finish | tenant_id | 1002 | ls_id | 1 | src | "192.168.56.153:2882" | dst | "192.168.56.153:2882" | task_id | YB42C0A83897-0006497CECEF4FA9-0-0 | is_failed | -4184 | ADD_LS_OP |
| 2026-01-29 19:17:04.332283 | 192.168.56.153 | 2882 | storage_ha | migration_finish_task | tenant_id | 1002 | ls_id | 1 | src | "192.168.56.153:2882" | dst | "192.168.56.153:2882" | task_id | YB42C0A83897-0006497CECEF4FA9-0-0 | is_failed | 1 | ADD_LS_OP |
+----------------------------+----------------+----------+------------+-----------------------------+-----------+--------+-------+--------+-------+-----------------------+-------+-----------------------+---------+-----------------------------------+-----------+--------+------------+
45 rows in set (0.132 sec)
obclient(root@sys)[oceanbase]>
