[rrd-users] Re: Loading extracted data

[Frederic Jacquet]

Thanks a lot ! That's it !
-----Original Message-----
From: Serge Maandag [mailto:serge.maandag at staff.zeelandnet.nl]
Sent: Monday, June 30, 2003 4:09 PM
To: Frederic Jacquet; rrd-users at list.ee.ethz.ch
Subject: RE: [rrd-users] Loading extracted data


I guess you have missed a part of the tutorial.

>        DS:disk1:GAUGE:600:U:U \

Try something like:

        DS:disk1:GAUGE:3600:U:U \

Serge.

-----Original Message-----
From: Frederic Jacquet [mailto:fjacquet at montrouge.sns.slb.com] 
Sent: Monday, June 30, 2003 3:42 PM
To: rrd-users at list.ee.ethz.ch
Subject: [rrd-users] Loading extracted data
Importance: Low


Hi folks, 

I try to load data extracted from a database to rrdtool for graphing.
The values are get every 30 minutes, So I have try : 

I have generate this rrd :  

$RRDTOOL_PATH create $RRD_PATH/disk.rrd\
         --start 1054420000 \
         --step 1800 \
        DS:disk1:GAUGE:600:U:U \
        DS:disk2:GAUGE:600:U:U \
        RRA:AVERAGE:0.5:1:600      \
        RRA:AVERAGE:0.5:6:700      \
        RRA:AVERAGE:0.5:24:775     \
        RRA:AVERAGE:0.5:288:797    \
        RRA:MAX:0.5:1:600          \
        RRA:MAX:0.5:6:700          \
        RRA:MAX:0.5:24:775         \
        RRA:MAX:0.5:288:797

Then : 

rrdtool update disk.rrd "1054422000:25.17:25.17"
rrdtool update disk.rrd "1054423800:25.15:25.15"
[...]
rrdtool update disk.rrd "1055455200:33.83:33.83"
rrdtool update disk.rrd "1055457000:33.83:33.83"

When I fetch the values, I get nothing : 
rrdtool dump disk.rrd |grep -v NaN
<!-- Round Robin Database Dump -->
<rrd>
        <version> 0001 </version>
        <step> 1800 </step> <!-- Seconds -->
        <lastupdate> 1055457000 </lastupdate> <!-- 2003-06-13 00:30:00
MEST -->

        <ds>
                <name> disk1 </name>
                <type> GAUGE </type>
                <minimal_heartbeat> 600 </minimal_heartbeat>

                <!-- PDP Status -->
                <last_ds> UNKN </last_ds>
                <value> 0.0000000000e+00 </value>
                <unknown_sec> 0 </unknown_sec>
        </ds>

        <ds>
                <name> disk2 </name>
                <type> GAUGE </type>
                <minimal_heartbeat> 600 </minimal_heartbeat>

                <!-- PDP Status -->
                <last_ds> UNKN </last_ds>
                <value> 0.0000000000e+00 </value>
                <unknown_sec> 0 </unknown_sec>
        </ds>

<!-- Round Robin Archives -->
        <rra>
                <cf> AVERAGE </cf>
                <pdp_per_row> 1 </pdp_per_row> <!-- 1800 seconds -->
                <xff> 5.0000000000e-01 </xff>

                <cdp_prep>
                </cdp_prep>
                <database>
                </database>
        </rra>
        <rra>
                <cf> AVERAGE </cf>
                <pdp_per_row> 6 </pdp_per_row> <!-- 10800 seconds -->
                <xff> 5.0000000000e-01 </xff>

                <cdp_prep>
                </cdp_prep>
                <database>
                </database>
        </rra>
        <rra>
                <cf> AVERAGE </cf>
                <pdp_per_row> 24 </pdp_per_row> <!-- 43200 seconds -->
                <xff> 5.0000000000e-01 </xff>

                <cdp_prep>
                </cdp_prep>
                <database>
                </database>
        </rra>
        <rra>
                <cf> AVERAGE </cf>
                <pdp_per_row> 288 </pdp_per_row> <!-- 518400 seconds -->
                <xff> 5.0000000000e-01 </xff>

                <cdp_prep>
                </cdp_prep>
                <database>
                </database>
        </rra>
        <rra>
                <cf> MAX </cf>
                <pdp_per_row> 1 </pdp_per_row> <!-- 1800 seconds -->
                <xff> 5.0000000000e-01 </xff>

                <cdp_prep>
                </cdp_prep>
                <database>
                </database>
        </rra>
        <rra>
                <cf> MAX </cf>
                <pdp_per_row> 6 </pdp_per_row> <!-- 10800 seconds -->
                <xff> 5.0000000000e-01 </xff>

                <cdp_prep>
                </cdp_prep>
                <database>
                </database>
        </rra>
        <rra>
                <cf> MAX </cf>
                <pdp_per_row> 24 </pdp_per_row> <!-- 43200 seconds -->
                <xff> 5.0000000000e-01 </xff>

                <cdp_prep>
                </cdp_prep>
                <database>
                </database>
        </rra>
        <rra>
                <cf> MAX </cf>
                <pdp_per_row> 288 </pdp_per_row> <!-- 518400 seconds -->
                <xff> 5.0000000000e-01 </xff>

                <cdp_prep>
                </cdp_prep>
                <database>
                </database>
        </rra>
</rrd>


This seems to lock me only when loading old values in batch, when I
monitor in real time, everything is ok.
I don't understand what's wrong with this method !

Frederic 				








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


-- Attached file removed by Ecartis and put at URL below --
-- Type: application/ms-tnef
-- Size: 3k (3248 bytes)
-- URL : http://www.ee.ethz.ch/~slist/p/3F004F0520645-winmail.dat


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