Distillation

Date: Sep 15, 2026

• 🔴 (16:38) User specified the recovery invariant: “never recovers an execution superseded by a newer assistant.”
• 🟡 (16:38) packages/core/test/session-projector.test.ts:266 contains the test it.effect("never recovers an execution superseded by a newer assistant", ...).
• 🟡 (16:38) packages/core/test/session-projector.test.ts:447 tests that a malformed execution claim is quarantined without blocking a valid claim; the malformed row uses id: "malformed", owner_id: "dead", phase: "invalid", time_created: 0, and expires_at: 0, and is expected to receive recovery_error: "Invalid execution phase: invalid" while recovery proceeds with execution_id: "valid".
• 🟡 (16:38) Other recovery scenarios found in packages/core/test/session-projector.test.ts include a "lost-wake" recovery with wake_pending: true, a "cross-session" execution in phase "unknown", recovery-batch session IDs formatted as ses_recovery_batch_${index.toString().padStart(3, "0")}, and a test at line 1258 that updates only the newest incomplete assistant projection.
• 🟡 (16:38) Generated database artifacts were verified: /home/byk/Code/opencode/packages/core/schema.json contains 42 matches for the consolidated session_execution, session_recovery, wake_pending, foreign-key, primary-key, index, and phase-check definitions; /home/byk/Code/opencode/packages/core/src/database/schema.gen.ts contains 16 corresponding matches.