[rrd-users] Re: Values in RRD are incorrect
Richard Marshall
richiemarshall at hotmail.com
Tue Jun 6 10:17:46 MEST 2006
Hi,
the RRD is a counter - the values start at 0 and increment (they are a
mesaure of page views, cpm views and clicks since the application started)
and I am holding maximum and average values. I see the same problem with
both max and average - that the rate will shoot up to 10e7 even though the
actual rate is typically around 0.5.
Thanks
Rich
----Original Message Follows----
From: "Darryl Lewis" <Lewis.Darryl at abc.net.au>
To: "Richard Marshall"
<richiemarshall at hotmail.com>,<rrd-users at list.ee.ethz.ch>
Subject: [rrd-users] Re: Values in RRD are incorrect
Date: Tue, 6 Jun 2006 10:53:11 +1000
MIME-Version: 1.0
Received: from bay0-mc4-f8.bay0.hotmail.com ([65.54.244.112]) by
bay0-imc1-s12.bay0.hotmail.com with Microsoft SMTPSVC(6.0.3790.1830); Mon, 5
Jun 2006 17:55:24 -0700
Received: from smtp.ee.ethz.ch ([129.132.2.219]) by
bay0-mc4-f8.bay0.hotmail.com with Microsoft SMTPSVC(6.0.3790.1830); Mon, 5
Jun 2006 17:55:10 -0700
Received: from localhost (tranquillity.ee.ethz.ch [129.132.2.222])by
smtp.ee.ethz.ch (Postfix) with ESMTP id 7C4C6D934C;Tue, 6 Jun 2006 02:55:06
+0200 (MEST)
Received: from smtp.ee.ethz.ch ([129.132.2.217]) by localhost (tranquillity
[129.132.2.222]) (amavisd-new, port 10024) with LMTP id 29059-01-7; Tue, 6
Jun 2006 02:55:06 +0200 (MEST)
Received: from tardis (smtp.ee.ethz.ch [129.132.2.219])by smtp.ee.ethz.ch
(Postfix) with ESMTP id 04048D9310;Tue, 6 Jun 2006 02:54:55 +0200 (MEST)
Received: with ECARTIS (v1.0.0; list rrd-users); Tue, 06 Jun 2006 02:54:55
+0200
Received: from localhost (tranquillity.ee.ethz.ch [129.132.2.222])by
smtp.ee.ethz.ch (Postfix) with ESMTP id 391C2D931Efor
<rrd-users at list.ee.ethz.ch>; Tue, 6 Jun 2006 02:54:36 +0200 (MEST)
Received: from smtp.ee.ethz.ch ([129.132.2.217]) by localhost (tranquillity
[129.132.2.222]) (amavisd-new, port 10024) with LMTP id 29059-01-5 for
<rrd-users at list.ee.ethz.ch>; Tue, 6 Jun 2006 02:54:35 +0200 (MEST)
Received: from nucfw06.abc.net.au (smtp.abc.net.au [203.2.218.145])by
smtp.ee.ethz.ch (Postfix) with ESMTP id 4CB56D9310for
<rrd-users at list.ee.ethz.ch>; Tue, 6 Jun 2006 02:54:34 +0200 (MEST)
X-Message-Info: LsUYwwHHNt0d7rsw4nyeW6mlik28Br/rQvcw9BdXod0=
X-Spam-Checker-Version: SpamAssassin 3.1.2 (2006-05-25) on thor.ee.ethz.ch
X-Spam-Level:
X-Spam-Status: No, score=-1.9 required=10.0 tests=AWL,BAYES_00 autolearn=ham
version=3.1.2
X-Original-To: rrd-users at list.ee.ethz.ch
Delivered-To: slist+rrd-users at ee.ethz.ch
Priority: normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506
Content-Class: urn:content-classes:message
X-MS-Has-Attach:
X-MS-TNEF-Correlator:
Thread-Topic: [rrd-users] Values in RRD are incorrect
thread-index: AcaIkwQeMEcFZTboQ+u+47v1dJZZ1AAcHYqA
X-OriginalArrivalTime: 06 Jun 2006 00:53:11.0531 (UTC)
FILETIME=[95A73BB0:01C68903]
X-Virus-Scanned: by amavisd-new at ee.ethz.ch
X-archive-position: 10716
X-ecartis-version: Ecartis v1.0.0
Errors-To: rrd-users-bounce at list.ee.ethz.ch
X-original-sender: Lewis.Darryl at abc.net.au
Precedence: bulk
List-help: <mailto:listar at list.ee.ethz.ch?Subject=help>
List-unsubscribe:
<mailto:rrd-users-request at list.ee.ethz.ch?Subject=unsubscribe>
List-software: Ecartis version 1.0.0
List-Id: <rrd-users.list-id.list.ee.ethz.ch>
X-List-ID: <rrd-users.list.ee.ethz.ch>
List-subscribe: <mailto:rrd-users-request at list.ee.ethz.ch?Subject=subscribe>
List-owner: <mailto:oetiker at ee.ethz.ch>
List-post: <mailto:rrd-users at list.ee.ethz.ch>
X-list: rrd-users
X-Virus-Scanned: by amavisd-new at ee.ethz.ch
Return-Path: rrd-users-bounce at list.ee.ethz.ch
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
--
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
More information about the rrd-users
mailing list