@@ -10,7 +10,8 @@ import { Log } from "../util/log"
1010import { NamedError } from "@opencode-ai/util/error"
1111import z from "zod"
1212import path from "path"
13- import { readFileSync , readdirSync , existsSync } from "fs"
13+ import { readFileSync , readdirSync , existsSync , statfsSync , unlinkSync , mkdirSync } from "fs"
14+ import os from "os"
1415import * as schema from "./schema"
1516
1617declare const OPENCODE_MIGRATIONS : { sql : string ; timestamp : number } [ ] | undefined
@@ -25,7 +26,8 @@ export const NotFoundError = NamedError.create(
2526const log = Log . create ( { service : "db" } )
2627
2728export namespace Database {
28- export const Path = path . join ( Global . Path . data , "opencode.db" )
29+ /** Actual database path, set when Client is initialized. Falls back to default. */
30+ export let Path = path . join ( Global . Path . data , "opencode.db" )
2931 type Schema = typeof schema
3032 export type Transaction = SQLiteTransaction < "sync" , void , Schema >
3133
@@ -69,18 +71,70 @@ export namespace Database {
6971 return sql . sort ( ( a , b ) => a . timestamp - b . timestamp )
7072 }
7173
74+ function isNFS ( dir : string ) : boolean {
75+ try {
76+ // NFS magic number: 0x6969
77+ return statfsSync ( dir ) . type === 0x6969
78+ } catch {
79+ return false
80+ }
81+ }
82+
83+ function removeDatabase ( dbPath : string ) {
84+ for ( const suffix of [ "" , "-shm" , "-wal" ] ) {
85+ try {
86+ unlinkSync ( dbPath + suffix )
87+ } catch { }
88+ }
89+ }
90+
91+ /** Resolve the database directory, falling back to a local path on NFS. */
92+ function resolveDbDir ( ) : string {
93+ const dataDir = Global . Path . data
94+ if ( ! isNFS ( dataDir ) ) return dataDir
95+
96+ // SQLite's WAL mode requires shared memory via mmap, which is broken on
97+ // NFS. Instead of downgrading journal mode (slower, still fragile), just
98+ // put the database on a local filesystem.
99+ const localDir = path . join ( os . tmpdir ( ) , "opencode-" + os . userInfo ( ) . uid )
100+ mkdirSync ( localDir , { recursive : true } )
101+ log . info ( "NFS detected, using local database path" , { nfs : dataDir , local : localDir } )
102+ return localDir
103+ }
104+
72105 export const Client = lazy ( ( ) => {
73- log . info ( "opening database" , { path : path . join ( Global . Path . data , "opencode.db" ) } )
106+ const dbDir = resolveDbDir ( )
107+ const dbPath = path . join ( dbDir , "opencode.db" )
108+ Path = dbPath
109+ log . info ( "opening database" , { path : dbPath } )
74110
75- const sqlite = new BunDatabase ( path . join ( Global . Path . data , "opencode.db" ) , { create : true } )
76- state . sqlite = sqlite
111+ let sqlite : BunDatabase
112+ try {
113+ sqlite = new BunDatabase ( dbPath , { create : true } )
114+
115+ // Integrity check — detect corruption before it causes harder-to-debug errors
116+ const result = sqlite . prepare ( "PRAGMA integrity_check" ) . get ( ) as { integrity_check : string } | undefined
117+ if ( result ?. integrity_check !== "ok" ) {
118+ log . warn ( "database corrupted, recreating" , { path : dbPath , integrity : result ?. integrity_check } )
119+ sqlite . close ( )
120+ removeDatabase ( dbPath )
121+ sqlite = new BunDatabase ( dbPath , { create : true } )
122+ }
123+ } catch ( e ) {
124+ // Database file itself may be unreadable/corrupt — remove and retry
125+ log . warn ( "database open failed, recreating" , { path : dbPath , error : String ( e ) } )
126+ removeDatabase ( dbPath )
127+ sqlite = new BunDatabase ( dbPath , { create : true } )
128+ }
77129
78130 sqlite . run ( "PRAGMA journal_mode = WAL" )
131+ try { sqlite . run ( "PRAGMA wal_checkpoint(PASSIVE)" ) } catch { }
79132 sqlite . run ( "PRAGMA synchronous = NORMAL" )
80133 sqlite . run ( "PRAGMA busy_timeout = 5000" )
81134 sqlite . run ( "PRAGMA cache_size = -64000" )
82135 sqlite . run ( "PRAGMA foreign_keys = ON" )
83- sqlite . run ( "PRAGMA wal_checkpoint(PASSIVE)" )
136+
137+ state . sqlite = sqlite
84138
85139 const db = drizzle ( { client : sqlite , schema } )
86140
0 commit comments