Running opencode locally and in docker while sharing config corrupts the database

[d4rky-pl]

Description

If you run opencode locally and in docker and share ~/.local/share/opencode/, ~/.local/state/opencode/ and ~/.config/opencode/ with the container it will lead to sqlite corruption if you try to run two sessions at the same time:

  ┃  588 |           session_id: sessionID,
589 |           time_created,
590 |           data, GitHub Copilot
591 |         })▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
592 |         .onConflictDoUpdate({ target: MessageTable.id, set: { data } })                                                                                                                                    ctrl+t variants  tab agents  ctrl+p commands
593 |         .run()
               ^
SQLiteError: database disk image is malformed
      errno: 11,
 byteOffset: -1,
       code: "SQLITE_CORRUPT"

      at #run (bun:sqlite:185:20)
      at <anonymous> (src/session/index.ts:593:10)
      at run (node:async_hooks:62:22)
      at use (src/storage/db.ts:111:28)
      at <anonymous> (src/session/index.ts:584:14)
      at process (src/session/processor.ts:411:25)

Plugins

No response

OpenCode version

No response

Steps to reproduce

1. Run opencode session locally
2. Run another opencode session in Docker container with

  -v "$HOME/.local/state/opencode:/home/node/.local/state/opencode" \
  -v "$HOME/.local/share/opencode:/home/node/.local/share/opencode" \
  -v "$HOME/.config/opencode:/home/node/.config/opencode" \

3. Start agent session (e.g. ask it to review the codebase)

Screenshot and/or share link

It crashes immediately when the next session starts
https://opncd.ai/share/fbRFgNq0

Operating System

macOS 15.7.4

Terminal

iTerm

[dejwi]

same

[Miskamyasa]

Same issue

[Dulani]

This looks very similar to #14970 (NFS/WAL corruption), just via a different trigger. In our case the corruption didn’t come from local + Docker, but from two different servers sharing the same NFS home directory. The underlying pattern is the same: multiple opencode processes on different “hosts” are writing to the same global SQLite DB (~/.local/share/opencode/opencode.db), and WAL/SHM is not safe across NFS clients.

Why it was a problem for us:

• We opened opencode on server A, then later on server B (same user, same NFS home).
• Both processes wrote to the same DB; corruption followed.

Workaround that fixed it:

• Make XDG_DATA_HOME host-specific in .bashrc, e.g.
  export XDG_DATA_HOME="/home/RAND.ORG/dwoods/.local/share/opencode-vincent"
• That isolates the DB per server and avoids cross-host WAL/SHM issues.

Durable fix ideas:

• Detect NFS (statfs 0x6969) and either warn or force a local DB dir.
• Add a configurable DB location override (env var) so users can opt into local storage.
• Optional: disable WAL on NFS or add integrity checks + auto-recovery.

If this aligns with maintainers’ direction, I’m happy to help craft a PR that adds NFS detection + local fallback + explicit override.

[Miskamyasa]

How to disable sqlite? And continue using files. Don't see any benefits actually.
I'm using devcontainers and several worktrees and mount the same XDG folder. Separate db instance will make sessions not sharable between them

[Miskamyasa]

Does it mean that we cannot share the database at all? All sessions will be saved for a particular container only.

[Dulani]

Does it mean that we cannot share the database at all? All sessions will be saved for a particular container only.

Unless you implement something to migrate session info from one DB to another (or somehow mount the db to the container... likely one mount at a time), then I do think that's what it means.

[igorwang]

Same issue

[tdgroot]

Just found out the hard way as well 😅