Graphing showing NAN values. 0.8.7h

[l33byt]

Hello,

I have had a working Cacti for around a few weeks, the database is large and I have around 9000 graphs.
For some reason last week I had a couple of issues, first with SPINE, it was timing out after 200 seconds, this was due to a host where by some one had used an SNMP time out of 1000000 seconds, also an access list had been applied to the device locking out my cacti server.

Spine is now sorted and I would like to show you my logic of thought.

-Firstly, if I add a new host and new graphs using the same template as my other graphs it begins to read and graph correctly.
-My Spine poller is running as per below.

SPINE: Using spine config file [/etc/cacti/spine.conf]
SPINE: Version 0.8.7e starting
SPINE: Time: 3.7266 s, Threads: 20, Hosts: 127

My Datasource debug for a non working graph

Data Source Debug

/usr/bin/rrdtool create \
/var/lib/cacti/rra/108/7443.rrd \
--step 30 \
DS:traffic_in:COUNTER:60:0:10000000 \
DS:traffic_out:COUNTER:60:0:10000000 \
RRA:AVERAGE:0.5:1:600 \
RRA:AVERAGE:0.5:6:700 \
RRA:AVERAGE:0.5:24:775 \
RRA:AVERAGE:0.5:288:797 \
RRA:MAX:0.5:1:600 \
RRA:MAX:0.5:6:700 \
RRA:MAX:0.5:24:775 \
RRA:MAX:0.5:288:797 \

And a working graph

/usr/bin/rrdtool create \
/var/lib/cacti/rra/132/8522.rrd \
--step 300 \
DS:traffic_in:COUNTER:600:0:100000000 \
DS:traffic_out:COUNTER:600:0:100000000 \
RRA:AVERAGE:0.5:1:600 \
RRA:AVERAGE:0.5:6:700 \
RRA:AVERAGE:0.5:24:775 \
RRA:AVERAGE:0.5:288:797 \
RRA:MAX:0.5:1:600 \
RRA:MAX:0.5:6:700 \
RRA:MAX:0.5:24:775 \
RRA:MAX:0.5:288:797 \

I believe there is an issue with the template, however if I make a change to the template for example graph colour, purely for the reasoning of re-applying the template to the entire database I still get the issue.

The other weird thing is if I was to run real time the graph does actually work.

Could any one offer any ideas to resolve

[l33byt]

Ok it appears it is the template.
I now have an issue that all my graphs show no template name.

Is there a way I can bulk update my graphs to use the template other wise 10000 graphs may see me busy for a little while.

Cancel that - I have re-applied the template it seems only the host I have added after the rest of the graphs stopped working is graphing correctly.

This is so strange, If I debug the poller information is coming though.

04/16/2012 10:45:03 AM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /var/lib/cacti/rra/109/7465.rrd --template traffic_out:traffic_in 1334569502:2256460082:2515287367
04/16/2012 10:45:03 AM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /var/lib/cacti/rra/109/7466.rrd --template traffic_out:traffic_in 1334569502:2233092957:2363596756
04/16/2012 10:45:03 AM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /var/lib/cacti/rra/109/7467.rrd --template traffic_out:traffic_in 1334569502:2946069562:2774605033
04/16/2012 10:45:03 AM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /var/lib/cacti/rra/109/7468.rrd --template traffic_out:traffic_in 1334569502:1231095821:1399498958
04/16/2012 10:45:03 AM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /var/lib/cacti/rra/109/7469.rrd --template traffic_out:traffic_in 1334569502:3085678203:2273875668
04/16/2012 10:45:03 AM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /var/lib/cacti/rra/109/7470.rrd --template traffic_out:traffic_in 1334569502:3935632427:19651237
04/16/2012 10:45:03 AM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /var/lib/cacti/rra/109/7471.rrd --template traffic_out:traffic_in 1334569502:2782167073:2933540962
04/16/2012 10:45:03 AM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /var/lib/cacti/rra/109/7472.rrd --template traffic_out:traffic_in 1334569502:1931657727:2144508859
04/16/2012 10:45:03 AM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /var/lib/cacti/rra/109/7473.rrd --template traffic_out:traffic_in 1334569502:1838779795:4101045096
04/16/2012 10:45:03 AM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /var/lib/cacti/rra/109/7474.rrd --template traffic_out:traffic_in 1334569502:3345684129:4140536797

It simply isn't graphing.

[gandalf]

Please see 2nd link of my sig for basic debugging help
R.