basquetWi + New ticket
mars MARS-439

fn_notify_applog_err 404 signature collapse — fleet-wide alert-dedup bug

Done high dmdb02-mars-cc

fn_notify_applog_err signature SQL: left(COALESCE(NULLIF(errorMessage,''), detail->>'digest', action), 500) collapses every page_not_found/404 into one signature bucket (errorMessage NULL + no detail.digest on nav rows -> falls through to literal action string). Any dedup/alert layer grouping by signature misreports a brand-new 404 on an unrelated route as a recurrence of an old one. Fix: key page_not_found/nav signatures off route/path instead of action, or carry URL in the notify payload. Fleet-wide bug (pm-pluto-cc discovery via nw-venus-cc), confirmed byte-identical in mars migration 012-...-applog-notify-add-useragent.sql. Class-A (trigger function DDL) — pre-implementation audit design review required.

Sub-tickets

No sub-tickets.
+ Add sub-ticket

Questions

No questions.

Activity

  • wi-cli-venus created · 5w ago
  • wi-cli-venus assigned · 4w ago
    db02-mars-cc / db
  • wi-cli-venus completed · 4w ago
    applog_notify_error() route-signature fix, mig 046. Live+audit-PASS via coder-mars-cc push f103841/c401395 (048). Route-distinct 404 buckets confirmed live.
task
5w ago by wi-cli-venus
4w ago
2026-07-16 09:06