No-404 directive: navigation/practica-link-dead fired 3x — find and eliminate the dead practica link source (broken link/route), not just relabel the event

Sub-tickets

Questions

Activity

• wi-cli-venus created · 2026-06-13
• wi-cli-venus commented · 5w ago
  Rescoped 2026-07-13 (coder-mars-cc, pm-mars-cc agreed): NOT closed by f223ef93 alone. f223ef93 was confirmed hard-deleted between 2026-04-29 16:01Z and ~2026-06-05/06 (archive trigger only captures INSERT/UPDATE, so the DELETE itself left zero archive trace — forensic gap, not a link/route bug). It accounts for 15 of 45 practica-link-dead events (2026-06-10→2026-07-12) — the single biggest contributor but NOT the sole source: 18 other distinct práctica ids also produced 1-6 dead-link hits each, including at least one confirmed-benign self-delete (cd3fb062). Scope is now: why are prácticas still getting hard-deleted outside the normal soft-delete server-action path at all (not just this one id) — pending db-mars-cc's Postgres/Supabase log-retention check on whether this is an ongoing/recurring pattern or a closed historical window.
• wi-cli-venus commented · 5w ago
  db-mars-cc final forensics on f223ef93 (2026-07-13): DB-side forensics exhausted — Postgres log retention (~24h) doesn't reach 04-29→06-06 window; Supabase migration history (43 entries) has no deletion op; own migrations/git have no DELETE FROM practicas; appEvents has zero delete event for this id. Trigger correction: trg_practicas_archive IS BEFORE INSERT OR DELETE OR UPDATE and DOES archive DELETE (rec:=OLD) — but practicasArchive has zero archiveOp='DELETE' rows fleet-wide, all-time, so removal bypassed the trigger entirely (TRUNCATE/disabled-trigger-session/direct table surgery). Report: closed-unresolved unless an out-of-band record surfaces. Escalated to Elazar by pm-mars-cc. SECOND untraced hard-delete found: cc487cbb-caec-4301-a375-29d6b2de3c90 (one of the 18 other MARS-106 resourceIds) has the identical signature — missing from live practicas, archive history ends at an ordinary UPDATE (2026-04-21 14:38 UTC, review-aprobado), zero archiveOp='DELETE' row. Both f223ef93 and cc487cbb's last archive touch is archivedBy=Carolina Adaro (carolina.adaro@odontologia.uba.ar), same day 2026-04-21 — correlation flagged to Elazar/PM, not yet causally established. Full breakdown of the 18 non-f223ef93 resourceIds behind MARS-106's practica-link-dead events: 15 present w/ deletedAt set (legit soft-delete, stale-link = caching/UX only); 2 present w/ deletedAt null (not deleted — likely no-access reason, separate from this bug class); 1 (cc487cbb) = second untraced hard-delete. So of 19 total distinct ids, 2 are confirmed trigger-bypassed hard-deletes and the rest are non-issues on the deletion-forensics front.
• wi-cli-venus parentChanged · 4w ago
  parent=#1962