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

WS-B1 Message identity: deterministic surrogate id + remote_id/uid_validity columns (C1 fix) [GATE] #281

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

blake3(account_id|folder_id|uid_validity|remote_id) surrogate id as PK/wire handle; add remote_id+uid_validity columns + UNIQUE(account,folder,uidvalidity,remote_id); outbox reads remote_id off the row (stops parsing the id) -> eliminates imap-uid- from the wire and fixes cross-folder/account collision. LANDS FIRST (gates WS-A4 + the Message shape). Size M.

Part of the Roadmap-to-9/10 program (design: scratchpad/design/, ROADMAP-TO-9.md). Serial PROTO queue: only one [PROTO] story in flight at a time; WS-A is the sole .proto editor. Detailed brief written at dispatch. DoD per docs/STORY-WORKFLOW.md (engine+proto+CLI+offline mock-only E2E, no fabrication, golden regen on proto change).

blake3(account_id|folder_id|uid_validity|remote_id) surrogate id as PK/wire handle; add remote_id+uid_validity columns + UNIQUE(account,folder,uidvalidity,remote_id); outbox reads remote_id off the row (stops parsing the id) -> eliminates imap-uid- from the wire and fixes cross-folder/account collision. LANDS FIRST (gates WS-A4 + the Message shape). Size M. Part of the Roadmap-to-9/10 program (design: scratchpad/design/, ROADMAP-TO-9.md). Serial PROTO queue: only one [PROTO] story in flight at a time; WS-A is the sole .proto editor. Detailed brief written at dispatch. DoD per docs/STORY-WORKFLOW.md (engine+proto+CLI+offline mock-only E2E, no fabrication, golden regen on proto change).
KofTwentyTwo commented 2026-07-31 18:57:24 +00:00 (Migrated from github.com)
Copy link
Copy source

Delivered via PR #337 (WS-B1, squash-merged to dev). Message identity C1 fix: deterministic surrogate id = sha256 over length-prefixed (account_id,folder_id,uid_validity,remote_id) + new remote_id/uid_validity columns + UNIQUE index; same UID across folders/accounts no longer silently overwrites (regression-tested). The outbox recovers remote addressing from the columns (stops parsing imap-uid-, wire id now opaque) while preserving the #252 UIDVALIDITY fail-closed guard; fire-once holds via the stable surrogate id. Migration is atomic + self-healing (crash-mid-migration recovers). Opus review APPROVED. GATE for the Message-shape proto stories (WS-A4/B2/B3/B4). Follow-ups #338 (legacy-orphan reap) + #339 (JMAP folder label) filed.

Delivered via PR #337 (WS-B1, squash-merged to dev). Message identity C1 fix: deterministic surrogate id = sha256 over length-prefixed (account_id,folder_id,uid_validity,remote_id) + new remote_id/uid_validity columns + UNIQUE index; same UID across folders/accounts no longer silently overwrites (regression-tested). The outbox recovers remote addressing from the columns (stops parsing imap-uid-, wire id now opaque) while preserving the #252 UIDVALIDITY fail-closed guard; fire-once holds via the stable surrogate id. Migration is atomic + self-healing (crash-mid-migration recovers). Opus review APPROVED. GATE for the Message-shape proto stories (WS-A4/B2/B3/B4). Follow-ups #338 (legacy-orphan reap) + #339 (JMAP folder label) filed.
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-B: Mail model & mutations
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#281