【 OB or 其他组件 】OCP
【 使用版本 】
【问题描述】 obd cluster deploy ocp 失败
【复现路径】问题出现前后相关操作
【附件及日志】Search plugins ok
Load cluster param plugin ok
Check before start ocp-server ok
Start ocp-server-ce ok
ocp-server-ce program health check \ 这里一直过不去。看odb 日志 failed to start xxx.xx.xx.xx ocp-server-ce
yaml配置文件，obd日志麻烦发出来一份
Only need to configure when remote login is required
user:
username: admin
password: IaaS&P@ssw0rd
password: oceanbase
key_file: /home/admin/.ssh/id_rsa
port: your ssh port, default 22
timeout: ssh connection timeout (second), default 30
ocp-server-ce:
servers:
- 192.168.x.x
global:
home_path: /home/admin/ocp/ocp
memory_size: 8G
port: 8080
soft_dir: /home/admin/ocp/software # Directory used to store packages
log_dir: /home/admin/ocp/logs # Directory used to temporarily store downloaded logs
admin_password: aaAA11__ # Password of ocp’s admin user
jdbc_url: jdbc:oceanbase://192.168.x.x:2881/ocp_meta # Jdbc URL of meta obcluster
jdbc_username: root
jdbc_password: IaaS&P@ssw0rd
ocp_site_url: http://192.168.x.x:8080OCP meta tenant definition, including tenant name, CPU and memory
ocp_meta_tenant:
tenant_name: ocp_meta
max_cpu: 4.0
memory_size: 8G
ocp_meta_username: root # User to use under ocp meta tenant
ocp_meta_password: aaAA11__ # Password used to connect to ocp meta tenant
ocp_meta_db: meta_database # Database used to store ocp meta dataOCP monitor tenant definition, including tenant name, CPU and memory
ocp_monitor_tenant:
tenant_name: ocp_monitor
max_cpu: 4.0
memory_size: 8G
ocp_monitor_username: root # User to use under ocp monitor tenant
ocp_monitor_password: aaAA11__ # Password used to connect to ocp monitor tenant
ocp_monitor_db: monitor_database # Database used to store ocp monitor data
#admin_password: 8~k_V6fV
[2024-09-18 08:54:13.512] [85dba594-7558-11ef-b213-fa163efaf635] [DEBUG] - cmd: [‘ocp’]
[2024-09-18 08:54:13.513] [85dba594-7558-11ef-b213-fa163efaf635] [DEBUG] - opts: {‘servers’: None, ‘components’: None, ‘force_delete’: None, ‘strict_check’: None, ‘without_parameter’: None}
[2024-09-18 08:54:13.513] [85dba594-7558-11ef-b213-fa163efaf635] [DEBUG] - mkdir /home/admin/.obd/lock/
[2024-09-18 08:54:13.513] [85dba594-7558-11ef-b213-fa163efaf635] [DEBUG] - unknown lock mode
[2024-09-18 08:54:13.514] [85dba594-7558-11ef-b213-fa163efaf635] [DEBUG] - try to get share lock /home/admin/.obd/lock/global
[2024-09-18 08:54:13.514] [85dba594-7558-11ef-b213-fa163efaf635] [DEBUG] - share lock /home/admin/.obd/lock/global, count 1
[2024-09-18 08:54:13.514] [85dba594-7558-11ef-b213-fa163efaf635] [DEBUG] - Get Deploy by name
[2024-09-18 08:54:13.514] [85dba594-7558-11ef-b213-fa163efaf635] [DEBUG] - mkdir /home/admin/.obd/cluster/
[2024-09-18 08:54:13.514] [85dba594-7558-11ef-b213-fa163efaf635] [DEBUG] - mkdir /home/admin/.obd/config_parser/
[2024-09-18 08:54:13.515] [85dba594-7558-11ef-b213-fa163efaf635] [DEBUG] - try to get exclusive lock /home/admin/.obd/lock/deploy_ocp
[2024-09-18 08:54:13.515] [85dba594-7558-11ef-b213-fa163efaf635] [DEBUG] - exclusive lock /home/admin/.obd/lock/deploy_ocp, count 1
[2024-09-18 08:54:13.521] [85dba594-7558-11ef-b213-fa163efaf635] [DEBUG] - Deploy status judge
[2024-09-18 08:54:13.522] [85dba594-7558-11ef-b213-fa163efaf635] [INFO] Get local repositories
[2024-09-18 08:54:13.522] [85dba594-7558-11ef-b213-fa163efaf635] [DEBUG] - mkdir /home/admin/.obd/repository
[2024-09-18 08:54:13.523] [85dba594-7558-11ef-b213-fa163efaf635] [DEBUG] - Get local repository ocp-server-ce-4.3.1-bd4512f9f708fb510d98f245b1be0b03a05e2cba
[2024-09-18 08:54:13.523] [85dba594-7558-11ef-b213-fa163efaf635] [DEBUG] - Search repository ocp-server-ce version: 4.3.1, tag: bd4512f9f708fb510d98f245b1be0b03a05e2cba, release: None, package_hash: None
[2024-09-18 08:54:13.523] [85dba594-7558-11ef-b213-fa163efaf635] [DEBUG] - try to get share lock /home/admin/.obd/lock/mirror_and_repo
[2024-09-18 08:54:13.523] [85dba594-7558-11ef-b213-fa163efaf635] [DEBUG] - share lock /home/admin/.obd/lock/mirror_and_repo, count 1
[2024-09-18 08:54:13.523] [85dba594-7558-11ef-b213-fa163efaf635] [DEBUG] - mkdir /home/admin/.obd/repository/ocp-server-ce
[2024-09-18 08:54:13.527] [85dba594-7558-11ef-b213-fa163efaf635] [DEBUG] - Found repository ocp-server-ce-4.3.1-20240805192406.el7-bd4512f9f708fb510d98f245b1be0b03a05e2cba
[2024-09-18 08:54:13.654] [85dba594-7558-11ef-b213-fa163efaf635] [DEBUG] - Get deploy config
[2024-09-18 08:54:13.673] [85dba594-7558-11ef-b213-fa163efaf635] [INFO] Search plugins
[2024-09-18 08:54:13.673] [85dba594-7558-11ef-b213-fa163efaf635] [DEBUG] - Searching start_check plugin for components …
[2024-09-18 08:54:13.673] [85dba594-7558-11ef-b213-fa163efaf635] [DEBUG] - Searching start_check plugin for ocp-server-ce-4.3.1-20240805192406.el7-bd4512f9f708fb510d98f245b1be0b03a05e2cba
[2024-09-18 08:54:13.674] [85dba594-7558-11ef-b213-fa163efaf635] [DEBUG] - mkdir /home/admin/.obd/plugins
[2024-09-18 08:54:13.675] [85dba594-7558-11ef-b213-fa163efaf635] [DEBUG] - Found for ocp-server-ce-py_script_start_check-4.2.2 for ocp-server-ce-4.3.1
[2024-09-18 08:54:13.675] [85dba594-7558-11ef-b213-fa163efaf635] [DEBUG] - Searching create_tenant plugin for components …
[2024-09-18 08:54:13.675] [85dba594-7558-11ef-b213-fa163efaf635] [DEBUG] - Searching create_tenant plugin for ocp-server-ce-4.3.1-20240805192406.el7-bd4512f9f708fb510d98f245b1be0b03a05e2cba
[2024-09-18 08:54:13.676] [85dba594-7558-11ef-b213-fa163efaf635] [DEBUG] - No such create_tenant plugin for ocp-server-ce-4.3.1
[2024-09-18 08:54:13.676] [85dba594-7558-11ef-b213-fa163efaf635] [DEBUG] - Searching tenant_optimize plugin for components …
[2024-09-18 08:54:13.676] [85dba594-7558-11ef-b213-fa163efaf635] [DEBUG] - Searching tenant_optimize plugin for ocp-server-ce-4.3.1-20240805192406.el7-bd4512f9f708fb510d98f245b1be0b03a05e2cba
[2024-09-18 08:54:13.676] [85dba594-7558-11ef-b213-fa163efaf635] [DEBUG] - No such tenant_optimize plugin for ocp-server-ce-4.3.1
[2024-09-18 08:54:13.676] [85dba594-7558-11ef-b213-fa163efaf635] [DEBUG] - Searching start plugin for components …
[2024-09-18 08:54:13.676] [85dba594-7558-11ef-b213-fa163efaf635] [DEBUG] - Searching start plugin for ocp-server-ce-4.3.1-20240805192406.el7-bd4512f9f708fb510d98f245b1be0b03a05e2cba
[2024-09-18 08:54:13.677] [85dba594-7558-11ef-b213-fa163efaf635] [DEBUG] - Found for ocp-server-ce-py_script_start-4.2.1 for ocp-server-ce-4.3.1
[2024-09-18 08:54:13.677] [85dba594-7558-11ef-b213-fa163efaf635] [DEBUG] - Searching connect plugin for components …
[2024-09-18 08:54:13.677] [85dba594-7558-11ef-b213-fa163efaf635] [DEBUG] - Searching connect plugin for ocp-server-ce-4.3.1-20240805192406.el7-bd4512f9f708fb510d98f245b1be0b03a05e2cba
[2024-09-18 08:54:13.678] [85dba594-7558-11ef-b213-fa163efaf635] [DEBUG] - Found for ocp-server-ce-py_script_connect-4.2.1 for ocp-server-ce-4.3.1
[2024-09-18 08:54:13.678] [85dba594-7558-11ef-b213-fa163efaf635] [DEBUG] - Searching bootstrap plugin for components …
[2024-09-18 08:54:13.678] [85dba594-7558-11ef-b213-fa163efaf635] [DEBUG] - Searching bootstrap plugin for ocp-server-ce-4.3.1-20240805192406.el7-bd4512f9f708fb510d98f245b1be0b03a05e2cba
[2024-09-18 08:54:13.678] [85dba594-7558-11ef-b213-fa163efaf635] [DEBUG] - Found for ocp-server-ce-py_script_bootstrap-4.2.1 for ocp-server-ce-4.3.1
[2024-09-18 08:54:13.678] [85dba594-7558-11ef-b213-fa163efaf635] [DEBUG] - Searching display plugin for components …
[2024-09-18 08:54:13.679] [85dba594-7558-11ef-b213-fa163efaf635] [DEBUG] - Searching display plugin for ocp-server-ce-4.3.1-20240805192406.el7-bd4512f9f708fb510d98f245b1be0b03a05e2cba
[2024-09-18 08:54:13.679] [85dba594-7558-11ef-b213-fa163efaf635] [DEBUG] - Found for ocp-server-ce-py_script_display-4.2.1 for ocp-server-ce-4.3.1
[2024-09-18 08:54:13.805] [85dba594-7558-11ef-b213-fa163efaf635] [INFO] Load cluster param plugin
[2024-09-18 08:54:13.805] [85dba594-7558-11ef-b213-fa163efaf635] [DEBUG] - Get local repository ocp-server-ce-4.3.1-bd4512f9f708fb510d98f245b1be0b03a05e2cba
[2024-09-18 08:54:13.805] [85dba594-7558-11ef-b213-fa163efaf635] [DEBUG] - Searching param plugin for components …
[2024-09-18 08:54:13.805] [85dba594-7558-11ef-b213-fa163efaf635] [DEBUG] - Search param plugin for ocp-server-ce
…skipping…
0000:1F90’ | awk -F’ ’ ‘{print $2}’ | uniq
[2024-09-18 10:03:43.273] [1977c7ba-755e-11ef-a963-fa163efaf635] [DEBUG] – exited code 0
[2024-09-18 10:03:43.274] [1977c7ba-755e-11ef-a963-fa163efaf635] [DEBUG] – failed to start 192.168.0.6 ocp-server-ce, remaining retries: 5
[2024-09-18 10:03:58.288] [1977c7ba-755e-11ef-a963-fa163efaf635] [DEBUG] – 192.168.0.6 program health check
[2024-09-18 10:03:58.288] [1977c7ba-755e-11ef-a963-fa163efaf635] [DEBUG] – admin@192.168.0.6 execute: ls /proc/262447
[2024-09-18 10:03:58.349] [1977c7ba-755e-11ef-a963-fa163efaf635] [DEBUG] – exited code 0
[2024-09-18 10:03:58.350] [1977c7ba-755e-11ef-a963-fa163efaf635] [DEBUG] – admin@192.168.0.6 execute: bash -c ‘cat /proc/net/{tcp*,udp*}’ | awk -F’ ’ ‘{print $2,$10}’ | grep ‘00000000:1F90’ | awk -F’ ’ ‘{print $2}’ | uniq
[2024-09-18 10:03:58.515] [1977c7ba-755e-11ef-a963-fa163efaf635] [DEBUG] – exited code 0
[2024-09-18 10:03:58.515] [1977c7ba-755e-11ef-a963-fa163efaf635] [DEBUG] – failed to start 192.168.0.6 ocp-server-ce, remaining retries: 4
[2024-09-18 10:04:13.531] [1977c7ba-755e-11ef-a963-fa163efaf635] [DEBUG] – 192.168.0.6 program health check
[2024-09-18 10:04:13.531] [1977c7ba-755e-11ef-a963-fa163efaf635] [DEBUG] – admin@192.168.0.6 execute: ls /proc/262447
[2024-09-18 10:04:13.591] [1977c7ba-755e-11ef-a963-fa163efaf635] [DEBUG] – exited code 0
[2024-09-18 10:04:13.592] [1977c7ba-755e-11ef-a963-fa163efaf635] [DEBUG] – admin@192.168.0.6 execute: bash -c ‘cat /proc/net/{tcp*,udp*}’ | awk -F’ ’ ‘{print $2,$10}’ | grep ‘00000000:1F90’ | awk -F’ ’ ‘{print $2}’ | uniq
[2024-09-18 10:04:13.760] [1977c7ba-755e-11ef-a963-fa163efaf635] [DEBUG] – exited code 0
[2024-09-18 10:04:13.760] [1977c7ba-755e-11ef-a963-fa163efaf635] [DEBUG] – failed to start 192.168.0.6 ocp-server-ce, remaining retries: 3
[2024-09-18 10:04:28.775] [1977c7ba-755e-11ef-a963-fa163efaf635] [DEBUG] – 192.168.0.6 program health check
[2024-09-18 10:04:28.776] [1977c7ba-755e-11ef-a963-fa163efaf635] [DEBUG] – admin@192.168.0.6 execute: ls /proc/262447
[2024-09-18 10:04:28.834] [1977c7ba-755e-11ef-a963-fa163efaf635] [DEBUG] – exited code 0
[2024-09-18 10:04:28.835] [1977c7ba-755e-11ef-a963-fa163efaf635] [DEBUG] – admin@192.168.0.6 execute: bash -c ‘cat /proc/net/{tcp*,udp*}’ | awk -F’ ’ ‘{print $2,$10}’ | grep ‘00000000:1F90’ | awk -F’ ’ ‘{print $2}’ | uniq
[2024-09-18 10:04:28.999] [1977c7ba-755e-11ef-a963-fa163efaf635] [DEBUG] – exited code 0
[2024-09-18 10:04:29.000] [1977c7ba-755e-11ef-a963-fa163efaf635] [DEBUG] – failed to start 192.168.0.6 ocp-server-ce, remaining retries: 2
[2024-09-18 10:04:44.014] [1977c7ba-755e-11ef-a963-fa163efaf635] [DEBUG] – 192.168.0.6 program health check
[2024-09-18 10:04:44.014] [1977c7ba-755e-11ef-a963-fa163efaf635] [DEBUG] – admin@192.168.0.6 execute: ls /proc/262447
[2024-09-18 10:04:44.074] [1977c7ba-755e-11ef-a963-fa163efaf635] [DEBUG] – exited code 0
[2024-09-18 10:04:44.074] [1977c7ba-755e-11ef-a963-fa163efaf635] [DEBUG] – admin@192.168.0.6 execute: bash -c ‘cat /proc/net/{tcp*,udp*}’ | awk -F’ ’ ‘{print $2,$10}’ | grep ‘00000000:1F90’ | awk -F’ ’ ‘{print $2}’ | uniq
[2024-09-18 10:04:44.237] [1977c7ba-755e-11ef-a963-fa163efaf635] [DEBUG] – exited code 0
[2024-09-18 10:04:44.238] [1977c7ba-755e-11ef-a963-fa163efaf635] [DEBUG] – failed to start 192.168.0.6 ocp-server-ce, remaining retries: 1
[2024-09-18 10:04:59.253] [1977c7ba-755e-11ef-a963-fa163efaf635] [DEBUG] – 192.168.0.6 program health check
[2024-09-18 10:04:59.253] [1977c7ba-755e-11ef-a963-fa163efaf635] [DEBUG] – admin@192.168.0.6 execute: ls /proc/262447
[2024-09-18 10:04:59.313] [1977c7ba-755e-11ef-a963-fa163efaf635] [DEBUG] – exited code 0
[2024-09-18 10:04:59.314] [1977c7ba-755e-11ef-a963-fa163efaf635] [DEBUG] – admin@192.168.0.6 execute: bash -c ‘cat /proc/net/{tcp*,udp*}’ | awk -F’ ’ ‘{print $2,$10}’ | grep ‘00000000:1F90’ | awk -F’ ’ ‘{print $2}’ | uniq
[2024-09-18 10:04:59.479] [1977c7ba-755e-11ef-a963-fa163efaf635] [DEBUG] – exited code 0
[2024-09-18 10:04:59.558] [1977c7ba-755e-11ef-a963-fa163efaf635] [ERROR] failed to start 192.168.0.6 ocp-server-ce
[2024-09-18 10:04:59.558] [1977c7ba-755e-11ef-a963-fa163efaf635] [ERROR] start ocp-server-ce failed
[2024-09-18 10:04:59.558] [1977c7ba-755e-11ef-a963-fa163efaf635] [DEBUG] - sub start ref count to 0
[2024-09-18 10:04:59.558] [1977c7ba-755e-11ef-a963-fa163efaf635] [DEBUG] - export start
[2024-09-18 10:04:59.558] [1977c7ba-755e-11ef-a963-fa163efaf635] [DEBUG] - plugin ocp-server-ce-py_script_start-4.2.1 result: False
[2024-09-18 10:04:59.558] [1977c7ba-755e-11ef-a963-fa163efaf635] [ERROR] ocp-server-ce start failed
[2024-09-18 10:04:59.560] [1977c7ba-755e-11ef-a963-fa163efaf635] [INFO] See https://www.oceanbase.com/product/ob-deployer/error-codes .
[2024-09-18 10:04:59.560] [1977c7ba-755e-11ef-a963-fa163efaf635] [INFO] Trace ID: 1977c7ba-755e-11ef-a963-fa163efaf635
[2024-09-18 10:04:59.560] [1977c7ba-755e-11ef-a963-fa163efaf635] [INFO] If you want to view detailed obd logs, please run: obd display-trace 1977c7ba-755e-11ef-a963-fa163efaf635
[2024-09-18 10:04:59.560] [1977c7ba-755e-11ef-a963-fa163efaf635] [DEBUG] - exclusive lock /home/admin/.obd/lock/mirror_and_repo release, count 2
[2024-09-18 10:04:59.561] [1977c7ba-755e-11ef-a963-fa163efaf635] [DEBUG] - exclusive lock /home/admin/.obd/lock/mirror_and_repo release, count 1
[2024-09-18 10:04:59.561] [1977c7ba-755e-11ef-a963-fa163efaf635] [DEBUG] - exclusive lock /home/admin/.obd/lock/mirror_and_repo release, count 0
[2024-09-18 10:04:59.561] [1977c7ba-755e-11ef-a963-fa163efaf635] [DEBUG] - try to get share lock /home/admin/.obd/lock/mirror_and_repo
[2024-09-18 10:04:59.561] [1977c7ba-755e-11ef-a963-fa163efaf635] [DEBUG] - share lock /home/admin/.obd/lock/mirror_and_repo release, count 1
[2024-09-18 10:04:59.561] [1977c7ba-755e-11ef-a963-fa163efaf635] [DEBUG] - share lock /home/admin/.obd/lock/mirror_and_repo release, count 0
[2024-09-18 10:04:59.561] [1977c7ba-755e-11ef-a963-fa163efaf635] [DEBUG] - unlock /home/admin/.obd/lock/mirror_and_repo
[2024-09-18 10:04:59.561] [1977c7ba-755e-11ef-a963-fa163efaf635] [DEBUG] - exclusive lock /home/admin/.obd/lock/deploy_ocp release, count 0
[2024-09-18 10:04:59.561] [1977c7ba-755e-11ef-a963-fa163efaf635] [DEBUG] - unlock /home/admin/.obd/lock/deploy_ocp
[2024-09-18 10:04:59.561] [1977c7ba-755e-11ef-a963-fa163efaf635] [DEBUG] - share lock /home/admin/.obd/lock/global release, count 0
[2024-09-18 10:04:59.561] [1977c7ba-755e-11ef-a963-fa163efaf635] [DEBUG] - unlock /home/admin/.obd/lock/global
块引用
黑屏化搭建的么，你的ocp server集群只给了8G内存，两个ocp租户用户16G肯定不够的呀，这能集群搭建成功么
ocp 集群租户 已经有了。现在只是要启动一个ocp 服务，配置文件这样有问题？ ocp_meta ocp_monitor 这两个租户也有了。jdbc_url: jdbc:oceanbase://192.168.x.x:2881/ocp_meta 这里 ocp_meta 是库名？ 看官网上没有看到解释
[2024-09-18 08:54:13.676] [85dba594-7558-11ef-b213-fa163efaf635] [DEBUG] - No such create_tenant plugin for ocp-server-ce-4.3.1。报错没找到创建租户的插件
你意思是集群可以使用mysql命令登录，确认租户都创建出来了么。
目前就是ocp服务没启动么obd cluster xxxx start -c ocp-server-ce 单独启动试试
是的 ，租户集群都手动提前搭建好了，测试也可以登录。 这边单独启动试下。 配置文件这样填没问题吧？
obd cluster ocp start -c ocp-server-ce
[WARN] no such option: -c
Usage: obd cluster [options]
Available commands:
obd cluster start ocp 直接这样启也是 ocp-server-ce program health check x 卡在这里。obd 日志也是 – failed to start 192.168.x.x ocp-server-ce
ocp-all-in-one-4.3.1-20240805192406.el7.aarch64.tar.gz 官网下载的包，然后使用的都是已有的租户。-c 指定的 ocp-only-example.yaml 配置文件，内容如上。
你的obd版本是多少
OceanBase Deploy: 2.9.2 的
租户不要提前搭建，你参考的是哪个搭建ocp文章麻烦发出来看看
麻烦提供下完整obd日志，和ocp的日志，放压缩包里上传。
/home/admin/ocp/logs/ 下面的日志贴一下呢
这个路径下日志没东西。ocp 没生成日志
后面有操作destroy吗？
你手动执行下：cd /home/admin/ocp/ocp; export JDBC_URL=jdbc:oceanbase://192.168.0.6:2881/ocp_meta; export JDBC_USERNAME=root@ocp_meta;export JDBC_PASSWORD=‘aaAA11__’; export JDBC_PUBLIC_KEY=;export OCP_INITIAL_ADMIN_PASSWORD=‘aaAA11__’;java -Dfile.encoding=UTF-8 -jar -Xms8g -Xmx8g -Docp.iam.encrypted-system-password=oceanbase /home/admin/ocp/ocp/lib/ocp-server.jar --bootstrap --progress-log=/home/admin/ocp/logs/bootstrap.log --with-property=server.port:8080 --with-property=logging.file.max-size:100MB --with-property=ocp.logging.file.total.size.cap:1GB --with-property=ocp.monitordb.host:192.168.0.6 --with-property=ocp.monitordb.username:root@ocp_monitor --with-property=ocp.monitordb.port:2881 --with-property=ocp.monitordb.password:‘aaAA11__’ --with-property=ocp.monitordb.database:monitor_database --with-property=logging.file.name:/home/admin/ocp/logs/ocp-server.log --with-property=ocp.site.url:http://192.168.0.6:8080 --with-property=obsdk.ob.connection.mode:direct --with-property=ocp.iam.login.client.max-attempts:60 --with-property=ocp.iam.login.client.lockout-minutes:1 --with-property=ocp.file.local.built-in.dir:/home/admin/ocp/ocp/ocp-server/lib --with-property=ocp.log.download.tmp.dir:/home/admin/ocp/ocp/logs/ocp --with-property=ocp.file.local.dir:/home/admin/ocp/software
再看看
执行上面报错如下： （都是执行的redeploy。destroy 会报错配置中，无法执行）
… 6 common frames omitted
16:04:02.984 [Druid-ConnectionPool-Create-815320891] ERROR com.alibaba.druid.pool.DruidDataSource - create connection SQLException, url: jdbc:oceanbase://192.168.0.6:2881/ocp_meta?useUnicode=true&characterEncoding=UTF8&encloseParamInParentheses=false&connectTimeout=10000&socketTimeout=28800000&rewriteBatchedStatements=true&useServerPrepStmts=false, errorCode 1045, state 42000
java.sql.SQLSyntaxErrorException: Could not connect to 192.168.0.6:2881 : (conn=3221572714) Access denied for user ‘root’@‘xxx.xxx.xxx.xxx’ (using password: YES)
at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:110)
at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:235)
at com.oceanbase.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1720)
at com.oceanbase.jdbc.internal.util.Utils.retrieveProxy(Utils.java:1431)
at com.oceanbase.jdbc.OceanBaseConnection.newConnection(OceanBaseConnection.java:311)
at com.oceanbase.jdbc.Driver.connect(Driver.java:89)
at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1657)
at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1723)
at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2838)
Caused by: java.sql.SQLSyntaxErrorException: (conn=3221572714) Access denied for user ‘root’@‘xxx.xxx.xxx.xxx’ (using password: YES)
at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:110)
at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:230)
at com.oceanbase.jdbc.internal.protocol.AbstractConnectProtocol.authenticationHandler(AbstractConnectProtocol.java:801)
at com.oceanbase.jdbc.internal.protocol.AbstractConnectProtocol.createConnection(AbstractConnectProtocol.java:602)
at com.oceanbase.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1715)
… 6 common frames omitted
#16:04:03.487 [Druid-ConnectionPool-Create-815320891] ERROR com.alibaba.druid.pool.DruidDataSource - create connection SQLException, url: jdbc:oceanbase://192.168.0.6:2881/ocp_meta?useUnicode=true&characterEncoding=UTF8&encloseParamInParentheses=false&connectTimeout=10000&socketTimeout=28800000&rewriteBatchedStatements=true&useServerPrepStmts=false, errorCode 1045, state 42000
java.sql.SQLSyntaxErrorException: Could not connect to 192.168.0.6:2881 : (conn=3221572715) Access denied for user ‘root’@‘xxx.xxx.xxx.xxx’ (using password: YES)
at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:110)
at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:235)
at com.oceanbase.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1720)
at com.oceanbase.jdbc.internal.util.Utils.retrieveProxy(Utils.java:1431)
at com.oceanbase.jdbc.OceanBaseConnection.newConnection(OceanBaseConnection.java:311)
at com.oceanbase.jdbc.Driver.connect(Driver.java:89)
at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1657)
at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1723)
at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2838)
Caused by: java.sql.SQLSyntaxErrorException: (conn=3221572715) Access denied for user ‘root’@‘xxx.xxx.xxx.xxx’ (using password: YES)
at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:110)
at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:230)
at com.oceanbase.jdbc.internal.protocol.AbstractConnectProtocol.authenticationHandler(AbstractConnectProtocol.java:801)
at com.oceanbase.jdbc.internal.protocol.AbstractConnectProtocol.createConnection(AbstractConnectProtocol.java:602)
at com.oceanbase.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1715)
… 6 common frames omitted
看报错没有链接上 jdbc_url: jdbc:oceanbase://192.168.x.x:2883/ocp_meta # Jdbc url of meta obcluster 这个链接串上的 ocp_meta 是库名？还是集群名呢？