REAL SERVER USAGE-LIMIT RECOVERY COMPARISON Same Linux machine; separate clean databases migrated by each commit. Settings snooze toggles invalidate the real UsageLimitRecoveryWorker. 5 warmups + 3 batches of 25 measured ProjectionStore.getLimitRecoveryCandidates spans. BEFORE 3a51807da05203bc2dbfbc489f976e3ba0dc609a {"os": "Linux", "architecture": "x86_64", "node": "v26.13.1", "pythonSqlite": "3.45.1", "nodeSqlite": "3.54.1", "cpu": "AMD Ryzen 9 9950X 16-Core Processor"} Batch 1: median 159.520288 ms, min 136.096573, max 188.046201 Batch 2: median 160.902351 ms, min 134.050885, max 227.796790 Batch 3: median 165.439579 ms, min 134.047899, max 217.932950 Armed IDs: fixture-thread-0000, fixture-thread-0001, fixture-thread-0002 Eligibility preserved: True { "commit": "3a51807da05203bc2dbfbc489f976e3ba0dc609a", "malformedInsertSucceeded": true, "malformedUpdateSucceeded": true, "malformedExcludedFromPrefilter": false, "prefilterThreadIdsUnchanged": false, "prefilterDistinctThreads": null, "prefilterError": "malformed JSON", "plan": [ "SCAN failure USING INDEX orchestration_v2_projection_turn_items_failed_error_idx" ], "realServerRecoverySweepSucceeded": false, "realServerRecoverySweepMs": 224.632512, "armedThreadIds": [ "fixture-thread-0000", "fixture-thread-0001", "fixture-thread-0002" ], "planSqliteVersion": "3.54.1" } { "commit": "3a51807da05203bc2dbfbc489f976e3ba0dc609a", "resetAt": "2026-11-19T05:26:18.084Z", "dueThreadIdsSelectedForContinuation": [ "fixture-thread-0000", "fixture-thread-0001", "fixture-thread-0002" ], "expectedThreadIds": [ "fixture-thread-0000", "fixture-thread-0001", "fixture-thread-0002" ], "selectionPreserved": true, "provider": "synthetic-provider (intentionally not configured)", "limitation": "Continuation dispatch is intentionally rejected before a provider can start; this verifies due selection, not an actual model continuation.", "dispatchTranscript": [ "fixture-thread-0000: continuation rejected: synthetic-provider is disabled for fixture-project", "fixture-thread-0001: continuation rejected: synthetic-provider is disabled for fixture-project", "fixture-thread-0002: continuation rejected: synthetic-provider is disabled for fixture-project" ] } AFTER e2849b107d933613a907ec07bd7b6b28e15e1a82 {"os": "Linux", "architecture": "x86_64", "cpu": "AMD Ryzen 9 9950X 16-Core Processor", "node": "v26.13.1", "pythonSqlite": "3.45.1", "nodeSqlite": "3.54.1"} Batch 1: median 7.336125 ms, min 5.755902, max 10.498047 Batch 2: median 7.409526 ms, min 4.460616, max 10.141747 Batch 3: median 6.839490 ms, min 5.097294, max 12.852579 Armed IDs: fixture-thread-0000, fixture-thread-0001, fixture-thread-0002 Eligibility preserved: True { "commit": "e2849b107d933613a907ec07bd7b6b28e15e1a82", "malformedInsertSucceeded": true, "malformedUpdateSucceeded": true, "malformedExcludedFromPrefilter": true, "prefilterThreadIdsUnchanged": true, "prefilterDistinctThreads": 392, "prefilterError": null, "planSqliteVersion": "3.54.1", "plan": [ "SCAN failure USING INDEX orchestration_v2_projection_turn_items_usage_limit_idx" ], "realServerRecoverySweepSucceeded": true, "realServerRecoverySweepMs": 36.799183, "armedThreadIds": [ "fixture-thread-0000", "fixture-thread-0001", "fixture-thread-0002" ] } { "commit": "e2849b107d933613a907ec07bd7b6b28e15e1a82", "resetAt": "2026-11-19T05:34:15.632Z", "dueThreadIdsSelectedForContinuation": [ "fixture-thread-0000", "fixture-thread-0001", "fixture-thread-0002" ], "expectedThreadIds": [ "fixture-thread-0000", "fixture-thread-0001", "fixture-thread-0002" ], "selectionPreserved": true, "provider": "synthetic-provider (intentionally not configured)", "limitation": "Continuation dispatch is intentionally rejected before a provider can start; this verifies due selection, not an actual model continuation.", "dispatchTranscript": [ "fixture-thread-0000: continuation rejected: synthetic-provider is disabled for fixture-project", "fixture-thread-0001: continuation rejected: synthetic-provider is disabled for fixture-project", "fixture-thread-0002: continuation rejected: synthetic-provider is disabled for fixture-project" ] } Smallest base median minus largest head median: 152.110762 ms Largest within-side spread between batch medians: 5.919291 ms Improvement exceeds spread: True Largest range across individual samples: 93.748891 ms Scope: lookup latency, automatic arming and due selection. Does not execute a real provider continuation.