2024-06-24 10:36:45.410 INFO 15100 --- [pool-manual-subtask-executor16,c5ff88ba075244ae,315b1785eae2] c.o.o.c.t.e.runner.JavaSubtaskRunner : Run subtask, id=54, context=Context{parallelIdx=-1, stringMap={tenant_id=4, ob_tenant_id=1006, tenant_name=ht, ob_tenant_parameter_map=, task_instance_id=6, task_operation=execute, whitelist=%, target_tenant_status=NORMAL, resource_pool_list_json=[{"id":1003,"name":"pool_ht_zone1_lks","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":1,"zoneList":["zone1"]}], 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":"ht","parameters":[],"rootPassword":"******","saveToCredential":true,"whitelist":"%","zones":[{"name":"zone1","replicaType":"FULL","resourcePool":{"unitCount":1,"unitSpecName":"LogOnlyNormal"}}]}, latest_execution_start_time=2024-06-24T10:36:45.383+08:00, sub_task_instance_name=Import tenant srs info, sub_task_instance_id=54}, listMap={}}, executor=192.168.10.6 2024-06-24 10:36:45.439 INFO 15100 --- [pool-manual-subtask-executor16,c5ff88ba075244ae,315b1785eae2] c.o.o.c.agent.HostAgentServiceImpl : Finding OCP agent: hostId=1 2024-06-24 10:36:45.443 INFO 15100 --- [pool-manual-subtask-executor16,c5ff88ba075244ae,315b1785eae2] c.o.o.c.a.p.HostAgentProcessServiceImpl : Getting all OCP agent processes on host 1 2024-06-24 10:36:45.481 INFO 15100 --- [pool-manual-subtask-executor16,c5ff88ba075244ae,315b1785eae2] c.o.o.e.internal.template.HttpTemplate : POST request to agent, url:http://192.168.10.6:62888/api/v1/ob/importSrsInfo, request body:AsyncTaskRequest(taskToken=0877a6e7-fd38-4cf4-9554-36c005a98bce), params:null 2024-06-24 10:36:45.489 INFO 15100 --- [pool-manual-subtask-executor16,c5ff88ba075244ae,315b1785eae2] c.o.o.e.internal.template.HttpTemplate : POST request to agent, url:http://192.168.10.6:62888/api/v1/task/status, request body:GetTaskStatusRequest(taskToken=0877a6e7-fd38-4cf4-9554-36c005a98bce), params:null 2024-06-24 10:36:45.503 INFO 15100 --- [pool-manual-subtask-executor16,c5ff88ba075244ae,315b1785eae2] c.o.o.s.task.util.AgentAsyncTaskHelper : try to request task result(EXECUTE), result:false,null,, 2024-06-24 10:36:45.540 INFO 15100 --- [pool-manual-subtask-executor16,c5ff88ba075244ae,315b1785eae2] c.o.ocp.common.lang.pattern.Retry : wait for 10 seconds 2024-06-24 10:36:55.542 INFO 15100 --- [pool-manual-subtask-executor16,c5ff88ba075244ae,315b1785eae2] c.o.o.e.internal.template.HttpTemplate : POST request to agent, url:http://192.168.10.6:62888/api/v1/task/status, request body:GetTaskStatusRequest(taskToken=0877a6e7-fd38-4cf4-9554-36c005a98bce), params:null 2024-06-24 10:36:55.547 INFO 15100 --- [pool-manual-subtask-executor16,c5ff88ba075244ae,315b1785eae2] 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 /home/admin/oceanbase/bin/import_srs_data.py -h192.168.10.6 -P2881 -p=xxx -t ht -f /home/admin/oceanbase/etc/default_srs_data_mysql.sql, timeout=20m0s}, exitCode: 1, output: File "/home/admin/oceanbase/bin/import_srs_data.py", line 27 print "host:{0} port:{1} pwd:{2} file:{3}".format(self.host, self.port, self.pwd, self.file_name) ^ SyntaxError: invalid syntax , error: exit status 1, 2024-06-24 10:36:55.550 ERROR 15100 --- [pool-manual-subtask-executor16,c5ff88ba075244ae,315b1785eae2] c.o.o.s.task.util.AgentAsyncTaskHelper : failed to execute async task, task token: 0877a6e7-fd38-4cf4-9554-36c005a98bce, 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 /home/admin/oceanbase/bin/import_srs_data.py -h192.168.10.6 -P2881 -p=xxx -t ht -f /home/admin/oceanbase/etc/default_srs_data_mysql.sql, timeout=20m0s}, exitCode: 1, output: File "/home/admin/oceanbase/bin/import_srs_data.py", line 27 print "host:{0} port:{1} pwd:{2} file:{3}".format(self.host, self.port, self.pwd, self.file_name) ^ SyntaxError: invalid syntax , error: exit status 1 2024-06-24 10:36:55.553 ERROR 15100 --- [pool-manual-subtask-executor16,c5ff88ba075244ae,315b1785eae2] c.o.ocp.core.util.ExceptionUtils : Checked Exception: com.oceanbase.ocp.core.exception.UnexpectedException occurred with code error.agent.task.failed, and args [0877a6e7-fd38-4cf4-9554-36c005a98bce, 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 /home/admin/oceanbase/bin/import_srs_data.py -h192.168.10.6 -P2881 -p=xxx -t ht -f /home/admin/oceanbase/etc/default_srs_data_mysql.sql, timeout=20m0s}, exitCode: 1, output: File "/home/admin/oceanbase/bin/import_srs_data.py", line 27 print "host:{0} port:{1} pwd:{2} file:{3}".format(self.host, self.port, self.pwd, self.file_name) ^ SyntaxError: invalid syntax , error: exit status 1] 2024-06-24 10:36:55.559 ERROR 15100 --- [pool-manual-subtask-executor16,c5ff88ba075244ae,315b1785eae2] c.o.o.c.t.e.c.w.subtask.SubtaskExecutor : OCP-Agent task 0877a6e7-fd38-4cf4-9554-36c005a98bce 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 /home/admin/oceanbase/bin/import_srs_data.py -h192.168.10.6 -P2881 -p=xxx -t ht -f /home/admin/oceanbase/etc/default_srs_data_mysql.sql, timeout=20m0s}, exitCode: 1, output: File "/home/admin/oceanbase/bin/import_srs_data.py", line 27 print "host:{0} port:{1} pwd:{2} file:{3}".format(self.host, self.port, self.pwd, self.file_name) ^ 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=0877a6e7-fd38-4cf4-9554-36c005a98bce,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 /home/admin/oceanbase/bin/import_srs_data.py -h192.168.10.6 -P2881 -p=xxx -t ht -f /home/admin/oceanbase/etc/default_srs_data_mysql.sql, timeout=20m0s}, exitCode: 1, output: File "/home/admin/oceanbase/bin/import_srs_data.py", line 27 print "host:{0} port:{1} pwd:{2} file:{3}".format(self.host, self.port, self.pwd, self.file_name) ^ SyntaxError: invalid syntax , error: exit status 1 at com.oceanbase.ocp.core.i18n.ErrorCodes$Kind$10.exception(ErrorCodes.java:1622) at com.oceanbase.ocp.core.i18n.ErrorCodes.exception(ErrorCodes.java:1477) 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.AgentAsyncTa skHelper.checkSuccess(AgentAsyncTaskHelper.java:235) at com.oceanbase.ocp.service.task.util.AgentAsyncTaskHelper.waitForExecuteFinish(AgentAsyncTaskHelper.java:181) at com.oceanbase.ocp.service.task.util.AgentAsyncTaskHelper.importSrsInfo(AgentAsyncTaskHelper.java:154) at com.oceanbase.ocp.obops.internal.cluster.ClusterHostOperationServiceImpl.importSrsInfo(ClusterHostOperationServiceImpl.java:499) at com.oceanbase.ocp.obops.internal.tenant.TenantOperationServiceImpl.importSrsInfo(TenantOperationServiceImpl.java:1162) 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$$5c935ee3.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.oceanbas e.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.SubtaskExecutor.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:750) Set state for subtask: 54, operation:EXECUTE, state: FAILED