[rrd-users] Re: Values in RRD are incorrect

[Darryl Lewis]

Are you setting the rrd to AVERAGE, GAUGE, COUNTER ?

-----Original Message-----
From: rrd-users-bounce at list.ee.ethz.ch
[mailto:rrd-users-bounce at list.ee.ethz.ch]On Behalf Of Richard Marshall
Sent: Monday, 5 June 2006 8:57 PM
To: rrd-users at list.ee.ethz.ch
Subject: [rrd-users] Values in RRD are incorrect


Hello,

I am using a perl script to select values from a mysql database and insert 
those values into a RRDs. I have had to bulk import historical data (approx. 
30 days at 1 minute intervals), which has gone without a problem. The graphs 
are correct and the values in the RRAs are correct. The problems start to 
come about when I run the script from cron every 5 minutes.

Even though the data from the database is correct, and the values inserted 
into the RRDs are correct, when I fetch the data from the rrd, for two 
fifths of the data the rates are incorrect by a huge factor. I have included 
an example of the data that is being updated into the RRd and the 
corresponding results from an rrd fetch.

                                          1149151620: 3.9444444444e+00 
1.9083333333e+00 1.3888888889e-02
                                          1149151680: 3.6611111111e+00 
2.0555555556e+00 1.6666666667e-02
1149151758, 6974702, 4348279, 34864       1149151740: 2.9861111111e+00 
1.7083333333e+00 3.0555555556e-02
1149151810, 8717127, 5442318, 43698       1149151800: 7.1577206999e+07 
7.1579283687e+07 7.1582759975e+07
1149151870, 8717300, 5442414, 43700       1149151860: 5.5870982906e+03 
3.5078685897e+03 2.8341880342e+01
1149151930, 8717482, 5442515, 43701       1149151920: 3.0083333333e+00 
1.6694444444e+00 1.9444444444e-02
1149151990, 8717646, 5442607, 43702       1149151980: 2.7833333333e+00 
1.5583333333e+00 1.6666666667e-02
1149152050, 8717850, 5442721, 43702       1149152040: 3.2888888889e+00 
1.8388888889e+00 2.7777777778e-03

Tha values on the left are the output of the script values and those on the 
right are the results of the rrd fetch. Each time the cron script runs I see 
a rate of 10e7, 10e2 and then back to the correct values.

Why is this happening and how can I resolve it? Please let me know if 
further detials are required.

(I have attached the values as text in case the columns get wrapped and 
start upsetting the formatting!)

TIA

Richard Marshall,
Systems Administrator,
Vibrant Media


--
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://lists.ee.ethz.ch/rrd-users
WebAdmin    http://lists.ee.ethz.ch/lsg2.cgi


==============================================================================
The information contained in this email and any attachment is confidential and
may contain legally privileged or copyright material.   It is intended only for
the use of the addressee(s).  If you are not the intended recipient of this
email, you are not permitted to disseminate, distribute or copy this email or
any attachments.  If you have received this message in error, please notify the
sender immediately and delete this email from your system.  The ABC does not
represent or warrant that this transmission is secure or virus free.   Before
opening any attachment you should check for viruses.  The ABC's liability is
limited to resupplying any email and attachments
==============================================================================

--
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://lists.ee.ethz.ch/rrd-users
WebAdmin    http://lists.ee.ethz.ch/lsg2.cgi