Libre-Alerts

root@librenms:/opt/librenms# ./alerts.php -d
DEBUG!
SQL[insert into `cache_locks` (`key`, `owner`, `expiration`) values (?, ?, ?) ["laravel_cachealerts","8HK0QwtRNFOqEcJo",1632306898] 0.48ms]

Start: Wed, 22 Sep 2021 16:03:58 +0530
ClearStaleAlerts():
SQL[SELECT `alerts`.`id` AS `alert_id`, `devices`.`hostname` AS `hostname` FROM `alerts` LEFT JOIN `devices` ON `alerts`.`device_id`=`devices`.`device_id`  RIGHT JOIN `alert_rules` ON `alerts`.`rule_id`=`alert_rules`.`id` WHERE `alerts`.`state`!=0 AND `devices`.`hostname` IS NULL [] 1.47ms]

RunFollowUp():
SQL[SELECT alerts.id, alerts.alerted, alerts.device_id, alerts.rule_id, alerts.state, alerts.note, alerts.info FROM alerts WHERE alerts.state > 0 && alerts.open = 0 [] 0.26ms]

RunAlerts():
SQL[SELECT alerts.id, alerts.alerted, alerts.device_id, alerts.rule_id, alerts.state, alerts.note, alerts.info FROM alerts WHERE alerts.state != 2 && alerts.open = 1 [] 0.2ms]

RunAcks():
SQL[SELECT alerts.id, alerts.alerted, alerts.device_id, alerts.rule_id, alerts.state, alerts.note, alerts.info FROM alerts WHERE alerts.state = 2 && alerts.open = 1 [] 0.2ms]

End  : Wed, 22 Sep 2021 16:03:58 +0530
SQL[select * from `cache_locks` where `key` = ? limit 1 ["laravel_cachealerts"] 0.34ms]

SQL[delete from `cache_locks` where `key` = ? and `owner` = ? ["laravel_cachealerts","8HK0QwtRNFOqEcJo"] 0.32ms]