desktop: service stuck at 500 after SQLite "disk I/O error" on resume from sleep #59189

Activity

1. opencode-agent commented on Oct 26, 2026

   

   opencode-agentBot

   on Oct 26, 2026 – with OpenCode Agent

   Contributor

   More actions

   Thanks for the detailed report and logs. I could reproduce this with the 2.1.4 CLI on Linux. I didn't test the desktop app or Windows, but the CLI uses the same background service code as Desktop.

   Steps, simulating the boot-time SQLite failure:

   1. Start the background service once, then stop it.
   2. Make opencode.db unreadable (I overwrote it with random bytes). opencode service start fails with Background service failed to start, and the log shows background service boot failed with SQLiteError: file is not a database. The failed serve --service process stays running on the service port.
   3. Restore the good database and start again. It still fails with Background service failed to start, and opencode service status reports stopped while the failed process is still alive. Only killing that process recovers, which matches your workaround.

   This still happens on the latest dev (ed74ec8). The script below reproduces it.

   Related:

   • Updates #55107: an earlier report of the same failed-boot process staying alive after a disk I/O error. It was closed, but this behaviour is still there.
   • fix(client): stop failed services before reporting startup errors #55311 and fix(desktop): restart a stuck background service from the error page #57134: open PRs that stop a failed service so the next start or the desktop Restart button can recover.
   • Starting background server... Error: Background service failed to start #57032 and service: relaunch fails with "Managed service port already in use" when previous background service has not exited #54267: other ways a stale service blocks restarts.

   Until this is fixed, ending the leftover opencode-cli.exe process (or running opencode service stop) and reopening the app is the workaround.

   Reproduction script (repro.sh)

   #!/usr/bin/env bash
   # Reproduces #59189: a background service whose boot fails with a SQLite error
   # stays alive, keeps the port and answers 500 forever; later starts never recover.
   # Usage: ./repro.sh            (uses `opencode` from PATH)
   #        OC="bun --conditions=browser --preload=.../preload.js .../packages/cli/src/index.ts" ./repro.sh
   set -u
   OC=${OC:-opencode}
   ROOT=$(mktemp -d /tmp/opencode/repro59189.XXXX)
   export HOME=$ROOT/home XDG_DATA_HOME=$ROOT/data XDG_STATE_HOME=$ROOT/state XDG_CONFIG_HOME=$ROOT/config XDG_CACHE_HOME=$ROOT/cache
   mkdir -p "$HOME" && cd "${WORKDIR:-$HOME}"
   PORT=${PORT:-44123}
   $OC --version
   $OC service set port $PORT >/dev/null 2>&1 || true
   
   echo "== 1. start once so the database exists"
   timeout 120 $OC service start; echo "exit=$?"
   curl -s -o /dev/null -w "/api/info -> %{http_code}\n" http://127.0.0.1:$PORT/api/info
   timeout 60 $OC service stop; sleep 5
   DB=$(find "$XDG_DATA_HOME" -name 'opencode*.db' | head -1); echo "db=$DB"
   cp "$DB" "$ROOT/good.db"
   
   echo "== 2. simulate a transient SQLite I/O failure at boot (garbage database file)"
   rm -f "$DB"-wal "$DB"-shm
   head -c 65536 /dev/urandom > "$DB"
   timeout 120 $OC service start; echo "exit=$?"
   sleep 2
   grep -h "boot failed" -r "$XDG_DATA_HOME" "$XDG_STATE_HOME" 2>/dev/null | tail -1
   curl -s -o /dev/null -w "/api/info -> %{http_code}\n" http://127.0.0.1:$PORT/api/info
   pgrep -af "[s]erve --service"
   
   echo "== 3. the cause is gone (database restored); start again"
   cp "$ROOT/good.db" "$DB"
   timeout 120 $OC service start; echo "exit=$?"
   curl -s -o /dev/null -w "/api/info -> %{http_code}\n" http://127.0.0.1:$PORT/api/info
   $OC service status
   echo "== still running failed processes:"
   pgrep -af "[s]erve --service"
   
   echo "== cleanup"
   pkill -f "[s]erve --service" ; true

   Run it: bash repro.sh
2. opencode-agent

   added

   reproduced

   on Oct 26, 2026