Issues creating RRD's for Filesystems

[Caliban]

Ok this has me stumped and I haven't found anything in the forum thats helped. We have 2 cacti setups.. one is corporate wide one department wide.. the department wide isn't having any issues but the corporate wide one for some reason has decided to stop creating new RRD's for filesystems. When you try and create one this shows up in the log file:
03/07/2006 03:04:49 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_item (local_data_id,host_id,action,hostname, snmp_community,snmp_version,snmp_timeout,snmp_username,snmp_password,snmp_port,rrd_name,rrd_path, rrd_num,arg1,arg2,arg3) values (3944,292,2,'172.18.128.41', 'bursnmp','1','500', '','','161', 'hdd_total','/var/www/html/cacti/rra/coloindexera_hdd_total_3944.rrd', '3','/var/www/html/cacti/scripts/ss_host_disk.php ss_host_disk 172.18.128.41 292 1:161:500:bursnmp:::MD5::[None] get total 13','','')"
Or this for a windows box:
03/07/2006 03:00:04 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_item (local_data_id,host_id,action,hostname, snmp_community,snmp_version,snmp_timeout,snmp_username,snmp_password,snmp_port,rrd_name,rrd_path, rrd_num,arg1,arg2,arg3) values (3928,286,2,'12.10.4.15', 'public','1','500', '','','161', 'hdd_total','/var/www/html/cacti/rra/lucy_hdd_total_3928.rrd', '3','/var/www/html/cacti/scripts/ss_host_disk.php ss_host_disk 12.10.4.15 286 1:161:500:public:::MD5::[None] get total 1','','')"

For a respective look at the data sources:
/usr/bin/rrdtool create \
/var/www/html/cacti/rra/coloindexera_hdd_total_3935.rrd \
--step 300 \
DS:hdd_total:GAUGE:600:0:1000000000000 \
DS:hdd_used:GAUGE:600:0:U \
DS:hdd_total:GAUGE:600:0:U \
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: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 \

/usr/bin/rrdtool create \
/var/www/html/cacti/rra/lucy_hdd_total_3928.rrd \
--step 300 \
DS:hdd_total:GAUGE:600:0:U \
DS:hdd_used:GAUGE:600:0:U \
DS:hdd_total:GAUGE:600:0:1000000000000 \
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: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 \

And the graph Debug:
/usr/bin/rrdtool graph - \
--imgformat=PNG \
--start=-86400 \
--end=-300 \
--title="ColoIndexer-A - Used Space - /" \
--rigid \
--base=1024 \
--height=120 \
--width=500 \
--alt-autoscale-max \
--lower-limit=0 \
--vertical-label="bytes" \
--slope-mode \
--font TITLE:10:/usr/share/rrdtool/fonts/DejaVuSansMono-Roman.ttf \
--font AXIS:6:/usr/share/rrdtool/fonts/DejaVuSansMono-Roman.ttf \
--font LEGEND:8:/usr/share/rrdtool/fonts/DejaVuSansMono-Roman.ttf \
--font UNIT:6:/usr/share/rrdtool/fonts/DejaVuSansMono-Roman.ttf \
DEF:a="/var/www/html/cacti/rra/coloindexera_hdd_total_3935.rrd":hdd_total:AVERAGE \
DEF:b="/var/www/html/cacti/rra/coloindexera_hdd_total_3935.rrd":hdd_used:AVERAGE \
AREA:a#002A97:"Total" \
GPRINTLAST:"Current\:%8.2lf %s" \
GPRINTAVERAGE:"Average\:%8.2lf %s" \
GPRINTMAX:"Maximum\:%8.2lf %s\n" \
AREA:b#F51D30:"Used" \
GPRINTLAST:" Current\:%8.2lf %s" \
GPRINTAVERAGE:"Average\:%8.2lf %s" \
GPRINTMAX:"Maximum\:%8.2lf %s\n"

RRDTool Says:

ERROR: opening '/var/www/html/cacti/rra/coloindexera_hdd_total_3935.rrd': No such file or directory

/usr/bin/rrdtool graph - \
--imgformat=PNG \
--start=-86400 \
--end=-300 \
--title="Lucy - Used Space - C: Label: Seri" \
--rigid \
--base=1024 \
--height=120 \
--width=500 \
--alt-autoscale-max \
--lower-limit=0 \
--vertical-label="bytes" \
--slope-mode \
--font TITLE:10:/usr/share/rrdtool/fonts/DejaVuSansMono-Roman.ttf \
--font AXIS:6:/usr/share/rrdtool/fonts/DejaVuSansMono-Roman.ttf \
--font LEGEND:8:/usr/share/rrdtool/fonts/DejaVuSansMono-Roman.ttf \
--font UNIT:6:/usr/share/rrdtool/fonts/DejaVuSansMono-Roman.ttf \
DEF:a="/var/www/html/cacti/rra/lucy_hdd_total_3928.rrd":hdd_total:AVERAGE \
DEF:b="/var/www/html/cacti/rra/lucy_hdd_total_3928.rrd":hdd_used:AVERAGE \
AREA:a#002A97:"Total" \
GPRINTLAST:"Current\:%8.2lf %s" \
GPRINTAVERAGE:"Average\:%8.2lf %s" \
GPRINTMAX:"Maximum\:%8.2lf %s\n" \
AREA:b#F51D30:"Used" \
GPRINTLAST:" Current\:%8.2lf %s" \
GPRINTAVERAGE:"Average\:%8.2lf %s" \
GPRINTMAX:"Maximum\:%8.2lf %s\n"

RRDTool Says:

ERROR: opening '/var/www/html/cacti/rra/lucy_hdd_total_3928.rrd': No such file or directory

As far as I can tell this only affects filesystem graph creations.. once the graph is created its populated fine as the other that are already there are going fine.. and other types aren't affected like CPU and NIC traffic.

The only difference between the two is it looks like someone imported a template that changed around some graph templates IE Host MIB - Available Disk Space is gone and now ucd 90 Filesystems is in its place. Unfortunately I don't know how to undo this.
Any ideas guys? Beside finding a yard stick long enough to rap the knuckles the next time some guy tries to upload an untried template?

[Caliban]

*tries his best Ben Stine impression*
Anyone... anyone?

[rony]

Export that template from the working system and import into the non-working system.

[Caliban]

Thansk Rony, we actually dug through the database and corrected it only to have it break on the next template that was imported so reverted back to a month old backup and built it back up .. lessoned learned
1. Test Templates first
2. Backup Often

[TheWitness]

Sounds like a reasonable practice.

TheWitness