集群在线体验环境中确认租户部署在哪些 OBServer 节点上的SQL执行结果为空

根据SELECT DISTINCT SVR_IP, SVR_PORT FROM oceanbase.CDB_OB_LS_LOCATIONS WHERE tenant_id = 1001; 查出来结果是空

1 个赞

已解决,将tenant_id改成1002就可以了
obclient(root@sys)[oceanbase]> SELECT * FROM oceanbase.DBA_OB_UNIT_CONFIGS\G
*************************** 1. row ***************************
UNIT_CONFIG_ID: 1
NAME: sys_unit_config
CREATE_TIME: 2025-06-16 17:12:20.916675
MODIFY_TIME: 2025-06-16 17:12:20.916675
MAX_CPU: 3
MIN_CPU: 3
MEMORY_SIZE: 2147483648
LOG_DISK_SIZE: 2147483648
MAX_IOPS: 9223372036854775807
MIN_IOPS: 9223372036854775807
IOPS_WEIGHT: 3
*************************** 2. row ***************************
UNIT_CONFIG_ID: 1002
NAME: oracle_tenant_unit
CREATE_TIME: 2025-06-17 18:52:31.184843
MODIFY_TIME: 2025-06-17 18:52:31.184843
MAX_CPU: 1
MIN_CPU: 1
MEMORY_SIZE: 2147483648
LOG_DISK_SIZE: 6442450944
MAX_IOPS: 10000
MIN_IOPS: 10000
IOPS_WEIGHT: 1
2 rows in set (0.001 sec)