polling performance problem

chadd · Posted: Mon Aug 29, 2005 8:02 am Post subject:

Sorry it took me so long to get back to you. In reply to your question about "mix of data sources", I did the following:

select action from poller_item;

and got:

6581 rows in set (0.05 sec) - all 0's.

In responce to your second question about invalid host id's, I am not sure. I don't know how to tell if they are valid or not. I did the following query in mysql:

mysql> select host_id, id from poller_reindex, host;

and have attached the results to this response in a .txt file.

I ran Cactid on it's own and this is what I have (version is rc3

:

-su-2.05b# /usr/local/cactid/bin/cactid
CACTID: Version 0.8.6f-rc3 starting
Segmentation fault (core dumped)

Again, any help would be appretiated. I really want to get Cactid working soon.

TheWitness · Posted: Mon Aug 29, 2005 6:57 pm Post subject:

I should be posting rc8 before too long. Unfortunately, I am tracking a segfault in Win32 that may have something to do with Cygwin at the moment.

Larry

chadd · Posted: Tue Aug 30, 2005 7:38 am Post subject:

Thank you for working on this. I really apretiate it. At currently all of my graphs have stopped updating, and the cmd.php poller does not seem to work either. I would like to ask you one thing before I wipe out my database and start over (because I really don't want that to be the fix - going forward). Is there a method to check for no longer valid stuff in the database, which you have stated cacti can not deal with? I think it would be much easier to write a script to delete stuff from the database that is causing problems, then to wipe out the database and re-add 150+ devices. Thanks again for all your help.

TheWitness · Posted: Tue Aug 30, 2005 2:46 pm Post subject:

I would consider an after hours consultation before wiping out a database of 150+ devices. You have my MSIM and AIM information look me up. SSH or RDP are all possible.

TheWitness

TheWitness · Posted: Tue Aug 30, 2005 6:18 pm Post subject:

Got your e-mail. Waiting on a call. I can only do this after hours.

Larry

aecon · Joined: 24 Mar 2005 Posts: 4

Greetings
I am also using the latest versions of [patched]cacti/cactid.I run it on a linux server :
2.6.13 Kernel
2 Gigs Ram
P4 3G Cpu

I get emails with the following content
----------------------------------------------------------
/bin/sh: line 1: 4678 Segmentation fault php
/somewhere/in/the/filesystem/poller.php
----------------------------------------------------------

The previous week i updated the kernel from 2.6.12.x to 2.6.13. Cacti was already running and creating graphs without any problems.For some weird reason after the kernel update, cacti stopped polling even if crond was running. I run the poller manually for a couple of times
and it started working again. Does anyone have any clues?

I believe that this post is rellevant with the thread.
Any help would be appreciated.

TheWitness · Posted: Mon Sep 05, 2005 8:55 pm Post subject:

Looks as though php is segfaulting.

Larry

chadd · Posted: Tue Sep 06, 2005 8:09 am Post subject:

First of all, big thanks to Larry for all his help. Second, I am still not able to use Cactid, it seems to segfault, and I don't know why - I will wait on the next release before trying again. I have however, by following a suggestion Larry made, lowered my polling times, and drastically reduced the load on my machine. The suggestion was, to install php_snmp, to increase performance of the cmd.php poller. I did this, and it made all the difference. So, moral of this post, is if anyone is still using cmd.php - make sure you have php_snmp installed!! See the attached .png for your proof (ignore the empty space at the beginning - it was when I was trying to get Cactid to work

). Thanks again Larry, and I will be eagerly awaiting the next release of Cactid, as I continue to add devices to Cacti!!!

-chadd.