ob启动集群失败

OceanBase 技术问题
#1

image
image749×230 9.23 KB

1 个赞
#2

看一下配置文件

1 个赞
#3

image
image1178×480 38.2 KB

1 个赞
#4

你好 请查看

1 个赞
#5

[2022-11-17 17:43:23.913] [345a1de8-665c-11ed-aed2-70fd45d07aa5] [DEBUG] – connect 127.0.0.1 -P2881 -uroot -p
[2022-11-17 17:43:23.914] [345a1de8-665c-11ed-aed2-70fd45d07aa5] [ERROR] Traceback (most recent call last):
[2022-11-17 17:43:23.914] [345a1de8-665c-11ed-aed2-70fd45d07aa5] [ERROR] File “core.py”, line 1446, in start_cluster
[2022-11-17 17:43:23.914] [345a1de8-665c-11ed-aed2-70fd45d07aa5] [ERROR] File “core.py”, line 1541, in _start_cluster
[2022-11-17 17:43:23.915] [345a1de8-665c-11ed-aed2-70fd45d07aa5] [ERROR] File “_plugin.py”, line 242, in call
[2022-11-17 17:43:23.915] [345a1de8-665c-11ed-aed2-70fd45d07aa5] [ERROR] File “_plugin.py”, line 216, in _new_func
[2022-11-17 17:43:23.915] [345a1de8-665c-11ed-aed2-70fd45d07aa5] [ERROR] File “/root/.obd/plugins/oceanbase-ce/3.1.0/connect.py”, line 65, in connect
[2022-11-17 17:43:23.915] [345a1de8-665c-11ed-aed2-70fd45d07aa5] [ERROR] db, cursor = _connect(server.ip, server_config[‘mysql_port’], password if password is not None else ‘’)
[2022-11-17 17:43:23.915] [345a1de8-665c-11ed-aed2-70fd45d07aa5] [ERROR] File “/root/.obd/plugins/oceanbase-ce/3.1.0/connect.py”, line 42, in _connect
[2022-11-17 17:43:23.915] [345a1de8-665c-11ed-aed2-70fd45d07aa5] [ERROR] db = mysql.connect(host=ip, user=user, port=int(port), password=str(password), cursorclass=mysql.cursors.DictCursor)
[2022-11-17 17:43:23.915] [345a1de8-665c-11ed-aed2-70fd45d07aa5] [ERROR] File “/root/.oceanbase-all-in-one/obd/usr/obd/lib/site-packages/pymysql/connections.py”, line 353, in init
[2022-11-17 17:43:23.915] [345a1de8-665c-11ed-aed2-70fd45d07aa5] [ERROR] self.connect()
[2022-11-17 17:43:23.915] [345a1de8-665c-11ed-aed2-70fd45d07aa5] [ERROR] File “/root/.oceanbase-all-in-one/obd/usr/obd/lib/site-packages/pymysql/connections.py”, line 633, in connect
[2022-11-17 17:43:23.915] [345a1de8-665c-11ed-aed2-70fd45d07aa5] [ERROR] self._request_authentication()
[2022-11-17 17:43:23.915] [345a1de8-665c-11ed-aed2-70fd45d07aa5] [ERROR] File “/root/.oceanbase-all-in-one/obd/usr/obd/lib/site-packages/pymysql/connections.py”, line 907, in _request_authentication
[2022-11-17 17:43:23.915] [345a1de8-665c-11ed-aed2-70fd45d07aa5] [ERROR] auth_packet = self._read_packet()
[2022-11-17 17:43:23.915] [345a1de8-665c-11ed-aed2-70fd45d07aa5] [ERROR] File “/root/.oceanbase-all-in-one/obd/usr/obd/lib/site-packages/pymysql/connections.py”, line 725, in _read_packet
[2022-11-17 17:43:23.915] [345a1de8-665c-11ed-aed2-70fd45d07aa5] [ERROR] packet.raise_for_error()
[2022-11-17 17:43:23.915] [345a1de8-665c-11ed-aed2-70fd45d07aa5] [ERROR] File “/root/.oceanbase-all-in-one/obd/usr/obd/lib/site-packages/pymysql/protocol.py”, line 221, in raise_for_error
[2022-11-17 17:43:23.915] [345a1de8-665c-11ed-aed2-70fd45d07aa5] [ERROR] err.raise_mysql_exception(self._data)
[2022-11-17 17:43:23.915] [345a1de8-665c-11ed-aed2-70fd45d07aa5] [ERROR] File “/root/.oceanbase-all-in-one/obd/usr/obd/lib/site-packages/pymysql/err.py”, line 143, in raise_mysql_exception
[2022-11-17 17:43:23.916] [345a1de8-665c-11ed-aed2-70fd45d07aa5] [ERROR] raise errorclass(errno, errval)
[2022-11-17 17:43:23.916] [345a1de8-665c-11ed-aed2-70fd45d07aa5] [ERROR] pymysql.err.OperationalError: (5150, ‘Tenant not in this server’)
[2022-11-17 17:43:23.916] [345a1de8-665c-11ed-aed2-70fd45d07aa5] [ERROR]
[2022-11-17 17:43:26.932] [345a1de8-665c-11ed-aed2-70fd45d07aa5] [ERROR] [ERROR] OBD-1006: Failed to connect to oceanbase-ce
[2022-11-17 17:43:26.932] [345a1de8-665c-11ed-aed2-70fd45d07aa5] [DEBUG] - sub connect ref count to 0
[2022-11-17 17:43:26.932] [345a1de8-665c-11ed-aed2-70fd45d07aa5] [DEBUG] - export connect
[2022-11-17 17:43:26.933] [345a1de8-665c-11ed-aed2-70fd45d07aa5] [INFO] See https://www.oceanbase.com/product/ob-deployer/error-codes .
[2022-11-17 17:43:26.933] [345a1de8-665c-11ed-aed2-70fd45d07aa5] [DEBUG] - share lock /root/.obd/lock/mirror_and_repo release, count 0
[2022-11-17 17:43:26.933] [345a1de8-665c-11ed-aed2-70fd45d07aa5] [DEBUG] - unlock /root/.obd/lock/mirror_and_repo
[2022-11-17 17:43:26.933] [345a1de8-665c-11ed-aed2-70fd45d07aa5] [DEBUG] - exclusive lock /root/.obd/lock/deploy_lo release, count 0
[2022-11-17 17:43:26.933] [345a1de8-665c-11ed-aed2-70fd45d07aa5] [DEBUG] - unlock /root/.obd/lock/deploy_lo
[2022-11-17 17:43:26.933] [345a1de8-665c-11ed-aed2-70fd45d07aa5] [DEBUG] - share lock /root/.obd/lock/global release, count 0
[2022-11-17 17:43:26.933] [345a1de8-665c-11ed-aed2-70fd45d07aa5] [DEBUG] - unlock /root/.obd/lock/global

#6

看着observer是起来了的，ob进程有没有，能不能登上ob？
有进程的话有没有连接失败的日志啊，看看日志

#7

已回复。。。。

#8

image

#9

image
image1746×926 175 KB

这两个密码有设置吗，设置的话需要设置成一致的
obproxy_sys_password:
observer_sys_password

#10

没设置，这两个在哪里设置

#11

image
image1015×475 32.7 KB

按照这个装的啊

#12

你好 ，没找到设置这两个密码的地方啊

#13

没设置的话不用设置了，我也不知道原因了

#15

怎么删除掉了

#16
  1. 你配置文件中root_password就是设置sys租户中root的密码
  2. 配置文件中memory_limit和system_memory的值设置的不对，会导致ob异常，在memory_limit大于64G时，可以分配30%给system_memory
    memory_limit -OceanBase 数据库-OceanBase文档中心-分布式数据库使用文档
    系统内部内存管理-OceanBase 数据库-OceanBase文档中心-分布式数据库使用文档

建议修改配置文件后，重新部署启动