obd部署机:10.99.88.110
observer单机集群:100.99.88.107
使用yaml配置文件进行黑屏部署
部署报错的详细obd日志麻烦发一份看看
obd文件是部署机.obd/log/目录里的log,log和log_shell这两个文件夹是observer节点上的oceanbase/的
我们的服务器环境一般都会配多个网卡不同的网段,之前maridb这样部署是可以的。不知道为什么换成oceanbase使用内网网段就部署失败
tar包里的obd文件就是 .obd/log/目录下的
网卡(devname)配置项不支持分别制定。
部署4.2以上的ob可以不指定网卡,会用local ip方式来启动,可以把devname 配置项去掉, 来启动
我们一开始是只使用了ip这个键名,后来上了多网卡的环境,发现使用内网ip时oceanbase部署失败,才加上了devname,结果还是报一样的错误。
都是互相能ping的
进程存在说明ob已经启动成功了可以试试黑屏化连接,报错是connect超时么?
[sys@e107 ~]$ mysql -h10.99.88.107 -P2881 -uroot@sys -p******* -Doceanbase -A
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3221487626
Server version: 5.7.25 OceanBase_CE 4.3.3.0 (r100000142024101215-0723f9774e5f77a1253149261ba75a94414625d0) (Built Oct 12 2024 16:04:08)
Copyright (c) 2000, 2024, 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> show databases;
±-------------------+
| Database |
±-------------------+
| information_schema |
| LBACSYS |
| mysql |
| oceanbase |
| ocs |
| ORAAUDITOR |
| SYS |
| sys_external_tbs |
| test |
±-------------------+
9 rows in set (0.01 sec)
mysql> select * from dba_ob_tenants\G
*************************** 1. row ***************************
TENANT_ID: 1
TENANT_NAME: sys
TENANT_TYPE: SYS
CREATE_TIME: 2025-01-03 10:58:32.303109
MODIFY_TIME: 2025-01-03 10:58:32.303109
PRIMARY_ZONE: RANDOM
LOCALITY: FULL{1}@zone1
PREVIOUS_LOCALITY: NULL
COMPATIBILITY_MODE: MYSQL
STATUS: NORMAL
IN_RECYCLEBIN: NO
LOCKED: NO
TENANT_ROLE: PRIMARY
SWITCHOVER_STATUS: NORMAL
SWITCHOVER_EPOCH: 0
SYNC_SCN: NULL
REPLAYABLE_SCN: NULL
READABLE_SCN: NULL
RECOVERY_UNTIL_SCN: NULL
LOG_MODE: NOARCHIVELOG
ARBITRATION_SERVICE_STATUS: DISABLED
UNIT_NUM: 1
COMPATIBLE: 4.3.3.0
MAX_LS_ID: 1
RESTORE_DATA_MODE: NORMAL
1 row in set (0.03 sec)
mysql>
sys租户已经能登陆进行查询了
但是obd中控机报部署错误
[2025-01-03 10:58:38.962] [DEBUG] – osys@100.99.88.107 execute: cd /observer/oceanbase; /observer/oceanbase/bin/obshell admin start --ip 100.99.88.107 --port 2886
[2025-01-03 10:58:43.177] [DEBUG] – exited code 0
[2025-01-03 10:58:46.181] [DEBUG] – send request to obshell: method: GET, url: /api/v1/status, data: {}, headers: None, params: None
[2025-01-03 10:58:58.045] [ERROR] response parser error: Expecting value: line 1 column 1 (char 0)
[2025-01-03 10:58:58.046] [ERROR] oceanbase-ce-py_script_bootstrap-4.2.2.0 RuntimeError: ‘NoneType’ object has no attribute ‘code’
[2025-01-03 10:58:58.046] [ERROR] Traceback (most recent call last):
[2025-01-03 10:58:58.046] [ERROR] File “core.py”, line 2104, in start_cluster
[2025-01-03 10:58:58.046] [ERROR] File “core.py”, line 2209, in _start_cluster
[2025-01-03 10:58:58.046] [ERROR] File “core.py”, line 198, in call_plugin
[2025-01-03 10:58:58.046] [ERROR] File “_plugin.py”, line 348, in call
[2025-01-03 10:58:58.046] [ERROR] File “_plugin.py”, line 305, in _new_func
[2025-01-03 10:58:58.046] [ERROR] File “/home/osys/.obd/plugins/oceanbase-ce/4.2.2.0/bootstrap.py”, line 167, in bootstrap
[2025-01-03 10:58:58.046] [ERROR] status = ocs_cursor[server].status_request(ignore_ConnectionError=True)
[2025-01-03 10:58:58.046] [ERROR] File “/home/osys/.obd/plugins/oceanbase-ce/4.2.2.0/connect.py”, line 412, in status_request
[2025-01-03 10:58:58.046] [ERROR] resp = self.request(‘GET’, ‘/api/v1/status’, ignore_ConnectionError=ignore_ConnectionError)
[2025-01-03 10:58:58.047] [ERROR] File “/home/sys/.obd/plugins/oceanbase-ce/4.2.2.0/connect.py”, line 381, in request
[2025-01-03 10:58:58.047] [ERROR] return self._request(method, url, data, headers, params, ignore_ConnectionError=ignore_ConnectionError, *args, **kwargs)
[2025-01-03 10:58:58.047] [ERROR] File “/home/osys/.obd/plugins/oceanbase-ce/4.2.2.0/connect.py”, line 335, in _request
[2025-01-03 10:58:58.047] [ERROR] if parsed_resp.code != 200:
[2025-01-03 10:58:58.047] [ERROR] AttributeError: ‘NoneType’ object has no attribute ‘code’
[2025-01-03 10:58:58.047] [ERROR]
[2025-01-03 10:58:58.047] [DEBUG] - sub bootstrap ref count to 0
[2025-01-03 10:58:58.047] [DEBUG] - export bootstrap
[2025-01-03 10:58:58.047] [DEBUG] - plugin oceanbase-ce-py_script_bootstrap-4.2.2.0 result: False
[2025-01-03 10:58:58.047] [INFO] [ERROR] response parser error: Expecting value: line 1 column 1 (char 0)
[2025-01-03 10:58:58.047] [INFO] [ERROR] oceanbase-ce-py_script_bootstrap-4.2.2.0 RuntimeError: ‘NoneType’ object has no attribute ‘code’
[2025-01-03 10:58:58.047] [INFO]
[2025-01-03 10:58:58.047] [ERROR] Cluster init failed
[2025-01-03 10:58:58.051] [INFO] See https://www.oceanbase.com/product/ob-deployer/error-codes .
[2025-01-03 10:58:58.051] [INFO] Trace ID: 79c2f5a8-c97e-11ef-94b1-bc24114b410f
[2025-01-03 10:58:58.051] [INFO] If you want to view detailed obd logs, please run: obd display-trace 79c2f5a8-c97e-11ef-94b1-bc24114b410f
[2025-01-03 10:58:58.052] [DEBUG] - unlock /home/osys/.obd/lock/global
[2025-01-03 10:58:58.052] [DEBUG] - unlock /home/osys/.obd/lock/deploy_cnfnms_ob
[2025-01-03 10:58:58.052] [DEBUG] - unlock /home/osys/.obd/lock/mirror_and_repo
看log是connect.py出错了
.obd/plugins/oceanbase-ce/4.2.2.0/connect.py", line 381, in request
[2025-01-03 10:58:58.047] [ERROR] return self._request(method, url, data, headers, params, ignore_ConnectionError=ignore_ConnectionError, *args, **kwargs)
[2025-01-03 10:58:58.047] [ERROR] File “/home/opesys/.obd/plugins/oceanbase-ce/4.2.2.0/connect.py”, line 335, in _request
[2025-01-03 10:58:58.047] [ERROR] if parsed_resp.code != 200:
[2025-01-03 10:58:58.047] [ERROR] AttributeError: ‘NoneType’ object has no attribute ‘code’
把local_ip改成ip
一开始就是ip,今天改成local_ip,报错都是一样的
参考这种写法
server1:
·······
local_ip:
把你的global中这些删除