[Bug]: Re-opening moved/renamed project fails with PlatformError: NotFound: FileSystem.realPath (stale project.worktree in opencode.db) #49817

Activity

1. Rafal1 commented on Sep 18, 2026

   

   Rafal1

   on Sep 18, 2026

   Author

   More actions

   Workaround (Direct SQLite Database Fix):
   Users can manually repair their database by updating the stale paths:

   Close OpenCode.

   Back up the database

   Copy-Item "$env:USERPROFILE\.local\share\opencode\opencode.db" "$env:USERPROFILE\.local\share\opencode\opencode.db.bak"
   

   Run the following SQL updates (using Node.js built-in node:sqlite or any SQLite CLI):

   -- 1. Update project worktree and name
   UPDATE project 
   SET worktree = '<NEW_FULL_PATH>',
       name = '<PROJECT_NAME>',
       time_updated = strftime('%s', 'now') * 1000
   WHERE id = '<PROJECT_ID>';
   
   -- 2. Update existing sessions pointing to the old path
   UPDATE session 
   SET directory = REPLACE(directory, '<OLD_PATH>', '<NEW_PATH>'),
       path = REPLACE(path, '<OLD_PATH>', '<NEW_PATH>'),
       time_updated = strftime('%s', 'now') * 1000
   WHERE directory LIKE '%<OLD_PATH>%';
   
   -- 3. Update session parts and event logs
   UPDATE part SET data = REPLACE(data, '<OLD_PATH>', '<NEW_PATH>') WHERE data LIKE '%<OLD_PATH>%';
   UPDATE event SET data = REPLACE(data, '<OLD_PATH>', '<NEW_PATH>') WHERE data LIKE '%<OLD_PATH>%';
   

   Restart OpenCode and recreate the project with the right path
2. Dante-dan commented on Sep 30, 2026

   

   Dante-dan

   on Sep 30, 2026

   Contributor

   More actions

   I checked the current V2 project/session paths. The project-root refresh is already implemented in #45043 and #45735: resolving a renamed repository replaces its canonical directory when the previous directory no longer exists. Existing sessions retain their own Location, so refreshing the project does not itself relocate those sessions. V2 also supports moving an idle session whose source directory is gone.

   On V2 commit df51166711, the existing renamed-project and clone-preservation regressions passed (2 tests), and the missing-source session-move regression passed (1 test). This is code-level coverage; I have not reproduced the reported Windows 1.18.31 scenario.

   For automatic recovery, I propose using the existing durable Session.Moved path to relocate inactive local sessions under the vanished project root to the new root, preserving their relative subdirectories. Keep live sessions and explicit workspace placements unchanged, and preserve historical parts/events rather than rewriting their text. Could you approve this scoped session-recovery approach?
3. thdxr commented on Oct 11, 2026

   

   thdxr

   on Oct 11, 2026

   Member

   More actions

   Thanks for the report! OpenCode 2.0 is now out and development is focused on V2, so we're closing issues filed against OpenCode 1. Please upgrade (opencode upgrade --major, details: https://anoma.ly/notes/opencode-2-0), and if this is still relevant on 2.0, reopen this issue or open a new one with your 2.0 version.

   — from 𝕺𝖕𝖊𝖓𝕮𝖔𝖉𝖊
4. thdxr

   closed this as not plannedon Oct 11, 2026