Renaming a project's local folder leaves stale `worktree` path in project DB, causing persistent 500 errors on relaunch

[Pallavikumarimdb]

Description

When a project's local directory is renamed on disk (e.g. via File Explorer or mv), opencode desktop does not update the worktree column in the project table of its SQLite database (~/.local/share/opencode/opencode.db). This causes every subsequent request to /api/... and /file/... for that project to fail with a 500 Internal Server Error, since the sidecar tries to resolve a path that no longer exists.

Interestingly, the name and sandboxes columns for the project do get updated to reflect the new folder name/path, but worktree does not — leaving the row in an inconsistent state.

Steps to Reproduce

1. Open a project folder in opencode desktop.
2. Rename the folder on disk, while opencode is closed, or via an external tool.
3. Reopen opencode and try to access the renamed project (either via a restored tab/session, or by opening the new folder path).

Expected Behavior

opencode should either:

• Detect that the worktree path no longer exists and prompt the user to relink/reselect the folder, or
• Correctly update the worktree value when the project is reopened at its new location (consistent with how name/sandboxes already get updated).

Actual Behavior

• Requests to GET /file?path=&directory=<old_path> and /api/... fail with 500 Internal Server Error.

• Renderer console shows repeated errors like: PlatformError: NotFound: FileSystem.realPath, [cause]: Error: ENOENT: no such file or directory, lstat

• This happens even after fully quitting and relaunching the app, since the stale path is persisted, not just cached in memory.

Root Cause (found via manual DB inspection)

In ~/.local/share/opencode/opencode.db, table project:

• The row for the renamed project has name and sandboxes updated to the new path, but worktree still contains the old, deleted path:

  SELECT id, worktree, name, sandboxes FROM project WHERE id = '<project_id>';
  -- worktree: C:/project-name  (stale)
  -- name: project-name1                                    (updated)
  -- sandboxes: ["C:/project-name1"]          (updated)

Additionally, stale references to the old path were found in several other places that also needed manual cleanup before the fix took full effect:

• Electron store files (opencode.global.dat, opencode.window.<id>.dat in %APPDATA%\ai.opencode.desktop\) — server.projects, layout.home.selection.directory, tabs.info[].directory, etc.
• These didn't cause the 500s directly, but did cause stale tabs/sessions to keep attempting to reopen the old path on launch.

Environment

Plugins

No response

OpenCode version

1.18.15

Steps to reproduce

No response

Screenshot and/or share link

No response

Operating System

• OS: Windows

Terminal

No response

[github-actions]

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

• Desktop: renaming a project folder breaks the project binding (phantom project, rename ignored, sessions silently fall back to global) #40986: Desktop: renaming a project folder breaks the project binding (phantom project, rename ignored, sessions silently fall back to global)
• Desktop app freezes / can't open sessions after the project folder is moved or renamed #40336: Desktop app freezes / can't open sessions after the project folder is moved or renamed
• Desktop restores a moved/deleted workspace and leaves its sessions permanently failing with FileSystem.realPath ENOENT #38578: Desktop restores a moved/deleted workspace and leaves its sessions permanently failing with FileSystem.realPath ENOENT
• Deleting/Renaming the lastest project fold will make Opencode not working. #38013: Deleting/Renaming the latest project folder will make Opencode not working
• Server keeps stale project.worktree after project folder is renamed on disk; remote clients keep reopening the dead path #35240: Server keeps stale project.worktree after project folder is renamed on disk; remote clients keep reopening the dead path
• Deleting and re-adding a project with a different path reuses stale worktree #35851: Deleting and re-adding a project with a different path reuses stale worktree
• Project path is not updated after moving project directory (opens old deleted path) #34737: Project path is not updated after moving project directory (opens old deleted path)
• Moving a project directory breaks all existing sessions created in the original one #33909: Moving a project directory breaks all existing sessions created in the original one
• Move project folder to path B and delete old path A But OpenCode still opens and navigates to old path A, even though it no longer exists #30697: Move project folder to path B and delete old path A but OpenCode still opens and navigates to old path A
• Bug: Stale Project Path Persists After Full Workspace Reset (Windows) #31888: Bug: Stale Project Path Persists After Full Workspace Reset (Windows)
• Desktop silently returns an empty response when the saved project directory no longer exists #39471: Desktop silently returns an empty response when the saved project directory no longer exists
• opencode -c fails with "Unexpected server error" after project directory is renamed/deleted #40677: opencode -c fails with "Unexpected server error" after project directory is renamed/deleted

Please review the above issues to see if your report is already covered before this is triaged further.