【 使用环境 】生产环境
【 OB or 其他组件 】
observe
【 使用版本 】
2.2.77
【问题描述】清晰明确描述问题
2024-07-05 19:50:39.394 INFO 56 — [pool-subtask-executor-thread-29,54205da52dfe4345,7b2a40b27711] c.a.o.c.m.t.model.SubtaskInstanceEntity : Run subtask, id=73127464, context=Context(parallelIdx=-1, stringMap={checkBeforeDataBackup=true, prohibit_rollback=false, task_instance_id=59098028, task_operation=execute, ob_cluster_id=2, startLogBackup=true, backupDim=CLUSTER, cluster_id=2, tenantName=*, backupMode=physical, triggerType=BACKUP_NOW, latest_execution_start_time=2024-07-05T19:50:39.384+08:00, backupNow=true, sub_task_instance_id=73127464, dataBackupMode=FULL_BACKUP, obClusterName=hndsj_yh}, listMap={}), executor=172.20.58.49
2024-07-05 19:50:39.590 INFO 56 — [pool-subtask-executor-thread-29,54205da52dfe4345,7b2a40b27711] c.a.o.s.o.o.f.ConnectPropertiesBuilder : user: root, tenant: sys, clusterName:hndsj_yh, obClusterId:1, connectionMode: proxy
2024-07-05 19:50:39.593 INFO 56 — [pool-subtask-executor-thread-29,54205da52dfe4345,7b2a40b27711] c.a.o.c.o.connector.ObConnectorHolder : [obsdk] no ob connector found in holder, key=ObConnectorKey(connectionMode=proxy, clusterName=hndsj_yh, obClusterId=1, tenantName=sys, username=root, address=localhost, port=2888, database=oceanbase)
2024-07-05 19:50:39.596 INFO 56 — [pool-subtask-executor-thread-29,54205da52dfe4345,7b2a40b27711] c.a.o.core.obsdk.connector.ObConnectors : [obsdk] create new ob connector, connectProperties=ConnectProperties(connectionMode=proxy, address=localhost, port=2888, obsAddrList=null, username=root, tenantName=sys, clusterName=hndsj_yh, obClusterId=1, compatibilityMode=MYSQL, database=oceanbase)
2024-07-05 19:50:39.604 INFO 56 — [pool-subtask-executor-thread-29,54205da52dfe4345,7b2a40b27711] c.a.o.core.obsdk.connector.ObConnectors : [obsdk] create new ob connector success
2024-07-05 19:50:39.606 INFO 56 — [pool-subtask-executor-thread-29,54205da52dfe4345,7b2a40b27711] c.a.o.c.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000]
2024-07-05 19:50:39.609 INFO 56 — [pool-subtask-executor-thread-29,54205da52dfe4345,7b2a40b27711] c.a.o.c.obsdk.connector.ConnectTemplate : [obsdk] sql: SELECT incarnation, log_archive_round, tenant_id, CASE WHEN min_first_time = ‘’ THEN usec_to_time(0) ELSE min_first_time END AS min_first_time, CASE WHEN max_next_time = ‘’ THEN usec_to_time(0) ELSE max_next_time END AS max_next_time, status, CASE WHEN max_next_time = ‘’ THEN 0 ELSE (time_to_usec(now()) - time_to_usec(max_next_time)) / 1000000 END AS delay, now(6) as check_time FROM CDB_OB_BACKUP_ARCHIVELOG_SUMMARY WHERE tenant_id = 1 AND log_archive_round = (SELECT MAX(log_archive_round) FROM CDB_OB_BACKUP_ARCHIVELOG_SUMMARY WHERE tenant_id = 1)
2024-07-05 19:50:39.615 INFO 56 — [pool-subtask-executor-thread-29,54205da52dfe4345,7b2a40b27711] c.a.o.c.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000]
2024-07-05 19:50:39.618 INFO 56 — [pool-subtask-executor-thread-29,54205da52dfe4345,7b2a40b27711] c.a.o.c.obsdk.connector.ConnectTemplate : [obsdk] sql: alter system archivelog
2024-07-05 19:50:39.626 ERROR 56 — [pool-subtask-executor-thread-29,54205da52dfe4345,7b2a40b27711] c.a.o.c.obsdk.connector.ConnectTemplate : [obsdk] execute failed, sql:[alter system archivelog], error message:[StatementCallback; uncategorized SQLException for SQL [alter system archivelog]; SQL state [0A000]; error code [1235]; start log archive backup when not STOP is not supported; nested exception is java.sql.SQLException: start log archive backup when not STOP is not supported]
2024-07-05 19:50:39.628 ERROR 56 — [pool-subtask-executor-thread-29,54205da52dfe4345,7b2a40b27711] c.a.o.s.o.b.PhysicalBackupObOpsService : SQL [alter system archivelog]; SQL state [0A000]; error code [1235]; message [start log archive backup when not STOP is not supported]
2024-07-05 19:50:39.631 INFO 56 — [pool-subtask-executor-thread-29,54205da52dfe4345,7b2a40b27711] c.a.o.c.m.t.model.SubtaskInstanceEntity : Set state for subtask: 73127464, current state: RUNNING, new state: FAILED
2024-07-05 19:50:39.641 WARN 56 — [pool-subtask-executor-thread-29,54205da52dfe4345,7b2a40b27711] c.a.o.c.t.engine.runner.RunnerFactory : Execute task failed, subtask=SubtaskInstanceEntity{id=73127464, name=Start log backup, state=FAILED, operation=EXECUTE, className=com.alipay.ocp.service.task.business.backup.StartLogBackupTask, seriesId=2, startTime=2024-07-05T19:50:39.385+08:00, endTime=2024-07-05T19:50:39.633+08:00}, failedMessage=Failed to start log backup. Error message: start log archive backup when not STOP is not supported.
com.alipay.ocp.core.exception.UnexpectedException: [OCP UnexpectedException]: status=500 INTERNAL_SERVER_ERROR, errorCode=BACKUP_START_LOG_BACKUP_FAILED, args=start log archive backup when not STOP is not supported
at com.alipay.ocp.service.operation.backup.PhysicalBackupObOpsService.startLogBackup(PhysicalBackupObOpsService.java:397) ~[ocp-service-3.1.2-20211025.jar!/:3.1.2-20211025]
at com.alipay.ocp.service.operation.backup.PhysicalBackupObOpsService.startLogBackup(PhysicalBackupObOpsService.java:378) ~[ocp-service-3.1.2-20211025.jar!/:3.1.2-20211025]
at com.alipay.ocp.service.operation.backup.PhysicalBackupTaskService.triggerLogBackup(PhysicalBackupTaskService.java:70) ~[ocp-service-3.1.2-20211025.jar!/:3.1.2-20211025]
at com.alipay.ocp.service.task.business.backup.StartLogBackupTask.run(StartLogBackupTask.java:42) ~[ocp-service-3.1.2-20211025.jar!/:3.1.2-20211025]
at com.alipay.ocp.core.metadb.task.model.SubtaskInstanceEntity.run(SubtaskInstanceEntity.java:219) ~[ocp-core-3.1.2-20211025.jar!/:3.1.2-20211025]
at com.alipay.ocp.core.task.engine.runner.JavaTaskRunner.doExecute(JavaTaskRunner.java:26) ~[ocp-core-3.1.2-20211025.jar!/:3.1.2-20211025]
at com.alipay.ocp.core.task.engine.runner.JavaTaskRunner.run(JavaTaskRunner.java:20) ~[ocp-core-3.1.2-20211025.jar!/:3.1.2-20211025]
at com.alipay.ocp.core.task.engine.runner.RunnerFactory.doRun(RunnerFactory.java:103) ~[ocp-core-3.1.2-20211025.jar!/:3.1.2-20211025]
at com.alipay.ocp.core.task.engine.runner.RunnerFactory.re
directOutputIfNotSysSchedule(RunnerFactory.java:147) ~[ocp-core-3.1.2-20211025.jar!/:3.1.2-20211025]
at com.alipay.ocp.core.task.engine.runner.RunnerFactory.run(RunnerFactory.java:92) ~[ocp-core-3.1.2-20211025.jar!/:3.1.2-20211025]
at com.alipay.ocp.core.task.engine.coordinator.worker.subtask.ReadySubtaskWorker.lambda$submitTask$2(ReadySubtaskWorker.java:123) ~[ocp-core-3.1.2-20211025.jar!/:3.1.2-20211025]
at java.util.concurrent.FutureTask.run(FutureTask.java:266) ~[na:1.8.0_275]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[na:1.8.0_275]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[na:1.8.0_275]
【复现路径】问题出现前后相关操作
【附件及日志】推荐使用OceanBase敏捷诊断工具obdiag收集诊断信息,详情参见链接（右键跳转查看）：