【 使用环境 】生产环境 or 测试环境
【 OB or 其他组件 】
【 使用版本 】
【问题描述】清晰明确描述问题
【复现路径】问题出现前后相关操作
【附件及日志】推荐使用OceanBase敏捷诊断工具obdiag收集诊断信息,详情参见链接（右键跳转查看）：
【备注】基于 LLM 和开源文档 RAG 的论坛小助手已开放测试，在发帖时输入 [@论坛小助手] 即可召唤小助手，欢迎试用！
环境：通过rpm方式安装的5.7.25-OceanBase_CE-v4.6.0.0
操作步骤1：启动observer
[admin@rac2 arch]$ /home/admin/oceanbase/bin/observer -I 192.168.1.172 -P 2882 -p 2881 -z zone1 -d /data/oceanbase/store/obcluster -r ‘192.168.1.172:2882:2881’ -c 1 -n obcluster -o “memory_limit=12G,system_memory=4G,datafile_size=10G,log_disk_size=12G,cpu_count=8”
/home/admin/oceanbase/bin/observer -I 192.168.1.172 -P 2882 -p 2881 -z zone1 -d /data/oceanbase/store/obcluster -r 192.168.1.172:2882:2881 -c 1 -n obcluster -o memory_limit=12G,system_memory=4G,datafile_size=10G,log_disk_size=12G,cpu_count=8
local_ip: 192.168.1.172
rpc port: 2882
mysql port: 2881
zone: zone1
data_dir: /data/oceanbase/store/obcluster
rs list: 192.168.1.172:2882:2881
cluster id: 1
appname: obcluster
optstr: memory_limit=12G,system_memory=4G,datafile_size=10G,log_disk_size=12G,cpu_count=8
[admin@rac2 arch]$
[admin@rac2 arch]$ ps -ef|grep observer
admin 12766 1 99 10:41 ? 00:01:12 /home/admin/oceanbase/bin/observer -I 192.168.1.172 -P 2882 -p 2881 -z zone1 -d /data/oceanbase/store/obcluster -r 192.168.1.172:2882:2881 -c 1 -n obcluster -o memory_limit=12G,system_memory=4G,datafile_size=10G,log_disk_size=12G,cpu_count=8
admin 13744 11804 0 10:42 pts/0 00:00:00 grep --color=auto observer
操作步骤2：
查看删除策略、修改删除策略
[admin@rac2 ~]$ obclient -h 127.0.0.1 -P 2881 -u root@perf_tenant -p -A -Doceanbase
Enter password:
Welcome to the OceanBase. Commands end with ; or \g.
Your OceanBase connection id is 3221511394
Server version: OceanBase_CE 4.6.0.0 (r100000162026071511-ac29b5f39774cb025f12641014f48820dc0be70a) (Built Jul 15 2026 11:56:19)
Copyright (c) 2000, 2018, OceanBase and/or its affiliates. All rights reserved.
Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.
obclient(root@perf_tenant)[oceanbase]> SELECT * FROM oceanbase.DBA_OB_BACKUP_DELETE_POLICY;
±------------±----------------+
| POLICY_NAME | RECOVERY_WINDOW |
±------------±----------------+
| log_only | 3d |
±------------±----------------+
1 row in set (0.001 sec)
obclient(root@perf_tenant)[oceanbase]> ALTER SYSTEM DROP DELETE BACKUP POLICY ‘log_only’;
Query OK, 0 rows affected (0.024 sec)
调整为1d
obclient(root@perf_tenant)[oceanbase]> ALTER SYSTEM ADD DELETE BACKUP POLICY ‘log_only’ RECOVERY_WINDOW ‘1d’;
Query OK, 0 rows affected (0.065 sec)
obclient(root@perf_tenant)[oceanbase]> SELECT * FROM oceanbase.DBA_OB_BACKUP_DELETE_POLICY;
ERROR 2013 (HY000): Lost connection to MySQL server during query
obclient(root@perf_tenant)[oceanbase]>
3、此时observer的服务进程已经停止
