部署后无法连接

OceanBase 技术问题
#1

【 使用环境 】测试环境
【问题描述】部署后连接数据库提示5150 -Tenant not in this server

#3

麻烦提供下连接数据库的sql呢。
参考文档： OceanBase文档中心-分布式数据库使用文档

#4

一般来说这个报错原因是 当连接的租户不在所连接的服务器上时会提示这个。

进一步确认需要你描述集群的节点拓扑信息、租户的资源和拓扑。登录到 SYS 租户查一下下面 SQL：

select zone,concat(SVR_IP,':',SVR_PORT) observer,
	cpu_capacity_max cpu_total,cpu_assigned_max cpu_assigned,
	cpu_capacity-cpu_assigned_max as cpu_free,
	round(memory_limit/1024/1024/1024,2) as memory_total,
	round((mem_capacity-mem_assigned)/1024/1024/1024,2) as memory_free
from gv$ob_servers;

select t1.name resource_pool_name, t2.`name` unit_config_name, 
	t2.max_cpu, t2.min_cpu, 
	round(t2.memory_size/1024/1024/1024,2) mem_size_gb,
	round(t2.log_disk_size/1024/1024/1024,2) log_disk_size_gb, t2.max_iops, 
	t2.min_iops, t3.unit_id, t3.zone, concat(t3.svr_ip,':',t3.`svr_port`) observer,
	t4.tenant_id, t4.tenant_name
from __all_resource_pool t1
	join __all_unit_config t2 on (t1.unit_config_id=t2.unit_config_id)
	join __all_unit t3 on (t1.`resource_pool_id` = t3.`resource_pool_id`)
	left join __all_tenant t4 on (t1.tenant_id=t4.tenant_id)
order by t1.`resource_pool_id`, t2.`unit_config_id`, t3.unit_id;
1 个赞
#5

集群名字写错了吧