租户 1096 合并卡住,看着是部分 tablet(如 table 1001 / tablet 216135 等)在 build_ctx_after_init 阶段反复返回 -4016,导致 Major/Medium 合并均失败;RS 调度仍在运行,但无法完成最后约 35% 的 tablet,因此进度停在 65.08%。
– 查看失败 tablet 及诊断信息
SELECT tenant_id, type, tablet_id, status, create_time, diagnose_info
FROM GV$OB_COMPACTION_DIAGNOSE_INFO
WHERE tenant_id = 1096 AND status = ‘FAILED’
ORDER BY create_time DESC
LIMIT 50;
– 查看未完成合并进度
SELECT svr_ip, svr_port, zone, ls_id, tablet_id,
total_tablet_count, unfinished_tablet_count,
data_size, unfinished_data_size, status
FROM GV$OB_COMPACTION_PROGRESS
WHERE tenant_id = 1096 AND type = ‘MAJOR_MERGE’
AND status != ‘FINISH’;
日志信息 查看
grep -E “progressive round on schema is less than meta|found schema changed when compare|stored col cnt in curr schema is less” observer.log | tail -50
grep “tablet_id=216135” observer.log | grep -E “STORAGE_COMPACTION|failed to build ctx|cal_major_merge_param” | tail -30
对失败 tablet 对应表(如 table_id=1001 )检查:
– 表 progressive merge 配置
SELECT table_id, table_name, progressive_merge_num, progressive_merge_round
FROM oceanbase.__all_table
WHERE tenant_id = 1096 AND table_id = 1001;
– tablet 合并信息
SELECT tablet_id, compaction_scn, status,
progressive_merge_round, progressive_merge_num
FROM GV$OB_TABLET_COMPACTION_INFO
WHERE tenant_id = 1096
AND tablet_id IN (216135, /* 其他失败 tablet_id */)
ORDER BY tablet_id;
–确认近期针对这些table_id是否有DDL操作