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 .
>
[...]
> [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>
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 */
> [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
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" <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
--
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
