Re: [cacti-user] Graphs have stopped

Your problem is caused by the poller_output table getting too big for cacti's poller to read into memory.

There are two things you should do to fix this:

1) Increate the maximum memory that PHP can utilize.  If you make it as high as a Gig (assuming you have that much in reserve), you may be able to get your data back.  You make this change in php.ini.  No reboot required, simply make the change between polls.

2) If that does not work, then you will loose the historical data, but you can get your polling running again.  You have two options:

a) Enter into mysql console and use the following command: "truncate table poller_output;".  This way you loose historical data (since updating stopped)
b) Modify <path_cacti>/lib/poller.php to place a LIMIT statement on the selects from poller_output table.  If you set it the LIMIT to 15000, you should be able to get your data back as well.

I hope this helps.

Regards,

Larry Adams
Cacti Developer
The Cacti Group
 -------------- Original message ----------------------
From: Paul Boven <p....@sa...>
> Hi again Will, everyone,
> 
> Will McDonald wrote:
> 
> >> The graphs are still there and properly visible trough the website, they
> >> just don't get any new data added even though the poller still runs and
> >> is able to retrieve SNMP data according to the poller log.
> > 
> > Weird. Have you tried strace-ing the poller process to see if it can
> > do everything it's meant to be doing?
> 
> No, I'll give that a try - though it seems already that it never does 
> call rrdtool, but it does a lot of sql queries of course, and those 
> work. But I never see any calls to rrdtool in the cacti log from before 
> the problems.
> 
> > Have any permissions changed on the directories your RRDs live in? On
> > my Cacti system /var/www/cacti/log and /var/www/cacti/rra are both
> > owned by cacti:cacti. Assuming your poller's running out of
> > /etc/cron.d/cacti as follows...
> > 
> > */5 * * * *     cacti   php /var/www/cacti/poller.php &>/dev/null
> > 
> > It's running as cacti and would (presumably) need write permissions to
> > the logs and the RRDs.
> 
> Exactly the same here: log and rra are owned by cacti:cacti, and so are 
> the rra's. The logfile still gets updated. A file permission problem 
> would have shown up in te cacti-logs, I'd hope.
> 
> Is there any way I can increase the verbosity of a manually started 
> poller run, when the logging in the web interface is already set to 'DEBUG'?
> 
> $ php poller.php
> Content-type: text/html
> X-Powered-By: PHP/4.3.9
> 
> 06/27/2006 12:06:51 PM - POLLER: Poller[0] DEBUG: About to Spawn a 
> Remote Process [CMD: /usr/bin/php, ARGS: -q /var/www/cacti/cmd.php 0 34]
> Waiting on 1/1 pollers.
> 
> (and that's all)
> 
> Regards, Paul Boven.
> 
> 
> Using Tomcat but need to do more? Need to support web services, security?
> Get stuff done quickly with pre-integrated technology to make your job easier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> cacti-user mailing list
> cac...@li...
> https://lists.sourceforge.net/lists/listinfo/cacti-user