2025-10-22 16:47:26.808 INFO 16470 --- [manual-subtask-executor16,53897cae143d401d,972fe44834739996] c.o.ocp.service.iam.user.UserService : user 100 login with organization 10000000 2025-10-22 16:47:26.814 INFO 16470 --- [manual-subtask-executor16,53897cae143d401d,972fe44834739996] c.o.o.c.t.e.runner.JavaSubtaskRunner : Run subtask, id=5537, context=Context{parallelIdx=-1, stringMap={tenant_id=6, target_tenant_binlog_service_status=RUNNING, cluster_cdcro_password=xxx task_instance_id=5420, task_operation=execute, binlog_cluster_id=3, binlog_instance_replicate_count=1, tenant_binlog_service_id=6, operation_scope=Tenant, latest_execution_start_time=2025-10-22T16:47:26.774+08:00, sub_task_instance_name=Wait tenant binlog service active, sub_task_instance_id=5537, cluster_cdcro_username=cdcro}, listMap={binlog_service_obproxy_cluster_ids_to_add=[1], binlog_instance_parameters=[binlog_expire_logs_seconds|86400, binlog_expire_logs_size|53687091200]}}, executor=10.40.65.146 2025-10-22 16:47:26.846 INFO 16470 --- [manual-subtask-executor16,53897cae143d401d,972fe44834739996] c.o.o.b.operator.JdbcBinlogOperator : binlog operator created, connectProperties=ConnectProperties(address=10.40.65.151, port=2983, username=null, password=null) 2025-10-22 16:47:26.852 INFO 16470 --- [manual-subtask-executor16,53897cae143d401d,972fe44834739996] c.o.o.binlogsdk.operator.BinlogTemplate : [binlogsdk] sql: SHOW BINLOG STATUS FOR TENANT `myoceanbase2`.`test2` 2025-10-22 16:47:26.982 WARN 16470 --- [manual-subtask-executor16,53897cae143d401d,972fe44834739996] c.o.o.binlogsdk.operator.BinlogTemplate : [binlogsdk] query failed, sql: [SHOW BINLOG STATUS FOR TENANT `myoceanbase2`.`test2`], error message: [Incorrect result size: expected 1, actual 0] 2025-10-22 16:47:26.987 WARN 16470 --- [manual-subtask-executor16,53897cae143d401d,972fe44834739996] c.o.o.b.operator.JdbcBinlogOperator : no result for show binlog status, cluster: myoceanbase2, tenant: test2 2025-10-22 16:47:26.992 INFO 16470 --- [manual-subtask-executor16,53897cae143d401d,972fe44834739996] .b.i.t.WaitTenantBinlogServiceActiveTask : Tenant binlog service is not active, retrying... 2025-10-22 16:47:30.029 INFO 16470 --- [manual-subtask-executor16,53897cae143d401d,972fe44834739996] c.o.o.b.operator.JdbcBinlogOperator : binlog operator created, connectProperties=ConnectProperties(address=10.40.65.151, port=2983, username=null, password=null) 2025-10-22 16:47:30.034 INFO 16470 --- [manual-subtask-executor16,53897cae143d401d,972fe44834739996] c.o.o.binlogsdk.operator.BinlogTemplate : [binlogsdk] sql: SHOW BINLOG STATUS FOR TENANT `myoceanbase2`.`test2` 2025-10-22 16:47:30.166 INFO 16470 --- [manual-subtask-executor16,53897cae143d401d,972fe44834739996] .b.i.t.WaitTenantBinlogServiceActiveTask : Tenant binlog service is active, tenantId=6 2025-10-22 16:47:30.175 INFO 16470 --- [manual-subtask-executor16,53897cae143d401d,972fe44834739996] c.o.o.b.operator.JdbcBinlogOperator : binlog operator created, connectProperties=ConnectProperties(address=10.40.65.151, port=2983, username=null, password=null) 2025-10-22 16:47:30.214 INFO 16470 --- [manual-subtask-executor16,53897cae143d401d,972fe44834739996] c.o.o.binlogsdk.operator.BinlogTemplate : [binlogsdk] sql: SHOW BINLOG INSTANCES FOR `myoceanbase2`.`test2` 2025-10-22 16:47:30.345 INFO 16470 --- [manual-subtask-executor16,53897cae143d401d,972fe44834739996] .b.i.t.WaitTenantBinlogServiceActiveTask : Binlog instance [p9waot6hwm] status not normal, retrying... 2025-10-22 16:47:33.351 INFO 16470 --- [manual-subtask-executor16,53897cae143d401d,972fe44834739996] c.o.o.binlogsdk.operator.BinlogTemplate : [binlogsdk] sql: SHOW BINLOG INSTANCES FOR `myoceanbase2`.`test2` 2025-10-22 16:47:33.484 INFO 16470 --- [manual-subtask-executor16,53897cae143d401d,972fe44834739996] .b.i.t.WaitTenantBinlogServiceActiveTask : Binlog instance [p9waot6hwm] status not normal, retrying... 2025-10-22 16:47:36.490 INFO 16470 --- [manual-subtask-executor16,53897cae143d401d,972fe44834739996] c.o.o.binlogsdk.operator.BinlogTemplate : [binlogsdk] sql: SHOW BINLOG INSTANCES FOR `myoceanbase2`.`test2` 2025-10-22 16:47:36.622 INFO 16470 --- [manual-subtask-executor16,53897cae143d401d,972fe44834739996] .b.i.t.WaitTenantBinlogServiceActiveTask : Binlog instance [p9waot6hwm] status not normal, retrying... 2025-10-22 16:47:39.628 INFO 16470 --- [manual-subtask-executor16,53897cae143d401d,972fe44834739996] c.o.o.binlogsdk.operator.BinlogTemplate : [binlogsdk] sql: SHOW BINLOG INSTANCES FOR `myoceanbase2`.`test2` 2025-10-22 16:47:39.762 INFO 16470 --- [manual-subtask-executor16,53897cae143d401d,972fe44834739996] .b.i.t.WaitTenantBinlogServiceActiveTask : Binlog instance [p9waot6hwm] status not normal, retrying... 2025-10-22 16:47:42.769 INFO 16470 --- [manual-subtask-executor16,53897cae143d401d,972fe44834739996] c.o.o.binlogsdk.operator.BinlogTemplate : [binlogsdk] sql: SHOW BINLOG INSTANCES FOR `myoceanbase2`.`test2` 2025-10-22 16:47:42.900 INFO 16470 --- [manual-subtask-executor16,53897cae143d401d,972fe44834739996] .b.i.t.WaitTenantBinlogServiceActiveTask : Binlog instance [p9waot6hwm] status not normal, retrying... 2025-10-22 16:47:45.905 INFO 16470 --- [manual-subtask-executor16,53897cae143d401d,972fe44834739996] c.o.o.binlogsdk.operator.BinlogTemplate : [binlogsdk] sql: SHOW BINLOG INSTANCES FOR `myoceanbase2`.`test2` 2025-10-22 16:47:46.036 INFO 16470 --- [manual-subtask-executor16,53897cae143d401d,972fe44834739996] .b.i.t.WaitTenantBinlogServiceActiveTask : Binlog instance [p9waot6hwm] status not normal, retrying... 2025-10-22 16:47:49.042 INFO 16470 --- [manual-subtask-executor16,53897cae143d401d,972fe44834739996] c.o.o.binlogsdk.operator.BinlogTemplate : [binlogsdk] sql: SHOW BINLOG INSTANCES FOR `myoceanbase2`.`test2` 2025-10-22 16:47:49.174 INFO 16470 --- [manual-subtask-executor16,53897cae143d401d,972fe44834739996] .b.i.t.WaitTenantBinlogServiceActiveTask : Binlog instance [p9waot6hwm] status not normal, retrying... 2025-10-22 16:47:52.180 INFO 16470 --- [manual-subtask-executor16,53897cae143d401d,972fe44834739996] c.o.o.binlogsdk.operator.BinlogTemplate : [binlogsdk] sql: SHOW BINLOG INSTANCES FOR `myoceanbase2`.`test2` 2025-10-22 16:47:52.311 INFO 16470 --- [manual-subtask-executor16,53897cae143d401d,972fe44834739996] .b.i.t.WaitTenantBinlogServiceActiveTask : Binlog instance [p9waot6hwm] status not normal, retrying... 2025-10-22 16:47:52.822 ERROR 16470 --- [manual-subtask-executor16,53897cae143d401d,972fe44834739996] c.o.ocp.core.util.ExceptionUtils : Checked Exception: com.oceanbase.ocp.core.exception.UnexpectedException occurred with code error.binlog.instance.status.not.normal, and args [] 2025-10-22 16:47:52.833 ERROR 16470 --- [manual-subtask-executor16,53897cae143d401d,972fe44834739996] c.o.o.c.t.e.c.w.subtask.SubtaskExecutor : Binlog instance status is abnormal. com.oceanbase.ocp.core.exception.UnexpectedException: [OCP UnexpectedException]: status=500 INTERNAL_SERVER_ERROR, errorCode=BINLOG_INSTANCE_STATUS_NOT_NORMAL, args= at com.oceanbase.ocp.core.i18n.ErrorCodes$Kind$10.exception(ErrorCodes.java:1958) at com.oceanbase.ocp.core.i18n.ErrorCodes.exception(ErrorCodes.java:1813) 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.binlog.internal.task.WaitTenantBinlogServiceActiveTask.checkAllBinlogInstancesStatus(WaitTenantBinlogServiceActiveTask.java:118) at com.oceanbase.ocp.binlog.internal.task.WaitTenantBinlogServiceActiveTask.run(WaitTenantBinlogServiceActiveTask.java:56) 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:212) at com.oceanbase.ocp.core.task.engine.coordinator.worker.subtask.SubtaskExecutor.redirectConsoleOutput(SubtaskExecutor.java:206) 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-10-22 16:47:52.955 INFO 16470 --- [manual-subtask-executor16,53897cae143d401d,fcd517bc57c721ab] c.o.ocp.service.iam.user.UserService : user 100 login with organization 10000000 2025-10-22 16:47:52.962 WARN 16470 --- [manual-subtask-executor16,53897cae143d401d,fcd517bc57c721ab] c.o.o.c.t.e.runner.JavaSubtaskRunner : Cancel subtask, id=5537, context=Context{parallelIdx=-1, stringMap={tenant_id=6, target_tenant_binlog_service_status=RUNNING, cluster_cdcro_password=xxx task_instance_id=5420, task_operation=cancel, binlog_cluster_id=3, binlog_instance_replicate_count=1, tenant_binlog_service_id=6, operation_scope=Tenant, latest_execution_start_time=2025-10-22T16:47:52.915+08:00, sub_task_instance_name=Wait tenant binlog service active, sub_task_instance_id=5537, cluster_cdcro_username=cdcro}, listMap={binlog_service_obproxy_cluster_ids_to_add=[1], binlog_instance_parameters=[binlog_expire_logs_seconds|86400, binlog_expire_logs_size|53687091200]}}, operation=CANCEL, executor=10.40.65.146 Set state for subtask: 5537, operation:CANCEL, state: FAILED