Ubuntu虚拟机部署OceanBase 4.6.0成功，但任何SQL查询都超时或连接丢失

[AntTech_5GYOQQ]

问题描述：

在 Ubuntu 22.04 虚拟机（VMware）上，使用 oceanbase-all-in-one-4.6.0_20260715.el7.x86_64.tar.gz 安装包，通过 obd cluster deploy -i 交互式方式成功部署了 OceanBase 集群 myoceanbase 。部署过程顺利，所有组件（包括 OBD、OBClient、OBAgent、Prometheus、Grafana）均显示为 running 状态。

核心问题：
集群启动后，使用 obclient 连接到 sys 租户或业务租户 obmysql 后，任何 SQL 查询（包括 SELECT VERSION(); 、SHOW DATABASES; 甚至设置超时的 SET 命令）都会遇到以下两种错误之一 ：

1. ERROR 4012 (HY000): Timeout, query has reached the maximum query timeout: 10000000(us)...
2. ERROR 2013 (HY000): Lost connection to MySQL server during query

调整会话超时 (SET ob_query_timeout = 300000000; ) 后，执行该 SET 命令本身也可能立即报错 ERROR 2013 。

**环境信息：

• 操作系统 ：Ubuntu 22.04.5 LTS (内核 5.15.0-185-generic)
• CPU ：8核 (Intel Xeon)
• 内存 ：虚拟机分配 16GB，free -h 显示可用 (available) 约 3.6GB
• 磁盘 ：机械硬盘 (HDD)（不是SSD类型磁盘） ，根目录 / 扩展后总容量 156GB，可用 101GB，使用率 33%
• OceanBase 版本 ：4.6.0.0
• 部署方式 ：obd cluster deploy -i 交互式部署，memory_limit 设为 7G（官方文档好像是8G)

已尝试的排查步骤：

1. 检查集群状态：obd cluster display myoceanbase 显示所有组件 status: ACTIVE 且 running 。
2. 检查磁盘空间：df -h / 显示可用空间充足 (101GB)。
3. 检查系统资源：free -h 显示可用内存约 3.6GB。
4. 调整超时：在 obclient 中尝试 SET ob_query_timeout = 300000000; ，该命令本身可能超时或连接丢失。
5. 重启集群：执行 obd cluster restart myoceanbase 后问题依旧。一直链接不上。
   
   

问题：

1. 为什么集群状态正常，却无法执行任何 SQL 查询？
2. 这是否与使用机械硬盘 (HDD) 有关？如果是，是否有任何针对 HDD 的配置优化可以尝试？
3. 是否有其他需要检查的日志或系统参数？
   4.不知道磁盘类型是否是无法连接/导致超时最大的影响因素

[淇铭]

把启动时候的obd.log observer.log 都发一下 看看具体的问题

[AntTech_BKPSAR]

期待解答

[AntTech_5GYOQQ]

obd.log (2.1 MB)

[AntTech_5GYOQQ]

我第一次是采用的yaml的方式部署，集群名称为obtext
第二次采用的是交互式部署，集群名称是myoceanbase

[内蒙古小草]

坚持！

[淇铭]

obd display-trace 16d0a3c4-8a1f-11f1-bb54-000c296051f7 在取一下日志信息

ob的启动时候的日志observer.log文件发一下

[AntTech_5GYOQQ]

observer.rar (4.4 MB)

[AntTech_5GYOQQ]

admin@dotmess:~$ obd display-trace 16d0a3c4-8a1f-11f1-bb54-000c296051f7
[2026-07-28 00:55:55.659] [DEBUG] - cmd: [‘obtest’]
[2026-07-28 00:55:55.659] [DEBUG] - opts: {‘encryption_passkey’: ******}
[2026-07-28 00:55:55.659] [DEBUG] - mkdir /home/admin/.obd/lock/
[2026-07-28 00:55:55.659] [DEBUG] - unknown lock mode
[2026-07-28 00:55:55.659] [DEBUG] - try to get share lock /home/admin/.obd/lock/global
[2026-07-28 00:55:55.659] [DEBUG] - share lock /home/admin/.obd/lock/global, count 1
[2026-07-28 00:55:55.659] [DEBUG] - Get Deploy by name
[2026-07-28 00:55:55.659] [DEBUG] - mkdir /home/admin/.obd/cluster/
[2026-07-28 00:55:55.659] [DEBUG] - mkdir /home/admin/.obd/config_parser/
[2026-07-28 00:55:55.660] [DEBUG] - try to get exclusive lock /home/admin/.obd/lock/deploy_obtest
[2026-07-28 00:55:55.660] [DEBUG] - exclusive lock /home/admin/.obd/lock/deploy_obtest, count 1
[2026-07-28 00:55:55.661] [DEBUG] - Deploy status judge
[2026-07-28 00:55:55.661] [DEBUG] - Get deploy config
[2026-07-28 00:55:55.665] [INFO] Get local repositories and plugins
[2026-07-28 00:55:55.666] [DEBUG] - mkdir /home/admin/.obd/repository
[2026-07-28 00:55:55.666] [DEBUG] - Get local repository oceanbase-ce-4.6.0.0-4289d018e7333ef556b95d23df0a73bea76c0e27
[2026-07-28 00:55:55.666] [DEBUG] - try to get share lock /home/admin/.obd/lock/mirror_and_repo
[2026-07-28 00:55:55.666] [DEBUG] - share lock /home/admin/.obd/lock/mirror_and_repo, count 1
[2026-07-28 00:55:55.667] [DEBUG] - Searching param plugin for components …
[2026-07-28 00:55:55.667] [DEBUG] - Search param plugin for oceanbase-ce
[2026-07-28 00:55:55.667] [DEBUG] - mkdir /home/admin/.obd/plugins
[2026-07-28 00:55:55.668] [DEBUG] - Found for oceanbase-ce-param-4.6.0.0 for oceanbase-ce-4.6.0.0
[2026-07-28 00:55:55.668] [DEBUG] - Applying oceanbase-ce-param-4.6.0.0 for oceanbase-ce-4.6.0.0-100000162026071511.el7-4 289d018e7333ef556b95d23df0a73bea76c0e27
[2026-07-28 00:55:55.951] [INFO] Open ssh connection
[2026-07-28 00:55:56.085] [DEBUG] - Searching display template for components …
[2026-07-28 00:55:56.085] [DEBUG] - mkdir /home/admin/.obd/workflows
[2026-07-28 00:55:56.086] [DEBUG] - Call workflow oceanbase-ce-py_script_workflow_display-4.2.1.4 for oceanbase-ce-4.6.0. 0-100000162026071511.el7-4289d018e7333ef556b95d23df0a73bea76c0e27
[2026-07-28 00:55:56.087] [DEBUG] - mkdir /home/admin/.obd/mirror
[2026-07-28 00:55:56.087] [DEBUG] - mkdir /home/admin/.obd/mirror/remote
[2026-07-28 00:55:56.087] [DEBUG] - mkdir /home/admin/.obd/mirror/local
[2026-07-28 00:55:56.087] [DEBUG] - mkdir /home/admin/.obd/optimize/
[2026-07-28 00:55:56.088] [DEBUG] - mkdir /home/admin/.obd/tool/
[2026-07-28 00:55:56.088] [DEBUG] - import display
[2026-07-28 00:55:56.088] [DEBUG] - add display ref count to 1
[2026-07-28 00:55:56.089] [DEBUG] - sub display ref count to 0
[2026-07-28 00:55:56.089] [DEBUG] - export display
[2026-07-28 00:55:56.089] [DEBUG] - plugin oceanbase-ce-py_script_workflow_display-4.2.1.4 result: True
[2026-07-28 00:55:56.089] [DEBUG] - Found for oceanbase-ce-py_script_workflow_display-4.2.1.4 for oceanbase-ce-4.2.1.4
[2026-07-28 00:55:56.089] [DEBUG] - share lock /home/admin/.obd/lock/mirror_and_repo, count 2
[2026-07-28 00:55:56.090] [DEBUG] - Searching status plugin for components …
[2026-07-28 00:55:56.090] [DEBUG] - Searching status plugin for oceanbase-ce-4.6.0.0-100000162026071511.el7-4289d018e7333 ef556b95d23df0a73bea76c0e27
[2026-07-28 00:55:56.090] [DEBUG] - Found for oceanbase-ce-py_script_status-3.1.0 for oceanbase-ce-4.6.0.0
[2026-07-28 00:55:56.090] [DEBUG] - Call plugin oceanbase-ce-py_script_status-3.1.0 for oceanbase-ce-4.6.0.0-100000162026 071511.el7-4289d018e7333ef556b95d23df0a73bea76c0e27
[2026-07-28 00:55:56.090] [DEBUG] - import status
[2026-07-28 00:55:56.091] [DEBUG] - add status ref count to 1
[2026-07-28 00:55:56.091] [DEBUG] – local execute: cat /home/admin/oceanbase/run/observer.pid
[2026-07-28 00:55:56.094] [DEBUG] – exited code 0
[2026-07-28 00:55:56.094] [DEBUG] – local execute: ls /proc/5927
[2026-07-28 00:55:56.097] [DEBUG] – exited code 0
[2026-07-28 00:55:56.097] [DEBUG] - sub status ref count to 0
[2026-07-28 00:55:56.097] [DEBUG] - export status
[2026-07-28 00:55:56.097] [DEBUG] - plugin oceanbase-ce-py_script_status-3.1.0 result: True
[2026-07-28 00:55:56.097] [DEBUG] - Searching status_check plugin for components …
[2026-07-28 00:55:56.097] [DEBUG] - Searching status_check plugin for general-4.6.0.0–None
[2026-07-28 00:55:56.098] [DEBUG] - Found for general-py_script_status_check-0.1 for general-4.6.0.0
[2026-07-28 00:55:56.098] [DEBUG] - Call plugin general-py_script_status_check-0.1 for oceanbase-ce-4.6.0.0-1000001620260 71511.el7-4289d018e7333ef556b95d23df0a73bea76c0e27
[2026-07-28 00:55:56.098] [DEBUG] - import status_check
[2026-07-28 00:55:56.099] [DEBUG] - add status_check ref count to 1
[2026-07-28 00:55:56.099] [DEBUG] - sub status_check ref count to 0
[2026-07-28 00:55:56.099] [DEBUG] - export status_check
[2026-07-28 00:55:56.099] [DEBUG] - plugin general-py_script_status_check-0.1 result: True
[2026-07-28 00:55:56.099] [DEBUG] - Searching connect plugin for components …
[2026-07-28 00:55:56.099] [DEBUG] - Searching connect plugin for oceanbase-ce-4.6.0.0-100000162026071511.el7-4289d018e733 3ef556b95d23df0a73bea76c0e27
[2026-07-28 00:55:56.100] [DEBUG] - Found for oceanbase-ce-py_script_connect-3.1.0 for oceanbase-ce-4.6.0.0
[2026-07-28 00:55:56.100] [DEBUG] - Call plugin oceanbase-ce-py_script_connect-3.1.0 for oceanbase-ce-4.6.0.0-10000016202 6071511.el7-4289d018e7333ef556b95d23df0a73bea76c0e27
[2026-07-28 00:55:56.100] [DEBUG] - import connect
[2026-07-28 00:55:56.100] [DEBUG] - add connect ref count to 1
[2026-07-28 00:55:56.101] [INFO] Connect to observer
[2026-07-28 00:55:56.101] [DEBUG] – mysql connect 127.0.0.1 -P2881 -uroot -p
[2026-07-28 00:55:56.104] [DEBUG] – mysql execute sql: select 1. args: None
[2026-07-28 00:55:56.105] [DEBUG] – OBD-5000: select 1 execute failed
[2026-07-28 00:55:59.106] [DEBUG] – mysql connect 127.0.0.1 -P2881 -uroot -p
[2026-07-28 00:55:59.107] [DEBUG] – mysql execute sql: select 1. args: None
[2026-07-28 00:55:59.108] [DEBUG] – OBD-5000: select 1 execute failed
[2026-07-28 00:56:02.124] [DEBUG] – mysql connect 127.0.0.1 -P2881 -uroot -p
[2026-07-28 00:56:02.126] [DEBUG] – mysql execute sql: select 1. args: None
[2026-07-28 00:56:02.128] [DEBUG] – OBD-5000: select 1 execute failed
[2026-07-28 00:56:05.129] [DEBUG] – mysql connect 127.0.0.1 -P2881 -uroot -p
[2026-07-28 00:56:05.132] [DEBUG] – mysql execute sql: select 1. args: None
[2026-07-28 00:56:05.133] [DEBUG] – OBD-5000: select 1 execute failed
[2026-07-28 00:56:08.134] [DEBUG] – mysql connect 127.0.0.1 -P2881 -uroot -p
[2026-07-28 00:56:08.136] [DEBUG] – mysql execute sql: select 1. args: None
[2026-07-28 00:56:08.137] [DEBUG] – OBD-5000: select 1 execute failed
[2026-07-28 00:56:11.137] [DEBUG] – mysql connect 127.0.0.1 -P2881 -uroot -p
[2026-07-28 00:56:11.163] [DEBUG] – mysql execute sql: select 1. args: None
[2026-07-28 00:56:11.164] [DEBUG] – OBD-5000: select 1 execute failed
[2026-07-28 00:56:14.165] [DEBUG] – mysql connect 127.0.0.1 -P2881 -uroot -p
[2026-07-28 00:56:14.169] [DEBUG] – mysql execute sql: select 1. args: None
[2026-07-28 00:56:14.171] [DEBUG] – OBD-5000: select 1 execute failed
[2026-07-28 00:56:17.171] [DEBUG] – mysql connect 127.0.0.1 -P2881 -uroot -p
[2026-07-28 00:56:17.173] [DEBUG] – mysql execute sql: select 1. args: None
[2026-07-28 00:56:17.174] [DEBUG] – OBD-5000: select 1 execute failed
[2026-07-28 00:56:20.174] [DEBUG] – mysql connect 127.0.0.1 -P2881 -uroot -p
[2026-07-28 00:56:20.176] [DEBUG] – mysql execute sql: select 1. args: None
[2026-07-28 00:56:20.177] [DEBUG] – OBD-5000: select 1 execute failed
[2026-07-28 00:56:23.177] [DEBUG] – mysql connect 127.0.0.1 -P2881 -uroot -p
[2026-07-28 00:56:23.179] [DEBUG] – mysql execute sql: select 1. args: None
[2026-07-28 00:56:23.181] [DEBUG] – OBD-5000: select 1 execute failed
[2026-07-28 00:56:26.182] [DEBUG] – mysql connect 127.0.0.1 -P2881 -uroot -p
[2026-07-28 00:56:26.185] [DEBUG] – mysql execute sql: select 1. args: None
[2026-07-28 00:56:26.189] [DEBUG] – OBD-5000: select 1 execute failed
[2026-07-28 00:56:29.190] [DEBUG] – mysql connect 127.0.0.1 -P2881 -uroot -p
[2026-07-28 00:56:29.191] [DEBUG] – mysql execute sql: select 1. args: None
[2026-07-28 00:56:29.192] [DEBUG] – OBD-5000: select 1 execute failed
[2026-07-28 00:56:32.192] [DEBUG] – mysql connect 127.0.0.1 -P2881 -uroot -p
[2026-07-28 00:56:32.194] [DEBUG] – mysql execute sql: select 1. args: None
[2026-07-28 00:56:32.195] [DEBUG] – OBD-5000: select 1 execute failed
[2026-07-28 00:56:35.195] [DEBUG] – mysql connect 127.0.0.1 -P2881 -uroot -p
[2026-07-28 00:56:35.197] [DEBUG] – mysql execute sql: select 1. args: None
[2026-07-28 00:56:35.198] [DEBUG] – OBD-5000: select 1 execute failed
[2026-07-28 00:56:38.199] [DEBUG] – mysql connect 127.0.0.1 -P2881 -uroot -p
[2026-07-28 00:56:38.201] [DEBUG] – mysql execute sql: select 1. args: None
[2026-07-28 00:56:38.202] [DEBUG] – OBD-5000: select 1 execute failed
[2026-07-28 00:56:41.203] [DEBUG] – mysql connect 127.0.0.1 -P2881 -uroot -p
[2026-07-28 00:56:41.204] [DEBUG] – mysql execute sql: select 1. args: None
[2026-07-28 00:56:41.205] [DEBUG] – OBD-5000: select 1 execute failed
[2026-07-28 00:56:44.206] [DEBUG] – mysql connect 127.0.0.1 -P2881 -uroot -p
[2026-07-28 00:56:44.207] [DEBUG] – mysql execute sql: select 1. args: None
[2026-07-28 00:56:44.208] [DEBUG] – OBD-5000: select 1 execute failed
[2026-07-28 00:56:47.209] [DEBUG] – mysql connect 127.0.0.1 -P2881 -uroot -p
[2026-07-28 00:56:47.212] [DEBUG] – mysql execute sql: select 1. args: None
[2026-07-28 00:56:47.213] [DEBUG] – OBD-5000: select 1 execute failed
[2026-07-28 00:56:50.214] [DEBUG] – mysql connect 127.0.0.1 -P2881 -uroot -p
[2026-07-28 00:56:50.218] [DEBUG] – mysql execute sql: select 1. args: None
[2026-07-28 00:56:50.219] [DEBUG] – OBD-5000: select 1 execute failed
[2026-07-28 00:56:53.220] [DEBUG] – mysql connect 127.0.0.1 -P2881 -uroot -p
[2026-07-28 00:56:53.221] [DEBUG] – mysql execute sql: select 1. args: None
[2026-07-28 00:56:53.222] [DEBUG] – OBD-5000: select 1 execute failed
[2026-07-28 00:56:56.222] [DEBUG] – mysql connect 127.0.0.1 -P2881 -uroot -p
[2026-07-28 00:56:56.224] [DEBUG] – mysql execute sql: select 1. args: None
[2026-07-28 00:56:56.225] [DEBUG] – OBD-5000: select 1 execute failed
[2026-07-28 00:56:59.225] [DEBUG] – mysql connect 127.0.0.1 -P2881 -uroot -p
[2026-07-28 00:56:59.227] [DEBUG] – mysql execute sql: select 1. args: None
[2026-07-28 00:56:59.227] [DEBUG] – OBD-5000: select 1 execute failed
[2026-07-28 00:57:02.209] [DEBUG] – mysql connect 127.0.0.1 -P2881 -uroot -p
[2026-07-28 00:57:02.213] [DEBUG] – mysql execute sql: select 1. args: None
[2026-07-28 00:57:02.215] [DEBUG] – OBD-5000: select 1 execute failed
[2026-07-28 00:57:05.215] [DEBUG] – mysql connect 127.0.0.1 -P2881 -uroot -p
[2026-07-28 00:57:05.217] [DEBUG] – mysql execute sql: select 1. args: None
[2026-07-28 00:57:05.219] [DEBUG] – OBD-5000: select 1 execute failed
[2026-07-28 00:57:08.219] [DEBUG] – mysql connect 127.0.0.1 -P2881 -uroot -p
[2026-07-28 00:57:08.221] [DEBUG] – mysql execute sql: select 1. args: None
[2026-07-28 00:57:08.222] [DEBUG] – OBD-5000: select 1 execute failed
[2026-07-28 00:57:11.223] [DEBUG] – mysql connect 127.0.0.1 -P2881 -uroot -p
[2026-07-28 00:57:11.225] [DEBUG] – mysql execute sql: select 1. args: None
[2026-07-28 00:57:11.227] [DEBUG] – OBD-5000: select 1 execute failed
[2026-07-28 00:57:14.228] [DEBUG] – mysql connect 127.0.0.1 -P2881 -uroot -p
[2026-07-28 00:57:14.230] [DEBUG] – mysql execute sql: select 1. args: None
[2026-07-28 00:57:14.231] [DEBUG] – OBD-5000: select 1 execute failed
[2026-07-28 00:57:17.232] [DEBUG] – mysql connect 127.0.0.1 -P2881 -uroot -p
[2026-07-28 00:57:17.238] [DEBUG] – mysql execute sql: select 1. args: None
[2026-07-28 00:57:17.241] [DEBUG] – OBD-5000: select 1 execute failed
[2026-07-28 00:57:20.242] [DEBUG] – mysql connect 127.0.0.1 -P2881 -uroot -p
[2026-07-28 00:57:20.243] [DEBUG] – mysql execute sql: select 1. args: None
[2026-07-28 00:57:20.245] [DEBUG] – OBD-5000: select 1 execute failed
[2026-07-28 00:57:23.246] [DEBUG] – mysql connect 127.0.0.1 -P2881 -uroot -p
[2026-07-28 00:57:23.249] [DEBUG] – mysql execute sql: select 1. args: None
[2026-07-28 00:57:23.251] [DEBUG] – OBD-5000: select 1 execute failed
[2026-07-28 00:57:26.252] [DEBUG] – mysql connect 127.0.0.1 -P2881 -uroot -p
[2026-07-28 00:57:26.253] [DEBUG] – mysql execute sql: select 1. args: None
[2026-07-28 00:57:26.254] [DEBUG] – OBD-5000: select 1 execute failed
[2026-07-28 00:57:29.255] [DEBUG] – mysql connect 127.0.0.1 -P2881 -uroot -p
[2026-07-28 00:57:29.256] [DEBUG] – mysql execute sql: select 1. args: None
[2026-07-28 00:57:29.257] [DEBUG] – OBD-5000: select 1 execute failed
[2026-07-28 00:57:32.258] [DEBUG] – mysql connect 127.0.0.1 -P2881 -uroot -p
[2026-07-28 00:57:32.259] [DEBUG] – mysql execute sql: select 1. args: None
[2026-07-28 00:57:32.260] [DEBUG] – OBD-5000: select 1 execute failed
[2026-07-28 00:57:35.261] [DEBUG] – mysql connect 127.0.0.1 -P2881 -uroot -p
[2026-07-28 00:57:35.263] [DEBUG] – mysql execute sql: select 1. args: None
[2026-07-28 00:57:35.266] [DEBUG] – OBD-5000: select 1 execute failed
[2026-07-28 00:57:38.267] [DEBUG] – mysql connect 127.0.0.1 -P2881 -uroot -p
[2026-07-28 00:57:38.268] [DEBUG] – mysql execute sql: select 1. args: None
[2026-07-28 00:57:38.269] [DEBUG] – OBD-5000: select 1 execute failed
[2026-07-28 00:57:41.270] [DEBUG] – mysql connect 127.0.0.1 -P2881 -uroot -p
[2026-07-28 00:57:41.271] [DEBUG] – mysql execute sql: select 1. args: None
[2026-07-28 00:57:41.272] [DEBUG] – OBD-5000: select 1 execute failed
[2026-07-28 00:57:44.273] [DEBUG] – mysql connect 127.0.0.1 -P2881 -uroot -p
[2026-07-28 00:57:44.274] [DEBUG] – mysql execute sql: select 1. args: None
[2026-07-28 00:57:44.275] [DEBUG] – OBD-5000: select 1 execute failed
[2026-07-28 00:57:47.276] [DEBUG] – mysql connect 127.0.0.1 -P2881 -uroot -p
[2026-07-28 00:57:47.278] [DEBUG] – mysql execute sql: select 1. args: None
[2026-07-28 00:57:47.278] [DEBUG] – OBD-5000: select 1 execute failed
[2026-07-28 00:57:50.279] [DEBUG] – mysql connect 127.0.0.1 -P2881 -uroot -p
[2026-07-28 00:57:50.281] [DEBUG] – mysql execute sql: select 1. args: None
[2026-07-28 00:57:50.283] [DEBUG] – OBD-5000: select 1 execute failed
[2026-07-28 00:57:53.284] [DEBUG] – mysql connect 127.0.0.1 -P2881 -uroot -p
[2026-07-28 00:57:53.285] [DEBUG] – mysql execute sql: select 1. args: None
[2026-07-28 00:57:53.286] [DEBUG] – OBD-5000: select 1 execute failed
[2026-07-28 00:57:56.287] [DEBUG] – mysql connect 127.0.0.1 -P2881 -uroot -p
[2026-07-28 00:57:56.288] [DEBUG] – mysql execute sql: select 1. args: None
[2026-07-28 00:57:56.289] [DEBUG] – OBD-5000: select 1 execute failed
[2026-07-28 00:57:59.290] [DEBUG] – mysql connect 127.0.0.1 -P2881 -uroot -p
[2026-07-28 00:57:59.291] [DEBUG] – mysql execute sql: select 1. args: None
[2026-07-28 00:57:59.291] [DEBUG] – OBD-5000: select 1 execute failed
[2026-07-28 00:58:02.297] [DEBUG] – mysql connect 127.0.0.1 -P2881 -uroot -p
[2026-07-28 00:58:02.299] [DEBUG] – mysql execute sql: select 1. args: None
[2026-07-28 00:58:02.300] [DEBUG] – OBD-5000: select 1 execute failed
[2026-07-28 00:58:05.300] [DEBUG] – mysql connect 127.0.0.1 -P2881 -uroot -p
[2026-07-28 00:58:05.302] [DEBUG] – mysql execute sql: select 1. args: None
[2026-07-28 00:58:05.304] [DEBUG] – OBD-5000: select 1 execute failed
[2026-07-28 00:58:08.305] [DEBUG] – mysql connect 127.0.0.1 -P2881 -uroot -p
[2026-07-28 00:58:08.306] [DEBUG] – mysql execute sql: select 1. args: None
[2026-07-28 00:58:08.308] [DEBUG] – OBD-5000: select 1 execute failed
[2026-07-28 00:58:11.309] [DEBUG] – mysql connect 127.0.0.1 -P2881 -uroot -p
[2026-07-28 00:58:11.311] [DEBUG] – mysql execute sql: select 1. args: None
[2026-07-28 00:58:11.311] [DEBUG] – OBD-5000: select 1 execute failed
[2026-07-28 00:58:14.312] [DEBUG] – mysql connect 127.0.0.1 -P2881 -uroot -p
[2026-07-28 00:58:14.313] [DEBUG] – mysql execute sql: select 1. args: None
[2026-07-28 00:58:14.314] [DEBUG] – OBD-5000: select 1 execute failed
[2026-07-28 00:58:17.316] [DEBUG] – mysql connect 127.0.0.1 -P2881 -uroot -p
[2026-07-28 00:58:17.320] [DEBUG] – mysql execute sql: select 1. args: None
[2026-07-28 00:58:17.323] [DEBUG] – OBD-5000: select 1 execute failed
[2026-07-28 00:58:20.323] [DEBUG] – mysql connect 127.0.0.1 -P2881 -uroot -p
[2026-07-28 00:58:20.325] [DEBUG] – mysql execute sql: select 1. args: None
[2026-07-28 00:58:20.326] [DEBUG] – OBD-5000: select 1 execute failed
[2026-07-28 00:58:23.326] [DEBUG] – mysql connect 127.0.0.1 -P2881 -uroot -p
[2026-07-28 00:58:23.328] [DEBUG] – mysql execute sql: select 1. args: None
[2026-07-28 00:58:23.328] [DEBUG] – OBD-5000: select 1 execute failed
[2026-07-28 00:58:26.329] [DEBUG] – mysql connect 127.0.0.1 -P2881 -uroot -p
[2026-07-28 00:58:26.330] [DEBUG] – mysql execute sql: select 1. args: None
[2026-07-28 00:58:26.332] [DEBUG] – OBD-5000: select 1 execute failed
[2026-07-28 00:58:29.332] [DEBUG] – mysql connect 127.0.0.1 -P2881 -uroot -p
[2026-07-28 00:58:29.333] [DEBUG] – mysql execute sql: select 1. args: None
[2026-07-28 00:58:29.336] [DEBUG] – OBD-5000: select 1 execute failed
[2026-07-28 00:58:32.337] [DEBUG] – mysql connect 127.0.0.1 -P2881 -uroot -p
[2026-07-28 00:58:32.339] [DEBUG] – mysql execute sql: select 1. args: None
[2026-07-28 00:58:32.341] [DEBUG] – OBD-5000: select 1 execute failed
[2026-07-28 00:58:35.342] [DEBUG] – mysql connect 127.0.0.1 -P2881 -uroot -p
[2026-07-28 00:58:35.343] [DEBUG] – mysql execute sql: select 1. args: None
[2026-07-28 00:58:35.344] [DEBUG] – OBD-5000: select 1 execute failed
[2026-07-28 00:58:38.345] [DEBUG] – mysql connect 127.0.0.1 -P2881 -uroot -p
[2026-07-28 00:58:38.347] [DEBUG] – mysql execute sql: select 1. args: None
[2026-07-28 00:58:38.348] [DEBUG] – OBD-5000: select 1 execute failed
[2026-07-28 00:58:41.348] [DEBUG] – mysql connect 127.0.0.1 -P2881 -uroot -p
[2026-07-28 00:58:41.350] [DEBUG] – mysql execute sql: select 1. args: None
[2026-07-28 00:58:41.354] [DEBUG] – OBD-5000: select 1 execute failed
[2026-07-28 00:58:44.355] [DEBUG] – mysql connect 127.0.0.1 -P2881 -uroot -p
[2026-07-28 00:58:44.356] [DEBUG] – mysql execute sql: select 1. args: None
[2026-07-28 00:58:44.357] [DEBUG] – OBD-5000: select 1 execute failed
[2026-07-28 00:58:47.358] [DEBUG] – mysql connect 127.0.0.1 -P2881 -uroot -p
[2026-07-28 00:58:47.360] [DEBUG] – mysql execute sql: select 1. args: None
[2026-07-28 00:58:47.361] [DEBUG] – OBD-5000: select 1 execute failed
[2026-07-28 00:58:50.362] [DEBUG] – mysql connect 127.0.0.1 -P2881 -uroot -p
[2026-07-28 00:58:50.363] [DEBUG] – mysql execute sql: select 1. args: None
[2026-07-28 00:58:50.364] [DEBUG] – OBD-5000: select 1 execute failed
[2026-07-28 00:58:53.365] [DEBUG] – mysql connect 127.0.0.1 -P2881 -uroot -p
[2026-07-28 00:58:53.369] [DEBUG] – mysql execute sql: select 1. args: None
[2026-07-28 00:58:53.372] [DEBUG] – OBD-5000: select 1 execute failed
[2026-07-28 00:58:56.372] [DEBUG] – mysql connect 127.0.0.1 -P2881 -uroot -p
[2026-07-28 00:58:56.375] [DEBUG] – mysql execute sql: select 1. args: None
[2026-07-28 00:58:56.376] [DEBUG] – OBD-5000: select 1 execute failed
[2026-07-28 00:58:59.377] [DEBUG] – mysql connect 127.0.0.1 -P2881 -uroot -p
[2026-07-28 00:58:59.378] [DEBUG] – mysql execute sql: select 1. args: None
[2026-07-28 00:58:59.379] [DEBUG] – OBD-5000: select 1 execute failed
[2026-07-28 00:59:02.396] [DEBUG] – mysql connect 127.0.0.1 -P2881 -uroot -p
[2026-07-28 00:59:02.397] [DEBUG] – mysql execute sql: select 1. args: None
[2026-07-28 00:59:02.399] [DEBUG] – OBD-5000: select 1 execute failed
[2026-07-28 00:59:05.399] [DEBUG] – mysql connect 127.0.0.1 -P2881 -uroot -p
[2026-07-28 00:59:05.401] [DEBUG] – mysql execute sql: select 1. args: None
[2026-07-28 00:59:05.403] [DEBUG] – OBD-5000: select 1 execute failed
[2026-07-28 00:59:08.403] [DEBUG] – mysql connect 127.0.0.1 -P2881 -uroot -p
[2026-07-28 00:59:08.406] [DEBUG] – mysql execute sql: select 1. args: None
[2026-07-28 00:59:08.407] [DEBUG] – OBD-5000: select 1 execute failed
[2026-07-28 00:59:11.408] [DEBUG] – mysql connect 127.0.0.1 -P2881 -uroot -p
[2026-07-28 00:59:11.409] [DEBUG] – mysql execute sql: select 1. args: None
[2026-07-28 00:59:11.410] [DEBUG] – OBD-5000: select 1 execute failed
[2026-07-28 00:59:14.411] [DEBUG] – mysql connect 127.0.0.1 -P2881 -uroot -p
[2026-07-28 00:59:14.412] [DEBUG] – mysql execute sql: select 1. args: None
[2026-07-28 00:59:14.413] [DEBUG] – OBD-5000: select 1 execute failed
[2026-07-28 00:59:17.413] [DEBUG] – mysql connect 127.0.0.1 -P2881 -uroot -p
[2026-07-28 00:59:17.415] [DEBUG] – mysql execute sql: select 1. args: None
[2026-07-28 00:59:17.416] [DEBUG] – OBD-5000: select 1 execute failed
[2026-07-28 00:59:20.417] [DEBUG] – mysql connect 127.0.0.1 -P2881 -uroot -p
[2026-07-28 00:59:20.419] [DEBUG] – mysql execute sql: select 1. args: None
[2026-07-28 00:59:20.422] [DEBUG] – OBD-5000: select 1 execute failed
[2026-07-28 00:59:23.422] [DEBUG] – mysql connect 127.0.0.1 -P2881 -uroot -p
[2026-07-28 00:59:23.424] [DEBUG] – mysql execute sql: select 1. args: None
[2026-07-28 00:59:23.425] [DEBUG] – OBD-5000: select 1 execute failed
[2026-07-28 00:59:26.425] [DEBUG] – mysql connect 127.0.0.1 -P2881 -uroot -p
[2026-07-28 00:59:26.427] [DEBUG] – mysql execute sql: select 1. args: None
[2026-07-28 00:59:26.428] [DEBUG] – OBD-5000: select 1 execute failed
[2026-07-28 00:59:29.428] [DEBUG] – mysql connect 127.0.0.1 -P2881 -uroot -p
[2026-07-28 00:59:29.430] [DEBUG] – mysql execute sql: select 1. args: None
[2026-07-28 00:59:29.430] [DEBUG] – OBD-5000: select 1 execute failed
[2026-07-28 00:59:32.431] [DEBUG] – mysql connect 127.0.0.1 -P2881 -uroot -p
[2026-07-28 00:59:32.432] [DEBUG] – mysql execute sql: select 1. args: None
[2026-07-28 00:59:32.433] [DEBUG] – OBD-5000: select 1 execute failed
[2026-07-28 00:59:35.434] [DEBUG] – mysql connect 127.0.0.1 -P2881 -uroot -p
[2026-07-28 00:59:35.436] [DEBUG] – mysql execute sql: select 1. args: None
[2026-07-28 00:59:35.436] [DEBUG] – OBD-5000: select 1 execute failed
[2026-07-28 00:59:38.437] [DEBUG] – mysql connect 127.0.0.1 -P2881 -uroot -p
[2026-07-28 00:59:38.439] [DEBUG] – mysql execute sql: select 1. args: None
[2026-07-28 00:59:38.441] [DEBUG] – OBD-5000: select 1 execute failed
[2026-07-28 00:59:41.442] [DEBUG] – mysql connect 127.0.0.1 -P2881 -uroot -p
[2026-07-28 00:59:41.443] [DEBUG] – mysql execute sql: select 1. args: None
[2026-07-28 00:59:41.444] [DEBUG] – OBD-5000: select 1 execute failed
[2026-07-28 00:59:44.445] [DEBUG] – mysql connect 127.0.0.1 -P2881 -uroot -p
[2026-07-28 00:59:44.446] [DEBUG] – mysql execute sql: select 1. args: None
[2026-07-28 00:59:44.447] [DEBUG] – OBD-5000: select 1 execute failed
[2026-07-28 00:59:47.448] [DEBUG] – mysql connect 127.0.0.1 -P2881 -uroot -p
[2026-07-28 00:59:47.449] [DEBUG] – mysql execute sql: select 1. args: None
[2026-07-28 00:59:47.450] [DEBUG] – OBD-5000: select 1 execute failed
[2026-07-28 00:59:50.450] [DEBUG] – mysql connect 127.0.0.1 -P2881 -uroot -p
[2026-07-28 00:59:50.453] [DEBUG] – mysql execute sql: select 1. args: None
[2026-07-28 00:59:50.457] [DEBUG] – OBD-5000: select 1 execute failed
[2026-07-28 00:59:53.458] [DEBUG] – mysql connect 127.0.0.1 -P2881 -uroot -p
[2026-07-28 00:59:53.459] [DEBUG] – mysql execute sql: select 1. args: None
[2026-07-28 00:59:53.460] [DEBUG] – OBD-5000: select 1 execute failed
[2026-07-28 00:59:56.461] [DEBUG] – mysql connect 127.0.0.1 -P2881 -uroot -p
[2026-07-28 00:59:56.462] [DEBUG] – mysql execute sql: select 1. args: None
[2026-07-28 00:59:56.463] [DEBUG] – OBD-5000: select 1 execute failed
[2026-07-28 00:59:59.464] [DEBUG] – mysql connect 127.0.0.1 -P2881 -uroot -p
[2026-07-28 00:59:59.466] [DEBUG] – mysql execute sql: select 1. args: None
[2026-07-28 00:59:59.466] [DEBUG] – OBD-5000: select 1 execute failed
[2026-07-28 01:00:02.464] [DEBUG] – mysql connect 127.0.0.1 -P2881 -uroot -p
[2026-07-28 01:00:02.465] [DEBUG] – mysql execute sql: select 1. args: None
[2026-07-28 01:00:02.466] [DEBUG] – OBD-5000: select 1 execute failed
[2026-07-28 01:00:05.467] [DEBUG] – mysql connect 127.0.0.1 -P2881 -uroot -p
[2026-07-28 01:00:05.469] [DEBUG] – mysql execute sql: select 1. args: None
[2026-07-28 01:00:05.471] [DEBUG] – OBD-5000: select 1 execute failed
[2026-07-28 01:00:08.473] [DEBUG] – mysql connect 127.0.0.1 -P2881 -uroot -p
[2026-07-28 01:00:08.474] [DEBUG] – mysql execute sql: select 1. args: None
[2026-07-28 01:00:08.475] [DEBUG] – OBD-5000: select 1 execute failed
[2026-07-28 01:00:11.476] [DEBUG] – mysql connect 127.0.0.1 -P2881 -uroot -p
[2026-07-28 01:00:11.478] [DEBUG] – mysql execute sql: select 1. args: None
[2026-07-28 01:00:11.479] [DEBUG] – OBD-5000: select 1 execute failed
[2026-07-28 01:00:14.480] [DEBUG] – mysql connect 127.0.0.1 -P2881 -uroot -p
[2026-07-28 01:00:14.481] [DEBUG] – mysql execute sql: select 1. args: None
[2026-07-28 01:00:14.482] [DEBUG] – OBD-5000: select 1 execute failed
[2026-07-28 01:00:17.484] [DEBUG] – mysql connect 127.0.0.1 -P2881 -uroot -p
[2026-07-28 01:00:17.486] [DEBUG] – mysql execute sql: select 1. args: None
[2026-07-28 01:00:17.488] [DEBUG] – OBD-5000: select 1 execute failed
[2026-07-28 01:00:20.489] [DEBUG] – mysql connect 127.0.0.1 -P2881 -uroot -p
[2026-07-28 01:00:20.491] [DEBUG] – mysql execute sql: select 1. args: None
[2026-07-28 01:00:20.492] [DEBUG] – OBD-5000: select 1 execute failed
[2026-07-28 01:00:23.493] [DEBUG] – mysql connect 127.0.0.1 -P2881 -uroot -p
[2026-07-28 01:00:23.494] [DEBUG] – mysql execute sql: select 1. args: None
[2026-07-28 01:00:23.495] [DEBUG] – OBD-5000: select 1 execute failed
[2026-07-28 01:00:26.495] [DEBUG] – mysql connect 127.0.0.1 -P2881 -uroot -p
[2026-07-28 01:00:26.497] [DEBUG] – mysql execute sql: select 1. args: None
[2026-07-28 01:00:26.498] [DEBUG] – OBD-5000: select 1 execute failed
[2026-07-28 01:00:29.498] [DEBUG] – mysql connect 127.0.0.1 -P2881 -uroot -p
[2026-07-28 01:00:29.500] [DEBUG] – mysql execute sql: select 1. args: None
[2026-07-28 01:00:29.502] [DEBUG] – OBD-5000: select 1 execute failed
[2026-07-28 01:00:32.502] [DEBUG] – mysql connect 127.0.0.1 -P2881 -uroot -p
[2026-07-28 01:00:32.504] [DEBUG] – mysql execute sql: select 1. args: None
[2026-07-28 01:00:32.505] [DEBUG] – OBD-5000: select 1 execute failed
[2026-07-28 01:00:35.506] [DEBUG] – mysql connect 127.0.0.1 -P2881 -uroot -p
[2026-07-28 01:00:35.508] [DEBUG] – mysql execute sql: select 1. args: None
[2026-07-28 01:00:35.508] [DEBUG] – OBD-5000: select 1 execute failed
[2026-07-28 01:00:38.509] [DEBUG] – mysql connect 127.0.0.1 -P2881 -uroot -p
[2026-07-28 01:00:38.511] [DEBUG] – mysql execute sql: select 1. args: None
[2026-07-28 01:00:38.512] [DEBUG] – OBD-5000: select 1 execute failed
[2026-07-28 01:00:41.512] [DEBUG] – mysql connect 127.0.0.1 -P2881 -uroot -p
[2026-07-28 01:00:41.514] [DEBUG] – mysql execute sql: select 1. args: None
[2026-07-28 01:00:41.514] [DEBUG] – OBD-5000: select 1 execute failed
[2026-07-28 01:00:44.515] [DEBUG] – mysql connect 127.0.0.1 -P2881 -uroot -p
[2026-07-28 01:00:44.516] [DEBUG] – mysql execute sql: select 1. args: None
[2026-07-28 01:00:44.517] [DEBUG] – OBD-5000: select 1 execute failed
[2026-07-28 01:00:47.518] [DEBUG] – mysql connect 127.0.0.1 -P2881 -uroot -p
[2026-07-28 01:00:47.520] [DEBUG] – mysql execute sql: select 1. args: None
[2026-07-28 01:00:47.522] [DEBUG] – OBD-5000: select 1 execute failed
[2026-07-28 01:00:50.523] [DEBUG] – mysql connect 127.0.0.1 -P2881 -uroot -p
[2026-07-28 01:00:50.524] [DEBUG] – mysql execute sql: select 1. args: None
[2026-07-28 01:00:50.525] [DEBUG] – OBD-5000: select 1 execute failed
[2026-07-28 01:00:53.526] [DEBUG] – mysql connect 127.0.0.1 -P2881 -uroot -p
[2026-07-28 01:00:53.527] [DEBUG] – mysql execute sql: select 1. args: None
[2026-07-28 01:00:53.528] [DEBUG] – OBD-5000: select 1 execute failed
[2026-07-28 01:00:56.529] [DEBUG] – mysql connect 127.0.0.1 -P2881 -uroot -p
[2026-07-28 01:00:56.531] [DEBUG] – mysql execute sql: select 1. args: None
[2026-07-28 01:00:56.532] [DEBUG] – OBD-5000: select 1 execute failed
[2026-07-28 01:00:59.558] [ERROR] [ERROR] OBD-1006: Failed to connect to oceanbase-ce
[2026-07-28 01:00:59.559] [DEBUG] - sub connect ref count to 0
[2026-07-28 01:00:59.559] [DEBUG] - export connect
[2026-07-28 01:00:59.559] [DEBUG] - plugin oceanbase-ce-py_script_connect-3.1.0 result: False
[2026-07-28 01:00:59.559] [DEBUG] - share lock /home/admin/.obd/lock/mirror_and_repo release, count 1
[2026-07-28 01:00:59.559] [DEBUG] - share lock /home/admin/.obd/lock/mirror_and_repo release, count 0
[2026-07-28 01:00:59.559] [DEBUG] - unlock /home/admin/.obd/lock/mirror_and_repo
[2026-07-28 01:00:59.559] [DEBUG] - exclusive lock /home/admin/.obd/lock/deploy_obtest release, count 0
[2026-07-28 01:00:59.560] [DEBUG] - unlock /home/admin/.obd/lock/deploy_obtest
[2026-07-28 01:00:59.560] [DEBUG] - share lock /home/admin/.obd/lock/global release, count 0
[2026-07-28 01:00:59.560] [DEBUG] - unlock /home/admin/.obd/lock/global
[2026-07-28 01:00:59.560] [INFO] See 错误码及解决方案 - ob-deployer - OceanBase .
[2026-07-28 01:00:59.560] [INFO] Trace ID: 16d0a3c4-8a1f-11f1-bb54-000c296051f7
[2026-07-28 01:00:59.560] [INFO] If you want to view detailed obd logs, please run: obd display-trace 16d0a3c4-8a1f-11f1- bb54-000c296051f7

[wkk2025]

顶一下

[淇铭]

1、 修复环境参数后完全重启
– 内核参数
sudo sysctl -w vm.max_map_count=655360
sudo sysctl -w fs.aio-max-nr=1048576

– ulimit（写入 limits.conf 永久生效）
ulimit -n 655350
ulimit -c unlimited
ulimit -s unlimited

– 停止并清理后重启
obd cluster stop myoceanbase -f
obd cluster start myoceanbase

2、 修复时钟/时区（非常重要）
– 检查时区
timedatectl
date

– 确保时区正确且开启 NTP 同步
sudo timedatectl set-timezone Asia/Shanghai
sudo systemctl enable --now chronyd # 或 ntp

– 确认时间不会跳变
chronyc tracking

3、 确认无多集群端口冲突
ss -lntp | grep 2881
obd cluster list
** 确保 obtest 已停止，仅 myoceanbase 占用 2881

4、 若重启后仍异常，建议重建集群
obd cluster destroy myoceanbase -f
– 修复环境后重新 obd cluster deploy myoceanbase
5、 验证
obclient -h127.0.0.1 -P2881 -uroot@sys -p -Doceanbase -e “select 1;”
obd cluster display myoceanbase

[AntTech_5GYOQQ]

我现在试一下

[AntTech_5GYOQQ]

@淇铭

ulimit -n 655350
ulimit -c unlimited
ulimit -s unlimited

我在停止或者启动的时候一直卡在connect to observer这里，最后报错

[AntTech_5GYOQQ]

[淇铭]

查看一下observer的进程是否在 ps -ef | grep observer

[AntTech_5GYOQQ]

[淇铭]

如果stop无法停止 kill掉进程

[AntTech_5GYOQQ]

[AntTech_8QELKG]

看着是成功了

[AntTech_5GYOQQ]

@淇铭

obd cluster destroy myoceanbase -f

哪里看出来的，我现在又重新部署了，泪目ing