[rrd-users] Re: Cricket/RRD fetch resolution problem (2nd try)

[Scott C. Kennedy]

Alex van den Bogaerdt wrote:

> > It seems that every query on data1.rrd returns the large number of values, yet every
> > query on
> > data2.rrd returns the 2 hr average values.
>
> Alright, check the properties of data2.rrd using "rrdtool info".  Maybe
> this RRA is missing:
>      # one point per 5 minutes, spanning 366 days
>      rra             5minUse     AVERAGE:0.5:1:105500
> Make sure to check both the number of rows *and* the consolidation function!

ahum (right back at you!): :)

"Scott C. Kennedy" wrote:

     # rrdtool info data1.rrd
     filename = "data1.rrd"
     rrd_version = "0001"
     step = 300
     last_update = 995911215
         [lines pruned]
     rra[4].cf = "AVERAGE"
     rra[4].rows = 105500
     rra[4].pdp_per_row = 1
     rra[4].xff = 5.0000000000e-01
     rra[4].cdp_prep[0].value = NaN
     rra[4].cdp_prep[0].unknown_datapoints = 0
     rra[4].cdp_prep[1].value = NaN
     rra[4].cdp_prep[1].unknown_datapoints = 0
     # rrdtool info data2.rrd
     filename = "data2.rrd"
     rrd_version = "0001"
     step = 300
     last_update = 996719709
          [lines pruned]
     rra[4].cf = "AVERAGE"
     rra[4].rows = 105500
     rra[4].pdp_per_row = 1
     rra[4].xff = 5.0000000000e-01
     rra[4].cdp_prep[0].value = NaN
     rra[4].cdp_prep[0].unknown_datapoints = 0
     rra[4].cdp_prep[1].value = NaN
     rra[4].cdp_prep[1].unknown_datapoints = 0

> > Maybe, I should look at this a different way, is there a way to specify with RRA to
> > fetch from?
>
> ahum:
>
> > Alex van den Bogaerdt wrote:
>
> > > Oh, and if everything is working as it should you can use the resolution
> > > flag to rrdtool fetch.   *If* the time is an exact multiple of 2 hours,
> > > you can choose which RRA to use.  However, if you try to select the
> > > 2-hour RRA but fail to query correct start and end times, it fails:
> > > "--start 00:00 --end 22:00" will work (assuming a timezone that is an
> > > even number of hours away from UTC) but "--start 00:05 --end 22:05" will
> > > not work.  It will return data from the 5-minute RRA.

Same problem...

     # sh -x /tmp/test_me
     + rrdtool fetch data1.rrd AVERAGE -r 300 -e 996782400 -s end-31days
     + wc -l
         8931
     + rrdtool fetch data1.rrd AVERAGE -r 300 -e 996782700 -s end-31days
     + wc -l
         8931
     + rrdtool fetch data1.rrd AVERAGE -r 300 -e 996784200 -s end-31days
     + wc -l
         8931
     + rrdtool fetch data1.rrd AVERAGE -r 300 -e 996786000 -s end-31days
     + wc -l
         8931
     + rrdtool fetch data1.rrd AVERAGE -r 300 -e 996786300 -s end-31days
     + wc -l
         8931
     + rrdtool fetch data2.rrd AVERAGE -r 300 -e 996782400 -s end-31days
     + wc -l
          375
     + rrdtool fetch data2.rrd AVERAGE -r 300 -e 996782700 -s end-31days
     + wc -l
          376
     + rrdtool fetch data2.rrd AVERAGE -r 300 -e 996784200 -s end-31days
     + wc -l
          376
     + rrdtool fetch data2.rrd AVERAGE -r 300 -e 996786000 -s end-31days
     + wc -l
          376
     + rrdtool fetch data2.rrd AVERAGE -r 300 -e 996786300 -s end-31days
     + wc -l
          376

BTW, thank you for your help with this, I've been pouring over the manuals trying
alot of this, but keep hitting the same problem.

Scott


--
Unsubscribe mailto:rrd-users-request at list.ee.ethz.ch?subject=unsubscribe
Help        mailto:rrd-users-request at list.ee.ethz.ch?subject=help
Archive     http://www.ee.ethz.ch/~slist/rrd-users
WebAdmin    http://www.ee.ethz.ch/~slist/lsg2.cgi