【 使用环境 】 测试环境
【 OB 】
【 使用版本 】 4.3.0
【问题描述】创建oceanbase 资源池报资源不足，但是在ocp前端界面查看资源是充足得状态
【附件及日志】
subtask_4000661.log (16.9 KB)
select a.zone, a.SVR_IP,a.SVR_PORT, b.status,cpu_capacity,cpu_assigned_max,cpu_capacity-cpu_assigned_max as cpu_free,round(memory_limit /1024/1024/1024 ,2) as memory_total_gb,round((memory_limit-mem_capacity) /1024/1024/1024 ,2) as system_memory_gb,round(mem_assigned /1024/1024/1024 ,2) as mem_assigned_gb,round((mem_capacity-mem_assigned) /1024/1024/1024 ,2) as memory_free_gb,round(log_disk_capacity /1024/1024/1024 ,2) as log_disk_capacity_gb,round(log_disk_assigned /1024/1024/1024 ,2) as log_disk_assigned_gb,round((log_disk_capacity-log_disk_assigned) /1024/1024/1024 ,2) as log_disk_free_gb,round((data_disk_capacity /1024/1024/1024 ),2) as data_disk_gb,round((data_disk_in_use /1024/1024/1024 ),2) as data_disk_used_gb,round((data_disk_capacity-data_disk_in_use) /1024/1024/1024 ,2) as data_disk_free_gb from gv$ob_servers a join oceanbase.DBA_OB_SERVERS b on a.zone=b.zone\G;
执行看下
obclient [(none)]> select a.zone, a.SVR_IP,a.SVR_PORT, b.status,cpu_capacity,cpu_assigned_max,cpu_capacity-cpu_assigned_max as cpu_free,round(memory_limit /1024/1024/1024 ,2) as memory_total_gb,round((memory_limit-mem_capacity) /1024/1024/1024 ,2) as system_memory_gb,round(mem_assigned /1024/1024/1024 ,2) as mem_assigned_gb,round((mem_capacity-mem_assigned) /1024/1024/1024 ,2) as memory_free_gb,round(log_disk_capacity /1024/1024/1024 ,2) as log_disk_capacity_gb,round(log_disk_assigned /1024/1024/1024 ,2) as log_disk_assigned_gb,round((log_disk_capacity-log_disk_assigned) /1024/1024/1024 ,2) as log_disk_free_gb,round((data_disk_capacity /1024/1024/1024 ),2) as data_disk_gb,round((data_disk_in_use /1024/1024/1024 ),2) as data_disk_used_gb,round((data_disk_capacity-data_disk_in_use) /1024/1024/1024 ,2) as data_disk_free_gb from gv$ob_servers a join oceanbase.DBA_OB_SERVERS b on a.zone=b.zone\G;
ERROR 1046 (3D000): No database selected
ERROR:
No query specified
obclient [(none)]>
到sys租户 oceanbase库里执行
*************************** 1. row ***************************
zone: zone3
SVR_IP: 10.141.161.128
SVR_PORT: 2882
status: ACTIVE
cpu_capacity: 16
cpu_assigned_max: 6
cpu_free: 10
memory_total_gb: 62.00
system_memory_gb: 5.00
mem_assigned_gb: 22.00
memory_free_gb: 35.00
log_disk_capacity_gb: 70.31
log_disk_assigned_gb: 64.00
log_disk_free_gb: 6.31
data_disk_gb: 1672.00
data_disk_used_gb: 1.44
data_disk_free_gb: 1670.56
*************************** 2. row ***************************
zone: zone3
SVR_IP: 10.141.161.128
SVR_PORT: 2882
status: ACTIVE
cpu_capacity: 16
cpu_assigned_max: 6
cpu_free: 10
memory_total_gb: 62.00
system_memory_gb: 5.00
mem_assigned_gb: 22.00
memory_free_gb: 35.00
log_disk_capacity_gb: 70.31
log_disk_assigned_gb: 64.00
log_disk_free_gb: 6.31
data_disk_gb: 1672.00
data_disk_used_gb: 1.44
data_disk_free_gb: 1670.56
*************************** 3. row ***************************
zone: zone3
SVR_IP: 10.141.161.211
SVR_PORT: 2882
status: ACTIVE
cpu_capacity: 16
cpu_assigned_max: 3
cpu_free: 13
memory_total_gb: 62.00
system_memory_gb: 5.00
mem_assigned_gb: 20.00
memory_free_gb: 37.00
log_disk_capacity_gb: 70.31
log_disk_assigned_gb: 60.00
log_disk_free_gb: 10.31
data_disk_gb: 1672.00
data_disk_used_gb: 3.98
data_disk_free_gb: 1668.02
*************************** 4. row ***************************
zone: zone3
SVR_IP: 10.141.161.211
SVR_PORT: 2882
status: ACTIVE
cpu_capacity: 16
cpu_assigned_max: 3
cpu_free: 13
memory_total_gb: 62.00
system_memory_gb: 5.00
mem_assigned_gb: 20.00
memory_free_gb: 37.00
log_disk_capacity_gb: 70.31
log_disk_assigned_gb: 60.00
log_disk_free_gb: 10.31
data_disk_gb: 1672.00
data_disk_used_gb: 3.98
data_disk_free_gb: 1668.02
*************************** 5. row ***************************
zone: zone1
SVR_IP: 10.141.161.94
SVR_PORT: 2882
status: ACTIVE
cpu_capacity: 16
cpu_assigned_max: 6
cpu_free: 10
memory_total_gb: 32.00
system_memory_gb: 5.00
mem_assigned_gb: 22.00
memory_free_gb: 5.00
log_disk_capacity_gb: 70.31
log_disk_assigned_gb: 64.00
log_disk_free_gb: 6.31
data_disk_gb: 1742.00
data_disk_used_gb: 1.43
data_disk_free_gb: 1740.57
*************************** 6. row ***************************
zone: zone1
SVR_IP: 10.141.161.94
SVR_PORT: 2882
status: ACTIVE
cpu_capacity: 16
cpu_assigned_max: 6
cpu_free: 10
memory_total_gb: 32.00
system_memory_gb: 5.00
mem_assigned_gb: 22.00
memory_free_gb: 5.00
log_disk_capacity_gb: 70.31
log_disk_assigned_gb: 64.00
log_disk_free_gb: 6.31
data_disk_gb: 1742.00
data_disk_used_gb: 1.43
data_disk_free_gb: 1740.57
*************************** 7. row ***************************
zone: zone2
SVR_IP: 10.141.161.163
SVR_PORT: 2882
status: ACTIVE
cpu_capacity: 16
cpu_assigned_max: 3
cpu_free: 13
memory_total_gb: 62.00
system_memory_gb: 5.00
mem_assigned_gb: 20.00
memory_free_gb: 37.00
log_disk_capacity_gb: 70.31
log_disk_assigned_gb: 60.00
log_disk_free_gb: 10.31
data_disk_gb: 1672.00
data_disk_used_gb: 4.02
data_disk_free_gb: 1667.98
*************************** 8. row ***************************
zone: zone2
SVR_IP: 10.141.161.163
SVR_PORT: 2882
status: ACTIVE
cpu_capacity: 16
cpu_assigned_max: 3
cpu_free: 13
memory_total_gb: 62.00
system_memory_gb: 5.00
mem_assigned_gb: 20.00
memory_free_gb: 37.00
log_disk_capacity_gb: 70.31
log_disk_assigned_gb: 60.00
log_disk_free_gb: 10.31
data_disk_gb: 1672.00
data_disk_used_gb: 4.02
data_disk_free_gb: 1667.98
*************************** 9. row ***************************
zone: zone2
SVR_IP: 10.141.161.144
SVR_PORT: 2882
status: ACTIVE
cpu_capacity: 16
cpu_assigned_max: 6
cpu_free: 10
memory_total_gb: 32.00
system_memory_gb: 5.00
mem_assigned_gb: 22.00
memory_free_gb: 5.00
log_disk_capacity_gb: 70.31
log_disk_assigned_gb: 64.00
log_disk_free_gb: 6.31
data_disk_gb: 1742.00
data_disk_used_gb: 1.42
data_disk_free_gb: 1740.58
*************************** 10. row ***************************
zone: zone2
SVR_IP: 10.141.161.144
SVR_PORT: 2882
status: ACTIVE
cpu_capacity: 16
cpu_assigned_max: 6
cpu_free: 10
memory_total_gb: 32.00
system_memory_gb: 5.00
mem_assigned_gb: 22.00
memory_free_gb: 5.00
log_disk_capacity_gb: 70.31
log_disk_assigned_gb: 64.00
log_disk_free_gb: 6.31
data_disk_gb: 1742.00
data_disk_used_gb: 1.42
data_disk_free_gb: 1740.58
*************************** 11. row ***************************
zone: zone1
SVR_IP: 10.141.161.227
SVR_PORT: 2882
status: ACTIVE
cpu_capacity: 16
cpu_assigned_max: 3
cpu_free: 13
memory_total_gb: 32.00
system_memory_gb: 5.00
mem_assigned_gb: 20.00
memory_free_gb: 7.00
log_disk_capacity_gb: 70.31
log_disk_assigned_gb: 60.00
log_disk_free_gb: 10.31
data_disk_gb: 1741.00
data_disk_used_gb: 4.13
data_disk_free_gb: 1736.87
*************************** 12. row ***************************
zone: zone1
SVR_IP: 10.141.161.227
SVR_PORT: 2882
status: ACTIVE
cpu_capacity: 16
cpu_assigned_max: 3
cpu_free: 13
memory_total_gb: 32.00
system_memory_gb: 5.00
mem_assigned_gb: 20.00
memory_free_gb: 7.00
log_disk_capacity_gb: 70.31
log_disk_assigned_gb: 60.00
log_disk_free_gb: 10.31
data_disk_gb: 1741.00
data_disk_used_gb: 4.13
data_disk_free_gb: 1736.87
12 rows in set (0.082 sec)
ERROR:
No query specified
创建语句设置的cpu是多少。cpu_free: 10-13 可以调大点
、、memory_free_gb: 7.00、log_disk_free_gb: 10.31 看着也快分配没了。可以调整调整。
老师
我是6台主机 三个区域 每个zone两台机器 机器规格是三台是8c32G 三台是8c64G 上面那个规格要怎样设置 ，我准备是新建一个租户 做一下数据库性能测试用得
日志提示server ‘“10.141.161.144:2882”’ LOG_DISK resource not enough
server ‘“10.141.161.163:2882”’ LOG_DISK resource not enough
目前日志提示是 log_disk_size不足 先调整 log_disk_size参数吧， 修改方式：alter system set log_disk_size=‘XXG’;
log_disk_size是什么值 主机磁盘得大小吗 我是一个小白 
datafile_size 和 log_disk_size 一个控制的是数据盘，一个控制的是日志盘大小
日志提示 log_disk_size 不足，需要调整下大小。
这边调整后 又出现别的报错
128还是上面的修改方式
211是修改内存大小：alter system set memory_limit=‘XXG’;
是在dbproxy上执行就行 还是说到每个节点下面操作
先看下配置文件吧。obd cluster edit-config name
user:
username: root
password:
port: 22
oceanbase-ce:
version: 4.3.0.1
release: 100000242024032211.el7
package_hash: c4a03c83614f50c99ddb1c37dda858fa5d9b14b7
10.141.161.94:
zone: zone1
datafile_maxsize: 1742G
datafile_next: 174G
10.141.161.227:
zone: zone1
datafile_maxsize: 1741G
datafile_next: 174G
10.141.161.144:
zone: zone2
datafile_maxsize: 1742G
datafile_next: 174G
10.141.161.163:
zone: zone2
datafile_maxsize: 1672G
datafile_next: 167G
10.141.161.128:
zone: zone3
datafile_maxsize: 1672G
datafile_next: 167G
10.141.161.211:
zone: zone3
datafile_maxsize: 1672G
datafile_next: 167G
servers:
- 10.141.161.94
- 10.141.161.144
- 10.141.161.128
- 10.141.161.227
- 10.141.161.163
- 10.141.161.211
global:
appname: myoceanbase
root_password:
mysql_port: 2881
rpc_port: 2882
home_path: /data/myoceanbase/oceanbase
cluster_id: 1715220881
enable_syslog_recycle: true
enable_syslog_wf: false
max_syslog_file_count: 4
memory_limit: 27423M
datafile_size: 82270M
system_memory: 5120M
log_disk_size: 72030M
cpu_count: 16
ocp_agent_monitor_password:
proxyro_password:
ocp_root_password:
ocp_meta_password:
obproxy-ce:
version: 4.2.3.0
package_hash: 0490ebc04220def8d25cb9cac9ac61a4efa6d639
release: 3.el7
servers: - 10.141.161.94
global:
prometheus_listen_port: 2884
listen_port: 2883
home_path: /data/myoceanbase/obproxy
obproxy_sys_password:
skip_proxy_sys_private_check: true
enable_strict_kernel_release: false
enable_cluster_checkout: false
rs_list: 10.141.161.94:2881;10.141.161.144:2881;10.141.161.128:2881
observer_sys_password:
cluster_name: myoceanbase
observer_root_password:
10.141.161.94:
proxy_id: 2988
client_session_id_version: 2
depends: - oceanbase-ce
obagent:
version: 4.2.2
package_hash: 19739a07a12eab736aff86ecf357b1ae660b554e
release: 100000042024011120.el7
servers: - 10.141.161.94
- 10.141.161.227
- 10.141.161.144
- 10.141.161.163
- 10.141.161.128
- 10.141.161.211
global:
monagent_http_port: 8088
mgragent_http_port: 8089
home_path: /data/myoceanbase/obagent
http_basic_auth_password:
ob_monitor_status: active
depends: - oceanbase-ce
ocp-express:
version: 4.2.2
package_hash: 09ffcf156d1df9318a78af52656f499d2315e3f7
release: 100000022024011120.el7
servers: - 10.141.161.94
global:
port: 8180
home_path: /data/myoceanbase/ocpexpress
admin_passwd:
memory_size: 1052M
depends: - obagent
- oceanbase-ce
- obproxy-ce
老师这是配置文件
两种方式。
- 通过obd cluster edit-config 方式修改配置文件里面的参数进行调大
- 通过登陆sys租户 进行：
修改内存大小：alter system set memory_limit=‘XXG’;
修改方式：alter system set log_disk_size=‘XXG’; 方式