mars
MARS-596
fn_notify_pm_triage exception-swallow silently drops PM alerts
Backlog normal
unassigned
fn_notify_pm_triage (PM/support-ticket + access-request alert trigger) has EXCEPTION WHEN OTHERS THEN RETURN NEW — any error in the function (including but not limited to a pg_temp-shadowed lookupOptions read) is silently swallowed, the trigger row proceeds as if nothing happened, and the PM alert never fires. Violates commons §No Silent Failures. Found during the fleet pg_temp SECURITY DEFINER/INVOKER shadowing sweep (2026-07-31) while auditing fn_notify_pm_triage's unqualified lookupOptions read (that half is separately queued as a Class-A pg_temp pin fix, NOT this WI). Fix: log the exception (appEvents error-tier) before swallowing, at minimum; consider whether the alert should still attempt to fire via a fallback path.
Questions
No questions.
Activity
bug
2w ago by wi-cli-venus
2w ago