ocp-express 创建租户报错

AntTech_WBWM9P · 2023 年9 月 12 日 15:41

雪染 · 2023 年9 月 12 日 16:53

我看sql参数里 locality 对应的都是只读副本，这样不支持，可以选全功能副本

AntTech_WBWM9P · 2023 年9 月 13 日 11:16

选择全功能副本后报错

023-09-13 11:13:51.967 ERROR 10617 --- [pool-manual-subtask-executor16,2fd9e456b72d4b1d,ea39b62c8f79] c.o.ocp.obsdk.connector.ObConnectors     : [obsdk] create ob connector of 'direct' mode failed, message:[obsdk] init ob connector failed, connectProperties=ConnectProperties(connectionMode=direct, address=10.32.0.103, port=2881, obsAddrList=[ObServerAddr(address=10.32.0.101, port=2881), ObServerAddr(address=10.32.0.102, port=2881), ObServerAddr(address=10.32.0.103, port=2881)], username=root, tenantName=aliyun_dts, clusterName=null, obClusterId=null, proxy=null, compatibilityMode=MYSQL, database=oceanbase), cause:java.sql.SQLSyntaxErrorException: Could not connect to 10.32.0.103:2881 : (conn=3222049115) Access denied

2023-09-13 11:13:51.969 ERROR 10617 --- [pool-manual-subtask-executor16,2fd9e456b72d4b1d,ea39b62c8f79] c.o.ocp.core.obsdk.ObAccessorFactory     : [ObAccessorFactory] create tenant accessor failed, error message:[obsdk] init ob connector failed, connectProperties=ConnectProperties(connectionMode=direct, address=10.32.0.103, port=2881, obsAddrList=[ObServerAddr(address=10.32.0.101, port=2881), ObServerAddr(address=10.32.0.102, port=2881), ObServerAddr(address=10.32.0.103, port=2881)], username=root, tenantName=aliyun_dts, clusterName=null, obClusterId=null, proxy=null, compatibilityMode=MYSQL, database=oceanbase), cause:java.sql.SQLSyntaxErrorException: Could not connect to 10.32.0.103:2881 : (conn=3222049115) Access denied

2023-09-13 11:13:51.972  WARN 10617 --- [pool-manual-subtask-executor16,2fd9e456b72d4b1d,ea39b62c8f79] c.o.o.task.engine.runner.RunnerFactory   : Execute task failed, subtask=SubtaskInstanceOverview{id=619, name=Set system variables, state=FAILED, operation=EXECUTE, className=com.oceanbase.ocp.obops.internal.tenant.task.SetSystemVariablesTask, seriesId=1, startTime=2023-09-13T11:13:51.879+08:00, endTime=null}, failedMessage=Failed to connect to the aliyun_dts tenant. Place check if the password of tenant is correctly  .

com.oceanbase.ocp.core.exception.ConnectFailedException: [OCP ConnectFailedException]: status=500 INTERNAL_SERVER_ERROR, errorCode=OB_TENANT_CONNECT_FAILED, args=aliyun_dts
	at com.oceanbase.ocp.core.obsdk.ObAccessorFactory.createObAccessor(ObAccessorFactory.java:92) ~[ocp-express-core-4.2.0-20230731.jar!/:4.2.0-20230731]
	at com.oceanbase.ocp.core.obsdk.ObAccessorFactory.createObAccessor(ObAccessorFactory.java:55) ~[ocp-express-core-4.2.0-20230731.jar!/:4.2.0-20230731]
	at com.oceanbase.ocp.core.obsdk.ObAccessorFactory.createObAccessor(ObAccessorFactory.java:45) ~[ocp-express-core-4.2.0-20230731.jar!/:4.2.0-20230731]
	at com.oceanbase.ocp.obops.internal.parameter.ObSystemVariableService.setVariables(ObSystemVariableService.java:110) ~[ocp-express-obops-service-4.2.0-20230731.jar!/:4.2.0-20230731]
	at com.oceanbase.ocp.obops.internal.tenant.task.SetSystemVariablesTask.run(SetSystemVariablesTask.java:50) ~[ocp-express-obops-service-4.2.0-20230731.jar!/:4.2.0-20230731]
	at com.oceanbase.ocp.task.engine.runner.JavaSubtaskRunner.execute(JavaSubtaskRunner.java:63) ~[ocp-express-task-service-4.2.0-20230731.jar!/:4.2.0-20230731]
	at com.oceanbase.ocp.task.engine.runner.JavaSubtaskRunner.doRun(JavaSubtaskRunner.java:35) ~[ocp-express-task-service-4.2.0-20230731.jar!/:4.2.0-20230731]
	at com.oceanbase.ocp.task.engine.runner.JavaSubtaskRunner.run(JavaSubtaskRunner.java:29) ~[ocp-express-task-service-4.2.0-20230731.jar!/:4.2.0-20230731]
	at com.oceanbase.ocp.task.engine.runner.RunnerFactory.doRun(RunnerFact
ory.java:114) ~[ocp-express-task-service-4.2.0-20230731.jar!/:4.2.0-20230731]
	at com.oceanbase.ocp.task.engine.runner.RunnerFactory.redirectOutputIfNotSysSchedule(RunnerFactory.java:185) ~[ocp-express-task-service-4.2.0-20230731.jar!/:4.2.0-20230731]
	at com.oceanbase.ocp.task.engine.runner.RunnerFactory.run(RunnerFactory.java:104) ~[ocp-express-task-service-4.2.0-20230731.jar!/:4.2.0-20230731]
	at com.oceanbase.ocp.task.engine.coordinator.worker.subtask.ReadySubtaskWorker.lambda$null$1(ReadySubtaskWorker.java:112) ~[ocp-express-task-service-4.2.0-20230731.jar!/:4.2.0-20230731]
	at java.util.concurrent.FutureTask.run(FutureTask.java:266) ~[na:1.8.0_382]
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[na:1.8.0_382]
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[na:1.8.0_382]
	at java.lang.Thread.run(Thread.java:750) ~[na:1.8.0_382]

大飞哥online · 2023 年9 月 13 日 15:18

Could not connect to 10.32.0.103:2881 : (conn=3222049115) Access denied

服务器连接，访问，权限，先查下

AntTech_WBWM9P · 2023 年9 月 13 日 15:41

是root用户的吧

大飞哥online · 2023 年9 月 13 日 21:06

报错写的是root 用户
你在 ocp 所在的机器用root 连下 103：2881 看下

AntTech_WBWM9P · 2023 年9 月 14 日 10:44

obclient -h10.32.0.103 -P2881 -uroot -p’EZ49YfX8BAGIYQocnWm9’ -Doceanbase -A

上面的截图就是 root 哦

AntTech_WBWM9P · 2023 年9 月 14 日 11:02

重新新建一个租户时就没有再报以上的错误了

大飞哥online · 2023 年9 月 14 日 11:05

多试几次，偶发吧