root@io-azp-observ01:~# /data/observium/alerter.php -d -h al03.02.mdf01.phx02.ip.example.com
DEBUG!

SQL[SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'dbSchema';]
SQL RUNTIME[0.00026298s]

SQL[SELECT @@SESSION.sql_mode;]
SQL RUNTIME[0.00008297s]

SQL[SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'current_rev';]
SQL RUNTIME[0.00004697s]

SQL[SELECT * FROM `config`]
SQL RUNTIME[0.00004792s]

CMD[/bin/hostname -f]

CMD EXITCODE[0]
CMD RUNTIME[0.0017s]
CMD EXITDELAY[10ms]
STDOUT[
observium.example.domain.com
]

  ___   _                              _
 / _ \ | |__   ___   ___  _ __ __   __(_) _   _  _ __ ___
| | | || '_ \ / __| / _ \| '__|\ \ / /| || | | || '_ ` _ \
| |_| || |_) |\__ \|  __/| |    \ V / | || |_| || | | | | |
 \___/ |_.__/ |___/ \___||_|     \_/  |_| \__,_||_| |_| |_|
                           Observium Professional 17.2.8356
                                   http://www.observium.org

#####  Starting alerter run at 2017-03-01 09:24:46  #####


SQL[SELECT * FROM `alert_tests` WHERE 1]
SQL RUNTIME[0.00009489s]
Cached 20 alert rules.

SQL[SELECT * FROM `alert_assoc`]
SQL RUNTIME[0.00006294s]

SQL[SELECT `device_id` FROM `devices` WHERE `disabled` = 0 AND `hostname` LIKE 'al03.02.mdf01.phx02.ip.example.com' ORDER BY `device_id` ASC]
SQL RUNTIME[0.00029206s]

SQL[SELECT * FROM `devices` WHERE `device_id` = '285']
SQL RUNTIME[0.00023413s]

SQL[SELECT * FROM `observium_processes` WHERE `process_name` = 'alerter.php' AND `device_id` = '285']
SQL RUNTIME[0.00017190s]

CMD[/bin/ps -ww -o pid,ppid,uid,gid,tty,stat,time,lstart,args -p 20303]

CMD EXITCODE[0]
CMD RUNTIME[0.0122s]
STDOUT[
  PID  PPID   UID   GID TT       STAT     TIME                  STARTED COMMAND
20303 12529     0     0 pts/2    S+   00:00:00 Wed Mar  1 09:24:45 2017 php /data/observium/alerter.php -d -h al03.02.mdf01.phx02.ip.example.com
]

CMD[date "+%:z"]

CMD EXITCODE[0]
CMD RUNTIME[0.0071s]
STDOUT[
-07:00
]

SQL[SELECT TIMEDIFF(NOW(), UTC_TIMESTAMP);]
SQL RUNTIME[0.00016713s]

CMD[/bin/ps -ww -o pid,ppid,uid,gid,tty,stat,time,lstart,args -p 12529]

CMD EXITCODE[0]
CMD RUNTIME[0.0159s]
STDOUT[
  PID  PPID   UID   GID TT       STAT     TIME                  STARTED COMMAND
12529 11155     0     0 pts/2    S    00:00:00 Wed Mar  1 08:55:38 2017 /bin/bash
]

SQL[INSERT INTO `observium_processes` (`process_pid`,`process_name`,`process_ppid`,`process_uid`,`process_command`,`process_start`,`device_id`)  VALUES ('20303','alerter.php','12529','0','php /data/observium/alerter.php -d -h al03.02.mdf01.phx02.ip.example.com','1488385485','285')]
SQL RUNTIME[0.00129914s]
#####  al03.02.mdf01.phx02.ip.example.com [285]  #####


SQL[SELECT * FROM  `alert_table` WHERE `device_id` = '285']
SQL RUNTIME[0.00025606s]

SQL[SELECT * FROM `alert_table` WHERE `device_id` = '285' AND `alert_status` IS NOT NULL;]
SQL RUNTIME[0.00019002s]
 o Alert: 5493          Status: [1] Status: OK.
 o Alert: 5494          Status: [1] Status: OK.
 o Alert: 5495          Status: [1] Status: OK.
 o Alert: 5496          Status: [1] Status: OK.
 o Alert: 5497          Status: [1] Status: OK.
 o Alert: 5498          Status: [1] Status: OK.
 o Alert: 5499          Status: [1] Status: OK.
 o Alert: 19150         Status: [1] Status: OK.
 o Alert: 19151         Status: [1] Status: OK.
 o Alert: 19152         Status: [1] Status: OK.
 o Alert: 19153         Status: [1] Status: OK.

#####  al03.02.mdf01.phx02.ip.example.com [285] completed notifications at 2017-03-01 09:24:46  #####


SQL[DELETE FROM `observium_processes` WHERE `process_pid` = '20303' AND `process_name` = 'alerter.php' AND `device_id` = '285']
SQL RUNTIME[0.00130010s]

SQL[SELECT * FROM `notifications_queue` WHERE `aca_type` = 'alert' AND `device_id` = '285']
SQL RUNTIME[0.00016689s]

SQL[SELECT * FROM `notifications_queue` WHERE `aca_type` = 'syslog' AND `device_id` = '285']
SQL RUNTIME[0.00018978s]

SQL[SELECT `notification_locked` FROM `notifications_queue` WHERE `notification_id` = '188']
SQL RUNTIME[0.00015306s]

SQL[UPDATE `notifications_queue` set `notification_locked` ='1' WHERE `notification_id` = '188']
SQL RUNTIME[0.00134802s]
 o Notifying            [email] Sean Pedersen: {"email":"username_lol@domain.example.com"}
MAILER-DAEMON... Saved message in /var/lib/sendmail/dead.letter
Mailer Error: mail() returned failure

SQL[DELETE FROM `notifications_queue` WHERE `notification_id` = '188']
SQL RUNTIME[0.00121713s]

SQL[SELECT `notification_locked` FROM `notifications_queue` WHERE `notification_id` = '189']
SQL RUNTIME[0.00013900s]

SQL[UPDATE `notifications_queue` set `notification_locked` ='1' WHERE `notification_id` = '189']
SQL RUNTIME[0.00101900s]
 o Notifying            [email] Sean Pedersen: {"email":"username_lol@domain.example.com"}
MAILER-DAEMON... Saved message in /var/lib/sendmail/dead.letter
Mailer Error: mail() returned failure

SQL[DELETE FROM `notifications_queue` WHERE `notification_id` = '189']
SQL RUNTIME[0.00133395s]

SQL[UPDATE `devices` set `last_alerter` =NOW() WHERE `device_id` = '285']
SQL RUNTIME[0.00048804s]
#####  Finished alerter run at 2017-03-01 09:24:47  #####