codex - 💡(How to fix) Fix 0.133.0-alpha.1 migration drops existing live goals without backfill

Darwin 25.2.0 arm64 arm

---

{
  "overallStatus": "ok",
  "codexVersion": "0.133.0-alpha.1",
  "checks": {
    "installation": { "status": "ok" },
    "config.load": {
      "status": "ok",
      "details": {
        "feature flag overrides": "memories=true, mentions_v2=true, goals=true, prevent_idle_sleep=true"
      }
    },
    "state.paths": {
      "status": "ok",
      "details": {
        "state DB integrity": "ok",
        "log DB integrity": "ok",
        "goals DB integrity": "ok"
      }
    }
  }
}

---

■ Failed to read thread goal: thread/goal/get failed in TUI

---

ROOT=/tmp/codex-goal-db-transition
rm -rf "$ROOT"
mkdir -p "$ROOT"/{home,codex-home,npm-prefix,npm-cache,work}

cp ~/.codex/auth.json "$ROOT/codex-home/auth.json"
cp ~/.codex/config.toml "$ROOT/codex-home/config.toml"
chmod 600 "$ROOT/codex-home/auth.json"

HOME="$ROOT/home" \
CODEX_HOME="$ROOT/codex-home" \
npm_config_prefix="$ROOT/npm-prefix" \
npm_config_cache="$ROOT/npm-cache" \
npm install -g @openai/codex@0.132.0-alpha.1

HOME="$ROOT/home" \
CODEX_HOME="$ROOT/codex-home" \
"$ROOT/npm-prefix/bin/codex" --no-alt-screen -C "$ROOT/work"

---

/goal db transition check

---

sqlite3 "$ROOT/codex-home/state_5.sqlite" ".tables"
sqlite3 -header -column "$ROOT/codex-home/state_5.sqlite" \
  "select thread_id, objective, status, tokens_used, time_used_seconds from thread_goals"

---

thread_id                             objective            status  tokens_used  time_used_seconds
------------------------------------  -------------------  ------  -----------  -----------------
019e472e-8fe3-78e1-969a-b8db7e9c8b5a  db transition check  active  0            5

---

HOME="$ROOT/home" \
CODEX_HOME="$ROOT/codex-home" \
npm_config_prefix="$ROOT/npm-prefix" \
npm_config_cache="$ROOT/npm-cache" \
npm install -g @openai/codex@alpha

HOME="$ROOT/home" \
CODEX_HOME="$ROOT/codex-home" \
"$ROOT/npm-prefix/bin/codex" --no-alt-screen -C "$ROOT/work"

---

sqlite3 -header -column "$ROOT/codex-home/state_5.sqlite" \
  "select version, description, success from _sqlx_migrations order by version desc limit 4"

---

version  description                   success
-------  ----------------------------  -------
34       drop thread goals             1
33       thread goal stopped statuses  1
32       threads preview               1
31       drop device key bindings      1

---

sqlite3 "$ROOT/codex-home/goals_1.sqlite" ".tables"
sqlite3 -header -column "$ROOT/codex-home/goals_1.sqlite" \
  "select thread_id, objective, status, tokens_used, time_used_seconds from thread_goals"

---

_sqlx_migrations  thread_goals
# no rows

---

/goal

---

■ Failed to read thread goal: thread/goal/get failed in TUI