【 使用环境 】 测试环境
【 OB or 其他组件 】 OCP 4.3.5 OB 4.3.5.2
【问题描述】清晰明确描述问题
dear,
我在进行备份的时候，备份租户是可以成功的，备份集群一致失败，请问是什么原因呢？有没相关的文档参考，附上成功和失败的日志
失败的：
log_task_5000822.zip (4.8 KB)
log_task_5016277.zip (5.0 KB)
成功的：
log_task_5016285.zip (13.8 KB)
2025-07-11 16:25:00.442 ERROR 31959 --- [manual-subtask-executor2,c73d332b2ac9078a,52457f9b95486782] c.o.o.c.t.e.c.w.subtask.SubtaskExecutor : Failed to start log backup. Error message: data backup pre-check failed, log backup not started.查下这个看下
select * from cdb_ob_archivelog;赞一个
看看
–1004租户归档是STOP状态
obclient(root@(none))[oceanbase]> select * from cdb_ob_archivelog;
+-----------+---------+----------+-------------+---------+--------+---------------------+----------------------------+---------------------+----------------------------+------------+---------------+---------------+-----------------------+-----------+-------------+-------------+---------------------+--------------+----------------------+-------------------+---------------------+-----------------------------+----------------------+------------------------------+---------+-------------------------------------------------------------------------+
| TENANT_ID | DEST_ID | ROUND_ID | INCARNATION | DEST_NO | STATUS | START_SCN | START_SCN_DISPLAY | CHECKPOINT_SCN | CHECKPOINT_SCN_DISPLAY | COMPATIBLE | BASE_PIECE_ID | USED_PIECE_ID | PIECE_SWITCH_INTERVAL | UNIT_SIZE | COMPRESSION | INPUT_BYTES | INPUT_BYTES_DISPLAY | OUTPUT_BYTES | OUTPUT_BYTES_DISPLAY | COMPRESSION_RATIO | DELETED_INPUT_BYTES | DELETED_INPUT_BYTES_DISPLAY | DELETED_OUTPUT_BYTES | DELETED_OUTPUT_BYTES_DISPLAY | COMMENT | PATH |
+-----------+---------+----------+-------------+---------+--------+---------------------+----------------------------+---------------------+----------------------------+------------+---------------+---------------+-----------------------+-----------+-------------+-------------+---------------------+--------------+----------------------+-------------------+---------------------+-----------------------------+----------------------+------------------------------+---------+-------------------------------------------------------------------------+
| 1002 | 1001 | 2 | 1 | 0 | DOING | 1753953901077638000 | 2025-07-31 17:25:01.077638 | 1756694336863134003 | 2025-09-01 10:38:56.863134 | 1 | 3 | 34 | 86400000000 | 1 | none | 14655158451 | 13.65GB | 14655158451 | 13.65GB | 1.00 | 0 | 0.00MB | 0 | 0.00MB | | file:///ob_backup/zj_cluster1/1750322111/tenant_incarnation_1/1002/clog |
| 1004 | 1001 | 1 | 1 | 0 | STOP | 1750993077773206000 | 2025-06-27 10:57:57.773206 | 1750993437930271001 | 2025-06-27 11:03:57.930271 | 1 | 1 | 1 | 86400000000 | 1 | none | 72271009 | 68.92MB | 72271009 | 68.92MB | 1.00 | 0 | 0.00MB | 0 | 0.00MB | | file:///ob_backup/zj_cluster1/1750322111/tenant_incarnation_1/1004/clog |
| 1006 | 1001 | 4 | 1 | 0 | DOING | 1753953900859118000 | 2025-07-31 17:25:00.859118 | 1756694397574195001 | 2025-09-01 10:39:57.574195 | 1 | 5 | 36 | 86400000000 | 1 | none | 14610799568 | 13.61GB | 14610799568 | 13.61GB | 1.00 | 0 | 0.00MB | 0 | 0.00MB | | file:///ob_backup/zj_cluster1/1750322111/tenant_incarnation_1/1006/clog |
| 1008 | 1001 | 1 | 1 | 0 | DOING | 1756689151123986000 | 2025-09-01 09:12:31.123986 | 1756694434586922002 | 2025-09-01 10:40:34.586922 | 1 | 1 | 1 | 86400000000 | 1 | none | 217277806 | 207.21MB | 217277806 | 207.21MB | 1.00 | 0 | 0.00MB | 0 | 0.00MB | | file:///ob_backup/zj_cluster1/1750322111/tenant_incarnation_1/1008/clog |
| 1010 | 1001 | 1 | 1 | 0 | DOING | 1756689150235078000 | 2025-09-01 09:12:30.235078 | 1756694431540390002 | 2025-09-01 10:40:31.540390 | 1 | 1 | 1 | 86400000000 | 1 | none | 85658361 | 81.69MB | 85658361 | 81.69MB | 1.00 | 0 | 0.00MB | 0 | 0.00MB | | file:///ob_backup/zj_cluster1/1750322111/tenant_incarnation_1/1010/clog |
| 1012 | 1001 | 1 | 1 | 0 | DOING | 1756689151123986000 | 2025-09-01 09:12:31.123986 | 1756694433584797000 | 2025-09-01 10:40:33.584797 | 1 | 1 | 1 | 86400000000 | 1 | none | 196531916 | 187.43MB | 196531916 | 187.43MB | 1.00 | 0 | 0.00MB | 0 | 0.00MB | | file:///ob_backup/zj_cluster1/1750322111/tenant_incarnation_1/1012/clog |
| 1014 | 1001 | 1 | 1 | 0 | DOING | 1756689149984005000 | 2025-09-01 09:12:29.984005 | 1756694431140679003 | 2025-09-01 10:40:31.140679 | 1 | 1 | 1 | 86400000000 | 1 | none | 184186864 | 175.65MB | 184186864 | 175.65MB | 1.00 | 0 | 0.00MB | 0 | 0.00MB | | file:///ob_backup/zj_cluster1/1750322111/tenant_incarnation_1/1014/clog |
| 1016 | 1001 | 1 | 1 | 0 | DOING | 1756689150160834000 | 2025-09-01 09:12:30.160834 | 1756694433584797002 | 2025-09-01 10:40:33.584797 | 1 | 1 | 1 | 86400000000 | 1 | none | 191724185 | 182.84MB | 191724185 | 182.84MB | 1.00 | 0 | 0.00MB | 0 | 0.00MB | | file:///ob_backup/zj_cluster1/1750322111/tenant_incarnation_1/1016/clog |
| 1018 | 1001 | 1 | 1 | 0 | DOING | 1756689149904554000 | 2025-09-01 09:12:29.904554 | 1756694432143176001 | 2025-09-01 10:40:32.143176 | 1 | 1 | 1 | 86400000000 | 1 | none | 162299209 | 154.78MB | 162299209 | 154.78MB | 1.00 | 0 | 0.00MB | 0 | 0.00MB | | file:///ob_backup/zj_cluster1/1750322111/tenant_incarnation_1/1018/clog |
| 1020 | 1001 | 1 | 1 | 0 | DOING | 1756689149943722000 | 2025-09-01 09:12:29.943722 | 1756694432582193003 | 2025-09-01 10:40:32.582193 | 1 | 1 | 1 | 86400000000 | 1 | none | 156737938 | 149.48MB | 156737938 | 149.48MB | 1.00 | 0 | 0.00MB | 0 | 0.00MB | | file:///ob_backup/zj_cluster1/1750322111/tenant_incarnation_1/1020/clog |
| 1022 | 1001 | 1 | 1 | 0 | DOING | 1756689149832075000 | 2025-09-01 09:12:29.832075 | 1756694432799015000 | 2025-09-01 10:40:32.799015 | 1 | 1 | 1 | 86400000000 | 1 | none | 71623157 | 68.31MB | 71623157 | 68.31MB | 1.00 | 0 | 0.00MB | 0 | 0.00MB | | file:///ob_backup/zj_cluster1/1750322111/tenant_incarnation_1/1022/clog |
| 1024 | 1001 | 1 | 1 | 0 | DOING | 1756689149868014000 | 2025-09-01 09:12:29.868014 | 1756694433044487003 | 2025-09-01 10:40:33.044487 | 1 | 1 | 1 | 86400000000 | 1 | none | 70715049 | 67.44MB | 70715049 | 67.44MB | 1.00 | 0 | 0.00MB | 0 | 0.00MB | | file:///ob_backup/zj_cluster1/1750322111/tenant_incarnation_1/1024/clog |
+-----------+---------+----------+-------------+---------+--------+---------------------+----------------------------+---------------------+----------------------------+------------+---------------+---------------+-----------------------+-----------+-------------+-------------+---------------------+--------------+----------------------+-------------------+---------------------+-----------------------------+----------------------+------------------------------+---------+-------------------------------------------------------------------------+
12 rows in set (0.100 sec)
1 个赞
–因为1004租户的归档状态异常导致集群备份失败
2025-09-01 09:22:10.747 INFO 31959 --- [manual-subtask-executor16,5ba42e6f3b07f0f3,921de7d60ae1985e] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: select * from (SELECT incarnation, round_id AS log_archive_round, tenant_id, path AS backup_dest, IF(start_scn_display != '', start_scn_display, NULL) AS min_first_time, IF(checkpoint_scn_display != '', checkpoint_scn_display, NULL) AS max_next_time, status, IF(checkpoint_scn != '', truncate((time_to_usec(now()) - checkpoint_scn / 1000) / 1000000, 4), NULL) AS delay, now(6) AS check_time FROM CDB_OB_ARCHIVELOG_SUMMARY WHERE tenant_id = ? AND round_id = (SELECT MAX(round_id) FROM CDB_OB_ARCHIVELOG_SUMMARY WHERE tenant_id = ?)), args: [1004, 1004]
2025-09-01 09:22:10.755 ERROR 31959 --- [manual-subtask-executor16,5ba42e6f3b07f0f3,921de7d60ae1985e] c.o.o.c.t.e.c.w.subtask.SubtaskExecutor : Failed to start log backup. Error message: data backup pre-check failed, log backup not started.
com.oceanbase.ocp.core.exception.UnexpectedException: [OCP UnexpectedException]: status=500 INTERNAL_SERVER_ERROR, errorCode=BACKUP_START_LOG_BACKUP_FAILED, args=data backup pre-check failed, log backup not started
at com.oceanbase.ocp.backup.internal.operation.PhysicalBackupTaskService.waitLogBackupStarted(PhysicalBackupTaskService.java:292)
at com.oceanbase.ocp.backup.internal.task.schedule.StartLogBackupTask.run(StartLogBackupTask.java:54)
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:207)
at com.oceanbase.ocp.core.task.engine.coordinator.worker.subtask.SubtaskExecutor.redirectConsoleOutput(SubtaskExecutor.java:201)
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)
Set state for subtask: 5039682, operation:EXECUTE, state: FAILED
你在OCP上将1004租户的日志备份启动下 再试下
你好 这个租户的日志备份 确实是停止状态，这个如何启动呢
我的界面上操作这栏 没有按钮. 也没有备份清理.
4.3.5-20250319105844
你截图看下
租户点进去也不行 也没有 我看看有没命令行做这事
我现在大概知道是什么情况了:
1、 这个租户之前我测试了下 设置了一次周期备份测略
2、在设置了周期备份策略后，租户的日志备份那就有启动按钮了。但是我点启动的话，报错 ： is already archivelog mode；
3、我删除该租户的周期策略后，操作那就像之前传的图，没有按钮了。
很迷茫
了解了，不设置备份策略这里的确不显示启动按钮，
你之前应该是没有正常停止备份和日志归档，强删了备份策略
在1004租户下按如下步骤操作下，然后再启动集群级备份试下？
1.Alter system noarchivelog;
2.alter system set log_archive_dest= '';
3.alter system set data_backup_dest= '';