{"source":"d73fd1279a9cbf3ef4677b88b4ad82f0a55583c7","driverSha256":"688bafdc26910378aea0c0c0f54c7930881f3b8e3d6a1629b1cadc0b2459b1c1","node":"v26.12.1","os":"linux x64","machine":"fs-20","command":"node service-harness.mjs /home/ubuntu/wt/pr-25696-base /tmp/lead-25696-r2/capture/service-before-20261027T1600","recipe":"B: actual ProjectionStore.layer + migrated SqlitePersistence.layerMemory; rich fixture via apply; labelled synthetic bulk projection clones","clock":"2026-10-01T12:00:00.000Z"} BEGIN environment [15:57:46.259] INFO (#2): Migrations ran successfully { migrations: [ '1_OrchestrationEvents', '2_OrchestrationCommandReceipts', '3_CheckpointDiffBlobs', '4_ProviderSessionRuntime', '5_Projections', '6_ProjectionThreadSessionRuntimeModeColumns', '7_ProjectionThreadMessageAttachments', '8_ProjectionThreadActivitySequence', '9_ProviderSessionRuntimeMode', '10_ProjectionThreadsRuntimeMode', '11_OrchestrationThreadCreatedRuntimeMode', '12_ProjectionThreadsInteractionMode', '13_ProjectionThreadProposedPlans', '14_ProjectionThreadProposedPlanImplementation', '15_ProjectionTurnsSourceProposedPlan', '16_CanonicalizeModelSelections', '17_ProjectionThreadsArchivedAt', '18_ProjectionThreadsArchivedAtIndex', '19_ProjectionSnapshotLookupIndexes', '20_AuthAccessManagement', '21_AuthSessionClientMetadata', '22_AuthSessionLastConnectedAt', '23_ProjectionThreadShellSummary', '24_BackfillProjectionThreadShellSummary', '25_CleanupInvalidProjectionPendingApprovals', '26_CanonicalizeModelSelectionOptions', '27_ProviderSessionRuntimeInstanceId', '28_ProjectionThreadSessionInstanceId', '29_ProjectionThreadDetailOrderingIndexes', '30_ProjectionThreadShellArchiveIndexes', '31_AuthAuthorizationScopes', '32_AuthPairingProofKeyThumbprint', '33_ProjectionThreadsSettled', '34_ProjectionThreadsSnoozed', '35_ProjectionThreadTitleRegeneration', '36_ProjectionThreadsPinned', '37_ProjectionTurnsKeysetIndex', '38_ProjectionThreadsPinOrderKey', '39_ProjectionProjectsDefaultThreadEnvMode', '40_ProjectionProjectFaviconPath', '41_AuthSessionClientConnection', '42_ProjectionThreadLinkedPullRequest', '43_ProjectionThreadsUnsettledAt', '44_ClearAutomaticProjectModelDefaults', '45_ProjectionProjectsAutoPull', '46_RepairAutomaticSettlementTimestamps', '47_ProjectionProjectIcon', '48_ProjectionThreadBranchPullRequest', '49_ProjectionThreadsActiveOrderKey', '50_ProjectionThreadPullRequests', '51_ProjectionThreadMessageContext', '52_ProjectionThreadTitleState', '53_PullRequestFilesViewed', '54_ProjectionThreadsAutoSettleDisabledAt', '55_OrchestrationV2', '56_RemoveRedundantProjectionIndexes', '57_ScheduledTaskWebhooks', '58_WebhookRelayDeliveries', '59_McpAppModelContext', '60_ThreadSnapshotWindowIndexes', '61_PullRequestReviewGuides', '62_ThreadFailureLookupIndex', '63_DropUnusedV1Projections', '64_CanonicalizeThreadPullRequestLinks', '65_CodexUsageNativeTurnIndex', '66_RepairClientSettlementTimestamps', '67_WebhookDedupe', '68_ShellStopRequestIndex', '69_ThreadMessageSearch' ] } SQLITE [{"version":"3.54.0"}] VARIABLE_CAP [{"compile_options":"MAX_VARIABLE_NUMBER=32766"}] END environment PASS BEGIN E1 [15:57:46.485] INFO (#326): Migrations ran successfully { migrations: [ '1_OrchestrationEvents', '2_OrchestrationCommandReceipts', '3_CheckpointDiffBlobs', '4_ProviderSessionRuntime', '5_Projections', '6_ProjectionThreadSessionRuntimeModeColumns', '7_ProjectionThreadMessageAttachments', '8_ProjectionThreadActivitySequence', '9_ProviderSessionRuntimeMode', '10_ProjectionThreadsRuntimeMode', '11_OrchestrationThreadCreatedRuntimeMode', '12_ProjectionThreadsInteractionMode', '13_ProjectionThreadProposedPlans', '14_ProjectionThreadProposedPlanImplementation', '15_ProjectionTurnsSourceProposedPlan', '16_CanonicalizeModelSelections', '17_ProjectionThreadsArchivedAt', '18_ProjectionThreadsArchivedAtIndex', '19_ProjectionSnapshotLookupIndexes', '20_AuthAccessManagement', '21_AuthSessionClientMetadata', '22_AuthSessionLastConnectedAt', '23_ProjectionThreadShellSummary', '24_BackfillProjectionThreadShellSummary', '25_CleanupInvalidProjectionPendingApprovals', '26_CanonicalizeModelSelectionOptions', '27_ProviderSessionRuntimeInstanceId', '28_ProjectionThreadSessionInstanceId', '29_ProjectionThreadDetailOrderingIndexes', '30_ProjectionThreadShellArchiveIndexes', '31_AuthAuthorizationScopes', '32_AuthPairingProofKeyThumbprint', '33_ProjectionThreadsSettled', '34_ProjectionThreadsSnoozed', '35_ProjectionThreadTitleRegeneration', '36_ProjectionThreadsPinned', '37_ProjectionTurnsKeysetIndex', '38_ProjectionThreadsPinOrderKey', '39_ProjectionProjectsDefaultThreadEnvMode', '40_ProjectionProjectFaviconPath', '41_AuthSessionClientConnection', '42_ProjectionThreadLinkedPullRequest', '43_ProjectionThreadsUnsettledAt', '44_ClearAutomaticProjectModelDefaults', '45_ProjectionProjectsAutoPull', '46_RepairAutomaticSettlementTimestamps', '47_ProjectionProjectIcon', '48_ProjectionThreadBranchPullRequest', '49_ProjectionThreadsActiveOrderKey', '50_ProjectionThreadPullRequests', '51_ProjectionThreadMessageContext', '52_ProjectionThreadTitleState', '53_PullRequestFilesViewed', '54_ProjectionThreadsAutoSettleDisabledAt', '55_OrchestrationV2', '56_RemoveRedundantProjectionIndexes', '57_ScheduledTaskWebhooks', '58_WebhookRelayDeliveries', '59_McpAppModelContext', '60_ThreadSnapshotWindowIndexes', '61_PullRequestReviewGuides', '62_ThreadFailureLookupIndex', '63_DropUnusedV1Projections', '64_CanonicalizeThreadPullRequestLinks', '65_CodexUsageNativeTurnIndex', '66_RepairClientSettlementTimestamps', '67_WebhookDedupe', '68_ShellStopRequestIndex', '69_ThreadMessageSearch' ] } ROW E1 empty expected={"count":0,"tooManyVariables":false} ACTUAL success {"schemaVersion":2,"snapshotSequence":0,"threads":0,"archivedThreads":0,"idDigest":"e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855"} ASSERT E1 empty PASS ROW E1 deleted only expected={"count":0,"tooManyVariables":false} ACTUAL success {"schemaVersion":2,"snapshotSequence":0,"threads":0,"archivedThreads":0,"idDigest":"e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855"} ASSERT E1 deleted only PASS ROW E1 no-match {"projectId":"project:missing"} expected={"count":0,"tooManyVariables":false} ACTUAL success {"schemaVersion":2,"snapshotSequence":0,"threads":0,"archivedThreads":0,"idDigest":"e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855"} ASSERT E1 no-match {"projectId":"project:missing"} PASS ROW E1 no-match {"familyOf":"missing","location":"active"} expected={"count":0,"tooManyVariables":false} ACTUAL success {"schemaVersion":2,"snapshotSequence":0,"threads":0,"archivedThreads":0,"idDigest":"e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855"} ASSERT E1 no-match {"familyOf":"missing","location":"active"} PASS ROW E1 no-match {"worktreePath":"/missing","location":"active"} expected={"count":0,"tooManyVariables":false} ACTUAL success {"schemaVersion":2,"snapshotSequence":0,"threads":0,"archivedThreads":0,"idDigest":"e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855"} ASSERT E1 no-match {"worktreePath":"/missing","location":"active"} PASS SQL_COUNTS [{"name":"threads","count":2},{"name":"runs","count":0},{"name":"items","count":0},{"name":"providers","count":0}] END E1 PASS BEGIN R1 [15:57:46.617] INFO (#655): Migrations ran successfully { migrations: [ '1_OrchestrationEvents', '2_OrchestrationCommandReceipts', '3_CheckpointDiffBlobs', '4_ProviderSessionRuntime', '5_Projections', '6_ProjectionThreadSessionRuntimeModeColumns', '7_ProjectionThreadMessageAttachments', '8_ProjectionThreadActivitySequence', '9_ProviderSessionRuntimeMode', '10_ProjectionThreadsRuntimeMode', '11_OrchestrationThreadCreatedRuntimeMode', '12_ProjectionThreadsInteractionMode', '13_ProjectionThreadProposedPlans', '14_ProjectionThreadProposedPlanImplementation', '15_ProjectionTurnsSourceProposedPlan', '16_CanonicalizeModelSelections', '17_ProjectionThreadsArchivedAt', '18_ProjectionThreadsArchivedAtIndex', '19_ProjectionSnapshotLookupIndexes', '20_AuthAccessManagement', '21_AuthSessionClientMetadata', '22_AuthSessionLastConnectedAt', '23_ProjectionThreadShellSummary', '24_BackfillProjectionThreadShellSummary', '25_CleanupInvalidProjectionPendingApprovals', '26_CanonicalizeModelSelectionOptions', '27_ProviderSessionRuntimeInstanceId', '28_ProjectionThreadSessionInstanceId', '29_ProjectionThreadDetailOrderingIndexes', '30_ProjectionThreadShellArchiveIndexes', '31_AuthAuthorizationScopes', '32_AuthPairingProofKeyThumbprint', '33_ProjectionThreadsSettled', '34_ProjectionThreadsSnoozed', '35_ProjectionThreadTitleRegeneration', '36_ProjectionThreadsPinned', '37_ProjectionTurnsKeysetIndex', '38_ProjectionThreadsPinOrderKey', '39_ProjectionProjectsDefaultThreadEnvMode', '40_ProjectionProjectFaviconPath', '41_AuthSessionClientConnection', '42_ProjectionThreadLinkedPullRequest', '43_ProjectionThreadsUnsettledAt', '44_ClearAutomaticProjectModelDefaults', '45_ProjectionProjectsAutoPull', '46_RepairAutomaticSettlementTimestamps', '47_ProjectionProjectIcon', '48_ProjectionThreadBranchPullRequest', '49_ProjectionThreadsActiveOrderKey', '50_ProjectionThreadPullRequests', '51_ProjectionThreadMessageContext', '52_ProjectionThreadTitleState', '53_PullRequestFilesViewed', '54_ProjectionThreadsAutoSettleDisabledAt', '55_OrchestrationV2', '56_RemoveRedundantProjectionIndexes', '57_ScheduledTaskWebhooks', '58_WebhookRelayDeliveries', '59_McpAppModelContext', '60_ThreadSnapshotWindowIndexes', '61_PullRequestReviewGuides', '62_ThreadFailureLookupIndex', '63_DropUnusedV1Projections', '64_CanonicalizeThreadPullRequestLinks', '65_CodexUsageNativeTurnIndex', '66_RepairClientSettlementTimestamps', '67_WebhookDedupe', '68_ShellStopRequestIndex', '69_ThreadMessageSearch' ] } SQL_COUNTS [{"name":"threads","count":32766},{"name":"runs","count":0},{"name":"items","count":0},{"name":"providers","count":0}] ROW R1 {} expected={"count":32766,"tooManyVariables":false} ACTUAL success {"schemaVersion":2,"snapshotSequence":0,"threads":32766,"archivedThreads":0,"idDigest":"ffcb22cb0ccb03c3e864fb2b7c68f5ddef4f1076840f5c78ed682e1c5e0cb00f"} ASSERT R1 {} PASS ROW R1 {"location":"active"} expected={"count":32766,"tooManyVariables":false} ACTUAL success {"schemaVersion":2,"snapshotSequence":0,"threads":32766,"archivedThreads":0,"idDigest":"ffcb22cb0ccb03c3e864fb2b7c68f5ddef4f1076840f5c78ed682e1c5e0cb00f"} ASSERT R1 {"location":"active"} PASS ROW H2 ids=32761 location=active expected={"count":32761,"tooManyVariables":false} ACTUAL success {"schemaVersion":2,"snapshotSequence":0,"threads":32761,"archivedThreads":0,"idDigest":"0812fed938a48cbb95652c2218d63dedf01d763cbfa629a5a4956e19ddbbfc96"} ASSERT H2 ids=32761 location=active PASS ROW H2 ids=32762 location=active expected={"count":32762,"tooManyVariables":true} ACTUAL failure [{"tag":"ProjectionStoreReadError","message":"Failed to read orchestration projection for thread thread:shell."},{"tag":"SqlError","message":"Failed to prepare statement"},{"tag":"UnknownError","message":"Failed to prepare statement"},{"message":"too many SQL variables","code":"ERR_SQLITE_ERROR"}] ASSERT H2 ids=32762 location=active PASS ROW H2 ids=32765 location=active expected={"count":32765,"tooManyVariables":true} ACTUAL failure [{"tag":"ProjectionStoreReadError","message":"Failed to read orchestration projection for thread thread:shell."},{"tag":"SqlError","message":"Failed to prepare statement"},{"tag":"UnknownError","message":"Failed to prepare statement"},{"message":"too many SQL variables","code":"ERR_SQLITE_ERROR"}] ASSERT H2 ids=32765 location=active PASS ROW H2 ids=32766 location=active expected={"count":32766,"tooManyVariables":true} ACTUAL failure [{"tag":"ProjectionStoreReadError","message":"Failed to read orchestration projection for thread thread:shell."},{"tag":"SqlError","message":"Failed to prepare statement"},{"tag":"UnknownError","message":"Failed to prepare statement"},{"message":"too many SQL variables","code":"ERR_SQLITE_ERROR"}] ASSERT H2 ids=32766 location=active PASS END R1 PASS BEGIN R2 + S1 large [15:57:55.667] INFO (#987): Migrations ran successfully { migrations: [ '1_OrchestrationEvents', '2_OrchestrationCommandReceipts', '3_CheckpointDiffBlobs', '4_ProviderSessionRuntime', '5_Projections', '6_ProjectionThreadSessionRuntimeModeColumns', '7_ProjectionThreadMessageAttachments', '8_ProjectionThreadActivitySequence', '9_ProviderSessionRuntimeMode', '10_ProjectionThreadsRuntimeMode', '11_OrchestrationThreadCreatedRuntimeMode', '12_ProjectionThreadsInteractionMode', '13_ProjectionThreadProposedPlans', '14_ProjectionThreadProposedPlanImplementation', '15_ProjectionTurnsSourceProposedPlan', '16_CanonicalizeModelSelections', '17_ProjectionThreadsArchivedAt', '18_ProjectionThreadsArchivedAtIndex', '19_ProjectionSnapshotLookupIndexes', '20_AuthAccessManagement', '21_AuthSessionClientMetadata', '22_AuthSessionLastConnectedAt', '23_ProjectionThreadShellSummary', '24_BackfillProjectionThreadShellSummary', '25_CleanupInvalidProjectionPendingApprovals', '26_CanonicalizeModelSelectionOptions', '27_ProviderSessionRuntimeInstanceId', '28_ProjectionThreadSessionInstanceId', '29_ProjectionThreadDetailOrderingIndexes', '30_ProjectionThreadShellArchiveIndexes', '31_AuthAuthorizationScopes', '32_AuthPairingProofKeyThumbprint', '33_ProjectionThreadsSettled', '34_ProjectionThreadsSnoozed', '35_ProjectionThreadTitleRegeneration', '36_ProjectionThreadsPinned', '37_ProjectionTurnsKeysetIndex', '38_ProjectionThreadsPinOrderKey', '39_ProjectionProjectsDefaultThreadEnvMode', '40_ProjectionProjectFaviconPath', '41_AuthSessionClientConnection', '42_ProjectionThreadLinkedPullRequest', '43_ProjectionThreadsUnsettledAt', '44_ClearAutomaticProjectModelDefaults', '45_ProjectionProjectsAutoPull', '46_RepairAutomaticSettlementTimestamps', '47_ProjectionProjectIcon', '48_ProjectionThreadBranchPullRequest', '49_ProjectionThreadsActiveOrderKey', '50_ProjectionThreadPullRequests', '51_ProjectionThreadMessageContext', '52_ProjectionThreadTitleState', '53_PullRequestFilesViewed', '54_ProjectionThreadsAutoSettleDisabledAt', '55_OrchestrationV2', '56_RemoveRedundantProjectionIndexes', '57_ScheduledTaskWebhooks', '58_WebhookRelayDeliveries', '59_McpAppModelContext', '60_ThreadSnapshotWindowIndexes', '61_PullRequestReviewGuides', '62_ThreadFailureLookupIndex', '63_DropUnusedV1Projections', '64_CanonicalizeThreadPullRequestLinks', '65_CodexUsageNativeTurnIndex', '66_RepairClientSettlementTimestamps', '67_WebhookDedupe', '68_ShellStopRequestIndex', '69_ThreadMessageSearch' ] } SQL_COUNTS [{"name":"threads","count":32767},{"name":"runs","count":0},{"name":"items","count":0},{"name":"providers","count":0}] ROW R2 {} expected={"count":32767,"tooManyVariables":true} ACTUAL failure [{"tag":"ProjectionStoreReadError","message":"Failed to read orchestration projection for thread thread:shell."},{"tag":"SqlError","message":"Failed to prepare statement"},{"tag":"UnknownError","message":"Failed to prepare statement"},{"message":"too many SQL variables","code":"ERR_SQLITE_ERROR"}] ASSERT R2 {} PASS ROW R2 {"location":"active"} expected={"count":32767,"tooManyVariables":true} ACTUAL failure [{"tag":"ProjectionStoreReadError","message":"Failed to read orchestration projection for thread thread:shell."},{"tag":"SqlError","message":"Failed to prepare statement"},{"tag":"UnknownError","message":"Failed to prepare statement"},{"message":"too many SQL variables","code":"ERR_SQLITE_ERROR"}] ASSERT R2 {"location":"active"} PASS ROW S1 32767 candidates expected={"count":32767,"tooManyVariables":true} ACTUAL failure [{"tag":"ProjectionStoreSetupError","message":"Failed to initialize orchestration projection store."},{"tag":"SqlError","message":"Failed to prepare statement"},{"tag":"UnknownError","message":"Failed to prepare statement"},{"message":"too many SQL variables","code":"ERR_SQLITE_ERROR"}] ASSERT S1 32767 candidates PASS END R2 + S1 large PASS BEGIN R5 [15:57:59.459] INFO (#1319): Migrations ran successfully { migrations: [ '1_OrchestrationEvents', '2_OrchestrationCommandReceipts', '3_CheckpointDiffBlobs', '4_ProviderSessionRuntime', '5_Projections', '6_ProjectionThreadSessionRuntimeModeColumns', '7_ProjectionThreadMessageAttachments', '8_ProjectionThreadActivitySequence', '9_ProviderSessionRuntimeMode', '10_ProjectionThreadsRuntimeMode', '11_OrchestrationThreadCreatedRuntimeMode', '12_ProjectionThreadsInteractionMode', '13_ProjectionThreadProposedPlans', '14_ProjectionThreadProposedPlanImplementation', '15_ProjectionTurnsSourceProposedPlan', '16_CanonicalizeModelSelections', '17_ProjectionThreadsArchivedAt', '18_ProjectionThreadsArchivedAtIndex', '19_ProjectionSnapshotLookupIndexes', '20_AuthAccessManagement', '21_AuthSessionClientMetadata', '22_AuthSessionLastConnectedAt', '23_ProjectionThreadShellSummary', '24_BackfillProjectionThreadShellSummary', '25_CleanupInvalidProjectionPendingApprovals', '26_CanonicalizeModelSelectionOptions', '27_ProviderSessionRuntimeInstanceId', '28_ProjectionThreadSessionInstanceId', '29_ProjectionThreadDetailOrderingIndexes', '30_ProjectionThreadShellArchiveIndexes', '31_AuthAuthorizationScopes', '32_AuthPairingProofKeyThumbprint', '33_ProjectionThreadsSettled', '34_ProjectionThreadsSnoozed', '35_ProjectionThreadTitleRegeneration', '36_ProjectionThreadsPinned', '37_ProjectionTurnsKeysetIndex', '38_ProjectionThreadsPinOrderKey', '39_ProjectionProjectsDefaultThreadEnvMode', '40_ProjectionProjectFaviconPath', '41_AuthSessionClientConnection', '42_ProjectionThreadLinkedPullRequest', '43_ProjectionThreadsUnsettledAt', '44_ClearAutomaticProjectModelDefaults', '45_ProjectionProjectsAutoPull', '46_RepairAutomaticSettlementTimestamps', '47_ProjectionProjectIcon', '48_ProjectionThreadBranchPullRequest', '49_ProjectionThreadsActiveOrderKey', '50_ProjectionThreadPullRequests', '51_ProjectionThreadMessageContext', '52_ProjectionThreadTitleState', '53_PullRequestFilesViewed', '54_ProjectionThreadsAutoSettleDisabledAt', '55_OrchestrationV2', '56_RemoveRedundantProjectionIndexes', '57_ScheduledTaskWebhooks', '58_WebhookRelayDeliveries', '59_McpAppModelContext', '60_ThreadSnapshotWindowIndexes', '61_PullRequestReviewGuides', '62_ThreadFailureLookupIndex', '63_DropUnusedV1Projections', '64_CanonicalizeThreadPullRequestLinks', '65_CodexUsageNativeTurnIndex', '66_RepairClientSettlementTimestamps', '67_WebhookDedupe', '68_ShellStopRequestIndex', '69_ThreadMessageSearch' ] } SQL_COUNTS [{"name":"threads","count":32768},{"name":"runs","count":0},{"name":"items","count":0},{"name":"providers","count":0}] ROW R5 unscoped expected={"count":32767,"tooManyVariables":true} ACTUAL failure [{"tag":"ProjectionStoreReadError","message":"Failed to read orchestration projection for thread thread:shell."},{"tag":"SqlError","message":"Failed to prepare statement"},{"tag":"UnknownError","message":"Failed to prepare statement"},{"message":"too many SQL variables","code":"ERR_SQLITE_ERROR"}] ASSERT R5 unscoped PASS ROW R5 active expected={"count":1,"tooManyVariables":false} ACTUAL success {"schemaVersion":2,"snapshotSequence":0,"threads":1,"archivedThreads":0,"idDigest":"062095be5993cfa55296d0f94dddd2b527b53d7ec532c7b19ad51fdf3cf2a760"} ASSERT R5 active PASS ROW R5 archive expected={"count":32766,"tooManyVariables":false} ACTUAL success {"schemaVersion":2,"snapshotSequence":0,"threads":0,"archivedThreads":32766,"idDigest":"7cd63aa76e1416ed087ede1c8d10c3e32d9b1be9c4fe66a748d879e3270ae24f"} ASSERT R5 archive PASS END R5 PASS BEGIN H1 16383 [15:58:04.981] INFO (#1656): Migrations ran successfully { migrations: [ '1_OrchestrationEvents', '2_OrchestrationCommandReceipts', '3_CheckpointDiffBlobs', '4_ProviderSessionRuntime', '5_Projections', '6_ProjectionThreadSessionRuntimeModeColumns', '7_ProjectionThreadMessageAttachments', '8_ProjectionThreadActivitySequence', '9_ProviderSessionRuntimeMode', '10_ProjectionThreadsRuntimeMode', '11_OrchestrationThreadCreatedRuntimeMode', '12_ProjectionThreadsInteractionMode', '13_ProjectionThreadProposedPlans', '14_ProjectionThreadProposedPlanImplementation', '15_ProjectionTurnsSourceProposedPlan', '16_CanonicalizeModelSelections', '17_ProjectionThreadsArchivedAt', '18_ProjectionThreadsArchivedAtIndex', '19_ProjectionSnapshotLookupIndexes', '20_AuthAccessManagement', '21_AuthSessionClientMetadata', '22_AuthSessionLastConnectedAt', '23_ProjectionThreadShellSummary', '24_BackfillProjectionThreadShellSummary', '25_CleanupInvalidProjectionPendingApprovals', '26_CanonicalizeModelSelectionOptions', '27_ProviderSessionRuntimeInstanceId', '28_ProjectionThreadSessionInstanceId', '29_ProjectionThreadDetailOrderingIndexes', '30_ProjectionThreadShellArchiveIndexes', '31_AuthAuthorizationScopes', '32_AuthPairingProofKeyThumbprint', '33_ProjectionThreadsSettled', '34_ProjectionThreadsSnoozed', '35_ProjectionThreadTitleRegeneration', '36_ProjectionThreadsPinned', '37_ProjectionTurnsKeysetIndex', '38_ProjectionThreadsPinOrderKey', '39_ProjectionProjectsDefaultThreadEnvMode', '40_ProjectionProjectFaviconPath', '41_AuthSessionClientConnection', '42_ProjectionThreadLinkedPullRequest', '43_ProjectionThreadsUnsettledAt', '44_ClearAutomaticProjectModelDefaults', '45_ProjectionProjectsAutoPull', '46_RepairAutomaticSettlementTimestamps', '47_ProjectionProjectIcon', '48_ProjectionThreadBranchPullRequest', '49_ProjectionThreadsActiveOrderKey', '50_ProjectionThreadPullRequests', '51_ProjectionThreadMessageContext', '52_ProjectionThreadTitleState', '53_PullRequestFilesViewed', '54_ProjectionThreadsAutoSettleDisabledAt', '55_OrchestrationV2', '56_RemoveRedundantProjectionIndexes', '57_ScheduledTaskWebhooks', '58_WebhookRelayDeliveries', '59_McpAppModelContext', '60_ThreadSnapshotWindowIndexes', '61_PullRequestReviewGuides', '62_ThreadFailureLookupIndex', '63_DropUnusedV1Projections', '64_CanonicalizeThreadPullRequestLinks', '65_CodexUsageNativeTurnIndex', '66_RepairClientSettlementTimestamps', '67_WebhookDedupe', '68_ShellStopRequestIndex', '69_ThreadMessageSearch' ] } SQL_COUNTS [{"name":"threads","count":16383},{"name":"runs","count":16383},{"name":"items","count":16384},{"name":"providers","count":0}] ROW H1 threads+runs=16383+16383 expected={"count":16383,"tooManyVariables":false} ACTUAL success {"schemaVersion":2,"snapshotSequence":0,"threads":16383,"archivedThreads":0,"idDigest":"9bb36c50db2ccd11f1fd25f035cf610a5548eb6308f3ccaedeb62e48c821ee9d"} ASSERT H1 threads+runs=16383+16383 PASS END H1 16383 PASS BEGIN H1 16384 [15:58:10.209] INFO (#1998): Migrations ran successfully { migrations: [ '1_OrchestrationEvents', '2_OrchestrationCommandReceipts', '3_CheckpointDiffBlobs', '4_ProviderSessionRuntime', '5_Projections', '6_ProjectionThreadSessionRuntimeModeColumns', '7_ProjectionThreadMessageAttachments', '8_ProjectionThreadActivitySequence', '9_ProviderSessionRuntimeMode', '10_ProjectionThreadsRuntimeMode', '11_OrchestrationThreadCreatedRuntimeMode', '12_ProjectionThreadsInteractionMode', '13_ProjectionThreadProposedPlans', '14_ProjectionThreadProposedPlanImplementation', '15_ProjectionTurnsSourceProposedPlan', '16_CanonicalizeModelSelections', '17_ProjectionThreadsArchivedAt', '18_ProjectionThreadsArchivedAtIndex', '19_ProjectionSnapshotLookupIndexes', '20_AuthAccessManagement', '21_AuthSessionClientMetadata', '22_AuthSessionLastConnectedAt', '23_ProjectionThreadShellSummary', '24_BackfillProjectionThreadShellSummary', '25_CleanupInvalidProjectionPendingApprovals', '26_CanonicalizeModelSelectionOptions', '27_ProviderSessionRuntimeInstanceId', '28_ProjectionThreadSessionInstanceId', '29_ProjectionThreadDetailOrderingIndexes', '30_ProjectionThreadShellArchiveIndexes', '31_AuthAuthorizationScopes', '32_AuthPairingProofKeyThumbprint', '33_ProjectionThreadsSettled', '34_ProjectionThreadsSnoozed', '35_ProjectionThreadTitleRegeneration', '36_ProjectionThreadsPinned', '37_ProjectionTurnsKeysetIndex', '38_ProjectionThreadsPinOrderKey', '39_ProjectionProjectsDefaultThreadEnvMode', '40_ProjectionProjectFaviconPath', '41_AuthSessionClientConnection', '42_ProjectionThreadLinkedPullRequest', '43_ProjectionThreadsUnsettledAt', '44_ClearAutomaticProjectModelDefaults', '45_ProjectionProjectsAutoPull', '46_RepairAutomaticSettlementTimestamps', '47_ProjectionProjectIcon', '48_ProjectionThreadBranchPullRequest', '49_ProjectionThreadsActiveOrderKey', '50_ProjectionThreadPullRequests', '51_ProjectionThreadMessageContext', '52_ProjectionThreadTitleState', '53_PullRequestFilesViewed', '54_ProjectionThreadsAutoSettleDisabledAt', '55_OrchestrationV2', '56_RemoveRedundantProjectionIndexes', '57_ScheduledTaskWebhooks', '58_WebhookRelayDeliveries', '59_McpAppModelContext', '60_ThreadSnapshotWindowIndexes', '61_PullRequestReviewGuides', '62_ThreadFailureLookupIndex', '63_DropUnusedV1Projections', '64_CanonicalizeThreadPullRequestLinks', '65_CodexUsageNativeTurnIndex', '66_RepairClientSettlementTimestamps', '67_WebhookDedupe', '68_ShellStopRequestIndex', '69_ThreadMessageSearch' ] } SQL_COUNTS [{"name":"threads","count":16384},{"name":"runs","count":16384},{"name":"items","count":16385},{"name":"providers","count":0}] ROW H1 threads+runs=16384+16384 expected={"count":16384,"tooManyVariables":true} ACTUAL failure [{"tag":"ProjectionStoreReadError","message":"Failed to read orchestration projection for thread thread:shell."},{"tag":"SqlError","message":"Failed to prepare statement"},{"tag":"UnknownError","message":"Failed to prepare statement"},{"message":"too many SQL variables","code":"ERR_SQLITE_ERROR"}] ASSERT H1 threads+runs=16384+16384 PASS END H1 16384 PASS BEGIN P0-P7 E2 K1 S1 small X1 rich fixture [15:58:12.374] INFO (#2340): Migrations ran successfully { migrations: [ '1_OrchestrationEvents', '2_OrchestrationCommandReceipts', '3_CheckpointDiffBlobs', '4_ProviderSessionRuntime', '5_Projections', '6_ProjectionThreadSessionRuntimeModeColumns', '7_ProjectionThreadMessageAttachments', '8_ProjectionThreadActivitySequence', '9_ProviderSessionRuntimeMode', '10_ProjectionThreadsRuntimeMode', '11_OrchestrationThreadCreatedRuntimeMode', '12_ProjectionThreadsInteractionMode', '13_ProjectionThreadProposedPlans', '14_ProjectionThreadProposedPlanImplementation', '15_ProjectionTurnsSourceProposedPlan', '16_CanonicalizeModelSelections', '17_ProjectionThreadsArchivedAt', '18_ProjectionThreadsArchivedAtIndex', '19_ProjectionSnapshotLookupIndexes', '20_AuthAccessManagement', '21_AuthSessionClientMetadata', '22_AuthSessionLastConnectedAt', '23_ProjectionThreadShellSummary', '24_BackfillProjectionThreadShellSummary', '25_CleanupInvalidProjectionPendingApprovals', '26_CanonicalizeModelSelectionOptions', '27_ProviderSessionRuntimeInstanceId', '28_ProjectionThreadSessionInstanceId', '29_ProjectionThreadDetailOrderingIndexes', '30_ProjectionThreadShellArchiveIndexes', '31_AuthAuthorizationScopes', '32_AuthPairingProofKeyThumbprint', '33_ProjectionThreadsSettled', '34_ProjectionThreadsSnoozed', '35_ProjectionThreadTitleRegeneration', '36_ProjectionThreadsPinned', '37_ProjectionTurnsKeysetIndex', '38_ProjectionThreadsPinOrderKey', '39_ProjectionProjectsDefaultThreadEnvMode', '40_ProjectionProjectFaviconPath', '41_AuthSessionClientConnection', '42_ProjectionThreadLinkedPullRequest', '43_ProjectionThreadsUnsettledAt', '44_ClearAutomaticProjectModelDefaults', '45_ProjectionProjectsAutoPull', '46_RepairAutomaticSettlementTimestamps', '47_ProjectionProjectIcon', '48_ProjectionThreadBranchPullRequest', '49_ProjectionThreadsActiveOrderKey', '50_ProjectionThreadPullRequests', '51_ProjectionThreadMessageContext', '52_ProjectionThreadTitleState', '53_PullRequestFilesViewed', '54_ProjectionThreadsAutoSettleDisabledAt', '55_OrchestrationV2', '56_RemoveRedundantProjectionIndexes', '57_ScheduledTaskWebhooks', '58_WebhookRelayDeliveries', '59_McpAppModelContext', '60_ThreadSnapshotWindowIndexes', '61_PullRequestReviewGuides', '62_ThreadFailureLookupIndex', '63_DropUnusedV1Projections', '64_CanonicalizeThreadPullRequestLinks', '65_CodexUsageNativeTurnIndex', '66_RepairClientSettlementTimestamps', '67_WebhookDedupe', '68_ShellStopRequestIndex', '69_ThreadMessageSearch' ] } SQL_COUNTS [{"name":"threads","count":25},{"name":"runs","count":13},{"name":"items","count":347},{"name":"providers","count":4}] SEED_SHA256 1f058fd5068205d0e256d01a5e4592d92c68aeb1a1846fe420a543735cc22e8c ROW P0 input={} {"schemaVersion":2,"snapshotSequence":0,"threads":23,"archivedThreads":1,"idDigest":"72421deb8a98078ff1418ee7575778b1430f0f9999eab2f706afea3ecf69645d"} ASSERT PASS ROW P1 input={"location":"active"} {"schemaVersion":2,"snapshotSequence":0,"threads":23,"archivedThreads":0,"idDigest":"28bbc03b44156f1addbd8c3348abe718b7b828c209e0a8e12549e69375e01506"} ASSERT PASS ROW P2 input={"location":"archive"} {"schemaVersion":2,"snapshotSequence":0,"threads":0,"archivedThreads":1,"idDigest":"dd9e881230ebf6e02363abdbb3566ee5aa13d0bae08caaf4334015d16a5a920d"} ASSERT PASS ROW P3 project:a input={"location":"active","projectId":"project:a"} {"schemaVersion":2,"snapshotSequence":0,"threads":22,"archivedThreads":0,"idDigest":"be5c43abd0c3daabbd1fdd2e0e623c5f7ae387121ec408aa337b4d88ef5fa198"} ASSERT PASS ROW P3 project:b input={"location":"active","projectId":"project:b"} {"schemaVersion":2,"snapshotSequence":0,"threads":1,"archivedThreads":0,"idDigest":"d9298a10d1b0735837dc4bd85dac641b0f3cef27a47e5d53a54f2f3f5b2fcffa"} ASSERT PASS ROW P3 project:missing input={"location":"active","projectId":"project:missing"} {"schemaVersion":2,"snapshotSequence":0,"threads":0,"archivedThreads":0,"idDigest":"e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855"} ASSERT PASS ROW P4 false input={"location":"active","unsettledOnly":false} {"schemaVersion":2,"snapshotSequence":0,"threads":23,"archivedThreads":0,"idDigest":"28bbc03b44156f1addbd8c3348abe718b7b828c209e0a8e12549e69375e01506"} ASSERT PASS ROW P4 true input={"location":"active","unsettledOnly":true} {"schemaVersion":2,"snapshotSequence":0,"threads":21,"archivedThreads":0,"idDigest":"ff83734e987e501667d28c4f650f19194364e79d5543a6c86db450663123809c"} ASSERT PASS ROW P5 root input={"location":"active","familyOf":"root"} {"schemaVersion":2,"snapshotSequence":0,"threads":5,"archivedThreads":0,"idDigest":"11e9f2ec8f4fd1e3ccdb1a0cd4a398c8326a41c8f66c3db6bc7d2b090f5bb634"} ASSERT PASS ROW P5 child input={"location":"active","familyOf":"child"} {"schemaVersion":2,"snapshotSequence":0,"threads":5,"archivedThreads":0,"idDigest":"11e9f2ec8f4fd1e3ccdb1a0cd4a398c8326a41c8f66c3db6bc7d2b090f5bb634"} ASSERT PASS ROW P5 missing input={"location":"active","familyOf":"missing"} {"schemaVersion":2,"snapshotSequence":0,"threads":0,"archivedThreads":0,"idDigest":"e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855"} ASSERT PASS ROW P5 deleted input={"location":"active","familyOf":"deleted"} {"schemaVersion":2,"snapshotSequence":0,"threads":1,"archivedThreads":0,"idDigest":"0deffced01e138a8805e5d6dc93e3a41afd79ae80fbe5ab17f09e7282d33179e"} ASSERT PASS ROW P6 /synthetic/shared input={"location":"active","worktreePath":"/synthetic/shared"} {"schemaVersion":2,"snapshotSequence":0,"threads":4,"archivedThreads":0,"idDigest":"8c39788f916fab9e37545d343b3ed32607bee1d44476d1c7bd1851446c470fc5"} ASSERT PASS ROW P6 /missing input={"location":"active","worktreePath":"/missing"} {"schemaVersion":2,"snapshotSequence":0,"threads":0,"archivedThreads":0,"idDigest":"e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855"} ASSERT PASS ROW P7 {"threadIds":["root"]} input={"location":"active","threadIds":["root"]} {"schemaVersion":2,"snapshotSequence":0,"threads":1,"archivedThreads":0,"idDigest":"4813494d137e1631bba301d5acab6e7bb7aa74ce1185d456565ef51d737677b2"} ASSERT PASS ROW P7 {"threadIds":["root","root","missing","quoted'\\日本語","archived"]} input={"location":"active","threadIds":["root","root","missing","quoted'\\日本語","archived"]} {"schemaVersion":2,"snapshotSequence":0,"threads":2,"archivedThreads":0,"idDigest":"7bcdda5677676fa496b5c1cb0c135c78407095ea1662a3628019829a18d5b84d"} ASSERT PASS ROW P7 {"threadIds":["root","quoted'\\日本語","other"],"projectId":"project:a","familyOf":"root","worktreePath":"/synthetic/shared"} input={"location":"active","threadIds":["root","quoted'\\日本語","other"],"projectId":"project:a","familyOf":"root","worktreePath":"/synthetic/shared"} {"schemaVersion":2,"snapshotSequence":0,"threads":1,"archivedThreads":0,"idDigest":"4813494d137e1631bba301d5acab6e7bb7aa74ce1185d456565ef51d737677b2"} ASSERT PASS ROW P7 {"threadIds":["other"],"projectId":"project:a","familyOf":"root","worktreePath":"/synthetic/shared"} input={"location":"active","threadIds":["other"],"projectId":"project:a","familyOf":"root","worktreePath":"/synthetic/shared"} {"schemaVersion":2,"snapshotSequence":0,"threads":0,"archivedThreads":0,"idDigest":"e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855"} ASSERT PASS ROW E2 input={"threadIds":[]} {"schemaVersion":2,"snapshotSequence":0,"threads":0,"archivedThreads":0,"idDigest":"e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855"} ASSERT PASS ROW K1 fork single equals snapshot ASSERT PASS ROW K1 nested single equals snapshot ASSERT PASS ROW K1 fork-missing single equals snapshot ASSERT PASS ROW K1 fork-deleted single equals snapshot ASSERT PASS ROW K1 missing single equals snapshot ASSERT PASS ROW K1 deleted single equals snapshot ASSERT PASS ROW K1 root single equals snapshot ASSERT PASS ROW K1 status:completed single equals snapshot ASSERT PASS ROW K1 status:rolled_back single equals snapshot ASSERT PASS ROW K1 status:queued single equals snapshot ASSERT PASS ROW K1 status:preparing single equals snapshot ASSERT PASS ROW K1 status:starting single equals snapshot ASSERT PASS ROW K1 status:running single equals snapshot ASSERT PASS ROW K1 status:waiting single equals snapshot ASSERT PASS ROW P0/K1 counts, runless/imported inheritance, goal, pending work, blocked statuses ASSERT PASS ROW S1 undefined count=14 ASSERT PASS ROW S1 other count=1 ASSERT PASS ROW S1 missing count=0 ASSERT PASS ROW S1 pinned count=0 ASSERT PASS ROW S1 disabled count=0 ASSERT PASS ROW S1 override count=0 ASSERT PASS ROW S1 request count=0 ASSERT PASS ROW S1 deleted count=0 ASSERT PASS ROW S1 archived count=0 ASSERT PASS ROW S1 status:running count=0 ASSERT PASS PARITY_SHA256 54db5811ecc32f15344f47a8ae1363d94b3cfe4cf51767834d925959d59cd251 ROW X1 read rows -> commit -> insert later -> decode: frozen=1 fresh=2 ASSERT PASS ROW X1 selected corruption [{"tag":"ProjectionStoreReadError","message":"Failed to read orchestration projection for thread thread:shell."},{"tag":"SchemaError","message":"Missing key\n at [\"createdBy\"]"}] ASSERT typed shell read error PASS ROW X1 outside scoped corruption excluded count=22 ASSERT PASS FINAL_PARITY_SHA256 efa2b0efbcb1e901bee55fc7f434878b759f8ec10a070f679a6f7751dc9b6906 END P0-P7 E2 K1 S1 small X1 rich fixture PASS