<div dir="ltr">With the following script I get the following expected graph. If you don't get that graph, then something is wrong with your system.<div><br></div><div><br><div class="gmail_drive_chip" style="width:396px;height:18px;max-height:18px;background-color:#f5f5f5;padding:5px;color:#222;font-family:arial;font-style:normal;font-weight:bold;font-size:13px;border:1px solid #ddd">
<a href="https://docs.google.com/file/d/0B1T6TeYwG0lodWE4S0I5NGk0SE0/edit?usp=drive_web" target="_blank" style="display:inline-block;overflow:hidden;text-overflow:ellipsis;white-space:nowrap;text-decoration:none;padding:1px 0px;border:none;width:100%"><img style="vertical-align: bottom; border: none;" src="https://ssl.gstatic.com/docs/doclist/images/icon_10_generic_list.png"> <span dir="ltr" style="color:#15c;text-decoration:none;vertical-align:bottom">test.sh</span></a></div>
<br><div class="gmail_drive_chip" style="width:396px;height:18px;max-height:18px;background-color:#f5f5f5;padding:5px;color:#222;font-family:arial;font-style:normal;font-weight:bold;font-size:13px;border:1px solid #ddd">
<a href="https://docs.google.com/file/d/0B1T6TeYwG0lodTUxVWg0alVSSDQ/edit?usp=drive_web" target="_blank" style="display:inline-block;overflow:hidden;text-overflow:ellipsis;white-space:nowrap;text-decoration:none;padding:1px 0px;border:none;width:100%"><img style="vertical-align: bottom; border: none;" src="https://ssl.gstatic.com/docs/doclist/images/icon_10_generic_list.png"> <span dir="ltr" style="color:#15c;text-decoration:none;vertical-align:bottom">testing2.png</span></a></div>
<br></div><div style>Without seeing the exact script you are running, it's hard to know if there is some subtle thing that you are doing that is causing the problem.</div><div><br></div></div><div class="gmail_extra">
<br><br><div class="gmail_quote">On 16 May 2013 22:16, 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"><br><div>Donovan!</div><div>With your script I got all values set to 5, as I can see both in dump and graph.</div><div>1. But from your email I didn't got clear info that you tried to run script with delays and "N:", is that correct?</div>
<div><br></div><div>2. If I simply put in `for` cycle "sleep 63" and change update not to use calculated time, but instead N:5, I got these data seen in dump:</div><div><br></div><div> <!-- 2013-05-16 23:11:00 EEST / 1368735060 --> <row><v>NaN</v></row> │<br>
<!-- 2013-05-16 23:12:00 EEST / 1368735120 --> <row><v>1.7920090000e+00</v></row> │<br> <!-- 2013-05-16 23:13:00 EEST / 1368735180 --> <row><v>3.5915094167e+00</v></row> │<br>
<!-- 2013-05-16 23:14:00 EEST / 1368735240 --> <row><v>3.8415422500e+00</v></row> │</div><div><br></div><div>Here's my for cycle (for clarification):</div>
<div><br></div><div>for ((t=$start; t<=$start+60*63; t=t+63 )); do<br>echo $t<br>rrdtool update testing3.rrd N:5;<br>sleep 63<br>done</div><div><br></div><div>I see some weird bug when N used, that's at least.</div>
<div>Can anyone confirm present or absent of such behavior?</div><div>Thanks.</div><div><br></div><div><br></div></div><div class="gmail_extra"><div><div class="h5"><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">I don't get that result at all... I'm using RRDtool 1.4.7 on a Debian system.<div><br></div><div>
Are you sure you are using GAUGE and not something like ABSOLUTE?</div><div><br></div><div>Some minor funnies in what you are doing is using step "-s 60" when creating your rrd, and -S 1 when generating your graph. This means your data is only resolution 60, and you are asking it to give you a 1 second resolution graph. However, that should not cause what you are seeing.<br>
<div><div><br></div><div>In your graph cmd you have "CDEF:realcnt=cnt,1,* LINE:realcnt#00A000:Cnt", which means you have an unnecessary multiply by 1 and you could just use; "LINE:cnt#00A000:Cnt".</div>
<div><br></div><div>Try running the attached script and having a look at the testing2.png output. I definitely don't get any strange stepping. If you do, then I'd suspect something strange on your platform.</div>
</div></div><div><br></div></div><div class="gmail_extra"><div><div><br><br><div class="gmail_quote">On 16 May 2013 18:40, 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>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"><div><div>
<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><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><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></div></div><span><font color="#888888">-- <br>Regards,<br>Alexander Yerenkow
</font></span></div>
</blockquote></div><br><br clear="all"><div><br></div></div></div><span><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></div></div><span class="HOEnZb"><font color="#888888">-- <br>Regards,<br>Alexander Yerenkow
</font></span></div>
</blockquote></div><br><br clear="all"><div><br></div>-- <br>Donovan Baarda <<a href="mailto:abo@minkirri.apana.org.au">abo@minkirri.apana.org.au</a>>
</div>