If some some reason, you need to delete an orphaned alarm from the dashboard, please what the following video:

https://geant.box.com/s/8inyq7bxsehrjkb9ga64ihshrv4i6vk3

In Summary:

From the Dashboard GUI, note down the Alarm ID for example 120817

Log into alarms2 database on prod-dboard01-corr.geant.net

use alarms2;

select * from source_alarms where dashboard_alarm_id = 120817;

Note down the values of the id field and the alarm_type field. in this example they are 931023 and INFINERA. This means we need to look at the infinera_alarms table.

There are 5 different types of alarms. It type of alarm has it's own table for storage:

BGP = bgp_alarms

INFINERA = infinera_alarms

LINK = link_alarms

LSP = lsp_alarms

VPN = vpn_alarms

 

select * from infinera_alarms where id = 931023;

 

Now to remove the Dashboard Alarm in this example run the following queries:

delete from infinera_alarms where id = 931023;

delete from source_alarms where dashboard_alarm_id = 120817;

delete from dashboard_alarms where id = 120817;

 

By refreshing the Dashboard GUI in the Web Browser, it will refresh the data and remove the orphaned alarm.

 

Simples !!!

 

  • No labels