# NousResearch/hermes-agent · SQLite WAL snapshot and backup correctness issues

## Open now

- 1 issue, 2 PRs open on GitHub.
- #124550: \[Bug\]: SQLite snapshots can restart indefinitely under successful WAL writes
- PR #124612: fix(cli): pin a read snapshot for WAL-safe SQLite backups
- PR #124640: fix(backup): keep WAL incremental backups on one snapshot

These items address bugs and fixes related to SQLite WAL-mode snapshot behavior, including indefinite restarts and ensuring incremental backups remain pinned to a consistent read snapshot.

## TL;DR

- 3 member(s): 1 open issue(s), 0 closed issue(s), 2 open PR(s), 0 merged PR(s), 0 PR(s) closed without merging.
- No fix has been merged to main; one or more PRs were attempted (see below).
- **Recommended:** review the prior/competing PR(s) below. A fix was attempted but not merged; your case may extend or revive that work.

## 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.

## Open related issues

- #124550: \[Bug\]: SQLite snapshots can restart indefinitely under successful WAL writes

## Prior & competing PRs

- **#124612: fix(cli): pin a read snapshot for WAL-safe SQLite backups**. open
  - maintainer direction: category `uncategorized`; implication `needs_llm`
  - files: `hermes_cli/backup_sqlite.py`, `tests/hermes_cli/test_backup.py`
- **#124640: fix(backup): keep WAL incremental backups on one snapshot**. open
  - maintainer direction: category `silent_close`; implication `active`
  - files: `hermes_cli/backup_sqlite.py`, `tests/hermes_cli/test_backup.py`

## Fix status

- No merged fix on record.
- Subsystem: `hermes_cli`