启动集群报[ERROR] execute sql exception这个怎么处理

【产品名称】开源社区版

【产品版本】3.1.0

【问题描述】执行obd cluster start oceanbase-cc 报如下错误

Initialize cluster

[ERROR] execute sql exception

[ERROR] execute sql exception

[root@kf-zw-yewu03 oceanbase]# obd cluster deploy oceanbase-cc -c /opt/oceanbase/distributed-with-obproxy-example-cc.yaml

oceanbase-ce-3.1.0 already installed

obproxy-3.1.0 already installed

+-------------------------------------------------------------------+

|               Packages               |

+--------------+---------+------------------------------------------+

| Repository  | Version | Md5                   |

+--------------+---------+------------------------------------------+

| oceanbase-ce | 3.1.0  | 56f57e9843e719d830ec03c206d914f4b3adc82b |

| obproxy   | 3.1.0  | 0b17cf0459a3b53c5a2febb6572894d183154c64 |

+--------------+---------+------------------------------------------+

Open ssh connection ok

Remote oceanbase-ce-3.1.0-56f57e9843e719d830ec03c206d914f4b3adc82b repository install ok

Remote oceanbase-ce-3.1.0-56f57e9843e719d830ec03c206d914f4b3adc82b repository lib check ok

Remote obproxy-3.1.0-0b17cf0459a3b53c5a2febb6572894d183154c64 repository install ok

Remote obproxy-3.1.0-0b17cf0459a3b53c5a2febb6572894d183154c64 repository lib check ok

z1(192.168.65.13) initializes cluster work home

z2(192.168.65.12) initializes cluster work home

192.168.65.13 init cluster work home

oceanbase-cc deployed

[root@kf-zw-yewu03 oceanbase]# obd cluster start oceanbase-cc

Get local repositories and plugins ok

[WARN] (192.168.65.13) not enough memory

[WARN] (192.168.65.12) not enough memory

Start observer ok

observer program health check ok

Connect to observer ok

Initialize cluster

Cluster bootstrap ok

Wait for observer init ok

+-------------------------------------------------+

|           observer          |

+---------------+---------+------+-------+--------+

| ip      | version | port | zone | status |

+---------------+---------+------+-------+--------+

| 192.168.65.12 | 3.1.0  | 2881 | zone2 | active |

| 192.168.65.13 | 3.1.0  | 2881 | zone1 | active |

+---------------+---------+------+-------+--------+


Start obproxy ok

obproxy program health check ok

Connect to obproxy ok

Initialize cluster

[ERROR] execute sql exception

[ERROR] execute sql exception

+---------------------------------------------------+

|           obproxy           |

+---------------+------+-----------------+----------+

| ip      | port | prometheus_port | status  |

+---------------+------+-----------------+----------+

| 192.168.65.13 | -  | -        | inactive |

+---------------+------+-----------------+----------+

oceanbase-cc running


机器资源有限的话,可以进行单机部署,参考:https://open.oceanbase.com/articles/1100233,OceanBase社区版3.1低配置本地离线安装-工程系统实现。本文以2C、8G虚拟机的较低配置,安装部署OceanBase社区版3.1。

配置文件:

## Only need to configure when remote login is required
# user:
#   username: your username
#   password: your password if need
#   key_file: your ssh-key file path if need
#   port: your ssh port, default 22
#   timeout: ssh connection timeout (second), default 30
oceanbase-ce:
  servers:
    - name: z1
      # Please don't use hostname, only IP can be supported
      ip: 192.168.65.13
    - name: z2
      ip: 192.168.65.12
#    - name: z3
#      ip: 192.168.1.4
  global:
    # Please set devname as the network adaptor's name whose ip is  in the setting of severs.
    # if set severs as "127.0.0.1", please set devname as "lo"
    # if current ip is 192.168.1.10, and the ip's network adaptor's name is "eth0", please use "eth0"
    devname: ens16
    # if current hardware's memory capacity is smaller than 50G, please use the setting of "mini-single-example.yaml" and do a small adjustment.
    memory_limit: 60G
    datafile_disk_percentage: 20
    syslog_level: INFO
    enable_syslog_recycle: true
    max_syslog_file_count: 4
    cluster_id: 1
    # observer cluster name, consistent with obproxy's cluster_name
    appname: ob_cluster
    root_password: # root user password, can be empty
    proxyro_password: # proxyro user pasword, consistent with obproxy's observer_sys_password, can be empty
  # In this example , support multiple ob process in single node, so different process use different ports.
  # If deploy ob cluster in multiple nodes, the port and path setting can be same. 
  z1:
    mysql_port: 2881
    rpc_port: 2882
    home_path: /opt/observer
    zone: zone1
  z2:
    mysql_port: 2881
    rpc_port: 2882
    home_path: /opt/observer
    zone: zone2
#  z3:
#    mysql_port: 2881
#    rpc_port: 2882
#    home_path: /root/observer
#    zone: zone3
obproxy:
  servers:
    - 192.168.65.13
  global:
    listen_port: 2883
    prometheus_listen_port: 2884
    home_path: /opt/obproxy
    # oceanbase root server list
    # format: ip:mysql_port,ip:mysql_port
    rs_list: 192.168.65.13:2881;192.168.65.12:2881
    enable_cluster_checkout: false
    # observer cluster name, consistent with oceanbase-ce's appname
    cluster_name: ob_cluster
    obproxy_sys_password: # obproxy sys user password, can be empty
    observer_sys_password: # proxyro user pasword, consistent with oceanbase-ce's proxyro_password, can be empty

目前proxyro_password不能为空。如果不想设置proxyro的密码,可以把proxyro_password的配置注释或者删除。

我们将在最近的更新中修复。

参考issue https://github.com/oceanbase/obdeploy/issues/20