rosa/vernier
Watch
1
0
Fork
You've already forked vernier
 0
Code Issues 18 Pull requests 4 Projects Releases Packages 1 Wiki Activity

Orphan-Media garbage collection #134

New issue
Closed
opened 2026-08-06 15:40:23 +00:00 by rosa · 0 comments
rosa commented 2026-08-06 15:40:23 +00:00
Owner
Copy link

Orphan-Media garbage collection

Deferred from #131. Media has a lifecycle independent of Posts (ADR-0017 / #131):
removing or replacing a Post's Photo drops the reference but leaves the Media,
and a Media may be referenced by zero Posts. Cascade only fires at the User
boundary (ON DELETE CASCADE). So orphaned Media — never referenced, or left
behind by a Photo removal/replacement — accumulates and is not collected.

Why deferred: safe deletion needs to know a Media isn't referenced by any
Post (and stays that way), which is real bookkeeping; premature hard-delete risks
breaking a still-referenced image. Tolerating orphans keeps deletes safe in v1.

Signal to revisit: orphan volume becoming a meaningful share of DB size, or a
quota (#deferred) needing to reclaim space.

## Orphan-Media garbage collection Deferred from #131. Media has a lifecycle independent of Posts (ADR-0017 / #131): removing or replacing a Post's Photo drops the **reference** but leaves the Media, and a Media may be referenced by zero Posts. Cascade only fires at the **User** boundary (`ON DELETE CASCADE`). So orphaned Media — never referenced, or left behind by a Photo removal/replacement — accumulates and is **not** collected. **Why deferred:** safe deletion needs to know a Media isn't referenced by *any* Post (and stays that way), which is real bookkeeping; premature hard-delete risks breaking a still-referenced image. Tolerating orphans keeps deletes safe in v1. **Signal to revisit:** orphan volume becoming a meaningful share of DB size, or a quota (#deferred) needing to reclaim space.
rosa changed title from Deferred: orphan-Media garbage collection to Orphan-Media garbage collection 2026-08-10 02:17:12 +00:00
rosa closed this issue 2026-08-12 03:53:19 +00:00
Sign in to join this conversation.
No Branch/Tag specified
Branches Tags
main
renovate/axum-governor-2.x-lockfile
renovate/uuid-1.x-lockfile
renovate/async-trait-0.x-lockfile
prototype/media-picker
research/micropub-media-endpoint
docs/typed-responses-adr
No results found.
Labels
Clear labels   
kind
bug
 Something is broken

  
kind
enhancement
 New feature or improvement

  
wayfinder
grilling
 HITL ticket: decision resolved through conversation

  
wayfinder
map
 Canonical wayfinder map for an effort

  
wayfinder
prototype
 HITL ticket: cheap concrete artifact to react to

  
wayfinder
research
 AFK ticket: surface facts a decision waits on

  
wayfinder
task
 Ticket: manual work that unblocks a decision

  
workflow
needs-info
 Waiting on reporter for more information

  
workflow
needs-triage
 Maintainer needs to evaluate this issue

  
workflow
ready-for-agent
 Fully specified, waiting for an AFK agent

  
workflow
ready-for-human
 Requires human implementation

  
workflow
wontfix
 Will not be actioned

No labels
kind
bug
kind
enhancement
wayfinder
grilling
wayfinder
map
wayfinder
prototype
wayfinder
research
wayfinder
task
workflow
needs-info
workflow
needs-triage
workflow
ready-for-agent
workflow
ready-for-human
workflow
wontfix
Milestone
Clear milestone
No items
No milestone
Projects
Clear projects
No items
No project
Assignees
Clear assignees
No assignees
1 participant
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set

Reference
rosa/vernier#134
No description provided.