RRDTool error

[benhanson]

So I have a handfull of devices for which rrd files aren't created. I ran the poller from the command line and saw:

ERROR: failed to parse data source 120:0:
ERROR: opening 'C:\Inetpub\cactiRoot\rra\dell_5224_2_traffic_in_457.rrd': No such file or directory

repeated for each interface of each device with no graphs. I turned on poller debug info and found the following in the log

c:/rrdtool/rrdtool.exe create C:/Inetpub/cactiRoot/rra/dell_5324_rack_traffic_in_457.rrd --step 60 DS:traffic_in:COUNTER:120:0: 1000000000 DS:traffic_out:COUNTER:120:0: 1000000000 RRA:AVERAGE:0.5:1:500 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:MIN:0.5:1:600 RRA:MIN:0.5:6:700 RRA:MIN:0.5:24:775 RRA:MIN:0.5:288:797 RRA:MAX:0.5:1:500 RRA:MAX:0.5:1:600 RRA:MAX:0.5:6:700 RRA:MAX:0.5:24:775 RRA:MAX:0.5:288:797 RRA:LAST:0.5:1:600 RRA:LAST:0.5:6:700 RRA:LAST:0.5:24:775 RRA:LAST:0.5:288:797

Noticing the space after COUNTER:120:0:, I tried running this command manually with the space removed and it was able to create the rrd files.

Any ideas what file I need to be patching to resolve this? I checked snmp.php and it looks good as far as I can tell.

Cacti: 8.7e
Spine: 8.7e
Windows 2003 SP2
1.79Ghz Xeon, 2.00GB RAM
MySQL: Ver 14.12 Distrib 5.0.37, for Win32 (ia32)
RRDTool: 1.2.26
CYGWIN1.dll v1.5.25-cr-0x5f1
Net-SNMP: 5.4

[BSOD2600]

You sure those broken data sources are not a carry over from cacti 0.8.7d? The spaces was an issue back then and was fixed.

[benhanson]

That is definitely a possibility, I created a new device today, had the problem, updated to 8.7e and then started troubleshooting. Does the 8.7d bug result in bad data in MySQL? I suppose if I delete the device and re-add it the problem will go away, correct?

[BSOD2600]

Does the 8.7d bug result in bad data in MySQL? I suppose if I delete the device and re-add it the problem will go away, correct?

yes, it does stay in mysql.

Deleting the data source, running a reindex on that device's snmp data query and then having cacti create it again should fix it. otherwise, you can manually remove the space in the data source too.

[benhanson]

Thanks for the input, I removed the leading space from the Maximum Value fields of the data sources involved, removed graphs and rrds and confirmed cacti was then able to create the rrds without error. Thanks again.

In case anyone else is curious, as far as I can tell the Maximum Value field that had the bad data in it is in the data_template_rrd table. If you sort by rrd_maximum you can see all of the rows with a preceding space rise to the top:

Using MySQL Query Browser:
SELECT * FROM cacti.data_template_rrd d order by rrd_maximum

[TheWitness]

This was a bug in 0.8.7d's lib/snmp.php. The correction came in 0.8.7e.

TheWitness