<div dir="ltr"><div>Thanks for your efforts, I found culprit:<br></div><div><br></div><div>I created these rrd files in directory, for which there was cron which builds graphs, to make me easier see changes.</div><div>I found that if I create database file elsewhere, all was just as in your case. I dug further and found out that there is "historically" one more script, which periodically tries to get data from old place, and if there's no data just putting "0" into all rrd.</div>
<div>I turned off this old script, and now I have perfectly line with given value, no matter how un-periodically this happen.</div><div><br></div><div>Thanks again for you patience :)</div></div><div class="gmail_extra">
<br><br><div class="gmail_quote">2013/5/17 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">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;min-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" style="display:inline-block;overflow:hidden;text-overflow:ellipsis;white-space:nowrap;text-decoration:none;padding:1px 0px;border:none;width:100%" target="_blank"><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;min-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" style="display:inline-block;overflow:hidden;text-overflow:ellipsis;white-space:nowrap;text-decoration:none;padding:1px 0px;border:none;width:100%" target="_blank"><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>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"><div>
<div class="h5">
<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><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><font color="#888888">-- <br>Regards,<br>Alexander Yerenkow
</font></span></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>