[rrd-users] [rrd-developers] RRDTOOL xport issue whereas RRDTOOL fetch is fine
swami
swami at infineta.com
Tue Jan 12 02:38:45 CET 2010
Hi Tobi,
Issue still persists with the patch as shown below in the snapshot .
[root at dev006 build]# /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_all.rrd:AccelTrafficBytesIn:AVERAGE DEF:bval=/var/stats/rrd_data/service_class_data/service_class_all.rrd:BytesOut:AVERAGE DEF:cval=/var/stats/rrd_data/service_class_data/service_class_all.rrd:GoodPutBytesIn:AVERAGE DEF:dval=/var/stats/rrd_data/service_class_data/service_class_all.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>1262887200</start>
<step>3600</step>
<end>1262883600</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]# /usr/local/third-party/rrd/bin/rrdtool fetch /var/stats/rrd_data/service_class_data/service_class_TESTSC07.rrd AVERAGE -r 3 -s 1262886000 -e 1262886120
AccelTrafficBytesIn PThruTrafficBytesIn GoodPutBytesOut GoodPutBytesIn WanPThruBytesIn BytesOut
1262887200: nan nan nan nan nan nan
Regards
swami
----- Original Message -----
From: oetiker [via RRD Mailinglists]
To: swami
Sent: Monday, January 11, 2010 12:09 AM
Subject: Re: [rrd-users] [rrd-developers] RRDTOOL xport issue whereas RRDTOOL fetch is fine
Hi Swami,
Friday swami wrote:
> 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 .
>
[...]
> [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>
ah ... I see what you are getting at ... the end is being adjusted
down and not up ... try this patch
Index: rrd_xport.c
===================================================================
--- rrd_xport.c (revision 1993)
+++ rrd_xport.c (working copy)
@@ -286,7 +286,7 @@
free(step_list);
*start = im->start - im->start % (*step);
- *end = im->end - im->end % (*step);
+ *end = im->end - im->end % (*step) + (*step);
/* room for rearranged data */
> [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
this is correct ... note that the timestamp marks THE END of the
interval, not the start hence the numbers returned cover your
requested timespan ... since you are only getting one line it may
be non obvious what the interval is, but then again you are free to
request a little more data from fetch ...
cheer
tobi
> Regards
> swami
> ----- Original Message -----
> From: "Tobias Oetiker" <[hidden email]>
> To: "swami" <[hidden email]>
> Cc: <[hidden email]>; <[hidden email]>
> 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 [hidden email] ++41 62 775 9902 / sb: -9900
--
Tobi Oetiker, OETIKER+PARTNER AG, Aarweg 15 CH-4600 Olten, Switzerland
http://it.oetiker.ch [hidden email] ++41 62 775 9902 / sb: -9900
_______________________________________________
rrd-users mailing list
[hidden email]
https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users
------------------------------------------------------------------------------
View message @ http://n2.nabble.com/RRDTOOL-xport-issue-whereas-RRDTOOL-fetch-is-fine-tp4270695p4284301.html
To unsubscribe from RRD Mailinglists, click here.
--
View this message in context: http://n2.nabble.com/RRDTOOL-xport-issue-whereas-RRDTOOL-fetch-is-fine-tp4270695p4289288.html
Sent from the RRDtool Users Mailinglist mailing list archive at Nabble.com.
More information about the rrd-users
mailing list