ubantu部署ob-mysql报错，求大佬解决

[AntTech_QXCNDP]

ubantu部署ob-mysql(oceanbase-all-in-one-4.2.3.0-100000112024042411.el7.x86_64.tar.gz)报错

[ERROR] OBD-1007: (127.0.0.1) The value of the ulimit parameter “max user processes” must not be less than 120000 (Current value: 62864), Please execute echo -e "* soft nproc 120000\n* hard nproc 120000" >> /etc/security/limits.d/nproc.conf as root in 127.0.0.1. if it dosen’t work, please check whether UsePAM is yes in /etc/ssh/sshd_config.

[旭辉]

麻烦发下obd日志，默认保存在安装obd的用户home路径： cd ~/.obd/log/

[AntTech_QXCNDP]

obd.zip (159.9 KB)
麻烦您过目，我用的操作系统是ubantu18.04.6，x86的

[辞霜]

Please execute echo -e "* soft nproc 120000\n* hard nproc 120000" >> /etc/security/limits.d/nproc.conf
报错有提供方法解决，看一眼你的/etc/security/limits.d/nproc.conf文件中nproc设置多少
修改为

• soft nproc 120000
• hard nproc 120000

[AntTech_QXCNDP]

这个我也发现了，ubantu这个不知道是不是我改坏了，修够后一直不生效，又安装了一个centos的操作系统，修改过后新增窗口就可以了

[AntTech_QXCNDP]

您好ob-mysql怎么重启呢

[AntTech_QXCNDP]

我重启服务器后，使用obd cluster lis显示运行中，但是查不到进程，也不知如何重启，使用obclient -h127.0.0.1 -uroot -P2881 -p也不能登录

[辞霜]

obd cluster restart xxx

[AntTech_QXCNDP]

上面的问题麻烦也帮忙解答下呢
obd cluster restart xxx (xxx是obd cluster lis命令查出来的名字吗)

[AntTech_QXCNDP]

麻烦问下为什么一直卡在这里呢

[AntTech_QXCNDP]

执行后报错这个了，

[辞霜]

执行下这个看看详细报错。

[AntTech_QXCNDP]

没有啥报错吧，主要是这个我重启了服务器，这个ob查看状态一直显示running

[AntTech_QXCNDP]

刚刚是
pidof observer
pidof obproxy
ps -ef|grep oceanbase
这几个命令都查不到，现在pidof observer 能查到了，但是pidof obproxy还是查不到

[辞霜]

那是因为重启机器前，未使用obd关闭demo导致
你发一下你执行启动集群报错的详细日志

[AntTech_QXCNDP]

报错这个
[2024-10-31 14:19:37.617] [ERROR] Traceback (most recent call last):
[2024-10-31 14:19:37.618] [ERROR] File “core.py”, line 2058, in start_cluster
[2024-10-31 14:19:37.618] [ERROR] File “core.py”, line 2158, in _start_cluster
[2024-10-31 14:19:37.618] [ERROR] File “core.py”, line 197, in call_plugin
[2024-10-31 14:19:37.618] [ERROR] File “_plugin.py”, line 347, in call
[2024-10-31 14:19:37.618] [ERROR] File “_plugin.py”, line 305, in _new_func
[2024-10-31 14:19:37.618] [ERROR] File “/root/.obd/plugins/oceanbase-ce/4.2.2.0/connect.py”, line 625, in connect
[2024-10-31 14:19:37.618] [ERROR] cursor = Cursor(ip=server.ip, port=server_config[‘mysql_port’], tenant=’’, password=password if password is not None else ‘’, stdio=stdio)
[2024-10-31 14:19:37.618] [ERROR] File “_stdio.py”, line 908, in wrapper
[2024-10-31 14:19:37.619] [ERROR] File “/root/.obd/plugins/oceanbase-ce/4.2.2.0/connect.py”, line 517, in init
[2024-10-31 14:19:37.619] [ERROR] self._connect()
[2024-10-31 14:19:37.619] [ERROR] File “/root/.obd/plugins/oceanbase-ce/4.2.2.0/connect.py”, line 547, in _connect
[2024-10-31 14:19:37.619] [ERROR] self.db = mysql.connect(host=self.ip, user=self.user, port=int(self.port), password=str(self.password),
[2024-10-31 14:19:37.619] [ERROR] File “pymysql/connections.py”, line 353, in init
[2024-10-31 14:19:37.619] [ERROR] File “pymysql/connections.py”, line 633, in connect
[2024-10-31 14:19:37.619] [ERROR] File “pymysql/connections.py”, line 907, in _request_authentication
[2024-10-31 14:19:37.619] [ERROR] File “pymysql/connections.py”, line 725, in _read_packet
[2024-10-31 14:19:37.620] [ERROR] File “pymysql/protocol.py”, line 221, in raise_for_error
[2024-10-31 14:19:37.620] [ERROR] File “pymysql/err.py”, line 143, in raise_mysql_exception
[2024-10-31 14:19:37.620] [ERROR] pymysql.err.OperationalError: (1045, “Access denied for user ‘root’@‘xxx.xxx.xxx.xxx’ (using password: NO)”)
[2024-10-31 14:19:37.620] [ERROR]
[2024-10-31 14:19:40.682] [ERROR] OBD-1006: Failed to connect to oceanbase-ce

[辞霜]

单独启动一下
obd cluster start -c oceanbase-ce

[AntTech_QXCNDP]

[辞霜]

start 后边带上你的集群名称呀

[AntTech_QXCNDP]

也是一样的报错哎