【 使用环境 】测试环境
【 OB 】
无法对集群进行初始化。
【 使用版本 】
V3.1.5_CE_HF2
【问题描述】清晰明确描述问题
为了参加OBCP V3考试，我在测试环境手工部署了集群。
我在三台服务器上分别通过如下方式启动了服务：
cd ~/oceanbase && bin/observer -i p5p1 -p 2881 -P 2882 -z zone1 -d ~/oceanbase/store/obcluster -r ‘10.110.7.40:2882:2881;10.110.7.41:2882:2881;10.110.7.42:2882:2881’ -c 20240205 -n obcluster -o “memory_limit=8G,cache_wash_threshold=1G,__min_full_resource_pool_memory=268435456,system_memory=3G,memory_chunk_cache_size=128M,cpu_count=12,net_thread_count=4,datafile_size=50G,stack_size=1536K,config_additional_dir=/data/obcluster/etc3;/redo/obcluster/etc2”
cd ~/oceanbase && bin/observer -i p5p1 -p 2881 -P 2882 -z zone2 -d ~/oceanbase/store/obcluster -r ‘10.110.7.40:2882:2881;10.110.7.41:2882:2881;10.110.7.42:2882:2881’ -c 20240205 -n obcluster -o “memory_limit=8G,cache_wash_threshold=1G,__min_full_resource_pool_memory=268435456,system_memory=3G,memory_chunk_cache_size=128M,cpu_count=12,net_thread_count=4,datafile_size=50G,stack_size=1536K,config_additional_dir=/data/obcluster/etc3;/redo/obcluster/etc2”
cd ~/oceanbase && bin/observer -i p5p1 -p 2881 -P 2882 -z zone3 -d ~/oceanbase/store/obcluster -r ‘10.110.7.40:2882:2881;10.110.7.41:2882:2881;10.110.7.42:2882:2881’ -c 20240205 -n obcluster -o “memory_limit=8G,cache_wash_threshold=1G,__min_full_resource_pool_memory=268435456,system_memory=3G,memory_chunk_cache_size=128M,cpu_count=12,net_thread_count=4,datafile_size=50G,stack_size=1536K,config_additional_dir=/data/obcluster/etc3;/redo/obcluster/etc2”
使用mysql -h 10.110.7.41 -u root -P 2881 -p -c -A 登录数据库进行初始化：
报错，报错信息如下：
[admin@xsky-node2 ~]$ mysql -h 10.110.7.40 -u root -P 2881 -p -c -A
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3221225473
Server version: 5.7.25 OceanBase 3.1.5 (r100020022023091114-8a9dc4b356d043b494015503d6d91f876486fbed) (Built Sep 11 2023 14:38:53)
Copyright (c) 2000, 2022, Oracle and/or its affiliates.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.
MySQL [(none)] > set session ob_query_timeout=1000000000;alter system bootstrap ZONE ‘zone1’ SERVER ‘10.110.7.40:2882’,ZONE ‘zone2’ SERVER ‘10.110.7.41:2882’, ZONE ‘zone3’ SERVER ‘10.110.7.42:2882’;
Query OK, 0 rows affected (0.00 sec)
ERROR 4015 (HY000): System error
不知道什么原因，该如何处理。
另外就是我对应V3.1.5_CE_HF2 的OB，我的obproxy该安装哪个版本更好。
如有问题请联系： 18701685580
【复现路径】问题出现前后相关操作
【附件及日志】
