PR 27896 real dev verification, 2026-10-31 main: 5fe18d79ac835e0f193ad61325e5b7d69a317bcf PR: a5c1a4f9b55a96ae0893390d16dc65d0d833ba4e One background dev server at a time. main web 8693 / server 16733; PR web 5733 / server 13773. Playwright 1.60.0 with /usr/bin/google-chrome. Created recovery-verification project/repository with the actual UI; selected Codex gpt-6.1-sol. main: provider wrote README.md, ran git status, returned MAIN_TURN_OK. Stopped main, copied its app-created database into isolated PR home, started exact PR head with explicit --home-dir. PR: migration 77 added indexes; migration 76 retained its original timestamp. PR: resumed existing provider session, read README.md and git status, returned PR_TURN_OK and recovery verification. PR: stopped a running provider command with Stop generation; client showed Run interrupted / Stopped by user. PR: after reload, another provider turn returned AFTER_CANCEL_OK. Sidebar returned to idle. Final actual run rows: completed codex 3; interrupted codex 1; no error items. No mocks, fixtures, replay provider, or direct database writes used to manufacture scenario data. 6 focused migration/preview-upgrade tests passed remotely through blacksmith-check. No application speedup claim: small real data cannot establish the reported historical-data performance figures. Not verified: a genuine usage-limit error and resume at reset, native mobile/desktop shells, other providers/OSes. READ-ONLY QUERY PLAN PROBES AGAINST APP-CREATED DATABASES: MAIN /home/user/main/.t3/userdata/statev2.sqlite migrations [ [Object: null prototype] { migration_id: 76, created_at: '2026-10-31 21:20:51', name: 'ProjectionProjectsPinArchive' }, [Object: null prototype] { migration_id: 75, created_at: '2026-10-31 21:20:51', name: 'SubagentDeliveryState' } ] indexes [] production recovery SQL SEARCH t USING INDEX sqlite_autoindex_orchestration_v2_projection_threads_1 (thread_id=?) LIST SUBQUERY 4 SCAN failure USING INDEX orchestration_v2_projection_turn_items_failed_error_idx CORRELATED SCALAR SUBQUERY 5 SEARCH request USING COVERING INDEX orchestration_v2_projection_runtime_requests_thread_status_idx (thread_id=? AND status=?) SEARCH r USING INDEX sqlite_autoindex_orchestration_v2_projection_runs_1 (run_id=?) CORRELATED SCALAR SUBQUERY 2 SEARCH latest USING INDEX orchestration_v2_projection_runs_thread_ordinal_idx (thread_id=?) USE TEMP B-TREE FOR ORDER BY SEARCH item USING INDEX sqlite_autoindex_orchestration_v2_projection_turn_items_1 (turn_item_id=?) CORRELATED SCALAR SUBQUERY 3 SEARCH error USING COVERING INDEX orchestration_v2_projection_turn_items_failed_error_idx (thread_id=? AND run_id=? AND node_id=?) CORRELATED SCALAR SUBQUERY 1 SEARCH binding USING INDEX orchestration_v2_projection_provider_session_bindings_thread_idx (thread_id=?) SEARCH session USING INDEX sqlite_autoindex_orchestration_v2_projection_provider_sessions_1 (provider_session_id=?) USE TEMP B-TREE FOR ORDER BY rows [] shell latest-executed subquery SCAN t CORRELATED SCALAR SUBQUERY 1 SEARCH candidate USING INDEX orchestration_v2_projection_runs_thread_ordinal_idx (thread_id=?) USE TEMP B-TREE FOR ORDER BY rows [ [Object: null prototype] { thread_id: 'thread:project:e778ce2b-b4e9-4117-af1a-ae619bd60315:2c79bf1f-ea75-43e3-874e-bfbdae8823e5', latest_executed: null }, [Object: null prototype] { thread_id: '5ee230ba-0ac3-4404-b536-e86710c36ff6', latest_executed: 'run:thread:5ee230ba-0ac3-4404-b536-e86710c36ff6:ordinal:1' } ] runs [ [Object: null prototype] { status: 'completed', provider: 'codex', count: 1 } ] failures [] PR_FINAL /home/user/t3code/.t3/userdata/statev2.sqlite migrations [ [Object: null prototype] { migration_id: 77, created_at: '2026-10-31 21:36:21', name: 'BackgroundRecoveryIndexes' }, [Object: null prototype] { migration_id: 76, created_at: '2026-10-31 21:20:51', name: 'ProjectionProjectsPinArchive' } ] indexes [ [Object: null prototype] { name: 'orchestration_v2_projection_turn_items_usage_limit_idx' }, [Object: null prototype] { name: 'orchestration_v2_projection_runs_latest_executed_idx' } ] production recovery SQL SEARCH t USING INDEX sqlite_autoindex_orchestration_v2_projection_threads_1 (thread_id=?) LIST SUBQUERY 4 SCAN failure USING INDEX orchestration_v2_projection_turn_items_usage_limit_idx CORRELATED SCALAR SUBQUERY 5 SEARCH request USING COVERING INDEX orchestration_v2_projection_runtime_requests_thread_status_idx (thread_id=? AND status=?) SEARCH r USING INDEX sqlite_autoindex_orchestration_v2_projection_runs_1 (run_id=?) CORRELATED SCALAR SUBQUERY 2 SEARCH latest USING INDEX orchestration_v2_projection_runs_latest_executed_idx (thread_id=?) SEARCH item USING INDEX sqlite_autoindex_orchestration_v2_projection_turn_items_1 (turn_item_id=?) CORRELATED SCALAR SUBQUERY 3 SEARCH error USING COVERING INDEX orchestration_v2_projection_turn_items_failed_error_idx (thread_id=? AND run_id=? AND node_id=?) CORRELATED SCALAR SUBQUERY 1 SEARCH binding USING INDEX orchestration_v2_projection_provider_session_bindings_thread_idx (thread_id=?) SEARCH session USING INDEX sqlite_autoindex_orchestration_v2_projection_provider_sessions_1 (provider_session_id=?) USE TEMP B-TREE FOR ORDER BY rows [] shell latest-executed subquery SCAN t CORRELATED SCALAR SUBQUERY 1 SEARCH candidate USING INDEX orchestration_v2_projection_runs_latest_executed_idx (thread_id=?) rows [ [Object: null prototype] { thread_id: 'thread:project:e778ce2b-b4e9-4117-af1a-ae619bd60315:2c79bf1f-ea75-43e3-874e-bfbdae8823e5', latest_executed: null }, [Object: null prototype] { thread_id: '5ee230ba-0ac3-4404-b536-e86710c36ff6', latest_executed: 'run:thread:5ee230ba-0ac3-4404-b536-e86710c36ff6:ordinal:4' }, [Object: null prototype] { thread_id: 'thread:project:44b56e0c-d491-4e66-b313-11d96e055df9:a06a476d-04d5-4bbf-96af-e35c794b7bc6', latest_executed: null } ] runs [ [Object: null prototype] { status: 'completed', provider: 'codex', count: 3 }, [Object: null prototype] { status: 'interrupted', provider: 'codex', count: 1 } ] failures []