GUI stuck on "thinking" after sending messages

[JohnWaterman114]

Environment： OpenCode GUI + CLI (Windows)

Issue： On June 25, CLI crashed while running a large task. Crashed again on restart. After that, GUI got stuck on "thinking..." every time I sent a message. Log showed ERR_SQLITE_ERROR, "SQL logic error". CLI recovered later, but GUI never did.

Debugging

1. Suspected DB size
   DB was 14.6GB. Ran VACUUM to shrink to 7.14GB → GUI still stuck.
2. Found the bloat
   Found 3220 sessions from a video analysis task taking up 6.2GB. Deleted them, VACUUM to 1.38GB → GUI still stuck.
3. Suspected old data corruption
   Deleted ALL sessions before June 25, VACUUM to 46MB → GUI still stuck.
   At this point, both "DB too large" and "old session corrupted" were ruled out.
4. Fresh DB
   Renamed the old DB, launched GUI to create a brand new empty DB.
   Sent a message → worked immediately.

[github-actions]

This issue might be a duplicate of existing issues. Please check:

• bug: UI stuck on 'thinking' indefinitely after stream error, no error displayed or state recovery #32366: UI stuck on 'thinking' indefinitely after stream error, no error displayed or state recovery — similar symptom of GUI stuck on thinking with no recovery, though the root cause there is stream errors rather than DB corruption
• [Bug] Go models inference slow/stuck on Windows (Desktop + TUI) with existing sessions after v1.17.14 #35611: Go models inference slow/stuck on Windows after v1.17.14 — also Windows-specific GUI stuck issue

If your issue is specifically about the GUI failing to recover after DB corruption/replacement (i.e., the new empty DB still causes stuck thinking), it may be a distinct bug worth keeping open. Including the opencode version and whether this persists with a completely fresh install would help narrow it down.