New graphs with same template no longer work

[tl1997]

Hello fellow Cacti users,

For some reason, all of the sudden, any new graphs I create using the same template I've been using for the last year or two, don't work, with rrdtool failing to be able to produce a graph. However, existing graphs that were created awhile ago using the same template still work just fine, and continue to be updated. The template is In/Out Bits 95th percentile with 64-bit counters.

I'm not very well versed in rrdtool (which is why I installed cacti in the first place ) Does anyone have any ideas on what I should check? Here's the debug output from one of the failing graphs:

RRDTool Command:
/usr/local/bin/rrdtool graph - \
--imgformat=PNG \
--start=-86400 \
--end=-300 \
--title="Orovitz 12k - Traffic" \
--rigid \
--base=1000 \
--height=120 \
--width=500 \
--alt-autoscale-max \
--lower-limit=0 \
--vertical-label="bits per second" \
--slope-mode \
--font TITLE:12: \
--font AXIS:8: \
--font LEGEND:10: \
--font UNIT:8: \
DEF:a="/usr/local/share/cacti/rra/orovitz_12k_traffic_in_2121.rrd":traffic_in:AVERAGE \
DEF:b="/usr/local/share/cacti/rra/orovitz_12k_traffic_in_2121.rrd":traffic_in:LAST \
DEF:c="/usr/local/share/cacti/rra/orovitz_12k_traffic_in_2121.rrd":traffic_in:MIN \
DEF:d="/usr/local/share/cacti/rra/orovitz_12k_traffic_in_2121.rrd":traffic_in:MAX \
DEF:e="/usr/local/share/cacti/rra/orovitz_12k_traffic_in_2121.rrd":traffic_out:AVERAGE \
DEF:f="/usr/local/share/cacti/rra/orovitz_12k_traffic_in_2121.rrd":traffic_out:LAST \
DEF:g="/usr/local/share/cacti/rra/orovitz_12k_traffic_in_2121.rrd":traffic_out:MIN \
DEF:h="/usr/local/share/cacti/rra/orovitz_12k_traffic_in_2121.rrd":traffic_out:MAX \
CDEF:cdefa=a,8,* \
CDEF:cdefb=b,8,* \
CDEF:cdefd=d,8,* \
CDEF:cdefh=e,8,* \
CDEF:cdefi=f,8,* \
CDEF:cdefba=h,8,* \
CDEF:cdefbb=a,UN,INF,UNKN,IF \
CDEF:cdefbg=TIME,1226519973,GT,a,a,UN,0,a,IF,IF,TIME,1226519973,GT,e,e,UN,0,e,IF,IF,+ \
AREA:cdefa#157419FF:"In" \
GPRINT:cdefb:LAST:" Cur\:%8.2lf %s" \
GPRINT:cdefa:AVERAGE:"Av\:%8.2lf %s" \
GPRINT:cdefd:MAX:"Max\:%8.2lf %s" \
COMMENT:"Transfer\: 2.71 MB" \
HRULE:|95\:bits\:0\:current|#00FF00FF:"95%\:" \
COMMENT:"|95\:bits\:6\:current| mbit\n" \
LINE1:cdefh#002A8FFF:"Out" \
GPRINT:cdefi:LAST:"Cur\:%8.2lf %s" \
GPRINT:cdefh:AVERAGE:"Av\:%8.2lf %s" \
GPRINT:cdefba:MAX:"Max\:%8.2lf %s" \
AREA:cdefbb#8F9286FF:"" \
COMMENT:"Transfer\: 2.69 MB" \
HRULE:|95\:bits\:0\:current|#0000FFFF:"95%\:" \
COMMENT:"|95\:bits\:6\:current| mbit\n" \
COMMENT:"\n" \
HRULE:143998.74#FF0000FF:"Total 95%\:" \
COMMENT:"0.14 mbit" \
COMMENT:"Total Transfer\: 5.4 MB\n"
RRDTool Says:

The part after "RRDTool Says" is completely blank, I didn't truncate the post. Again, other templates work, and even the same template works for graphs that were created awhile back.

Here's the output from a working graph of the same template. Towards the end of the rrd command, its quite different. Is my template somehow corrupt? If the template somehow changes, does it only affect new graphs and not old ones? Working graph of (supposedly) same template:

RRDTool Command:
/usr/local/bin/rrdtool graph - \
--imgformat=PNG \
--start=-86400 \
--end=-300 \
--title="Pentland Core - Traffic - To-Pentland-10k - Te7/4" \
--rigid \
--base=1000 \
--height=120 \
--width=500 \
--alt-autoscale-max \
--lower-limit=0 \
--vertical-label="bits per second" \
--slope-mode \
--font TITLE:12: \
--font AXIS:8: \
--font LEGEND:10: \
--font UNIT:8: \
DEF:a="/usr/local/share/cacti/rra/pentland_core_traffic_in_1339.rrd":traffic_in:AVERAGE \
DEF:b="/usr/local/share/cacti/rra/pentland_core_traffic_in_1339.rrd":traffic_in:LAST \
DEF:c="/usr/local/share/cacti/rra/pentland_core_traffic_in_1339.rrd":traffic_in:MIN \
DEF:d="/usr/local/share/cacti/rra/pentland_core_traffic_in_1339.rrd":traffic_in:MAX \
DEF:e="/usr/local/share/cacti/rra/pentland_core_traffic_in_1339.rrd":traffic_out:AVERAGE \
DEF:f="/usr/local/share/cacti/rra/pentland_core_traffic_in_1339.rrd":traffic_out:LAST \
DEF:g="/usr/local/share/cacti/rra/pentland_core_traffic_in_1339.rrd":traffic_out:MIN \
DEF:h="/usr/local/share/cacti/rra/pentland_core_traffic_in_1339.rrd":traffic_out:MAX \
CDEF:cdefa=a,8,* \
CDEF:cdefb=b,8,* \
CDEF:cdefd=d,8,* \
CDEF:cdefe=e,8,* \
CDEF:cdeff=f,8,* \
CDEF:cdefh=h,8,* \
AREA:cdefa#00CF00FF:"Inbound" \
GPRINT:cdefb:LAST:" Current\:%8.2lf %s" \
GPRINT:cdefa:AVERAGE:"Average\:%8.2lf %s" \
GPRINT:cdefd:MAX:"Maximum\:%8.2lf %s\n" \
LINE1:cdefe#002A97FF:"Outbound" \
GPRINT:cdeff:LAST:"Current\:%8.2lf %s" \
GPRINT:cdefe:AVERAGE:"Average\:%8.2lf %s" \
GPRINT:cdefh:MAX:"Maximum\:%8.2lf %s\n" \
COMMENT:"\n" \
HRULE:2667.75#FF0000FF:"95th Percentile" \
COMMENT:"(0 mbit in+out)"
RRDTool Says:
OK

Any suggestions would be greatly appreciated.

My system:

[gandalf]

The HRULE statement is broken. It prints the plain text instead of calculating a number as required. Strange and unknown behaviour, especially because its working on the second graph
Reinhard

[tl1997]

Thanks...I did reach the conclusion that after the graph is made, the template doesn't matter. It appears that some how my template got messed up, maybe during an import or something.

Can anyone export a "fresh" Interface - Traffic (bits/sec, 95th Percentile) graph template and post it here? I figure if I can delete and re-add a clean one, I should be able to create new graphs again.

[gandalf]

Please create a second db, let's call it "cactibkup". Then import cacti.sql into it. Point your config.php to that db and export the template from cactibkip.
Then, point config.php back to your cacti db and import.
That's how you can do it on your own
Reinhard