<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=iso-8859-1" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.6001.19088">
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT size=2 face=Arial>Guys,</FONT></DIV>
<DIV><FONT size=2 face=Arial>
Any update on this issue is appreciated as i have to understand how rrd fetch vs
xport works and why the result is different.</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>Regards</FONT></DIV>
<DIV><FONT size=2 face=Arial>swami</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV style="FONT: 10pt arial">----- Original Message -----
<DIV style="BACKGROUND: #e4e4e4; font-color: black"><B>From:</B> <A
title=swami@infineta.com href="mailto:swami@infineta.com">swami</A> </DIV>
<DIV><B>To:</B> <A title=rrd-users@lists.oetiker.ch
href="mailto:rrd-users@lists.oetiker.ch">rrd-users@lists.oetiker.ch</A> ; <A
title=rrd-developers@lists.oetiker.ch
href="mailto:rrd-developers@lists.oetiker.ch">rrd-developers@lists.oetiker.ch</A>
</DIV>
<DIV><B>Sent:</B> Friday, July 22, 2011 2:25 PM</DIV>
<DIV><B>Subject:</B> RRDTOOL fetch vs xport (shows rows with different step
value)</DIV></DIV>
<DIV><BR></DIV>
<DIV><FONT size=2 face=Arial>Hi All,</FONT></DIV>
<DIV><FONT size=2
face=Arial> Have created a
RRD and am finding that rrdtool xport and fetch gives me the rows at
different step value as shown below.</FONT></DIV>
<DIV><FONT size=2 face=Arial>Can someone explain why it should be different
?</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>RRDTOOL version:1.4.5</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial><STRONG>Output of rrdtool info yr.rrd: (note , its
created with step as 3 secs , to have pdp's of 3secs apart for 3
months and pdp daily apart for 1 yr)</STRONG></FONT></DIV>
<DIV><FONT size=2 face=Arial>filename = "yr.rrd"<BR>rrd_version = "0003"<BR>step
= 3<BR>last_update = 1311358529<BR>header_size =
6524<BR>ds[AccelTrafficBytesIn].index = 0<BR>ds[AccelTrafficBytesIn].type =
"GAUGE"<BR>ds[AccelTrafficBytesIn].minimal_heartbeat =
10<BR>ds[AccelTrafficBytesIn].min =
0.0000000000e+00<BR>ds[AccelTrafficBytesIn].max =
NaN<BR>ds[AccelTrafficBytesIn].last_ds = "U"<BR>ds[AccelTrafficBytesIn].value =
0.0000000000e+00<BR>ds[AccelTrafficBytesIn].unknown_sec =
2<BR>ds[PThruTrafficBytesIn].index = 1<BR>ds[PThruTrafficBytesIn].type =
"GAUGE"<BR>ds[PThruTrafficBytesIn].minimal_heartbeat =
10<BR>ds[PThruTrafficBytesIn].min =
0.0000000000e+00<BR>ds[PThruTrafficBytesIn].max =
NaN<BR>ds[PThruTrafficBytesIn].last_ds = "U"<BR>ds[PThruTrafficBytesIn].value =
0.0000000000e+00<BR>ds[PThruTrafficBytesIn].unknown_sec =
2<BR>ds[GoodPutBytesOut].index = 2<BR>ds[GoodPutBytesOut].type =
"GAUGE"<BR>ds[GoodPutBytesOut].minimal_heartbeat = 10<BR>ds[GoodPutBytesOut].min
= 0.0000000000e+00<BR>ds[GoodPutBytesOut].max =
NaN<BR>ds[GoodPutBytesOut].last_ds = "U"<BR>ds[GoodPutBytesOut].value =
0.0000000000e+00<BR>ds[GoodPutBytesOut].unknown_sec =
2<BR>ds[GoodPutBytesIn].index = 3<BR>ds[GoodPutBytesIn].type =
"GAUGE"<BR>ds[GoodPutBytesIn].minimal_heartbeat = 10<BR>ds[GoodPutBytesIn].min =
0.0000000000e+00<BR>ds[GoodPutBytesIn].max = NaN<BR>ds[GoodPutBytesIn].last_ds =
"U"<BR>ds[GoodPutBytesIn].value =
0.0000000000e+00<BR>ds[GoodPutBytesIn].unknown_sec =
2<BR>ds[WanPThruBytesIn].index = 4<BR>ds[WanPThruBytesIn].type =
"GAUGE"<BR>ds[WanPThruBytesIn].minimal_heartbeat = 10<BR>ds[WanPThruBytesIn].min
= 0.0000000000e+00<BR>ds[WanPThruBytesIn].max =
NaN<BR>ds[WanPThruBytesIn].last_ds = "U"<BR>ds[WanPThruBytesIn].value =
0.0000000000e+00<BR>ds[WanPThruBytesIn].unknown_sec = 2<BR>ds[BytesOut].index =
5<BR>ds[BytesOut].type = "GAUGE"<BR>ds[BytesOut].minimal_heartbeat =
10<BR>ds[BytesOut].min = 0.0000000000e+00<BR>ds[BytesOut].max =
NaN<BR>ds[BytesOut].last_ds = "U"<BR>ds[BytesOut].value =
0.0000000000e+00<BR>ds[BytesOut].unknown_sec = 2<BR>ds[LanBytesIn].index =
6<BR>ds[LanBytesIn].type = "GAUGE"<BR>ds[LanBytesIn].minimal_heartbeat =
10<BR>ds[LanBytesIn].min = 0.0000000000e+00<BR>ds[LanBytesIn].max =
NaN<BR>ds[LanBytesIn].last_ds = "U"<BR>ds[LanBytesIn].value =
0.0000000000e+00<BR>ds[LanBytesIn].unknown_sec = 2<BR>ds[Reduction].index =
7<BR>ds[Reduction].type = "GAUGE"<BR>ds[Reduction].minimal_heartbeat =
10<BR>ds[Reduction].min = 0.0000000000e+00<BR>ds[Reduction].max =
NaN<BR>ds[Reduction].last_ds = "U"<BR>ds[Reduction].value =
0.0000000000e+00<BR>ds[Reduction].unknown_sec = 2<BR>rra[0].cf =
"AVERAGE"<BR>rra[0].rows = 1712000<BR>rra[0].cur_row =
985084<BR>rra[0].pdp_per_row = 1<BR>rra[0].xff =
5.0000000000e-01<BR>rra[0].cdp_prep[0].value =
NaN<BR>rra[0].cdp_prep[0].unknown_datapoints = 0<BR>rra[0].cdp_prep[1].value =
NaN<BR>rra[0].cdp_prep[1].unknown_datapoints = 0<BR>rra[0].cdp_prep[2].value =
NaN<BR>rra[0].cdp_prep[2].unknown_datapoints = 0<BR>rra[0].cdp_prep[3].value =
NaN<BR>rra[0].cdp_prep[3].unknown_datapoints = 0<BR>rra[0].cdp_prep[4].value =
NaN<BR>rra[0].cdp_prep[4].unknown_datapoints = 0<BR>rra[0].cdp_prep[5].value =
NaN<BR>rra[0].cdp_prep[5].unknown_datapoints = 0<BR>rra[0].cdp_prep[6].value =
NaN<BR>rra[0].cdp_prep[6].unknown_datapoints = 0<BR>rra[0].cdp_prep[7].value =
NaN<BR>rra[0].cdp_prep[7].unknown_datapoints = 0<BR>rra[1].cf =
"AVERAGE"<BR>rra[1].rows = 365<BR>rra[1].cur_row = 187<BR>rra[1].pdp_per_row =
28800<BR>rra[1].xff = 5.0000000000e-01<BR>rra[1].cdp_prep[0].value =
NaN<BR>rra[1].cdp_prep[0].unknown_datapoints = 21909<BR>rra[1].cdp_prep[1].value
= NaN<BR>rra[1].cdp_prep[1].unknown_datapoints =
21909<BR>rra[1].cdp_prep[2].value = NaN<BR>rra[1].cdp_prep[2].unknown_datapoints
= 21909<BR>rra[1].cdp_prep[3].value =
NaN<BR>rra[1].cdp_prep[3].unknown_datapoints = 21909<BR>rra[1].cdp_prep[4].value
= NaN<BR>rra[1].cdp_prep[4].unknown_datapoints =
21909<BR>rra[1].cdp_prep[5].value = NaN<BR>rra[1].cdp_prep[5].unknown_datapoints
= 21909<BR>rra[1].cdp_prep[6].value =
NaN<BR>rra[1].cdp_prep[6].unknown_datapoints = 21909<BR>rra[1].cdp_prep[7].value
= NaN<BR>rra[1].cdp_prep[7].unknown_datapoints = 21909<BR>rra[2].cf =
"MAX"<BR>rra[2].rows = 1712000<BR>rra[2].cur_row = 1120126<BR>rra[2].pdp_per_row
= 1<BR>rra[2].xff = 5.0000000000e-01<BR>rra[2].cdp_prep[0].value =
NaN<BR>rra[2].cdp_prep[0].unknown_datapoints = 0<BR>rra[2].cdp_prep[1].value =
NaN<BR>rra[2].cdp_prep[1].unknown_datapoints = 0<BR>rra[2].cdp_prep[2].value =
NaN<BR>rra[2].cdp_prep[2].unknown_datapoints = 0<BR>rra[2].cdp_prep[3].value =
NaN<BR>rra[2].cdp_prep[3].unknown_datapoints = 0<BR>rra[2].cdp_prep[4].value =
NaN<BR>rra[2].cdp_prep[4].unknown_datapoints = 0<BR>rra[2].cdp_prep[5].value =
NaN<BR>rra[2].cdp_prep[5].unknown_datapoints = 0<BR>rra[2].cdp_prep[6].value =
NaN<BR>rra[2].cdp_prep[6].unknown_datapoints = 0<BR>rra[2].cdp_prep[7].value =
NaN<BR>rra[2].cdp_prep[7].unknown_datapoints = 0<BR>rra[3].cf =
"MAX"<BR>rra[3].rows = 365<BR>rra[3].cur_row = 105<BR>rra[3].pdp_per_row =
28800<BR>rra[3].xff = 5.0000000000e-01<BR>rra[3].cdp_prep[0].value =
NaN<BR>rra[3].cdp_prep[0].unknown_datapoints = 21909<BR>rra[3].cdp_prep[1].value
= NaN<BR>rra[3].cdp_prep[1].unknown_datapoints =
21909<BR>rra[3].cdp_prep[2].value = NaN<BR>rra[3].cdp_prep[2].unknown_datapoints
= 21909<BR>rra[3].cdp_prep[3].value =
NaN<BR>rra[3].cdp_prep[3].unknown_datapoints = 21909<BR>rra[3].cdp_prep[4].value
= NaN<BR>rra[3].cdp_prep[4].unknown_datapoints =
21909<BR>rra[3].cdp_prep[5].value = NaN<BR>rra[3].cdp_prep[5].unknown_datapoints
= 21909<BR>rra[3].cdp_prep[6].value =
NaN<BR>rra[3].cdp_prep[6].unknown_datapoints = 21909<BR>rra[3].cdp_prep[7].value
= NaN<BR>rra[3].cdp_prep[7].unknown_datapoints = 21909<BR>rra[4].cf =
"LAST"<BR>rra[4].rows = 1712000<BR>rra[4].cur_row = 568409<BR>rra[4].pdp_per_row
= 1<BR>rra[4].xff = 5.0000000000e-01<BR>rra[4].cdp_prep[0].value =
NaN<BR>rra[4].cdp_prep[0].unknown_datapoints = 0<BR>rra[4].cdp_prep[1].value =
NaN<BR>rra[4].cdp_prep[1].unknown_datapoints = 0<BR>rra[4].cdp_prep[2].value =
NaN<BR>rra[4].cdp_prep[2].unknown_datapoints = 0<BR>rra[4].cdp_prep[3].value =
NaN<BR>rra[4].cdp_prep[3].unknown_datapoints = 0<BR>rra[4].cdp_prep[4].value =
NaN<BR>rra[4].cdp_prep[4].unknown_datapoints = 0<BR>rra[4].cdp_prep[5].value =
NaN<BR>rra[4].cdp_prep[5].unknown_datapoints = 0<BR>rra[4].cdp_prep[6].value =
NaN<BR>rra[4].cdp_prep[6].unknown_datapoints = 0<BR>rra[4].cdp_prep[7].value =
NaN<BR>rra[4].cdp_prep[7].unknown_datapoints = 0<BR>rra[5].cf =
"LAST"<BR>rra[5].rows = 365<BR>rra[5].cur_row = 60<BR>rra[5].pdp_per_row =
28800<BR>rra[5].xff = 5.0000000000e-01<BR>rra[5].cdp_prep[0].value =
NaN<BR>rra[5].cdp_prep[0].unknown_datapoints = 21909<BR>rra[5].cdp_prep[1].value
= NaN<BR>rra[5].cdp_prep[1].unknown_datapoints =
21909<BR>rra[5].cdp_prep[2].value = NaN<BR>rra[5].cdp_prep[2].unknown_datapoints
= 21909<BR>rra[5].cdp_prep[3].value =
NaN<BR>rra[5].cdp_prep[3].unknown_datapoints = 21909<BR>rra[5].cdp_prep[4].value
= NaN<BR>rra[5].cdp_prep[4].unknown_datapoints =
21909<BR>rra[5].cdp_prep[5].value = NaN<BR>rra[5].cdp_prep[5].unknown_datapoints
= 21909<BR>rra[5].cdp_prep[6].value =
NaN<BR>rra[5].cdp_prep[6].unknown_datapoints = 21909<BR>rra[5].cdp_prep[7].value
= NaN<BR>rra[5].cdp_prep[7].unknown_datapoints = 21909<BR></FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial><STRONG>Snaphost of output of rrdtool xport for
now-1600s shows rows at 6 secs apart :</STRONG></FONT></DIV>
<DIV><FONT size=2 face=Arial>#rrdtool xport -s now-1600s -e now --step 3
DEF:AccelTrafficBytesIn=yr.rrd:AccelTrafficBytesIn:AVERAGE
XPORT:AccelTrafficBytesIn</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial><xport><BR>
<meta><BR>
<start>1311367668</start><BR>
<step>6</step><BR>
<end>1311369270</end><BR>
<rows>268</rows><BR>
<columns>1</columns><BR>
<legend><BR>
<entry></entry><BR> </legend><BR>
</meta><BR> <data><BR>
<row><t>1311367668</t><v>NaN</v></row><BR>
<row><t>1311367674</t><v>NaN</v></row><BR>
<row><t>1311367680</t><v>NaN</v></row></FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial><STRONG>Snapshot of the output from rrdtool fetch
for now-1600s shows rows at 3 secs apart:</STRONG></FONT></DIV>
<DIV><FONT size=2 face=Arial>#rrdtool fetch yr.rrd AVERAGE -s now-1600s -e
now</FONT></DIV>
<DIV><FONT size=2
face=Arial>
AccelTrafficBytesIn PThruTrafficBytesIn
GoodPutBytesOut
Goo<BR>dPutBytesIn
WanPThruBytesIn
BytesOut
LanBytesIn<BR> Reduction</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=2 face=Arial>1311368013: nan nan nan nan nan nan nan
nan<BR>1311368016: nan nan nan nan nan nan nan nan<BR>1311368019: nan nan nan
nan nan nan nan nan<BR>1311368022: nan nan nan nan nan nan nan
nan<BR></FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>Regards</FONT></DIV>
<DIV><FONT size=2 face=Arial>swami</FONT></DIV>
<DIV><FONT size=2 face=Arial> </DIV></FONT></BODY></HTML>