2025-03-26 16:58:41.325 INFO 2379057 --- [pool-manual-subtask-executor16,00a38908b5b248da,3e1bd1beb8a0] c.o.o.c.t.e.runner.JavaSubtaskRunner : Run subtask, id=2000240, context=Context{parallelIdx=-1, stringMap={tenant_id=1000001, ob_tenant_id=1006, tenant_name=mhsb_root, ob_tenant_parameter_map=, task_instance_id=2000252, task_operation=execute, whitelist=%, target_tenant_status=NORMAL, resource_pool_list_json=[{"id":1003,"name":"pool_mhsb_root_server1_kmq","unitConfig":{"iopsWeight":8,"logDiskSize":24,"logDiskSizeByte":25769803776,"maxCpuCoreCount":8.00,"maxIops":0,"maxMemoryByte":8589934592,"maxMemorySize":8,"minCpuCoreCount":8.00,"minIops":0,"minMemoryByte":8589934592,"minMemorySize":8},"unitCount":1,"zoneList":["server1"]}], cluster_id=1, old_password=******, new_password=******, system_variable_map=, create_tenant_param_json={"charset":"utf8mb4","collation":"utf8mb4_general_ci","enableArbitration":false,"mode":"MYSQL","name":"mhsb_root","parameters":[],"rootPassword":"******","saveToCredential":true,"whitelist":"%","zones":[{"name":"server1","replicaType":"FULL","resourcePool":{"unitCount":1,"unitSpecName":"mhsb_unit"}}]}, latest_execution_start_time=2025-03-26T16:58:40.812+08:00, sub_task_instance_name=Import tenant srs info, sub_task_instance_id=2000240}, listMap={}}, executor=192.168.0.139 2025-03-26 16:58:41.620 INFO 2379057 --- [pool-manual-subtask-executor16,00a38908b5b248da,3e1bd1beb8a0] c.o.o.c.agent.HostAgentServiceImpl : Finding OCP agent: hostId=2 2025-03-26 16:58:41.807 INFO 2379057 --- [pool-manual-subtask-executor16,00a38908b5b248da,3e1bd1beb8a0] c.o.o.c.a.p.HostAgentProcessServiceImpl : Getting all OCP agent processes on host 2 2025-03-26 16:58:42.027 INFO 2379057 --- [pool-manual-subtask-executor16,00a38908b5b248da,3e1bd1beb8a0] c.o.o.e.internal.template.HttpTemplate : POST request to agent, url:http://192.168.0.139:62888/api/v1/ob/importSrsInfo, request body:AsyncTaskRequest(taskToken=39eb358e-1b30-4615-9443-1831d1ca62e1), params:null 2025-03-26 16:58:42.129 INFO 2379057 --- [pool-manual-subtask-executor16,00a38908b5b248da,3e1bd1beb8a0] c.o.o.e.internal.template.HttpTemplate : POST request to agent, url:http://192.168.0.139:62888/api/v1/task/status, request body:GetTaskStatusRequest(taskToken=39eb358e-1b30-4615-9443-1831d1ca62e1), params:null 2025-03-26 16:58:42.267 INFO 2379057 --- [pool-manual-subtask-executor16,00a38908b5b248da,3e1bd1beb8a0] 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 /disk_d/oceanbase/ob/mhsb_t1/home/bin/import_srs_data.py -h192.168.0.139 -P2991 -p=xxx -t mhsb_root -f /disk_d/oceanbase/ob/mhsb_t1/home/etc/default_srs_data_mysql.sql, timeout=20m0s}, exitCode: 127, output: sh: line 1: python: command not found , error: exit status 127, 2025-03-26 16:58:42.420 ERROR 2379057 --- [pool-manual-subtask-executor16,00a38908b5b248da,3e1bd1beb8a0] c.o.o.s.task.util.AgentAsyncTaskHelper : failed to execute async task, task token: 39eb358e-1b30-4615-9443-1831d1ca62e1, 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 /disk_d/oceanbase/ob/mhsb_t1/home/bin/import_srs_data.py -h192.168.0.139 -P2991 -p=xxx -t mhsb_root -f /disk_d/oceanbase/ob/mhsb_t1/home/etc/default_srs_data_mysql.sql, timeout=20m0s}, exitCode: 127, output: sh: line 1: python: command not found , error: exit status 127 2025-03-26 16:58:42.714 ERROR 2379057 --- [pool-manual-subtask-executor16,00a38908b5b248da,3e1bd1beb8a0] c.o.ocp.core.util.ExceptionUtils : Checked Exception: com.oceanbase.ocp.core.exception.UnexpectedException occurred with code error.agent.task.failed, and args [39eb358e-1b30-4615-9443-1831d1ca62e1, 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 /disk_d/oceanbase/ob/mhsb_t1/home/bin/import_srs_data.py -h192.168.0.139 -P2991 -p=xxx -t mhsb_root -f /disk_d/oceanbase/ob/mhsb_t1/home/etc/default_srs_data_mysql.sql, timeout=20m0s}, exitCode: 127, output: sh: line 1: python: command not found , error: exit status 127] 2025-03-26 16:58:42.937 ERROR 2379057 --- [pool-manual-subtask-executor16,00a38908b5b248da,3e1bd1beb8a0] c.o.o.c.t.e.c.w.subtask.SubtaskExecutor : OCP-Agent task 39eb358e-1b30-4615-9443-1831d1ca62e1 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 /disk_d/oceanbase/ob/mhsb_t1/home/bin/import_srs_data.py -h192.168.0.139 -P2991 -p=xxx -t mhsb_root -f /disk_d/oceanbase/ob/mhsb_t1/home/etc/default_srs_data_mysql.sql, timeout=20m0s}, exitCode: 127, output: sh: line 1: python: command not found , error: exit status 127 com.oceanbase.ocp.core.exception.UnexpectedException: [OCP UnexpectedException]: status=500 INTERNAL_SERVER_ERROR, errorCode=AGENT_TASK_FAILED, args=39eb358e-1b30-4615-9443-1831d1ca62e1,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 /disk_d/oceanbase/ob/mhsb_t1/home/bin/import_srs_data.py -h192.168.0.139 -P2991 -p=xxx -t mhsb_root -f /disk_d/oceanbase/ob/mhsb_t1/home/etc/default_srs_data_mysql.sql, timeout=20m0s}, exitCode: 127, output: sh: line 1: python: command not found , error: exit status 127 at com.oceanbase.ocp.core.i18n.ErrorCodes$Kind$10.exception(ErrorCodes.java:1570) at com.oceanbase.ocp.core.i18n.ErrorCodes.exception(ErrorCodes.java:1425) 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:229) at com.oceanbase.ocp.service.task.util.AgentAsyncTaskHelper.waitForExecuteFinish(AgentAsyncTaskHelper.java:175) at com.oceanbase.ocp.service.task.util.AgentAsyncTaskHelper.importSrsInfo(AgentAsyncTaskHelpe r.java:148) at com.oceanbase.ocp.obops.internal.cluster.ClusterHostOperationServiceImpl.importSrsInfo(ClusterHostOperationServiceImpl.java:482) at com.oceanbase.ocp.obops.internal.tenant.TenantOperationServiceImpl.importSrsInfo(TenantOperationServiceImpl.java:724) at com.oceanbase.ocp.obops.internal.tenant.TenantOperationServiceImpl$$FastClassBySpringCGLIB$$44eef4f8.invoke() at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:793) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763) at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:97) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763) at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:708) at com.oceanbase.ocp.obops.internal.tenant.TenantOperationServiceImpl$$EnhancerBySpringCGLIB$$ea5a5f9c.importSrsInfo() at com.oceanbase.ocp.obops.internal.tenant.task.ImportTenantSrsInfoTask.run(ImportTenantSrsInfoTask.java:42) 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:203) at com.oceanbase.ocp.core.task.engine.coordinator.worker.subtask.SubtaskE xecutor.redirectConsoleOutput(SubtaskExecutor.java:197) at com.oceanbase.ocp.core.task.engine.coordinator.worker.subtask.SubtaskExecutor.lambda$submit$2(SubtaskExecutor.java:134) 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:748) Set state for subtask: 2000240, operation:EXECUTE, state: FAILED