[rrd-users] Import old data to rrdtool

Hicham.ElHarti at dekabank.de Hicham.ElHarti at dekabank.de
Mon Oct 1 16:05:30 CEST 2007


Hello,

I have some text files with old monitoring data, which should be insered
to rrdtool DB and showed with graphics.

The files have this form: (timestamp art_avg  art_min art_max)
===============================
1189585215 0 0 2
1189585515 0 0 3
1189585815 0 0 3
1189586115 5 0 6
1189586415 0 0 2
1189586715 1 1 3
1189587015 7 1 14
1189587315 0 0 2
1189587615 0 0 3
1189587915 0 0 2
1189588215 1 1 4
1189588515 0 0 3
1189588815 0 0 2
1189589115 0 0 1
1189589415 0 0 21
...
=================================

I created a DB for these data using:
rrdtool create test.rrd --start 1188597600\
                -s 300   DS:art_avg:GAUGE:180:U:U \
                         DS:art_min:GAUGE:180:U:U \
                         DS:art_max:GAUGE:180:U:U \
                         RRA:AVERAGE:0.5:1:8640 \
                        RRA:AVERAGE:0.5:1:8640 \
                        RRA:AVERAGE:0.5:1:8640
========================================

I then inserted the data in form:
Timestamp:art_avg:art_min:art_max with the command rrdtool update

I tried to get the graph with: (for month september 2007)
/usr/bin/rrdtool graph test.png \
                -s "00:00 09/01/07" -e "23:59 09/30/07" \
                 -v "ZGS Average Response Time" -w 1000 -h 450 -t " ZGS
AJA " \
                DEF:art_avg=test.rrd:art_avg:AVERAGE \
                DEF:art_min=test.rrd:art_min:AVERAGE \
                DEF:art_max=test.rrd:art_max:AVERAGE \
                COMMENT:"       " \
                LINE1:art_avg#00FFFF:"Average Response Time" \
                LINE1:art_min#FF00FF:"Min Response Time" \
                LINE1:art_min#00FF00:"Max Response Time" \
                COMMENT:"       \j"

But the graph is empty!!!!

When I run 
rrdtool fetch test.rrd AVERAGE I get several line like:
=================================
1191242100: nan nan nan
1191242400: nan nan nan
1191242700: nan nan nan
1191243000: nan nan nan
1191243300: nan nan nan
1191243600: nan nan nan
1191243900: nan nan nan
1191244200: nan nan nan
1191244500: nan nan nan
1191244800: nan nan nan
1191245100: nan nan nan
1191245400: nan nan nan
1191245700: nan nan nan
1191246000: nan nan nan
==================================

Can you tell me please why the graphs are empty

Thank you in advance!

Cheers,
Hicham



-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.oetiker.ch/pipermail/rrd-users/attachments/20071001/d9ffb2e6/attachment.html 


More information about the rrd-users mailing list