Graphs not updated since outage /new graph not being created

[Schnark]

Hi guys,

We had an outage to our Windows Cacti server the other week and since then we've had issues with some graphs not getting any new data in it (reports -1.#J rather than any data). Additionally, on several nodes, the new RRD's will not be created automatically, but on others, new graphs are being created fine.

I've tried the following however happy to try again:
- delete the graphs that weren't working
- trying to duplicate the graphs
- deleting the node completely and re-adding it (node is showing as SNMP up)
- check that SNMP is set correctly (confirmed - the non-interface graphs are working fine)
- restarted the server hosting Cacti / MySQL
- checked for NTFS perm issues (looks fine but will have a look at the process monitor troubleshooting thread tomorrow)
- reviewed the Windows event logs - nothing obvious
- created the graph manually for the graphs that didn't created - this worked fine but still getting the -1.#J error

Grateful any advice / suggestions on how to troubleshoot / fix

Config details are as follows:
- v0.8.7.e
- Windows 2003 / IIS
- Net-SNMP 5.4.2.1
- RRDTool ver 1.2.30
- poller type -spine

[Schnark]

Info on a graph that was previously working but is not now:

RRDTool Command:

D:/rrdtool/rrdtool.exe graph - \
--imgformat=PNG \
--start=-86400 \
--end=-300 \
--title="<device> - Traffic - <link> - Link to <remote site> at-<interface>" \
--rigid \
--base=1000 \
--height=120 \
--width=500 \
--alt-autoscale \
--vertical-label="bits per second" \
--slope-mode \
--font TITLE:12: \
--font AXIS:8: \
--font LEGEND:10: \
--font UNIT:8: \
DEF:a="D\:/Inetpub/Wwwroot/Cacti/rra/87/27572.rrd":traffic_in:AVERAGE \
DEF:b="D\:/Inetpub/Wwwroot/Cacti/rra/87/27572.rrd":traffic_out:AVERAGE \
CDEF:cdefa=a,8,* \
CDEF:cdeff=b,8,* \
AREA:cdefa#00CF0019:"" \
LINE1:cdefa#00CF00FF:"Inbound" \
GPRINT:cdefa:LAST:" Current\:%8.2lf %s" \
GPRINT:cdefa:AVERAGE:"Average\:%8.2lf %s" \
GPRINT:cdefa:MAX:"Maximum\:%8.2lf %s\n" \
AREA:cdeff#002A9719:"" \
LINE1:cdeff#002A97FF:"Outbound" \
GPRINT:cdeff:LAST:"Current\:%8.2lf %s" \
GPRINT:cdeff:AVERAGE:"Average\:%8.2lf %s" \
GPRINT:cdeff:MAX:"Maximum\:%8.2lf %s\n"

RRDTool Says:

OK


Info on a new graph that won't create:

D:/rrdtool/rrdtool.exe graph - \
--imgformat=PNG \
--start=-86400 \
--end=-300 \
--title="<device> - Traffic - <interface> - Link to <device> <interface>" \
--rigid \
--base=1000 \
--height=120 \
--width=500 \
--alt-autoscale \
--vertical-label="bits per second" \
--slope-mode \
--font TITLE:12: \
--font AXIS:8: \
--font LEGEND:10: \
--font UNIT:8: \
DEF:a="D\:/Inetpub/Wwwroot/Cacti/rra/2246/30676.rrd":traffic_in:AVERAGE \
DEF:b="D\:/Inetpub/Wwwroot/Cacti/rra/2246/30676.rrd":traffic_out:AVERAGE \
CDEF:cdefa=a,8,* \
CDEF:cdeff=b,8,* \
AREA:cdefa#00CF0019:"" \
LINE1:cdefa#00CF00FF:"Inbound" \
GPRINT:cdefa:LAST:" Current\:%8.2lf %s" \
GPRINT:cdefa:AVERAGE:"Average\:%8.2lf %s" \
GPRINT:cdefa:MAX:"Maximum\:%8.2lf %s\n" \
AREA:cdeff#002A9719:"" \
LINE1:cdeff#002A97FF:"Outbound" \
GPRINT:cdeff:LAST:"Current\:%8.2lf %s" \
GPRINT:cdeff:AVERAGE:"Average\:%8.2lf %s" \
GPRINT:cdeff:MAX:"Maximum\:%8.2lf %s\n"
RRDTool Says:

ERROR: opening 'D:/Inetpub/Wwwroot/Cacti/rra/2246/30676.rrd': No such file or directory


I'll do a debug poll and see what happens, but I note that the later entry isn't added into the poller cache.

[noname]

In the device settings, what do you see when clicked "(Verbose Query)" at "SNMP - Interface Statistics"?

Additionally, please post the output when clicked "Turn On Data Source Debug Mode" at the datasource which has problems.