[rrd-users] [rrd-developers] RRDTOOL xport issue whereas RRDTOOL fetch is fine
swami
swami at infineta.com
Fri Jan 8 19:02:32 CET 2010
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.
[root at dev006 build_1.4.2]# /usr/local/software/rrd/bin/rrdtool
RRDtool 1.4.2 Copyright 1997-2009 by Tobias Oetiker <tobi at 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
[root at 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>
[root at 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" <tobi at oetiker.ch>
To: "swami" <swami at infineta.com>
Cc: <rrd-users at lists.oetiker.ch>; <rrd-developers at 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
>>
>> [root at 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.
>>
>> [root at 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 tobi at oetiker.ch ++41 62 775 9902 / sb: -9900
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.oetiker.ch/pipermail/rrd-users/attachments/20100108/4af558b6/attachment.htm
More information about the rrd-users
mailing list