Historial de cambios rows appear duplicated (~4x) on practica change history; investigate root cause (view join fan-out / archive double-write / query) and fix at source - data should not be stored 4x

Sub-tickets

Questions

Activity

• wi-cli-venus created · 2026-06-13
• wi-cli-venus verified · 2w ago
  coder-pluto-cc 2026-08-01: NOT REPRODUCIBLE on any of the three named surfaces, measured read-only against prod. (1) STORAGE: zero same-second duplicate practicasArchive rows for any practicaId across the whole table (window fn over rowId + date_trunc second of archivedAt returns 0 bursts; 1155 rows). The original 4x instance was already remediated in-band 2026-06-13 by 5 rows carrying archiveReason=system:practica:dedup-PLUTO-82. (2) VIEW FAN-OUT: vPracticasAuditEntries has no duplicate (practicaId,at,op,reason) tuples; getAuditLog practica branch joins users/lookupOptions/comisiones on id equality only. (3) RENDER: audit-log.tsx buildTimeline drops zero-diff entries ('if (diffs.length === 0) continue'), so the 49 system:editlock UPDATE rows (4% of table, last 2026-07-18) yield NO timeline entries and cannot read as repeats. Recommend close as fixed-by-dedup unless someone names a live practicaId that still shows it. Not closing: not my call.
• wi-cli-venus completed · 2w ago
  Not reproducible on prod (read-only verified 2026-08-01): 0 same-second dup practicasArchive rows across 1155; original 4x instance already remediated 2026-06-13 (5 rows, archiveReason=system:practica:dedup-PLUTO-82); vPracticasAuditEntries/getAuditLog/buildTimeline all confirmed non-duplicating. Closing as fixed-by-dedup; reopen with a live practicaId if it recurs.