【 使用环境 】生产环境
【 OB or 其他组件 】
【 使用版本 】
【问题描述】数据库停止后启动,无法启动
【复现路径】数据库停止后就无法启动了
[2025-01-10 14:35:09.440] [ERROR] Traceback (most recent call last):
[2025-01-10 14:35:09.440] [ERROR] File “core.py”, line 2090, in start_cluster
[2025-01-10 14:35:09.440] [ERROR] File “core.py”, line 2140, in _start_cluster
[2025-01-10 14:35:09.440] [ERROR] File “core.py”, line 228, in run_workflow
[2025-01-10 14:35:09.440] [ERROR] File “core.py”, line 270, in run_plugin_template
[2025-01-10 14:35:09.441] [ERROR] File “core.py”, line 315, in call_plugin
[2025-01-10 14:35:09.441] [ERROR] File “_plugin.py”, line 347, in call
[2025-01-10 14:35:09.441] [ERROR] File “_plugin.py”, line 304, in _new_func
[2025-01-10 14:35:09.441] [ERROR] File “/root/.obd/plugins/oceanbase-ce/3.1.0/connect.py”, line 68, in connect
[2025-01-10 14:35:09.441] [ERROR] cursor = Cursor(ip=server.ip, port=server_config.get(‘mysql_port’, 2881), tenant=’’, password=****** if password is not None else ‘’, stdio=stdio)
[2025-01-10 14:35:09.441] [ERROR] File “_stdio.py”, line 1012, in wrapper
[2025-01-10 14:35:09.441] [ERROR] File “_stdio.py”, line 999, in func_wrapper
[2025-01-10 14:35:09.441] [ERROR] File “tool.py”, line 763, in init
[2025-01-10 14:35:09.441] [ERROR] File “tool.py”, line 793, in _connect
[2025-01-10 14:35:09.441] [ERROR] File “pymysql/connections.py”, line 353, in init
[2025-01-10 14:35:09.441] [ERROR] File “pymysql/connections.py”, line 633, in connect
[2025-01-10 14:35:09.441] [ERROR] File “pymysql/connections.py”, line 907, in _request_authentication
[2025-01-10 14:35:09.441] [ERROR] File “pymysql/connections.py”, line 725, in _read_packet
[2025-01-10 14:35:09.441] [ERROR] File “pymysql/protocol.py”, line 221, in raise_for_error
[2025-01-10 14:35:09.441] [ERROR] File “pymysql/err.py”, line 143, in raise_mysql_exception
[2025-01-10 14:35:09.441] [ERROR] pymysql.err.OperationalError: (8001, ‘Server is initializing’)
[2025-01-10 14:35:09.441] [ERROR]
[2025-01-10 14:35:12.472] [ERROR] OBD-1006: Failed to connect to oceanbase-ce
[2025-01-10 14:35:12.472] [DEBUG] - sub connect ref count to 0
[2025-01-10 14:35:12.472] [DEBUG] - export connect
[2025-01-10 14:35:12.472] [DEBUG] - plugin oceanbase-ce-py_script_connect-3.1.0 result: False
[2025-01-10 14:35:12.477] [DEBUG] - share lock /root/.obd/lock/mirror_and_repo release, count 1
[2025-01-10 14:35:12.478] [DEBUG] - share lock /root/.obd/lock/mirror_and_repo release, count 0
[2025-01-10 14:35:12.478] [DEBUG] - unlock /root/.obd/lock/mirror_and_repo
[2025-01-10 14:35:12.478] [DEBUG] - exclusive lock /root/.obd/lock/deploy_dy_qd release, count 0
[2025-01-10 14:35:12.478] [DEBUG] - unlock /root/.obd/lock/deploy_dy_qd
[2025-01-10 14:35:12.478] [DEBUG] - share lock /root/.obd/lock/global release, count 0
[2025-01-10 14:35:12.478] [DEBUG] - unlock /root/.obd/lock/global
[2025-01-10 14:35:12.478] [INFO] See https://www.oceanbase.com/product/ob-deployer/error-codes .
[2025-01-10 14:35:12.479] [INFO] Trace ID: 53b20284-cf1c-11ef-8993-5254a813e24f
[2025-01-10 14:35:12.479] [INFO] If you want to view detailed obd logs, please run: obd display-trace 53b20284-cf1c-11ef-8993-5254a813e24f
附带版本 obd的详细日志信息
4.35日志是上面那个
[2025-01-10 14:44:29.106] [DEBUG] - Found for oceanbase-ce-py_script_workflow_start-4.2.1.4 for oceanbase-ce-4.2.1.4
[2025-01-10 14:44:29.107] [DEBUG] - Searching configserver_pre plugin for components …
[2025-01-10 14:44:29.107] [DEBUG] - Searching configserver_pre plugin for oceanbase-ce-4.3.5.0-100000202024123117.el7-48b61655aaa13e9b01b722928d1979c76b41937e
[2025-01-10 14:44:29.108] [DEBUG] - Found for oceanbase-ce-py_script_configserver_pre-3.1.0 for oceanbase-ce-4.3.5.0
[2025-01-10 14:44:29.108] [DEBUG] - Call plugin oceanbase-ce-py_script_configserver_pre-3.1.0 for oceanbase-ce-4.3.5.0-100000202024123117.el7-48b61655aaa13e9b01b722928d1979c76b41937e
[2025-01-10 14:44:29.108] [DEBUG] - import configserver_pre
[2025-01-10 14:44:29.109] [DEBUG] - add configserver_pre ref count to 1
[2025-01-10 14:44:29.110] [DEBUG] - sub configserver_pre ref count to 0
[2025-01-10 14:44:29.110] [DEBUG] - export configserver_pre
[2025-01-10 14:44:29.110] [DEBUG] - plugin oceanbase-ce-py_script_configserver_pre-3.1.0 result: True
[2025-01-10 14:44:29.110] [DEBUG] - Searching start_pre plugin for components …
[2025-01-10 14:44:29.110] [DEBUG] - Searching start_pre plugin for oceanbase-ce-4.3.5.0-100000202024123117.el7-48b61655aaa13e9b01b722928d1979c76b41937e
[2025-01-10 14:44:29.111] [DEBUG] - Found for oceanbase-ce-py_script_start_pre-4.3.0.0 for oceanbase-ce-4.3.5.0
[2025-01-10 14:44:29.111] [DEBUG] - Call plugin oceanbase-ce-py_script_start_pre-4.3.0.0 for oceanbase-ce-4.3.5.0-100000202024123117.el7-48b61655aaa13e9b01b722928d1979c76b41937e
[2025-01-10 14:44:29.111] [DEBUG] - import start_pre
[2025-01-10 14:44:29.113] [DEBUG] - add start_pre ref count to 1
[2025-01-10 14:44:29.114] [INFO] cluster scenario: htap
[2025-01-10 14:44:29.115] [DEBUG] – local execute: ls /obdserver/data/clog/tenant_1/
[2025-01-10 14:44:29.121] [DEBUG] – exited code 0
[2025-01-10 14:44:29.121] [DEBUG] – local execute: cat /obdserver/observer/run/observer.pid
[2025-01-10 14:44:29.126] [DEBUG] – exited code 0
[2025-01-10 14:44:29.126] [DEBUG] – local execute: ls /proc/57101
[2025-01-10 14:44:29.131] [DEBUG] – exited code 0
[2025-01-10 14:44:29.132] [DEBUG] - sub start_pre ref count to 0
[2025-01-10 14:44:29.132] [DEBUG] - export start_pre
[2025-01-10 14:44:29.132] [DEBUG] - plugin oceanbase-ce-py_script_start_pre-4.3.0.0 result: True
[2025-01-10 14:44:29.133] [DEBUG] - Searching start plugin for components …
[2025-01-10 14:44:29.133] [DEBUG] - Searching start plugin for oceanbase-ce-4.3.5.0-100000202024123117.el7-48b61655aaa13e9b01b722928d1979c76b41937e
[2025-01-10 14:44:29.134] [DEBUG] - Found for oceanbase-ce-py_script_start-3.1.0 for oceanbase-ce-4.3.5.0
[2025-01-10 14:44:29.134] [DEBUG] - Call plugin oceanbase-ce-py_script_start-3.1.0 for oceanbase-ce-4.3.5.0-100000202024123117.el7-48b61655aaa13e9b01b722928d1979c76b41937e
[2025-01-10 14:44:29.134] [DEBUG] - import start
[2025-01-10 14:44:29.135] [DEBUG] - add start ref count to 1
[2025-01-10 14:44:29.136] [INFO] Start observer
[2025-01-10 14:44:29.268] [DEBUG] – need_bootstrap: False
[2025-01-10 14:44:29.268] [DEBUG] - sub start ref count to 0
[2025-01-10 14:44:29.268] [DEBUG] - export start
[2025-01-10 14:44:29.268] [DEBUG] - plugin oceanbase-ce-py_script_start-3.1.0 result: True
[2025-01-10 14:44:29.269] [DEBUG] - Searching health_check plugin for components …
[2025-01-10 14:44:29.269] [DEBUG] - Searching health_check plugin for oceanbase-ce-4.3.5.0-100000202024123117.el7-48b61655aaa13e9b01b722928d1979c76b41937e
[2025-01-10 14:44:29.270] [DEBUG] - Found for oceanbase-ce-py_script_health_check-3.1.0 for oceanbase-ce-4.3.5.0
[2025-01-10 14:44:29.270] [DEBUG] - Call plugin oceanbase-ce-py_script_health_check-3.1.0 for oceanbase-ce-4.3.5.0-100000202024123117.el7-48b61655aaa13e9b01b722928d1979c76b41937e
[2025-01-10 14:44:29.270] [DEBUG] - import health_check
[2025-01-10 14:44:29.271] [DEBUG] - add health_check ref count to 1
[2025-01-10 14:44:29.271] [INFO] observer program health check
[2025-01-10 14:44:32.273] [DEBUG] – 127.0.0.1 program health check
[2025-01-10 14:44:32.274] [DEBUG] – local execute: cat /obdserver/observer/run/observer.pid
[2025-01-10 14:44:32.279] [DEBUG] – exited code 0
[2025-01-10 14:44:32.279] [DEBUG] – local execute: ls /proc/57101
[2025-01-10 14:44:32.286] [DEBUG] – exited code 0
[2025-01-10 14:44:32.286] [DEBUG] – 127.0.0.1 observer[pid: 57101] started
[2025-01-10 14:44:32.407] [DEBUG] - sub health_check ref count to 0
[2025-01-10 14:44:32.407] [DEBUG] - export health_check
[2025-01-10 14:44:32.407] [DEBUG] - plugin oceanbase-ce-py_script_health_check-3.1.0 result: True
[2025-01-10 14:44:32.407] [DEBUG] - Searching connect plugin for components …
[2025-01-10 14:44:32.408] [DEBUG] - Searching connect plugin for oceanbase-ce-4.3.5.0-100000202024123117.el7-48b61655aaa13e9b01b722928d1979c76b41937e
[2025-01-10 14:44:32.409] [DEBUG] - Found for oceanbase-ce-py_script_connect-3.1.0 for oceanbase-ce-4.3.5.0
[2025-01-10 14:44:32.409] [DEBUG] - Call plugin oceanbase-ce-py_script_connect-3.1.0 for oceanbase-ce-4.3.5.0-100000202024123117.el7-48b61655aaa13e9b01b722928d1979c76b41937e
[2025-01-10 14:44:32.409] [DEBUG] - import connect
[2025-01-10 14:44:32.411] [DEBUG] - add connect ref count to 1
[2025-01-10 14:44:32.411] [INFO] Connect to observer
[2025-01-10 14:44:32.412] [DEBUG] – connect 127.0.0.1 -P2881 -uroot -p******
[2025-01-10 14:44:35.419] [DEBUG] – connect 127.0.0.1 -P2881 -uroot -p
[2025-01-10 14:44:38.424] [DEBUG] – connect 127.0.0.1 -P2881 -uroot -p******
[2025-01-10 14:44:41.430] [DEBUG] – connect 127.0.0.1 -P2881 -uroot -p
[2025-01-10 14:44:44.435] [DEBUG] – connect 127.0.0.1 -P2881 -uroot -p******
[2025-01-10 14:44:47.440] [DEBUG] – connect 127.0.0.1 -P2881 -uroot -p
[2025-01-10 14:44:50.445] [DEBUG] – connect 127.0.0.1 -P2881 -uroot -p******
[2025-01-10 14:44:53.450] [DEBUG] – connect 127.0.0.1 -P2881 -uroot -p
[2025-01-10 14:44:56.455] [DEBUG] – connect 127.0.0.1 -P2881 -uroot -p******
[2025-01-10 14:44:59.461] [DEBUG] – connect 127.0.0.1 -P2881 -uroot -p
[2025-01-10 14:45:02.464] [DEBUG] – connect 127.0.0.1 -P2881 -uroot -p******
[2025-01-10 14:45:05.469] [DEBUG] – connect 127.0.0.1 -P2881 -uroot -p
[2025-01-10 14:45:08.473] [DEBUG] – connect 127.0.0.1 -P2881 -uroot -p******
[2025-01-10 14:45:11.477] [DEBUG] – connect 127.0.0.1 -P2881 -uroot -p
[2025-01-10 14:45:14.481] [DEBUG] – connect 127.0.0.1 -P2881 -uroot -p******
[2025-01-10 14:45:17.484] [DEBUG] – connect 127.0.0.1 -P2881 -uroot -p
[2025-01-10 14:45:20.488] [DEBUG] – connect 127.0.0.1 -P2881 -uroot -p******
[2025-01-10 14:45:23.493] [DEBUG] – connect 127.0.0.1 -P2881 -uroot -p
[2025-01-10 14:45:26.498] [DEBUG] – connect 127.0.0.1 -P2881 -uroot -p******
[2025-01-10 14:45:29.503] [DEBUG] – connect 127.0.0.1 -P2881 -uroot -p
[2025-01-10 14:45:32.508] [DEBUG] – connect 127.0.0.1 -P2881 -uroot -p******
[2025-01-10 14:45:35.511] [DEBUG] – connect 127.0.0.1 -P2881 -uroot -p
[2025-01-10 14:45:38.516] [DEBUG] – connect 127.0.0.1 -P2881 -uroot -p******
[2025-01-10 14:45:41.521] [DEBUG] – connect 127.0.0.1 -P2881 -uroot -p
[2025-01-10 14:45:44.526] [DEBUG] – connect 127.0.0.1 -P2881 -uroot -p******
[2025-01-10 14:45:47.532] [DEBUG] – connect 127.0.0.1 -P2881 -uroot -p
[2025-01-10 14:45:50.537] [DEBUG] – connect 127.0.0.1 -P2881 -uroot -p******
[2025-01-10 14:45:53.542] [DEBUG] – connect 127.0.0.1 -P2881 -uroot -p
[2025-01-10 14:45:56.547] [DEBUG] – connect 127.0.0.1 -P2881 -uroot -p******
[2025-01-10 14:45:59.552] [DEBUG] – connect 127.0.0.1 -P2881 -uroot -p
[2025-01-10 14:46:02.557] [DEBUG] – connect 127.0.0.1 -P2881 -uroot -p******
[2025-01-10 14:46:05.562] [DEBUG] – connect 127.0.0.1 -P2881 -uroot -p
[2025-01-10 14:46:08.565] [DEBUG] – connect 127.0.0.1 -P2881 -uroot -p******
[2025-01-10 14:46:11.569] [DEBUG] – connect 127.0.0.1 -P2881 -uroot -p
[2025-01-10 14:46:14.572] [DEBUG] – connect 127.0.0.1 -P2881 -uroot -p******
[2025-01-10 14:46:17.578] [DEBUG] – connect 127.0.0.1 -P2881 -uroot -p
[2025-01-10 14:46:20.581] [DEBUG] – connect 127.0.0.1 -P2881 -uroot -p******
[2025-01-10 14:46:23.586] [DEBUG] – connect 127.0.0.1 -P2881 -uroot -p
[2025-01-10 14:46:26.592] [DEBUG] – connect 127.0.0.1 -P2881 -uroot -p******
[2025-01-10 14:46:29.597] [DEBUG] – connect 127.0.0.1 -P2881 -uroot -p
[2025-01-10 14:46:32.602] [DEBUG] – connect 127.0.0.1 -P2881 -uroot -p******
[2025-01-10 14:46:35.607] [DEBUG] – connect 127.0.0.1 -P2881 -uroot -p
[2025-01-10 14:46:38.612] [DEBUG] – connect 127.0.0.1 -P2881 -uroot -p******
[2025-01-10 14:46:41.616] [DEBUG] – connect 127.0.0.1 -P2881 -uroot -p
[2025-01-10 14:46:44.621] [DEBUG] – connect 127.0.0.1 -P2881 -uroot -p******
[2025-01-10 14:46:47.627] [DEBUG] – connect 127.0.0.1 -P2881 -uroot -p
[2025-01-10 14:46:50.632] [DEBUG] – connect 127.0.0.1 -P2881 -uroot -p******
[2025-01-10 14:46:53.636] [DEBUG] – connect 127.0.0.1 -P2881 -uroot -p
[2025-01-10 14:46:56.641] [DEBUG] – connect 127.0.0.1 -P2881 -uroot -p******
[2025-01-10 14:46:59.646] [DEBUG] – connect 127.0.0.1 -P2881 -uroot -p
[2025-01-10 14:47:02.649] [DEBUG] – connect 127.0.0.1 -P2881 -uroot -p******
[2025-01-10 14:47:05.655] [DEBUG] – connect 127.0.0.1 -P2881 -uroot -p
[2025-01-10 14:47:08.658] [DEBUG] – connect 127.0.0.1 -P2881 -uroot -p******
[2025-01-10 14:47:11.663] [DEBUG] – connect 127.0.0.1 -P2881 -uroot -p
[2025-01-10 14:47:14.668] [DEBUG] – connect 127.0.0.1 -P2881 -uroot -p******
[2025-01-10 14:47:17.673] [DEBUG] – connect 127.0.0.1 -P2881 -uroot -p
[2025-01-10 14:47:20.676] [DEBUG] – connect 127.0.0.1 -P2881 -uroot -p******
[2025-01-10 14:47:23.679] [DEBUG] – connect 127.0.0.1 -P2881 -uroot -p
[2025-01-10 14:47:26.683] [DEBUG] – connect 127.0.0.1 -P2881 -uroot -p******
[2025-01-10 14:47:29.685] [DEBUG] – connect 127.0.0.1 -P2881 -uroot -p
[2025-01-10 14:47:32.690] [DEBUG] – connect 127.0.0.1 -P2881 -uroot -p******
[2025-01-10 14:47:35.696] [DEBUG] – connect 127.0.0.1 -P2881 -uroot -p
[2025-01-10 14:47:38.699] [DEBUG] – connect 127.0.0.1 -P2881 -uroot -p******
[2025-01-10 14:47:41.704] [DEBUG] – connect 127.0.0.1 -P2881 -uroot -p
[2025-01-10 14:47:44.709] [DEBUG] – connect 127.0.0.1 -P2881 -uroot -p******
[2025-01-10 14:47:47.712] [DEBUG] – connect 127.0.0.1 -P2881 -uroot -p
[2025-01-10 14:47:50.716] [DEBUG] – connect 127.0.0.1 -P2881 -uroot -p******
[2025-01-10 14:47:53.722] [DEBUG] – connect 127.0.0.1 -P2881 -uroot -p
[2025-01-10 14:47:56.727] [DEBUG] – connect 127.0.0.1 -P2881 -uroot -p******
[2025-01-10 14:47:59.731] [DEBUG] – connect 127.0.0.1 -P2881 -uroot -p
[2025-01-10 14:48:02.735] [DEBUG] – connect 127.0.0.1 -P2881 -uroot -p******
[2025-01-10 14:48:05.738] [DEBUG] – connect 127.0.0.1 -P2881 -uroot -p
[2025-01-10 14:48:08.742] [DEBUG] – connect 127.0.0.1 -P2881 -uroot -p******
[2025-01-10 14:48:11.746] [DEBUG] – connect 127.0.0.1 -P2881 -uroot -p
[2025-01-10 14:48:14.750] [DEBUG] – connect 127.0.0.1 -P2881 -uroot -p******
[2025-01-10 14:48:17.755] [DEBUG] – connect 127.0.0.1 -P2881 -uroot -p
[2025-01-10 14:48:20.759] [DEBUG] – connect 127.0.0.1 -P2881 -uroot -p******
[2025-01-10 14:48:23.763] [DEBUG] – connect 127.0.0.1 -P2881 -uroot -p
[2025-01-10 14:48:23.989] [ERROR] Keyboard Interrupt
[2025-01-10 14:48:23.990] [ERROR] Traceback (most recent call last):
[2025-01-10 14:48:23.990] [ERROR] File “_plugin.py”, line 304, in _new_func
[2025-01-10 14:48:23.990] [ERROR] File “/root/.obd/plugins/oceanbase-ce/3.1.0/connect.py”, line 83, in connect
[2025-01-10 14:48:23.990] [ERROR] time.sleep(3)
[2025-01-10 14:48:23.990] [ERROR] KeyboardInterrupt
[2025-01-10 14:48:23.990] [ERROR]
[2025-01-10 14:48:23.990] [ERROR] During handling of the above exception, another exception occurred:
[2025-01-10 14:48:23.990] [ERROR]
[2025-01-10 14:48:23.990] [ERROR] Traceback (most recent call last):
[2025-01-10 14:48:23.990] [ERROR] File “obd.py”, line 286, in do_command
[2025-01-10 14:48:23.990] [ERROR] File “obd.py”, line 976, in _do_command
[2025-01-10 14:48:23.990] [ERROR] File “core.py”, line 2090, in start_cluster
[2025-01-10 14:48:23.990] [ERROR] File “core.py”, line 2140, in _start_cluster
[2025-01-10 14:48:23.990] [ERROR] File “core.py”, line 228, in run_workflow
[2025-01-10 14:48:23.990] [ERROR] File “core.py”, line 270, in run_plugin_template
[2025-01-10 14:48:23.990] [ERROR] File “core.py”, line 315, in call_plugin
[2025-01-10 14:48:23.991] [ERROR] File “_plugin.py”, line 347, in call
[2025-01-10 14:48:23.991] [ERROR] File “_plugin.py”, line 304, in _new_func
[2025-01-10 14:48:23.991] [ERROR] KeyboardInterrupt
[2025-01-10 14:48:23.991] [ERROR]
[2025-01-10 14:48:24.030] [INFO] [ERROR] Keyboard Interrupt
[2025-01-10 14:48:24.030] [INFO]
[2025-01-10 14:48:24.030] [DEBUG] - share lock /root/.obd/lock/mirror_and_repo release, count 1
[2025-01-10 14:48:24.030] [DEBUG] - share lock /root/.obd/lock/mirror_and_repo release, count 0
[2025-01-10 14:48:24.030] [DEBUG] - unlock /root/.obd/lock/mirror_and_repo
[2025-01-10 14:48:24.031] [DEBUG] - exclusive lock /root/.obd/lock/deploy_dy_qd release, count 0
[2025-01-10 14:48:24.031] [DEBUG] - unlock /root/.obd/lock/deploy_dy_qd
[2025-01-10 14:48:24.031] [DEBUG] - share lock /root/.obd/lock/global release, count 0
[2025-01-10 14:48:24.031] [DEBUG] - unlock /root/.obd/lock/global
[2025-01-10 14:48:24.031] [INFO] Trace ID: 565d52c0-cf1e-11ef-b724-5254a813e24f
[2025-01-10 14:48:24.031] [INFO] If you want to view detailed obd logs, please run: obd display-trace 565d52c0-cf1e-11ef-b724-5254a813e24f
yaml文件
oceanbase-ce:
servers:
# Please don’t use hostname, only IP can be supported
- 127.0.0.1
global:
# The working directory for OceanBase Database. OceanBase Database is started under this directory. This is a required field.
home_path: /obdserver/observer
data_dir: /obdserver/data
redo_dir: /dmdata/obredo
# The directory for data storage. The default value is $home_path/store.
# data_dir: /data
# The directory for clog, ilog, and slog. The default value is the same as the data_dir value.
# redo_dir: /redo
# Starting from observer version 4.2, the network selection for the observer is based on the ‘local_ip’ parameter, and the ‘devname’ parameter is no longer mandatory.
# If the ‘local_ip’ parameter is set, the observer will first use this parameter for the configuration, regardless of the ‘devname’ parameter.
# If only the ‘devname’ parameter is set, the observer will use the ‘devname’ parameter for the configuration.
# If neither the ‘devname’ nor the ‘local_ip’ parameters are set, the ‘local_ip’ parameter will be automatically assigned the IP address configured above.
#devname: bridge0
mysql_port: 2881 # External port for OceanBase Database. The default value is 2881. DO NOT change this value after the cluster is started.
rpc_port: 2882 # Internal port for OceanBase Database. The default value is 2882. DO NOT change this value after the cluster is started.
obshell_port: 2886 # Operation and maintenance port for Oceanbase Database. The default value is 2886. This parameter is valid only when the version of oceanbase-ce is 4.2.2.0 or later.
zone: zone1
cluster_id: 1
# please set memory limit to a suitable value which is matching resource.
memory_limit: 6G # The maximum running memory for an observer
system_memory: 1G # The reserved system memory. system_memory is reserved for general tenants. The default value is 30G.
datafile_size: 2G # Size of the data file.
datafile_next: 2G # the auto extend step. Please enter an capacity, such as 2G
datafile_maxsize: 20G # the auto extend max size. Please enter an capacity, such as 20G
log_disk_size: 14G # The size of disk space used by the clog files.
cpu_count: 16
production_mode: false
enable_syslog_wf: false # Print system logs whose levels are higher than WARNING to a separate log file. The default value is true.
max_syslog_file_count: 4 # The maximum number of reserved log files before enabling auto recycling. The default value is 0.
root_password: Ahzd123!@#
ps -ef|grep observer看一下进程存在么
发一份启动期间的observer日志 ~/oceanbase/log
看了下日志,实际上observer启动成功了
[2025-01-10 15:16:33.129324] INFO [SERVER] start (ob_server.cpp:1205) [59741][observer][T0][YB427F000001-00062B54DF17E6E4-0-0] [lt=7] [OBSERVER_NOTICE] server instance start succeed
但是,持续存在4018和4009 io报错。
4018可能是系统资源不足导致,4009IO error问题可能由磁盘空间不足、磁盘故障或 IO 超时引起。
老师,请问我现在该如何解决这个问题
优先扩容下内存,6G是最小运行规格。
memory_limit:10G
system_memory:3G
datafile_size:100g
datafime_next:20G
datafile_maxsize:200G
log_disk_size:50G
如果觉得麻烦你可以destroy掉集群然后使用obd web白屏化部署集群,这些参数都可以自己手动填写
这个在yaml文件里面修改直接obd cluster start 吗还是要杀掉以前的集群,重新构建
如果你仅是刚安装目前没有数据 建议你obd cluster destroy xxxx然后使用obd web重新构建一个
你这个密码设置的有问题吧。obd详细日志发一下看看
怎么重新搭建的,不应该会存在修改密码报错。yaml文件是否仅仅修改了内存和磁盘参数
obd cluster destroy dy_qd 摧毁
obd cluster deploy dy_qd -c mini-local-example.yaml
obd cluster start dy_qd
执行deploy 部署成功集群默认启动状态,不需要start。