ocp发起备份任务慢

OceanBase 技术问题
#1

【 使用环境 】生产环境
【 OB or 其他组件 】ocp
【 使用版本 】版本号: 4.4.2-20260721101640
【问题描述】在ocp上发起备份 很慢，一直在 查询备份租户
【复现路径】问题出现前后相关操作
【附件及日志】推荐使用OceanBase敏捷诊断工具obdiag收集诊断信息,详情参见链接（右键跳转查看）：

【SOP系列 22 】——故障诊断第一步(自助诊断和诊断信息收集)

【备注】基于 LLM 和开源文档 RAG 的论坛小助手已开放测试，在发帖时输入 [@论坛小助手] 即可召唤小助手，欢迎试用！

image
image1294×528 25.7 KB

想知道，ocp在 查询 什么 ？

#3

可以把ocp-server.log日志 发一下看看 谷歌浏览器 开发者模式 看看调用的API 找一下traceid信息

#4 
{data: {contents: [{alarmStoragePercentageThreshold: 80, configName: "nfs_backup_caqh_msp",…},…]},…}
data: {contents: [{alarmStoragePercentageThreshold: 80, configName: "nfs_backup_caqh_msp",…},…]}
duration: 131
server: "b7e6ebf350"
status: 200
successful: true
timestamp: "2026-10-15T14:12:51.937486782+08:00"
traceId: "9c1798c35dbdd45b"



[root@nd-ob-master04 log]#   grep  9c1798c35dbdd45b   ocp-server.log*
ocp-server.log:2026-10-15 14:12:51.814  INFO 52301 --- [http-nio-0.0.0.0-8080-exec-10,9c1798c35dbdd45b,7e03a1b7536c4af1] c.o.o.s.c.trace.RequestTracingAspect     : API: [GET /api/v2/ba
ckup/config/storages?clusterId=17, client=172.18.64.45, traceId=9c1798c35dbdd45b, method=IterableResponse com.oceanbase.ocp.server.common.controller.ObBackupController.getAvailableStor
ageConfigList(Long,BackupStorageType), args=17,]
ocp-server.log:2026-10-15 14:12:51.820  INFO 52301 --- [http-nio-0.0.0.0-8080-exec-10,9c1798c35dbdd45b,7e03a1b7536c4af1] c.o.o.b.i.s.BackupStorageConnectManager  : isPhysical=true, isL
ogical=false, isPhysicalAndWasLogical=false
ocp-server.log:2026-10-15 14:12:51.844  INFO 52301 --- [http-nio-0.0.0.0-8080-exec-10,9c1798c35dbdd45b,7e03a1b7536c4af1] c.o.o.b.i.s.BackupStorageConnectManager  : isPhysical=true, isL
ogical=false, isPhysicalAndWasLogical=false
ocp-server.log:2026-10-15 14:12:51.854  INFO 52301 --- [http-nio-0.0.0.0-8080-exec-10,9c1798c35dbdd45b,7e03a1b7536c4af1] c.o.o.b.i.s.BackupStorageConnectManager  : isPhysical=true, isL
ogical=false, isPhysicalAndWasLogical=false
ocp-server.log:2026-10-15 14:12:51.864  INFO 52301 --- [http-nio-0.0.0.0-8080-exec-10,9c1798c35dbdd45b,7e03a1b7536c4af1] c.o.o.b.i.s.BackupStorageConnectManager  : isPhysical=true, isL
ogical=false, isPhysicalAndWasLogical=false
ocp-server.log:2026-10-15 14:12:51.874  INFO 52301 --- [http-nio-0.0.0.0-8080-exec-10,9c1798c35dbdd45b,7e03a1b7536c4af1] c.o.o.b.i.s.BackupStorageConnectManager  : isPhysical=true, isL
ogical=false, isPhysicalAndWasLogical=false
ocp-server.log:2026-10-15 14:12:51.883  INFO 52301 --- [http-nio-0.0.0.0-8080-exec-10,9c1798c35dbdd45b,7e03a1b7536c4af1] c.o.o.b.i.s.BackupStorageConnectManager  : isPhysical=true, isL
ogical=false, isPhysicalAndWasLogical=false
ocp-server.log:2026-10-15 14:12:51.892  INFO 52301 --- [http-nio-0.0.0.0-8080-exec-10,9c1798c35dbdd45b,7e03a1b7536c4af1] c.o.o.b.i.s.BackupStorageConnectManager  : isPhysical=true, isL
ogical=false, isPhysicalAndWasLogical=false
ocp-server.log:2026-10-15 14:12:51.900  INFO 52301 --- [http-nio-0.0.0.0-8080-exec-10,9c1798c35dbdd45b,7e03a1b7536c4af1] c.o.o.b.i.s.BackupStorageConnectManager  : isPhysical=true, isL
ogical=false, isPhysicalAndWasLogical=false
ocp-server.log:2026-10-15 14:12:51.910  INFO 52301 --- [http-nio-0.0.0.0-8080-exec-10,9c1798c35dbdd45b,7e03a1b7536c4af1] c.o.o.b.i.s.BackupStorageConnectManager  : isPhysical=true, isL
ogical=false, isPhysicalAndWasLogical=false
ocp-server.log:2026-10-15 14:12:51.919  INFO 52301 --- [http-nio-0.0.0.0-8080-exec-10,9c1798c35dbdd45b,7e03a1b7536c4af1] c.o.o.b.i.s.BackupStorageConnectManager  : isPhysical=true, isL
ogical=false, isPhysicalAndWasLogical=false
ocp-server.log:2026-10-15 14:12:51.927  INFO 52301 --- [http-nio-0.0.0.0-8080-exec-10,9c1798c35dbdd45b,7e03a1b7536c4af1] c.o.o.b.i.s.BackupStorageConnectManager  : isPhysical=true, isL
ogical=false, isPhysicalAndWasLogical=false
ocp-server.log:2026-10-15 14:12:51.937  WARN 52301 --- [http-nio-0.0.0.0-8080-exec-10,9c1798c35dbdd45b,7e03a1b7536c4af1] c.o.o.b.i.u.BackupParamSecurityUtils     : storage[BACKUP_STORA
GE_FILE] not need desensitize accessKey.
ocp-server.log:2026-10-15 14:12:51.937  WARN 52301 --- [http-nio-0.0.0.0-8080-exec-10,9c1798c35dbdd45b,7e03a1b7536c4af1] c.o.o.b.i.u.BackupParamSecurityUtils     : storage[BACKUP_STORA
GE_FILE] not need desensitize accessKey.
ocp-server.log:2026-10-15 14:12:51.937  WARN 52301 --- [http-nio-0.0.0.0-8080-exec-10,9c1798c35dbdd45b,7e03a1b7536c4af1] c.o.o.b.i.u.BackupParamSecurityUtils     : storage[BACKUP_STORA
GE_FILE] not need desensitize accessKey.
ocp-server.log:2026-10-15 14:12:51.937  WARN 52301 --- [http-nio-0.0.0.0-8080-exec-10,9c1798c35dbdd45b,7e03a1b7536c4af1] c.o.o.b.i.u.BackupParamSecurityUtils     : storage[BACKUP_STORA
GE_FILE] not need desensitize accessKey.
ocp-server.log:2026-10-15 14:12:51.937  WARN 52301 --- [http-nio-0.0.0.0-8080-exec-10,9c1798c35dbdd45b,7e03a1b7536c4af1] c.o.o.b.i.u.BackupParamSecurityUtils     : storage[BACKUP_STORA
GE_FILE] not need desensitize accessKey.
ocp-server.log:2026-10-15 14:12:51.937  WARN 52301 --- [http-nio-0.0.0.0-8080-exec-10,9c1798c35dbdd45b,7e03a1b7536c4af1] c.o.o.b.i.u.BackupParamSecurityUtils     : storage[BACKUP_STORA
GE_FILE] not need desensitize accessKey.
ocp-server.log:2026-10-15 14:12:51.937  WARN 52301 --- [http-nio-0.0.0.0-8080-exec-10,9c1798c35dbdd45b,7e03a1b7536c4af1] c.o.o.b.i.u.BackupParamSecurityUtils     : storage[BACKUP_STORA
GE_FILE] not need desensitize accessKey.
ocp-server.log:2026-10-15 14:12:51.937  WARN 52301 --- [http-nio-0.0.0.0-8080-exec-10,9c1798c35dbdd45b,7e03a1b7536c4af1] c.o.o.b.i.u.BackupParamSecurityUtils     : storage[BACKUP_STORA
GE_FILE] not need desensitize accessKey.
ocp-server.log:2026-10-15 14:12:51.937  WARN 52301 --- [http-nio-0.0.0.0-8080-exec-10,9c1798c35dbdd45b,7e03a1b7536c4af1] c.o.o.b.i.u.BackupParamSecurityUtils     : storage[BACKUP_STORA
GE_FILE] not need desensitize accessKey.
ocp-server.log:2026-10-15 14:12:51.937  WARN 52301 --- [http-nio-0.0.0.0-8080-exec-10,9c1798c35dbdd45b,7e03a1b7536c4af1] c.o.o.b.i.u.BackupParamSecurityUtils     : storage[BACKUP_STORA
GE_FILE] not need desensitize accessKey.
ocp-server.log:2026-10-15 14:12:51.937  WARN 52301 --- [http-nio-0.0.0.0-8080-exec-10,9c1798c35dbdd45b,7e03a1b7536c4af1] c.o.o.b.i.u.BackupParamSecurityUtils     : storage[BACKUP_STORA
GE_FILE] not need desensitize accessKey.
ocp-server.log:2026-10-15 14:12:51.937  INFO 52301 --- [http-nio-0.0.0.0-8080-exec-10,9c1798c35dbdd45b,7e03a1b7536c4af1] c.o.o.s.c.trace.RequestTracingAspect     : API OK: [GET /api/v2
/backup/config/storages client=172.18.64.45, traceId=9c1798c35dbdd45b, duration=131 ms]
#5

基本知道问题了，但是不知道如何解决。
这个ocp管理了40多个集群，这个集群有 50多个租户，在ocp 发起备份的时候 需要便利这个集群下所有的租户的备份信息，没然后就超时了。
类似这种信息

image
image890×722 102 KB

#6

能把ocp-server.log、ocp-agent 的日志 完整提供一下么？看看是不是租户多的问题 你可以看看在ocp上看看这个集群里的元数据数据的ocp-meta租户下查询租户信息的语句 是不是超时了

#7

抱歉，日志外发比较麻烦。
我自己看了下，ocp元数据 没有慢sql ，基本上可以确定是ocp-server的性能问题了，我尝试 加一点内存给ocp-server.jar 试试

#8

嗯嗯 可以加内存 试一下