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" <[EMAIL PROTECTED]> To: "Richard Marshall" <[EMAIL PROTECTED]>,<[email protected]> 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 <[email protected]>; 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 <[email protected]>; 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 <[email protected]>; 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: [email protected] Delivered-To: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] X-original-sender: [EMAIL PROTECTED] Precedence: bulk List-help: <mailto:[EMAIL PROTECTED]> List-unsubscribe: <mailto:[EMAIL PROTECTED]> 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:[EMAIL PROTECTED]> List-owner: <mailto:[EMAIL PROTECTED]> List-post: <mailto:[email protected]> X-list: rrd-users X-Virus-Scanned: by amavisd-new at ee.ethz.ch Return-Path: [EMAIL PROTECTED] Are you setting the rrd to AVERAGE, GAUGE, COUNTER ? -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Richard Marshall Sent: Monday, 5 June 2006 8:57 PM To: [email protected] 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:[EMAIL PROTECTED] Help mailto:[EMAIL PROTECTED] 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:[EMAIL PROTECTED] Help mailto:[EMAIL PROTECTED] Archive http://lists.ee.ethz.ch/rrd-users WebAdmin http://lists.ee.ethz.ch/lsg2.cgi -- Unsubscribe mailto:[EMAIL PROTECTED] Help mailto:[EMAIL PROTECTED] Archive http://lists.ee.ethz.ch/rrd-users WebAdmin http://lists.ee.ethz.ch/lsg2.cgi
