扩容内存，显示连接失败

OceanBase 技术问题
#1

Connect to observer -
Connect to observer x
[ERROR] OBD-1006: Failed to connect to oceanbase-ce
[ERROR] OBD-1005: Some of the servers in the cluster have been stopped
See https://www.oceanbase.com/product/ob-deployer/error-codes .
Trace ID: dedd4f22-e85c-11ef-b67e-fa163ed9e4ed

[ERROR] Traceback (most recent call last):
[2025-02-11 17:50:10.763] [ERROR] File “core.py”, line 2532, in reload_cluster
[2025-02-11 17:50:10.763] [ERROR] File “core.py”, line 2572, in _reload_cluster
[2025-02-11 17:50:10.763] [ERROR] File “core.py”, line 2158, in _start_cluster
[2025-02-11 17:50:10.763] [ERROR] File “core.py”, line 197, in call_plugin
[2025-02-11 17:50:10.763] [ERROR] File “_plugin.py”, line 347, in call
[2025-02-11 17:50:10.763] [ERROR] File “_plugin.py”, line 305, in _new_func
[2025-02-11 17:50:10.763] [ERROR] File “/root/.obd/plugins/oceanbase-ce/4.2.2.0/connect.py”, line 625, in connect
[2025-02-11 17:50:10.763] [ERROR] cursor = Cursor(ip=server.ip, port=server_config[‘mysql_port’], tenant=’’, password=password if password is not None else ‘’, stdio=stdio)
[2025-02-11 17:50:10.763] [ERROR] File “_stdio.py”, line 908, in wrapper
[2025-02-11 17:50:10.763] [ERROR] File “/root/.obd/plugins/oceanbase-ce/4.2.2.0/connect.py”, line 517, in init
[2025-02-11 17:50:10.763] [ERROR] self._connect()
[2025-02-11 17:50:10.763] [ERROR] File “/root/.obd/plugins/oceanbase-ce/4.2.2.0/connect.py”, line 547, in _connect
[2025-02-11 17:50:10.763] [ERROR] self.db = mysql.connect(host=self.ip, user=self.user, port=int(self.port), password=str(self.password),
[2025-02-11 17:50:10.763] [ERROR] File “pymysql/connections.py”, line 353, in init
[2025-02-11 17:50:10.763] [ERROR] File “pymysql/connections.py”, line 633, in connect
[2025-02-11 17:50:10.763] [ERROR] File “pymysql/connections.py”, line 907, in _request_authentication
[2025-02-11 17:50:10.763] [ERROR] File “pymysql/connections.py”, line 725, in _read_packet
[2025-02-11 17:50:10.763] [ERROR] File “pymysql/protocol.py”, line 221, in raise_for_error
[2025-02-11 17:50:10.763] [ERROR] File “pymysql/err.py”, line 143, in raise_mysql_exception
[2025-02-11 17:50:10.763] [ERROR] pymysql.err.OperationalError: (1045, “Access denied for user ‘root’@‘xxx.xxx.xxx.xxx’ (using password: NO)”)
[2025-02-11 17:50:10.764] [ERROR]
[2025-02-11 17:50:13.842] [ERROR] OBD-1006: Failed to connect to oceanbase-ce
[2025-02-11 17:50:13.842] [DEBUG] – sub connect ref count to 0
[2025-02-11 17:50:13.842] [DEBUG] – export connect
[2025-02-11 17:50:13.843] [ERROR] OBD-1005: Some of the servers in the cluster have been stopped

通过修改配置文件obd cluster edit-config 修改内存后reload，显示连接失败，但是obclient可以连接，有哪个大佬遇到过吗？

#4

是不是黑屏化改过数据库密码 并未在obd修改

#5

如果有，怎么解决？

#6

学了一段时间的oceanbase,感觉越来越像是半成品一样.

#7

多实际使用 有的搭建是非标准搭建 对ob不了解 就开始使用了 要么环境问题 要么是自己部署的问题 也有些非标操作 造成的问题 不过有的也是ob自身的问题 建议多了解 多使用 目前ob有很多的大客户在使用 ob参与在很多的项目中 是经过检验的产品 不过ob有些功能也在逐渐的优化中 ob也在逐渐的成长 也离不开你们对ob的支持与使用 如果使用过程中遇到问题 欢迎发帖交流

2 个赞
#8

你好，
obd cluster edit-config 看下配置文件里是否是修改后的密码
obd cluster display 看下集群状态

#9

先将密码改回与obd一致再使用obd进行修改密码即可

#10

您好，我在执行edit-config后里面没写，密码没有写，怎么处理？
oceanbase-ce:
servers:

  • 127.0.0.1
    global:
    home_path: /home/lsp/oceanbase/oceanbase-ce
    cluster_id: 1715948688
    enable_syslog_recycle: true
    enable_syslog_wf: false
    max_syslog_file_count: 4
    memory_limit: 6144M
    production_mode: false
    __min_full_resource_pool_memory: 1073741824
    system_memory: 1024M
    cpu_count: 16
    datafile_size: 2048M
    datafile_maxsize: 8192M
    datafile_next: 2048M
    log_disk_size: 14336M
#11

您好，我在执行edit-config后里面没写，密码没有写，怎么处理？
oceanbase-ce:
servers:

  • 127.0.0.1
    global:
    home_path: /home/lsp/oceanbase/oceanbase-ce
    cluster_id: 1715948688
    enable_syslog_recycle: true
    enable_syslog_wf: false
    max_syslog_file_count: 4
    memory_limit: 6144M
    production_mode: false
    __min_full_resource_pool_memory: 1073741824
    system_memory: 1024M
    cpu_count: 16
    datafile_size: 2048M
    datafile_maxsize: 8192M
    datafile_next: 2048M
    log_disk_size: 14336M

display是stopped的状态，但是obclient是正常连接的

#12

你这是很久前部署的demo集群了吧？添加个root_password:参数在yaml文件中

#13

reload后还是不行，[ERROR] Traceback (most recent call last):
[2025-02-12 11:43:30.729] [ERROR] File “core.py”, line 2532, in reload_cluster
[2025-02-12 11:43:30.729] [ERROR] File “core.py”, line 2572, in _reload_cluster
[2025-02-12 11:43:30.729] [ERROR] File “core.py”, line 2158, in _start_cluster
[2025-02-12 11:43:30.729] [ERROR] File “core.py”, line 197, in call_plugin
[2025-02-12 11:43:30.729] [ERROR] File “_plugin.py”, line 347, in call
[2025-02-12 11:43:30.729] [ERROR] File “_plugin.py”, line 305, in _new_func
[2025-02-12 11:43:30.729] [ERROR] File “/root/.obd/plugins/oceanbase-ce/4.2.2.0/connect.py”, line 625, in connect
[2025-02-12 11:43:30.729] [ERROR] cursor = Cursor(ip=server.ip, port=server_config[‘mysql_port’], tenant=’’, password=password if password is not None else ‘’, stdio=stdio)
[2025-02-12 11:43:30.729] [ERROR] File “_stdio.py”, line 908, in wrapper
[2025-02-12 11:43:30.730] [ERROR] File “/root/.obd/plugins/oceanbase-ce/4.2.2.0/connect.py”, line 517, in init
[2025-02-12 11:43:30.730] [ERROR] self._connect()
[2025-02-12 11:43:30.730] [ERROR] File “/root/.obd/plugins/oceanbase-ce/4.2.2.0/connect.py”, line 547, in _connect
[2025-02-12 11:43:30.730] [ERROR] self.db = mysql.connect(host=self.ip, user=self.user, port=int(self.port), password=str(self.password),
[2025-02-12 11:43:30.730] [ERROR] File “pymysql/connections.py”, line 353, in init
[2025-02-12 11:43:30.730] [ERROR] File “pymysql/connections.py”, line 633, in connect
[2025-02-12 11:43:30.730] [ERROR] File “pymysql/connections.py”, line 907, in _request_authentication
[2025-02-12 11:43:30.730] [ERROR] File “pymysql/connections.py”, line 725, in _read_packet
[2025-02-12 11:43:30.730] [ERROR] File “pymysql/protocol.py”, line 221, in raise_for_error
[2025-02-12 11:43:30.730] [ERROR] File “pymysql/err.py”, line 143, in raise_mysql_exception
[2025-02-12 11:43:30.730] [ERROR] pymysql.err.OperationalError: (1045, “Access denied for user ‘root’@‘xxx.xxx.xxx.xxx’ (using password: NO)”)
[2025-02-12 11:43:30.730] [ERROR]
[2025-02-12 11:43:33.832] [ERROR] OBD-1006: Failed to connect to oceanbase-ce
[2025-02-12 11:43:33.832] [DEBUG] – sub connect ref count to 0
[2025-02-12 11:43:33.832] [DEBUG] – export connect
[2025-02-12 11:43:33.832] [ERROR] OBD-1005: Some of the servers in the cluster have been stopped
[2025-02-12 11:43:33.834] [INFO] See https://www.oceanbase.com/product/ob-deployer/error-codes .
[2025-02-12 11:43:33.834] [INFO] Trace ID: d03800fc-e8f2-11ef-b134-fa163ed9e4ed
[2025-02-12 11:43:33.834] [INFO] If you want to view detailed obd logs, please run: obd display-trace d03800fc-e8f2-11ef-b134-fa163ed9e4ed
[2025-02-12 11:43:33.834] [DEBUG] - share lock /root/.obd/lock/mirror_and_repo release, count 2
[2025-02-12 11:43:33.834] [DEBUG] - share lock /root/.obd/lock/mirror_and_repo release, count 1
[2025-02-12 11:43:33.835] [DEBUG] - share lock /root/.obd/lock/mirror_and_repo release, count 0
[2025-02-12 11:43:33.835] [DEBUG] - unlock /root/.obd/lock/mirror_and_repo
[2025-02-12 11:43:33.835] [DEBUG] - exclusive lock /root/.obd/lock/deploy_demo release, count 0
[2025-02-12 11:43:33.835] [DEBUG] - unlock /root/.obd/lock/deploy_demo
[2025-02-12 11:43:33.835] [DEBUG] - share lock /root/.obd/lock/global release, count 0
[2025-02-12 11:43:33.835] [DEBUG] - unlock /root/.obd/lock/global

#14

[2025-02-12 11:43:30.727306] WDIAG [SHARE.SCHEMA] check_user_access (ob_schema_getter_guard.cpp:2645) [3091589][T1_MysqlQueueTh][T1][Y0-00062D70963FAEA2-0-0] [lt=21][errcode=-4043] password error(ret=-4043, ret=“OB_PASSWORD_WRONG”, login_info.passwd_.length()=0, user_info->get_passwd_str().length()=41)

日志过滤passwd

#15

需要直接使用vi进行修改的xxxx.yaml文件。麻烦发一下你的yaml文件看看，还有.data文件。
他们都在 ~/.obd/cluster/<deploy_name>/

#16

.data:
[root@LSP2 demo]# cat .data
name: demo
components:
obagent:
hash: 8a5c3b8c55defe409d1e72b7efd13c5e41549545
version: 4.2.2
oceanbase-ce:
hash: e25abee1b1c478be79d88713e49852bafc205f06
version: 4.3.0.1
obproxy-ce:
hash: cab6154cd013719765c938795d773b9c247bd653
version: 4.2.3.0
status: STATUS_STOPPED
config_status: NEED_RELOAD

oceanbase-ce:
servers:

  • 127.0.0.1
    global:
    home_path: /home/lsp/oceanbase/oceanbase-ce
    cluster_id: 1715948688
    enable_syslog_recycle: true
    enable_syslog_wf: false
    max_syslog_file_count: 4
    memory_limit: 6144M
    production_mode: false
    __min_full_resource_pool_memory: 1073741824
    system_memory: 10G
    cpu_count: 16
    datafile_size: 2048M
    datafile_maxsize: 8192M
    datafile_next: 2048M
    log_disk_size: 14336M
    root_password: xxxx

密码也加了

#17

接下来怎么操作？直接reload吗？

#18

确保yaml文件的密码和你当前数据库root密码一致
.data文件vi修改
status: STATUS_RUNNING
config_status: UNCHANGE

#19

改了，然后呢

#20

集群应该正常了吧？

#21

正常了，十分感谢

#22

还想请教一个问题，这个数据库用段时间就挂了，是内存不够导致的吗？之前是默认的6G，我改成了12G有用吗，还是其他原因，有什么解决的办法没？