--- title: 小规格租户资源池 (1C2G) 创建失败-OceanBase数据库使用指南 description: 了解OceanBase数据库在实际应用中关于小规格租户资源池 (1C2G) 创建失败相关的常见问题和使用技巧，帮助您快速解决小规格租户资源池 (1C2G) 创建失败的难题。 --- 切换语言 - 简体中文 - English 划线反馈 # 小规格租户资源池 (1C2G) 创建失败 更新时间：2026-06-10 01:56 适用版本： V1.4.x、V2.1.x、V2.2.x、V3.1.x、V3.2.x、V4.0.x、V4.1.x、V4.2.x 内容类型：Troubleshoot ## 适用版本 OceanBase 数据库所有版本。 ## 问题现象 小规格资源池(1C2G)创建失败，具体如下。 1. 创建 1C2G 的资源单元。 ```shell obclient [oceanbase]> create resource unit mqt max_cpu 1,min_cpu 1,max_memory '2G',min_memory '2G',MAX_IOPS 128, MIN_IOPS 128, MAX_DISK_SIZE 536870912, MAX_SESSION_NUM 64; Query OK, 0 rows affected (0.00 sec) ``` 2. 创建 1C2G 的资源池报错。 ```shell obclient [oceanbase]> create resource pool p1 unit 'mqt',unit_num 1,zone_list('zone1','zone2','zone3'); ``` 返回结果如下： ```shell ERROR 1235 (0A000): unit min memory less than __min_full_resource_pool_memory not supported ``` ## 问题原因 OceanBase 创建资源池默认只允许大于 5G（包括 5G）内存规格。 可以查看隐藏参数 `__min_full_resource_pool_memory` 参数值是 5G，所以创建资源池失败，具体语句如下： ```shell obclient [oceanbase]> select * from __all_virtual_sys_parameter_stat where name='__min_full_resource_pool_memory'; ``` 返回结果如下。 ```shell +-------+----------+-------------+----------+---------------------------------+-----------+------------+--------------+-------------------------------------------------------------------+-------------+--------------+---------------+---------+---------+-------------------+ | zone | svr_type | svr_ip | svr_port | name | data_type | value | value_strict | info | need_reboot | section | visible_level | scope | source | edit_level | +-------+----------+-------------+----------+---------------------------------+-----------+------------+--------------+-------------------------------------------------------------------+-------------+--------------+---------------+---------+---------+-------------------+ | zone1 | observer | xx.xx.xx.xx | 2882 | __min_full_resource_pool_memory | NULL | 5368709120 | NULL | the min memory value which is specified for a full resource pool. | NULL | LOAD_BALANCE | NULL | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone3 | observer | xx.xx.xx.xx | 2882 | __min_full_resource_pool_memory | NULL | 5368709120 | NULL | the min memory value which is specified for a full resource pool. | NULL | LOAD_BALANCE | NULL | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | xx.xx.xx.xx | 2882 | __min_full_resource_pool_memory | NULL | 5368709120 | NULL | the min memory value which is specified for a full resource pool. | NULL | LOAD_BALANCE | NULL | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +-------+----------+-------------+----------+---------------------------------+-----------+------------+--------------+-------------------------------------------------------------------+-------------+--------------+---------------+---------+---------+-------------------+ 3 rows in set (0.03 sec) ``` ## 解决方法 将 OceanBase 集群隐藏参数 `__min_full_resource_pool_memory` 修改成 1G。 具体操作如下。 1. 修改隐藏参数 `__min_full_resource_pool_memory` 为 1G。 ```shell obclient [oceanbase]> alter system set __min_full_resource_pool_memory=1073741824; Query OK, 0 rows affected (0.03 sec) ``` 2. 查询内部表 `__all_virtual_sys_parameter_stat` 中 value 是否为 1G。 ``` 返回结果如下。 ```shell +-------+----------+-------------+----------+---------------------------------+-----------+------------+--------------+-------------------------------------------------------------------+-------------+--------------+---------------+---------+---------+-------------------+ | zone | svr_type | svr_ip | svr_port | name | data_type | value | value_strict | info | need_reboot | section | visible_level | scope | source | edit_level | +-------+----------+-------------+----------+---------------------------------+-----------+------------+--------------+-------------------------------------------------------------------+-------------+--------------+---------------+---------+---------+-------------------+ | zone1 | observer | xx.xx.xx.xx | 2882 | __min_full_resource_pool_memory | NULL | 1073741824 | NULL | the min memory value which is specified for a full resource pool. | NULL | LOAD_BALANCE | NULL | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone3 | observer | xx.xx.xx.xx | 2882 | __min_full_resource_pool_memory | NULL | 1073741824 | NULL | the min memory value which is specified for a full resource pool. | NULL | LOAD_BALANCE | NULL | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | xx.xx.xx.xx | 2882 | __min_full_resource_pool_memory | NULL | 1073741824 | NULL | the min memory value which is specified for a full resource pool. | NULL | LOAD_BALANCE | NULL | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +-------+----------+-------------+----------+---------------------------------+-----------+------------+--------------+-------------------------------------------------------------------+-------------+--------------+---------------+---------+---------+-------------------+ 3 rows in set (0.02 sec) ``` 3. 修改完成之后，1C2G 小规格资源池创建成功。 ```shell obclient [oceanbase]> create resource pool p1 unit 'mqt',unit_num 1,zone_list('zone1','zone2','zone3'); Query OK, 0 rows affected (0.01 sec) ``` Previous [资源池错误，错误代码 4656](https://www.oceanbase.com/knowledge-base/oceanbase-database-20000000092) Next [添加资源池报错，错误代码 4657](https://www.oceanbase.com/knowledge-base/oceanbase-database-20000010170) ![有帮助](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*y6ocSqN8cqsAAAAAAAAAAAAAARQnAQ)![无帮助](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*BG9IQJyLHF8AAAAAAAAAAAAAARQnAQ)![反馈](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*eTWdQKCRKHwAAAAAAAAAAAAAARQnAQ)[AI](https://www.oceanbase.com/obi) 咨询热线