Details
-
Bug
-
Resolution: Fixed
-
Major
-
None
-
Professional Edition
-
ubuntu 14 LTS
Description
In May, I switched my tables in my database from MyISAM to INNODB. At that time, it started showing INNODB IO. After may (around June 17th) I updated the MySQL version to 5.6. After that, the data is no longer retrieved. Is MySQL 5.6 not supported yet? I updated the local_agent and restarted xinetd but it appears that didn't help any.
Any help would be appreciated.
Attachments
- Capture.PNG
- 37 kB
- Capture.PNG
- 74 kB
Activity
Yeah. They've made changes which have broken compatibility with the agent script, so that'll need to be modified to try to support the changes.
DEBUG!
[0;32mObservium 0.15.7.6579
[1;37mPoller[0m
[0m
CMD[[0;33m/opt/observium/scripts/distro[0m]
[0m
EXITCODE[[0;32m0[0m]
RUNTIME[[0;32m0.0764s[0m][0m
STDOUT[
Linux|3.13.0-43-generic|amd64|Ubuntu|14.04
][0m
CMD[[0;33m/usr/bin/env python --version 2>&1[0m]
[0m
EXITCODE[[0;32m0[0m]
RUNTIME[[0;32m0.0029s[0m][0m
STDOUT[
Python 2.7.6
][0m
SQL[[0;33mSELECT version()[0m][0m
RUNTIME[[0;32m0.00023603s[0m][0m
CMD[[0;33m/usr/bin/snmpget --version 2>&1[0m]
[0m
EXITCODE[[0;32m0[0m]
RUNTIME[[0;32m0.0028s[0m][0m
STDOUT[
NET-SNMP version: 5.7.2
][0m
CMD[[0;33m/usr/bin/rrdtool --version |head -n1[0m]
[0m
EXITCODE[[0;32m0[0m]
RUNTIME[[0;32m0.0082s[0m][0m
STDOUT[
RRDtool 1.4.7 Copyright 1997-2012 by Tobias Oetiker <tobi@oetiker.ch>
][0m
[1;37mSoftware versions:[0m
[1mOS[0m: Linux 3.13.0-43-generic [amd64] (Ubuntu 14.04)
[1mPHP[0m: 5.5.9-1ubuntu4.11
[1mPython[0m: Python 2.7.6
[1mMySQL[0m: 5.6.19-0ubuntu0.14.04.1 (extension: mysqli 5.5.43)
[1mSNMP[0m: NET-SNMP 5.7.2
[1mRRDtool[0m: 1.4.7
[0m
Starting polling run:
SQL[[0;33mSELECT `device_id` FROM `devices` WHERE `disabled` = 0 AND `device_id` = '3' ORDER BY `device_id` ASC[0m][0m
RUNTIME[[0;32m0.00072503s[0m][0m
SQL[[0;33mSELECT * FROM `devices` WHERE `device_id` = '3'[0m][0m
RUNTIME[[0;32m0.00026298s[0m][0m
SQL[[0;33mSELECT * FROM `devices_attribs` WHERE `device_id` = '3'[0m][0m
RUNTIME[[0;32m0.00026393s[0m][0m
SQL[[0;33mSELECT * FROM `alert_tests` WHERE 1[0m][0m
RUNTIME[[0;32m0.00021315s[0m][0m
Cached 6 alert rules.
SQL[[0;33mSELECT *,`alert_table`.`alert_table_id` AS `alert_table_id` FROM `alert_table` LEFT JOIN `alert_table-state` ON `alert_table`.`alert_table_id` = `alert_table-state`.`alert_table_id` WHERE `device_id` = '3'[0m][0m
RUNTIME[[0;32m0.00033498s[0m][0m
mon01.newrockit.com 3 linux (unix)
CMD[[0;33m/usr/bin/fping -t 500 -c 1 -q 127.0.1.1 2>&1[0m]
[0m
EXITCODE[[0;32m0[0m]
RUNTIME[[0;32m0.0087s[0m][0m
STDOUT[
127.0.1.1 : xmt/rcv/%loss = 1/1/0%, min/avg/max = 0.09/0.09/0.09
][0m
SQL[[0;33mSELECT `version` FROM `dbSchema`;[0m][0m
RUNTIME[[0;32m0.00025296s[0m][0m
CMD[[0;33m/usr/bin/snmpget -v2c -c *** -Pu -OQUst -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'mon01.newrockit.com':'161' sysObjectID.0 sysUpTime.0[0m]
[0m
EXITCODE[[0;32m0[0m]
RUNTIME[[0;32m0.0117s[0m][0m
STDOUT[
sysObjectID.0 = enterprises.8072.3.2.10
sysUpTime.0 = 17094738
][0m
SNMP_STATUS[[0;32mTRUE[0m][0m
RRD /opt/observium/rrd/mon01.newrockit.com/status.rrd already exists - no need to create.
RRD[cmd[[0;32mupdate /opt/observium/rrd/mon01.newrockit.com/status.rrd N:1[0m] [0m
stdout[[0;32mOK u:0.00 s:0.00 r:0.02[0m] [0m
stderr[[0;32m[0m]][0m
RRD /opt/observium/rrd/mon01.newrockit.com/ping.rrd already exists - no need to create.
RRD[cmd[[0;32mupdate /opt/observium/rrd/mon01.newrockit.com/ping.rrd N:0.09[0m] [0m
stdout[[0;32mOK u:0.00 s:0.00 r:0.02[0m] [0m
stderr[[0;32m[0m]][0m
RRD /opt/observium/rrd/mon01.newrockit.com/ping_snmp.rrd already exists - no need to create.
RRD[cmd[[0;32mupdate /opt/observium/rrd/mon01.newrockit.com/ping_snmp.rrd N:16.39[0m] [0m
stdout[[0;32mOK u:0.00 s:0.00 r:0.02[0m] [0m
stderr[[0;32m[0m]][0m
SQL[[0;33mSELECT * FROM `device_graphs` WHERE `device_id` = '3'[0m][0m
RUNTIME[[0;32m0.00239706s[0m][0m
including: includes/polling/unix-agent.inc.php
Observium UNIX Agent:
SQL[[0;33mSELECT attrib_value FROM devices_attribs WHERE `device_id` = '3' AND `attrib_type` = 'agent_port'[0m][0m
RUNTIME[[0;32m0.00039577s[0m][0m
execution time: 447msRRD /opt/observium/rrd/mon01.newrockit.com/agent.rrd already exists - no need to create.
RRD[cmd[[0;32mupdate /opt/observium/rrd/mon01.newrockit.com/agent.rrd N:447[0m] [0m
stdout[[0;32mOK u:0.00 s:0.00 r:0.50[0m] [0m
stderr[[0;32m[0m]][0m
Array
(
[] =>
[Observium] => Version: 1.0.1
AgentOS: linux
PluginsDirectory: /usr/lib/observium_agent/plugins
LocalDirectory: /usr/lib/observium_agent/local
AgentDirectory: /etc/observium
OnlyFrom: 127.0.0.1 104.236.178.104 ::1
[df] => /dev/vda1 ext4 20511356 5822808 13623592 30% /
udev devtmpfs 240048 4 240044 1% /dev
[mounts] => /dev/disk/by-label/DOROOT / ext4 rw,relatime,errors=remount-ro,data=ordered 0 0
[ps] => (root,33512,1284,0.0) /sbin/init
(root,0,0,0.0) [kthreadd]
(root,0,0,0.0) [ksoftirqd/0]
(root,0,0,0.0) [kworker/0:0H]
(root,0,0,0.2) [rcu_sched]
(root,0,0,0.2) [rcuos/0]
(root,0,0,0.0) [rcu_bh]
(root,0,0,0.0) [rcuob/0]
(root,0,0,0.0) [migration/0]
(root,0,0,0.0) [watchdog/0]
(root,0,0,0.0) [khelper]
(root,0,0,0.0) [kdevtmpfs]
(root,0,0,0.0) [netns]
(root,0,0,0.0) [writeback]
(root,0,0,0.0) [kintegrityd]
(root,0,0,0.0) [bioset]
(root,0,0,0.0) [kworker/u3:0]
(root,0,0,0.0) [kblockd]
(root,0,0,0.0) [ata_sff]
(root,0,0,0.0) [khubd]
(root,0,0,0.0) [md]
(root,0,0,0.0) [devfreq_wq]
(root,0,0,0.0) [kworker/0:1]
(root,0,0,0.0) [khungtaskd]
(root,0,0,0.0) [kswapd0]
(root,0,0,0.0) [ksmd]
(root,0,0,0.0) [fsnotify_mark]
(root,0,0,0.0) [ecryptfs-kthrea]
(root,0,0,0.0) [crypto]
(root,0,0,0.0) [kthrotld]
(root,0,0,0.0) [vballoon]
(root,0,0,0.0) [scsi_eh_0]
(root,0,0,0.0) [scsi_eh_1]
(root,0,0,0.0) [deferwq]
(root,0,0,0.0) [charger_manager]
(root,0,0,0.0) [kpsmoused]
(root,0,0,0.0) [jbd2/vda1-8]
(root,0,0,0.0) [ext4-rsv-conver]
(root,0,0,0.0) [kworker/0:2]
(root,19472,340,0.0) upstart-udev-bridge --daemon
(root,51232,376,0.0) /lib/systemd/systemd-udevd --daemon
(root,0,0,0.0) [ttm_swap]
(root,15256,136,0.0) upstart-socket-bridge --daemon
(root,0,0,0.0) [kvm-irqfd-clean]
(postfix,27404,1528,0.0) showq -t unix -u -c
(message+,39224,776,0.0) dbus-daemon --system --fork
(root,43448,924,0.0) /lib/systemd/systemd-logind
(syslog,256036,9292,0.0) rsyslogd
(root,15272,220,0.0) upstart-file-bridge --daemon
(root,15816,8,0.0) /sbin/getty -8 38400 tty4
(root,15816,8,0.0) /sbin/getty -8 38400 tty5
(root,15816,8,0.0) /sbin/getty -8 38400 tty2
(root,15816,8,0.0) /sbin/getty -8 38400 tty3
(root,15816,8,0.0) /sbin/getty -8 38400 tty6
(root,105632,4300,0.1) sshd: root@pts/0
(root,61364,336,0.0) /usr/sbin/sshd -D
(root,4364,4,0.0) acpid -c /etc/acpi/events -s /var/run/acpid.socket
(root,23652,256,0.0) cron
(daemon,19136,8,0.0) atd
(root,23248,4584,0.1) -bash
(root,25340,304,0.0) /usr/lib/postfix/master
(postfix,27568,244,0.0) qmgr -l -t unix -u
(snmp,45884,3112,0.2) /usr/sbin/snmpd -Lsd -Lf /dev/null -u snmp -p /var/run/snmpd.pid
(root,317484,1588,0.0) /usr/sbin/apache2 -k start
(root,265556,4572,0.0) /usr/bin/python /usr/bin/fail2ban-server -b -s /var/run/fail2ban/fail2ban.sock -p /var/run/fail2ban/fail2ban.pid
(root,15816,8,0.0) /sbin/getty -8 38400 tty1
(root,0,0,0.0) [kauditd]
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(root,0,0,0.0) [kworker/u3:1]
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,318060,9884,0.0) /usr/sbin/apache2 -k start
(root,0,0,0.0) [kworker/u2:1]
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(root,59636,1480,0.0) CRON
(root,4440,652,0.0) /bin/sh -c /opt/observium/poller-wrapper.py 20 >> /dev/null 2>&1
(root,739888,9820,0.3) python /opt/observium/poller-wrapper.py 20
(root,4440,648,0.0) /bin/sh -c /usr/bin/env php /opt/observium/poller.php -h 13 >> /dev/null 2>&1
(root,204280,18104,1.0) php /opt/observium/poller.php -h 13
(root,4440,652,0.0) sh -c /usr/bin/rrdtool -
(root,86440,2636,0.0) /usr/bin/rrdtool -
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(root,4440,652,0.0) sh -c /usr/bin/snmpbulkwalk -r '0' -v2c -c 'squareplanit_community'@1 -Pu -OqsX -m BRIDGE-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'sw01.squareplanit.net':'1612' dot1dTpFdbEntry 2>/dev/null
(root,19804,2548,0.0) /usr/bin/snmpbulkwalk -r 0 -v2c -c -Pu -OqsX -m BRIDGE-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp udp:sw01.squareplanit.net:1612 dot1dTpFdbEntry
(root,201320,16724,0.0) php ./poller.php -d -m unix-agent -h 3
(root,4440,652,0.0) sh -c /usr/bin/rrdtool -
(root,86440,2640,0.0) /usr/bin/rrdtool -
(root,17972,1552,0.0) /bin/bash /usr/bin/observium_agent
(root,15564,1124,0.0) ps ax -o user,vsz,rss,pcpu,command --columns 10000
(root,10976,844,0.0) sed -e 1d -e s/ ([^ ]) ([^ ]) ([^ ]) ([^ ]) */(\1,\2,\3,\4) /
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,320172,14500,0.0) /usr/sbin/apache2 -k start
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(root,0,0,0.0) [xfsalloc]
(root,0,0,0.0) [xfs_mru_cache]
(root,0,0,0.0) [xfslogd]
(root,0,0,0.0) [jfsIO]
(root,0,0,0.0) [jfsCommit]
(root,0,0,0.0) [jfsSync]
(root,0,0,0.0) [bioset]
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(postfix,27404,1532,0.0) pickup -l -t unix -u -c
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(root,14992,164,0.0) /usr/sbin/xinetd -dontfork -pidfile /var/run/xinetd.pid -stayalive -inetd_compat -inetd_ipv6
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,321436,16088,0.0) /usr/sbin/apache2 -k start
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,321436,15772,0.0) /usr/sbin/apache2 -k start
(www-data,321452,15824,0.0) /usr/sbin/apache2 -k start
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,321436,15788,0.0) /usr/sbin/apache2 -k start
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,321436,15760,0.0) /usr/sbin/apache2 -k start
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,320900,15352,0.0) /usr/sbin/apache2 -k start
(mysql,926556,33752,0.9) /usr/sbin/mysqld
(root,0,0,0.0) [kworker/u2:2]
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,321436,16140,0.0) /usr/sbin/apache2 -k start
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,321440,15744,0.0) /usr/sbin/apache2 -k start
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
(www-data,0,0,0.0) [sh] <defunct>
[mem] => MemTotal: 501800 kB
MemFree: 151284 kB
Buffers: 21500 kB
Cached: 113392 kB
SwapCached: 11096 kB
Active: 97952 kB
Inactive: 177268 kB
Active(anon): 23204 kB
Inactive(anon): 124344 kB
Active(file): 74748 kB
Inactive(file): 52924 kB
Unevictable: 0 kB
Mlocked: 0 kB
SwapTotal: 1048572 kB
SwapFree: 998496 kB
Dirty: 2584 kB
Writeback: 0 kB
AnonPages: 131832 kB
Mapped: 28368 kB
Shmem: 7220 kB
Slab: 45792 kB
SReclaimable: 27664 kB
SUnreclaim: 18128 kB
KernelStack: 3456 kB
PageTables: 8028 kB
NFS_Unstable: 0 kB
Bounce: 0 kB
WritebackTmp: 0 kB
CommitLimit: 1299472 kB
Committed_AS: 950216 kB
VmallocTotal: 34359738367 kB
VmallocUsed: 11056 kB
VmallocChunk: 34359720536 kB
HardwareCorrupted: 0 kB
AnonHugePages: 0 kB
HugePages_Total: 0
HugePages_Free: 0
HugePages_Rsvd: 0
HugePages_Surp: 0
Hugepagesize: 2048 kB
DirectMap4k: 331768 kB
DirectMap2M: 192512 kB
DirectMap1G: 0 kB
[cpu] => 0.74 0.98 0.92 1/430 4090 1
[uptime] => 170953.69 127247.40
[netif] => eth0 yes
[lnx_if:sep(58)] => eth0: 1563914364 6263251 0 0 0 0 0 0 1213512374 6376721 0 0 0 0 0 0
lo: 236127704 1427838 0 0 0 0 0 0 236127704 1427838 0 0 0 0 0 0
[eth0]
Link detected: yes
[lo]
Link detected: yes
[tcp_conn_stats] => ESTABLISHED 3
TIME_WAIT 4
[md] => Personalities :
unused devices: <none>
[diskstat] => 1436462558
253 0 vda 530962 47205 19012826 184160 3636696 1258748 64624024 31898556 0 1003032 32080780
[kernel] => 1436462558
nr_free_pages 37860
nr_alloc_batch 58
nr_inactive_anon 31086
nr_active_anon 5788
nr_inactive_file 13189
nr_active_file 18729
nr_unevictable 0
nr_mlock 0
nr_anon_pages 32938
nr_mapped 7072
nr_file_pages 36497
nr_dirty 646
nr_writeback 0
nr_slab_reclaimable 6916
nr_slab_unreclaimable 4532
nr_page_table_pages 2017
nr_kernel_stack 432
nr_unstable 0
nr_bounce 0
nr_vmscan_write 217881
nr_vmscan_immediate_reclaim 88834
nr_writeback_temp 0
nr_isolated_anon 0
nr_isolated_file 0
nr_shmem 1805
nr_dirtied 6767654
nr_written 6860430
numa_hit 1134266093
numa_miss 0
numa_foreign 0
numa_interleave 14855
numa_local 1134266093
numa_other 0
nr_anon_transparent_hugepages 0
nr_free_cma 0
nr_dirty_threshold 13650
nr_dirty_background_threshold 6825
pgpgin 9518061
pgpgout 32312012
pswpin 53348
pswpout 217385
pgalloc_dma 32858107
pgalloc_dma32 1108620900
pgalloc_normal 0
pgalloc_movable 0
pgfree 1141584313
pgactivate 1735530
pgdeactivate 3810875
pgfault 2961775741
pgmajfault 207807
pgrefill_dma 389674
pgrefill_dma32 4246120
pgrefill_normal 0
pgrefill_movable 0
pgsteal_kswapd_dma 63996
pgsteal_kswapd_dma32 2195060
pgsteal_kswapd_normal 0
pgsteal_kswapd_movable 0
pgsteal_direct_dma 6647
pgsteal_direct_dma32 775403
pgsteal_direct_normal 0
pgsteal_direct_movable 0
pgscan_kswapd_dma 76925
pgscan_kswapd_dma32 2612698
pgscan_kswapd_normal 0
pgscan_kswapd_movable 0
pgscan_direct_dma 9911
pgscan_direct_dma32 1010856
pgscan_direct_normal 0
pgscan_direct_movable 0
pgscan_direct_throttle 0
zone_reclaim_failed 0
pginodesteal 0
slabs_scanned 713216
kswapd_inodesteal 0
kswapd_low_wmark_hit_quickly 10166
kswapd_high_wmark_hit_quickly 298
pageoutrun 13825
allocstall 16398
pgrotated 223424
numa_pte_updates 0
numa_huge_pte_updates 0
numa_hint_faults 0
numa_hint_faults_local 0
numa_pages_migrated 0
pgmigrate_success 62547
pgmigrate_fail 10
compact_migrate_scanned 698505
compact_free_scanned 14532120
compact_isolated 145987
compact_stall 866
compact_fail 494
compact_success 372
htlb_buddy_alloc_success 0
htlb_buddy_alloc_fail 0
unevictable_pgs_culled 5360
unevictable_pgs_scanned 0
unevictable_pgs_rescued 5392
unevictable_pgs_mlocked 5392
unevictable_pgs_munlocked 5392
unevictable_pgs_cleared 0
unevictable_pgs_stranded 0
thp_fault_alloc 0
thp_fault_fallback 0
thp_collapse_alloc 0
thp_collapse_alloc_failed 0
thp_split 0
thp_zero_page_alloc 0
thp_zero_page_alloc_failed 0
nr_tlb_remote_flush 160
nr_tlb_remote_flush_received 234
nr_tlb_local_flush_all 46080898
nr_tlb_local_flush_one 247708794
cpu 2880832 2424 1275316 12653801 38322 16 20465 0 0 0
cpu0 2880832 2424 1275316 12653801 38322 16 20465 0 0 0
intr 42189407 15 10 0 0 0 0 2 0 1 0 0 0 146 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1144769 0 6037392 98 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
ctxt 122017934
btime 1436291604
processes 4158152
procs_running 1
procs_blocked 0
softirq 37322841 1 16018845 0 7465056 0 0 18 0 6995 13831926
[netctr] => 1436462558
eth0 1563914785 6263253 0 0 0 0 0 0 1213512568 6376723 0 0 0 0 0 0
lo 236133436 1427874 0 0 0 0 0 0 236133436 1427874 0 0 0 0 0 0
[postfix_mailq] => Mail queue is empty
[local] =>
[app] => Array
(
[apache] => 186408
592929792
.0770297
170947
1.09044
3468.5
3180.82
U
U
9
0
0
1
0
0
0
0
0
0
140
[mysql] => a0:65712
a1:1
a2:24139
a3:0
a4:-1
a5:-1
a6:-1
a7:-1
a8:-1
a9:-1
aa:-1
ab:-1
ac:-1
ad:-1
ae:-1
af:-1
ag:-1
ah:-1
ai:-1
aj:-1
ak:-1
al:-1
am:-1
an:-1
ao:-1
ap:-1
aq:-1
ar:-1
as:-1
at:-1
au:-1
av:-1
aw:-1
ax:-1
ay:-1
az:-1
b0:-1
b1:-1
b2:-1
b3:-1
b4:6
b5:5801992
b6:3
b7:48
b8:220
b9:786
ba:2000
bb:5000
bc:2000
bd:1
be:2
bf:26
bg:0
bh:6
bi:3
bj:18430
bk:1
bl:151
bm:8
bn:189379
bo:-1
bp:-1
bq:
br:-1
bs:0
bt:1
bu:16759680
bv:0
bw:0
bx:0
by:4348792
bz:0
c0:1
c1:16777216
c2:5786569
c3:974736
c4:77108
c5:4348792
c6:1442
c7:0
c8:0
c9:0
ca:0
cb:0
cc:0
cd:24
ce:0
cf:2089
cg:0
ch:323386
ci:0
cj:5366
ck:140680
cl:22450
cm:25631
cn:4208
co:6
cp:5482357040
cq:732275937
cr:8388608
cs:-1
ct:-1
cu:-1
cv:-1
cw:32768
cx:0
cy:0
cz:-1
d0:-1
d1:-1
d2:-1
d3:-1
d4:-1
d5:-1
d6:1
d7:-1
d8:-1
d9:-1
da:-1
db:-1
dc:-1
dd:-1
de:-1
df:-1
dg:2
dh:-1
di:4446083
dj:1442
dk:0
dl:0
dm:417400
dn:7193735
do:13512358
dp:467
dq:101941
dr:3793724
ds:0
dt:0
du:0
dv:974881
dw:2414948
dx:-1
dy:-1
dz:-1
e0:-1
e1:-1
e2:-1
e3:-1
e4:-1
e5:-1
e6:-1
e7:-1
e8:-1
e9:-1
ea:-1
eb:-1
ec:-1
ed:-1
ee:-1
ef:-1
eg:0
eh:3060736
ei:16777216
ej:0
ek:0
)
)
No include:
No include: Observium
No include: df
No include: mounts
No include: ps
No include: mem
No include: cpu
No include: uptime
No include: netif
No include: lnx_if:sep(58)
No include: tcp_conn_stats
No include: md
No include: diskstat
No include: kernel
No include: netctr
No include: postfix_mailq
No include: local
No include: app
SQL[[0;33mSELECT * FROM `applications` WHERE `device_id` = '3' AND `app_type` = 'apache'[0m][0m
RUNTIME[[0;32m0.00052905s[0m][0m
Including: applications/apache.inc.php
apacheRRD /opt/observium/rrd/mon01.newrockit.com/app-apache-1.rrd already exists - no need to create.
RRD[cmd[[0;32mupdate /opt/observium/rrd/mon01.newrockit.com/app-apache-1.rrd N:186408:592929792:.0770297:170947:1.09044:3468.5:3180.82:U:U:9:0:0:1:0:0:0:0:0:0:140[0m] [0m
stdout[[0;32mOK u:0.00 s:0.00 r:0.50[0m] [0m
stderr[[0;32m[0m]][0m
SQL[[0;33mSELECT * FROM `applications` WHERE `device_id` = '3' AND `app_type` = 'mysql'[0m][0m
RUNTIME[[0;32m0.00027418s[0m][0m
Including: applications/mysql.inc.php
mysqlRRD /opt/observium/rrd/mon01.newrockit.com/app-mysql-2.rrd already exists - no need to create.
RRD[cmd[[0;32mupdate /opt/observium/rrd/mon01.newrockit.com/app-mysql-2.rrd N:8388608:-1:-1:140680:5366:0:22450:-1:-1:-1:-1:-1:-1:-1:-1:-1:-1:-1:5801992:6:-1:-1:-1:-1:2000:48:220:786:-1:-1:-1:16777216:16759680:151:26:1:2:3:189379:-1:65712:1:24139:0:0:0:0:4348792:0:4208:25631:6:-1:-1:-1:-1:-1:-1:-1:-1:-1:-1:24:0:2089:0:323386:3:732275937:5482357040:1442:77108:0:0:0:0:4348792:974736:0[0m] [0m
stdout[[0;32mOK u:0.00 s:0.00 r:0.51[0m] [0m
stderr[[0;32m[0m]][0m
RRD /opt/observium/rrd/mon01.newrockit.com/app-mysql-2-status.rrd already exists - no need to create.
RRD[cmd[[0;32mupdate /opt/observium/rrd/mon01.newrockit.com/app-mysql-2-status.rrd N:-1:-1:-1:-1:1:-1:-1:-1:-1:-1:-1:-1:-1:-1:2:-1[0m] [0m
stdout[[0;32mOK u:0.00 s:0.00 r:0.51[0m] [0m
stderr[[0;32m[0m]][0m
Processes:
SQL[[0;33mSELECT COUNT FROM `applications` WHERE `device_id` = '3' AND `app_type` = 'apache'[0m][0m
RUNTIME[[0;32m0.00053787s[0m][0m
SQL[[0;33mSELECT COUNT FROM `applications` WHERE `device_id` = '3' AND `app_type` = 'mysql'[0m][0m
RUNTIME[[0;32m0.00025296s[0m][0m
Sensors:
SQL[[0;33mSELECT * FROM `sensors` WHERE `device_id` = '3' AND `sensor_class` = 'temperature' AND `poller_type` = 'agent'[0m][0m
RUNTIME[[0;32m0.00039196s[0m][0m
SQL[[0;33mSELECT * FROM `sensors` WHERE `device_id` = '3' AND `sensor_class` = 'humidity' AND `poller_type` = 'agent'[0m][0m
RUNTIME[[0;32m0.00021195s[0m][0m
SQL[[0;33mSELECT * FROM `sensors` WHERE `device_id` = '3' AND `sensor_class` = 'fanspeed' AND `poller_type` = 'agent'[0m][0m
RUNTIME[[0;32m0.00020003s[0m][0m
SQL[[0;33mSELECT * FROM `sensors` WHERE `device_id` = '3' AND `sensor_class` = 'airflow' AND `poller_type` = 'agent'[0m][0m
RUNTIME[[0;32m0.00020599s[0m][0m
SQL[[0;33mSELECT * FROM `sensors` WHERE `device_id` = '3' AND `sensor_class` = 'voltage' AND `poller_type` = 'agent'[0m][0m
RUNTIME[[0;32m0.00021005s[0m][0m
SQL[[0;33mSELECT * FROM `sensors` WHERE `device_id` = '3' AND `sensor_class` = 'current' AND `poller_type` = 'agent'[0m][0m
RUNTIME[[0;32m0.00019884s[0m][0m
SQL[[0;33mSELECT * FROM `sensors` WHERE `device_id` = '3' AND `sensor_class` = 'power' AND `poller_type` = 'agent'[0m][0m
RUNTIME[[0;32m0.00019693s[0m][0m
SQL[[0;33mSELECT * FROM `sensors` WHERE `device_id` = '3' AND `sensor_class` = 'apower' AND `poller_type` = 'agent'[0m][0m
RUNTIME[[0;32m0.00021410s[0m][0m
SQL[[0;33mSELECT * FROM `sensors` WHERE `device_id` = '3' AND `sensor_class` = 'impedance' AND `poller_type` = 'agent'[0m][0m
RUNTIME[[0;32m0.00021005s[0m][0m
SQL[[0;33mSELECT * FROM `sensors` WHERE `device_id` = '3' AND `sensor_class` = 'frequency' AND `poller_type` = 'agent'[0m][0m
RUNTIME[[0;32m0.00020099s[0m][0m
SQL[[0;33mSELECT * FROM `sensors` WHERE `device_id` = '3' AND `sensor_class` = 'dbm' AND `poller_type` = 'agent'[0m][0m
RUNTIME[[0;32m0.00046301s[0m][0m
SQL[[0;33mSELECT * FROM `sensors` WHERE `device_id` = '3' AND `sensor_class` = 'snr' AND `poller_type` = 'agent'[0m][0m
RUNTIME[[0;32m0.00027800s[0m][0m
SQL[[0;33mSELECT * FROM `sensors` WHERE `device_id` = '3' AND `sensor_class` = 'capacity' AND `poller_type` = 'agent'[0m][0m
RUNTIME[[0;32m0.00023985s[0m][0m
SQL[[0;33mSELECT * FROM `sensors` WHERE `device_id` = '3' AND `sensor_class` = 'load' AND `poller_type` = 'agent'[0m][0m
RUNTIME[[0;32m0.00022101s[0m][0m
SQL[[0;33mSELECT * FROM `sensors` WHERE `device_id` = '3' AND `sensor_class` = 'runtime' AND `poller_type` = 'agent'[0m][0m
RUNTIME[[0;32m0.00023103s[0m][0m
SQL[[0;33mSELECT * FROM `sensors` WHERE `device_id` = '3' AND `sensor_class` = 'state' AND `poller_type` = 'agent'[0m][0m
RUNTIME[[0;32m0.00149894s[0m][0m
Module [ unix-agent ] time: 0.5076s
including: includes/polling/system.inc.php
CMD[[0;33m/usr/bin/snmpget -v2c -c *** -Pu -OQUs -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'mon01.newrockit.com':'161' sysUpTime.0 sysLocation.0 sysContact.0 sysName.0[0m]
[0m
EXITCODE[[0;32m0[0m]
RUNTIME[[0;32m0.01s[0m][0m
STDOUT[
sysUpTime.0 = 1:23:29:07.92
sysLocation.0 = Digital Ocean, FRA1, Frankfurt, Germany
sysContact.0 = Me <josh@newrockit.com>
sysName.0 = mon01.newrockit.com
][0m
SNMP_STATUS[[0;32mTRUE[0m][0m
CMD[[0;33m/usr/bin/snmpget -v2c -c *** -Pu -Oqv -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'mon01.newrockit.com':'161' sysDescr.0[0m]
[0m
EXITCODE[[0;32m0[0m]
RUNTIME[[0;32m0.0137s[0m][0m
STDOUT[
Linux mon01.newrockit.com 3.13.0-43-generic #72-Ubuntu SMP Mon Dec 8 19:35:06 UTC 2014 x86_64
][0m
SNMP_STATUS[[0;32mTRUE[0m][0m
CMD[[0;33m/usr/bin/snmpget -v2c -c *** -Pu -Oqvn -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'mon01.newrockit.com':'161' sysObjectID.0[0m]
[0m
EXITCODE[[0;32m0[0m]
RUNTIME[[0;32m0.007s[0m][0m
STDOUT[
.1.3.6.1.4.1.8072.3.2.10
][0m
SNMP_STATUS[[0;32mTRUE[0m][0m
CMD[[0;33m/usr/bin/snmpget -v2c -c *** -Pu -Ovqn -m SNMP-FRAMEWORK-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'mon01.newrockit.com':'161' snmpEngineID.0[0m]
[0m
EXITCODE[[0;32m0[0m]
RUNTIME[[0;32m0.0063s[0m][0m
STDOUT[
"80 00 1F 88 80 CA 2E 15 43 7C 6D 49 55 00 00 00
00 "
][0m
SNMP_STATUS[[0;32mTRUE[0m][0m
Using UNIX Agent Uptime (170954 sec. => 1 day, 23h 29m 14s)
RRD /opt/observium/rrd/mon01.newrockit.com/uptime.rrd already exists - no need to create.
RRD[cmd[[0;32mupdate /opt/observium/rrd/mon01.newrockit.com/uptime.rrd N:170954[0m] [0m
stdout[[0;32mOK u:0.00 s:0.00 r:0.59[0m] [0m
stderr[[0;32m[0m]][0m
Uptime: 1 day, 23h 29m 14s
Array
(
[sysUpTime] => 170947
[unix-agent] => 170954
[use] => unix-agent
[message] => Using UNIX Agent Uptime
[uptime] => 170954
[formatted] => 1 day, 23h 29m 14s
[previous] => 170920
[diff] => -34
[rebooted] => 0
)
SQL[[0;33mSELECT * FROM `devices_locations` WHERE `device_id` = '3'[0m][0m
RUNTIME[[0;32m0.00047112s[0m][0m
Module [ system ] time: 0.046s
including: includes/polling/os.inc.php
SQL[[0;33mSELECT * FROM `entPhysical` WHERE `device_id` = '3' AND `entPhysicalContainedIn` = '0'[0m][0m
RUNTIME[[0;32m0.00028300s[0m][0m
CMD[[0;33m/usr/bin/snmpget -v2c -c *** -Pu -Oqv -m MIB-Dell-10892 -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/dell 'udp':'mon01.newrockit.com':'161' chassisModelName.1[0m]
[0m
EXITCODE[[0;32m0[0m]
RUNTIME[[0;32m0.0226s[0m][0m
STDOUT[
No Such Object available on this agent at this OID
][0m
SNMP_STATUS[[0;31mFALSE[0m][0m
CMD[[0;33m/usr/bin/snmpget -v2c -c *** -Pu -Oqv -m CPQSINFO-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/hp 'udp':'mon01.newrockit.com':'161' cpqSiProductName.0[0m]
[0m
EXITCODE[[0;32m0[0m]
RUNTIME[[0;32m0.0145s[0m][0m
STDOUT[
No Such Object available on this agent at this OID
][0m
SNMP_STATUS[[0;31mFALSE[0m][0m
CMD[[0;33m/usr/bin/snmpget -v2c -c *** -Pu -Oqv -m UCD-SNMP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'mon01.newrockit.com':'161' .1.3.6.1.4.1.2021.7890.1.3.1.1.6.100.105.115.116.114.111[0m]
[0m
EXITCODE[[0;32m0[0m]
RUNTIME[[0;32m0.2125s[0m][0m
STDOUT[
"Linux|3.13.0-43-generic|amd64|Ubuntu|14.04"
][0m
SNMP_STATUS[[0;32mTRUE[0m][0m
Hardware: Generic x86 [64bit] Version: 3.13.0-43-generic Features: Ubuntu 14.04 Serial: Asset:
Module [ os ] time: 0.2562s
Graphs [checked]: ping, ping_snmp, agent, uptime
Polled in 0.8564 seconds
Updating mon01.newrockit.com - Array
(
[uptime] => 170954
[last_polled] => Array
(
[0] => NOW()
)
[last_polled_timetaken] => 0.8564
[device_state] => a:1:{s:15:"poller_mod_perf";a:3:{s:10:"unix-agent";s:6:"0.5076";s:6:"system";s:6:"0.0460";s:2:"os";s:6:"0.2562";}}
)
SQL[[0;33mUPDATE `devices` set `uptime` ='170954',`last_polled` =NOW(),`last_polled_timetaken` ='0.8564',`device_state` ='a:1:{s:15:\"poller_mod_perf\";a:3:{s:10:\"unix-agent\";s:6:\"0.5076\";s:6:\"system\";s:6:\"0.0460\";s:2:\"os\";s:6:\"0.2562\";}}' WHERE `device_id` = '3'[0m][0m
RUNTIME[[0;32m0.00187683s[0m][0m
UPDATED!
Checking alerts
Array
(
[device_status] => 1
[device_status_type] =>
[device_ping] => 0.09
[device_snmp] => 16.39
[device_uptime] => 170920
[device_rebooted] => 0
[device_duration_poll] => 3.87
)
Checking alert 2 associated by 2
Testing: device_status equals 0 (value: 1) OK Checks OK.
SQL[[0;33mUPDATE `alert_table-state` set `state` ='{\"metrics\":{\"device_status\":\"1\"}}',`count` ='0',`alert_status` ='1',`last_message` ='Checks OK',`last_checked` ='1436462559' WHERE `alert_table_id` = '1'[0m][0m
RUNTIME[[0;32m0.00014710s[0m][0m
RRD /opt/observium/rrd/mon01.newrockit.com/alert-1.rrd already exists - no need to create.
RRD[cmd[[0;32mupdate /opt/observium/rrd/mon01.newrockit.com/alert-1.rrd N:1:1[0m] [0m
stdout[[0;32mOK u:0.00 s:0.00 r:0.85[0m] [0m
stderr[[0;32m[0m]][0m
Checking alert 5 associated by 5
Testing: device_rebooted equals 1 (value: 0) OK Checks OK.
SQL[[0;33mUPDATE `alert_table-state` set `state` ='{\"metrics\":{\"device_rebooted\":0}}',`count` ='0',`alert_status` ='1',`last_message` ='Checks OK',`last_checked` ='1436462559' WHERE `alert_table_id` = '35'[0m][0m
RUNTIME[[0;32m0.00014305s[0m][0m
RRD /opt/observium/rrd/mon01.newrockit.com/alert-35.rrd already exists - no need to create.
RRD[cmd[[0;32mupdate /opt/observium/rrd/mon01.newrockit.com/alert-35.rrd N:1:1[0m] [0m
stdout[[0;32mOK u:0.00 s:0.00 r:0.85[0m] [0m
stderr[[0;32m[0m]][0m
SQL[[0;33mINSERT INTO `perf_times` (`type`,`doing`,`start`,`duration`,`devices`) VALUES ('poll','3','1436462558.1452','0.969','1')[0m][0m
RUNTIME[[0;32m0.00148487s[0m][0m
./poller.php: mon01.newrockit.com - 1 devices polled in 0.969 secs
NOTE, $config['snmp']['hide_auth'] is set to TRUE, snmp community and snmp v3 auth hidden from debug output.
Memory usage: 5.5MB (peak: 5.5MB)
MySQL: Cell[4/0s] Row[6/0.01s] Rows[21/0.02s] Column[0/0s] Update[3/0s] Insert[1/0s] Delete[0/0s]
"my tables" means all except observium? (observium already use innodb).
Attach debug output:
./poller.php -d -m unix-agent -h <this_device>
|
I'm test with mysql 5.6, all works as should (also unix-gent)..
$ ./discovery.php -VV
Observium 0.15.7.6613
Software versions:
OS: Linux 3.13.0-49-generic [amd64] (Ubuntu 12.04)
PHP: 5.3.27-1ubuntu3.6
Python: Python 2.7.3
MySQL: 5.6.24-2+deb.sury.org~precise+2 (extension: mysqli 5.6.24)
SNMP: NET-SNMP 5.4.3
RRDtool: 1.4.7