rrd contains NaN

[madsn]

Hi there

I have recently moved my rrd files from a 32 bit CentOS system to a new 64 bit system. In doing so I followed this guide:
http://slog.carlheaton.co.uk/index.php/ ... itectures/
After installing cacti on the new machine and transfering the rrd files and database to it, the graphs were looking fine, but my problem is that new data is not stored in the files, or it might be stored but it is not usefull. If I put the cacti log on DEBUG I can see that the data collected from the devices is looking fine. (see below)

Code: Select all

04/05/2011 03:50:07 PM - CMDPHP: Poller[0] Host[13] DS[704] SNMP: v2: XXX.XXX.XXX.12, dsname: int_status, oid: .1.3.6.1.2.1.2.2.1.8.10124, output: 2  
04/05/2011 03:50:07 PM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /var/www/html/cacti/rra/my_sw1_int_status_523.rrd --template int_status N:1 

If I export the the graphs to CSV I get NaN for all entries.

I first thought the reason would have something to do with restrictions on the rrd files but I have tried with chmod 777 and this didn't help. Any ideas of what is going wrong?

Code: Select all

Title:,"'MY-SW1 - Status - Gi0/1 - Timeserver'"
Vertical Label:,"'status'"
Start Date:,"2011-04-04 15:55:00"
End Date:,"2011-04-05 15:55:00"
Step:,"300"
Total Rows:,"289"
Graph ID:,"519"
Host ID:,"9"

Date,"Current status"
2011-04-04 15:55:00,"NaN"
2011-04-04 16:00:00,"NaN"
2011-04-04 16:05:00,"NaN"
2011-04-04 16:10:00,"NaN"
2011-04-04 16:15:00,"NaN"
2011-04-04 16:20:00,"NaN"
2011-04-04 16:25:00,"NaN"
2011-04-04 16:30:00,"NaN"
2011-04-04 16:35:00,"NaN"
2011-04-04 16:40:00,"NaN"
2011-04-04 16:45:00,"NaN"
2011-04-04 16:50:00,"NaN"
2011-04-04 16:55:00,"NaN"
2011-04-04 17:00:00,"NaN"

I use CentOS 5.5 64bit, cacti 0.8.7g

[madsn]

Ok have gotten a bit further in my investigation. After looking at gandalfs Official Debugging Help
http://docs.cacti.net/manual:087:4_help ... #debugging
it occured to me that it might have something to do with the database and because I have installed my cacti installation in another folder on the new installation, the table named poller_item which I have transffered from the old one had a wrong entry. More specific the field rra_path was set to /var/www/html/cacti/rra/some_file and the new installation is at /var/www/cacti/some_file. I updated this with the following command in case anybody is interested:

Code: Select all

UPDATE poller_item
SET rrd_path=(
REPLACE (rrd_path,
"/var/www/html/",
"/var/www/"))

Maybe it would be an indea to use the <path_cacti> in this field in some future release. Despite my efforts it is still nor working

[madsn]

Okay I was too fast, it actually did help, but bacause I wasn't patient enough I tried pushing the rebuild poller cache button and the following happend.

Code: Select all

04/05/2011 04:35:07 PM - SYSTEM STATS: Time:5.3580 Method:cmd.php Processes:1 Threads:N/A Hosts:9 HostsPerProcess:9 DataSources:855 RRDsProcessed:435 

04/05/2011 04:30:09 PM - SYSTEM STATS: Time:7.4710 Method:cmd.php Processes:1 Threads:N/A Hosts:9 HostsPerProcess:9 DataSources:1275 RRDsProcessed:855  

Why are the numbers of DataSources and RRDsProccessed decreasing ? What does it exactly mean to rebuild the poller cache?

[madsn]

Okay if I use my database backup and then press "rebuild poller cache" entrys are deleted from the poller item table this is the reason why I went from 1275 to 855. This brings me back to, what does it actually mean to rebuild the poller cache?

[madsn]

Hi again okay by examining the the source files I found out that the data in the table poller_item is based on the entries in the data_local table and this is actually where my problem lies. Is there a way to recreate these data directly from the rrd files?

[gandalf]

Hi again okay by examining the the source files I found out that the data in the table poller_item is based on the entries in the data_local table and this is actually where my problem lies. Is there a way to recreate these data directly from the rrd files?

Unfortunately not. At least nothing, that is supported or available in any way.
R.