Hi Guys,
We are having the same broken graph issue again
I do not know why it shows the light red color. I can ping the device from Observium just fine.
I am seeing the following from the db.log
[2016/03/28 11:30:03 +0800] poller.php(1148): Failed dbQuery (#2006 - MySQL server has gone away), Query: INSERT INTO `snmp_errors` (`device_id`,`error_count`,`error_code`,`error_reason`,`snmp_cmd_exitcode`,`snmp_cmd`,`snmp_options`,`mib`,`mib_dir`,`oid`,`added`,`updated`) VALUES ('3','1','1002','Request timeout','1','snmpget','-OUQnv','','','.1.3.6.1.2.1.25.3.3.1.2.6','1459135803','1459135803') [2016/03/28 11:30:03 +0800] poller.php(1148): Failed dbQuery (#2006 - MySQL server has gone away), Query: UPDATE `processors-state` set `processor_usage` ='0',`processor_polled` ='1459135803' WHERE `processor_id` = '18' [2016/03/28 11:30:03 +0800] poller.php(9834): Failed dbQuery (#2006 - MySQL server has gone away), Query: SELECT * FROM `snmp_errors` WHERE `device_id` = '7' AND `error_code` = '1002' AND `snmp_cmd` = 'snmpget' AND `snmp_options` = '-Oqv' AND `mib` = 'HOST-RESOURCES-MIB' AND `oid` = 'hrSystemUptime.0';
I do not know why it says Mysql server has gone away as the process is running
[root@mrtg2 logs]# /etc/init.d/mysqld status mysqld (pid 11072) is running... [root@mrtg2 logs]# ps aux | grep mysqld root 10962 0.0 0.0 106064 1496 pts/0 S 11:28 0:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --socket=/var/lib/mysql/mysql.sock --pid-file=/var/run/mysqld/mysqld.pid --basedir=/usr --user=mysql mysql 11072 1.1 0.5 2877776 40632 pts/0 Sl 11:28 0:02 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --log-error=/var/log/mysqld.log --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/lib/mysql/mysql.sock root 14263 0.0 0.0 103308 916 pts/0 S+ 11:31 0:00 grep mysqld
Any tips?
Thanks!
Regards, Edy
On 3/23/2016 9:58 AM, Spencer Ryan wrote:
One of our instances polls just over 200 devices (mostly in the same site) with 16 workers and completes in normally around 80 seconds.
[2016/03/22 21:56:28 -0400] poller-wrapper.py(21016): /opt/observium/poller-wrapper.py: polled 202 devices in 86 seconds with 16 workers
The VM runs on a Pure Storage SSD array though. Maybe try turning your pollers down? In the logs folder obvervium.log should tell you how long it's taking to poll all your devices, what do those average?
Spencer Ryan* | Senior Systems Administrator | sryan@arbor.net mailto:sryan@arbor.net *Arbor Networks* +1.734.794.5033 (d) | +1.734.846.2053 (m) www.arbornetworks.com http://www.arbornetworks.com/
On Tue, Mar 22, 2016 at 9:53 PM, Adam Armstrong <adama@memetic.org mailto:adama@memetic.org> wrote:
Are you sure having 24 threads is a good idea? Gaps like these are usually caused by network issues, or poller processes getting stacked up and interfering with one another. You can try using the new 'experimental' ports poller mode : $config['enable_ports_separate_walk'] = 1; You'll be able to see on the poller information screen if it's had a positive/negative effect. adam.On 23/03/2016 01:50:43, Pui Edylie <email@edylie.net <mailto:email@edylie.net>> wrote: 33 */6 * * * root /opt/observium/discovery.php -h all >> /dev/null 2>&1 */5 * * * * root /opt/observium/discovery.php -h new >> /dev/null 2>&1 */5 * * * * root /opt/observium/poller-wrapper.py 24 >> /dev/null 2>&1 On 3/23/2016 9:46 AM, Adam Armstrong wrote:show me : cat /etc/cron.d/observium adam.On 23/03/2016 01:37:31, Pui Edylie <email@edylie.net> <mailto:email@edylie.net> wrote: Dear Members, We are running latest commercial version and currently we have about 260 devices with 24 probers. We are getting graph that is breaking up but the link is ok. Anyone has any idea? Thanks! Regards, Edy_______________________________________________ observium mailing list observium@observium.org <mailto:observium@observium.org> http://postman.memetic.org/cgi-bin/mailman/listinfo/observium_______________________________________________ observium mailing list observium@observium.org <mailto:observium@observium.org> http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
