oceanbase 社区版安装报错MySQL error: Error 4012 (HY000)

单机服务器环境
数据库版本 4.3.5.4
通过界面安装部署,只修改了数据路径跟日志路径,其他的按最小可用默认安装
预检查全通过,剩余空间900G,空闲内存也有20+G
最后部署失败,前面dubug都没有报错
日志提示
[2025-11-10 16:01:14.496] [INFO] obshell bootstrap
[2025-11-10 16:18:09.202] [ERROR] Traceback (most recent call last):
[2025-11-10 16:18:09.202] [ERROR] File “concurrent/futures/thread.py”, line 57, in run
[2025-11-10 16:18:09.202] [ERROR] File “service/handler/deployment_handler.py”, line 540, in _do_install
[2025-11-10 16:18:09.202] [ERROR] File “core.py”, line 2348, in _start_cluster
[2025-11-10 16:18:09.202] [ERROR] File “core.py”, line 256, in run_workflow
[2025-11-10 16:18:09.202] [ERROR] File “core.py”, line 298, in run_plugin_template
[2025-11-10 16:18:09.202] [ERROR] File “core.py”, line 347, in call_plugin
[2025-11-10 16:18:09.202] [ERROR] File “_plugin.py”, line 348, in call
[2025-11-10 16:18:09.202] [ERROR] File “_plugin.py”, line 304, in _new_func
[2025-11-10 16:18:09.202] [ERROR] File “/root/.obd/plugins/oceanbase-ce/4.2.1.4/obshell_bootstrap.py”, line 54, in obshell_bootstrap
[2025-11-10 16:18:09.202] [ERROR] client.v1.wait_dag_succeed(dag.generic_id)
[2025-11-10 16:18:09.202] [ERROR] File “/usr/obd/lib/site-packages/obshell/service/client_v1.py”, line 1110, in wait_dag_succeed
[2025-11-10 16:18:09.202] [ERROR] raise TaskExecuteFailedError(f"{logs}", dag)
[2025-11-10 16:18:09.202] [ERROR] obshell.service.client_v1.TaskExecuteFailedError: Task ‘Take over’ execution failed: 10.21.32.200:12886 ERROR: [MySQL.Error]: MySQL error: Error 4012 (HY000): Timeout, query has reached the maximum query timeout: 1000000000(us), maybe you can adjust the session variable ob_query_timeout or query_timeout hint, and try again.
[2025-11-10 16:18:09.202] [ERROR]
[2025-11-10 16:18:09.202] [ERROR]
[2025-11-10 16:18:09.203] [ERROR] [ERROR] obshell bootstrap failed: Task ‘Take over’ execution failed: 10.21.32.200:12886 ERROR: [MySQL.Error]: MySQL error: Error 4012 (HY000): Timeout, query has reached the maximum query timeout: 1000000000(us), maybe you can adjust the session variable ob_query_timeout or query_timeout hint, and try again.
[2025-11-10 16:18:09.203] [ERROR]
[2025-11-10 16:18:09.203] [DEBUG] - sub obshell_bootstrap ref count to 0
[2025-11-10 16:18:09.203] [DEBUG] - export obshell_bootstrap
[2025-11-10 16:18:09.203] [DEBUG] - plugin oceanbase-ce-py_script_obshell_bootstrap-4.2.1.4 result: False

1 个赞

obshell bootstrap failed: Task ‘Take over’这个报错 可以试试扩容一下内存配置参数为12G。

1 个赞

是改proxy_mem_limited 改成12G吗

修改memory_limit=12G

麻烦提供一份obshell日志 看看obshell版本是多少,最新版432已修复该bug
~/xxx/oceanbase/shell/log下

在log_obshell/daemon.log 下有看到版本current obshell version is 4.3.1.0-12025070719,memory_limit改成12G重新安装还是一样的报错

还是同一个报错么麻烦提供一份yaml参数文件,再扩容到15G试试 :joy:
~/.obd/cluster/xxx

user:
username: root
password:
port: 22
oceanbase-ce:
version: 4.3.5.4
release: 104000042025090916.el7
package_hash: a30a15dd7a80f6acd0f113993bb70b2e56d40f80
10.21.32.200:
zone: zone1
servers:

  • 10.21.32.200
    global:
    appname: northeast2
    root_password: Maxkwh@2025
    mysql_port: 2881
    rpc_port: 2882
    data_dir: /mnt/maxkwh/dbdata/data
    redo_dir: /mnt/maxkwh/dbdata/log
    obshell_port: 9886
    home_path: /mnt/maxkwh/northeast2/oceanbase
    scenario: htap
    cluster_id: 1762767713
    proxyro_password: lBONb0mFz7
    enable_syslog_wf: false
    max_syslog_file_count: 16
    production_mode: false
    memory_limit: 6G
    datafile_size: 2G
    system_memory: 1G
    log_disk_size: 14G
    cpu_count: 38
    __min_full_resource_pool_memory: 1073741824
    datafile_maxsize: 8G
    datafile_next: 2G
    obproxy-ce:
    version: 4.3.5.0
    package_hash: f17b277b681adb1c86bfc3cfda369ad88896da9d
    release: 3.el7
    servers:
  • 10.21.32.200
    global:
    prometheus_listen_port: 2884
    listen_port: 2883
    rpc_listen_port: 2885
    home_path: /mnt/maxkwh/northeast2/obproxy
    obproxy_sys_password: =?iY2h4]XH2A|]JbHZscVt
    skip_proxy_sys_private_check: true
    enable_strict_kernel_release: false
    enable_cluster_checkout: false
    proxy_mem_limited: 500M
    10.21.32.200:
    proxy_id: 4774
    client_session_id_version: 2
    depends:
  • oceanbase-ce
    密码我删了


配置页面写了15G,config.yaml出来的memory_limit还是会变成6G

内存调整

直接vi修改yaml文件然后deploy部署即可