Hi Tobi,
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).
One more thing to observe is that the ouput of rrdtool fetch below shows just
one record with the time as 1262886600 which is not in the range of time given
in the command.
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 .
You want any other inputs ? How to debug this further.
[r...@dev006 build_1.4.2]# /usr/local/software/rrd/bin/rrdtool
RRDtool 1.4.2 Copyright 1997-2009 by Tobias Oetiker <t...@oetiker.ch>
Compiled Jan 8 2010 09:36:16
Usage: rrdtool [options] command command_options
Valid commands: create, update, updatev, graph, graphv, dump, restore,
last, lastupdate, first, info, fetch, tune,
resize, xport, flushcached
RRDtool is distributed under the Terms of the GNU General
Public License Version 2. (www.gnu.org/copyleft/gpl.html)
For more information read the RRD manpages
[r...@dev006 build_1.4.2]# /usr/local/third-party/rrd/bin/rrdtool xport --step
3 -s 1262886000 -e 1262886120
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
<?xml version="1.0" encoding="ISO-8859-1"?>
<xport>
<meta>
<start>1262886600</start>
<step>600</step>
<end>1262886000</end>
<rows>0</rows>
<columns>6</columns>
<legend>
<entry></entry>
<entry></entry>
<entry></entry>
<entry></entry>
<entry></entry>
<entry></entry>
</legend>
</meta>
<data>
</data>
</xport>
[r...@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
AccelTrafficBytesIn PThruTrafficBytesIn GoodPutBytesOut
GoodPutBytesIn WanPThruBytesIn BytesOut
1262886600: 4.3554497354e+02 0.0000000000e+00 1.6151587302e+02 5.8164285714e+02
0.0000000000e+00 5.6100264550e+03
Regards
swami
----- Original Message -----
From: "Tobias Oetiker" <t...@oetiker.ch>
To: "swami" <sw...@infineta.com>
Cc: <rrd-us...@lists.oetiker.ch>; <rrd-developers@lists.oetiker.ch>
Sent: Thursday, January 07, 2010 10:20 PM
Subject: Re: [rrd-developers] RRDTOOL xport issue whereas RRDTOOL fetch is fine
> Hi Swami,
>
>
> Yesterday swami wrote:
>
>> Hi All,
>> I am finding this issue of rrd xport not returning rows whereas the
>> rrd fetch is returning rows with the same parameters.
>> Would be great if any of you could help me or have faced this issue.I am
>> using rrdtool version 1.3.6.
>>
>> Below is the snapshot of the commands executed and their result .
>>
>> RRDTOOL FETCH: returns one row as shown below
>>
>> [r...@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
>> AccelTrafficBytesIn PThruTrafficBytesIn GoodPutBytesOut
>> GoodPutBytesIn WanPThruBytesIn BytesOut
>>
>> 1262886600: 4.3554497354e+02 0.0000000000e+00 1.6151587302e+02
>> 5.8164285714e+02 0.0000000000e+00 5.6100264550e+03
>>
>> RRDTOOL XPORT : things to observe
>> 1) in the result , step is 600 eventhough step is set to 3 in the command
>> 2) start and end time in the result are not the same as in the command
>> 3) no rows are returned.
>>
>> [r...@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
>> <?xml version="1.0" encoding="ISO-8859-1"?>
>>
>> <xport>
>> <meta>
>> <start>1262886600</start>
>> <step>600</step>
>> <end>1262886000</end>
>> <rows>0</rows>
>> <columns>6</columns>
>> <legend>
>> <entry></entry>
>> <entry></entry>
>> <entry></entry>
>> <entry></entry>
>> <entry></entry>
>> <entry></entry>
>> </legend>
>> </meta>
>> <data>
>> </data>
>> </xport>
>
> there were a number of issues fixed in xport recently. please try
> with the latest 1.3.x or 1.4.x version of rrdtool
>
> cheers
> tobi
>
> --
> Tobi Oetiker, OETIKER+PARTNER AG, Aarweg 15 CH-4600 Olten, Switzerland
> http://it.oetiker.ch t...@oetiker.ch ++41 62 775 9902 / sb: -9900_______________________________________________
rrd-developers mailing list
rrd-developers@lists.oetiker.ch
https://lists.oetiker.ch/cgi-bin/listinfo/rrd-developers
