在创建租户时报错

OceanBase 技术问题
#1

【 使用环境 】 测试环境
【 OB or 其他组件 】
【 使用版本 】4.3.5
【问题描述】在选择以小规格开发模式-单机部署（mini-single-example.yaml）创建租户时报错
【复现路径】CREATE RESOURCE UNIT unit1 MAX_CPU 1, MIN_CPU 1, MEMORY_SIZE ‘2G’, MAX_IOPS 1024, MIN_IOPS 1024, IOPS_WEIGHT 0, LOG_DISK_SIZE ‘2G’;

CREATE RESOURCE POOL pool1 UNIT=‘unit1’,UNIT_NUM=1,ZONE_LIST=(‘zone1’);

CREATE TENANT IF NOT EXISTS IBSENPTFS
charset=‘utf8mb4’,
comment ‘mysql tenant/instance’,
primary_zone=‘RANDOM’,
resource_pool_list = (‘pool1’) set ob_tcp_invited_nodes = ‘%’;

【附件及日志】

image
image1001×249 6.31 KB

【备注】请教大佬是什么问题，或者有没有相关文档，谢谢各位大佬

1 个赞
#3

select * from oceanbase.gv$ob_units;先查一下这个信息

#4

image
image3111×148 10.8 KB

大佬过目

#5

这几个信息 也查一下
show parameters where name in (‘memory_limit’,‘memory_limit_percentage’,‘system_memory’,‘log_disk_size’,‘log_disk_percentage’,‘datafile_size’,‘datafile_disk_percentage’);

#6

image
image2987×197 15.7 KB

是我执行的姿势不对吗

#7

粘贴过去的时候注意字符转译

#8

image
image1415×475 28.4 KB

请大佬过目

#9
zone svr_type svr_ip svr_port name data_type value info section scope source edit_level default_value isdefault
zone1 observer 172.16.2.10 12882 log_disk_percentage INT 0 the percentage of disk space used by the log files. Range: [0,99] in integer; only effective when parameter log_disk_size is 0; when log_disk_percentage is 0: a) if the data and the log are on the same disk, means log_disk_percentage = 30 b) if the data and the log are on the different disks, means log_disk_perecentage = 90 LOGSERVICE CLUSTER DEFAULT DYNAMIC_EFFECTIVE 0 1
zone1 observer 172.16.2.10 12882 log_disk_size CAPACITY 14G the size of disk space used by the log files. Range: [0, +∞) LOGSERVICE CLUSTER DEFAULT DYNAMIC_EFFECTIVE 0M 0
zone1 observer 172.16.2.10 12882 memory_limit_percentage INT 80 the size of the memory reserved for internal use (for testing purpose). Range: [10, 95] OBSERVER CLUSTER DEFAULT DYNAMIC_EFFECTIVE 80 1
zone1 observer 172.16.2.10 12882 system_memory CAPACITY 1G the memory reserved for internal use which cannot be allocated to any outer-tenant, and should be determined to guarantee every server functions normally. Range: [0M,) OBSERVER CLUSTER DEFAULT DYNAMIC_EFFECTIVE 0M 0
zone1 observer 172.16.2.10 12882 memory_limit CAPACITY 6G the size of the memory reserved for internal use (for testing purpose), 0 means follow memory_limit_percentage. Range: 0, [1G,) OBSERVER CLUSTER DEFAULT DYNAMIC_EFFECTIVE 0M 0
zone1 observer 172.16.2.10 12882 datafile_disk_percentage INT 0 the percentage of disk space used by the data files. Range: [0,99] in integer SSTABLE CLUSTER DEFAULT DYNAMIC_EFFECTIVE 0 1
zone1 observer 172.16.2.10 12882 datafile_size CAPACITY 2G size of the data file. Range: [0, +∞) SSTABLE CLUSTER DEFAULT DYNAMIC_EFFECTIVE 0M 0
#10

在查一下 这个信息 SELECT * FROM oceanbase.DBA_OB_UNIT_CONFIGS;

#11

image
image2478×222 14.1 KB

#12

你按照这个语法创建
CREATE TENANT IF NOT EXISTS IBSENPTFS
PRIMARY_ZONE=‘zone1’,
RESOURCE_POOL_LIST=(‘pool1’)
set OB_TCP_INVITED_NODES=’%’;

1 个赞