Aggregate graph not working "The RRD file does not exist"

[mohamedbahaa]

Hi All ,

I appreciate to receive your valuable comments & recommendations about the problem i faced with aggregate graphs:

[*] i installed CactiEZ package V0.7; which includes cacti Version 0.8.8a

[*] Aggregate plugin V1.01 is installed (all detailed info about cacti are listed in attached file)

in short the problem is that : when i create an aggregate graph withou adding Total function; every thing is fine & graph is normally.

when i try to add a total function aside the existing elements in graph i find the graph get lost & shows: "The RRD file doesn't exist"

the graph in both cases is attached also.

i'll be so glad if i could overcome that problem.

BR
Bahaa

[mohamedbahaa]

any body an help please ?

[mohamedbahaa]

no one can suggest a solution ?!

[gandalf]

Please find the aggregate graph under "Graph Management" and select it. Switch to debug and post output
R.

[mohamedbahaa]

Sorry for delay:


RRDTool Command:

/usr/bin/rrdtool graph - \
--imgformat=PNG \
--start=-86400 \
--end=-60 \
--title='Aggregate - Traffic - IGW - Total' \
--rigid \
--base=1000 \
--height=200 \
--width=800 \
--alt-autoscale-max \
--lower-limit='0' \
--vertical-label='bits per second' \
--slope-mode \
--font TITLE:10: \
--font AXIS:8: \
--font LEGEND:8: \
--font UNIT:8: \
DEF:a="/var/www/html/rra/rms-npe1_traffic_in_16232.rrd":'traffic_in':AVERAGE \
DEF:b="/var/www/html/rra/rms-npe1_traffic_in_16232.rrd":'traffic_out':AVERAGE \
DEF:c="/var/www/html/rra/rms-npe2_traffic_in_12874.rrd":'traffic_in':AVERAGE \
DEF:d="/var/www/html/rra/rms-npe2_traffic_in_12874.rrd":'traffic_out':AVERAGE \
DEF:e="/var/www/html/rra/uto-npe1_traffic_in_11364.rrd":'traffic_in':AVERAGE \
DEF:f="/var/www/html/rra/uto-npe1_traffic_in_11364.rrd":'traffic_out':AVERAGE \
DEF:g="/var/www/html/rra/uto-npe2_traffic_in_12127.rrd":'traffic_in':AVERAGE \
DEF:h="/var/www/html/rra/uto-npe2_traffic_in_12127.rrd":'traffic_out':AVERAGE \
CDEF:cdefa='a,0,*' \
CDEF:cdefc='b,0,*' \
CDEF:cdefg='c,0,*' \
CDEF:cdefi='d,0,*' \
CDEF:cdefbc='e,0,*' \
CDEF:cdefbe='f,0,*' \
CDEF:cdefbi='g,0,*' \
CDEF:cdefca='h,0,*' \
CDEF:cdefce='TIME,1377569188,GT,a,a,UN,0,a,IF,IF,TIME,1377569188,GT,c,c,UN,0,c,IF,IF,TIME,1377569188,GT,e,e,UN,0,e,IF,IF,TIME,1377569188,GT,g,g,UN,0,g,IF,IF,+,+,+,8,*' \
CDEF:cdefci='TIME,1377569188,GT,b,b,UN,0,b,IF,IF,TIME,1377569188,GT,d,d,UN,0,d,IF,IF,TIME,1377569188,GT,f,f,UN,0,f,IF,IF,TIME,1377569188,GT,h,h,UN,0,h,IF,IF,+,+,+,8,*' \
--watermark "Created using CactiEZ" \
AREA:cdefa#00CF0033:"" \
LINE1:cdefa#00CF00FF:"" \
LINE1:cdefc#002A97FF:"" \
AREA:cdefc#002A9733:"" \
LINE1:cdefa#000000FF:"" \
LINE1:cdefc#000000FF:"" \
AREA:cdefg#00CF0033:"" \
LINE1:cdefg#00CF00FF:"" \
LINE1:cdefi#002A97FF:"" \
AREA:cdefi#002A9733:"" \
LINE1:cdefg#000000FF:"" \
LINE1:cdefi#000000FF:"" \
AREA:cdefbc#00CF0033:"" \
LINE1:cdefbc#00CF00FF:"" \
LINE1:cdefbe#002A97FF:"" \
AREA:cdefbe#002A9733:"" \
LINE1:cdefbc#000000FF:"" \
LINE1:cdefbe#000000FF:"" \
AREA:cdefbi#00CF0033:"" \
LINE1:cdefbi#00CF00FF:"" \
LINE1:cdefca#002A97FF:"" \
AREA:cdefca#002A9733:"" \
LINE1:cdefbi#000000FF:"" \
LINE1:cdefca#000000FF:"" \
AREA:cdefce#00CF0033:"Total Inbound" \
GPRINT:cdefce:LAST:" Current\:%8.2lf %s" \
GPRINT:cdefce:AVERAGE:"Average\:%8.2lf %s" \
GPRINT:cdefce:MAX:"Maximum\:%8.2lf %s\n" \
LINE1:cdefci#002A97FF:"Total Outbound" \
AREA:cdefci#002A9733:"" \
GPRINT:cdefci:AVERAGE:" Average\:%8.2lf %s" \
GPRINT:cdefci:MAX:"Maximum\:%8.2lf %s\n"

RRDTool Says:

OK

[gandalf]

But there's no error as described in your first post ...
R.

[zubkoff]

I have the same issue with aggregate graph (Looks like cacti version is the same)

/usr/bin/rrdtool graph - \
--imgformat=PNG \
--start=1384161002 \
--end=1384247402 \
--title='Aggregate 20G - Traffic' \
--rigid \
--base=1000 \
--height=120 \
--width=700 \
--alt-autoscale-max \
--lower-limit='0' \
COMMENT:"From 2013/11/11 11\:10\:02 To 2013/11/12 11\:10\:02\c" \
COMMENT:" \n" \
--vertical-label='bits per second' \
--slope-mode \
--font TITLE:10: \
--font AXIS:8: \
--font LEGEND:8: \
--font UNIT:8: \
DEF:a='/var/www/html/rra/sw_x650_traffic_in_278.rrd':'traffic_in':AVERAGE \
DEF:b='/var/www/html/rra/sw_x650_traffic_in_278.rrd':'traffic_out':AVERAGE \
DEF:c='/var/www/html/rra/sw_x650_traffic_in_279.rrd':'traffic_in':AVERAGE \
DEF:d='/var/www/html/rra/sw_x650_traffic_in_279.rrd':'traffic_out':AVERAGE \
CDEF:cdefa='a,0,*' \
CDEF:cdefc='b,0,*' \
CDEF:cdefe='c,0,*' \
CDEF:cdefg='d,0,*' \
CDEF:cdefi='TIME,1384247882,GT,a,a,UN,0,a,IF,IF,TIME,1384247882,GT,c,c,UN,0,c,IF,IF,+,8,*' \
CDEF:cdefbd='TIME,1384247882,GT,b,b,UN,0,b,IF,IF,TIME,1384247882,GT,d,d,UN,0,d,IF,IF,+,8,*' \
CDEF:cdefbi='TIME,1384247882,GT,a,a,UN,0,a,IF,IF,TIME,1384247882,GT,b,b,UN,0,b,IF,IF,TIME,1384247882,GT,c,c,UN,0,c,IF,IF,TIME,1384247882,GT,d,d,UN,0,d,IF,IF,+,+,+,8640,*' \
--watermark "MyNetwork" \
AREA:cdefa#00CF0033:'' \
LINE1:cdefa#00CF00FF:'' \
AREA:cdefc#002A9733:'' \
LINE1:cdefc#002A97FF:'' \
AREA:cdefe#00CF0033:'' \
LINE1:cdefe#00CF00FF:'' \
AREA:cdefg#002A9733:'' \
LINE1:cdefg#002A97FF:'' \
AREA:cdefi#00CF0033:'' \
LINE1:cdefi#00CF00FF:'Total Inbound' \
GPRINT:cdefi:LAST:' Current\:%8.2lf %s' \
GPRINT:cdefi:AVERAGE:'Average\:%8.2lf %s' \
GPRINT:cdefi:MAX:'Maximum\:%8.2lf %s\n' \
AREA:cdefbd#002A9733:'' \
LINE1:cdefbd#002A97FF:'Total Outbound' \
GPRINT:cdefbd:LAST:'Current\:%8.2lf %s' \
GPRINT:cdefbd:AVERAGE:'Average\:%8.2lf %s' \
GPRINT:cdefbd:MAX:'Maximum\:%8.2lf %s\n' \
GPRINT:cdefbi:AVERAGE:'Total Summary Traffic\:%8.2lf %s\n'

And then Picture with "RRD file does not exists"

Aggregate logging does not print something wrong
Could you please help me with troubleshooting ? Thank You.

[zubkoff]

Downgrade aggregate plugin from v1.01 to v0.75 and everything works fine

[fastbob]

You're right, totalling does work correctly in 0.75. The interest of the new version is to be able to associate/disassociate data sources dynamically with existing graphs instead of having to recreate the graphs. When you have upwards of 50 data sources in one graph with adds and deletes almost every week as i have, version 0.75 is just to much of a headache to go back to.

Graph debug reports no error, as others have already stated. Only message is RDD does not exist where the graph should be.

A pity.

debug in 0.75
RRDTool Command:
/usr/bin/rrdtool graph - \
--imgformat=PNG \
--start=-86400 \
--end=-300 \
--title='Aggregate' \
--rigid \
--x-grid MINUTE:60:HOUR:2:HOUR:2:0:%k \
--grid-dash 1:2 \
--color MGRID#FF0000DD --color GRID#11111188 \
--base=1000 \
--height=120 \
--width=600 \
--upper-limit='16000000' \
--lower-limit='-16000000' \
--vertical-label='bits per second' \
--slope-mode \
--font TITLE:9:'DejaVu Sans Mono Book' \
--font AXIS:8:'DejaVu Sans Mono ' \
--font LEGEND:8:'DejaVu Sans Mono' \
--font UNIT:8:'DejaVu Sans Mono oblique' \
DEF:a="/var/www/html/cacti/rra/bahia_ima_ng_traffic_in_5528.rrd":'traffic_in':AVERAGE \
DEF:b="/var/www/html/cacti/rra/bahia_ima_ng_traffic_in_5528.rrd":'traffic_out':AVERAGE \
DEF:c="/var/www/html/cacti/rra/anira_sa_beccar523_traffic_in_9402.rrd":'traffic_in':AVERAGE \
DEF:d="/var/www/html/cacti/rra/anira_sa_beccar523_traffic_in_9402.rrd":'traffic_out':AVERAGE \
CDEF:cdefa='a,8,*' \
CDEF:cdefe='b,8,*,-1,*' \
CDEF:cdeff='b,8,*' \
CDEF:cdefi='c,8,*' \
CDEF:cdefbc='d,8,*,-1,*' \
CDEF:cdefbd='d,8,*' \
CDEF:cdefbg='TIME,1385994839,GT,a,a,UN,0,a,IF,IF,TIME,1385994839,GT,c,c,UN,0,c,IF,IF,+,8,*' \
CDEF:cdefca='TIME,1385994839,GT,b,b,UN,0,b,IF,IF,TIME,1385994839,GT,d,d,UN,0,d,IF,IF,+,8,*,-1,*' \
CDEF:cdefcb='TIME,1385994839,GT,b,b,UN,0,b,IF,IF,TIME,1385994839,GT,d,d,UN,0,d,IF,IF,+,8,*' \
--watermark "Brought to you by xxx" \
--color FONT#001D61 \
--color ARROW#FF3932 \
AREA:cdefa#00FF0099:"ANIRA SA Bahia_IMA Inbound" \
GPRINT:cdefa:LAST:" Current\:%8.2lf %s" \
GPRINT:cdefa:AVERAGE:"Average\:%8.2lf %s" \
GPRINT:cdefa:MAX:"Maximum\:%8.2lf %s\n" \
AREA:cdefe#00A0FF99:"ANIRA SA Bahia_IMA Outbound" \
GPRINT:cdeff:LAST:" Current\:%8.2lf %s" \
GPRINT:cdeff:AVERAGE:"Average\:%8.2lf %s" \
GPRINT:cdeff:MAX:"Maximum\:%8.2lf %s\n" \
AREA:cdefi#00FF0099:"ANIRA SA Beccar#523 Inbound":STACK \
GPRINT:cdefi:LAST:" Current\:%8.2lf %s" \
GPRINT:cdefi:AVERAGE:"Average\:%8.2lf %s" \
GPRINT:cdefi:MAX:"Maximum\:%8.2lf %s\n" \
AREA:cdefbc#00A0FF99:"ANIRA SA Beccar#523 Outbound":STACK \
GPRINT:cdefbd:LAST:"Current\:%8.2lf %s" \
GPRINT:cdefbd:AVERAGE:"Average\:%8.2lf %s" \
GPRINT:cdefbd:MAX:"Maximum\:%8.2lf %s\n" \
LINE1:cdefbg#00FF0099:"Total Inbound" \
GPRINT:cdefbg:LAST:" Current\:%8.2lf %s" \
GPRINT:cdefbg:AVERAGE:"Average\:%8.2lf %s" \
GPRINT:cdefbg:MAX:"Maximum\:%8.2lf %s\n" \
LINE1:cdefca#00A0FF99:"Total Outbound" \
GPRINT:cdefcb:LAST:" Current\:%8.2lf %s" \
GPRINT:cdefcb:AVERAGE:"Average\:%8.2lf %s" \
GPRINT:cdefcb:MAX:"Maximum\:%8.2lf %s\n"

RRDTool Says:
OK
except fro scaling limits, exactly the same graph (without the graph of course) created in V1.01
RRDTool Command:
/usr/bin/rrdtool graph - \
--imgformat=PNG \
--start=-86400 \
--end=-300 \
--title='Aggregate2' \
--rigid \
--x-grid MINUTE:60:HOUR:2:HOUR:2:0:%k \
--grid-dash 1:2 \
--color MGRID#FF0000DD --color GRID#11111188 \
--base=1000 \
--height=120 \
--width=600 \
--alt-autoscale \
--vertical-label='bits per second' \
--slope-mode \
--font TITLE:9:'DejaVu Sans Mono Book' \
--font AXIS:8:'DejaVu Sans Mono ' \
--font LEGEND:8:'DejaVu Sans Mono' \
--font UNIT:8:'DejaVu Sans Mono oblique' \
DEF:a="/var/www/html/cacti/rra/bahia_ima_ng_traffic_in_5528.rrd":'traffic_in':AVERAGE \
DEF:b="/var/www/html/cacti/rra/bahia_ima_ng_traffic_in_5528.rrd":'traffic_out':AVERAGE \
DEF:c="/var/www/html/cacti/rra/anira_sa_beccar523_traffic_in_9402.rrd":'traffic_in':AVERAGE \
DEF:d="/var/www/html/cacti/rra/anira_sa_beccar523_traffic_in_9402.rrd":'traffic_out':AVERAGE \
CDEF:cdefa='a,8,*' \
CDEF:cdefe='b,8,*,-1,*' \
CDEF:cdeff='b,8,*' \
CDEF:cdefi='c,8,*' \
CDEF:cdefbc='d,8,*,-1,*' \
CDEF:cdefbd='d,8,*' \
CDEF:cdefbg='TIME,1385995241,GT,a,a,UN,0,a,IF,IF,TIME,1385995241,GT,c,c,UN,0,c,IF,IF,+,8,*' \
CDEF:cdefca='TIME,1385995241,GT,b,b,UN,0,b,IF,IF,TIME,1385995241,GT,d,d,UN,0,d,IF,IF,+,8,*,-1,*' \
CDEF:cdefcb='TIME,1385995241,GT,b,b,UN,0,b,IF,IF,TIME,1385995241,GT,d,d,UN,0,d,IF,IF,+,8,*' \
--watermark "Brought to you by xxx" \
--color FONT#001D61 \
--color ARROW#FF3932 \
AREA:cdefa#00FF0099:"ANIRA SA Bahia_IMA Inbound" \
GPRINT:cdefa:LAST:" Current\:%8.2lf %s" \
GPRINT:cdefa:AVERAGE:"Average\:%8.2lf %s" \
GPRINT:cdefa:MAX:"Maximum\:%8.2lf %s\n" \
AREA:cdefe#00A0FF99:"ANIRA SA Bahia_IMA Outbound" \
GPRINT:cdeff:LAST:" Current\:%8.2lf %s" \
GPRINT:cdeff:AVERAGE:"Average\:%8.2lf %s" \
GPRINT:cdeff:MAX:"Maximum\:%8.2lf %s\n" \
AREA:cdefi#00FF0099:"ANIRA SA Beccar#523 Inbound":STACK \
GPRINT:cdefi:LAST:" Current\:%8.2lf %s" \
GPRINT:cdefi:AVERAGE:"Average\:%8.2lf %s" \
GPRINT:cdefi:MAX:"Maximum\:%8.2lf %s\n" \
AREA:cdefbc#00A0FF99:"ANIRA SA Beccar#523 Outbound":STACK \
GPRINT:cdefbd:LAST:"Current\:%8.2lf %s" \
GPRINT:cdefbd:AVERAGE:"Average\:%8.2lf %s" \
GPRINT:cdefbd:MAX:"Maximum\:%8.2lf %s\n" \
LINE1:cdefbg#00FF0099:"Total Inbound" \
GPRINT:cdefbg:LAST:" Current\:%8.2lf %s" \
GPRINT:cdefbg:AVERAGE:"Average\:%8.2lf %s" \
GPRINT:cdefbg:MAX:"Maximum\:%8.2lf %s\n" \
LINE1:cdefca#00A0FF99:"Total Outbound" \
GPRINT:cdefcb:LAST:" Current\:%8.2lf %s" \
GPRINT:cdefcb:AVERAGE:"Average\:%8.2lf %s" \
GPRINT:cdefcb:MAX:"Maximum\:%8.2lf %s\n"

RRDTool Says:
OK

fb