# NousResearch/hermes-agent · state.db FTS/index corruption detection and repair work

## Open now

- Nothing open on GitHub.

Members center on state.db (SQLite) index health: one bug report of FTS index corruption on macOS with a failing write-health probe, and several fix PRs covering corruption detection, search self-heal, REINDEX repair strategies, and repair-lock handling. The titles suggest a shared theme, but the exact outcomes and status of each change aren't established here.

## TL;DR

- 4 member(s): 0 open issue(s), 1 closed issue(s), 0 open PR(s), 1 merged PR(s), 2 PR(s) closed without merging.
- A fix was merged to main in PR #68653. Verify it addresses your case.
- **Recommended:** read PR #68653 (and any competing PRs below) before filing. Confirm the merged change covers your symptom.

## Maintainer resolution verdict

- Internal-tracker verdict over this cluster's issue members: `unresolved`. This is distinct from the fix status above. Weigh it yourself.

## How this cluster was grouped

- Link evidence (`STRUCTURAL_SPANNING`): every member is connected by structural evidence: shared changed files, or a closing/superseded reference.
- Pairwise link density `0.50`: the share of member pairs that carry a link, counting a structural link in full and a relevance-only link at 0.36. `1.00` means every pair is linked.

## Closed / duplicate issues

- #63386: \[Bug\] state.db FTS index corruption on macOS (write-health probe fails)

## Prior & competing PRs

- **#68653: fix(state): FTS read-path corruption detection, search self-heal, and REINDEX repair strategy**. merged to main · fix tier `verified`
  - maintainer direction: category `merged`
  - files: `contributors/emails/[redacted:email]`, `hermes_state.py`, `tests/state/test_fts_runtime_rebuild.py`, `tests/test_state_db_malformed_repair.py`
- **#63398: fix(state): add REINDEX strategy to repair stale B-tree indexes**. closed without merge
  - maintainer direction: category `merged_via`; implication `superseded`; refs `#68653`
- **#103321: fix(state): preserve repair locks and report unhealthy checks (#63386)**. closed without merge
  - maintainer direction: category `merged_via`; implication `superseded`; refs `04dd80a977`, `#108130`

## Fix status

- Merged to main in PR #68653 (cited above). No release data is tracked. Verify downstream.
- Fix last verified (merged) `2026-07-21`.
- Subsystem: `agent`