升级OBD后升级OCP失败

OceanBase 技术问题
,
#23

学习学习

#24

user:
username: admin
password:
port: 3022
oceanbase-ce:
version: 4.2.1.8
release: 108000022024072217.el7
package_hash: 4285dbe242f497b8655c9b901f60c2848d555f52
33.67.3.14:
zone: zone1
33.67.3.15:
zone: zone2
33.67.3.16:
zone: zone3
servers:

  • 33.67.3.14
  • 33.67.3.15
  • 33.67.3.16
    global:
    appname: OcpSim
    root_password:
    mysql_port: 2881
    rpc_port: 2882
    home_path: /obhome/metadb/oceanbase
    data_dir: /obhome/metadb/data/1
    redo_dir: /ocplogs/metadb/data/log1
    ocp_meta_tenant:
    tenant_name: ocp_meta
    max_cpu: 2.0
    memory_size: 4G
    ocp_meta_username: root
    ocp_meta_password:
    ocp_meta_db: meta_database
    ocp_monitor_tenant:
    tenant_name: ocp_monitor
    max_cpu: 2.0
    memory_size: 8G
    ocp_monitor_username: root
    ocp_monitor_password:
    ocp_monitor_db: monitor_database
    cluster_id: 1769281957
    proxyro_password: p0dcBpISup
    ocp_root_password: dUOELUp4Vm
    ocp_meta_tenant_log_disk_size: 8G
    enable_syslog_wf: false
    max_syslog_file_count: 16
    memory_limit: 52G
    datafile_size: 155G
    system_memory: 7G
    log_disk_size: 141G
    cpu_count: 14
    datafile_maxsize: 222G
    datafile_next: 22G
    obproxy-ce:
    version: 4.3.5.0
    package_hash: 168f2fa3e36cc97f94df8baec80689f9c010ded0
    release: 3.el7
    servers:
  • 33.67.3.14
    global:
    home_path: /obhome/metadb/obproxy
    prometheus_listen_port: 2884
    listen_port: 2883
    enable_obproxy_rpc_service: false
    obproxy_sys_password: RJ2P4fvNFv
    skip_proxy_sys_private_check: true
    enable_strict_kernel_release: false
    enable_cluster_checkout: false
    rs_list: 33.67.3.14:2881;33.67.3.15:2881;33.67.3.16:2881
    cluster_name: OcpSim
    observer_root_password:
    depends:
  • oceanbase-ce
    33.67.3.14:
    proxy_id: 8035
    client_session_id_version: 2
    ocp-server-ce:
    version: 4.3.6
    package_hash: 9cb90dad471bb9ff8fe94c67402ce9560cc0b6fe
    release: 20250709105610.el7
    servers:
  • 33.67.3.14
  • 33.67.3.15
  • 33.67.3.16
    global:
    home_path: /obhome/ocp
    soft_dir: /obhome/software
    log_dir: /ocplogs/ocp/logs
    ocp_site_url: http://33.67.3.14:8080
    port: 8080
    admin_password:
    memory_size: 4G
    manage_info:
    machine: 10
    depends:
  • oceanbase-ce
  • obproxy-ce
#25

你从obd所在节点发起连接试一下

#26

OBD 通过proxy访问

image
image709×202 10.6 KB

obd 直接访问ob节点

image
image1052×544 32.2 KB

#27

执行下这个看看：netstat -an | grep 33.67.3.14:2883

然后连接上metadb执行：SHOW VARIABLES LIKE ‘max_connections’;

#28

image
obclient(root@ocp_meta)[(none)]> SHOW VARIABLES LIKE ‘max_connections’;
±----------------±-----------+
| Variable_name | Value |
±----------------±-----------+
| max_connections | 2147483647 |
±----------------±-----------+
1 row in set (0.005 sec)

#30

目前看还是连接metadb失败导致升级卡住。
meta租户登陆
UPDATE config_properties
SET value = ‘10000’
WHERE key = ‘spring.datasource.hikari.ConnectionTimeout’;
重新执行obd upgrade命令试试

#31

image
没有这个key

#32

这个问题涉及到row和proxy的平衡，根据我的经验，适当调整limited会有帮助。

#33

这个配置在哪里修改

#34

select * from config_properties where key = ‘spring.datasource.hikari.ConnectionTimeout’;
可以考虑把obproxy的配置去掉 直接用2881连接

#35

是不是超时了？这几台OCP都是虚拟机