【产品名称】开源社区版
【产品版本】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