NousResearch/hermes-agent

Repairing orphaned FTS5 shadow tables in state database

Cluster 56815 · agent. Data as of 2026-10-25 11:21 UTC

Nothing open on GitHub. Fix merged in #108130 on 11 Sep 2026. Check it covers your case.

open issues

open PRs

items grouped

Known?: Yes. 4 related items grouped here, 1 issue already closed.
Fix event: A fix was merged to main in PR #108130. Check it covers your case. No release data is tracked.
Tracker: The maintainers' tracker marks this unresolved. That is separate from the fix event.
Still open: Nothing open on GitHub.

Next step: read #108130, then check it covers your case.

Read #108130 Pick up a Lab task

The members appear to share one theme: orphaned FTS5 shadow tables in the session state database, tied to lost virtual table schema, which can break session_search. Several propose repair on open or doctor/repair/recover handling, and one reports the problem after an interrupted migration.

Open issues0

No open issues.

Open PRs0

No open pull requests.

Fixes on record

Merged to main. A stamp counts the issues a fix is linked to.

#108130 state.db FTS damage no longer kills turns; doctor/repair/recover handle real incident shapes (#97794, #88587, #100227, #103840, #106667, #102240, #98050, #103647, #96591, #105887; salvage #97843 #88604 #56824 #91413 #102808 #103657 #106890 #103321)

merged to main

files: agent/turn_explainers.py, contributors/emails/[email protected], contributors/emails/[redacted:email], contributors/emails/[redacted:email], contributors/emails/[redacted:email], gateway/run_notifications.py, hermes_cli/console_engine.py, hermes_cli/doctor_state.py, hermes_cli/session_lost_and_found.py, hermes_cli/session_recovery.py, hermes_cli/sessions_cmd.py, hermes_cli/web_routers/_common.py, hermes_cli/web_routers/analytics.py, hermes_cli/web_server_sessions.py, hermes_constants.py, hermes_state_errors.py, hermes_state_fts.py, hermes_state_repair.py, hermes_state_schema.py, hermes_state_search.py (+12 more)

2 PRs closed without merging

From the close comments: duplicate 1 · merged via another change 1

#56824 fix(state): repair orphan FTS5 shadow tables on SessionDB open · merged via another change → 04dd80a, #108130, #103868
#56845 fix(agent): repair orphaned FTS shadow tables · duplicate → #56824, #56815

Closed issues · 1

Closed#56815FTS5 virtual table schema loss orphans shadow tables, breaking session_search permanently after interrupted migration

How this cluster was grouped

Link evidence (structural links throughout): every member is connected by structural evidence: shared changed files, or a closing/superseded reference.
Pairwise link density 0.50: the share of item 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.

Pick up a Lab task

Check whether a fix covers the open issues here, with your own agent. Bring back evidence for maintainers.

Open the Lab

At a glance

Subsystem: agent
Merged PRs: #108130
Closed issues: 1
Attempts: 2 PRs closed without merging
Fix link checked: 11 Sep 2026

For your agent

The same facts, typed.

cluster/56815.json
cluster/56815.md