启动集群时报Failed to connect oceanbase-ce

【产品名称】

【产品版本】

【问题描述】

[root@localhost log]# obd cluster start ob_cluster

Get local repositories and plugins ok

Open ssh connection ok

Load cluster param plugin ok

Check before start observer ok

[WARN] (127.0.0.1) The recommended value of fs.aio-max-nr is 1048576 (Current value: 65536)

Start observer ok

observer program health check ok

Connect to observer x

[ERROR] Failed to connect oceanbase-ce

See OceanBase 社区.

这个卡半天,一直提示连不上详情的日志提示如下:

[2022-04-15 13:46:07.064] [475d7a7a-bc7f-11ec-a7f5-000c29a5c85d] [ERROR]

[2022-04-15 13:46:10.065] [475d7a7a-bc7f-11ec-a7f5-000c29a5c85d] [DEBUG] – connect 127.0.0.1 -P2883 -uroot -p

[2022-04-15 13:46:10.069] [475d7a7a-bc7f-11ec-a7f5-000c29a5c85d] [ERROR] Traceback (most recent call last):

[2022-04-15 13:46:10.069] [475d7a7a-bc7f-11ec-a7f5-000c29a5c85d] [ERROR] File “/usr/obd/lib/site-packages/pymysql/connections.py”, line 614, in connect

[2022-04-15 13:46:10.069] [475d7a7a-bc7f-11ec-a7f5-000c29a5c85d] [ERROR] (self.host, self.port), self.connect_timeout, **kwargs

[2022-04-15 13:46:10.070] [475d7a7a-bc7f-11ec-a7f5-000c29a5c85d] [ERROR] File “socket.py”, line 724, in create_connection

[2022-04-15 13:46:10.070] [475d7a7a-bc7f-11ec-a7f5-000c29a5c85d] [ERROR] File “socket.py”, line 713, in create_connection

[2022-04-15 13:46:10.070] [475d7a7a-bc7f-11ec-a7f5-000c29a5c85d] [ERROR] ConnectionRefusedError: [Errno 111] Connection refused

[2022-04-15 13:46:10.070] [475d7a7a-bc7f-11ec-a7f5-000c29a5c85d] [ERROR]

[2022-04-15 13:46:10.071] [475d7a7a-bc7f-11ec-a7f5-000c29a5c85d] [ERROR] During handling of the above exception, another exception occurred:

[2022-04-15 13:46:10.071] [475d7a7a-bc7f-11ec-a7f5-000c29a5c85d] [ERROR]

[2022-04-15 13:46:10.071] [475d7a7a-bc7f-11ec-a7f5-000c29a5c85d] [ERROR] Traceback (most recent call last):

[2022-04-15 13:46:10.071] [475d7a7a-bc7f-11ec-a7f5-000c29a5c85d] [ERROR] File “core.py”, line 1237, in start_cluster

[2022-04-15 13:46:10.071] [475d7a7a-bc7f-11ec-a7f5-000c29a5c85d] [ERROR] File “_plugin.py”, line 235, in __call__

[2022-04-15 13:46:10.072] [475d7a7a-bc7f-11ec-a7f5-000c29a5c85d] [ERROR] File “_plugin.py”, line 209, in _new_func

[2022-04-15 13:46:10.072] [475d7a7a-bc7f-11ec-a7f5-000c29a5c85d] [ERROR] File “/root/.obd/plugins/oceanbase-ce/3.1.0/connect.py”, line 64, in connect

[2022-04-15 13:46:10.072] [475d7a7a-bc7f-11ec-a7f5-000c29a5c85d] [ERROR] db, cursor = _connect(server.ip, server_config[‘mysql_port’], password if password is not None else ‘’)

[2022-04-15 13:46:10.072] [475d7a7a-bc7f-11ec-a7f5-000c29a5c85d] [ERROR] File “/root/.obd/plugins/oceanbase-ce/3.1.0/connect.py”, line 41, in _connect

[2022-04-15 13:46:10.072] [475d7a7a-bc7f-11ec-a7f5-000c29a5c85d] [ERROR] db = mysql.connect(host=ip, user=user, port=int(port), password=str(password), cursorclass=mysql.cursors.DictCursor)

[2022-04-15 13:46:10.073] [475d7a7a-bc7f-11ec-a7f5-000c29a5c85d] [ERROR] File “/usr/obd/lib/site-packages/pymysql/connections.py”, line 353, in __init__

[2022-04-15 13:46:10.073] [475d7a7a-bc7f-11ec-a7f5-000c29a5c85d] [ERROR] self.connect()

[2022-04-15 13:46:10.073] [475d7a7a-bc7f-11ec-a7f5-000c29a5c85d] [ERROR] File “/usr/obd/lib/site-packages/pymysql/connections.py”, line 664, in connect

[2022-04-15 13:46:10.073] [475d7a7a-bc7f-11ec-a7f5-000c29a5c85d] [ERROR] raise exc

[2022-04-15 13:46:10.073] [475d7a7a-bc7f-11ec-a7f5-000c29a5c85d] [ERROR] pymysql.err.OperationalError: (2003, “Can’t connect to MySQL server on ‘127.0.0.1’ ([Errno 111] Connection refused)”)

[2022-04-15 13:46:10.074] [475d7a7a-bc7f-11ec-a7f5-000c29a5c85d] [ERROR]

麻烦提供一下卡住的期间对应的observer.log日志附件。

直接去看日志,onserver.log,第一个error级别的日志,向下看

麻烦提供一下卡住的期间对应的observer.log日志附件。



没有observer的日志解决不了的

看一下observer.log的找到error一条条记录往下理就可以了