Venus appEvents conform to fleet standard: categoryId uuid FK->lookupOptions + seed appEventCategory group + backfill w/ renames (access->authz, app->system, client-env->client); add 4 promoted cols (httpStatus/durationMs/path/failureCode); canonical logError/logWarn/logInfo wrappers + pickKnown + isCritical sync-bypass; canonical v_appEvents_* views; error-tier retention job (180d, GUC-bypass); re-level 1435 perf/warn rows->info; legacy_events sink decision for ~1552 rows. BLOCKED on committed SSOT + Elazar priority call.

Sub-tickets

Questions

Activity

• wi-cli-venus created · 2026-06-13
• wi-cli-venus assigned · 6w ago
  solo-venus-cc
• wi-cli-venus statusChanged · 6w ago
  Resuming at Stage D (deferred queue): indexes+views+legacy-category sweep (reversible, ship solo) + retention policy/mechanism DRY-RUN only (COUNT by age/category, hard-stop for PM go/no-go — no DELETE). Stage E deferred. DDL → pre-impl design-ping first.
• wi-cli-venus commit · 6w ago
  Stage D pt1 SHIPPED b942317/v0.77.5 (PTD-green, divergent-audited): SSOT §7 indexes (added 5: categoryId+action, actorUserId, ix_alerts[error,warn], ix_404, ix_security[5 sec uuids]) + historical cron retag system->cron (26 rows) via DROP/recreate-byte-identical trigger dance + read-back assert; soporte-cron 6 emits app->cron. §5.1 bug CONFIRMED live (RETURN OLD on UPDATE no-ops), sidestepped by drop-dance. HELD for pt2: 7 v_appEvents_* views (need verbatim §8 bodies) + retention tier expansion (dry-run=0 rows due today, awaiting PM go/no-go per irreversibility gate).
• wi-cli-venus commit · 6w ago
  Stage D pt2 SHIPPED 5db8a44/v0.77.6 (PTD-green, divergent-audited PASS): 7 canonical v_appEvents_* views (errors_24h/alerts/recurring/friction/404/security/misleveled) per SSOT §8, reconciled to venus categoryId+FK via lookupOptions JOIN; security 5-set via params->>'security'='true'; misleveled WHERE verbatim. All CREATE OR REPLACE VIEW, reversible, zero data mutation, applied to prod (7 persist). Open flag: recurring HAVING count>1 documented+flagged for SSOT-owner veto. pt3 (retention tier expansion) HELD for Elazar go/no-go — DELETE jobs NOT installed.
• wi-cli-venus commit · 6w ago
  Stage D pt3 SHIPPED 1ed0b9f/v0.77.7 (divergent auditor re-PASS) — CLOSES Stage D. §9 4-tier retention (error 180d/warn 90d/info 90d/debug 7d, security 5-set forever). 4 pg_cron jobs live, all guards categoryId-predicate + fail-closed circuit-breaker (count<5 abort). BLOCKER closed (0 rows exposed by guard rewrite, verified live). Dry-run=0 all tiers. Elazar GO. Stage D = indexes+retag(pt1)+7 views(pt2)+retention(pt3) all DONE+prod-verified.
• wi-cli-venus completed · 5w ago
  Closeout: WI was stale, not blocked. SSOT already committed (../shared/md/evolutiva-appevents-standard.md, ratified fleet standard pm-mars/pm-pluto/pm-venus 2026-06-13, lives one dir above venus repo). categoryId FK+NOT NULL, 4 promoted cols, logError/logWarn/logInfo+pickKnown+isCritical (logger-core.ts), indexes, 7 views, 4-tier retention: all DONE and prod-verified 2026-07-03 (venus4a/4b/4d/4d2/4d3). perf re-level: DONE (category='perf'=0, independently confirmed by db-venus-cc). legacy_events sink: MOOT (categoryId-null=0, independently confirmed, zero unmappable rows). Only residual = Stage E appEventRelays sidecar, deferred+not-needed (no UPDATE-relay pattern exists on venus), split to VENUS-218. No Elazar priority call needed — no phantom backlog behind this WI. Memo: pm/venus-4-closeout-gap-analysis.md (solo-venus-cc).