[rrd-users] Incorrect MAX total from consolidated cacti graph

Thu Oct 29 17:00:45 CET 2015

> Thanks to both Simon and Steve for their responses. After carefully
> reading
> these responses, I am beginning to believe that rrdtool is selecting
> consolidated values when the MAX samples required for the total are still
> in
> the rrd file. Below are some more facts that may help shed some light on
> this issue:

maybe this helps?

http://rrdtool.vandenbogaerdt.nl/min-avg-max.php

(please ignore the rest, my dumb phone has trouble doing what i want)

A definition for all the files involved includes a MAX CDEF.
> All the files have one-minute samples.
> The one-minute MAX samples are still in the rrd files for the timeframe
> (10/18/2015 @ 13:56) of the original posting.
>
> I am including a copy of the cacti graph definition below (edited with
> 'ABC'
> to hide customer names). It is clear to me that the rrdtool is simply
> adding
> all the MAX values.
>
> /usr/bin/rrdtool graph - \
> --imgformat=PNG \
> --start='1445190960' \
> --end='1445190960' \
> --title='All Production In Channel Users' \
> --base='1000' \
> --height='120' \
> --width='500' \
> --alt-autoscale-max \
> --lower-limit='0' \
> COMMENT:"From 2015/10/18 13\:56\:00 To 2015/10/18 13\:56\:00\c" \
> COMMENT:"  \n" \
> --vertical-label='' \
> --slope-mode \
> --font TITLE:12: \
> --font AXIS:8: \
> --font LEGEND:8: \
> --font UNIT:8: \
> DEF:a='/usr/share/cacti/rra/ABC_ousers_3892.rrd':'musers':MAX \
> DEF:b='/usr/share/cacti/rra/ABC_ousers_3825.rrd':'musers':MAX \
> DEF:c='/usr/share/cacti/rra/ABC_ousers_3912.rrd':'musers':MAX \
> DEF:d='/usr/share/cacti/rra/ABC_3780.rrd':'musers':MAX \
> DEF:e='/usr/share/cacti/rra/ABC_ousers_3834.rrd':'musers':MAX \
> DEF:f='/usr/share/cacti/rra/ABC_ousers_3807.rrd':'musers':MAX \
> DEF:g='/usr/share/cacti/rra/ABC_ousers_3709.rrd':'musers':MAX \
> DEF:h='/usr/share/cacti/rra/ABC_ousers_3718.rrd':'musers':MAX \
> DEF:i='/usr/share/cacti/rra/ABC_ousers_4383.rrd':'musers':MAX \
> DEF:j='/usr/share/cacti/rra/ABC_ousers_3727.rrd':'musers':MAX \
> DEF:ba='/usr/share/cacti/rra/ABC_ousers_3771.rrd':'musers':MAX \
> DEF:bb='/usr/share/cacti/rra/ABC_ousers_4630.rrd':'musers':MAX \
> DEF:bc='/usr/share/cacti/rra/ABC_ousers_3968.rrd':'musers':MAX \
> DEF:bd='/usr/share/cacti/rra/ABC_ousers_3958.rrd':'musers':MAX \
> DEF:be='/usr/share/cacti/rra/ABC_ousers_4478.rrd':'musers':MAX \
> DEF:bf='/usr/share/cacti/rra/ABC_ousers_4100.rrd':'musers':MAX \
> DEF:bg='/usr/share/cacti/rra/ABC_ousers_3752.rrd':'musers':MAX \
> DEF:bh='/usr/share/cacti/rra/ABC_ousers_4123.rrd':'musers':MAX \
> DEF:bi='/usr/share/cacti/rra/ABC_ousers_4058.rrd':'musers':MAX \
> DEF:bj='/usr/share/cacti/rra/ABC_4090.rrd':'musers':MAX \
> DEF:ca='/usr/share/cacti/rra/ABC_ousers_4074.rrd':'musers':MAX \
> DEF:cb='/usr/share/cacti/rra/ABC_ousers_4114.rrd':'musers':MAX \
> DEF:cc='/usr/share/cacti/rra/ABC_ousers_4133.rrd':'musers':MAX \
> DEF:cd='/usr/share/cacti/rra/ABC_ousers_4762.rrd':'musers':MAX \
> DEF:ce='/usr/share/cacti/rra/ABC_ousers_3744.rrd':'musers':MAX \
> DEF:cf='/usr/share/cacti/rra/ABC_ousers_4016.rrd':'musers':MAX \
> DEF:cg='/usr/share/cacti/rra/ABC_ousers_4025.rrd':'musers':MAX \
> DEF:ch='/usr/share/cacti/rra/ABC_ousers_3816.rrd':'musers':MAX \
> DEF:ci='/usr/share/cacti/rra/ABC_ousers_3843.rrd':'musers':MAX \
> DEF:cj='/usr/share/cacti/rra/ABC_ousers_4043.rrd':'musers':MAX \
> DEF:da='/usr/share/cacti/rra/ABC_ousers_3673.rrd':'musers':MAX \
> DEF:db='/usr/share/cacti/rra/ABC_ousers_3648.rrd':'musers':MAX \
> DEF:dc='/usr/share/cacti/rra/ABC_ousers_4541.rrd':'musers':MAX \
> DEF:dd='/usr/share/cacti/rra/ABC_ousers_4592.rrd':'musers':MAX \
> CDEF:cdefde='TIME,1446121816,GT,a,a,UN,0,a,IF,IF,TIME,1446121816,GT,b,b,UN,0,b,IF,IF,TIME,1446121816,GT,c,c,UN,0,c,IF,IF,TIME,1446121816,GT,d,d,UN,0,d,IF,IF,TIME,1446121816,GT,e,e,UN,0,e,IF,IF,TIME,1446121816,GT,f,f,UN,0,f,IF,IF,TIME,1446121816,GT,g,g,UN,0,g,IF,IF,TIME,1446121816,GT,h,h,UN,0,h,IF,IF,TIME,1446121816,GT,i,i,UN,0,i,IF,IF,TIME,1446121816,GT,j,j,UN,0,j,IF,IF,TIME,1446121816,GT,ba,ba,UN,0,ba,IF,IF,TIME,1446121816,GT,bb,bb,UN,0,bb,IF,IF,TIME,1446121816,GT,bc,bc,UN,0,bc,IF,IF,TIME,1446121816,GT,bd,bd,UN,0,bd,IF,IF,TIME,1446121816,GT,be,be,UN,0,be,IF,IF,TIME,1446121816,GT,bf,bf,UN,0,bf,IF,IF,TIME,1446121816,GT,bg,bg,UN,0,bg,IF,IF,TIME,1446121816,GT,bh,bh,UN,0,bh,IF,IF,TIME,1446121816,GT,bi,bi,UN,0,bi,IF,IF,TIME,1446121816,GT,bj,bj,UN,0,bj,IF,IF,TIME,1446121816,GT,ca,ca,UN,0,ca,IF,IF,TIME,1446121816,GT,cb,cb,UN,0,cb,IF,IF,TIME,1446121816,GT,cc,cc,UN,0,cc,IF,IF,TIME,1446121816,GT,cd,cd,UN,0,cd,IF,IF,TIME,1446121816,GT,ce,ce,UN,0,ce,IF,IF,TIME,1446121816,GT,cf,cf,UN,0,
 cf,IF,IF,T
>  IME,1446121816,GT,cg,cg,UN,0,cg,IF,IF,TIME,1446121816,GT,ch,ch,UN,0,ch,IF,IF,TIME,1446121816,GT,ci,ci,UN,0,ci,IF,IF,TIME,1446121816,GT,cj,cj,UN,0,cj,IF,IF,TIME,1446121816,GT,da,da,UN,0,da,IF,IF,TIME,1446121816,GT,db,db,UN,0,db,IF,IF,TIME,1446121816,GT,dc,dc,UN,0,dc,IF,IF,TIME,1446121816,GT,dd,dd,UN,0,dd,IF,IF,+,+,+,+,+,+,+,+,+,+,+,+,+,+,+,+,+,+,+,+,+,+,+,+,+,+,+,+,+,+,+,+,+'
> \
> AREA:a#FFF200FF:'ABC'  \
> AREA:b#55009DFF:'ABC':STACK \
> AREA:c#EA8F00FF:'ABC':STACK \
> AREA:d#4444FFFF:'ABC':STACK \
> AREA:e#FF0000FF:'ABC':STACK \
> AREA:f#55009DFF:'ABC':STACK \
> AREA:g#FF0000FF:'ABC':STACK \
> AREA:h#EACC00FF:'ABC':STACK \
> AREA:i#FF7D00FF:'ABC':STACK \
> AREA:j#000000FF:'ABC':STACK \
> AREA:ba#55009DFF:'ABC':STACK \
> AREA:bb#FF5576FF:'ABC':STACK \
> AREA:bc#FFF200FF:'ABC':STACK \
> AREA:bd#55009DFF:'ABC':STACK \
> AREA:be#4444FFFF:'ABC':STACK \
> AREA:bf#F5F800FF:'ABC':STACK \
> AREA:bg#0022CCFF:'ABC':STACK \
> AREA:bh#FFC3C0FF:'ABC':STACK \
> AREA:bi#FFC3C0FF:'ABC':STACK \
> AREA:bj#FFC3C0FF:'ABC':STACK \
> AREA:ca#FFC3C0FF:'ABC':STACK \
> AREA:cb#FFC3C0FF:'ABC':STACK \
> AREA:cc#FFC3C0FF:'ABC':STACK \
> AREA:cd#00FF00FF:'ABC':STACK \
> AREA:ce#74C366FF:'ABC':STACK \
> AREA:cf#EACC00FF:'ABC':STACK \
> AREA:cg#000000FF:'ABC':STACK \
> AREA:ch#4400CCFF:'ABC':STACK \
> AREA:ci#FFF200FF:'ABC':STACK \
> AREA:cj#EA8F00FF:'ABC':STACK \
> AREA:da#EACC00FF:'ABC':STACK \
> AREA:db#FF0000FF:'ABC':STACK \
> AREA:dc#7CB3F1FF:'ABC':STACK \
> AREA:dd#FFF200FF:'ABC\n':STACK \
> GPRINT:cdefde:LAST:'     CUR\: %8.0lf'  \
> GPRINT:cdefde:AVERAGE:'AVG\: %8.0lf'  \
> GPRINT:cdefde:MAX:'MAX\: %8.0lf'
> Viewing Graph Properties 'All Production In Channel Users'
> All Production In Channel Users	Zoom Graph
> CSV Export
>
>
>
>
>
>
>
>
>
>
> --
> View this message in context:
> http://rrd-mailinglists.937164.n2.nabble.com/Incorrect-MAX-total-from-consolidated-cacti-graph-tp7583182p7583196.html
> Sent from the RRDtool Users Mailinglist mailing list archive at
> Nabble.com.
>
> _______________________________________________
> rrd-users mailing list
> rrd-users at lists.oetiker.ch
> https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users
>
>