2025-01-11 09:14:41.650 INFO 6617 --- [manual-subtask-executor16,effc967cb8fe8b3e,63fec6be881dadb3] c.o.o.c.t.e.runner.JavaSubtaskRunner : Run subtask, id=170, context=Context{parallelIdx=-1, stringMap={old_config_url=http://_my_ocp_addr_:8080/services?Action=ObRootServiceInfo&User_ID=alibaba&UID=ocpmaster&ObRegion=scxx, ob_log_disk_path=/root/data/log, primary_root_sys_password=xxx task_instance_id=66, agent_async_task_token_map={"142":"613455e7-55df-4a18-aa2a-469e305e9c6a"}, 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=2, operation_scope=Cluster, ob_svr_port=2882, sub_task_instance_name=Create resource manager for default user, sub_task_instance_id=170, cluster_version=4.3.5.0, cluster_name=scxx, 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=true,enable_record_trace_log=false, tenant_name=scxx, subtask_splitter=host_ids, ob_version=4.3.5.0, service_name=scxx:1736549857, target_zone_status=RUNNING, ob_cluster_id=1736549857, 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, tenant_mode=MYSQL, ob_run_user=root, target_cluster_status=RUNNING, latest_execution_start_time=2025-01-11T09:14:41.618+08:00, ob_data_disk_path=/root/data, mix_obs_rpm={}}, listMap={root_servers=[2], server_ids=[2], host_ids=[2], zone1.host_ids=[2], zone_names=[zone1], ob_connect_address_list=[_my_ob_addr_:2881]}}, executor=_my_ocp_addr_ 2025-01-11 09:14:41.732 INFO 6617 --- [manual-subtask-executor16,effc967cb8fe8b3e,63fec6be881dadb3] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2025-01-11 09:14:41.739 INFO 6617 --- [manual-subtask-executor16,effc967cb8fe8b3e,63fec6be881dadb3] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: SELECT CONSUMER_GROUP FROM DBA_RSRC_CONSUMER_GROUPS 2025-01-11 09:14:41.749 INFO 6617 --- [manual-subtask-executor16,effc967cb8fe8b3e,63fec6be881dadb3] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2025-01-11 09:14:41.755 INFO 6617 --- [manual-subtask-executor16,effc967cb8fe8b3e,63fec6be881dadb3] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: SELECT PLAN FROM DBA_RSRC_PLANS 2025-01-11 09:14:41.793 INFO 6617 --- [manual-subtask-executor16,effc967cb8fe8b3e,63fec6be881dadb3] c.o.o.s.o.o.f.ConnectPropertiesBuilder : get credential from obsdk context, clusterName=scxx, tenantName=sys, dbUser=root 2025-01-11 09:14:41.799 INFO 6617 --- [manual-subtask-executor16,effc967cb8fe8b3e,63fec6be881dadb3] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2025-01-11 09:14:41.804 INFO 6617 --- [manual-subtask-executor16,effc967cb8fe8b3e,63fec6be881dadb3] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: SELECT CONSUMER_GROUP FROM DBA_RSRC_CONSUMER_GROUPS 2025-01-11 09:14:41.810 INFO 6617 --- [manual-subtask-executor16,effc967cb8fe8b3e,63fec6be881dadb3] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2025-01-11 09:14:41.816 INFO 6617 --- [manual-subtask-executor16,effc967cb8fe8b3e,63fec6be881dadb3] 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-01-11 09:14:41.827 INFO 6617 --- [manual-subtask-executor16,effc967cb8fe8b3e,63fec6be881dadb3] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2025-01-11 09:14:41.838 INFO 6617 --- [manual-subtask-executor16,effc967cb8fe8b3e,63fec6be881dadb3] 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-01-11 09:14:41.949 ERROR 6617 --- [manual-subtask-executor16,effc967cb8fe8b3e,63fec6be881dadb3] com.alibaba.druid.pool.DruidDataSource : recyle error java.sql.SQLSyntaxErrorException: (conn=3221493440) 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(DefaultUserResourceManagerServiceIm pl.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-01-11 09:14:46.969 WARN 6617 --- [manual-subtask-executor16,effc967cb8fe8b3e,63fec6be881dadb3] com.alibaba.druid.pool.DruidDataSource : get connection timeout retry : 1 2025-01-11 09:14:51.980 WARN 6617 --- [manual-subtask-executor16,effc967cb8fe8b3e,63fec6be881dadb3] 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 5001, 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.TenantResourceServiceImp l.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 5001, 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 5001, active 0, maxActive 20, creating 0, createErrorCount 3 at com.alibaba.druid.pool.DruidDataSource.getConnectionIntern al(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='_my_ob_addr_', port=2881}. connect timed out 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.SocketTimeoutException: connect timed out at java.net.PlainSocketImpl.sock etConnect(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-01-11 09:14:57.002 WARN 6617 --- [manual-subtask-executor16,effc967cb8fe8b3e,63fec6be881dadb3] com.alibaba.druid.pool.DruidDataSource : get connection timeout retry : 1 2025-01-11 09:15:02.007 WARN 6617 --- [manual-subtask-executor16,effc967cb8fe8b3e,63fec6be881dadb3] 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.AbstractResourceAcces sor.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: wait m illis 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='_my_ob_addr_', port=2881}. connect timed out 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$CreateConnectionThre ad.run(DruidDataSource.java:2838) Caused by: java.net.SocketTimeoutException: connect timed out 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-01-11 09:15:02.022 WARN 6617 --- [manual-subtask-executor16,effc967cb8fe8b3e,63fec6be881dadb3] 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=3221493440) unexpected end of stream, read 0 bytes from 31 (socket was closed by server); nested exception is java.sql.SQLNonTransientConnectionException: (conn=3221493440) unexpected end of stream, read 0 bytes from 31 (socket was closed by server)] 2025-01-11 09:15:07.026 WARN 6617 --- [manual-subtask-executor16,effc967cb8fe8b3e,63fec6be881dadb3] com.alibaba.druid.pool.DruidDataSource : get connection timeout retry : 1 2025-01-11 09:15:12.032 WARN 6617 --- [manual-subtask-executor16,effc967cb8fe8b3e,63fec6be881dadb3] c.o.ocp.obsdk.connector.ConnectTemplate : Failed to query last trace info:Failed to obtain JDBC Connection; nested exception is com.alibaba.druid.pool.GetConnectionTimeoutException: wait millis 5000, active 0, maxActive 20, creating 0, createErrorCount 3 2025-01-11 09:15:12.089 INFO 6617 --- [manual-subtask-executor16,effc967cb8fe8b3e,63fec6be881dadb3] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] slow query, durationMillis=30251, sql=call DBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP (CONSUMER_GROUP => 'ocp_monitor_group', COMMENT => 'reserve thread for default user'); 2025-01-11 09:15:12.097 ERROR 6617 --- [manual-subtask-executor16,effc967cb8fe8b3e,63fec6be881dadb3] 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(Abstrac tResourceAccessor.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: 170, operation:EXECUTE, state: FAILED 2025-01-11 09:20:07.092 INFO 6617 --- [manual-subtask-executor16,effc967cb8fe8b3e,a3f07196ec5685b1] c.o.o.c.t.e.runner.JavaSubtaskRunner : Retry subtask, id=170, context=Context{parallelIdx=-1, stringMap={old_config_url=http://_my_ocp_addr_:8080/services?Action=ObRootServiceInfo&User_ID=alibaba&UID=ocpmaster&ObRegion=scxx, ob_log_disk_path=/root/data/log, primary_root_sys_password=xxx task_instance_id=66, agent_async_task_token_map={"142":"613455e7-55df-4a18-aa2a-469e305e9c6a"}, 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=2, operation_scope=Cluster, ob_svr_port=2882, sub_task_instance_name=Create resource manager for default user, sub_task_instance_id=170, cluster_version=4.3.5.0, cluster_name=scxx, 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=true,enable_record_trace_log=false, tenant_name=scxx, subtask_splitter=host_ids, ob_version=4.3.5.0, service_name=scxx:1736549857, target_zone_status=RUNNING, ob_cluster_id=1736549857, 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, tenant_mode=MYSQL, ob_run_user=root, target_cluster_status=RUNNING, latest_execution_start_time=2025-01-11T09:20:07.068+08:00, ob_data_disk_path=/root/data, mix_obs_rpm={}}, listMap={root_servers=[2], server_ids=[2], host_ids=[2], zone1.host_ids=[2], zone_names=[zone1], ob_connect_address_list=[_my_ob_addr_:2881]}}, executor=_my_ocp_addr_ 2025-01-11 09:20:07.096 INFO 6617 --- [manual-subtask-executor16,effc967cb8fe8b3e,a3f07196ec5685b1] .CreateResourceManagerForDefaultUserTask : do nothing when rollback 2025-01-11 09:20:07.175 INFO 6617 --- [manual-subtask-executor16,effc967cb8fe8b3e,a3f07196ec5685b1] c.o.o.obsdk.connector.ObConnectorHolder : [obsdk] no ob connector found in holder, key=ObConnectorKey(connectionMode=direct, clusterName=scxx, obClusterId=1736549857, tenantName=sys, username=root, address=_my_ob_addr_, port=2881, database=oceanbase) 2025-01-11 09:20:07.178 INFO 6617 --- [manual-subtask-executor16,effc967cb8fe8b3e,a3f07196ec5685b1] c.o.ocp.obsdk.connector.ObConnectors : [obsdk] create new ob connector, connectProperties=ConnectProperties(connectionMode=direct, address=null, port=null, obsAddrList=[ObServerAddr(address=_my_ob_addr_, port=2881)], username=root, tenantName=sys, clusterName=scxx, obClusterId=1736549857, proxy=null, odpSocketConfig=null, vpcId=1, compatibilityMode=MYSQL, database=oceanbase) 2025-01-11 09:20:09.188 ERROR 6617 --- [manual-subtask-executor16,effc967cb8fe8b3e,a3f07196ec5685b1] c.o.ocp.obsdk.connector.ObConnectors : [obsdk] init ob connector failed, connectProperties=ConnectProperties(connectionMode=direct, address=_my_ob_addr_, port=2881, obsAddrList=[ObServerAddr(address=_my_ob_addr_, port=2881)], username=root, tenantName=sys, clusterName=scxx, obClusterId=1736549857, proxy=null, odpSocketConfig=null, vpcId=1, compatibilityMode=MYSQL, database=oceanbase), cause:java.sql.SQLNonTransientConnectionException: Could not connect to HostAddress{host='_my_ob_addr_', port=2881}. connect timed out 2025-01-11 09:20:09.197 WARN 6617 --- [manual-subtask-executor16,effc967cb8fe8b3e,a3f07196ec5685b1] c.o.ocp.obsdk.connector.ObConnectors : [obsdk] try to create ob connector of 'direct' mode failed, observer addr:ObServerAddr(address=_my_ob_addr_, port=2881), message:[obsdk] init ob connector failed, connectProperties=ConnectProperties(connectionMode=direct, address=_my_ob_addr_, port=2881, obsAddrList=[ObServerAddr(address=_my_ob_addr_, port=2881)], username=root, tenantName=sys, clusterName=scxx, obClusterId=1736549857, proxy=null, odpSocketConfig=null, vpcId=1, compatibilityMode=MYSQL, database=oceanbase), cause:java.sql.SQLNonTransientConnectionException: Could not connect to HostAddress{host='_my_ob_addr_', port=2881}. connect timed out 2025-01-11 09:20:09.203 ERROR 6617 --- [manual-subtask-executor16,effc967cb8fe8b3e,a3f07196ec5685b1] 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=_my_ob_addr_, port=2881, obsAddrList=[ObServerAddr(address=_my_ob_addr_, port=2881)], username=root, tenantName=sys, clusterName=scxx, obClusterId=1736549857, proxy=null, odpSocketConfig=null, vpcId=1, compatibilityMode=MYSQL, database=oceanbase), cause:java.sql.SQLNonTransientConnectionException: Could not connect to HostAddress{host='_my_ob_addr_', port=2881}. connect timed out 2025-01-11 09:20:09.206 ERROR 6617 --- [manual-subtask-executor16,effc967cb8fe8b3e,a3f07196ec5685b1] 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=_my_ob_addr_, port=2881, obsAddrList=[ObServerAddr(address=_my_ob_addr_, port=2881)], username=root, tenantName=sys, clusterName=scxx, obClusterId=1736549857, proxy=null, odpSocketConfig=null, vpcId=1, compatibilityMode=MYSQL, database=oceanbase), cause:java.sql.SQLNonTransientConnectionException: Could not connect to HostAddress{host='_my_ob_addr_', port=2881}. connect timed out 2025-01-11 09:20:09.210 ERROR 6617 --- [manual-subtask-executor16,effc967cb8fe8b3e,a3f07196ec5685b1] c.o.o.c.t.e.c.w.subtask.SubtaskExecutor : connect timed out java.net.SocketTimeoutException: connect timed out 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.ThreadPoolExecuto r$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:750) Set state for subtask: 170, operation:RETRY, state: FAILED