【 使用环境 】测试环境
【 OB or 其他组件 】OCP
【 使用版本 】ocp-server-ce-4.3.2
【问题描述】报连不上数据库
【复现路径】部署报错
网页显示：
install oceanbase-ce-4.2.1.8 for local ok
install obproxy-ce-4.3.1.0 for local ok
install ocp-server-ce-4.3.2 for local ok
±--------------------------------------------------------------------------------------------+
| Packages |
±--------------±--------±-----------------------±-----------------------------------------+
| Repository | Version | Release | Md5 |
±--------------±--------±-----------------------±-----------------------------------------+
| oceanbase-ce | 4.2.1.8 | 108000022024072217.el7 | 499b676f2ede5a16e0c07b2b15991d1160d972e8 |
| obproxy-ce | 4.3.1.0 | 4.el7 | 835f4803c1f4da186439323b66c51db4662678a3 |
| ocp-server-ce | 4.3.2 | 20241012145836.el7 | 610610e2daf63f6df08af686f9a88b6d8cefcc52 |
±--------------±--------±-----------------------±-----------------------------------------+
Repository integrity check ok
Load param plugin ok
Open ssh connection ok
Generate ocp server configuration ok
Parameter check ok
Cluster status check ok
Initializes observer work home ok
Initializes obproxy work home ok
Initializes ocp-server-ce work home ok
Remote oceanbase-ce-4.2.1.8-108000022024072217.el7-499b676f2ede5a16e0c07b2b15991d1160d972e8 repository install ok
Remote oceanbase-ce-4.2.1.8-108000022024072217.el7-499b676f2ede5a16e0c07b2b15991d1160d972e8 repository lib check !!
Remote obproxy-ce-4.3.1.0-4.el7-835f4803c1f4da186439323b66c51db4662678a3 repository install ok
Remote obproxy-ce-4.3.1.0-4.el7-835f4803c1f4da186439323b66c51db4662678a3 repository lib check ok
Remote ocp-server-ce-4.3.2-20241012145836.el7-610610e2daf63f6df08af686f9a88b6d8cefcc52 repository install ok
Remote ocp-server-ce-4.3.2-20241012145836.el7-610610e2daf63f6df08af686f9a88b6d8cefcc52 repository lib check ok
Try to get lib-repository
install oceanbase-ce-libs-4.2.1.8 for local ok
Remote oceanbase-ce-libs-4.2.1.8-108000022024072217.el7-d02f4bfd321370a02550424293beb1be31204038 repository install ok
Remote oceanbase-ce-4.2.1.8-108000022024072217.el7-499b676f2ede5a16e0c07b2b15991d1160d972e8 repository lib check ok
ocpmetadb deployed
Search plugins ok
Load cluster param plugin ok
Check before start observer ok
[WARN] OBD-1011: (10.106.21.31) The recommended value of fs.aio-max-nr is 1048576 (Current value: 65536)
[WARN] OBD-1012: (10.106.21.31) clog and data use the same disk (/data)
Start observer ok
observer program health check ok
Connect to observer ok
Initialize oceanbase-ce ok
Create tenant ocp_meta ok
Exec oceanbase-ce-4.2.1.8-108000022024072217.el7-499b676f2ede5a16e0c07b2b15991d1160d972e8 import_time_zone_info.py ok
Exec oceanbase-ce-4.2.1.8-108000022024072217.el7-499b676f2ede5a16e0c07b2b15991d1160d972e8 import_srs_data.py ok
obclient -h10.106.21.31 -P2881 -uroot@ocp_meta -Doceanbase -A
Create tenant ocp_monitor ok
[ERROR] OBD-5000: create resource pool ocp_monitor_pool unit=‘ocp_monitor_unit’, unit_num=1, zone_list=(‘zone1’) execute failed
[ERROR] create resource pool failed, you can try again by using SQL “drop resource pool ocp_monitor_pool” to delete the resource pool, if you are certain that the resource pool is not being used. error info: (4733, ‘zone ‘zone1’ resource not enough to hold 1 unit. You can check resource info by views: DBA_OB_UNITS, GV$OB_UNITS, GV$OB_SERVERS.\nserver ‘“10.106.21.31:2882”’ LOG_DISK resource not enough\n’)
Load cluster param plugin ok
Check before start obproxy ok
Start obproxy ok
obproxy program health check ok
Connect to obproxy ok
Initialize obproxy-ce ok
±-----------------------------------------------+
| obproxy-ce |
±-------------±-----±----------------±-------+
| ip | port | prometheus_port | status |
±-------------±-----±----------------±-------+
| 10.106.21.31 | 2883 | 2884 | active |
±-------------±-----±----------------±-------+
obclient -h10.106.21.31 -P2883 -uroot@proxysys -p’UATdb0101^’ -Doceanbase -A
succeed
Search plugins ok
Load cluster param plugin ok
Check before start ocp-server ok
[ERROR] meta tenant or monitor tenant connect failed
[ERROR] start ocp-server-ce failed
[ERROR] ocp-server-ce start failed
后台日志：
st request time
2025-03-11 17:39:05,221 INFO get_install_task_info (ocp_handler.py:862) [9c7f62d487ec48a2b9b1bfe19a943e64] get ocp install task info
2025-03-11 17:39:05,228 INFO dispatch (request_response_log.py:43) [9c7f62d487ec48a2b9b1bfe19a943e64] app send response, code: 200
2025-03-11 17:39:05,716 WARNING _do_install (ocp_handler.py:819) [None] failed to start component: ocp-server-ce
2025-03-11 17:39:05,716 INFO _do_install (ocp_handler.py:821) [None] end start ocp-server-ce
2025-03-11 17:39:05,721 ERROR wrapper (task.py:140) [1bfe43b132424e3987568a7dbe743e30] task 1 got exception
Traceback (most recent call last):
File “service/common/task.py”, line 126, in wrapper
File “concurrent/futures/_base.py”, line 444, in result
File “concurrent/futures/_base.py”, line 389, in __get_result
File “concurrent/futures/thread.py”, line 57, in run
File “service/handler/ocp_handler.py”, line 826, in _do_install
File “_stdio.py”, line 969, in wrapper
File “_stdio.py”, line 956, in func_wrapper
File “tool.py”, line 767, in init
File “tool.py”, line 797, in _connect
File “pymysql/connections.py”, line 353, in init
File “pymysql/connections.py”, line 633, in connect
File “pymysql/connections.py”, line 907, in _request_authentication
File “pymysql/connections.py”, line 725, in _read_packet
File “pymysql/protocol.py”, line 221, in raise_for_error
File “pymysql/err.py”, line 143, in raise_mysql_exception
pymysql.err.OperationalError: (1045, “Access denied for user ‘root’@‘xxx.xxx.xxx.xxx’ (using password: YES)”)
2025-03-11 17:39:05,723 INFO wrapper (task.py:143) [1bfe43b132424e3987568a7dbe743e30] task 1 finished failed
2025-03-11 17:39:06,985 INFO dispatch (request_response_log.py:40) [f67b28df8b174f359ff5bbdce8499eb6] app receive request, method: GET, url: http://10.106.21.31:8680/api/v1/ocp/deployments/1/install/2/log, query_params: , body: , from: 10.102.144.145:60883
2025-03-11 17:39:06,986 INFO dispatch (idle_shutdown.py:36) [f67b28df8b174f359ff5bbdce8499eb6] dispatch request and update last request time
2025-03-11 17:39:06,986 INFO get_install_task_info (ocp_handler.py:862) [f67b28df8b174f359ff5bbdce8499eb6] get ocp install task info
