2025-01-17 21:13:54.169 INFO 1432603 --- [manual-subtask-executor15,f384dc251dbc0061,9aca6d572c156a01] c.o.ocp.service.iam.user.UserService : user 100 login with organization 10000000 2025-01-17 21:13:54.171 INFO 1432603 --- [manual-subtask-executor15,f384dc251dbc0061,9aca6d572c156a01] c.o.o.c.t.e.runner.JavaSubtaskRunner : Run subtask, id=11030566, context=Context{parallelIdx=0, stringMap={cluster_version=4.2.2.0, scob.1736924642.watched_parameters={"server_permanent_offline_time":"3600s","enable_rebalance":"{\"door\":\"True\",\"appdb\":\"True\",\"coupon\":\"True\",\"campus\":\"True\",\"payment\":\"True\",\"sys\":\"True\",\"yeguan\":\"True\"}","enable_rereplication":"True"}, cluster_name=scob, subtask_splitter=primary_first_cluster_ids, primary_root_sys_password=xxx task_instance_id=11026616, task_operation=execute, target_version=4.2.2.1-101000012024030709, cluster_id=2000001, ocpagent_service_name=agent, operating_system=el7, target_cluster_status=RUNNING, latest_execution_start_time=2025-01-17T21:13:54.163+08:00, sub_task_instance_name=Execute upgrade checker script, watched_scenario=UPGRADE, sub_task_instance_id=11030566, primary_cluster_id=2000001}, listMap={1736924642.scob.zone_names=[zone1, zone2, zone3], standby_cluster_ids=[], 1736924642.scob.zone3.host_ids=[3000001], 1736924642.scob.zone2.server_ids=[2000001], cluster_ids=[2000001], primary_first_cluster_ids=[2000001], 1736924642.scob.zone1.server_ids=[2000002], standby_first_cluster_ids=[2000001], 1736924642.scob.zone2.host_ids=[2000002], staged_versions=[4.2.2.1-101000012024030709], 1736924642.scob.zone1.host_ids=[2000004], 1736924642.scob.zone3.server_ids=[2000003], direct_upgrade_versions=[]}}, executor=10.2.117.13 2025-01-17 21:13:54.173 INFO 1432603 --- [manual-subtask-executor15,f384dc251dbc0061,9aca6d572c156a01] c.o.o.obsdk.connector.ObConnectorHolder : [obsdk] invalidate ob connector, clusterName=scob 2025-01-17 21:13:54.178 INFO 1432603 --- [manual-subtask-executor15,f384dc251dbc0061,9aca6d572c156a01] c.o.o.obsdk.connector.ObConnectorHolder : [obsdk] invalidate ob connector, key=ObConnectorKey(connectionMode=direct, clusterName=scob, obClusterId=1736924642, tenantName=sys, username=root, address=10.3.1.5, port=2881, database=oceanbase) 2025-01-17 21:13:54.179 INFO 1432603 --- [manual-subtask-executor15,f384dc251dbc0061,9aca6d572c156a01] c.o.o.obsdk.connector.ObConnectorHolder : [obsdk] ob connector is evicted from holder's cache. cause=EXPLICIT, key=ObConnectorKey(connectionMode=direct, clusterName=scob, obClusterId=1736924642, tenantName=sys, username=root, address=10.3.1.5, port=2881, database=oceanbase), size=21 2025-01-17 21:13:54.181 INFO 1432603 --- [manual-subtask-executor15,f384dc251dbc0061,9aca6d572c156a01] com.alibaba.druid.pool.DruidDataSource : {dataSource-618} closing ... 2025-01-17 21:13:54.185 INFO 1432603 --- [manual-subtask-executor15,f384dc251dbc0061,9aca6d572c156a01] com.alibaba.druid.pool.DruidDataSource : {dataSource-618} closed 2025-01-17 21:13:54.186 INFO 1432603 --- [manual-subtask-executor15,f384dc251dbc0061,9aca6d572c156a01] c.o.o.obsdk.connector.ObConnectorHolder : [obsdk] invalidate ob connector, key=ObConnectorKey(connectionMode=direct, clusterName=scob, obClusterId=1736924642, tenantName=sys, username=ocp_monitor, address=10.3.1.6, port=2881, database=oceanbase) 2025-01-17 21:13:54.187 INFO 1432603 --- [manual-subtask-executor15,f384dc251dbc0061,9aca6d572c156a01] c.o.o.obsdk.connector.ObConnectorHolder : [obsdk] ob connector is evicted from holder's cache. cause=EXPLICIT, key=ObConnectorKey(connectionMode=direct, clusterName=scob, obClusterId=1736924642, tenantName=sys, username=ocp_monitor, address=10.3.1.6, port=2881, database=oceanbase), size=20 2025-01-17 21:13:54.188 INFO 1432603 --- [manual-subtask-executor15,f384dc251dbc0061,9aca6d572c156a01] com.alibaba.druid.pool.DruidDataSource : {dataSource-616} closing ... 2025-01-17 21:13:54.221 INFO 1432603 --- [manual-subtask-executor15,f384dc251dbc0061,9aca6d572c156a01] com.alibaba.druid.pool.DruidDataSource : {dataSource-616} closed 2025-01-17 21:13:54.223 INFO 1432603 --- [manual-subtask-executor15,f384dc251dbc0061,9aca6d572c156a01] o.o.s.t.b.c.ExecUpgradeCheckerScriptTask : execute upgrade_checker.py, clusterId=2000001, version=4.2.2.1-101000012024030709 2025-01-17 21:13:54.236 INFO 1432603 --- [manual-subtask-executor15,f384dc251dbc0061,9aca6d572c156a01] c.o.o.obsdk.connector.ObConnectorHolder : [obsdk] no ob connector found in holder, key=ObConnectorKey(connectionMode=direct, clusterName=scob, obClusterId=1736924642, tenantName=sys, username=root, address=10.3.1.6, port=2881, database=oceanbase) 2025-01-17 21:13:54.237 INFO 1432603 --- [manual-subtask-executor15,f384dc251dbc0061,9aca6d572c156a01] c.o.o.obsdk.connector.ObConnectorHolder : [obsdk] no ob connector found in holder, key=ObConnectorKey(connectionMode=direct, clusterName=scob, obClusterId=1736924642, tenantName=sys, username=root, address=10.3.1.5, port=2881, database=oceanbase) 2025-01-17 21:13:54.238 INFO 1432603 --- [manual-subtask-executor15,f384dc251dbc0061,9aca6d572c156a01] c.o.o.obsdk.connector.ObConnectorHolder : [obsdk] no ob connector found in holder, key=ObConnectorKey(connectionMode=direct, clusterName=scob, obClusterId=1736924642, tenantName=sys, username=root, address=10.3.1.7, port=2881, database=oceanbase) 2025-01-17 21:13:54.239 INFO 1432603 --- [manual-subtask-executor15,f384dc251dbc0061,9aca6d572c156a01] c.o.ocp.obsdk.connector.ObConnectors : [obsdk] create new ob connector, connectProperties=ConnectProperties(connectionMode=direct, address=null, port=null, obsAddrList=[ObServerAddr(address=10.3.1.6, port=2881), ObServerAddr(address=10.3.1.5, port=2881), ObServerAddr(address=10.3.1.7, port=2881)], username=root, tenantName=sys, clusterName=scob, obClusterId=1736924642, proxy=null, odpSocketConfig=null, vpcId=1, compatibilityMode=MYSQL, database=oceanbase) 2025-01-17 21:13:54.309 INFO 1432603 --- [manual-subtask-executor15,f384dc251dbc0061,9aca6d572c156a01] c.o.ocp.obsdk.connector.ObConnectors : [obsdk] create new ob connector success 2025-01-17 21:13:54.317 INFO 1432603 --- [manual-subtask-executor15,f384dc251dbc0061,9aca6d572c156a01] c.o.o.s.o.o.f.ConnectPropertiesBuilder : get credential from obsdk context, clusterName=scob, tenantName=sys, dbUser=root 2025-01-17 21:13:54.334 INFO 1432603 --- [manual-subtask-executor15,f384dc251dbc0061,9aca6d572c156a01] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2025-01-17 21:13:54.343 INFO 1432603 --- [manual-subtask-executor15,f384dc251dbc0061,9aca6d572c156a01] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: SELECT `svr_ip`, `svr_port`, `zone`, `role` FROM `CDB_OB_LS_LOCATIONS` WHERE `tenant_id` = 1 AND `ls_id` = 1 2025-01-17 21:13:54.380 INFO 1432603 --- [manual-subtask-executor15,f384dc251dbc0061,9aca6d572c156a01] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2025-01-17 21:13:54.389 INFO 1432603 --- [manual-subtask-executor15,f384dc251dbc0061,9aca6d572c156a01] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: select version() 2025-01-17 21:13:54.408 INFO 1432603 --- [manual-subtask-executor15,f384dc251dbc0061,9aca6d572c156a01] c.o.o.obsdk.connector.ObConnectorHolder : [obsdk] no ob connector found in holder, key=ObConnectorKey(connectionMode=direct, clusterName=null, obClusterId=null, tenantName=sys, username=root, address=10.3.1.5, port=2881, database=oceanbase) 2025-01-17 21:13:54.410 INFO 1432603 --- [manual-subtask-executor15,f384dc251dbc0061,9aca6d572c156a01] c.o.ocp.obsdk.connector.ObConnectors : [obsdk] create new ob connector, connectProperties=ConnectProperties(connectionMode=direct, address=10.3.1.5, port=2881, obsAddrList=null, username=root, tenantName=sys, clusterName=null, obClusterId=null, proxy=null, odpSocketConfig=null, vpcId=1, compatibilityMode=MYSQL, database=oceanbase) 2025-01-17 21:13:54.482 INFO 1432603 --- [manual-subtask-executor15,f384dc251dbc0061,9aca6d572c156a01] c.o.ocp.obsdk.connector.ObConnectors : [obsdk] create new ob connector success 2025-01-17 21:13:54.492 INFO 1432603 --- [manual-subtask-executor15,f384dc251dbc0061,9aca6d572c156a01] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2025-01-17 21:13:54.501 INFO 1432603 --- [manual-subtask-executor15,f384dc251dbc0061,9aca6d572c156a01] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: select max(value) value from oceanbase.__all_virtual_sys_parameter_stat where name = 'min_observer_version' 2025-01-17 21:13:54.513 INFO 1432603 --- [manual-subtask-executor15,f384dc251dbc0061,9aca6d572c156a01] c.o.o.s.t.b.c.helper.UpgradeTaskHelper : execute script upgrade_checker.py on cluster, clusterId=2000001, obClusterId=1736924642, zone=null, clusterType=PRIMARY, rpmName=oceanbase-ce-4.2.2.1-101000012024030709.el7.x86_64.rpm 2025-01-17 21:13:54.517 INFO 1432603 --- [manual-subtask-executor15,f384dc251dbc0061,9aca6d572c156a01] c.o.o.c.agent.HostAgentServiceImpl : Finding OCP agent: hostId=2000004 2025-01-17 21:13:54.519 INFO 1432603 --- [manual-subtask-executor15,f384dc251dbc0061,9aca6d572c156a01] c.o.o.c.a.p.HostAgentProcessServiceImpl : Getting all OCP agent processes on host 2000004 2025-01-17 21:13:54.531 INFO 1432603 --- [manual-subtask-executor15,f384dc251dbc0061,9aca6d572c156a01] c.o.o.e.internal.template.HttpTemplate : POST request to agent, url:http://10.3.1.5:62888/api/v1/file/exists, request body:GetFileExistsRequest(filePath=rpms/extract/oceanbase-ce-4.2.2.1-101000012024030709.el7.x86_64.rpm/home/admin/oceanbase/etc/upgrade_checker.py), params:null 2025-01-17 21:13:54.549 INFO 1432603 --- [manual-subtask-executor15,f384dc251dbc0061,9aca6d572c156a01] c.o.o.c.h.s.HostOperationServiceImpl : [downloadRpm]: generate agent async task token:1e9351cf-4cbf-4c50-94af-ea78afbff64d 2025-01-17 21:13:54.553 INFO 1432603 --- [manual-subtask-executor15,f384dc251dbc0061,9aca6d572c156a01] c.o.o.c.agent.HostAgentServiceImpl : Finding OCP agent: hostId=2000004 2025-01-17 21:13:54.555 INFO 1432603 --- [manual-subtask-executor15,f384dc251dbc0061,9aca6d572c156a01] c.o.o.c.a.p.HostAgentProcessServiceImpl : Getting all OCP agent processes on host 2000004 2025-01-17 21:13:54.566 INFO 1432603 --- [manual-subtask-executor15,f384dc251dbc0061,9aca6d572c156a01] c.o.o.e.internal.template.HttpTemplate : POST request to agent, url:http://10.3.1.5:62888/api/v1/file/download, request body:DownloadFileRequest(source=RemoteFileAccessInfo(type=URL, url=http://10.2.117.13:8080/api/v2/object-storage/sys-package/oceanbase-ce-4.2.2.1-101000012024030709.el7.x86_64.rpm, path=null), target=rpms/oceanbase-ce-4.2.2.1-101000012024030709.el7.x86_64.rpm, validateChecksum=true, checksum=d68b82169d8efdcdcb44c7f46730ea265085123e), params:null 2025-01-17 21:13:54.582 INFO 1432603 --- [manual-subtask-executor15,f384dc251dbc0061,9aca6d572c156a01] c.o.o.e.internal.template.HttpTemplate : POST request to agent, url:http://10.3.1.5:62888/api/v1/task/status, request body:GetTaskStatusRequest(taskToken=1e9351cf-4cbf-4c50-94af-ea78afbff64d), params:null 2025-01-17 21:13:54.591 INFO 1432603 --- [manual-subtask-executor15,f384dc251dbc0061,9aca6d572c156a01] c.o.o.s.task.util.AgentAsyncTaskHelper : try to request task result(EXECUTE), result:false,null,, 2025-01-17 21:13:54.592 INFO 1432603 --- [manual-subtask-executor15,f384dc251dbc0061,9aca6d572c156a01] c.o.ocp.common.lang.pattern.Retry : wait for 3 seconds 2025-01-17 21:13:57.593 INFO 1432603 --- [manual-subtask-executor15,f384dc251dbc0061,9aca6d572c156a01] c.o.o.e.internal.template.HttpTemplate : POST request to agent, url:http://10.3.1.5:62888/api/v1/task/status, request body:GetTaskStatusRequest(taskToken=1e9351cf-4cbf-4c50-94af-ea78afbff64d), params:null 2025-01-17 21:13:57.606 INFO 1432603 --- [manual-subtask-executor15,f384dc251dbc0061,9aca6d572c156a01] c.o.o.s.task.util.AgentAsyncTaskHelper : try to request task result(EXECUTE), result:false,null,, 2025-01-17 21:13:57.607 INFO 1432603 --- [manual-subtask-executor15,f384dc251dbc0061,9aca6d572c156a01] c.o.ocp.common.lang.pattern.Retry : wait for 3 seconds 2025-01-17 21:14:00.608 INFO 1432603 --- [manual-subtask-executor15,f384dc251dbc0061,9aca6d572c156a01] c.o.o.e.internal.template.HttpTemplate : POST request to agent, url:http://10.3.1.5:62888/api/v1/task/status, request body:GetTaskStatusRequest(taskToken=1e9351cf-4cbf-4c50-94af-ea78afbff64d), params:null 2025-01-17 21:14:00.621 INFO 1432603 --- [manual-subtask-executor15,f384dc251dbc0061,9aca6d572c156a01] c.o.o.s.task.util.AgentAsyncTaskHelper : try to request task result(EXECUTE), result:true,{"path":"rpms/oceanbase-ce-4.2.2.1-101000012024030709.el7.x86_64.rpm"},, 2025-01-17 21:14:00.623 INFO 1432603 --- [manual-subtask-executor15,f384dc251dbc0061,9aca6d572c156a01] c.o.o.c.h.s.HostOperationServiceImpl : [extractFileInRpm]: generate agent async task token:27e30de6-af43-45fe-b486-ad58f59114d1 2025-01-17 21:14:00.627 INFO 1432603 --- [manual-subtask-executor15,f384dc251dbc0061,9aca6d572c156a01] c.o.o.c.agent.HostAgentServiceImpl : Finding OCP agent: hostId=2000004 2025-01-17 21:14:00.629 INFO 1432603 --- [manual-subtask-executor15,f384dc251dbc0061,9aca6d572c156a01] c.o.o.c.a.p.HostAgentProcessServiceImpl : Getting all OCP agent processes on host 2000004 2025-01-17 21:14:00.649 INFO 1432603 --- [manual-subtask-executor15,f384dc251dbc0061,9aca6d572c156a01] c.o.o.e.internal.template.HttpTemplate : POST request to agent, url:http://10.3.1.5:62888/api/v1/package/extract, request body:ExtractPackageRequest(packageFile=rpms/oceanbase-ce-4.2.2.1-101000012024030709.el7.x86_64.rpm, targetPath=rpms/extract/, extractAll=true, fileInPackage=null), params:null 2025-01-17 21:14:00.678 INFO 1432603 --- [manual-subtask-executor15,f384dc251dbc0061,9aca6d572c156a01] c.o.o.e.internal.template.HttpTemplate : POST request to agent, url:http://10.3.1.5:62888/api/v1/task/status, request body:GetTaskStatusRequest(taskToken=27e30de6-af43-45fe-b486-ad58f59114d1), params:null 2025-01-17 21:14:00.698 INFO 1432603 --- [manual-subtask-executor15,f384dc251dbc0061,9aca6d572c156a01] c.o.o.s.task.util.AgentAsyncTaskHelper : try to request task result(EXECUTE), result:false,null,, 2025-01-17 21:14:00.700 INFO 1432603 --- [manual-subtask-executor15,f384dc251dbc0061,9aca6d572c156a01] c.o.ocp.common.lang.pattern.Retry : wait for 10 seconds 2025-01-17 21:14:10.701 INFO 1432603 --- [manual-subtask-executor15,f384dc251dbc0061,9aca6d572c156a01] c.o.o.e.internal.template.HttpTemplate : POST request to agent, url:http://10.3.1.5:62888/api/v1/task/status, request body:GetTaskStatusRequest(taskToken=27e30de6-af43-45fe-b486-ad58f59114d1), params:null 2025-01-17 21:14:10.719 INFO 1432603 --- [manual-subtask-executor15,f384dc251dbc0061,9aca6d572c156a01] c.o.o.s.task.util.AgentAsyncTaskHelper : try to request task result(EXECUTE), result:false,null,, 2025-01-17 21:14:10.720 INFO 1432603 --- [manual-subtask-executor15,f384dc251dbc0061,9aca6d572c156a01] c.o.ocp.common.lang.pattern.Retry : wait for 10 seconds 2025-01-17 21:14:20.722 INFO 1432603 --- [manual-subtask-executor15,f384dc251dbc0061,9aca6d572c156a01] c.o.o.e.internal.template.HttpTemplate : POST request to agent, url:http://10.3.1.5:62888/api/v1/task/status, request body:GetTaskStatusRequest(taskToken=27e30de6-af43-45fe-b486-ad58f59114d1), params:null 2025-01-17 21:14:20.733 INFO 1432603 --- [manual-subtask-executor15,f384dc251dbc0061,9aca6d572c156a01] c.o.o.s.task.util.AgentAsyncTaskHelper : try to request task result(EXECUTE), result:true,{"basePath":"rpms/extract/oceanbase-ce-4.2.2.1-101000012024030709.el7.x86_64.rpm","extractAll":true},, 2025-01-17 21:14:20.735 INFO 1432603 --- [manual-subtask-executor15,f384dc251dbc0061,9aca6d572c156a01] c.o.o.c.h.s.HostOperationServiceImpl : remove host files, pathList:[rpms/extract/oceanbase-ce-4.2.2.1-101000012024030709.el7.x86_64.rpm/home/admin/oceanbase/admin, rpms/extract/oceanbase-ce-4.2.2.1-101000012024030709.el7.x86_64.rpm/home/admin/oceanbase/bin, rpms/extract/oceanbase-ce-4.2.2.1-101000012024030709.el7.x86_64.rpm/home/admin/oceanbase/etc/dict] 2025-01-17 21:14:20.740 INFO 1432603 --- [manual-subtask-executor15,f384dc251dbc0061,9aca6d572c156a01] c.o.o.c.agent.HostAgentServiceImpl : Finding OCP agent: hostId=2000004 2025-01-17 21:14:20.742 INFO 1432603 --- [manual-subtask-executor15,f384dc251dbc0061,9aca6d572c156a01] c.o.o.c.a.p.HostAgentProcessServiceImpl : Getting all OCP agent processes on host 2000004 2025-01-17 21:14:20.754 INFO 1432603 --- [manual-subtask-executor15,f384dc251dbc0061,9aca6d572c156a01] c.o.o.e.internal.template.HttpTemplate : POST request to agent, url:http://10.3.1.5:62888/api/v1/file/remove, request body:RemoveFilesRequest(pathList=[rpms/extract/oceanbase-ce-4.2.2.1-101000012024030709.el7.x86_64.rpm/home/admin/oceanbase/admin, rpms/extract/oceanbase-ce-4.2.2.1-101000012024030709.el7.x86_64.rpm/home/admin/oceanbase/bin, rpms/extract/oceanbase-ce-4.2.2.1-101000012024030709.el7.x86_64.rpm/home/admin/oceanbase/etc/dict]), params:null 2025-01-17 21:14:20.829 INFO 1432603 --- [manual-subtask-executor15,f384dc251dbc0061,9aca6d572c156a01] c.o.o.c.h.s.HostOperationServiceImpl : remove host files success, pathList:[rpms/extract/oceanbase-ce-4.2.2.1-101000012024030709.el7.x86_64.rpm/home/admin/oceanbase/admin, rpms/extract/oceanbase-ce-4.2.2.1-101000012024030709.el7.x86_64.rpm/home/admin/oceanbase/bin, rpms/extract/oceanbase-ce-4.2.2.1-101000012024030709.el7.x86_64.rpm/home/admin/oceanbase/etc/dict] 2025-01-17 21:14:20.832 INFO 1432603 --- [manual-subtask-executor15,f384dc251dbc0061,9aca6d572c156a01] c.o.o.c.h.s.HostOperationServiceImpl : remove host files, pathList:[rpms/oceanbase-ce-4.2.2.1-101000012024030709.el7.x86_64.rpm] 2025-01-17 21:14:20.836 INFO 1432603 --- [manual-subtask-executor15,f384dc251dbc0061,9aca6d572c156a01] c.o.o.c.agent.HostAgentServiceImpl : Finding OCP agent: hostId=2000004 2025-01-17 21:14:20.838 INFO 1432603 --- [manual-subtask-executor15,f384dc251dbc0061,9aca6d572c156a01] c.o.o.c.a.p.HostAgentProcessServiceImpl : Getting all OCP agent processes on host 2000004 2025-01-17 21:14:20.850 INFO 1432603 --- [manual-subtask-executor15,f384dc251dbc0061,9aca6d572c156a01] c.o.o.e.internal.template.HttpTemplate : POST request to agent, url:http://10.3.1.5:62888/api/v1/file/remove, request body:RemoveFilesRequest(pathList=[rpms/oceanbase-ce-4.2.2.1-101000012024030709.el7.x86_64.rpm]), params:null 2025-01-17 21:14:20.874 INFO 1432603 --- [manual-subtask-executor15,f384dc251dbc0061,9aca6d572c156a01] c.o.o.c.h.s.HostOperationServiceImpl : remove host files success, pathList:[rpms/oceanbase-ce-4.2.2.1-101000012024030709.el7.x86_64.rpm] 2025-01-17 21:14:20.878 INFO 1432603 --- [manual-subtask-executor15,f384dc251dbc0061,9aca6d572c156a01] c.o.o.s.t.b.c.helper.UpgradeTaskHelper : [runScript]: generate agent async task token:96a75a2b-3d0c-4207-91c5-3e6d9644a77f 2025-01-17 21:14:20.882 INFO 1432603 --- [manual-subtask-executor15,f384dc251dbc0061,9aca6d572c156a01] c.o.o.c.agent.HostAgentServiceImpl : Finding OCP agent: hostId=2000004 2025-01-17 21:14:20.884 INFO 1432603 --- [manual-subtask-executor15,f384dc251dbc0061,9aca6d572c156a01] c.o.o.c.a.p.HostAgentProcessServiceImpl : Getting all OCP agent processes on host 2000004 2025-01-17 21:14:20.895 INFO 1432603 --- [manual-subtask-executor15,f384dc251dbc0061,9aca6d572c156a01] c.o.o.e.internal.template.HttpTemplate : POST request to agent, url:http://10.3.1.5:62888/api/v1/ob/upgrade/runScript, request body:RunUpgradeScriptRequest(scriptPath=rpms/extract/oceanbase-ce-4.2.2.1-101000012024030709.el7.x86_64.rpm/home/admin/oceanbase/etc/upgrade_checker.py, arguments=RunUpgradeScriptArgument(host=127.0.0.1, port=2881, logFile=4.2.2.1-101000012024030709_upgrade_checker_20250117211420.log, zone=null, cmdTimeout=0)), params:null 2025-01-17 21:14:20.912 INFO 1432603 --- [manual-subtask-executor15,f384dc251dbc0061,9aca6d572c156a01] c.o.o.e.internal.template.HttpTemplate : POST request to agent, url:http://10.3.1.5:62888/api/v1/task/status, request body:GetTaskStatusRequest(taskToken=96a75a2b-3d0c-4207-91c5-3e6d9644a77f), params:null 2025-01-17 21:14:20.922 INFO 1432603 --- [manual-subtask-executor15,f384dc251dbc0061,9aca6d572c156a01] c.o.o.s.task.util.AgentAsyncTaskHelper : try to request task result(EXECUTE), result:false,null,, 2025-01-17 21:14:20.923 INFO 1432603 --- [manual-subtask-executor15,f384dc251dbc0061,9aca6d572c156a01] c.o.ocp.common.lang.pattern.Retry : wait for 15 seconds 2025-01-17 21:14:35.924 INFO 1432603 --- [manual-subtask-executor15,f384dc251dbc0061,9aca6d572c156a01] c.o.o.e.internal.template.HttpTemplate : POST request to agent, url:http://10.3.1.5:62888/api/v1/task/status, request body:GetTaskStatusRequest(taskToken=96a75a2b-3d0c-4207-91c5-3e6d9644a77f), params:null 2025-01-17 21:14:35.936 INFO 1432603 --- [manual-subtask-executor15,f384dc251dbc0061,9aca6d572c156a01] c.o.o.s.task.util.AgentAsyncTaskHelper : try to request task result(EXECUTE), result:false,null,OcpAgentError: code = 1500, message = Execute shell command failed: failed to execute command: Command{user=root, program=sh, outputType=combined, cmd=export PYTHONPATH=/home/admin/ocp_agent/site-packages:$PYTHONPATH && python /tmp/rpms/extract/oceanbase-ce-4.2.2.1-101000012024030709.el7.x86_64.rpm/home/admin/oceanbase/etc/upgrade_checker.py -h127.0.0.1 -P2881 -uroot@sys --password=xxx -l /tmp/4.2.2.1-101000012024030709_upgrade_checker_20250117211420.log, timeout=30m0s}, exitCode: 1, output: File "/tmp/rpms/extract/oceanbase-ce-4.2.2.1-101000012024030709.el7.x86_64.rpm/home/admin/oceanbase/etc/upgrade_checker.py", line 33 except mysql.connector.Error, e: ^ SyntaxError: invalid syntax , error: exit status 1, 2025-01-17 21:14:35.945 ERROR 1432603 --- [manual-subtask-executor15,f384dc251dbc0061,9aca6d572c156a01] c.o.o.s.task.util.AgentAsyncTaskHelper : failed to execute async task, task token: 96a75a2b-3d0c-4207-91c5-3e6d9644a77f, err: OcpAgentError: code = 1500, message = Execute shell command failed: failed to execute command: Command{user=root, program=sh, outputType=combined, cmd=export PYTHONPATH=/home/admin/ocp_agent/site-packages:$PYTHONPATH && python /tmp/rpms/extract/oceanbase-ce-4.2.2.1-101000012024030709.el7.x86_64.rpm/home/admin/oceanbase/etc/upgrade_checker.py -h127.0.0.1 -P2881 -uroot@sys --password=xxx -l /tmp/4.2.2.1-101000012024030709_upgrade_checker_20250117211420.log, timeout=30m0s}, exitCode: 1, output: File "/tmp/rpms/extract/oceanbase-ce-4.2.2.1-101000012024030709.el7.x86_64.rpm/home/admin/oceanbase/etc/upgrade_checker.py", line 33 except mysql.connector.Error, e: ^ SyntaxError: invalid syntax , error: exit status 1 2025-01-17 21:14:35.951 ERROR 1432603 --- [manual-subtask-executor15,f384dc251dbc0061,9aca6d572c156a01] c.o.ocp.core.util.ExceptionUtils : Checked Exception: com.oceanbase.ocp.core.exception.UnexpectedException occurred with code error.agent.task.failed, and args [96a75a2b-3d0c-4207-91c5-3e6d9644a77f, OcpAgentError: code = 1500, message = Execute shell command failed: failed to execute command: Command{user=root, program=sh, outputType=combined, cmd=export PYTHONPATH=/home/admin/ocp_agent/site-packages:$PYTHONPATH && python /tmp/rpms/extract/oceanbase-ce-4.2.2.1-101000012024030709.el7.x86_64.rpm/home/admin/oceanbase/etc/upgrade_checker.py -h127.0.0.1 -P2881 -uroot@sys --password=xxx -l /tmp/4.2.2.1-101000012024030709_upgrade_checker_20250117211420.log, timeout=30m0s}, exitCode: 1, output: File "/tmp/rpms/extract/oceanbase-ce-4.2.2.1-101000012024030709.el7.x86_64.rpm/home/admin/oceanbase/etc/upgrade_checker.py", line 33 except mysql.connector.Error, e: ^ SyntaxError: invalid syntax , error: exit status 1] 2025-01-17 21:14:35.952 ERROR 1432603 --- [manual-subtask-executor15,f384dc251dbc0061,9aca6d572c156a01] c.o.o.c.t.e.c.w.subtask.SubtaskExecutor : OCP-Agent task 96a75a2b-3d0c-4207-91c5-3e6d9644a77f failed, error message: OcpAgentError: code = 1500, message = Execute shell command failed: failed to execute command: Command{user=root, program=sh, outputType=combined, cmd=export PYTHONPATH=/home/admin/ocp_agent/site-packages:$PYTHONPATH && python /tmp/rpms/extract/oceanbase-ce-4.2.2.1-101000012024030709.el7.x86_64.rpm/home/admin/oceanbase/etc/upgrade_checker.py -h127.0.0.1 -P2881 -uroot@sys --password=xxx -l /tmp/4.2.2.1-101000012024030709_upgrade_checker_20250117211420.log, timeout=30m0s}, exitCode: 1, output: File "/tmp/rpms/extract/oceanbase-ce-4.2.2.1-101000012024030709.el7.x86_64.rpm/home/admin/oceanbase/etc/upgrade_checker.py", line 33 except mysql.connector.Error, e: ^ SyntaxError: invalid syntax , error: exit status 1 com.oceanbase.ocp.core.exception.UnexpectedException: [OCP UnexpectedException]: status=500 INTERNAL_SERVER_ERROR, errorCode=AGENT_TASK_FAILED, args=96a75a2b-3d0c-4207-91c5-3e6d9644a77f,OcpAgentError: code = 1500, message = Execute shell command failed: failed to execute command: Command{user=root, program=sh, outputType=combined, cmd=export PYTHONPATH=/home/admin/ocp_agent/site-packages:$PYTHONPATH && python /tmp/rpms/extract/oceanbase-ce-4.2.2.1-101000012024030709.el7.x86_64.rpm/home/admin/oceanbase/etc/upgrade_checker.py -h127.0.0.1 -P2881 -uroot@sys --password=xxx -l /tmp/4.2.2.1-101000012024030709_upgrade_checker_20250117211420.log, timeout=30m0s}, exitCode: 1, output: File "/tmp/rpms/extract/oceanbase-ce-4.2.2.1-101000012024030709.el7.x86_64.rpm/home/admin/oceanbase/etc/upgrade_checker.py", line 33 except mysql.connector.Error, e: ^ SyntaxError: invalid syntax , error: exit status 1 at com.oceanbase.ocp.core.i18n.ErrorCodes$Kind$10.exception(ErrorCodes.java:1774) at com.oceanbase.ocp.core.i18n.ErrorCodes.excep tion(ErrorCodes.java:1629) at com.oceanbase.ocp.core.util.ExceptionUtils.newException(ExceptionUtils.java:169) at com.oceanbase.ocp.core.util.ExceptionUtils.throwException(ExceptionUtils.java:162) at com.oceanbase.ocp.service.task.util.AgentAsyncTaskHelper.checkSuccess(AgentAsyncTaskHelper.java:271) at com.oceanbase.ocp.service.task.util.AgentAsyncTaskHelper.waitForExecuteFinish(AgentAsyncTaskHelper.java:217) at com.oceanbase.ocp.service.task.util.AgentAsyncTaskHelper.runUpgradeScript(AgentAsyncTaskHelper.java:140) at com.oceanbase.ocp.service.task.business.cluster.helper.UpgradeTaskHelper.runScript(UpgradeTaskHelper.java:161) at com.oceanbase.ocp.service.task.business.cluster.helper.UpgradeTaskHelper.runScript(UpgradeTaskHelper.java:106) at com.oceanbase.ocp.service.task.business.cluster.helper.UpgradeTaskHelper.runScript(UpgradeTaskHelper.java:81) at com.oceanbase.ocp.service.task.business.cluster.ExecUpgradeCheckerScriptTask.run(ExecUpgradeCheckerScriptTask.java:60) 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: 11030566, operation:EXECUTE, state: FAILED