<div dir="ltr"><div>This is my command.<br></div><div><br></div><div>rrdtool create -s 60 testing2.rrd DS:cnt:GAUGE:120:U:U RRA:AVERAGE:0.5:1:1440 RRA:AVERAGE:0.5:60:720 RRA:AVERAGE:0.5:1440:365 </div><div><br></div><div>graph:</div>
<div><br></div><div>rrdtool graph testing2.png -s -1200 -S 1 -a PNG -w 1000 -h 250 -v "testing" DEF:cnt= testing2.rrd:cnt:AVERAGE CDEF:realcnt=cnt,1,* LINE:realcnt#00A000:Cnt</div><div><br></div><div>Even if I got problem in graph, how do I get not "5" in dump:</div>
<div><br></div><div> <!-- 2013-05-16 16:49:00 EEST / 1368712140 --> <row><v>4.8531933333e+00</v></row><br> <!-- 2013-05-16 16:50:00 EEST / 1368712200 --> <row><v>0.0000000000e+00</v></row><br>
<!-- 2013-05-16 16:51:00 EEST / 1368712260 --> <row><v>1.9154833333e-01</v></row><br> <!-- 2013-05-16 16:52:00 EEST / 1368712320 --> <row><v>4.4032950000e-01</v></row><br>
<!-- 2013-05-16 16:53:00 EEST / 1368712380 --> <row><v>6.8845091667e-01</v></row><br> <!-- 2013-05-16 16:54:00 EEST / 1368712440 --> <row><v>9.4017525000e-01</v></row><br>
</div><div><br></div><div>Could anyone *please* run this test?</div><div>create testing db, and gather there data with my script (with real delays one), and not via dumping into file a lot of data in just moment...</div><div>
<br></div><div>I'll need or confirmation that it's somehow my only problem, or we'll get know that problem elsewhere.</div><div>Thanks.</div><div><br></div></div><div class="gmail_extra"><br><br><div class="gmail_quote">
2013/5/16 Donovan Baarda <span dir="ltr"><<a href="mailto:abo@minkirri.apana.org.au" target="_blank">abo@minkirri.apana.org.au</a>></span><br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="ltr">What does your rrdtool create and graph lines look like? I suspect that's where the error lies.<div><br></div><div><br></div></div><div class="gmail_extra"><div><div class="h5"><br><br><div class="gmail_quote">
On 16 May 2013 16:01, Alexander Yerenkow <span dir="ltr"><<a href="mailto:yerenkow@gmail.com" target="_blank">yerenkow@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div>Thanks for hint, but this is working only when invoking at moment of time.<br></div><div>E.g. If I run script </div>
<div><br></div><div>tt=`jot - 1 30` <br>
for i in $tt <br>do <br>
t=`date +"%s"` <br>rrdtool update testing.rrd $t:5; rrdtool update testing2.rrd N:5; <br>
sleep 63; <br>done </div>
<div><br></div><div>I still see same seesaw graph (I changed from 61 to 63 to make problem more visible).</div><div>The script was run on fresh created two files, according your command. </div><div>The problem (if there is problem) lies somewhere in some rounding time, as it seems appear in both files, when I specify N, and time.</div>
<div>Here's my fresh graphs:</div><div><a href="https://javaz.org/wp-content/testing.rrd-avg.png" target="_blank">https://javaz.org/wp-content/testing.rrd-avg.png</a></div><div><a href="https://javaz.org/wp-content/testing2.rrd-avg.png" target="_blank">https://javaz.org/wp-content/testing2.rrd-avg.png</a></div>
<div><br></div><div>Could you confirm that if you run my script (with real half-hour datamining) you will have same good-looking graph?</div><div><br></div><div>BTW, I'm using rrdtool-1.4.7.</div><div><br></div><div>
<br>
</div><div class="gmail_extra"><br><br><div class="gmail_quote">2013/5/16 Donovan Baarda <br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div>
G'day Alexander,<div>
<br></div><div>You need to read <a href="http://oss.oetiker.ch/rrdtool/doc/rrdcreate.en.html" target="_blank">http://oss.oetiker.ch/rrdtool/doc/rrdcreate.en.html</a>, in particular the bit towards the end about "The Heartbeat and the Step". In particular, heartbeat on the DSS is the *maximum" time between samples, otherwise they are thrown away and recorded as unknown. You can think of step/heartbeat as the "xff" of the input data. In your case I'm guessing using step=60 and heartbeat=120 is probably closest to what you want.</div>
<div><br></div><div>I looked at your seesaw-graphs blog entry and the graph you have looks like a kind of artefact of using a low heartbeat (resulting in very few valid inputs) combined with a low xff or maybe graphing options to interpolate the missing values. When i do the following;</div>
<div><br></div><div>$ rrdtool create -s 60 testing.rrd DS:cnt:GAUGE:120:U:U RRA:AVERAGE:0.5:1:1440 RRA:AVERAGE:0.5:60:720 RRA:AVERAGE:0.5:1440:365</div><div><div>$ t=`date +"%s"`</div><div>$ for ((i=$t; i<$t+60*61; i=$i+61)); do rrdtool update testing.rrd $i:5; done<br>
</div><div><div>$ rrdtool graph testing.png -s $t -S 60 DEF:cnt=testing.rrd:cnt:AVERAGE LINE1:cnt#ff0000:cnt</div></div><div><br></div><div>I get the following graph;</div><div><br></div><div><a href="http://minkirri.apana.org.au/~abo/testing.png" target="_blank"></a><br>
</div></div><div><br></div></div><div><div>Which is probably what you expect.</div></div></div><div><div class="gmail_extra"><br><br><div class="gmail_quote"><div><div>On 15 May 2013 11:03, Alexander Yerenkow <span dir="ltr"><<a href="mailto:yerenkow@gmail.com" target="_blank">yerenkow@gmail.com</a>></span> wrote:<br>
</div></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div><div dir="ltr"><div>Hello list!</div><div>I'm having problem with GAUGE and non-regular updates of values, I described my problem fully here:<br>
</div><br><a href="https://javaz.org/2013/05/rrdtool-strange-rounding-produces-seesaw-graphs/" target="_blank">https://javaz.org/2013/05/rrdtool-strange-rounding-produces-seesaw-graphs/</a><br>
<br><div>I'd appreciate if you point me to right place where I find why I can't get what I need.<br clear="all"></div><div><br></div><div>I already tried to tune heartbeat value, but to no avail.</div><span><font color="#888888"><div>
<br></div>
<br>-- <br>Regards,<br>Alexander Yerenkow
</font></span></div>
<br></div></div>_______________________________________________<br>
rrd-users mailing list<br>
<a href="mailto:rrd-users@lists.oetiker.ch" target="_blank">rrd-users@lists.oetiker.ch</a><br>
<a href="https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users" target="_blank">https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users</a><br>
<br></blockquote></div><span><font color="#888888"><br><br clear="all"><div><br></div>-- <br>Donovan Baarda </font></span></div>
</div></blockquote></div><span><font color="#888888"><br><br clear="all"><br>-- <br>Regards,<br>Alexander Yerenkow
</font></span></div></div>
</blockquote></div><br><br clear="all"><div><br></div></div></div><span class="HOEnZb"><font color="#888888">-- <br>Donovan Baarda <<a href="mailto:abo@minkirri.apana.org.au" target="_blank">abo@minkirri.apana.org.au</a>>
</font></span></div>
</blockquote></div><br><br clear="all"><br>-- <br>Regards,<br>Alexander Yerenkow
</div>