根据SELECT DISTINCT SVR_IP, SVR_PORT FROM oceanbase.CDB_OB_LS_LOCATIONS WHERE tenant_id = 1001; 查出来结果是空
查看待进行资源隔离的租户的资源规格
SELECT * FROM oceanbase.DBA_OB_UNIT_CONFIGS;
输出结果如下：
obclient(root@sys)[(none)]> SELECT * FROM oceanbase.DBA_OB_UNIT_CONFIGS;
+----------------+--------------------+----------------------------+----------------------------+---------+---------+-------------+---------------+---------------------+---------------------+-------------+
| UNIT_CONFIG_ID | NAME | CREATE_TIME | MODIFY_TIME | MAX_CPU | MIN_CPU | MEMORY_SIZE | LOG_DISK_SIZE | MAX_IOPS | MIN_IOPS | IOPS_WEIGHT |
+----------------+--------------------+----------------------------+----------------------------+---------+---------+-------------+---------------+---------------------+---------------------+-------------+
| 1 | sys_unit_config | 2025-06-16 17:12:20.916675 | 2025-06-16 17:12:20.916675 | 3 | 3 | 2147483648 | 2147483648 | 9223372036854775807 | 9223372036854775807 | 3 |
| 1002 | oracle_tenant_unit | 2025-06-17 18:52:31.184843 | 2025-06-17 18:52:31.184843 | 1 | 1 | 2147483648 | 6442450944 | 10000 | 10000 | 1 |
+----------------+--------------------+----------------------------+----------------------------+---------+---------+-------------+---------------+---------------------+---------------------+-------------+
2 rows in set (0.023 sec)
obclient(root@sys)[oceanbase]> SELECT DISTINCT SVR_IP, SVR_PORT FROM oceanbase.CDB_OB_LS_LOCATIONS WHERE tenant_id = 1002;
Empty set (0.015 sec)
obclient(root@sys)[oceanbase]> SELECT DISTINCT SVR_IP, SVR_PORT FROM oceanbase.CDB_OB_LS_LOCATIONS WHERE tenant_id = 1001;
Empty set (0.008 sec)
根据查询结果，如果该租户的 MAX_IOPS 和 MIN_IOPS 均为默认值 INT64_MAX （9223372036854775807），则需要对租户可使用的 IOPS 资源重新进行规划。