社区版4.3.5.4 bug node1的数据盘和日志盘大小不同修改

AntTech_ZGW8AE · 2025 年10 月 23 日 15:10

今天安装了这个版本，3节点，默认参数安装，运行起来以后，修改了集群的日志和数据盘大小，结果2和3变了，1始终不变。

重启node1和重启整个集群，还是如此。

旭辉 · 2025 年10 月 23 日 15:16

查一下这个sql

select /*+ READ_CONSISTENCY(WEAK) */
a.zone,
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(mem_capacity /1024/1024/1024 ,2) as mem_capacity,
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_capacity_gb,
round((DATA_DISK_ALLOCATED /1024/1024/1024 ),2) as data_disk_allocate_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;

AntTech_ZGW8AE · 2025 年10 月 23 日 15:31

旭辉:

select /*+ READ_CONSISTENCY(WEAK) */
a.zone,
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(mem_capacity /1024/1024/1024 ,2) as mem_capacity,
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_capacity_gb,
round((DATA_DISK_ALLOCATED /1024/1024/1024 ),2) as data_disk_allocate_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(root@sys)[oceanbase]> select /*+ READ_CONSISTENCY(WEAK) */
→ a.zone,
→ 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(mem_capacity /1024/1024/1024 ,2) as mem_capacity,
→ 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_capacity_gb,
→ round((DATA_DISK_ALLOCATED /1024/1024/1024 ),2) as data_disk_allocate_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;
*************************** 1. row ***************************
zone: zone1
svr_ip: 172.19.62.173
status: ACTIVE
cpu_capacity: 8
cpu_assigned_max: 2
cpu_free: 6
memory_total_gb: 24.00
mem_capacity: 18.00
system_memory_gb: 6.00
mem_assigned_gb: 2.00
memory_free_gb: 16.00
log_disk_capacity_gb: 16.00
log_disk_assigned_gb: 2.00
log_disk_free_gb: 14.00
data_disk_capacity_gb: 14.05
data_disk_allocate_gb: 4.00
data_disk_used_gb: 0.12
data_disk_free_gb: 13.92
*************************** 2. row ***************************
zone: zone3
svr_ip: 172.19.62.175
status: ACTIVE
cpu_capacity: 8
cpu_assigned_max: 2
cpu_free: 6
memory_total_gb: 24.00
mem_capacity: 18.00
system_memory_gb: 6.00
mem_assigned_gb: 2.00
memory_free_gb: 16.00
log_disk_capacity_gb: 70.00
log_disk_assigned_gb: 2.00
log_disk_free_gb: 68.00
data_disk_capacity_gb: 103.00
data_disk_allocate_gb: 12.00
data_disk_used_gb: 0.12
data_disk_free_gb: 102.88
*************************** 3. row ***************************
zone: zone2
svr_ip: 172.19.62.174
status: ACTIVE
cpu_capacity: 8
cpu_assigned_max: 2
cpu_free: 6
memory_total_gb: 24.00
mem_capacity: 18.00
system_memory_gb: 6.00
mem_assigned_gb: 2.00
memory_free_gb: 16.00
log_disk_capacity_gb: 70.00
log_disk_assigned_gb: 2.00
log_disk_free_gb: 68.00
data_disk_capacity_gb: 103.00
data_disk_allocate_gb: 12.00
data_disk_used_gb: 0.12
data_disk_free_gb: 102.88
3 rows in set (0.008 sec)