LOG_DISK_SIZE resource is not enough to hold a new unit

[秋秋i]

【 使用环境 】 测试环境
【问题描述】想给租户增加配置，但是任务失败了

[Royce1220]

select /*+ READ_CONSISTENCY(WEAK) */

a.zone,

a.svr_ip,

a.svr_ip,

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;
查一下这个看一下

[秋秋i]

[Royce1220]

日志盘不够了，看一下show parameters like ‘%log_disk%’;

[Royce1220]

如果磁盘够用的话，可以尝试调大log_disk_size;

[秋秋i]

@Royce1220

show parameters like ‘%log_disk%’;

[秋秋i]

我已经从原来的30G调整成100g了

本地空间是够的

[Royce1220]

好的，OB默认是按照memory*3来分配log_disk_size的，如果租户的unit是10G，那log_disk_size就需要30G

[秋秋i]

但是我调成了100G，还是报错

[Royce1220]

@Royce1220

select /*+ READ_CONSISTENCY(WEAK) */

a.zone,

a.svr_ip,

a.svr_ip,

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;

这个再查询一下呢

[旭辉]

你配置文件调整后重启了吗？

[秋秋i]

@Royce1220

select /*+ READ_CONSISTENCY(WEAK) */

a.zone,

a.svr_ip,

a.svr_ip,

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;

刚才查的就是我修改了config.yml文件log_disk_size为100G以后给你再查的

[旭辉]

如果没重启，在数据库里面需要同步修改下，参考
https://www.oceanbase.com/docs/common-oceanbase-database-cn-1000000001052550

[咖啡哥]

变更规格，点击“更多配置”，日志盘配小点。默认是内存的3倍

[旭辉]

有进展吗？

[秋秋i]

4.3不能这么执行吗

[秋秋i]

没找到调整日志盘哎

[Royce1220]

这是sys租户吗，需要去sys租户下调整

[秋秋i]

我进的就是sys租户吧

[旭辉]

这个语法看起来是有问题，我再确认下，你直接修改yaml文件重启下集群