无法修改unit

【 使用环境 】生产环境
【 使用版本 】5.7.25-OceanBase_CE-v4.3.1.0
【问题描述】
1、数据库root用户修改unit报错
ALTER RESOURCE POOL pool_name UNIT_NUM = 2;
ERROR 4179 (HY000): alter pool unit num which is granted to a tenant not allowed
2、云平台修改 Unit报错:
指定的租户sitegroup(状态运维中)报错“当前状态不支持此操作”
############{EXECUTE}{2026-01-28T05:24:48.523Z}############
2026-01-28 05:24:48.534 INFO 638847 — [pool-manual-subtask-executor1,4597db7af4bc4884,a921ecc1b9fa] c.o.o.t.engine.runner.JavaSubtaskRunner : Run subtask, id=412000002, context=Context{parallelIdx=-1, stringMap={ob_tenant_id=1008, prohibit_rollback=false, task_instance_id=412000002, task_operation=execute, latest_execution_start_time=2026-01-28T05:24:48.508Z, sub_task_instance_id=412000002, unit_count=2}, listMap={unit_spec_json_list=[{“cpuCore”:2.00,“memoryBytes”:8589934592,“memorySize”:8}, {“cpuCore”:2.00,“memoryBytes”:8589934592,“memorySize”:8}, {“cpuCore”:2.00,“memoryBytes”:8589934592,“memorySize”:8}], zone_names=[zone1, zone2, zone3]}}, executor=196.128.1.1

2026-01-28 05:24:48.536 INFO 638847 — [pool-manual-subtask-executor1,4597db7af4bc4884,a921ecc1b9fa] c.o.o.o.i.t.task.PrepareAlterTenantTask : prepare alter tenant, tenantId=1008

2026-01-28 05:24:48.541 INFO 638847 — [pool-manual-subtask-executor1,4597db7af4bc4884,a921ecc1b9fa] c.o.o.o.i.t.task.PrepareAlterTenantTask : update status finished

Set state for subtask: 412000002, operation:EXECUTE, state: FAILED
2026-01-28 05:29:59.536 WARN 638847 — [pool-subtask-executor1,] c.o.o.t.e.c.w.s.TimeoutSubtaskWorker : Subtask timeout, name=Prepare alter tenant, executedSeconds=311, timeout=300

2 个赞

当前集群规模是什么样子的

现在解决了,因为已分配给租户了,通过 ALTER RESOURCE TENANT sys UNIT_NUM = 2;命令在数据库里成功修改了。

1 个赞

对啊,资源池已经分配给租户的话,要修改Zone的资源单元个数,只能修改租户的配置项,alter tenant

2 个赞