no graphs for CPU Usage and Load average, problem with CDEF

[puoka]

I upgraded to cacti-0.8.6j and installed few templates right away, so I am not sure what was the cause. but the result - no graphs for CPU Usage and Load average. The rest of the graphs work fine. As far as I understand there is a problem with CDEF, here is the Graph debug:

Code: Select all

 RRDTool Command:

/usr/bin/rrdtool graph - \
--imgformat=PNG \
--start=-86400 \
--end=-300 \
--title="*** - CPU Usage" \
--rigid \
--base=1000 \
--height=120 \
--width=500 \
--alt-autoscale-max \
--lower-limit=0 \
--vertical-label="percent" \
--slope-mode \
DEF:a="***_cpu_system_8753.rrd":cpu_system:AVERAGE \
DEF:b="***_cpu_user_8754.rrd":cpu_user:AVERAGE \
DEF:c="***_cpu_nice_8752.rrd":cpu_nice:AVERAGE \
CDEF:cdefbc= \
AREA:a#FF0000:"System"  \
GPRINT:a:LAST:"Current\:%8.2lf %s"  \
GPRINT:a:AVERAGE:"Average\:%8.2lf %s"  \
GPRINT:a:MAX:"Maximum\:%8.2lf %s\n"  \
AREA:b#0000FF:"User":STACK \
GPRINT:b:LAST:"  Current\:%8.2lf %s"  \
GPRINT:b:AVERAGE:"Average\:%8.2lf %s"  \
GPRINT:b:MAX:"Maximum\:%8.2lf %s\n"  \
AREA:c#00FF00:"Nice":STACK \
GPRINT:c:LAST:"  Current\:%8.2lf %s"  \
GPRINT:c:AVERAGE:"Average\:%8.2lf %s"  \
GPRINT:c:MAX:"Maximum\:%8.2lf %s\n"  \
LINE1:cdefbc#000000:"Total"  \
GPRINT:cdefbc:LAST:" Current\:%8.2lf %s"  \
GPRINT:cdefbc:AVERAGE:"Average\:%8.2lf %s"  \
GPRINT:cdefbc:MAX:"Maximum\:%8.2lf %s" 

RRDTool Says:

What looks odd to me here is "CDEF:cdefbc= \" -- there are no values in the function and no calculations are made.
there is nothing in "RRDTool Says:" also.

I spend some time researching and looking at templates and how graph is being generated, can't find anything, don't see anything in the log.

How do I fix this, what to check?
Need help.

[gandalf]

Please visit the Graph Template. Then, select the Graph Item belonging to the "Total" line. Post a screenshot. Look at the CDEF referenced here, perhaps it is broken
Reinhard

[puoka]

I went to Graph Templates > ucd/net - Load Average > Item # 7 (No Task): Total
Bellow is the screenshot of that. It is using CDEF Total All data Sources.
Last night I was trying to replace the function "Total All data Sources" in Console -> CDEF's by deleting it and reexporting the template for ucd/net - Load Average from a working instance of cacti... it didn't work out.
I also include screenshots of the way that function is defined, it has two items there, the second one is coming from a template for Apache stats, I tried both ways the way that function is defined by default and the way it is on the screenshot, the resut was the same.
Anything else i can try to fix it...? My Load average and CPU usage are still not graphing.

[gandalf]

The CDEF is wrong. Please delete the duplicate entry and retry.
Reinhard

[puoka]

Thanks gandalf!
Here is what I did :
I deleted the Console -> CDEF's -> Total All data Sources and imported ucd/net - Load Average which contains the function in its original state. I did the same operation before, but it didn't fix it.
This time I went to the Graph Template and set CDEF Function to None, saved it and then set it back to Total All data Sources, saved it and my GRAPHS SHOWED UP.

Thanks again, I think the problem is solved, thought I wish that Graph Template would see the change in the CDEF's without me having to reset it.