migration: V1→V2 data migration permanently stalls on legacy session row with directory='.' #57602

Activity

1. opencode-agent commented on Oct 21, 2026

   

   opencode-agentBot

   on Oct 21, 2026 – with OpenCode Agent

   Contributor

   More actions

   Thanks for the detailed report. I was able to reproduce this on 2.1.1, and it still happens on the latest dev (aadd4d8).

   I tested it with opencode serve in a clean data directory on Linux, so this isn't specific to Windows:

   1. Started the server once to create the v2 database.
   2. Added legacy V1 session/message/part tables with two sessions: a newer one with an absolute directory and an older one with directory = '.'.
   3. Restarted the server twice.

   Both restarts logged V1 migration failed ... Path is not absolute: .. The migration.v1-v2 cursor stayed on the last good session, and the . session never reached session_v2, so the migration can't get past that row. The script below reproduces it.

   Related issues:

   • desktop: all projects show no sessions — session list fails with 'Path is not absolute: .' from a legacy session row (v1.18.31, Windows) #49256: the same Path is not absolute: . error from legacy ACP rows, but in the v1 session list (closed).
   • migration: V1 migration aborts on legacy message ID failing Session.Message.ID schema #54736, server: V1 migration fails every startup with SQLiteError: no such column: path #54009: other cases where a single legacy row makes the V1 migration fail on every startup.

   Until this is fixed, your workaround (back up the database, then set those rows' directory to an absolute path) is the way to get the migration to finish.

   Reproduction script (repro.sh)

   #!/usr/bin/env bash
   # Reproduces #57602: V1->V2 migration stalls forever on a legacy session row with directory='.'
   # Usage: ./repro.sh            (uses `opencode` from PATH)
   #        OC_DEV=/path/to/opencode/checkout ./repro.sh   (runs from source)
   set -u
   H=$(mktemp -d /tmp/opencode/oc57602.XXXX)
   mkdir -p "$H/proj"
   export HOME=$H XDG_DATA_HOME=$H/data XDG_CONFIG_HOME=$H/config XDG_STATE_HOME=$H/state XDG_CACHE_HOME=$H/cache
   oc() {
     if [ -n "${OC_DEV:-}" ]; then
       bun --conditions=browser --preload="$OC_DEV/packages/tui/node_modules/@opentui/solid/scripts/preload.js" "$OC_DEV/packages/cli/src/index.ts" "$@"
     else
       opencode "$@"
     fi
   }
   cd "$H/proj"
   DB=$H/data/opencode/opencode.db
   
   echo "== 1. first boot: create the v2 database"
   timeout 15 bash -c "$(declare -f oc); OC_DEV='${OC_DEV:-}' oc serve --port 4599 --print-logs" >"$H/boot1.log" 2>&1
   # builds from source use the "local" channel database
   [ -f "$H/data/opencode/opencode-local.db" ] && DB=$H/data/opencode/opencode-local.db
   
   echo "== 2. seed legacy V1 tables: one good session, one with directory='.'"
   python3 - "$DB" <<'EOF'
   import sqlite3, sys, time
   c = sqlite3.connect(sys.argv[1])
   c.executescript("""
   CREATE TABLE session (
     id text PRIMARY KEY, project_id text NOT NULL, workspace_id text, parent_id text, slug text NOT NULL,
     directory text NOT NULL, path text, title text NOT NULL, version text NOT NULL, share_url text,
     summary_additions integer, summary_deletions integer, summary_files integer, summary_diffs text,
     metadata text, cost real DEFAULT 0, tokens_input integer DEFAULT 0, tokens_output integer DEFAULT 0,
     tokens_reasoning integer DEFAULT 0, tokens_cache_read integer DEFAULT 0, tokens_cache_write integer DEFAULT 0,
     revert text, permission text, agent text, model text,
     time_created integer NOT NULL, time_updated integer NOT NULL, time_compacting integer, time_archived integer);
   CREATE TABLE message (id text PRIMARY KEY, session_id text NOT NULL, time_created integer NOT NULL, time_updated integer NOT NULL, data text NOT NULL);
   CREATE TABLE part (id text PRIMARY KEY, message_id text NOT NULL, session_id text NOT NULL, time_created integer NOT NULL, time_updated integer NOT NULL, data text NOT NULL);
   """)
   now = int(time.time() * 1000)
   # newer, valid session (processed first: migration walks ORDER BY id DESC)
   c.execute("INSERT INTO session (id,project_id,slug,directory,path,title,version,time_created,time_updated) VALUES (?,?,?,?,?,?,?,?,?)",
             ("ses_zzzzgood000000000000000001", "global", "good", "/tmp/work", "", "Good session", "1.1.53", now, now))
   # older ACP session with a relative directory
   c.execute("INSERT INTO session (id,project_id,slug,directory,path,title,version,time_created,time_updated) VALUES (?,?,?,?,?,?,?,?,?)",
             ("ses_aaaaacp0000000000000000001", "global", "acp", ".", "", "ACP Session 1", "1.1.53", now, now))
   c.commit()
   EOF
   
   for i in 2 3; do
     echo "== $i. boot #$i: migration runs"
     timeout 15 bash -c "$(declare -f oc); OC_DEV='${OC_DEV:-}' oc serve --port 4599 --print-logs" >"$H/boot$i.log" 2>&1
     grep -o 'message="V1 migration failed".\{0,80\}\|Path is not absolute: [^)]*' "$H/boot$i.log" | sort -u
     python3 - "$DB" <<'EOF'
   import sqlite3, sys
   c = sqlite3.connect(sys.argv[1])
   print("  kv migration.v1-v2 =", c.execute("SELECT value FROM kv WHERE key='migration.v1-v2'").fetchone())
   print("  session_v2 ids     =", [r[0] for r in c.execute("SELECT id FROM session_v2")])
   EOF
   done
   echo "logs in $H"

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

   added

   reproduced

   on Oct 21, 2026
3. rekram1-node

   self-assigned this

   on Oct 21, 2026
4. rekram1-node

   closed this as completedin #57618on Oct 21, 2026