Event queue duplicate key violations

[moshloop]

mission-control-658fdcff4-wkgch mission-control {"time":"2025-12-04T08:46:14.025551752Z","level":"ERROR","msg":"ERROR >=\u001b[33m[2ms] \u001b[34;1m[rows:0]\u001b[0m ERROR: duplicate key value violates unique constraint "event_queue_name_properties" (SQLSTATE 23505) UPDATE "notifications" SET "name"=$1$,"namespace"=$2$,"events"=$3$,"title"=$4$,"template"=$5$,"filter"=$6$,"properties"=$7$,"source"=$8$,"repeat_interval"=$9$,"group_by"=$10$,"group_by_interval"=$11$,"watchdog_interval"=$12$,"created_by"=$13$,"deleted_at"=$14$,"inhibitions"=$15$,"playbook_id"=$16$,"person_id"=$17$,"team_id"=$18$,"custom_services"=$19$,"fallback_playbook_id"=$20$,"fallback_person_id"=$21$,"fallback_team_id"=$22$,"fallback_custom_services"=NULL,"fallback_delay"=$23$,"wait_for"=$24$,"wait_for_eval_period"=$25$,"error"=$26$,"error_at"=$27$ WHERE "id" = $28$","logger":"db"}
mission-control-658fdcff4-wkgch mission-control {"time":"2025-12-04T08:46:14.027842565Z","level":"ERROR","msg":"ERROR >=\u001b[33m[2ms] \u001b[34;1m[rows:0]\u001b[0m ERROR: duplicate key value violates unique constraint "event_queue_name_properties" (SQLSTATE 23505) UPDATE "notifications" SET "deleted_at"=NOW() WHERE (name = $1$ AND namespace = $2$) AND deleted_at IS NULL","logger":"db"}
mission-control-658fdcff4-wkgch mission-control {"time":"2025-

[adityathebe]

The notifications table doesn't have a trigger that touches the event_queue table.
Could be an outdated trigger

[adityathebe]

TODO: Run

 SELECT tgname, tgfoid::regproc AS fn, pg_get_triggerdef(oid) FROM pg_trigger WHERE tgrelid='notifications'::regclass AND NOT tgisinternal;

SELECT pg_get_functiondef('notify_table_updates_and_deletes'::regproc);

[adityathebe]

@moshloop which mission-control version is this? Which environment?