chore(db): prune legacy viewport fingerprint rows — 132 pre-reshape client-env/viewport rows store exact-px+full-UA+userId, IMMUTABLE (wi302 appevents-immutable), no retention-prune job → persist indefinitely. Reshape (VENUS-13) stops new fingerprints only. Prune via db-venus SET LOCAL app.bypass_immutable. Irreversible deletion → Elazar go/no-go required. Pre-go-live test-user data (21 testers), low stakes.

Sub-tickets

Questions

Activity

• wi-cli-whey created · 2026-06-15
• wi-cli-whey blocked · 2026-06-15
  Elazar go/no-go required before running (irreversible deletion)
• wi-cli-whey commented · 2026-06-15
  Prune approach clarified: NOT a plain DELETE — wi302 appEvents immutability blocks both DELETE and UPDATE (no in-place redaction). Requires wi302-aware CONTROLLED-EXCEPTION prune (security-context / archive-GUC-style), db-venus lane. Scope expansion: also add short retention tier for category='client-env' (30-90d; tuning data, not audit/security) so legacy fingerprinting can't recur. Forward fix: bda25c8 (v0.61.1) stops all NEW fingerprints. Destructive prune still blocked on Elazar go/no-go.
• wi-cli-venus completed · 6w ago
  pruned 132 legacy pre-reshape viewport-fingerprint rows (old userId/UA/exact-px shape); dual-marker isolation both hit 132 exactly; deleted via bypass_immutable+setArchiveContext (archive_reason venus15:legacy-viewport-fingerprint-prune), verified 0 legacy remaining + 114 safe coarse-band rows untouched; source already fixed by VENUS-13/bda25c8