# NousResearch/hermes-agent · FTS index corruption fixes across SQLite upgrades

## Open now

- 1 issue, 0 PRs open on GitHub.
- #86027: \[Bug\]: Legacy messages_fts_trigram from SQLite 3.46.1 is reported malformed by SQLite 3.53.4 during v0.18.2 → v0.20.1 upgrade

These items address malformed or incompatible full-text search indexes that arise when upgrading SQLite versions, adding detection and self-repair logic during engine changes or index rebuilds.

## TL;DR

- 3 member(s): 1 open issue(s), 0 closed issue(s), 0 open PR(s), 0 merged PR(s), 2 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

- #86027: \[Bug\]: Legacy messages_fts_trigram from SQLite 3.46.1 is reported malformed by SQLite 3.53.4 during v0.18.2 → v0.20.1 upgrade

## Prior & competing PRs

- **#86062: fix(state): recover from malformed legacy FTS index during rebuild**. closed without merge
  - maintainer direction: category `implemented_elsewhere`; implication `superseded`
- **#86183: fix(state): verify and self-repair FTS5 indexes on engine change**. closed without merge
  - maintainer direction: category `volume_quota`; implication `active`; refs `1c68b13d1e`, `693c0e1c62`

## Fix status

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