NAN appearing in Graphs

bjwizard · Post by **bjwizard** » Tue Jan 18, 2005 7:01 pm

I'm running FREEBSD 0.8.6B version of cacti, and for no apparent reason on Tuesday at 12:40am in the monring my graphs stopped being generated and I have NAN for all my graphs.

I went to check the logfile and it would not display through cacit, and a couple of menu items from console would disappear.

Viewed it at console level and there didn't seem to be any problems. Moved the file to cacti.log.old and then I was able to view the file through cacti.... though still no graphs.

Ran /usr/local/bin/php /usr/local/share/cacti/cmd.php from console and it ran perfectly yet the graphs are still not updated.

Any ideas...

Cheers

Post by **TheWitness** » Tue Jan 18, 2005 7:13 pm

Did you run out of disk space and corrupt your RRD files?

TheWitness

bjwizard · Post by **bjwizard** » Tue Jan 18, 2005 7:26 pm

No, I didn't run out of disk space as I have 96gig free. all other mysql apps are running perfectly only cacti for some reason died.

Post by **TheWitness** » Tue Jan 18, 2005 8:38 pm

Check your poller_output table for the number of records. If this is 0.8.6b, you need to upgrade to 0.8.6c. There is a bug in 0.8.6b that causes the poller to crash and RRD files not to be updated when a host is rebooted.

TheWitness

bjwizard · Post by **bjwizard** » Tue Jan 18, 2005 8:54 pm

I ran the following through phpmyAdmin

SELECT count( * )
FROM poller_output

and was returned this

count(*)
73618

I'm not willing to update just yet to 0.8.6c as it has not be ported to freebsd as far as I can tell.

Are there some other options

Post by **TheWitness** » Tue Jan 18, 2005 8:59 pm

There are a series of files that you can simply apply to correct this problem. It is the only fix for now. Goto the following web site and download either the patches or the actual files.

http://www.cacti.net/download_patches.p ... ion=0.8.6b

or for the files:

http://www.cacti.net/downloads/patches/ ... re-patched

TheWitness

p.s. There are no database changes between versions, so you don't need an RPM or the equivalent.[/b]

Post by **TheWitness** » Tue Jan 18, 2005 9:01 pm

Also, you may have to truncate your poller_output table unless you are willing to wait a few polling cycles to catch up. Once corrected, you may get a few messages indicating that the poller timed out as it catches up.

TheWitness

bjwizard · Post by **bjwizard** » Tue Jan 18, 2005 9:32 pm

Ok I took the plunge and upgraded form the website to 0.86c. Ran
/usr/local/bin/php /usr/local/share/cacti/cmd.php four times

Yet I'm still getting NAN on all my graphs

pls note i'm using cmd.php not poller.php

Post by **TheWitness** » Tue Jan 18, 2005 9:33 pm

You must run poller.php to update the rrd files. Please run poller.php a few times to get this thing cleared up.

TheWitness

bjwizard · Post by **bjwizard** » Tue Jan 18, 2005 9:41 pm

When i run poller i receive the following

/usr/local/bin/php /usr/local/share/cacti/poller.php

01/19/2005 01:39:52 PM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Process [CMD: /usr/local/bin/php, ARGS: -q /usr/local/share/cacti/cmd.php 0 13]
Waiting on 1/1 pollers.
cat: /proc/meminfo: No such file or directory
cat: /proc/meminfo: No such file or directory

Thoughts?

Post by **rony** » Tue Jan 18, 2005 9:55 pm

The "/proc/meminfo" is related to the localhost "Linux Memory" script. Since you are running freebsd, that error is normal.

bjwizard · Post by **bjwizard** » Tue Jan 18, 2005 10:01 pm

The graphs are still coming up nan

I created a new device and the graphs are not coming up all they are staying as just links.

Post by **rony** » Tue Jan 18, 2005 10:07 pm

Are you running the poller on a 5 minute interval from cron?

Graphs typically do not appear until at least one polling cycle and data until 2 polling cycles.

If you ran the poller manually as root, don't forget to check that the permissions of the rra and files located in it can be modifed and created by the user running the poller.php from cron.

bjwizard · Post by **bjwizard** » Tue Jan 18, 2005 10:37 pm

I modified the cron on updating the version of cacti. I also set the permisisons at the same time. Cron runs as the SU of the system. The rra folder and log file were set with the following cmd

chown -R cactiuser log && chown -R cactiuser rra

any other ideas

bjwizard · Post by **bjwizard** » Tue Jan 18, 2005 10:39 pm

if you like we can do this via MSN, AOL or SKYPE (txt, or voice)

Cacti

NAN appearing in Graphs

NAN appearing in Graphs

Who is online