Total All Data Sources - Max

mrnoodle · Post by **mrnoodle** » Mon Sep 21, 2009 1:28 pm

There appears to be a problem with the Total All Data Sources CDEF when dealing with Max Values in an RRD file. If you look at the attached graph below, you can see that the Max value of one of the individual graph items is actually more than the Max value of the combined graph which is generated using the "Total All Data Sources" function.

Looking at the Graph properties, it appears that the Total All Data Sources function is only being applied to the Average values in the RRD files and the discrepancy is appearing after the Average values are consolidated.

DEF:a="/usr/local/cacti/rra/ihg_ipe_1_mpegpidrate_3634.rrd":mpegpidrate:AVERAGE \
DEF:b="/usr/local/cacti/rra/ihg_ipe_1_mpegpidrate_3634.rrd":mpegpidrate:MAX \
DEF:c="/usr/local/cacti/rra/ihg_ipe_1_mpegpidrate_3635.rrd":mpegpidrate:AVERAGE \
DEF:d="/usr/local/cacti/rra/ihg_ipe_1_mpegpidrate_3635.rrd":mpegpidrate:MAX \
DEF:e="/usr/local/cacti/rra/ihg_ipe_1_mpegpidrate_3632.rrd":mpegpidrate:AVERAGE \
DEF:f="/usr/local/cacti/rra/ihg_ipe_1_mpegpidrate_3632.rrd":mpegpidrate:MAX \
DEF:g="/usr/local/cacti/rra/ihg_ipe_1_mpegpidrate_3633.rrd":mpegpidrate:AVERAGE \
DEF:h="/usr/local/cacti/rra/ihg_ipe_1_mpegpidrate_3633.rrd":mpegpidrate:MAX \
CDEF:cdefbh=TIME,1253555703,GT,a,a,UN,0,a,IF,IF,TIME,1253555703,GT,c,c,UN,0,c,IF,IF,TIME,1253555703,GT,e,e,UN,0,e,IF,IF,TIME,1253555703,GT,g,g,UN,0,g,IF,IF,+,+,+ \

Is there any way to get the Total All Data Sources CDEF to apply to the Max RRD entries to eliminate this divergence without having to manually create a CDEF?

Post by **gandalf** » Tue Sep 22, 2009 4:26 pm

Which CF is chosen on the graph template item that defines the total?
Reinhard

mrnoodle · Post by **mrnoodle** » Wed Sep 23, 2009 6:50 am

The graph was created manually, not from a template and the original
CF that was chosen was AVG.

I thought that may be the issue so I tried to add a new graph item that used the same "Total All Data Source" CDEF but used the MAX CF instead. The item that was created used the same CDEF as the original item and it did not create a second CDEF using DEFs b,d,f,h.

jackofferman · Post by **jackofferman** » Tue Oct 13, 2009 3:54 pm

I created a new CDEF to get the Average to work. I didn't want a total of all my Averages, because that wouldn't make too much sense. I wanted an Average of all the Averages: Here's the CDEF I created:
Average of All:
cdef=SIMILAR_DATA_SOURCES_NODUPS,7,/

So basically, it's all Similiar Data Sources, No duplicates and then divided by 7 since I have seven data sources.

I've attached a word doc of my graph and snapshot of the CDEF.

I've also read that the All Data Sources for the MAX values does not work correctly and is fixed in version 0.8.7c.

Cacti