2025-03-06 16:36:48.846 INFO 2287169 --- [manual-subtask-executor14,9a037d85adf59289,8e710641465bd090] c.o.ocp.service.iam.user.UserService : user 100 login with organization 10000000 2025-03-06 16:36:48.850 INFO 2287169 --- [manual-subtask-executor14,9a037d85adf59289,8e710641465bd090] c.o.o.c.t.e.runner.JavaSubtaskRunner : Run subtask, id=497, context=Context{parallelIdx=-1, stringMap={old_config_url=http://192.168.9.61:8080/services?Action=ObRootServiceInfo&User_ID=alibaba&UID=ocpmaster&ObRegion=sgkydb, ob_log_disk_path=/data/log1, primary_root_sys_password=xxx task_instance_id=195, agent_async_task_token_map={"504":"d76ef643-a56a-44a0-b57e-17509e0a9cf6"}, task_operation=execute, ob_run_path=/opt/oceanbase/oceanbase, cluster_type=PRIMARY, ob_install_path=/opt/oceanbase/oceanbase, obproxy_proxyro_username=proxyro, ob_sql_port=2881, cluster_id=5, operation_scope=Cluster, ob_svr_port=2882, sub_task_instance_name=Create resource manager for default user, sub_task_instance_id=497, cluster_version=4.3.5.0, cluster_name=sgkydb, target_server_status=RUNNING, mix_rpm_names={"zone1":"oceanbase-ce-4.3.5.0-100000202024123117.el7.x86_64.rpm"}, startup_option_string=large_query_threshold=600s,max_syslog_file_count=300,enable_syslog_recycle=1,enable_cgroup=false,enable_record_trace_log=false, subtask_splitter=host_ids, ob_version=4.3.5.0, service_name=sgkydb:1741231014, target_zone_status=RUNNING, ob_cluster_id=1741231014, OLD_PROXYRO_password=xxx zone1.idc=default_idc, service_type=OB_CLUSTER, obproxy_proxyro_password=xxx root_sys_password=xxx dep_rpm_names={"zone1":["oceanbase-ce-libs-4.3.5.0-100000202024123117.el7.x86_64.rpm","oceanbase-ce-utils-4.3.5.0-100000202024123117.el7.x86_64.rpm"]}, connection_mode=direct, ob_run_user=root, target_cluster_status=RUNNING, latest_execution_start_time=2025-03-06T16:36:48.590+08:00, ob_data_disk_path=/data/1, mix_obs_rpm={}}, listMap={root_servers=[2], server_ids=[14, 15, 16, 17], host_ids=[2, 3, 4, 5], zone1.host_ids=[2, 3, 4, 5], zone_names=[zone1], ob_connect_address_list=[192.168.9.62:2881]}}, executor=192.168.9.61 2025-03-06 16:36:48.915 INFO 2287169 --- [manual-subtask-executor14,9a037d85adf59289,8e710641465bd090] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2025-03-06 16:36:48.966 INFO 2287169 --- [manual-subtask-executor14,9a037d85adf59289,8e710641465bd090] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: SELECT CONSUMER_GROUP FROM DBA_RSRC_CONSUMER_GROUPS 2025-03-06 16:36:48.989 INFO 2287169 --- [manual-subtask-executor14,9a037d85adf59289,8e710641465bd090] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2025-03-06 16:36:49.031 INFO 2287169 --- [manual-subtask-executor14,9a037d85adf59289,8e710641465bd090] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: SELECT PLAN FROM DBA_RSRC_PLANS 2025-03-06 16:36:49.050 INFO 2287169 --- [manual-subtask-executor14,9a037d85adf59289,8e710641465bd090] c.o.o.s.o.o.f.ConnectPropertiesBuilder : get credential from obsdk context, clusterName=sgkydb, tenantName=sys, dbUser=root 2025-03-06 16:36:49.116 INFO 2287169 --- [manual-subtask-executor14,9a037d85adf59289,8e710641465bd090] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2025-03-06 16:36:49.159 INFO 2287169 --- [manual-subtask-executor14,9a037d85adf59289,8e710641465bd090] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: SELECT CONSUMER_GROUP FROM DBA_RSRC_CONSUMER_GROUPS 2025-03-06 16:36:49.162 INFO 2287169 --- [manual-subtask-executor14,9a037d85adf59289,8e710641465bd090] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2025-03-06 16:36:49.165 INFO 2287169 --- [manual-subtask-executor14,9a037d85adf59289,8e710641465bd090] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: SELECT CONSUMER_GROUP, ATTRIBUTE, VALUE FROM DBA_RSRC_GROUP_MAPPINGS WHERE CONSUMER_GROUP IS NOT NULL AND CONSUMER_GROUP <> '' 2025-03-06 16:36:49.171 INFO 2287169 --- [manual-subtask-executor14,9a037d85adf59289,8e710641465bd090] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2025-03-06 16:36:49.174 INFO 2287169 --- [manual-subtask-executor14,9a037d85adf59289,8e710641465bd090] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: call DBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP (CONSUMER_GROUP => 'ocp_monitor_group', COMMENT => 'reserve thread for default user'); 2025-03-06 16:36:49.234 ERROR 2287169 --- [manual-subtask-executor14,9a037d85adf59289,8e710641465bd090] com.alibaba.druid.pool.DruidDataSource : recyle error java.sql.SQLSyntaxErrorException: (conn=3221499677) Connection.clearWarnings cannot be called on a closed connection at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:110) at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:211) at com.oceanbase.jdbc.OceanBaseConnection.clearWarnings(OceanBaseConnection.java:1425) at com.alibaba.druid.pool.DruidConnectionHolder.reset(DruidConnectionHolder.java:331) at com.alibaba.druid.pool.DruidDataSource.recycle(DruidDataSource.java:1949) at com.alibaba.druid.pool.DruidPooledConnection.recycle(DruidPooledConnection.java:351) at com.alibaba.druid.pool.DruidPooledConnection.close(DruidPooledConnection.java:288) at org.springframework.jdbc.datasource.DataSourceUtils.doCloseConnection(DataSourceUtils.java:407) at org.springframework.jdbc.datasource.DataSourceUtils.doReleaseConnection(DataSourceUtils.java:394) at org.springframework.jdbc.datasource.DataSourceUtils.releaseConnection(DataSourceUtils.java:361) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:396) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:436) at com.oceanbase.ocp.obsdk.connector.ConnectTemplate.execute(ConnectTemplate.java:308) at com.oceanbase.ocp.obsdk.connector.ObConnectTemplate.executeMysqlPl(ObConnectTemplate.java:97) at com.oceanbase.ocp.obsdk.connector.ObConnectTemplate.executePl(ObConnectTemplate.java:88) at com.oceanbase.ocp.obsdk.accessor.resource.AbstractResourceAccessor.createConsumerGroup(AbstractResourceAccessor.java:250) at com.oceanbase.ocp.obops.internal.resource.TenantResourceServiceImpl.createConsumerGroup(TenantResourceServiceImpl.java:120) at com.oceanbase.ocp.obops.internal.resource.DefaultUserResourceManagerServiceImpl.createConsumerGroupForUser(DefaultUserResourceManagerServic eImpl.java:105) at com.oceanbase.ocp.service.task.business.cluster.CreateResourceManagerForDefaultUserTask.run(CreateResourceManagerForDefaultUserTask.java:74) at com.oceanbase.ocp.core.task.engine.runner.JavaSubtaskRunner.execute(JavaSubtaskRunner.java:64) at com.oceanbase.ocp.core.task.engine.runner.JavaSubtaskRunner.doRun(JavaSubtaskRunner.java:32) at com.oceanbase.ocp.core.task.engine.runner.JavaSubtaskRunner.run(JavaSubtaskRunner.java:26) at com.oceanbase.ocp.core.task.engine.runner.RunnerFactory.doRun(RunnerFactory.java:76) at com.oceanbase.ocp.core.task.engine.coordinator.worker.subtask.SubtaskExecutor.doRun(SubtaskExecutor.java:206) at com.oceanbase.ocp.core.task.engine.coordinator.worker.subtask.SubtaskExecutor.redirectConsoleOutput(SubtaskExecutor.java:200) at com.oceanbase.ocp.core.task.engine.coordinator.worker.subtask.SubtaskExecutor.lambda$submit$2(SubtaskExecutor.java:137) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:750) 2025-03-06 16:36:54.434 WARN 2287169 --- [manual-subtask-executor14,9a037d85adf59289,8e710641465bd090] com.alibaba.druid.pool.DruidDataSource : get connection timeout retry : 1 2025-03-06 16:36:59.521 WARN 2287169 --- [manual-subtask-executor14,9a037d85adf59289,8e710641465bd090] o.s.jdbc.support.SQLErrorCodesFactory : Error while extracting database name org.springframework.jdbc.support.MetaDataAccessException: Could not get Connection for extracting meta-data; nested exception is org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is com.alibaba.druid.pool.GetConnectionTimeoutException: wait millis 5000, active 0, maxActive 20, creating 0, createErrorCount 3 at org.springframework.jdbc.support.JdbcUtils.extractDatabaseMetaData(JdbcUtils.java:363) at org.springframework.jdbc.support.SQLErrorCodesFactory.resolveErrorCodes(SQLErrorCodesFactory.java:235) at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.lambda$setDataSource$0(SQLErrorCodeSQLExceptionTranslator.java:138) at org.springframework.util.function.SingletonSupplier.get(SingletonSupplier.java:97) at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.setDataSource(SQLErrorCodeSQLExceptionTranslator.java:139) at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.(SQLErrorCodeSQLExceptionTranslator.java:100) at org.springframework.jdbc.support.JdbcAccessor.getExceptionTranslator(JdbcAccessor.java:136) at org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1577) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:398) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:436) at com.oceanbase.ocp.obsdk.connector.ConnectTemplate.execute(ConnectTemplate.java:308) at com.oceanbase.ocp.obsdk.connector.ObConnectTemplate.executeMysqlPl(ObConnectTemplate.java:97) at com.oceanbase.ocp.obsdk.connector.ObConnectTemplate.executePl(ObConnectTemplate.java:88) at com.oceanbase.ocp.obsdk.accessor.resource.AbstractResourceAccessor.createConsumerGroup(AbstractResourceAccessor.java:250) at com.oceanbase.ocp.obops.internal.resource.TenantResourceService Impl.createConsumerGroup(TenantResourceServiceImpl.java:120) at com.oceanbase.ocp.obops.internal.resource.DefaultUserResourceManagerServiceImpl.createConsumerGroupForUser(DefaultUserResourceManagerServiceImpl.java:105) at com.oceanbase.ocp.service.task.business.cluster.CreateResourceManagerForDefaultUserTask.run(CreateResourceManagerForDefaultUserTask.java:74) at com.oceanbase.ocp.core.task.engine.runner.JavaSubtaskRunner.execute(JavaSubtaskRunner.java:64) at com.oceanbase.ocp.core.task.engine.runner.JavaSubtaskRunner.doRun(JavaSubtaskRunner.java:32) at com.oceanbase.ocp.core.task.engine.runner.JavaSubtaskRunner.run(JavaSubtaskRunner.java:26) at com.oceanbase.ocp.core.task.engine.runner.RunnerFactory.doRun(RunnerFactory.java:76) at com.oceanbase.ocp.core.task.engine.coordinator.worker.subtask.SubtaskExecutor.doRun(SubtaskExecutor.java:206) at com.oceanbase.ocp.core.task.engine.coordinator.worker.subtask.SubtaskExecutor.redirectConsoleOutput(SubtaskExecutor.java:200) at com.oceanbase.ocp.core.task.engine.coordinator.worker.subtask.SubtaskExecutor.lambda$submit$2(SubtaskExecutor.java:137) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:750) Caused by: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is com.alibaba.druid.pool.GetConnectionTimeoutException: wait millis 5000, active 0, maxActive 20, creating 0, createErrorCount 3 at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:84) at org.springframework.jdbc.support.JdbcUtils.extractDatabaseMetaData(JdbcUtils.java:337) ... 27 common frames omitted Caused by: com.alibaba.druid.pool.GetConnectionTimeoutException: wait millis 5000, active 0, maxActive 20, creating 0, createErrorCount 3 at com.alibaba.druid.pool.DruidDataSource.getConnectionInt ernal(DruidDataSource.java:1773) at com.alibaba.druid.pool.DruidDataSource.getConnectionDirect(DruidDataSource.java:1427) at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:1407) at com.oceanbase.ocp.obsdk.datasource.ConnLevelConfigDataSource.getConnection(ConnLevelConfigDataSource.java:36) at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:1397) at com.oceanbase.ocp.obsdk.datasource.ConnLevelConfigDataSource.getConnection(ConnLevelConfigDataSource.java:22) at com.oceanbase.ocp.obsdk.datasource.ConnLevelConfigDataSource.getConnection(ConnLevelConfigDataSource.java:12) at org.springframework.jdbc.datasource.DataSourceUtils.fetchConnection(DataSourceUtils.java:160) at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:118) at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:81) ... 28 common frames omitted Caused by: java.sql.SQLNonTransientConnectionException: Could not connect to HostAddress{host='.62', port=2881}. Connection refused (Connection refused) at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:122) at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:225) at com.oceanbase.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1752) at com.oceanbase.jdbc.internal.util.Utils.retrieveProxy(Utils.java:1434) at com.oceanbase.jdbc.OceanBaseConnection.newConnection(OceanBaseConnection.java:409) at com.oceanbase.jdbc.Driver.connect(Driver.java:93) 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.net.ConnectException: Connection refused (Connection refu sed) at java.net.PlainSocketImpl.socketConnect(Native Method) at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350) at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206) at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188) at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392) at java.net.Socket.connect(Socket.java:607) at com.oceanbase.jdbc.internal.protocol.AbstractConnectProtocol.createSocket(AbstractConnectProtocol.java:286) at com.oceanbase.jdbc.internal.protocol.AbstractConnectProtocol.createConnection(AbstractConnectProtocol.java:561) at com.oceanbase.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1732) ... 6 common frames omitted 2025-03-06 16:37:04.836 WARN 2287169 --- [manual-subtask-executor14,9a037d85adf59289,8e710641465bd090] com.alibaba.druid.pool.DruidDataSource : get connection timeout retry : 1 2025-03-06 16:37:09.861 WARN 2287169 --- [manual-subtask-executor14,9a037d85adf59289,8e710641465bd090] o.s.jdbc.support.SQLErrorCodesFactory : Error while extracting database name org.springframework.jdbc.support.MetaDataAccessException: Could not get Connection for extracting meta-data; nested exception is org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is com.alibaba.druid.pool.GetConnectionTimeoutException: wait millis 5000, active 0, maxActive 20, creating 0, createErrorCount 3 at org.springframework.jdbc.support.JdbcUtils.extractDatabaseMetaData(JdbcUtils.java:363) at org.springframework.jdbc.support.SQLErrorCodesFactory.resolveErrorCodes(SQLErrorCodesFactory.java:235) at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.lambda$setDataSource$0(SQLErrorCodeSQLExceptionTranslator.java:138) at org.springframework.util.function.SingletonSupplier.get(SingletonSupplier.java:97) at org.springframework.util.function.SupplierUtils.resolve(SupplierUtils.java:40) at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.getSqlErrorCodes(SQLErrorCodeSQLExceptionTranslator.java:169) at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:191) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73) at org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1577) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:398) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:436) at com.oceanbase.ocp.obsdk.connector.ConnectTemplate.execute(ConnectTemplate.java:308) at com.oceanbase.ocp.obsdk.connector.ObConnectTemplate.executeMysqlPl(ObConnectTemplate.java:97) at com.oceanbase.ocp.obsdk.connector.ObConnectTemplate.executePl(ObConnectTemplate.java:88) at com.oceanbase.ocp.obsdk.accessor.resource.AbstractResourceAc cessor.createConsumerGroup(AbstractResourceAccessor.java:250) at com.oceanbase.ocp.obops.internal.resource.TenantResourceServiceImpl.createConsumerGroup(TenantResourceServiceImpl.java:120) at com.oceanbase.ocp.obops.internal.resource.DefaultUserResourceManagerServiceImpl.createConsumerGroupForUser(DefaultUserResourceManagerServiceImpl.java:105) at com.oceanbase.ocp.service.task.business.cluster.CreateResourceManagerForDefaultUserTask.run(CreateResourceManagerForDefaultUserTask.java:74) at com.oceanbase.ocp.core.task.engine.runner.JavaSubtaskRunner.execute(JavaSubtaskRunner.java:64) at com.oceanbase.ocp.core.task.engine.runner.JavaSubtaskRunner.doRun(JavaSubtaskRunner.java:32) at com.oceanbase.ocp.core.task.engine.runner.JavaSubtaskRunner.run(JavaSubtaskRunner.java:26) at com.oceanbase.ocp.core.task.engine.runner.RunnerFactory.doRun(RunnerFactory.java:76) at com.oceanbase.ocp.core.task.engine.coordinator.worker.subtask.SubtaskExecutor.doRun(SubtaskExecutor.java:206) at com.oceanbase.ocp.core.task.engine.coordinator.worker.subtask.SubtaskExecutor.redirectConsoleOutput(SubtaskExecutor.java:200) at com.oceanbase.ocp.core.task.engine.coordinator.worker.subtask.SubtaskExecutor.lambda$submit$2(SubtaskExecutor.java:137) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:750) Caused by: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is com.alibaba.druid.pool.GetConnectionTimeoutException: wait millis 5000, active 0, maxActive 20, creating 0, createErrorCount 3 at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:84) at org.springframework.jdbc.support.JdbcUtils.extractDatabaseMetaData(JdbcUtils.java:337) ... 28 common frames omitted Caused by: com.alibaba.druid.pool.GetConnectionTimeoutException: wai t millis 5000, active 0, maxActive 20, creating 0, createErrorCount 3 at com.alibaba.druid.pool.DruidDataSource.getConnectionInternal(DruidDataSource.java:1773) at com.alibaba.druid.pool.DruidDataSource.getConnectionDirect(DruidDataSource.java:1427) at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:1407) at com.oceanbase.ocp.obsdk.datasource.ConnLevelConfigDataSource.getConnection(ConnLevelConfigDataSource.java:36) at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:1397) at com.oceanbase.ocp.obsdk.datasource.ConnLevelConfigDataSource.getConnection(ConnLevelConfigDataSource.java:22) at com.oceanbase.ocp.obsdk.datasource.ConnLevelConfigDataSource.getConnection(ConnLevelConfigDataSource.java:12) at org.springframework.jdbc.datasource.DataSourceUtils.fetchConnection(DataSourceUtils.java:160) at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:118) at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:81) ... 29 common frames omitted Caused by: java.sql.SQLNonTransientConnectionException: Could not connect to HostAddress{host='192.168.9.62', port=2881}. Connection refused (Connection refused) at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:122) at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:225) at com.oceanbase.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1752) at com.oceanbase.jdbc.internal.util.Utils.retrieveProxy(Utils.java:1434) at com.oceanbase.jdbc.OceanBaseConnection.newConnection(OceanBaseConnection.java:409) at com.oceanbase.jdbc.Driver.connect(Driver.java:93) 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.DruidDataSourc e$CreateConnectionThread.run(DruidDataSource.java:2838) Caused by: java.net.ConnectException: Connection refused (Connection refused) at java.net.PlainSocketImpl.socketConnect(Native Method) at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350) at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206) at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188) at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392) at java.net.Socket.connect(Socket.java:607) at com.oceanbase.jdbc.internal.protocol.AbstractConnectProtocol.createSocket(AbstractConnectProtocol.java:286) at com.oceanbase.jdbc.internal.protocol.AbstractConnectProtocol.createConnection(AbstractConnectProtocol.java:561) at com.oceanbase.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1732) ... 6 common frames omitted 2025-03-06 16:37:09.965 WARN 2287169 --- [manual-subtask-executor14,9a037d85adf59289,8e710641465bd090] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] execute failed, sql:[call DBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP (CONSUMER_GROUP => 'ocp_monitor_group', COMMENT => 'reserve thread for default user');], error message:[StatementCallback; SQL [call DBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP (CONSUMER_GROUP => 'ocp_monitor_group', COMMENT => 'reserve thread for default user');]; (conn=3221499677) unexpected end of stream, read 0 bytes from 31 (socket was closed by server); nested exception is java.sql.SQLNonTransientConnectionException: (conn=3221499677) unexpected end of stream, read 0 bytes from 31 (socket was closed by server)] 2025-03-06 16:37:14.971 WARN 2287169 --- [manual-subtask-executor14,9a037d85adf59289,8e710641465bd090] com.alibaba.druid.pool.DruidDataSource : get connection timeout retry : 1 2025-03-06 16:37:18.950 WARN 2287169 --- [manual-subtask-executor14,9a037d85adf59289,8e710641465bd090] c.o.ocp.obsdk.connector.ConnectTemplate : Failed to query last trace info:Failed to obtain JDBC Connection; nested exception is com.alibaba.druid.pool.DataSourceDisableException 2025-03-06 16:37:18.956 INFO 2287169 --- [manual-subtask-executor14,9a037d85adf59289,8e710641465bd090] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] slow query, durationMillis=29782, sql=call DBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP (CONSUMER_GROUP => 'ocp_monitor_group', COMMENT => 'reserve thread for default user'); 2025-03-06 16:37:18.959 ERROR 2287169 --- [manual-subtask-executor14,9a037d85adf59289,8e710641465bd090] c.o.o.c.t.e.c.w.subtask.SubtaskExecutor : unexpected end of stream, read 0 bytes from 31 (socket was closed by server) java.io.EOFException: unexpected end of stream, read 0 bytes from 31 (socket was closed by server) at com.oceanbase.jdbc.internal.io.input.Ob20PacketInputStream.readFully(Ob20PacketInputStream.java:176) at com.oceanbase.jdbc.internal.io.input.Ob20PacketInputStream.resolveOb20Packet(Ob20PacketInputStream.java:147) at com.oceanbase.jdbc.internal.io.input.Ob20PacketInputStream.getPacketArray(Ob20PacketInputStream.java:97) at com.oceanbase.jdbc.internal.io.input.Ob20PacketInputStream.getPacket(Ob20PacketInputStream.java:90) at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:2211) at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:2117) at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:324) at com.oceanbase.jdbc.OceanBaseStatement.executeInternal(OceanBaseStatement.java:489) at com.oceanbase.jdbc.OceanBaseStatement.execute(OceanBaseStatement.java:676) at com.oceanbase.jdbc.OceanBaseStatement.execute(OceanBaseStatement.java:643) at com.alibaba.druid.pool.DruidPooledStatement.execute(DruidPooledStatement.java:644) at org.springframework.jdbc.core.JdbcTemplate$1ExecuteStatementCallback.doInStatement(JdbcTemplate.java:427) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:383) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:436) at com.oceanbase.ocp.obsdk.connector.ConnectTemplate.execute(ConnectTemplate.java:308) at com.oceanbase.ocp.obsdk.connector.ObConnectTemplate.executeMysqlPl(ObConnectTemplate.java:97) at com.oceanbase.ocp.obsdk.connector.ObConnectTemplate.executePl(ObConnectTemplate.java:88) at com.oceanbase.ocp.obsdk.accessor.resource.AbstractResourceAccessor.createConsumerGroup(Abst ractResourceAccessor.java:250) at com.oceanbase.ocp.obops.internal.resource.TenantResourceServiceImpl.createConsumerGroup(TenantResourceServiceImpl.java:120) at com.oceanbase.ocp.obops.internal.resource.DefaultUserResourceManagerServiceImpl.createConsumerGroupForUser(DefaultUserResourceManagerServiceImpl.java:105) at com.oceanbase.ocp.service.task.business.cluster.CreateResourceManagerForDefaultUserTask.run(CreateResourceManagerForDefaultUserTask.java:74) at com.oceanbase.ocp.core.task.engine.runner.JavaSubtaskRunner.execute(JavaSubtaskRunner.java:64) at com.oceanbase.ocp.core.task.engine.runner.JavaSubtaskRunner.doRun(JavaSubtaskRunner.java:32) at com.oceanbase.ocp.core.task.engine.runner.JavaSubtaskRunner.run(JavaSubtaskRunner.java:26) at com.oceanbase.ocp.core.task.engine.runner.RunnerFactory.doRun(RunnerFactory.java:76) at com.oceanbase.ocp.core.task.engine.coordinator.worker.subtask.SubtaskExecutor.doRun(SubtaskExecutor.java:206) at com.oceanbase.ocp.core.task.engine.coordinator.worker.subtask.SubtaskExecutor.redirectConsoleOutput(SubtaskExecutor.java:200) at com.oceanbase.ocp.core.task.engine.coordinator.worker.subtask.SubtaskExecutor.lambda$submit$2(SubtaskExecutor.java:137) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:750) Set state for subtask: 497, operation:EXECUTE, state: FAILED 2025-03-06 16:44:38.030 INFO 2287169 --- [manual-subtask-executor14,9a037d85adf59289,c4595a66b816989f] c.o.ocp.service.iam.user.UserService : user 100 login with organization 10000000 2025-03-06 16:44:38.033 INFO 2287169 --- [manual-subtask-executor14,9a037d85adf59289,c4595a66b816989f] c.o.o.c.t.e.runner.JavaSubtaskRunner : Retry subtask, id=497, context=Context{parallelIdx=-1, stringMap={old_config_url=http://192.168.9.61:8080/services?Action=ObRootServiceInfo&User_ID=alibaba&UID=ocpmaster&ObRegion=sgkydb, ob_log_disk_path=/data/log1, primary_root_sys_password=xxx task_instance_id=195, agent_async_task_token_map={"504":"d76ef643-a56a-44a0-b57e-17509e0a9cf6"}, task_operation=retry, ob_run_path=/opt/oceanbase/oceanbase, cluster_type=PRIMARY, ob_install_path=/opt/oceanbase/oceanbase, obproxy_proxyro_username=proxyro, ob_sql_port=2881, cluster_id=5, operation_scope=Cluster, ob_svr_port=2882, sub_task_instance_name=Create resource manager for default user, sub_task_instance_id=497, cluster_version=4.3.5.0, cluster_name=sgkydb, target_server_status=RUNNING, mix_rpm_names={"zone1":"oceanbase-ce-4.3.5.0-100000202024123117.el7.x86_64.rpm"}, startup_option_string=large_query_threshold=600s,max_syslog_file_count=300,enable_syslog_recycle=1,enable_cgroup=false,enable_record_trace_log=false, subtask_splitter=host_ids, ob_version=4.3.5.0, service_name=sgkydb:1741231014, target_zone_status=RUNNING, ob_cluster_id=1741231014, OLD_PROXYRO_password=xxx zone1.idc=default_idc, service_type=OB_CLUSTER, obproxy_proxyro_password=xxx root_sys_password=xxx dep_rpm_names={"zone1":["oceanbase-ce-libs-4.3.5.0-100000202024123117.el7.x86_64.rpm","oceanbase-ce-utils-4.3.5.0-100000202024123117.el7.x86_64.rpm"]}, connection_mode=direct, ob_run_user=root, target_cluster_status=RUNNING, latest_execution_start_time=2025-03-06T16:44:37.981+08:00, ob_data_disk_path=/data/1, mix_obs_rpm={}}, listMap={root_servers=[2], server_ids=[14, 15, 16, 17], host_ids=[2, 3, 4, 5], zone1.host_ids=[2, 3, 4, 5], zone_names=[zone1], ob_connect_address_list=[192.168.9.62:2881]}}, executor=192.168.9.61 2025-03-06 16:44:38.035 INFO 2287169 --- [manual-subtask-executor14,9a037d85adf59289,c4595a66b816989f] .CreateResourceManagerForDefaultUserTask : do nothing when rollback 2025-03-06 16:44:38.072 INFO 2287169 --- [manual-subtask-executor14,9a037d85adf59289,c4595a66b816989f] c.o.o.obsdk.connector.ObConnectorHolder : [obsdk] no ob connector found in holder, key=ObConnectorKey(connectionMode=direct, clusterName=sgkydb, obClusterId=1741231014, tenantName=sys, username=root, address=192.168.9.63, port=2881, database=oceanbase) 2025-03-06 16:44:38.115 INFO 2287169 --- [manual-subtask-executor14,9a037d85adf59289,c4595a66b816989f] c.o.o.obsdk.connector.ObConnectorHolder : [obsdk] no ob connector found in holder, key=ObConnectorKey(connectionMode=direct, clusterName=sgkydb, obClusterId=1741231014, tenantName=sys, username=root, address=192.168.9.64, port=2881, database=oceanbase) 2025-03-06 16:44:38.121 INFO 2287169 --- [manual-subtask-executor14,9a037d85adf59289,c4595a66b816989f] c.o.o.obsdk.connector.ObConnectorHolder : [obsdk] no ob connector found in holder, key=ObConnectorKey(connectionMode=direct, clusterName=sgkydb, obClusterId=1741231014, tenantName=sys, username=root, address=192.168.9.65, port=2881, database=oceanbase) 2025-03-06 16:44:38.125 INFO 2287169 --- [manual-subtask-executor14,9a037d85adf59289,c4595a66b816989f] c.o.o.obsdk.connector.ObConnectorHolder : [obsdk] no ob connector found in holder, key=ObConnectorKey(connectionMode=direct, clusterName=sgkydb, obClusterId=1741231014, tenantName=sys, username=root, address=192.168.9.62, port=2881, database=oceanbase) 2025-03-06 16:44:38.150 INFO 2287169 --- [manual-subtask-executor14,9a037d85adf59289,c4595a66b816989f] c.o.ocp.obsdk.connector.ObConnectors : [obsdk] create new ob connector, connectProperties=ConnectProperties(connectionMode=direct, address=null, port=null, obsAddrList=[ObServerAddr(address=192.168.9.63, port=2881), ObServerAddr(address=192.168.9.64, port=2881), ObServerAddr(address=192.168.9.65, port=2881), ObServerAddr(address=192.168.9.62, port=2881)], username=root, tenantName=sys, clusterName=sgkydb, obClusterId=1741231014, proxy=null, odpSocketConfig=null, vpcId=1, compatibilityMode=MYSQL, database=oceanbase) 2025-03-06 16:44:38.157 ERROR 2287169 --- [manual-subtask-executor14,9a037d85adf59289,c4595a66b816989f] c.o.ocp.obsdk.connector.ObConnectors : [obsdk] init ob connector failed, connectProperties=ConnectProperties(connectionMode=direct, address=192.168.9.63, port=2881, obsAddrList=[ObServerAddr(address=192.168.9.63, port=2881), ObServerAddr(address=192.168.9.64, port=2881), ObServerAddr(address=192.168.9.65, port=2881), ObServerAddr(address=192.168.9.62, port=2881)], username=root, tenantName=sys, clusterName=sgkydb, obClusterId=1741231014, proxy=null, odpSocketConfig=null, vpcId=1, compatibilityMode=MYSQL, database=oceanbase), cause:java.sql.SQLTransientConnectionException: Could not connect to 192.168.9.63:2881 : (conn=3221783934) RPC post error 2025-03-06 16:44:38.161 WARN 2287169 --- [manual-subtask-executor14,9a037d85adf59289,c4595a66b816989f] c.o.ocp.obsdk.connector.ObConnectors : [obsdk] try to create ob connector of 'direct' mode failed, observer addr:ObServerAddr(address=192.168.9.63, port=2881), message:[obsdk] init ob connector failed, connectProperties=ConnectProperties(connectionMode=direct, address=192.168.9.63, port=2881, obsAddrList=[ObServerAddr(address=192.168.9.63, port=2881), ObServerAddr(address=192.168.9.64, port=2881), ObServerAddr(address=192.168.9.65, port=2881), ObServerAddr(address=192.168.9.62, port=2881)], username=root, tenantName=sys, clusterName=sgkydb, obClusterId=1741231014, proxy=null, odpSocketConfig=null, vpcId=1, compatibilityMode=MYSQL, database=oceanbase), cause:java.sql.SQLTransientConnectionException: Could not connect to 192.168.9.63:2881 : (conn=3221783934) RPC post error 2025-03-06 16:44:38.170 ERROR 2287169 --- [manual-subtask-executor14,9a037d85adf59289,c4595a66b816989f] c.o.ocp.obsdk.connector.ObConnectors : [obsdk] init ob connector failed, connectProperties=ConnectProperties(connectionMode=direct, address=192.168.9.64, port=2881, obsAddrList=[ObServerAddr(address=192.168.9.63, port=2881), ObServerAddr(address=192.168.9.64, port=2881), ObServerAddr(address=192.168.9.65, port=2881), ObServerAddr(address=192.168.9.62, port=2881)], username=root, tenantName=sys, clusterName=sgkydb, obClusterId=1741231014, proxy=null, odpSocketConfig=null, vpcId=1, compatibilityMode=MYSQL, database=oceanbase), cause:java.sql.SQLTransientConnectionException: Could not connect to 192.168.9.64:2881 : (conn=3222043345) RPC post error 2025-03-06 16:44:38.172 WARN 2287169 --- [manual-subtask-executor14,9a037d85adf59289,c4595a66b816989f] c.o.ocp.obsdk.connector.ObConnectors : [obsdk] try to create ob connector of 'direct' mode failed, observer addr:ObServerAddr(address=192.168.9.64, port=2881), message:[obsdk] init ob connector failed, connectProperties=ConnectProperties(connectionMode=direct, address=192.168.9.64, port=2881, obsAddrList=[ObServerAddr(address=192.168.9.63, port=2881), ObServerAddr(address=192.168.9.64, port=2881), ObServerAddr(address=192.168.9.65, port=2881), ObServerAddr(address=192.168.9.62, port=2881)], username=root, tenantName=sys, clusterName=sgkydb, obClusterId=1741231014, proxy=null, odpSocketConfig=null, vpcId=1, compatibilityMode=MYSQL, database=oceanbase), cause:java.sql.SQLTransientConnectionException: Could not connect to 192.168.9.64:2881 : (conn=3222043345) RPC post error 2025-03-06 16:44:38.266 ERROR 2287169 --- [manual-subtask-executor14,9a037d85adf59289,c4595a66b816989f] c.o.ocp.obsdk.connector.ObConnectors : [obsdk] init ob connector failed, connectProperties=ConnectProperties(connectionMode=direct, address=192.168.9.65, port=2881, obsAddrList=[ObServerAddr(address=192.168.9.63, port=2881), ObServerAddr(address=192.168.9.64, port=2881), ObServerAddr(address=192.168.9.65, port=2881), ObServerAddr(address=192.168.9.62, port=2881)], username=root, tenantName=sys, clusterName=sgkydb, obClusterId=1741231014, proxy=null, odpSocketConfig=null, vpcId=1, compatibilityMode=MYSQL, database=oceanbase), cause:java.sql.SQLTransientConnectionException: Could not connect to 192.168.9.65:2881 : (conn=3222306295) RPC post error 2025-03-06 16:44:38.270 WARN 2287169 --- [manual-subtask-executor14,9a037d85adf59289,c4595a66b816989f] c.o.ocp.obsdk.connector.ObConnectors : [obsdk] try to create ob connector of 'direct' mode failed, observer addr:ObServerAddr(address=192.168.9.65, port=2881), message:[obsdk] init ob connector failed, connectProperties=ConnectProperties(connectionMode=direct, address=192.168.9.65, port=2881, obsAddrList=[ObServerAddr(address=192.168.9.63, port=2881), ObServerAddr(address=192.168.9.64, port=2881), ObServerAddr(address=192.168.9.65, port=2881), ObServerAddr(address=192.168.9.62, port=2881)], username=root, tenantName=sys, clusterName=sgkydb, obClusterId=1741231014, proxy=null, odpSocketConfig=null, vpcId=1, compatibilityMode=MYSQL, database=oceanbase), cause:java.sql.SQLTransientConnectionException: Could not connect to 192.168.9.65:2881 : (conn=3222306295) RPC post error 2025-03-06 16:44:38.277 ERROR 2287169 --- [manual-subtask-executor14,9a037d85adf59289,c4595a66b816989f] c.o.ocp.obsdk.connector.ObConnectors : [obsdk] init ob connector failed, connectProperties=ConnectProperties(connectionMode=direct, address=192.168.9.62, port=2881, obsAddrList=[ObServerAddr(address=192.168.9.63, port=2881), ObServerAddr(address=192.168.9.64, port=2881), ObServerAddr(address=192.168.9.65, port=2881), ObServerAddr(address=192.168.9.62, port=2881)], username=root, tenantName=sys, clusterName=sgkydb, obClusterId=1741231014, proxy=null, odpSocketConfig=null, vpcId=1, compatibilityMode=MYSQL, database=oceanbase), cause:java.sql.SQLNonTransientConnectionException: Could not connect to HostAddress{host='192.168.9.62', port=2881}. Connection refused (Connection refused) 2025-03-06 16:44:38.358 WARN 2287169 --- [manual-subtask-executor14,9a037d85adf59289,c4595a66b816989f] c.o.ocp.obsdk.connector.ObConnectors : [obsdk] try to create ob connector of 'direct' mode failed, observer addr:ObServerAddr(address=192.168.9.62, port=2881), message:[obsdk] init ob connector failed, connectProperties=ConnectProperties(connectionMode=direct, address=192.168.9.62, port=2881, obsAddrList=[ObServerAddr(address=192.168.9.63, port=2881), ObServerAddr(address=192.168.9.64, port=2881), ObServerAddr(address=192.168.9.65, port=2881), ObServerAddr(address=192.168.9.62, port=2881)], username=root, tenantName=sys, clusterName=sgkydb, obClusterId=1741231014, proxy=null, odpSocketConfig=null, vpcId=1, compatibilityMode=MYSQL, database=oceanbase), cause:java.sql.SQLNonTransientConnectionException: Could not connect to HostAddress{host='192.168.9.62', port=2881}. Connection refused (Connection refused) 2025-03-06 16:44:38.367 ERROR 2287169 --- [manual-subtask-executor14,9a037d85adf59289,c4595a66b816989f] 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=192.168.9.62, port=2881, obsAddrList=[ObServerAddr(address=192.168.9.63, port=2881), ObServerAddr(address=192.168.9.64, port=2881), ObServerAddr(address=192.168.9.65, port=2881), ObServerAddr(address=192.168.9.62, port=2881)], username=root, tenantName=sys, clusterName=sgkydb, obClusterId=1741231014, proxy=null, odpSocketConfig=null, vpcId=1, compatibilityMode=MYSQL, database=oceanbase), cause:java.sql.SQLNonTransientConnectionException: Could not connect to HostAddress{host='192.168.9.62', port=2881}. Connection refused (Connection refused) 2025-03-06 16:44:38.374 ERROR 2287169 --- [manual-subtask-executor14,9a037d85adf59289,c4595a66b816989f] c.o.o.s.o.o.factory.ObAccessorFactory : [ObAccessorFactory] create tenant accessor failed, error message:[obsdk] init ob connector failed, connectProperties=ConnectProperties(connectionMode=direct, address=192.168.9.62, port=2881, obsAddrList=[ObServerAddr(address=192.168.9.63, port=2881), ObServerAddr(address=192.168.9.64, port=2881), ObServerAddr(address=192.168.9.65, port=2881), ObServerAddr(address=192.168.9.62, port=2881)], username=root, tenantName=sys, clusterName=sgkydb, obClusterId=1741231014, proxy=null, odpSocketConfig=null, vpcId=1, compatibilityMode=MYSQL, database=oceanbase), cause:java.sql.SQLNonTransientConnectionException: Could not connect to HostAddress{host='192.168.9.62', port=2881}. Connection refused (Connection refused) 2025-03-06 16:44:38.384 ERROR 2287169 --- [manual-subtask-executor14,9a037d85adf59289,c4595a66b816989f] c.o.o.c.t.e.c.w.subtask.SubtaskExecutor : Connection refused (Connection refused) java.net.ConnectException: Connection refused (Connection refused) at java.net.PlainSocketImpl.socketConnect(Native Method) at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350) at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206) at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188) at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392) at java.net.Socket.connect(Socket.java:607) at com.oceanbase.jdbc.internal.protocol.AbstractConnectProtocol.createSocket(AbstractConnectProtocol.java:286) at com.oceanbase.jdbc.internal.protocol.AbstractConnectProtocol.createConnection(AbstractConnectProtocol.java:561) at com.oceanbase.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1732) at com.oceanbase.jdbc.internal.util.Utils.retrieveProxy(Utils.java:1434) at com.oceanbase.jdbc.OceanBaseConnection.newConnection(OceanBaseConnection.java:409) at com.oceanbase.jdbc.Driver.connect(Driver.java:93) 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.init(DruidDataSource.java:927) at com.oceanbase.ocp.obsdk.connector.impl.AbstractConnector.init(AbstractConnector.java:95) at com.oceanbase.ocp.obsdk.connector.impl.DefaultConnector.init(DefaultConnector.java:14) at com.oceanbase.ocp.obsdk.connector.ObConnectors.lambda$newObConnector$1(ObConnectors.java:254) at com.oceanbase.ocp.common.trace.TraceDecorator.lambda$decorate$1(TraceDecorator.java:49) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:750) Set state for subtask: 497, operation:RETRY, state: FAILED 2025-03-06 16:45:20.384 INFO 2287169 --- [manual-subtask-executor14,9a037d85adf59289,bbbcf62ec8d8a815] c.o.ocp.service.iam.user.UserService : user 100 login with organization 10000000 2025-03-06 16:45:20.432 INFO 2287169 --- [manual-subtask-executor14,9a037d85adf59289,bbbcf62ec8d8a815] c.o.o.c.t.e.runner.JavaSubtaskRunner : Retry subtask, id=497, context=Context{parallelIdx=-1, stringMap={old_config_url=http://192.168.9.61:8080/services?Action=ObRootServiceInfo&User_ID=alibaba&UID=ocpmaster&ObRegion=sgkydb, ob_log_disk_path=/data/log1, primary_root_sys_password=xxx task_instance_id=195, agent_async_task_token_map={"504":"d76ef643-a56a-44a0-b57e-17509e0a9cf6"}, task_operation=retry, ob_run_path=/opt/oceanbase/oceanbase, cluster_type=PRIMARY, ob_install_path=/opt/oceanbase/oceanbase, obproxy_proxyro_username=proxyro, ob_sql_port=2881, cluster_id=5, operation_scope=Cluster, ob_svr_port=2882, sub_task_instance_name=Create resource manager for default user, sub_task_instance_id=497, cluster_version=4.3.5.0, cluster_name=sgkydb, target_server_status=RUNNING, mix_rpm_names={"zone1":"oceanbase-ce-4.3.5.0-100000202024123117.el7.x86_64.rpm"}, startup_option_string=large_query_threshold=600s,max_syslog_file_count=300,enable_syslog_recycle=1,enable_cgroup=false,enable_record_trace_log=false, subtask_splitter=host_ids, ob_version=4.3.5.0, service_name=sgkydb:1741231014, target_zone_status=RUNNING, ob_cluster_id=1741231014, OLD_PROXYRO_password=xxx zone1.idc=default_idc, service_type=OB_CLUSTER, obproxy_proxyro_password=xxx root_sys_password=xxx dep_rpm_names={"zone1":["oceanbase-ce-libs-4.3.5.0-100000202024123117.el7.x86_64.rpm","oceanbase-ce-utils-4.3.5.0-100000202024123117.el7.x86_64.rpm"]}, connection_mode=direct, ob_run_user=root, target_cluster_status=RUNNING, latest_execution_start_time=2025-03-06T16:45:20.239+08:00, ob_data_disk_path=/data/1, mix_obs_rpm={}}, listMap={root_servers=[2], server_ids=[14, 15, 16, 17], host_ids=[2, 3, 4, 5], zone1.host_ids=[2, 3, 4, 5], zone_names=[zone1], ob_connect_address_list=[192.168.9.62:2881]}}, executor=192.168.9.61 2025-03-06 16:45:20.471 INFO 2287169 --- [manual-subtask-executor14,9a037d85adf59289,bbbcf62ec8d8a815] .CreateResourceManagerForDefaultUserTask : do nothing when rollback 2025-03-06 16:45:20.631 INFO 2287169 --- [manual-subtask-executor14,9a037d85adf59289,bbbcf62ec8d8a815] c.o.o.obsdk.connector.ObConnectorHolder : [obsdk] no ob connector found in holder, key=ObConnectorKey(connectionMode=direct, clusterName=sgkydb, obClusterId=1741231014, tenantName=sys, username=root, address=192.168.9.65, port=2881, database=oceanbase) 2025-03-06 16:45:20.688 INFO 2287169 --- [manual-subtask-executor14,9a037d85adf59289,bbbcf62ec8d8a815] c.o.o.obsdk.connector.ObConnectorHolder : [obsdk] no ob connector found in holder, key=ObConnectorKey(connectionMode=direct, clusterName=sgkydb, obClusterId=1741231014, tenantName=sys, username=root, address=192.168.9.64, port=2881, database=oceanbase) 2025-03-06 16:45:20.691 INFO 2287169 --- [manual-subtask-executor14,9a037d85adf59289,bbbcf62ec8d8a815] c.o.o.obsdk.connector.ObConnectorHolder : [obsdk] no ob connector found in holder, key=ObConnectorKey(connectionMode=direct, clusterName=sgkydb, obClusterId=1741231014, tenantName=sys, username=root, address=192.168.9.63, port=2881, database=oceanbase) 2025-03-06 16:45:20.693 INFO 2287169 --- [manual-subtask-executor14,9a037d85adf59289,bbbcf62ec8d8a815] c.o.o.obsdk.connector.ObConnectorHolder : [obsdk] no ob connector found in holder, key=ObConnectorKey(connectionMode=direct, clusterName=sgkydb, obClusterId=1741231014, tenantName=sys, username=root, address=192.168.9.62, port=2881, database=oceanbase) 2025-03-06 16:45:20.696 INFO 2287169 --- [manual-subtask-executor14,9a037d85adf59289,bbbcf62ec8d8a815] c.o.ocp.obsdk.connector.ObConnectors : [obsdk] create new ob connector, connectProperties=ConnectProperties(connectionMode=direct, address=null, port=null, obsAddrList=[ObServerAddr(address=192.168.9.65, port=2881), ObServerAddr(address=192.168.9.64, port=2881), ObServerAddr(address=192.168.9.63, port=2881), ObServerAddr(address=192.168.9.62, port=2881)], username=root, tenantName=sys, clusterName=sgkydb, obClusterId=1741231014, proxy=null, odpSocketConfig=null, vpcId=1, compatibilityMode=MYSQL, database=oceanbase) 2025-03-06 16:45:20.704 ERROR 2287169 --- [manual-subtask-executor14,9a037d85adf59289,bbbcf62ec8d8a815] c.o.ocp.obsdk.connector.ObConnectors : [obsdk] init ob connector failed, connectProperties=ConnectProperties(connectionMode=direct, address=192.168.9.65, port=2881, obsAddrList=[ObServerAddr(address=192.168.9.65, port=2881), ObServerAddr(address=192.168.9.64, port=2881), ObServerAddr(address=192.168.9.63, port=2881), ObServerAddr(address=192.168.9.62, port=2881)], username=root, tenantName=sys, clusterName=sgkydb, obClusterId=1741231014, proxy=null, odpSocketConfig=null, vpcId=1, compatibilityMode=MYSQL, database=oceanbase), cause:java.sql.SQLTransientConnectionException: Could not connect to 192.168.9.65:2881 : (conn=3222309315) RPC post error 2025-03-06 16:45:20.786 WARN 2287169 --- [manual-subtask-executor14,9a037d85adf59289,bbbcf62ec8d8a815] c.o.ocp.obsdk.connector.ObConnectors : [obsdk] try to create ob connector of 'direct' mode failed, observer addr:ObServerAddr(address=192.168.9.65, port=2881), message:[obsdk] init ob connector failed, connectProperties=ConnectProperties(connectionMode=direct, address=192.168.9.65, port=2881, obsAddrList=[ObServerAddr(address=192.168.9.65, port=2881), ObServerAddr(address=192.168.9.64, port=2881), ObServerAddr(address=192.168.9.63, port=2881), ObServerAddr(address=192.168.9.62, port=2881)], username=root, tenantName=sys, clusterName=sgkydb, obClusterId=1741231014, proxy=null, odpSocketConfig=null, vpcId=1, compatibilityMode=MYSQL, database=oceanbase), cause:java.sql.SQLTransientConnectionException: Could not connect to 192.168.9.65:2881 : (conn=3222309315) RPC post error 2025-03-06 16:45:20.836 ERROR 2287169 --- [manual-subtask-executor14,9a037d85adf59289,bbbcf62ec8d8a815] c.o.ocp.obsdk.connector.ObConnectors : [obsdk] init ob connector failed, connectProperties=ConnectProperties(connectionMode=direct, address=192.168.9.64, port=2881, obsAddrList=[ObServerAddr(address=192.168.9.65, port=2881), ObServerAddr(address=192.168.9.64, port=2881), ObServerAddr(address=192.168.9.63, port=2881), ObServerAddr(address=192.168.9.62, port=2881)], username=root, tenantName=sys, clusterName=sgkydb, obClusterId=1741231014, proxy=null, odpSocketConfig=null, vpcId=1, compatibilityMode=MYSQL, database=oceanbase), cause:java.sql.SQLTransientConnectionException: Could not connect to 192.168.9.64:2881 : (conn=3222046307) RPC post error 2025-03-06 16:45:20.840 WARN 2287169 --- [manual-subtask-executor14,9a037d85adf59289,bbbcf62ec8d8a815] c.o.ocp.obsdk.connector.ObConnectors : [obsdk] try to create ob connector of 'direct' mode failed, observer addr:ObServerAddr(address=192.168.9.64, port=2881), message:[obsdk] init ob connector failed, connectProperties=ConnectProperties(connectionMode=direct, address=192.168.9.64, port=2881, obsAddrList=[ObServerAddr(address=192.168.9.65, port=2881), ObServerAddr(address=192.168.9.64, port=2881), ObServerAddr(address=192.168.9.63, port=2881), ObServerAddr(address=192.168.9.62, port=2881)], username=root, tenantName=sys, clusterName=sgkydb, obClusterId=1741231014, proxy=null, odpSocketConfig=null, vpcId=1, compatibilityMode=MYSQL, database=oceanbase), cause:java.sql.SQLTransientConnectionException: Could not connect to 192.168.9.64:2881 : (conn=3222046307) RPC post error 2025-03-06 16:45:20.849 ERROR 2287169 --- [manual-subtask-executor14,9a037d85adf59289,bbbcf62ec8d8a815] c.o.ocp.obsdk.connector.ObConnectors : [obsdk] init ob connector failed, connectProperties=ConnectProperties(connectionMode=direct, address=192.168.9.63, port=2881, obsAddrList=[ObServerAddr(address=192.168.9.65, port=2881), ObServerAddr(address=192.168.9.64, port=2881), ObServerAddr(address=192.168.9.63, port=2881), ObServerAddr(address=192.168.9.62, port=2881)], username=root, tenantName=sys, clusterName=sgkydb, obClusterId=1741231014, proxy=null, odpSocketConfig=null, vpcId=1, compatibilityMode=MYSQL, database=oceanbase), cause:java.sql.SQLTransientConnectionException: Could not connect to 192.168.9.63:2881 : (conn=3221786913) RPC post error 2025-03-06 16:45:20.852 WARN 2287169 --- [manual-subtask-executor14,9a037d85adf59289,bbbcf62ec8d8a815] c.o.ocp.obsdk.connector.ObConnectors : [obsdk] try to create ob connector of 'direct' mode failed, observer addr:ObServerAddr(address=192.168.9.63, port=2881), message:[obsdk] init ob connector failed, connectProperties=ConnectProperties(connectionMode=direct, address=192.168.9.63, port=2881, obsAddrList=[ObServerAddr(address=192.168.9.65, port=2881), ObServerAddr(address=192.168.9.64, port=2881), ObServerAddr(address=192.168.9.63, port=2881), ObServerAddr(address=192.168.9.62, port=2881)], username=root, tenantName=sys, clusterName=sgkydb, obClusterId=1741231014, proxy=null, odpSocketConfig=null, vpcId=1, compatibilityMode=MYSQL, database=oceanbase), cause:java.sql.SQLTransientConnectionException: Could not connect to 192.168.9.63:2881 : (conn=3221786913) RPC post error 2025-03-06 16:45:20.856 ERROR 2287169 --- [manual-subtask-executor14,9a037d85adf59289,bbbcf62ec8d8a815] c.o.ocp.obsdk.connector.ObConnectors : [obsdk] init ob connector failed, connectProperties=ConnectProperties(connectionMode=direct, address=192.168.9.62, port=2881, obsAddrList=[ObServerAddr(address=192.168.9.65, port=2881), ObServerAddr(address=192.168.9.64, port=2881), ObServerAddr(address=192.168.9.63, port=2881), ObServerAddr(address=192.168.9.62, port=2881)], username=root, tenantName=sys, clusterName=sgkydb, obClusterId=1741231014, proxy=null, odpSocketConfig=null, vpcId=1, compatibilityMode=MYSQL, database=oceanbase), cause:java.sql.SQLNonTransientConnectionException: Could not connect to HostAddress{host='192.168.9.62', port=2881}. Connection refused (Connection refused) 2025-03-06 16:45:20.862 WARN 2287169 --- [manual-subtask-executor14,9a037d85adf59289,bbbcf62ec8d8a815] c.o.ocp.obsdk.connector.ObConnectors : [obsdk] try to create ob connector of 'direct' mode failed, observer addr:ObServerAddr(address=192.168.9.62, port=2881), message:[obsdk] init ob connector failed, connectProperties=ConnectProperties(connectionMode=direct, address=192.168.9.62, port=2881, obsAddrList=[ObServerAddr(address=192.168.9.65, port=2881), ObServerAddr(address=192.168.9.64, port=2881), ObServerAddr(address=192.168.9.63, port=2881), ObServerAddr(address=192.168.9.62, port=2881)], username=root, tenantName=sys, clusterName=sgkydb, obClusterId=1741231014, proxy=null, odpSocketConfig=null, vpcId=1, compatibilityMode=MYSQL, database=oceanbase), cause:java.sql.SQLNonTransientConnectionException: Could not connect to HostAddress{host='192.168.9.62', port=2881}. Connection refused (Connection refused) 2025-03-06 16:45:20.864 ERROR 2287169 --- [manual-subtask-executor14,9a037d85adf59289,bbbcf62ec8d8a815] 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=192.168.9.62, port=2881, obsAddrList=[ObServerAddr(address=192.168.9.65, port=2881), ObServerAddr(address=192.168.9.64, port=2881), ObServerAddr(address=192.168.9.63, port=2881), ObServerAddr(address=192.168.9.62, port=2881)], username=root, tenantName=sys, clusterName=sgkydb, obClusterId=1741231014, proxy=null, odpSocketConfig=null, vpcId=1, compatibilityMode=MYSQL, database=oceanbase), cause:java.sql.SQLNonTransientConnectionException: Could not connect to HostAddress{host='192.168.9.62', port=2881}. Connection refused (Connection refused) 2025-03-06 16:45:20.865 ERROR 2287169 --- [manual-subtask-executor14,9a037d85adf59289,bbbcf62ec8d8a815] c.o.o.s.o.o.factory.ObAccessorFactory : [ObAccessorFactory] create tenant accessor failed, error message:[obsdk] init ob connector failed, connectProperties=ConnectProperties(connectionMode=direct, address=192.168.9.62, port=2881, obsAddrList=[ObServerAddr(address=192.168.9.65, port=2881), ObServerAddr(address=192.168.9.64, port=2881), ObServerAddr(address=192.168.9.63, port=2881), ObServerAddr(address=192.168.9.62, port=2881)], username=root, tenantName=sys, clusterName=sgkydb, obClusterId=1741231014, proxy=null, odpSocketConfig=null, vpcId=1, compatibilityMode=MYSQL, database=oceanbase), cause:java.sql.SQLNonTransientConnectionException: Could not connect to HostAddress{host='192.168.9.62', port=2881}. Connection refused (Connection refused) 2025-03-06 16:45:20.868 ERROR 2287169 --- [manual-subtask-executor14,9a037d85adf59289,bbbcf62ec8d8a815] c.o.o.c.t.e.c.w.subtask.SubtaskExecutor : Connection refused (Connection refused) java.net.ConnectException: Connection refused (Connection refused) at java.net.PlainSocketImpl.socketConnect(Native Method) at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350) at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206) at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188) at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392) at java.net.Socket.connect(Socket.java:607) at com.oceanbase.jdbc.internal.protocol.AbstractConnectProtocol.createSocket(AbstractConnectProtocol.java:286) at com.oceanbase.jdbc.internal.protocol.AbstractConnectProtocol.createConnection(AbstractConnectProtocol.java:561) at com.oceanbase.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1732) at com.oceanbase.jdbc.internal.util.Utils.retrieveProxy(Utils.java:1434) at com.oceanbase.jdbc.OceanBaseConnection.newConnection(OceanBaseConnection.java:409) at com.oceanbase.jdbc.Driver.connect(Driver.java:93) 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.init(DruidDataSource.java:927) at com.oceanbase.ocp.obsdk.connector.impl.AbstractConnector.init(AbstractConnector.java:95) at com.oceanbase.ocp.obsdk.connector.impl.DefaultConnector.init(DefaultConnector.java:14) at com.oceanbase.ocp.obsdk.connector.ObConnectors.lambda$newObConnector$1(ObConnectors.java:254) at com.oceanbase.ocp.common.trace.TraceDecorator.lambda$decorate$1(TraceDecorator.java:49) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:750) Set state for subtask: 497, operation:RETRY, state: FAILED 2025-03-06 16:49:14.042 INFO 2287169 --- [manual-subtask-executor14,9a037d85adf59289,64b227718041faa3] c.o.ocp.service.iam.user.UserService : user 100 login with organization 10000000 2025-03-06 16:49:14.045 INFO 2287169 --- [manual-subtask-executor14,9a037d85adf59289,64b227718041faa3] c.o.o.c.t.e.runner.JavaSubtaskRunner : Retry subtask, id=497, context=Context{parallelIdx=-1, stringMap={old_config_url=http://192.168.9.61:8080/services?Action=ObRootServiceInfo&User_ID=alibaba&UID=ocpmaster&ObRegion=sgkydb, ob_log_disk_path=/data/log1, primary_root_sys_password=xxx task_instance_id=195, agent_async_task_token_map={"504":"d76ef643-a56a-44a0-b57e-17509e0a9cf6"}, task_operation=retry, ob_run_path=/opt/oceanbase/oceanbase, cluster_type=PRIMARY, ob_install_path=/opt/oceanbase/oceanbase, obproxy_proxyro_username=proxyro, ob_sql_port=2881, cluster_id=5, operation_scope=Cluster, ob_svr_port=2882, sub_task_instance_name=Create resource manager for default user, sub_task_instance_id=497, cluster_version=4.3.5.0, cluster_name=sgkydb, target_server_status=RUNNING, mix_rpm_names={"zone1":"oceanbase-ce-4.3.5.0-100000202024123117.el7.x86_64.rpm"}, startup_option_string=large_query_threshold=600s,max_syslog_file_count=300,enable_syslog_recycle=1,enable_cgroup=false,enable_record_trace_log=false, subtask_splitter=host_ids, ob_version=4.3.5.0, service_name=sgkydb:1741231014, target_zone_status=RUNNING, ob_cluster_id=1741231014, OLD_PROXYRO_password=xxx zone1.idc=default_idc, service_type=OB_CLUSTER, obproxy_proxyro_password=xxx root_sys_password=xxx dep_rpm_names={"zone1":["oceanbase-ce-libs-4.3.5.0-100000202024123117.el7.x86_64.rpm","oceanbase-ce-utils-4.3.5.0-100000202024123117.el7.x86_64.rpm"]}, connection_mode=direct, ob_run_user=root, target_cluster_status=RUNNING, latest_execution_start_time=2025-03-06T16:49:13.955+08:00, ob_data_disk_path=/data/1, mix_obs_rpm={}}, listMap={root_servers=[2], server_ids=[14, 15, 16, 17], host_ids=[2, 3, 4, 5], zone1.host_ids=[2, 3, 4, 5], zone_names=[zone1], ob_connect_address_list=[192.168.9.62:2881]}}, executor=192.168.9.61 2025-03-06 16:49:14.048 INFO 2287169 --- [manual-subtask-executor14,9a037d85adf59289,64b227718041faa3] .CreateResourceManagerForDefaultUserTask : do nothing when rollback 2025-03-06 16:49:14.117 INFO 2287169 --- [manual-subtask-executor14,9a037d85adf59289,64b227718041faa3] c.o.o.obsdk.connector.ObConnectorHolder : [obsdk] no ob connector found in holder, key=ObConnectorKey(connectionMode=direct, clusterName=sgkydb, obClusterId=1741231014, tenantName=sys, username=root, address=192.168.9.63, port=2881, database=oceanbase) 2025-03-06 16:49:14.120 INFO 2287169 --- [manual-subtask-executor14,9a037d85adf59289,64b227718041faa3] c.o.o.obsdk.connector.ObConnectorHolder : [obsdk] no ob connector found in holder, key=ObConnectorKey(connectionMode=direct, clusterName=sgkydb, obClusterId=1741231014, tenantName=sys, username=root, address=192.168.9.64, port=2881, database=oceanbase) 2025-03-06 16:49:14.122 INFO 2287169 --- [manual-subtask-executor14,9a037d85adf59289,64b227718041faa3] c.o.o.obsdk.connector.ObConnectorHolder : [obsdk] no ob connector found in holder, key=ObConnectorKey(connectionMode=direct, clusterName=sgkydb, obClusterId=1741231014, tenantName=sys, username=root, address=192.168.9.65, port=2881, database=oceanbase) 2025-03-06 16:49:14.123 INFO 2287169 --- [manual-subtask-executor14,9a037d85adf59289,64b227718041faa3] c.o.o.obsdk.connector.ObConnectorHolder : [obsdk] no ob connector found in holder, key=ObConnectorKey(connectionMode=direct, clusterName=sgkydb, obClusterId=1741231014, tenantName=sys, username=root, address=192.168.9.62, port=2881, database=oceanbase) 2025-03-06 16:49:14.126 INFO 2287169 --- [manual-subtask-executor14,9a037d85adf59289,64b227718041faa3] c.o.ocp.obsdk.connector.ObConnectors : [obsdk] create new ob connector, connectProperties=ConnectProperties(connectionMode=direct, address=null, port=null, obsAddrList=[ObServerAddr(address=192.168.9.63, port=2881), ObServerAddr(address=192.168.9.64, port=2881), ObServerAddr(address=192.168.9.65, port=2881), ObServerAddr(address=192.168.9.62, port=2881)], username=root, tenantName=sys, clusterName=sgkydb, obClusterId=1741231014, proxy=null, odpSocketConfig=null, vpcId=1, compatibilityMode=MYSQL, database=oceanbase) 2025-03-06 16:49:14.134 ERROR 2287169 --- [manual-subtask-executor14,9a037d85adf59289,64b227718041faa3] c.o.ocp.obsdk.connector.ObConnectors : [obsdk] init ob connector failed, connectProperties=ConnectProperties(connectionMode=direct, address=192.168.9.63, port=2881, obsAddrList=[ObServerAddr(address=192.168.9.63, port=2881), ObServerAddr(address=192.168.9.64, port=2881), ObServerAddr(address=192.168.9.65, port=2881), ObServerAddr(address=192.168.9.62, port=2881)], username=root, tenantName=sys, clusterName=sgkydb, obClusterId=1741231014, proxy=null, odpSocketConfig=null, vpcId=1, compatibilityMode=MYSQL, database=oceanbase), cause:java.sql.SQLTransientConnectionException: Could not connect to 192.168.9.63:2881 : (conn=3221804431) RPC post error 2025-03-06 16:49:14.137 WARN 2287169 --- [manual-subtask-executor14,9a037d85adf59289,64b227718041faa3] c.o.ocp.obsdk.connector.ObConnectors : [obsdk] try to create ob connector of 'direct' mode failed, observer addr:ObServerAddr(address=192.168.9.63, port=2881), message:[obsdk] init ob connector failed, connectProperties=ConnectProperties(connectionMode=direct, address=192.168.9.63, port=2881, obsAddrList=[ObServerAddr(address=192.168.9.63, port=2881), ObServerAddr(address=192.168.9.64, port=2881), ObServerAddr(address=192.168.9.65, port=2881), ObServerAddr(address=192.168.9.62, port=2881)], username=root, tenantName=sys, clusterName=sgkydb, obClusterId=1741231014, proxy=null, odpSocketConfig=null, vpcId=1, compatibilityMode=MYSQL, database=oceanbase), cause:java.sql.SQLTransientConnectionException: Could not connect to 192.168.9.63:2881 : (conn=3221804431) RPC post error 2025-03-06 16:49:14.146 ERROR 2287169 --- [manual-subtask-executor14,9a037d85adf59289,64b227718041faa3] c.o.ocp.obsdk.connector.ObConnectors : [obsdk] init ob connector failed, connectProperties=ConnectProperties(connectionMode=direct, address=192.168.9.64, port=2881, obsAddrList=[ObServerAddr(address=192.168.9.63, port=2881), ObServerAddr(address=192.168.9.64, port=2881), ObServerAddr(address=192.168.9.65, port=2881), ObServerAddr(address=192.168.9.62, port=2881)], username=root, tenantName=sys, clusterName=sgkydb, obClusterId=1741231014, proxy=null, odpSocketConfig=null, vpcId=1, compatibilityMode=MYSQL, database=oceanbase), cause:java.sql.SQLTransientConnectionException: Could not connect to 192.168.9.64:2881 : (conn=3222062734) RPC post error 2025-03-06 16:49:14.149 WARN 2287169 --- [manual-subtask-executor14,9a037d85adf59289,64b227718041faa3] c.o.ocp.obsdk.connector.ObConnectors : [obsdk] try to create ob connector of 'direct' mode failed, observer addr:ObServerAddr(address=192.168.9.64, port=2881), message:[obsdk] init ob connector failed, connectProperties=ConnectProperties(connectionMode=direct, address=192.168.9.64, port=2881, obsAddrList=[ObServerAddr(address=192.168.9.63, port=2881), ObServerAddr(address=192.168.9.64, port=2881), ObServerAddr(address=192.168.9.65, port=2881), ObServerAddr(address=192.168.9.62, port=2881)], username=root, tenantName=sys, clusterName=sgkydb, obClusterId=1741231014, proxy=null, odpSocketConfig=null, vpcId=1, compatibilityMode=MYSQL, database=oceanbase), cause:java.sql.SQLTransientConnectionException: Could not connect to 192.168.9.64:2881 : (conn=3222062734) RPC post error 2025-03-06 16:49:14.157 ERROR 2287169 --- [manual-subtask-executor14,9a037d85adf59289,64b227718041faa3] c.o.ocp.obsdk.connector.ObConnectors : [obsdk] init ob connector failed, connectProperties=ConnectProperties(connectionMode=direct, address=192.168.9.65, port=2881, obsAddrList=[ObServerAddr(address=192.168.9.63, port=2881), ObServerAddr(address=192.168.9.64, port=2881), ObServerAddr(address=192.168.9.65, port=2881), ObServerAddr(address=192.168.9.62, port=2881)], username=root, tenantName=sys, clusterName=sgkydb, obClusterId=1741231014, proxy=null, odpSocketConfig=null, vpcId=1, compatibilityMode=MYSQL, database=oceanbase), cause:java.sql.SQLTransientConnectionException: Could not connect to 192.168.9.65:2881 : (conn=3222326104) RPC post error 2025-03-06 16:49:14.159 WARN 2287169 --- [manual-subtask-executor14,9a037d85adf59289,64b227718041faa3] c.o.ocp.obsdk.connector.ObConnectors : [obsdk] try to create ob connector of 'direct' mode failed, observer addr:ObServerAddr(address=192.168.9.65, port=2881), message:[obsdk] init ob connector failed, connectProperties=ConnectProperties(connectionMode=direct, address=192.168.9.65, port=2881, obsAddrList=[ObServerAddr(address=192.168.9.63, port=2881), ObServerAddr(address=192.168.9.64, port=2881), ObServerAddr(address=192.168.9.65, port=2881), ObServerAddr(address=192.168.9.62, port=2881)], username=root, tenantName=sys, clusterName=sgkydb, obClusterId=1741231014, proxy=null, odpSocketConfig=null, vpcId=1, compatibilityMode=MYSQL, database=oceanbase), cause:java.sql.SQLTransientConnectionException: Could not connect to 192.168.9.65:2881 : (conn=3222326104) RPC post error 2025-03-06 16:49:14.165 ERROR 2287169 --- [manual-subtask-executor14,9a037d85adf59289,64b227718041faa3] c.o.ocp.obsdk.connector.ObConnectors : [obsdk] init ob connector failed, connectProperties=ConnectProperties(connectionMode=direct, address=192.168.9.62, port=2881, obsAddrList=[ObServerAddr(address=192.168.9.63, port=2881), ObServerAddr(address=192.168.9.64, port=2881), ObServerAddr(address=192.168.9.65, port=2881), ObServerAddr(address=192.168.9.62, port=2881)], username=root, tenantName=sys, clusterName=sgkydb, obClusterId=1741231014, proxy=null, odpSocketConfig=null, vpcId=1, compatibilityMode=MYSQL, database=oceanbase), cause:java.sql.SQLNonTransientConnectionException: Could not connect to HostAddress{host='192.168.9.62', port=2881}. Connection refused (Connection refused) 2025-03-06 16:49:14.167 WARN 2287169 --- [manual-subtask-executor14,9a037d85adf59289,64b227718041faa3] c.o.ocp.obsdk.connector.ObConnectors : [obsdk] try to create ob connector of 'direct' mode failed, observer addr:ObServerAddr(address=192.168.9.62, port=2881), message:[obsdk] init ob connector failed, connectProperties=ConnectProperties(connectionMode=direct, address=192.168.9.62, port=2881, obsAddrList=[ObServerAddr(address=192.168.9.63, port=2881), ObServerAddr(address=192.168.9.64, port=2881), ObServerAddr(address=192.168.9.65, port=2881), ObServerAddr(address=192.168.9.62, port=2881)], username=root, tenantName=sys, clusterName=sgkydb, obClusterId=1741231014, proxy=null, odpSocketConfig=null, vpcId=1, compatibilityMode=MYSQL, database=oceanbase), cause:java.sql.SQLNonTransientConnectionException: Could not connect to HostAddress{host='192.168.9.62', port=2881}. Connection refused (Connection refused) 2025-03-06 16:49:14.169 ERROR 2287169 --- [manual-subtask-executor14,9a037d85adf59289,64b227718041faa3] 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=192.168.9.62, port=2881, obsAddrList=[ObServerAddr(address=192.168.9.63, port=2881), ObServerAddr(address=192.168.9.64, port=2881), ObServerAddr(address=192.168.9.65, port=2881), ObServerAddr(address=192.168.9.62, port=2881)], username=root, tenantName=sys, clusterName=sgkydb, obClusterId=1741231014, proxy=null, odpSocketConfig=null, vpcId=1, compatibilityMode=MYSQL, database=oceanbase), cause:java.sql.SQLNonTransientConnectionException: Could not connect to HostAddress{host='192.168.9.62', port=2881}. Connection refused (Connection refused) 2025-03-06 16:49:14.171 ERROR 2287169 --- [manual-subtask-executor14,9a037d85adf59289,64b227718041faa3] c.o.o.s.o.o.factory.ObAccessorFactory : [ObAccessorFactory] create tenant accessor failed, error message:[obsdk] init ob connector failed, connectProperties=ConnectProperties(connectionMode=direct, address=192.168.9.62, port=2881, obsAddrList=[ObServerAddr(address=192.168.9.63, port=2881), ObServerAddr(address=192.168.9.64, port=2881), ObServerAddr(address=192.168.9.65, port=2881), ObServerAddr(address=192.168.9.62, port=2881)], username=root, tenantName=sys, clusterName=sgkydb, obClusterId=1741231014, proxy=null, odpSocketConfig=null, vpcId=1, compatibilityMode=MYSQL, database=oceanbase), cause:java.sql.SQLNonTransientConnectionException: Could not connect to HostAddress{host='192.168.9.62', port=2881}. Connection refused (Connection refused) 2025-03-06 16:49:14.256 ERROR 2287169 --- [manual-subtask-executor14,9a037d85adf59289,64b227718041faa3] c.o.o.c.t.e.c.w.subtask.SubtaskExecutor : Connection refused (Connection refused) java.net.ConnectException: Connection refused (Connection refused) at java.net.PlainSocketImpl.socketConnect(Native Method) at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350) at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206) at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188) at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392) at java.net.Socket.connect(Socket.java:607) at com.oceanbase.jdbc.internal.protocol.AbstractConnectProtocol.createSocket(AbstractConnectProtocol.java:286) at com.oceanbase.jdbc.internal.protocol.AbstractConnectProtocol.createConnection(AbstractConnectProtocol.java:561) at com.oceanbase.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1732) at com.oceanbase.jdbc.internal.util.Utils.retrieveProxy(Utils.java:1434) at com.oceanbase.jdbc.OceanBaseConnection.newConnection(OceanBaseConnection.java:409) at com.oceanbase.jdbc.Driver.connect(Driver.java:93) 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.init(DruidDataSource.java:927) at com.oceanbase.ocp.obsdk.connector.impl.AbstractConnector.init(AbstractConnector.java:95) at com.oceanbase.ocp.obsdk.connector.impl.DefaultConnector.init(DefaultConnector.java:14) at com.oceanbase.ocp.obsdk.connector.ObConnectors.lambda$newObConnector$1(ObConnectors.java:254) at com.oceanbase.ocp.common.trace.TraceDecorator.lambda$decorate$1(TraceDecorator.java:49) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:750) Set state for subtask: 497, operation:RETRY, state: FAILED