[rrd-users] Strange issue with large step value

[_ JvG _]

I did what you asked:

rrdtool create pymeter-weekdata.rrd \
    --start 1419184800 \
    --step 3600 \
    DS:qtotal:COUNTER:604800:0:100000 \
    RRA:AVERAGE:0.5:1:8904 \
    RRA:AVERAGE:0.5:168:53

rrdtool update pymeter-weekdata.rrd 1419789600:50628
rrdtool update pymeter-weekdata.rrd 1420394400:50803
rrdtool update pymeter-weekdata.rrd 1420999200:50959
rrdtool update pymeter-weekdata.rrd 1421604000:51120

rrdtool xport  \
    --start 1419184800 \
    --end 1425236400 \
    --step 604800  \
    DEF:Qtotal=pymeter-weekdata.rrd:qtotal:AVERAGE \
    CDEF:QTot=Qtotal,604800,*,100,/  \
    XPORT:QTot:"Usage\n"

<?xml version="1.0" encoding="ISO-8859-1"?>

<xport>
  <meta>
    <start>1419465600</start>
    <step>604800</step>
    <end>1419465600</end>
    <rows>11</rows>
    <columns>1</columns>
    <legend>
      <entry>Usage\n</entry>
    </legend>
  </meta>
  <data>
    <row><t>1419465600</t><v>NaN</v></row>
    <row><t>1420070400</t><v>NaN</v></row>
    <row><t>1420675200</t><v>1.6617857143e+00</v></row>
    <row><t>1421280000</t><v>1.5832142857e+00</v></row>
    <row><t>1421884800</t><v>NaN</v></row>
    <row><t>1422489600</t><v>NaN</v></row>
    <row><t>1423094400</t><v>NaN</v></row>
    <row><t>1423699200</t><v>NaN</v></row>
    <row><t>1424304000</t><v>NaN</v></row>
    <row><t>1424908800</t><v>NaN</v></row>
    <row><t>1425513600</t><v>NaN</v></row>
  </data>
</xport>


the data in the new table is even more off...


    <row><t>1419804000</t><v>1.0416666667e-02</v></row>
    <row><t>1420380000</t><v>1.0416666667e-02</v></row>
.
.
.
    <row><t>1420398000</t><v>1.0190476190e-02</v></row>
    <row><t>1420416000</t><v>9.2857142857e-03</v></row>
.
.
.
    <row><t>1420992000</t><v>9.2857142857e-03</v></row>
    <row><t>1421010000</t><v>9.4642857143e-03</v></row>
    <row><t>1421028000</t><v>9.5833333333e-03</v></row>
.
.
.
    <row><t>1421604000</t><v>9.5833333333e-03</v></row>


Ans the problem is still there.
I've did some more tests with different heartbeats with the same results.
I do not get your remark that my input is wrong...

Please help



On Tue, May 5, 2015 at 7:51 AM, Alex van den Bogaerdt <
alex at vandenbogaerdt.nl> wrote:

> Please explain how I convert the above example to an hourly database
>> without recalculating the values
>>
>
> Create a new database to test, investigate and learn.
>
> The step size should be divided by 168 (and then becomes 3600), the amount
> of rows should be multiplied by 168 (to store the same amount of time), and
> then feed the same data (rrdtool will update more than one row at a time,
> no problem).
>
> --step 3600
> RRA:AVERAGE:0.5:1:8904
>
> Now use "rrdtool dump" and open the resulting file with a text editor to
> get an idea what is inside this database.
>
> Repeat the excercise, now with two RRAs:
>
> --step 3600
> RRA:AVERAGE:0.5:1:8904
> RRA:AVERAGE:0.5:168:53
>
> This second RRA should be very much the same as what you get now: one
> entry for every week, 53 times.
>
> Depending on the results you can test further. Still no data? Perhaps
> there's something wrong with your heartbeat settings, or your min/max
> settings. Data, but not what you expect? Then the input is not what you
> expect.
>
> After looking at this, do your "rrdtool xport" again and compare against
> the "rrdtool dump" results. Does it do what you think it should do.
>
>
>
>
>
> _______________________________________________
> rrd-users mailing list
> rrd-users at lists.oetiker.ch
> https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users
>



-- 
_ JvG _
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.oetiker.ch/pipermail/rrd-users/attachments/20150505/281957ac/attachment.html>