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

WS-B follow-up: reap orphaned legacy message rows after identity migration #338

New Issue
Open
opened 2026-07-31 18:52:14 +00:00 by KofTwentyTwo · 0 comments
KofTwentyTwo commented 2026-07-31 18:52:14 +00:00 (Migrated from github.com)
Copy link
Copy source

From the WS-B1 (#281) review. After the surrogate-id migration, legacy rows keep their old id + remote_id='imap-uid-N' + uid_validity=''; on the next re-sync the same message gets a new identity tuple -> a new surrogate id -> a second row, orphaning the legacy one (never reaped). Not data loss, not a collision (confirmed), acceptable for pre-alpha. Fix options: drop+rebuild the messages table on the identity migration (cleanest, pre-alpha data is disposable), or reap rows whose id still has the imap-uid- shape after a full re-sync, or document it. Low priority. Source: #337 review Minor #1.

From the WS-B1 (#281) review. After the surrogate-id migration, legacy rows keep their old id + remote_id='imap-uid-N' + uid_validity=''; on the next re-sync the same message gets a new identity tuple -> a new surrogate id -> a second row, orphaning the legacy one (never reaped). Not data loss, not a collision (confirmed), acceptable for pre-alpha. Fix options: drop+rebuild the messages table on the identity migration (cleanest, pre-alpha data is disposable), or reap rows whose id still has the imap-uid- shape after a full re-sync, or document it. Low priority. Source: #337 review Minor #1.
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 enhancement
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#338