【 使用环境 】生产环境
【 OB or 其他组件 】OB、OBProxy
【 使用版本 】OceanBase_CE-v4.2.2.0
【问题描述】使用navicat从mysql库往oceanbase库里导数据，ob如果直连2881可以正常导入，但如果连接2883就会报错，如下图：
请问这是什么原因导致的呢？
请问这是什么原因导致的呢？
手动连接2883数据库可以成功嘛？
可以提供下连接串信息
select a.zone, a.SVR_IP,a.SVR_PORT, 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;
select a.zone,a.svr_ip,b.tenant_name,b.tenant_type, a.max_cpu, a.min_cpu, round(a.memory_size/1024/1024/1024,2) memory_size_gb, round(a.log_disk_size/1024/1024/1024,2) log_disk_size, round(a.log_disk_in_use/1024/1024/1024,2) log_disk_in_use, round(a.data_disk_in_use/1024/1024/1024,2) data_disk_in_use from oceanbase.gv$ob_units a join oceanbase.dba_ob_tenants b on a.tenant_id=b.tenant_id order by b.tenant_name;
看看租户和集群得资源情况
第一个sql报这个错：
第二个sql的返回值：
| zone | svr_ip | tenant_name | tenant_type | max_cpu | min_cpu | memory_size_gb | log_disk_size | log_disk_in_use | data_disk_in_use |
|---|---|---|---|---|---|---|---|---|---|
| zone1 | 192.168.0.130 | business | USER | 40 | 40 | 90.00 | 36.00 | 0.66 | 0.03 |
| zone3 | 192.168.0.147 | business | USER | 40 | 40 | 90.00 | 36.00 | 0.66 | 0.03 |
| zone2 | 192.168.0.251 | business | USER | 40 | 40 | 90.00 | 36.00 | 0.66 | 0.03 |
大佬，能看出什么问题吗？
sys租户 oceanbase库执行呢。
observer core了。可以看下这个帖子https://ask.oceanbase.com/t/topic/35606122?
生产环境建议升级到4.2.3版本，不要使用4.2.2.0 这个版本了。
obproxy有以下TCP相关的参数可以调整下：
#tcp相关参数
alter proxyconfig set client_sock_option_flag_out=3;
alter proxyconfig set client_tcp_keepidle=5;
alter proxyconfig set client_tcp_keepintvl=5;
alter proxyconfig set client_tcp_keepcnt=5;
alter proxyconfig set client_tcp_user_timeout=0;
alter proxyconfig set sock_option_flag_out=3;
alter proxyconfig set server_tcp_keepcnt=5;
alter proxyconfig set server_tcp_keepidle=5;
alter proxyconfig set server_tcp_keepintvl=5;
alter proxyconfig set server_tcp_user_timeout=0;
你这个是数据库崩溃了吧？
大佬救急 