[rrd-users] Re: nan after about 6 hours of data collection

[Alex van den Bogaerdt]

On Thu, Dec 18, 2003 at 09:47:09AM +0100, rajkumars at asianetindia.com wrote:
> Hello all,
> 
> I am pretty new to RRD, started playing with in 2 days ago. I created an rrd, which will be updated per minute, and I populated it with data continuously every 30 minutes using rrdtool update. But data after about 6 hours are all nan. here are my exact configs 
> 
> rrdtool create icmp.rrd \
> -s 60  --start 1071682900 \

You say you're going to update every 30 minutes.  This means every
first update of each batch will be too late.  Change heartbeat as
appropriate.

> RRA:AVERAGE:0.5:1:720 \
> RRA:AVERAGE:0.5:5:720 \
> RRA:AVERAGE:0.5:30:336 \
> RRA:AVERAGE:0.5:120:360 \
> RRA:AVERAGE:0.5:1440:365 \
> 
> I am not fully sure of the RRA sections are correct, my intentions are to create a graph of 5 min average for 24 hours, 30 min average for a week, 2 hours average for a month and day average for a year. 

It doesn't hurt (much) but you could do without the first RRA.

> I have collected data from 1071682903 till 1071734374 and stored in a directory in files in format 

1071734374
1071682903 -
----------
     51471

This is 857 minutes 51 seconds.  Almost 15 hours.  The first RRA will
be fully populated.  The last entry should have been made at time
1071734340.  

> which is inserted into rrd using an awk script 
> 
> $ cat backup/* | awk -f icmp.awk  | bash

How can you tell the files will be processed in chronological order?
You MUST insert data in chronological order.

> raj at indus:~/rrd$ cat icmp.awk 
> BEGIN{ print "#!/bin/sh"}
> { printf  "rrdtool update icmp.rrd %d:%d:%d:%d:%d\n", $1,$2,$3,$4,$5}

< backup/* sort -n |\
   awk '{print "update icmp.rrd %d:%d:%d:%d:%d\n", $1,$2,$3,$4,$5}' |\
   rrdtool -


>                       one           two         three          four
> 
> 1071734040: 2.5975000000e+02 5.8300000000e+01 2.2451100000e+04 1.4742570000e+05
> 1071734100: 3.2525000000e+02 8.1350000000e+01 2.1923250000e+04 1.4996735000e+05
> 1071734160: 4.4900000000e+02 1.2700000000e+02 2.2234000000e+04 1.4611900000e+05
> 1071734220: 2.5400000000e+02 6.4000000000e+01 1.9648000000e+04 1.4952700000e+05
> 1071734280: 2.9603333333e+02 7.3966666667e+01 2.0311000000e+04 1.4868720000e+05
> 1071734340: 3.0723333333e+02 7.4000000000e+01 2.1857900000e+04 1.4831656667e+05

This is correct.  As stated above, an update at time 1071734374 will
cause the RRA to be populated until timestamp 1071734340.  The next
interval
> 1071734400: nan nan nan nan
is not yet completed.

When using the fetch command, specify an end time (1071734400 would be
nice).

HTH
Alex
-- 
http://www.googlism.com/index.htm?ism=alex+van+den+bogaerdt&type=1
This message was produced without any <iframe tags

--
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