启动数据库后无法连接，报错：8001, 'Server is initializing'

OceanBase 技术问题
#1

【 使用环境 】 测试环境
【 使用版本 】OceanBase_CE 4.2.1.8 (r108000022024072217-3149c25ca2dadbb7707686ad02a1367b1b43e0b5)
【问题描述】启动数据库后无法连接，报错：8001, ‘Server is initializing’
【附件及日志】
[2024-12-30 16:03:40.823] [ERROR] Traceback (most recent call last):
[2024-12-30 16:03:40.823] [ERROR] File “core.py”, line 2065, in start_cluster
[2024-12-30 16:03:40.823] [ERROR] File “core.py”, line 2165, in _start_cluster
[2024-12-30 16:03:40.823] [ERROR] File “core.py”, line 197, in call_plugin
[2024-12-30 16:03:40.823] [ERROR] File “_plugin.py”, line 348, in call
[2024-12-30 16:03:40.823] [ERROR] File “_plugin.py”, line 305, in _new_func
[2024-12-30 16:03:40.823] [ERROR] File “/root/.obd/plugins/oceanbase-ce/4.2.1.4/connect.py”, line 636, in connect
[2024-12-30 16:03:40.824] [ERROR] cursor = Cursor(ip=server.ip, port=server_config[‘mysql_port’], tenant=’’, password=password if password is not None else ‘’, stdio=stdio)
[2024-12-30 16:03:40.824] [ERROR] File “_stdio.py”, line 912, in wrapper
[2024-12-30 16:03:40.824] [ERROR] File “_stdio.py”, line 899, in func_wrapper
[2024-12-30 16:03:40.824] [ERROR] File “/root/.obd/plugins/oceanbase-ce/4.2.1.4/connect.py”, line 528, in init
[2024-12-30 16:03:40.824] [ERROR] self._connect()
[2024-12-30 16:03:40.824] [ERROR] File “/root/.obd/plugins/oceanbase-ce/4.2.1.4/connect.py”, line 558, in _connect
[2024-12-30 16:03:40.824] [ERROR] self.db = mysql.connect(host=self.ip, user=self.user, port=int(self.port), password=str(self.password),
[2024-12-30 16:03:40.824] [ERROR] File “pymysql/connections.py”, line 353, in init
[2024-12-30 16:03:40.824] [ERROR] File “pymysql/connections.py”, line 633, in connect
[2024-12-30 16:03:40.824] [ERROR] File “pymysql/connections.py”, line 907, in _request_authentication
[2024-12-30 16:03:40.824] [ERROR] File “pymysql/connections.py”, line 725, in _read_packet
[2024-12-30 16:03:40.824] [ERROR] File “pymysql/protocol.py”, line 221, in raise_for_error
[2024-12-30 16:03:40.825] [ERROR] File “pymysql/err.py”, line 143, in raise_mysql_exception
[2024-12-30 16:03:40.825] [ERROR] pymysql.err.OperationalError: (8001, ‘Server is initializing’)
[2024-12-30 16:03:40.825] [ERROR]
[2024-12-30 16:03:43.952] [ERROR] OBD-1006: Failed to connect to oceanbase-ce
[2024-12-30 16:03:43.952] [DEBUG] - sub connect ref count to 0
[2024-12-30 16:03:43.952] [DEBUG] - export connect
[2024-12-30 16:03:43.952] [DEBUG] - plugin oceanbase-ce-py_script_connect-4.2.1.4 result: False
[2024-12-30 16:03:43.962] [INFO] See https://www.oceanbase.com/product/ob-deployer/error-codes .
[2024-12-30 16:03:43.963] [INFO] Trace ID: daf8670c-c683-11ef-a02b-005056bd6d4a

2 个赞
#3

obd版本多少，ps -ef| grep observer看一下observer是否起来了？
如果没有 使用obd cluster start -c oceanbase-ce单独拉起ob试试，然后提供一下详细obd日志和observer日志

2 个赞
#4

版本是OceanBase_CE 4.2.1.8 (r108000022024072217-3149c25ca2dadbb7707686ad02a1367b1b43e0b5)

observer是启动的：

image
image1892×77 8.41 KB

以下是 observer trace rootservice 日志：
observer.log.rar (12.9 MB)

2 个赞
#5

observer进程存在说明ob启动正常，你试试黑屏化连接，应该是正常的。

3 个赞
#6

image
image793×45 2.46 KB

一直报在初始化。。

2 个赞
#7

日志显示存在4024报错，你把yaml文件发出来看一下。可能是内存配置有问题

3 个赞
#8

config.rar (972 字节)

2 个赞
#9 
memory_limit: 16G
datafile_size: 20G
system_memory: 2G
log_disk_size: 40G
cpu_count: 16
production_mode: false
datafile_maxsize: 40G
datafile_next: 2G

参数设置的有问题，参考我提供的你修改一下参数重新部署一下

2 个赞
#10

请问更改完配置，使用obd cluster restart myoceanbase 可以吗

1 个赞
#11

需要重新部署，使用redeploy

2 个赞
#12

请问使用redeploy 数据会保留吗

2 个赞
#13

不会保留，你试试带参启动吧。感觉你应该是磁盘空间问题先试试给存储扩容一下看看能不能起来
./bin/observer -o “datafile_size=20G”

1 个赞
#14

请问sys租户和ocp_meta租户的内存大小设置和服务器的内存大小比例应该怎么分配呢

1 个赞
#15

每次看技术文章 受益匪浅

1 个赞
#16

meta集群的 sys和ocp-meta不需要参考自己服务内存大小，需要参考ocp管理多少台集群。
因为ocp会调任务访问所有接管的集群。具体分配根据业务规格即可