<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">It doesn't appear to matter which RRA I update -- I thought of that too. Whichever RRA I update the timestamps get corrupted.<div><br></div><div>Oddly, the base RRA goes centuries farther forward while the remaining RRAs all go back to 1969 while keeping the correct day. Machine timezone is UTC if that matters. I tried changing the TZ variable a few times with no apparent effect.</div><div><div><br><div><div>On Jul 12, 2012, at 7:38 PM, Joe Loiacono wrote:</div><blockquote type="cite"><div>Hmm. I used resize recently without any *apparent* problems. I will do a<br>review. I'm pretty sure I would have seen something along the lines of what<br>you've shown though.<br><br>I have a set of databases that mimics MRTG. I expanded the 'Last 3 Years'<br>rra (i.e., a derived one, not the base that you updated.)<br><br>v1.4.7.<br><br>Joe Loiacono<br><br><br><br><br>From:<span class="Apple-tab-span" style="white-space:pre"> </span>Jo Rhett <<a href="mailto:jrhett@netconsonance.com">jrhett@netconsonance.com</a>><br>To:<span class="Apple-tab-span" style="white-space:pre"> </span><a href="mailto:rrd-users@lists.oetiker.ch">rrd-users@lists.oetiker.ch</a><br>Date:<span class="Apple-tab-span" style="white-space:pre"> </span>07/12/2012 06:54 PM<br>Subject:<span class="Apple-tab-span" style="white-space:pre"> </span>[rrd-users] rrdtool resize corrupts timestamps in both 1.3.9<br> and<span class="Apple-tab-span" style="white-space:pre"> </span>1.4.7<br>Sent by:<span class="Apple-tab-span" style="white-space:pre"> </span>rrd-users-bounces+jloiacon=csc.com@lists.oetiker.ch<br><br><br><br>I found that doing a resize on an rrd file caused a total loss of data with<br>rrdtool 1.3.9 which is bundled with zenoss 3.2.1 on CentOS 5.<br>Investigating with the tools found that the data was there, but the<br>timestamps were corrupt.<br><br>So I grabbed rrdtool 1.4.7 and tried to use it and found that it has the<br>same problem on CentOS 5.<br><br>$ rrdtool dump testfile.rrd | head -40<br><?xml version="1.0" encoding="utf-8"?><br><!DOCTYPE rrd SYSTEM "http://oss.oetiker.ch/rrdtool/rrdtool.dtd"><br><!-- Round Robin Database Dump --><rrd> <version> 0003 </version><br><step> 15 </step> <!-- Seconds --><br><lastupdate> 1342133281 </lastupdate> <!-- 2012-07-12 15:48:01 PDT --><br><br><ds><br><name> ds0 </name><br><type> COUNTER </type><br><minimal_heartbeat> 45 </minimal_heartbeat><br><min> NaN </min><br><max> 1.0000000000e+04 </max><br><br><!-- PDP Status --><br><last_ds> 5585260819 </last_ds><br><value> 5.2688224977e+02 </value><br><unknown_sec> 0 </unknown_sec><br></ds><br><br><!-- Round Robin Archives --> <rra><br><cf> AVERAGE </cf><br><pdp_per_row> 1 </pdp_per_row> <!-- 15 seconds --><br><br><params><br><xff> 5.0000000000e-01 </xff><br></params><br><cdp_prep><br><ds><br><primary_value> 5.0500416920e+02 </primary_value><br><secondary_value> 5.0571394032e+02 </secondary_value><br><value> NaN </value><br><unknown_datapoints> 0 </unknown_datapoints><br></ds><br></cdp_prep><br><database><br><!-- 2012-07-12 13:18:15 PDT / 1342124295 --> <row><v> 5.2835238201e+02<br></v></row><br><!-- 2012-07-12 13:18:30 PDT / 1342124310 --> <row><v> 5.2950058206e+02<br></v></row><br><!-- 2012-07-12 13:18:45 PDT / 1342124325 --> <row><v> 5.3706333105e+02<br></v></row><br><!-- 2012-07-12 13:19:00 PDT / 1342124340 --> <row><v> 5.2656011537e+02<br></v></row><br><!-- 2012-07-12 13:19:15 PDT / 1342124355 --> <row><v> 5.0348379147e+02<br></v></row><br><br>$ rrdtool resize testfile.rrd 0 GROW 1416<br><br>$ rrdtool dump resize.rrd | head -40<br><?xml version="1.0" encoding="utf-8"?><br><!DOCTYPE rrd SYSTEM "http://oss.oetiker.ch/rrdtool/rrdtool.dtd"><br><!-- Round Robin Database Dump --><rrd> <version> 0003 </version><br><step> 15 </step> <!-- Seconds --><br><lastupdate> 4048795654275216693 </lastupdate> <!-- -547790155-01-11136<br>05:31:33 PST --><br><br><ds><br><name> ds0 </name><br><type> COUNTER </type><br><minimal_heartbeat> 45 </minimal_heartbeat><br><min> NaN </min><br><max> 1.0000000000e+04 </max><br><br><!-- PDP Status --><br><last_ds> </last_ds><br><value> 0.0000000000e+00 </value><br><unknown_sec> 0 </unknown_sec><br></ds><br><br><!-- Round Robin Archives --> <rra><br><cf> AVERAGE </cf><br><pdp_per_row> 1 </pdp_per_row> <!-- 15 seconds --><br><br><params><br><xff> 5.0000000000e-01 </xff><br></params><br><cdp_prep><br><ds><br><primary_value> 0.0000000000e+00 </primary_value><br><secondary_value> 0.0000000000e+00 </secondary_value><br><value> 0.0000000000e+00 </value><br><unknown_datapoints> 0 </unknown_datapoints><br></ds><br></cdp_prep><br><database><br><!-- -547790155-01-11136 21:07:45 PST / 892845857 --> <row><v> NaN<br></v></row><br><!-- -547790155-01-11136 21:08:00 PST / 892845872 --> <row><v> NaN<br></v></row><br><!-- -547790155-01-11136 21:08:15 PST / 892845887 --> <row><v> NaN<br></v></row><br><!-- -547790155-01-11136 21:08:30 PST / 892845902 --> <row><v> NaN<br></v></row><br><!-- -547790155-01-11136 21:08:45 PST / 892845917 --> <row><v> NaN<br></v></row><br><br>Let's find the first value that was in the old file.<br><br>$ rrdtool dump tmp.0.resize.rrd | grep 5.28352<br><!-- -547790155-01-11098 03:01:15 PST / 892867067 --> <row><v><br>5.2835238201e+02 </v></row><br><br>Hm. That's a way bit different timestamp than this record<br><!-- 2012-07-12 13:18:15 PDT / 1342124295 --> <row><v> 5.2835238201e+02<br></v></row><br><br>--<br>Jo Rhett<br>Net Consonance : net philanthropy to improve open source and internet<br>projects.<br><br><br>_______________________________________________<br>rrd-users mailing list<br>rrd-users@lists.oetiker.ch<br>https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users<br><br><br></div></blockquote></div><br><div>
<span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; font-size: medium; "><span class="Apple-style-span" style="font-size: 12px; "><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><font face="Helvetica" size="3" style="font: normal normal normal 12px/normal Helvetica; ">-- </font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><font face="Helvetica" size="3" style="font: normal normal normal 12px/normal Helvetica; ">Jo Rhett</font></div></span><span class="Apple-style-span" style="font-size: 12px; ">Net Consonance : </span><span class="Apple-style-span" style="font-size: 12px; ">net philanthropy to improve open source and internet projects.</span><br><span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div><div><span class="Apple-style-span" style="font-size: 12px; "><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><br></div></span></div></div></div></span></span><br class="Apple-interchange-newline">
</div>
<br></div></div></body></html>