2024-11-08 18:22:04.462 INFO 28647 --- [manual-subtask-executor16,f6f04bcef1be81f0,7ed962bbab9f1b0a] c.o.o.c.t.e.runner.JavaSubtaskRunner : Run subtask, id=1000026, context=Context{parallelIdx=-1, stringMap={tenant_id=1000001, ob_tenant_id=1006, tenant_name=Jx_His, ob_tenant_parameter_map=, task_instance_id=1000018, task_operation=execute, whitelist=%, target_tenant_status=NORMAL, resource_pool_list_json=[{"id":1003,"name":"pool_Jx_His_zone1_mie","unitConfig":{"iopsWeight":1,"logDiskSize":6,"logDiskSizeByte":6442450944,"maxCpuCoreCount":1.00,"maxIops":0,"maxMemoryByte":2147483648,"maxMemorySize":2,"minCpuCoreCount":1.00,"minIops":0,"minMemoryByte":2147483648,"minMemorySize":2},"unitCount":2,"zoneList":["zone1"]}], cluster_id=1, old_password=xxx new_password=xxx system_variable_map=, create_tenant_param_json={"charset":"utf8mb4","collation":"utf8mb4_general_ci","enableArbitration":false,"mode":"MYSQL","name":"Jx_His","parameters":[],"primaryZone":"zone1","rootPassword":"******","saveToCredential":true,"skipImportTenantInfo":false,"whitelist":"%","zones":[{"name":"zone1","replicaType":"FULL","resourcePool":{"unitCount":2,"unitSpecName":"LogOnlyNormal"}}]}, latest_execution_start_time=2024-11-08T18:22:04.388+08:00, sub_task_instance_name=Import tenant srs info, sub_task_instance_id=1000026}, listMap={}}, executor=192.168.18.130 2024-11-08 18:22:04.722 INFO 28647 --- [manual-subtask-executor16,f6f04bcef1be81f0,7ed962bbab9f1b0a] c.o.o.c.agent.HostAgentServiceImpl : Finding OCP agent: hostId=1 2024-11-08 18:22:04.747 INFO 28647 --- [manual-subtask-executor16,f6f04bcef1be81f0,7ed962bbab9f1b0a] c.o.o.c.a.p.HostAgentProcessServiceImpl : Getting all OCP agent processes on host 1 2024-11-08 18:22:04.899 INFO 28647 --- [manual-subtask-executor16,f6f04bcef1be81f0,7ed962bbab9f1b0a] c.o.o.e.internal.template.HttpTemplate : POST request to agent, url:http://192.168.18.135:62888/api/v1/ob/importSrsInfo, request body:AsyncTaskRequest(taskToken=96228526-3130-4277-88d6-95fe6c02f289), params:null 2024-11-08 18:22:04.936 INFO 28647 --- [manual-subtask-executor16,f6f04bcef1be81f0,7ed962bbab9f1b0a] c.o.o.e.internal.template.HttpTemplate : POST request to agent, url:http://192.168.18.135:62888/api/v1/task/status, request body:GetTaskStatusRequest(taskToken=96228526-3130-4277-88d6-95fe6c02f289), params:null 2024-11-08 18:22:04.966 INFO 28647 --- [manual-subtask-executor16,f6f04bcef1be81f0,7ed962bbab9f1b0a] 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 /root/oceanbase/bin/import_srs_data.py -h192.168.18.135 -P2881 -p=xxx -t Jx_His -f /root/oceanbase/etc/default_srs_data_mysql.sql, timeout=20m0s}, exitCode: 127, output: sh: line 1: python: command not found , error: exit status 127, 2024-11-08 18:22:05.043 ERROR 28647 --- [manual-subtask-executor16,f6f04bcef1be81f0,7ed962bbab9f1b0a] c.o.o.s.task.util.AgentAsyncTaskHelper : failed to execute async task, task token: 96228526-3130-4277-88d6-95fe6c02f289, 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 /root/oceanbase/bin/import_srs_data.py -h192.168.18.135 -P2881 -p=xxx -t Jx_His -f /root/oceanbase/etc/default_srs_data_mysql.sql, timeout=20m0s}, exitCode: 127, output: sh: line 1: python: command not found , error: exit status 127 2024-11-08 18:22:05.069 ERROR 28647 --- [manual-subtask-executor16,f6f04bcef1be81f0,7ed962bbab9f1b0a] c.o.ocp.core.util.ExceptionUtils : Checked Exception: com.oceanbase.ocp.core.exception.UnexpectedException occurred with code error.agent.task.failed, and args [96228526-3130-4277-88d6-95fe6c02f289, 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 /root/oceanbase/bin/import_srs_data.py -h192.168.18.135 -P2881 -p=xxx -t Jx_His -f /root/oceanbase/etc/default_srs_data_mysql.sql, timeout=20m0s}, exitCode: 127, output: sh: line 1: python: command not found , error: exit status 127] 2024-11-08 18:22:05.084 ERROR 28647 --- [manual-subtask-executor16,f6f04bcef1be81f0,7ed962bbab9f1b0a] c.o.o.c.t.e.c.w.subtask.SubtaskExecutor : OCP-Agent task 96228526-3130-4277-88d6-95fe6c02f289 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 /root/oceanbase/bin/import_srs_data.py -h192.168.18.135 -P2881 -p=xxx -t Jx_His -f /root/oceanbase/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=96228526-3130-4277-88d6-95fe6c02f289,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 /root/oceanbase/bin/import_srs_data.py -h192.168.18.135 -P2881 -p=xxx -t Jx_His -f /root/oceanbase/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:1732) at com.oceanbase.ocp.core.i18n.ErrorCodes.exception(ErrorCodes.java:1587) 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:262) at com.oceanbase.ocp.service.task.util.AgentAsyncTaskHelper.waitForExecuteFinish(AgentAsyncTaskHelper.java:208) at com.oceanbase.ocp.service.task.util.AgentAsyncTaskHelper.importSrsInfo(AgentAsyncTaskHelper.java:157) at com.oceanbase.ocp.obops.internal.cluster.ClusterHostOperationSe rviceImpl.importSrsInfo(ClusterHostOperationServiceImpl.java:499) at com.oceanbase.ocp.obops.internal.tenant.TenantOperationServiceImpl.importSrsInfo(TenantOperationServiceImpl.java:1495) 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:792) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:762) 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:762) at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:707) at com.oceanbase.ocp.obops.internal.tenant.TenantOperationServiceImpl$$EnhancerBySpringCGLIB$$1afe06c7.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: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:748) Set state for subtask: 1000026, operation:EXECUTE, state: FAILED 2024-11-08 18:22:30.797 INFO 28647 --- [manual-subtask-executor16,f6f04bcef1be81f0,d00ffc4dabff4c20] c.o.o.c.t.e.runner.JavaSubtaskRunner : Retry subtask, id=1000026, context=Context{parallelIdx=-1, stringMap={tenant_id=1000001, ob_tenant_id=1006, tenant_name=Jx_His, ob_tenant_parameter_map=, task_instance_id=1000018, task_operation=retry, whitelist=%, target_tenant_status=NORMAL, resource_pool_list_json=[{"id":1003,"name":"pool_Jx_His_zone1_mie","unitConfig":{"iopsWeight":1,"logDiskSize":6,"logDiskSizeByte":6442450944,"maxCpuCoreCount":1.00,"maxIops":0,"maxMemoryByte":2147483648,"maxMemorySize":2,"minCpuCoreCount":1.00,"minIops":0,"minMemoryByte":2147483648,"minMemorySize":2},"unitCount":2,"zoneList":["zone1"]}], cluster_id=1, old_password=xxx new_password=xxx system_variable_map=, create_tenant_param_json={"charset":"utf8mb4","collation":"utf8mb4_general_ci","enableArbitration":false,"mode":"MYSQL","name":"Jx_His","parameters":[],"primaryZone":"zone1","rootPassword":"******","saveToCredential":true,"skipImportTenantInfo":false,"whitelist":"%","zones":[{"name":"zone1","replicaType":"FULL","resourcePool":{"unitCount":2,"unitSpecName":"LogOnlyNormal"}}]}, latest_execution_start_time=2024-11-08T18:22:30.719+08:00, sub_task_instance_name=Import tenant srs info, sub_task_instance_id=1000026}, listMap={}}, executor=192.168.18.130 2024-11-08 18:22:30.809 INFO 28647 --- [manual-subtask-executor16,f6f04bcef1be81f0,d00ffc4dabff4c20] c.o.o.o.i.t.t.ImportTenantSrsInfoTask : do nothing when rollback 2024-11-08 18:22:31.018 INFO 28647 --- [manual-subtask-executor16,f6f04bcef1be81f0,d00ffc4dabff4c20] c.o.o.c.agent.HostAgentServiceImpl : Finding OCP agent: hostId=1 2024-11-08 18:22:31.034 INFO 28647 --- [manual-subtask-executor16,f6f04bcef1be81f0,d00ffc4dabff4c20] c.o.o.c.a.p.HostAgentProcessServiceImpl : Getting all OCP agent processes on host 1 2024-11-08 18:22:31.180 INFO 28647 --- [manual-subtask-executor16,f6f04bcef1be81f0,d00ffc4dabff4c20] c.o.o.e.internal.template.HttpTemplate : POST request to agent, url:http://192.168.18.135:62888/api/v1/ob/importSrsInfo, request body:AsyncTaskRequest(taskToken=f1599ed2-be23-4a04-863b-485260fd39e6), params:null 2024-11-08 18:22:31.209 INFO 28647 --- [manual-subtask-executor16,f6f04bcef1be81f0,d00ffc4dabff4c20] c.o.o.e.internal.template.HttpTemplate : POST request to agent, url:http://192.168.18.135:62888/api/v1/task/status, request body:GetTaskStatusRequest(taskToken=f1599ed2-be23-4a04-863b-485260fd39e6), params:null 2024-11-08 18:22:31.227 INFO 28647 --- [manual-subtask-executor16,f6f04bcef1be81f0,d00ffc4dabff4c20] 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 /root/oceanbase/bin/import_srs_data.py -h192.168.18.135 -P2881 -p=xxx -t Jx_His -f /root/oceanbase/etc/default_srs_data_mysql.sql, timeout=20m0s}, exitCode: 127, output: sh: line 1: python: command not found , error: exit status 127, 2024-11-08 18:22:31.263 ERROR 28647 --- [manual-subtask-executor16,f6f04bcef1be81f0,d00ffc4dabff4c20] c.o.o.s.task.util.AgentAsyncTaskHelper : failed to execute async task, task token: f1599ed2-be23-4a04-863b-485260fd39e6, 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 /root/oceanbase/bin/import_srs_data.py -h192.168.18.135 -P2881 -p=xxx -t Jx_His -f /root/oceanbase/etc/default_srs_data_mysql.sql, timeout=20m0s}, exitCode: 127, output: sh: line 1: python: command not found , error: exit status 127 2024-11-08 18:22:31.284 ERROR 28647 --- [manual-subtask-executor16,f6f04bcef1be81f0,d00ffc4dabff4c20] c.o.ocp.core.util.ExceptionUtils : Checked Exception: com.oceanbase.ocp.core.exception.UnexpectedException occurred with code error.agent.task.failed, and args [f1599ed2-be23-4a04-863b-485260fd39e6, 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 /root/oceanbase/bin/import_srs_data.py -h192.168.18.135 -P2881 -p=xxx -t Jx_His -f /root/oceanbase/etc/default_srs_data_mysql.sql, timeout=20m0s}, exitCode: 127, output: sh: line 1: python: command not found , error: exit status 127] 2024-11-08 18:22:31.297 ERROR 28647 --- [manual-subtask-executor16,f6f04bcef1be81f0,d00ffc4dabff4c20] c.o.o.c.t.e.c.w.subtask.SubtaskExecutor : OCP-Agent task f1599ed2-be23-4a04-863b-485260fd39e6 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 /root/oceanbase/bin/import_srs_data.py -h192.168.18.135 -P2881 -p=xxx -t Jx_His -f /root/oceanbase/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=f1599ed2-be23-4a04-863b-485260fd39e6,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 /root/oceanbase/bin/import_srs_data.py -h192.168.18.135 -P2881 -p=xxx -t Jx_His -f /root/oceanbase/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:1732) at com.oceanbase.ocp.core.i18n.ErrorCodes.exception(ErrorCodes.java:1587) 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:262) at com.oceanbase.ocp.service.task.util.AgentAsyncTaskHelper.waitForExecuteFinish(AgentAsyncTaskHelper.java:208) at com.oceanbase.ocp.service.task.util.AgentAsyncTaskHelper.importSrsInfo(AgentAsyncTaskHelper.java:157) at com.oceanbase.ocp.obops.internal.cluster.ClusterHostOperationSe rviceImpl.importSrsInfo(ClusterHostOperationServiceImpl.java:499) at com.oceanbase.ocp.obops.internal.tenant.TenantOperationServiceImpl.importSrsInfo(TenantOperationServiceImpl.java:1495) 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:792) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:762) 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:762) at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:707) at com.oceanbase.ocp.obops.internal.tenant.TenantOperationServiceImpl$$EnhancerBySpringCGLIB$$1afe06c7.importSrsInfo() at com.oceanbase.ocp.obops.internal.tenant.task.ImportTenantSrsInfoTask.run(ImportTenantSrsInfoTask.java:42) at com.oceanbase.ocp.core.task.runtime.Subtask.retry(Subtask.java:49) at com.oceanbase.ocp.core.task.engine.runner.JavaSubtaskRunner.retry(JavaSubtaskRunner.java:76) at com.oceanbase.ocp.core.task.engine.runner.JavaSubtaskRunner.doRun(JavaSubtaskRunner.java:35) 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.r edirectConsoleOutput(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:748) Set state for subtask: 1000026, operation:RETRY, state: FAILED 2024-11-08 18:30:04.529 INFO 28647 --- [manual-subtask-executor16,f6f04bcef1be81f0,65f9285c09056029] c.o.o.c.t.e.runner.JavaSubtaskRunner : Retry subtask, id=1000026, context=Context{parallelIdx=-1, stringMap={tenant_id=1000001, ob_tenant_id=1006, tenant_name=Jx_His, ob_tenant_parameter_map=, task_instance_id=1000018, task_operation=retry, whitelist=%, target_tenant_status=NORMAL, resource_pool_list_json=[{"id":1003,"name":"pool_Jx_His_zone1_mie","unitConfig":{"iopsWeight":1,"logDiskSize":6,"logDiskSizeByte":6442450944,"maxCpuCoreCount":1.00,"maxIops":0,"maxMemoryByte":2147483648,"maxMemorySize":2,"minCpuCoreCount":1.00,"minIops":0,"minMemoryByte":2147483648,"minMemorySize":2},"unitCount":2,"zoneList":["zone1"]}], cluster_id=1, old_password=xxx new_password=xxx system_variable_map=, create_tenant_param_json={"charset":"utf8mb4","collation":"utf8mb4_general_ci","enableArbitration":false,"mode":"MYSQL","name":"Jx_His","parameters":[],"primaryZone":"zone1","rootPassword":"******","saveToCredential":true,"skipImportTenantInfo":false,"whitelist":"%","zones":[{"name":"zone1","replicaType":"FULL","resourcePool":{"unitCount":2,"unitSpecName":"LogOnlyNormal"}}]}, latest_execution_start_time=2024-11-08T18:30:04.446+08:00, sub_task_instance_name=Import tenant srs info, sub_task_instance_id=1000026}, listMap={}}, executor=192.168.18.130 2024-11-08 18:30:04.547 INFO 28647 --- [manual-subtask-executor16,f6f04bcef1be81f0,65f9285c09056029] c.o.o.o.i.t.t.ImportTenantSrsInfoTask : do nothing when rollback 2024-11-08 18:30:04.777 INFO 28647 --- [manual-subtask-executor16,f6f04bcef1be81f0,65f9285c09056029] c.o.o.c.agent.HostAgentServiceImpl : Finding OCP agent: hostId=1 2024-11-08 18:30:04.794 INFO 28647 --- [manual-subtask-executor16,f6f04bcef1be81f0,65f9285c09056029] c.o.o.c.a.p.HostAgentProcessServiceImpl : Getting all OCP agent processes on host 1 2024-11-08 18:30:04.942 INFO 28647 --- [manual-subtask-executor16,f6f04bcef1be81f0,65f9285c09056029] c.o.o.e.internal.template.HttpTemplate : POST request to agent, url:http://192.168.18.135:62888/api/v1/ob/importSrsInfo, request body:AsyncTaskRequest(taskToken=aaca552b-75c2-473d-aa8b-86e8fd2da579), params:null 2024-11-08 18:30:04.979 INFO 28647 --- [manual-subtask-executor16,f6f04bcef1be81f0,65f9285c09056029] c.o.o.e.internal.template.HttpTemplate : POST request to agent, url:http://192.168.18.135:62888/api/v1/task/status, request body:GetTaskStatusRequest(taskToken=aaca552b-75c2-473d-aa8b-86e8fd2da579), params:null 2024-11-08 18:30:04.997 INFO 28647 --- [manual-subtask-executor16,f6f04bcef1be81f0,65f9285c09056029] 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 /root/oceanbase/bin/import_srs_data.py -h192.168.18.135 -P2881 -p=xxx -t Jx_His -f /root/oceanbase/etc/default_srs_data_mysql.sql, timeout=20m0s}, exitCode: 127, output: sh: line 1: python: command not found , error: exit status 127, 2024-11-08 18:30:05.034 ERROR 28647 --- [manual-subtask-executor16,f6f04bcef1be81f0,65f9285c09056029] c.o.o.s.task.util.AgentAsyncTaskHelper : failed to execute async task, task token: aaca552b-75c2-473d-aa8b-86e8fd2da579, 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 /root/oceanbase/bin/import_srs_data.py -h192.168.18.135 -P2881 -p=xxx -t Jx_His -f /root/oceanbase/etc/default_srs_data_mysql.sql, timeout=20m0s}, exitCode: 127, output: sh: line 1: python: command not found , error: exit status 127 2024-11-08 18:30:05.057 ERROR 28647 --- [manual-subtask-executor16,f6f04bcef1be81f0,65f9285c09056029] c.o.ocp.core.util.ExceptionUtils : Checked Exception: com.oceanbase.ocp.core.exception.UnexpectedException occurred with code error.agent.task.failed, and args [aaca552b-75c2-473d-aa8b-86e8fd2da579, 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 /root/oceanbase/bin/import_srs_data.py -h192.168.18.135 -P2881 -p=xxx -t Jx_His -f /root/oceanbase/etc/default_srs_data_mysql.sql, timeout=20m0s}, exitCode: 127, output: sh: line 1: python: command not found , error: exit status 127] 2024-11-08 18:30:05.069 ERROR 28647 --- [manual-subtask-executor16,f6f04bcef1be81f0,65f9285c09056029] c.o.o.c.t.e.c.w.subtask.SubtaskExecutor : OCP-Agent task aaca552b-75c2-473d-aa8b-86e8fd2da579 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 /root/oceanbase/bin/import_srs_data.py -h192.168.18.135 -P2881 -p=xxx -t Jx_His -f /root/oceanbase/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=aaca552b-75c2-473d-aa8b-86e8fd2da579,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 /root/oceanbase/bin/import_srs_data.py -h192.168.18.135 -P2881 -p=xxx -t Jx_His -f /root/oceanbase/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:1732) at com.oceanbase.ocp.core.i18n.ErrorCodes.exception(ErrorCodes.java:1587) 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:262) at com.oceanbase.ocp.service.task.util.AgentAsyncTaskHelper.waitForExecuteFinish(AgentAsyncTaskHelper.java:208) at com.oceanbase.ocp.service.task.util.AgentAsyncTaskHelper.importSrsInfo(AgentAsyncTaskHelper.java:157) at com.oceanbase.ocp.obops.internal.cluster.ClusterHostOperationSe rviceImpl.importSrsInfo(ClusterHostOperationServiceImpl.java:499) at com.oceanbase.ocp.obops.internal.tenant.TenantOperationServiceImpl.importSrsInfo(TenantOperationServiceImpl.java:1495) 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:792) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:762) 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:762) at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:707) at com.oceanbase.ocp.obops.internal.tenant.TenantOperationServiceImpl$$EnhancerBySpringCGLIB$$1afe06c7.importSrsInfo() at com.oceanbase.ocp.obops.internal.tenant.task.ImportTenantSrsInfoTask.run(ImportTenantSrsInfoTask.java:42) at com.oceanbase.ocp.core.task.runtime.Subtask.retry(Subtask.java:49) at com.oceanbase.ocp.core.task.engine.runner.JavaSubtaskRunner.retry(JavaSubtaskRunner.java:76) at com.oceanbase.ocp.core.task.engine.runner.JavaSubtaskRunner.doRun(JavaSubtaskRunner.java:35) 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.r edirectConsoleOutput(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:748) Set state for subtask: 1000026, operation:RETRY, state: FAILED