OceanBase 租户日志盘不回收，LS_ID 1001 不可回收日志量持续增长

AntTech_ZZ5QZV · 2026 年11 月 11 日 16:42

环境信息 ：OceanBase 版本4.3.5.6
问题描述 ：租户 1002 的日志盘使用率接近 80%，查询 gv$ob_log_stat 发现 LS_ID 1001 的 UNRECYCLABLE_MB 持续增长，但 GV$OB_TABLET_COMPACTION_PROGRESS 和 GV$OB_COMPACTION_DIAGNOSE_INFO 均查不到进行中的转储任务。

淇铭 · 2026 年11 月 11 日 16:44

使用的是社区版的ob吧

AntTech_ZZ5QZV · 2026 年11 月 11 日 16:44

是的，社区版

淇铭 · 2026 年11 月 11 日 16:52

目前ob的环境是有什么问题么？查一下这个信息
SELECT svr_ip, svr_port, service_type, rec_log_scn
FROM oceanbase.__all_virtual_checkpoint
WHERE tenant_id = 1002 AND ls_id = 1001
ORDER BY rec_log_scn;

SELECT ls_id, status, start_scn, checkpoint_scn
FROM oceanbase.CDB_OB_ARCHIVELOG
WHERE tenant_id = 1002;

SELECT svr_ip, svr_port, checkpoint_type, tablet_id, rec_log_scn

FROM oceanbase.__all_virtual_transaction_checkpoint

WHERE tenant_id = 1002 AND ls_id = 1001

ORDER BY rec_log_scn;

AntTech_ZZ5QZV · 2026 年11 月 11 日 16:59

目前业务层面暂时没有出现实际的问题或阻塞，但我在巡检时发现了这一个我认为存在隐患的指标。

SELECT svr_ip, svr_port, service_type, rec_log_scn
FROM oceanbase.__all_virtual_checkpoint
WHERE tenant_id = 1002 AND ls_id = 1001
ORDER BY rec_log_scn;

svr_ip	svr_port	service_type	rec_log_scn
192.168.150.200	32882	TRANS_SERVICE	1794335530457307000
192.168.150.200	32882	TABLE_LOCK	1794360688071236000
192.168.150.200	32882	STORAGE_SCHEMA	4611686018427387903
192.168.150.200	32882	TABLET_SEQ_SYNC	4611686018427387903
192.168.150.200	32882	DDL	4611686018427387903
192.168.150.200	32882	KEEP_ALIVE	4611686018427387903
192.168.150.200	32882	GC_LS	4611686018427387903
192.168.150.200	32882	RESERVED_SNAPSHOT	4611686018427387903
192.168.150.200	32882	MEDIUM_COMPACTION	4611686018427387903
192.168.150.200	32882	DUP_TABLE	4611686018427387903
192.168.150.200	32882	TRANSFER_HANDLER	4611686018427387903
192.168.150.200	32882	BLOCK_TX_SERVICE	4611686018427387903
192.168.150.200	32882	TTL_SERVICE	4611686018427387903
192.168.150.200	32882	VEC_INDEX_SERVICE	4611686018427387903

SELECT TENANT_ID,DEST_ID, status, start_scn, checkpoint_scn
FROM oceanbase.CDB_OB_ARCHIVELOG
WHERE tenant_id = 1002; （ls_id不存在该列）

TENANT_ID	DEST_ID	status	start_scn	checkpoint_scn
1002	1007	DOING	1793983634848919000	1794387490872211000

SELECT svr_ip, svr_port, checkpoint_type, tablet_id, rec_log_scn

FROM oceanbase.__all_virtual_transaction_checkpoint

WHERE tenant_id = 1002 AND ls_id = 1001

ORDER BY rec_log_scn;

svr_ip	svr_port	checkpoint_type	tablet_id	rec_log_scn
192.168.150.200	32882	DATA_CHECKPOINT_TYPE	40000	1794335530457307000
192.168.150.200	32882	TX_DATA_MEMTABLE_TYPE	49402	1794387271689364000
192.168.150.200	32882	TX_CTX_MEMTABLE_TYPE	49401	4611686018427387903
192.168.150.200	32882	MDS_TABLE_TYPE	0	4611686018427387903

淇铭 · 2026 年11 月 11 日 17:03

SELECT location, COUNT(*) cnt, MIN(rec_log_scn) min_rec, MAX(rec_log_scn) max_rec
FROM oceanbase.__all_virtual_transaction_freeze_checkpoint
WHERE tenant_id = 1002 AND ls_id = 1001
GROUP BY location;

SELECT tablet_id, location, rec_log_scn, write_ref_cnt, unsynced_cnt, end_scn
FROM oceanbase.__all_virtual_transaction_freeze_checkpoint
WHERE tenant_id = 1002 AND ls_id = 1001
ORDER BY rec_log_scn
LIMIT 30;

这两个也查一下

AntTech_ZZ5QZV · 2026 年11 月 11 日 17:10

SELECT location, COUNT(*) cnt, MIN(rec_log_scn) min_rec, MAX(rec_log_scn) max_rec
FROM oceanbase.__all_virtual_transaction_freeze_checkpoint
WHERE tenant_id = 1002 AND ls_id = 1001
GROUP BY location;

location	cnt	min_rec	max_rec
ACTIVE	355	1794335530457307000	1794387375148302000

SELECT tablet_id, location, rec_log_scn, write_ref_cnt, unsynced_cnt, end_scn
FROM oceanbase.__all_virtual_transaction_freeze_checkpoint
WHERE tenant_id = 1002 AND ls_id = 1001
ORDER BY rec_log_scn
LIMIT 30; （有些字段不存在）

svr_ip	svr_port	tenant_id	ls_id	tablet_id	rec_log_scn	location	rec_log_scn_is_stable
192.168.150.200	32882	1002	1001	1152921504606848475	1794335530457307000	ACTIVE	1
192.168.150.200	32882	1002	1001	200545	1794335530457307000	ACTIVE	1
192.168.150.200	32882	1002	1001	1152921504606848478	1794335530457307000	ACTIVE	1
192.168.150.200	32882	1002	1001	1152921504606848477	1794335530457307000	ACTIVE	1
192.168.150.200	32882	1002	1001	1152921504606848474	1794335530457307000	ACTIVE	1
192.168.150.200	32882	1002	1001	1152921504606848476	1794335530457307000	ACTIVE	1
192.168.150.200	32882	1002	1001	200572	1794335530498860000	ACTIVE	1
192.168.150.200	32882	1002	1001	1152921504606848662	1794335530498860000	ACTIVE	1
192.168.150.200	32882	1002	1001	1152921504606848661	1794335530498860000	ACTIVE	1
192.168.150.200	32882	1002	1001	1152921504606848660	1794335530498860000	ACTIVE	1
192.168.150.200	32882	1002	1001	1152921504606848659	1794335530498860000	ACTIVE	1
192.168.150.200	32882	1002	1001	1152921504606848658	1794335530498860000	ACTIVE	1
192.168.150.200	32882	1002	1001	1152921504606848479	1794335548821180000	ACTIVE	1
192.168.150.200	32882	1002	1001	201010	1794335557346810001	ACTIVE	1
192.168.150.200	32882	1002	1001	1152921504606850941	1794335557346810003	ACTIVE	1
192.168.150.200	32882	1002	1001	1152921504606850940	1794335557346810004	ACTIVE	1
192.168.150.200	32882	1002	1001	1152921504606850939	1794335557346810005	ACTIVE	1
192.168.150.200	32882	1002	1001	1152921504606850938	1794335557346810006	ACTIVE	1
192.168.150.200	32882	1002	1001	1152921504606850937	1794335557346810007	ACTIVE	1
192.168.150.200	32882	1002	1001	1152921504606850936	1794335557346810009	ACTIVE	1
192.168.150.200	32882	1002	1001	1152921504606850935	1794335559241592002	ACTIVE	1
192.168.150.200	32882	1002	1001	200581	1794335597394387001	ACTIVE	1
192.168.150.200	32882	1002	1001	1152921504606848716	1794335597394387003	ACTIVE	1
192.168.150.200	32882	1002	1001	1152921504606848717	1794335597724158001	ACTIVE	1
192.168.150.200	32882	1002	1001	200580	1794335602900680001	ACTIVE	1
192.168.150.200	32882	1002	1001	201185	1794335616917337005	ACTIVE	1
192.168.150.200	32882	1002	1001	1152921504606852863	1794335616917337007	ACTIVE	1
192.168.150.200	32882	1002	1001	1152921504606852864	1794335617418214001	ACTIVE	1
192.168.150.200	32882	1002	1001	1152921504606852875	1794335617418214002	ACTIVE	1
192.168.150.200	32882	1002	1001	1152921504606852876	1794335617418214003	ACTIVE	1

淇铭 · 2026 年11 月 11 日 17:13

LS 1001 上有 355 个 memtable 停在 ACTIVE，冻结没有完成，所以不会进 PREPARE，转储 DAG 也不会创建。预期内

SELECT *

FROM oceanbase.__all_virtual_minor_freeze_info

WHERE tenant_id = 1002 AND ls_id = 1001;

SELECT tenant_id, svr_ip, svr_port,
ROUND(LOG_DISK_SIZE/1024/1024/1024,2) AS log_disk_gb,
ROUND(LOG_DISK_IN_USE/1024/1024/1024,2) AS used_gb,
ROUND(LOG_DISK_IN_USE100.0/LOG_DISK_SIZE,2) AS used_pct,
ROUND(LOG_DISK_SIZE0.3/1024/1024/1024,2) AS need_flush_unrecyc_gb
FROM oceanbase.gv$ob_units
WHERE tenant_id = 1002;

这两个信息都查一下看看

AntTech_ZZ5QZV · 2026 年11 月 11 日 17:19

SELECT *

FROM oceanbase.__all_virtual_minor_freeze_info

WHERE tenant_id = 1002 AND ls_id = 1001;

svr_ip	svr_port	tenant_id	ls_id	tablet_id	is_force	freeze_clock	freeze_snapshot_version	start_time	end_time	ret_code	state	diagnose_info	memtables_info
192.168.150.200	32882	1002	1001	0	NO	38	1794340318038001003	2026-11-11 03:51:58.584822	2026-11-11 03:51:58.593346	0	FINISH	tablet_freeze success

SELECT tenant_id, svr_ip, svr_port,
ROUND(LOG_DISK_SIZE/1024/1024/1024,2) AS log_disk_gb,
ROUND(LOG_DISK_IN_USE/1024/1024/1024,2) AS used_gb,
ROUND(LOG_DISK_IN_USE * 100.0/LOG_DISK_SIZE,2) AS used_pct,
ROUND(LOG_DISK_SIZE * 0.3/1024/1024/1024,2) AS need_flush_unrecyc_gb
FROM oceanbase.gv$ob_units
WHERE tenant_id = 1002;

tenant_id	svr_ip	svr_port	log_disk_gb	used_gb	used_pct	need_flush_unrecyc_gb
1002	192.168.150.200	32882	270.00	215.99	80.00	81.00

淇铭 · 2026 年11 月 11 日 17:27

SELECT ls_id, role, svr_ip,
begin_lsn, base_lsn, end_lsn,
(end_lsn-begin_lsn)/1024/1024 AS used_like_mb,
(end_lsn-base_lsn)/1024/1024 AS unrecyclable_mb,
(base_lsn-begin_lsn)/1024/1024 AS recyclable_but_not_gc_mb
FROM oceanbase.gv$ob_log_stat
WHERE tenant_id = 1002 AND svr_ip = ‘192.168.150.200’
ORDER BY used_like_mb DESC; 这个在查一下

AntTech_ZZ5QZV · 2026 年11 月 11 日 17:28

ls_id	role	svr_ip	begin_lsn	base_lsn	end_lsn	used_like_mb	unrecyclable_mb	recyclable_but_not_gc_mb
1001	LEADER	192.168.150.200	1213455519744	1430069710848	1441694942753	217666.07571507	11086.68509007	206579.39062500
1	LEADER	192.168.150.200	33082650624	36437889024	36591704732	3346.49477768	146.69009018	3199.80468750

淇铭 · 2026 年11 月 11 日 17:33

AntTech_ZZ5QZV · 2026 年11 月 11 日 17:42

[2026-11-11 17:31:46.151506] INFO [PALF] recycle_blocks_ (palf_env_impl.cpp:1172) [8536][T1002_TimerWK2_PalfGC][T1002][Y0-0000000000000000-0-0] recycle_blocks success(functor={id:1001, min_block_max_scn:{val:1792955797300957015, v:0}, min_block_id:18083, min_using_block_id:21311, oldest_palf_id:1001, oldest_block_scn:{val:1792955797300957015, v:0}, ret_code:0})

[2026-11-11 17:31:46.151525] WDIAG [PALF] runTimerTask (block_gc_timer_task.cpp:94) [8536][T1002_TimerWK2_PalfGC][T1002][Y0-0000000000000000-0-0] [errcode=-4389] try_recycle_blocks cost too much time(cost_time_us=3572, log_dir:"/root/std-dig/OceanBase/data/clog/tenant_1002", cur_unrecyclable_log_disk_size(MB):11391)

[2026-11-11 17:31:51.149923] INFO [PALF] try_recycle_blocks (palf_env_impl.cpp:799) [8537][T1002_TimerWK3_PalfGC][T1002][Y0-0000000000000000-0-0] LOG_DISK_OPTION(cur_unrecyclable_log_disk_size(MB):11393, sequence:1)

淇铭 · 2026 年11 月 11 日 17:44

目前查看是因为日志的GC速度有点慢日志又在写入
5-10分钟查一次 gc是否持续推进
SELECT ls_id,
begin_lsn, base_lsn, end_lsn,
(base_lsn-begin_lsn)/1024/1024 AS recyclable_pending_gc_mb,
(end_lsn-base_lsn)/1024/1024 AS unrecyclable_mb
FROM oceanbase.gv$ob_log_stat
WHERE tenant_id=1002 AND ls_id=1001 AND role=‘LEADER’;

grep ‘recycle_blocks success’ observer.log* | grep ‘T1002’ | grep ‘id:1001’ | tail -20
这个日志文件整个提供一下
observer.log.20261111173333114

AntTech_ZZ5QZV · 2026 年11 月 11 日 17:51

这个observer.log.20261111173333114文件200多MB，我担心其中会有敏感数据，可以给出命令筛出来一些日志提供给你吗？

(base) [root@192-168-150-200 log]# grep “recycle_blocks success” observer.log* | grep “T1002” | grep “id:1001” | tail -20
observer.log.20261111125836838:[2026-11-11 12:51:47.643352] INFO [PALF] recycle_blocks_ (palf_env_impl.cpp:1172) [8536][T1002_TimerWK2_PalfGC][T1002][Y0-0000000000000000-0-0] [lt=44] recycle_blocks success(functor={id:1001, min_block_max_scn:{val:1792954816153257008, v:0}, min_block_id:18066, min_using_block_id:21311, oldest_palf_id:1001, oldest_block_scn:{val:1792954816153257008, v:0}, ret_code:0})
observer.log.20261111125836838:[2026-11-11 12:52:01.009459] INFO [PALF] recycle_blocks_ (palf_env_impl.cpp:1172) [8534][T1002_TimerWK0_PalfGC][T1002][Y0-0000000000000000-0-0] [lt=13] recycle_blocks success(functor={id:1001, min_block_max_scn:{val:1792954874832060007, v:0}, min_block_id:18067, min_using_block_id:21311, oldest_palf_id:1001, oldest_block_scn:{val:1792954874832060007, v:0}, ret_code:0})
observer.log.20261111125836838:[2026-11-11 12:52:19.267929] INFO [PALF] recycle_blocks_ (palf_env_impl.cpp:1172) [8536][T1002_TimerWK2_PalfGC][T1002][Y0-0000000000000000-0-0] [lt=29] recycle_blocks success(functor={id:1001, min_block_max_scn:{val:1792954924912694017, v:0}, min_block_id:18068, min_using_block_id:21311, oldest_palf_id:1001, oldest_block_scn:{val:1792954924912694017, v:0}, ret_code:0})
observer.log.20261111125836838:[2026-11-11 12:52:38.076576] INFO [PALF] recycle_blocks_ (palf_env_impl.cpp:1172) [8534][T1002_TimerWK0_PalfGC][T1002][Y0-0000000000000000-0-0] [lt=23] recycle_blocks success(functor={id:1001, min_block_max_scn:{val:1792954983649537012, v:0}, min_block_id:18069, min_using_block_id:21311, oldest_palf_id:1001, oldest_block_scn:{val:1792954983649537012, v:0}, ret_code:0})
observer.log.20261111132423675:[2026-11-11 13:24:21.265396] INFO [PALF] recycle_blocks_ (palf_env_impl.cpp:1172) [8534][T1002_TimerWK0_PalfGC][T1002][Y0-0000000000000000-0-0] [lt=25] recycle_blocks success(functor={id:1001, min_block_max_scn:{val:1792955070047796008, v:0}, min_block_id:18070, min_using_block_id:21311, oldest_palf_id:1001, oldest_block_scn:{val:1792955070047796008, v:0}, ret_code:0})
observer.log.20261111135115661:[2026-11-11 13:46:32.508364] INFO [PALF] recycle_blocks_ (palf_env_impl.cpp:1172) [8536][T1002_TimerWK2_PalfGC][T1002][Y0-0000000000000000-0-0] [lt=17] recycle_blocks success(functor={id:1001, min_block_max_scn:{val:1792955117006952006, v:0}, min_block_id:18071, min_using_block_id:21311, oldest_palf_id:1001, oldest_block_scn:{val:1792955117006952006, v:0}, ret_code:0})
observer.log.20261111140959052:[2026-11-11 14:08:06.192525] INFO [PALF] recycle_blocks_ (palf_env_impl.cpp:1172) [8536][T1002_TimerWK2_PalfGC][T1002][Y0-0000000000000000-0-0] [lt=18] recycle_blocks success(functor={id:1001, min_block_max_scn:{val:1792955197741281004, v:0}, min_block_id:18072, min_using_block_id:21311, oldest_palf_id:1001, oldest_block_scn:{val:1792955197741281004, v:0}, ret_code:0})
observer.log.20261111143604775:[2026-11-11 14:31:45.863046] INFO [PALF] recycle_blocks_ (palf_env_impl.cpp:1172) [8537][T1002_TimerWK3_PalfGC][T1002][Y0-0000000000000000-0-0] [lt=23] recycle_blocks success(functor={id:1001, min_block_max_scn:{val:1792955250277406012, v:0}, min_block_id:18073, min_using_block_id:21311, oldest_palf_id:1001, oldest_block_scn:{val:1792955250277406012, v:0}, ret_code:0})
observer.log.20261111150304362:[2026-11-11 15:02:34.350222] INFO [PALF] recycle_blocks_ (palf_env_impl.cpp:1172) [8534][T1002_TimerWK0_PalfGC][T1002][Y0-0000000000000000-0-0] [lt=16] recycle_blocks success(functor={id:1001, min_block_max_scn:{val:1792955318187935019, v:0}, min_block_id:18074, min_using_block_id:21311, oldest_palf_id:1001, oldest_block_scn:{val:1792955318187935019, v:0}, ret_code:0})
observer.log.20261111153606072:[2026-11-11 15:35:07.248031] INFO [PALF] recycle_blocks_ (palf_env_impl.cpp:1172) [8537][T1002_TimerWK3_PalfGC][T1002][Y0-0000000000000000-0-0] [lt=10] recycle_blocks success(functor={id:1001, min_block_max_scn:{val:1792955443887861006, v:0}, min_block_id:18075, min_using_block_id:21311, oldest_palf_id:1001, oldest_block_scn:{val:1792955443887861006, v:0}, ret_code:0})
observer.log.20261111155608188:[2026-11-11 15:55:50.985793] INFO [PALF] recycle_blocks_ (palf_env_impl.cpp:1172) [8537][T1002_TimerWK3_PalfGC][T1002][Y0-0000000000000000-0-0] [lt=1] recycle_blocks success(functor={id:1001, min_block_max_scn:{val:1792955485093356011, v:0}, min_block_id:18076, min_using_block_id:21311, oldest_palf_id:1001, oldest_block_scn:{val:1792955485093356011, v:0}, ret_code:0})
observer.log.20261111162243433:[2026-11-11 16:17:05.176323] INFO [PALF] recycle_blocks_ (palf_env_impl.cpp:1172) [8535][T1002_TimerWK1_PalfGC][T1002][Y0-0000000000000000-0-0] [lt=11] recycle_blocks success(functor={id:1001, min_block_max_scn:{val:1792955542060299012, v:0}, min_block_id:18077, min_using_block_id:21311, oldest_palf_id:1001, oldest_block_scn:{val:1792955542060299012, v:0}, ret_code:0})
observer.log.20261111163427239:[2026-11-11 16:33:06.545916] INFO [PALF] recycle_blocks_ (palf_env_impl.cpp:1172) [8535][T1002_TimerWK1_PalfGC][T1002][Y0-0000000000000000-0-0] [lt=0] recycle_blocks success(functor={id:1001, min_block_max_scn:{val:1792955590842199013, v:0}, min_block_id:18078, min_using_block_id:21311, oldest_palf_id:1001, oldest_block_scn:{val:1792955590842199013, v:0}, ret_code:0})
observer.log.20261111164754616:[2026-11-11 16:44:53.646845] INFO [PALF] recycle_blocks_ (palf_env_impl.cpp:1172) [8534][T1002_TimerWK0_PalfGC][T1002][Y0-0000000000000000-0-0] [lt=24] recycle_blocks success(functor={id:1001, min_block_max_scn:{val:1792955618175466007, v:0}, min_block_id:18079, min_using_block_id:21311, oldest_palf_id:1001, oldest_block_scn:{val:1792955618175466007, v:0}, ret_code:0})
observer.log.20261111170116451:[2026-11-11 16:57:27.162570] INFO [PALF] recycle_blocks_ (palf_env_impl.cpp:1172) [8536][T1002_TimerWK2_PalfGC][T1002][Y0-0000000000000000-0-0] [lt=15] recycle_blocks success(functor={id:1001, min_block_max_scn:{val:1792955676335655004, v:0}, min_block_id:18080, min_using_block_id:21311, oldest_palf_id:1001, oldest_block_scn:{val:1792955676335655004, v:0}, ret_code:0})
observer.log.20261111171432329:[2026-11-11 17:10:37.657768] INFO [PALF] recycle_blocks_ (palf_env_impl.cpp:1172) [8534][T1002_TimerWK0_PalfGC][T1002][Y0-0000000000000000-0-0] [lt=13] recycle_blocks success(functor={id:1001, min_block_max_scn:{val:1792955702768368018, v:0}, min_block_id:18081, min_using_block_id:21311, oldest_palf_id:1001, oldest_block_scn:{val:1792955702768368018, v:0}, ret_code:0})
observer.log.20261111172110955:[2026-11-11 17:20:08.976360] INFO [PALF] recycle_blocks_ (palf_env_impl.cpp:1172) [8534][T1002_TimerWK0_PalfGC][T1002][Y0-0000000000000000-0-0] [lt=24] recycle_blocks success(functor={id:1001, min_block_max_scn:{val:1792955739143333009, v:0}, min_block_id:18082, min_using_block_id:21311, oldest_palf_id:1001, oldest_block_scn:{val:1792955739143333009, v:0}, ret_code:0})
observer.log.20261111173333114:[2026-11-11 17:31:46.151506] INFO [PALF] recycle_blocks_ (palf_env_impl.cpp:1172) [8536][T1002_TimerWK2_PalfGC][T1002][Y0-0000000000000000-0-0] [lt=36] recycle_blocks success(functor={id:1001, min_block_max_scn:{val:1792955797300957015, v:0}, min_block_id:18083, min_using_block_id:21311, oldest_palf_id:1001, oldest_block_scn:{val:1792955797300957015, v:0}, ret_code:0})
observer.log.20261111174019008:[2026-11-11 17:37:57.664523] INFO [PALF] recycle_blocks_ (palf_env_impl.cpp:1172) [8536][T1002_TimerWK2_PalfGC][T1002][Y0-0000000000000000-0-0] [lt=18] recycle_blocks success(functor={id:1001, min_block_max_scn:{val:1792955834610465004, v:0}, min_block_id:18084, min_using_block_id:21311, oldest_palf_id:1001, oldest_block_scn:{val:1792955834610465004, v:0}, ret_code:0})
observer.log.20261111174700309:[2026-11-11 17:43:56.246414] INFO [PALF] recycle_blocks_ (palf_env_impl.cpp:1172) [8534][T1002_TimerWK0_PalfGC][T1002][Y0-0000000000000000-0-0] [lt=16] recycle_blocks success(functor={id:1001, min_block_max_scn:{val:1792955884340579007, v:0}, min_block_id:18085, min_using_block_id:21311, oldest_palf_id:1001, oldest_block_scn:{val:1792955884340579007, v:0}, ret_code:0})

淇铭 · 2026 年11 月 11 日 17:52

可以私发给我

淇铭 · 2026 年11 月 11 日 17:57

看着没有什么问题你设置的就是log_disk_utilization_threshold=80% 超过805才会回收目前看着一直徘徊在80%这样超过 80% 才删 1 块（64MB）→ 掉回阈值下 → 等写入再顶上去 → 再删 1 块。

AntTech_ZZ5QZV · 2026 年11 月 11 日 18:08

刚才试了私发上传限10MB，超了，那我是这俩天在关注下
SELECT TENANT_ID, LS_ID, SVR_IP, ROLE,
(end_lsn - base_lsn)/1024/1024 AS UNRECYCLABLE_MB
FROM gv$ob_log_stat
WHERE TENANT_ID = 1002
ORDER BY UNRECYCLABLE_MB DESC;
命令的情况吗？目前跑到了11402.72717571

AntTech_ZZ5QZV · 2026 年11 月 11 日 18:17

ls_id begin_lsn base_lsn end_lsn recyclable_pending_gc_mb unrecyclable_mb
1001 1213791043584 1430069710848 1442039269128 206259.41015625 11415.06031036

ls_id begin_lsn base_lsn end_lsn recyclable_pending_gc_mb unrecyclable_mb
1001 1213858148352 1430069710848 1442056585640 206195.41406250 11431.57462311

ls_id	begin_lsn	base_lsn	end_lsn	recyclable_pending_gc_mb	unrecyclable_mb
1001	1213858148352	1430069710848	1442071302473	206195.41406250	11445.60968876

老师，这是几组数据，base_lsn没动