创建资源池 提示内存资源不足

OceanBase 技术问题
#1

报错内容：ErrorCode = 4733, SQLState = HY000, Details = zone ‘zone1’ resource not enough to hold 1 unit. You can check resource info by views: DBA_OB_UNITS, GV$OB_UNITS, GV$OB_SERVERS. server ‘“192.168.98.54:2882”’ MEMORY resource not enough
【 使用环境 】 测试环境
【 OB or 其他组件 】oceanbase 三节点 服务器配置 32C 128G
【 使用版本 】4.0.0
【问题描述】已有一个sys资源池和pool1资源池，再次新建资源池就提示上述报错内容
【复现路径】新建资源单元 CREATE RESOURCE UNIT unit2 MAX_CPU 2,
MIN_CPU 2,
MEMORY_SIZE ‘10G’,
MAX_IOPS 10000,
MIN_IOPS 1024,
IOPS_WEIGHT 0,
LOG_DISK_SIZE ‘2G’
新建资源池 CREATE RESOURCE POOL pool2 UNIT=‘unit2’,UNIT_NUM=1,ZONE_LIST=(‘zone1’,‘zone2’,‘zone3’);

之后就提示 ErrorCode = 4733, SQLState = HY000, Details = zone ‘zone1’ resource not enough to hold 1 unit. You can check resource info by views: DBA_OB_UNITS, GV$OB_UNITS, GV$OB_SERVERS. server ‘“192.168.98.54:2882”’ MEMORY resource not enough

#3

按照提示查查每台机器资源使用情况。
应该就是提示那样，资源被使用完了。

可以着重看看sys租户分配的资源是不是太大，导致普通租户这分配不到

1 个赞
#4

查看下集群资源使用情况:

SELECT SVR_IP ,
        SVR_PORT ,
        ZONE ,
        SQL_PORT ,
        CPU_CAPACITY ,
        CPU_CAPACITY_MAX ,
        CPU_ASSIGNED ,
        CPU_ASSIGNED_MAX ,
        MEM_CAPACITY/1024/1024/1024 as  MEM_CAPACITY_GB ,
        MEM_ASSIGNED/1024/1024/1024 as MEM_ASSIGNED_GB,
        LOG_DISK_CAPACITY/1024/1024/1024 as LOG_DISK_CAPACITY_GB  ,
        LOG_DISK_ASSIGNED/1024/1024/1024 as LOG_DISK_ASSIGNED_GB ,
        LOG_DISK_IN_USE/1024/1024/1024 as LOG_DISK_IN_USE_GB ,
        DATA_DISK_CAPACITY/1024/1024/1024 as DATA_DISK_CAPACITY_GB ,
        DATA_DISK_IN_USE/1024/1024/1024 as DATA_DISK_IN_USE_GB,
        DATA_DISK_HEALTH_STATUS ,
        MEMORY_LIMIT/1024/1024/1024 as MEMORY_LIMIT_GB 
FROM GV$OB_SERVERS;