Repository navigation
Sessions orphaned when git repo is initialized in existing opencode directory #16812
Description
Activity
This issue might be a duplicate of existing issues. Please check:
- After upgrading to OpenCode v1.2.21, previous sessions disappear from the TUI session list. #16579: Same root cause —
migrateFromGlobal()silently failing to reassign sessions fromproject_id = "global"to a real project ID. That issue was triggered by upgrading to v1.2.21, while this one is triggered by initializing git after sessions already exist, but the underlying bug appears identical. opencode sessionscommand fails to list historical sessions when run inside a Git repository #15678: Related — sessions not visible when running inside a git repo due to project ID mismatch.
I hit the same underlying bug on v1.2.21 (Linux/WSL, desktop app) with an existing repo at /home/c_w_xiaohei/workspace.
What happened:
- OpenCode created a new project row for the directory and tried to migrate existing sessions from
project_id = "global"to the new project id. - The migration failed with
FOREIGN KEY constraint failedand loggedfailed to migrate sessions from global to project. - After that, the chats were not deleted, but split between
globaland the new project id, so the session list looked like history had disappeared.
Local evidence:
- log:
~/.local/share/opencode/log/2026-03-11T180424.log - the DB still contained the sessions/messages
- manually updating the affected
session.project_idrows fromglobalto the new project id made the missing chats reappear immediately
So this is not only a "git init after sessions already exist" case. The same global -> project migration path can fail in normal use and orphan visible history.
-- by OpenCode, after local investigation
added a commit that references this issue on Mar 12, 2026
Description
Describe the bug
Sessions created before a git repository has commits are stored under
project_id = "global". When a commit is made and opencode resolves a real project ID (the root commit SHA), themigrateFromGlobal()function is supposed to reassign those sessions but it fails silently.Root cause
migrateFromGlobal()inproject.tshas two bugs:projecttable. Thesession.project_idcolumn has a foreign key constraint referencingproject.id, so the UPDATE is rejected. The.catch()handler on thework()call swallows the error silently.if (!row)branch — i.e., the first time a project ID row is created. Sessions that accumulate under"global"after the real project row already exists are never migrated.Expected behavior
Sessions created before
git init/ first commit should appear in the session list after the project transitions from"global"to a real project ID.Plugins
No response
OpenCode version
1.2.24
Steps to reproduce
mkdir /tmp/test && cd /tmp/test)opencode session listreturns sessionsgit init && git commit --allow-empty -m "first commit"opencode session listreturns nothingScreenshot and/or share link
No response
Operating System
macOS 26.3
Terminal
Ghostty