ocp显示空闲内存足够，修改资源单元却提示资源不够

大师兄 · 2024 年8 月 8 日 10:07

【使用环境】测试环境
【使用版本】4.3
【问题描述】ocp显示空闲内存足够，修改资源单元却提示资源不够
【复现路径】

alter resource unit ocp_meta_unit MEMORY_SIZE = '8G';

ErrorCode = 4624, SQLState = HY000, Details = zone 'zone1' server '"192.168.1.52:2882"' MEMORY_SIZE resource is not enough to hold a new unit
提示内存不足

但是在ocpweb端查看zone1 的observer缺显示有空闲内存，这是为何啊

zmix · 2024 年8 月 8 日 10:25

select zone,concat(SVR_IP,’:’,SVR_PORT) observer,
cpu_capacity_max cpu_total,cpu_assigned_max cpu_assigned,
cpu_capacity-cpu_assigned_max as cpu_free,
round(memory_limit/1024/1024/1024,2) as memory_total,
round((memory_limit-mem_capacity)/1024/1024/1024,2) as system_memory,
round(mem_assigned/1024/1024/1024,2) as mem_assigned,
round((mem_capacity-mem_assigned)/1024/1024/1024,2) as memory_free,
round(log_disk_capacity/1024/1024/1024,2) as log_disk_capacity,
round(log_disk_assigned/1024/1024/1024,2) as log_disk_assigned,
round((log_disk_capacity-log_disk_assigned)/1024/1024/1024,2) as log_disk_free,
round((data_disk_capacity/1024/1024/1024),2) as data_disk,
round((data_disk_in_use/1024/1024/1024),2) as data_disk_used,
round((data_disk_capacity-data_disk_in_use)/1024/1024/1024,2) as data_disk_free
from oceanbase.gv$ob_servers;
查询看下

大师兄 · 2024 年8 月 8 日 11:04

ErrorCode = 1064, SQLState = 42000, Details = You have an error in your SQL syntax; check the manual that corresponds to your OceanBase version for the right syntax to use near ':’,SVR_PORT) observer, cpu_capacity_max cpu_total,cpu_assigned_max cpu_assigne' at line 1