codex - 💡(How to fix) Fix Goal tracking fails with missing thread_goals table in remote macOS Codex app session

What version of Codex are you using?

Codex app session on a remote macOS host. The local CLI reports:

codex-cli 0.132.0

What platform is your computer?

macOS 26.4.1
Apple Silicon / arm64

The session path is:

1. ChatGPT on iPhone
2. Start/open Codex from that mobile ChatGPT session
3. Connect over SSH to a remote macOS desktop host
4. Use the Codex app/session on that remote host

No local username, hostname, repository name, workspace path, thread ID, or private project details are included in this report.

What issue are you seeing?

Goal tracking is unavailable in the current session. When the agent attempted to inspect the active goal state, the goal tool failed with this SQLite/schema error:

error returned from database: (code: 1) no such table: thread_goals

The agent then had to proceed without goal tracking.

Steps that reproduced the issue

1. Open ChatGPT on iPhone.
2. Start a Codex session from ChatGPT.
3. Connect to a remote Apple Silicon macOS desktop host over SSH.
4. Use the Codex app/session in an existing private repository checkout.
5. Have the agent call the goal tracking tool (get_goal) to inspect the current goal state.

Expected behavior

Goal tracking should either:

• initialize or migrate the local goal storage before reading it, or
• recover gracefully if a prior schema is detected, or
• show an actionable message explaining how to repair/restart the goal database state.

Actual behavior

The goal tool failed immediately with:

error returned from database: (code: 1) no such table: thread_goals

Additional information

Observed on 2026-05-25.

This may be related to #23984, which tracks goal failures and diagnostics around thread_goals / goal storage schema mismatches. I am filing this as a separate, narrower reproduction because the launch path is mobile ChatGPT -> SSH -> remote macOS Codex app session and the local CLI reports codex-cli 0.132.0.