# NousResearch/hermes-agent · sessions DB migration timing and schema fix

## Open now

- Nothing open on GitHub.

These items address a missing 'last_read_at' column in the sessions schema that caused API failures, focusing on ensuring the database migration runs eagerly at startup rather than being deferred or silently skipped.

## TL;DR

- 4 member(s): 0 open issue(s), 1 closed issue(s), 0 open PR(s), 2 merged PR(s), 1 PR(s) closed without merging.
- A fix was merged to main in PR #86671. Verify it addresses your case.
- **Recommended:** read PR #86671 (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: `resolved` · deciding PR(s): `pr-86671`. 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

- #80037: Session list API fails with "no such column: s.last_read_at" after update until first new session triggers migration

## Prior & competing PRs

- **#80797: fix(desktop): derive the stale-schema read probe from SCHEMA_SQL**. merged to main · fix tier `verified`
  - maintainer direction: category `merged`
  - files: `hermes_cli/web_routers/profiles.py`, `hermes_cli/web_server.py`, `hermes_state_schema.py`, `tests/hermes_cli/test_web_server.py`, `tests/test_schema_read_probe.py`
- **#86671: fix(sessions): eager state.db schema migration at backend startup; stop swallowing locked ALTERs**. merged to main · fix tier `verified`
  - maintainer direction: category `merged`
  - files: `hermes_cli/web_server.py`, `hermes_state_schema.py`, `tests/hermes_cli/test_web_server.py`, `tests/test_hermes_state.py`
- **#80047: fix(sessions): heal missing last_read_at on read-only GET /api/sessions opens**. closed without merge
  - maintainer direction: category `superseded_by_pr`; implication `superseded`; refs `#80797`

## Fix status

- Merged to main in PR #86671 (cited above). No release data is tracked. Verify downstream.
- Fix last verified (merged) `2026-08-15`.
- Subsystem: `dashboard`