<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.6001.18349" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY>
<DIV><FONT face=Arial size=2>Hi Tobi,</FONT></DIV>
<DIV><FONT face=Arial
size=2>
I tried with 1.3.9 and 1.4.2 and the issue is still seen as shown below in the
snapshot (rrdtool xport not returning rows whereas rrdtool fetch returns a
row).</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>One more thing to observe is that the
ouput of rrdtool fetch below shows just one record with the time as
<STRONG>1262886600 which is not in the range of time given in the
command.</STRONG></FONT></DIV>
<DIV><FONT face=Arial size=2>When i execute rrd_fetch from php with the same
parameters used as in the command below, i get the ret['start'] as 1262886000
which is correct .</FONT></DIV>
<DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>You want any other inputs ? How to debug this
further.</FONT></DIV></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>[root@dev006 build_1.4.2]#
/usr/local/software/rrd/bin/rrdtool<BR>RRDtool 1.4.2 Copyright 1997-2009
by Tobias Oetiker <</FONT><A href="mailto:tobi@oetiker.ch"><FONT face=Arial
size=2>tobi@oetiker.ch</FONT></A><FONT face=Arial
size=2>><BR>
Compiled Jan 8 2010 09:36:16</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Usage: rrdtool [options] command
command_options</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Valid commands: create, update, updatev, graph,
graphv, dump,
restore,<BR>
last, lastupdate, first, info, fetch,
tune,<BR>
resize, xport, flushcached</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>RRDtool is distributed under the Terms of the GNU
General<BR>Public License Version 2. (</FONT><A
href="http://www.gnu.org/copyleft/gpl.html"><FONT face=Arial
size=2>www.gnu.org/copyleft/gpl.html</FONT></A><FONT face=Arial
size=2>)</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>For more information read the RRD
manpages</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2><STRONG>[root@dev006 build_1.4.2]#
/usr/local/third-party/rrd/bin/rrdtool xport --step 3 -s 1262886000 -e
1262886120</STRONG>
DEF:aval=/var/stats/rrd_data/service_class_data/service_class_TESTSC04.rrd:AccelTrafficBytesIn:AVERAGE
DEF:bval=/var/stats/rrd_data/service_class_data/service_class_TESTSC04.rrd:BytesOut:AVERAGE
DEF:cval=/var/stats/rrd_data/service_class_data/service_class_TESTSC04.rrd:GoodPutBytesIn:AVERAGE
DEF:dval=/var/stats/rrd_data/service_class_data/service_class_TESTSC04.rrd:GoodPutBytesOut:AVERAGE
CDEF:a=aval,UN,0,aval,IF,8,* CDEF:b=bval,UN,0,bval,IF,8,*
CDEF:c=cval,UN,0,cval,IF,8,* CDEF:d=dval,UN,0,dval,IF,8,* CDEF:dr1=d,100,*,a,/
CDEF:dr=100,dr1,- CDEF:ci=a,d,/ CDEF:civ=ci,UN,1,ci,IF CDEF:cival=civ,1,MAX
XPORT:dr XPORT:cival XPORT:a XPORT:b XPORT:c XPORT:d<BR><?xml version="1.0"
encoding="ISO-8859-1"?></FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2><xport><BR>
<meta><BR>
<STRONG><start>1262886600</start><BR>
<step>600</step><BR>
<end>1262886000</end></STRONG><BR>
<rows>0</rows><BR>
<columns>6</columns><BR>
<legend><BR>
<entry></entry><BR>
<entry></entry><BR>
<entry></entry><BR>
<entry></entry><BR>
<entry></entry><BR>
<entry></entry><BR> </legend><BR>
</meta><BR> <data><BR>
</data><BR></xport><BR><STRONG>[root@dev006 build_1.4.2]#
/usr/local/third-party/rrd/bin/rrdtool fetch
/var/stats/rrd_data/service_class_data/service_class_TESTSC04.rrd AVERAGE -r 3
-s 1262886000 -e
1262886180<BR></STRONG>
AccelTrafficBytesIn PThruTrafficBytesIn
GoodPutBytesOut
GoodPutBytesIn
WanPThruBytesIn
BytesOut</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2><STRONG>1262886600:</STRONG> 4.3554497354e+02
0.0000000000e+00 1.6151587302e+02 5.8164285714e+02 0.0000000000e+00
5.6100264550e+03</FONT></DIV>
<DIV><FONT face=Arial size=2>Regards</FONT></DIV>
<DIV><FONT face=Arial size=2>swami</FONT></DIV>
<DIV><FONT face=Arial size=2>----- Original Message ----- </FONT>
<DIV><FONT face=Arial size=2>From: "Tobias Oetiker" <</FONT><A
href="mailto:tobi@oetiker.ch"><FONT face=Arial
size=2>tobi@oetiker.ch</FONT></A><FONT face=Arial size=2>></FONT></DIV>
<DIV><FONT face=Arial size=2>To: "swami" <</FONT><A
href="mailto:swami@infineta.com"><FONT face=Arial
size=2>swami@infineta.com</FONT></A><FONT face=Arial size=2>></FONT></DIV>
<DIV><FONT face=Arial size=2>Cc: <</FONT><A
href="mailto:rrd-users@lists.oetiker.ch"><FONT face=Arial
size=2>rrd-users@lists.oetiker.ch</FONT></A><FONT face=Arial size=2>>;
<</FONT><A href="mailto:rrd-developers@lists.oetiker.ch"><FONT face=Arial
size=2>rrd-developers@lists.oetiker.ch</FONT></A><FONT face=Arial
size=2>></FONT></DIV>
<DIV><FONT face=Arial size=2>Sent: Thursday, January 07, 2010 10:20
PM</FONT></DIV>
<DIV><FONT face=Arial size=2>Subject: Re: [rrd-developers] RRDTOOL xport issue
whereas RRDTOOL fetch is fine</FONT></DIV></DIV>
<DIV><FONT face=Arial><BR><FONT size=2></FONT></FONT></DIV><FONT face=Arial
size=2>> Hi Swami,<BR>> <BR>> <BR>> Yesterday swami wrote:<BR>>
<BR>>> Hi
All,<BR>>> I am
finding this issue of rrd xport not returning rows whereas the rrd fetch is
returning rows with the same parameters.<BR>>> Would be great if any of
you could help me or have faced this issue.I am using rrdtool version
1.3.6.<BR>>><BR>>> Below is the snapshot of the commands executed
and their result .<BR>>><BR>>> RRDTOOL FETCH: returns one row as
shown below<BR>>><BR>>> [root@dev006 ~]#
/usr/local/third-party/rrd/bin/rrdtool fetch
/var/stats/rrd_data/service_class_data/service_class_TESTSC04.rrd AVERAGE -r 3
-s 1262886000 -e
1262886180<BR>>>
AccelTrafficBytesIn PThruTrafficBytesIn
GoodPutBytesOut
GoodPutBytesIn
WanPThruBytesIn
BytesOut<BR>>><BR>>> 1262886600: 4.3554497354e+02 0.0000000000e+00
1.6151587302e+02 5.8164285714e+02 0.0000000000e+00
5.6100264550e+03<BR>>><BR>>> RRDTOOL XPORT : things to
observe<BR>>> 1) in the result , step is 600 eventhough step is set
to 3 in the command<BR>>> 2) start and end time in the result are not the
same as in the command<BR>>> 3) no rows are
returned.<BR>>><BR>>> [root@dev006 ~]#
/usr/local/third-party/rrd/bin/rrdtool xport --step 3 -s 1262886000 -e
1262886180
DEF:aval=/var/stats/rrd_data/service_class_data/service_class_TESTSC04.rrd:AccelTrafficBytesIn:AVERAGE
DEF:bval=/var/stats/rrd_data/service_class_data/service_class_TESTSC04.rrd:BytesOut:AVERAGE
DEF:cval=/var/stats/rrd_data/service_class_data/service_class_TESTSC04.rrd:GoodPutBytesIn:AVERAGE
DEF:dval=/var/stats/rrd_data/service_class_data/service_class_TESTSC04.rrd:GoodPutBytesOut:AVERAGE
CDEF:a=aval,UN,0,aval,IF,8,* CDEF:b=bval,UN,0,bval,IF,8,*
CDEF:c=cval,UN,0,cval,IF,8,* CDEF:d=dval,UN,0,dval,IF,8,* CDEF:dr1=d,100,*,a,/
CDEF:dr=100,dr1,- CDEF:ci=a,d,/ CDEF:civ=ci,UN,1,ci,IF CDEF:cival=civ,1,MAX
XPORT:dr XPORT:cival XPORT:a XPORT:b XPORT:c XPORT:d<BR>>> <?xml
version="1.0" encoding="ISO-8859-1"?><BR>>><BR>>>
<xport><BR>>>
<meta><BR>>>
<start>1262886600</start><BR>>>
<step>600</step><BR>>>
<end>1262886000</end><BR>>>
<rows>0</rows><BR>>>
<columns>6</columns><BR>>>
<legend><BR>>>
<entry></entry><BR>>>
<entry></entry><BR>>>
<entry></entry><BR>>>
<entry></entry><BR>>>
<entry></entry><BR>>>
<entry></entry><BR>>>
</legend><BR>>> </meta><BR>>>
<data><BR>>> </data><BR>>>
</xport><BR>> <BR>> there were a number of issues fixed in xport
recently. please try<BR>> with the latest 1.3.x or 1.4.x version of
rrdtool<BR>> <BR>> cheers<BR>> tobi<BR>> <BR>> -- <BR>> Tobi
Oetiker, OETIKER+PARTNER AG, Aarweg 15 CH-4600 Olten, Switzerland<BR>>
</FONT><A href="http://it.oetiker.ch"><FONT face=Arial
size=2>http://it.oetiker.ch</FONT></A><FONT face=Arial size=2> </FONT><A
href="mailto:tobi@oetiker.ch"><FONT face=Arial
size=2>tobi@oetiker.ch</FONT></A><FONT face=Arial size=2> ++41 62 775 9902 / sb:
-9900</FONT></BODY></HTML>