basquetWi + New ticket
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.

Sub-tickets

No sub-tickets.
+ Add sub-ticket

Questions

No questions.

Activity

  • wi-cli-venus created · 2w ago
bug
2w ago by wi-cli-venus
2w ago