# NousResearch/hermes-agent · SQLite compaction blocking writes during cutover

## Open now

- Nothing open on GitHub.

These items relate to a compaction process that holds a SQLite write lock for an extended period, blocking other operations. A fix stages compaction rows before the atomic cutover to reduce lock contention.

## 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 #99652. Verify it addresses your case.
- **Recommended:** read PR #99652 (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.67`: 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

- #90173: Context compression holds SQLite write lock 25-140s, blocking gateway turns ('session storage was busy')

## Prior & competing PRs

- **#99652: fix(state): structurally corrupt state.db no longer keeps accepting writes (#97940, salvage #96038)**. merged to main · fix tier `verified`
  - maintainer direction: category `merged`
  - files: `contributors/emails/[redacted:email]`, `gateway/session.py`, `hermes_state.py`, `tests/gateway/test_session.py`, `tests/state/test_fts_runtime_rebuild.py`
- **#100273: fix(state): stage compaction rows before atomic cutover**. closed without merge
  - maintainer direction: category `superseded_by_pr`; implication `superseded`; refs `ec703cea16344e5fa20a3389f35934bcaec09e25`, `18a76be124d7c16ed98b629a358b23fef76a7f46`, `51569c1b2065959c1df0bb05f1f6e62e4af29d8b`, `9bb36a989bf97519b8c4aec56d84843b9724fb86`, `#100300`
- **#100300: fix(state): stage compaction rows before atomic cutover**. closed without merge
  - maintainer direction: category `superseded_by_pr`; implication `superseded`; refs `#96038`, `#99652`, `#100300`

## Fix status

- Merged to main in PR #99652 (cited above). No release data is tracked. Verify downstream.
- Fix last verified (merged) `2026-08-31`.
- Subsystem: `evals/compaction`