KofTwentyTwo/nuncio
2
0 Fork 0
Code Issues 73 Pull Requests 12 Actions Packages Projects Releases Wiki Activity

WS-F5 Hygiene: kill is_new_message N+1 SELECT-per-message in sync #325

New Issue
Closed
opened 2026-07-31 18:15:38 +00:00 by KofTwentyTwo · 1 comment
KofTwentyTwo commented 2026-07-31 18:15:38 +00:00 (Migrated from github.com)
Copy link
Copy source

Size S.

Roadmap-to-9/10 (design: scratchpad/design/). Serial PROTO queue via WS-A. Brief at dispatch. DoD per docs/STORY-WORKFLOW.md; DAV tests wiremock-only.

Size S. Roadmap-to-9/10 (design: scratchpad/design/). Serial PROTO queue via WS-A. Brief at dispatch. DoD per docs/STORY-WORKFLOW.md; DAV tests wiremock-only.
KofTwentyTwo commented 2026-07-31 19:11:07 +00:00 (Migrated from github.com)
Copy link
Copy source

Delivered via PR #341 (WS-F5, squash-merged to dev). Replaced the per-message is_new_message N+1 with one batched existing_message_ids(chunk) SELECT + a per-pass HashSet for intra-chunk dedup, preserving fire-once semantics exactly (existing regression + new mixed-batch test + 2 unit tests). PO-accepted behavior change: a DB error during the batch existence check now propagates (fails the sync honestly) instead of the old per-message log-and-treat-as-not-new — consistent with the fail-closed hardening direction (cf #247), no effect on the fire-once guarantee.

Delivered via PR #341 (WS-F5, squash-merged to dev). Replaced the per-message is_new_message N+1 with one batched existing_message_ids(chunk) SELECT + a per-pass HashSet for intra-chunk dedup, preserving fire-once semantics exactly (existing regression + new mixed-batch test + 2 unit tests). PO-accepted behavior change: a DB error during the batch existence check now propagates (fails the sync honestly) instead of the old per-message log-and-treat-as-not-new — consistent with the fail-closed hardening direction (cf #247), no effect on the fire-once guarantee.
Sign in to join this conversation.
No Branch/Tag Specified
Labels
Clear labels
area-ci
CI / quality gates
 area-cli
nuncio-cli reference client
 area-docs
Documentation
 area-grpc
gRPC API layer
 area-mail
Mail protocols
 area-release
Release / packaging
 area-security
Security
 area-store
Storage / SQLite
 bug
Something isn't working
 deferred
Backlog, off the critical path; re-justify before scheduling
 dependencies
Pull requests that update a dependency file
 documentation
Improvements or additions to documentation
 duplicate
This issue or pull request already exists
 enhancement
New feature or request
 github_actions
Pull requests that update GitHub Actions code
 good first issue
Good for newcomers
 help wanted
Extra attention is needed
 invalid
This doesn't seem right
 javascript
Pull requests that update javascript code
 phase-0
Roadmap Phase 0
 phase-1
Roadmap Phase 1
 phase-2
Roadmap Phase 2
 phase-3
Roadmap Phase 3
 phase-4
Roadmap Phase 4
 phase-5
Roadmap Phase 5
 question
Further information is requested
 rust
Pull requests that update rust code
 story
Roadmap story: full LLM-ready spec, done via engine+proto+CLI+E2E
 wontfix
This will not be worked on
No labels story
Milestone
No items
No Milestone WS-F: Ops, usability & maintainability
Projects
Clear projects
No projects
Assignees
Clear assignees
forge-recovery (Forge Recovery) james.maes (James Maes)
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: KofTwentyTwo/nuncio#325