Distillation

Date: Sep 15, 2026

• 🟡 (12:35) Frozen patch evidence adds migration file packages/core/src/database/migration/20260914170650_session-recovery.ts, creating a session_recovery table with fields including session_id, execution_id, continuation_message_id, and phase.
• 🟡 (12:35) The session-recovery migration creates unique index session_recovery_execution_idx on session_recovery.execution_id.
• 🟡 (12:35) A subsequent migration has ID 20260914222526_session-execution-phase and defines constraint fk_session_recovery_continuation_message_id_session_input_id_fk, linking session_recovery.continuation_message_id to session_input.id with ON DELETE CASCADE.
• 🟡 (12:35) Frozen coordinator changes implement lease expiration using expires_at: Date.now() + leaseDuration, propagate executionID through run(sessionID, force, executionID), and expose active: coordinator.active.
• 🟡 (12:35) Frozen recovery logic imports and, desc, eq, isNull, and lt from drizzle-orm; obtains SessionExecution.Service; creates continuationMessageID using SessionMessage.ID.create(); and uses a transactional commit operation with .returning({ id: SessionExecutionTable.id }).
• 🟡 (12:35) Frozen startup/recovery behavior constructs a continuation request with prompt: Prompt.make({ text: "continue" }) and invokes .run().
• 🟡 (12:35) Frozen patch also modifies packages/core/src/session/runner/llm.ts, including integration with SessionSchema and session retrieval through getSession(sessionID).