[rrd-users] Getting NaN in CDEF with LIMIT but the DEF has a validnumber

Tom Jefferson tjefferson2001 at hotmail.com
Wed Dec 28 06:00:12 CET 2011


Thanks for the suggestion, that is indeed the issue. So when using a LIMIT in a CDEF should you allow for a little overage on your range?  Is this a common issue?   rrdtool xport DEF:ds450=450.rrd:450:AVERAGE CDEF:limit450=ds450,100,- XPORT:ds450:"source" XPORT:limit450:"mod"
<?xml version="1.0" encoding="ISO-8859-1"?><xport>
  <meta>
    <start>1324962000</start>
    <step>300</step>
    <end>1325048400</end>
    <rows>289</rows>
    <columns>2</columns>
    <legend>
      <entry>source</entry>
      <entry>mod</entry>
    </legend>
  </meta>
  <data>
    <row><t>1324962000</t><v>1.0000000000e+02</v><v>0.0000000000e+00</v></row>
    <row><t>1324962300</t><v>1.0000000000e+02</v><v>0.0000000000e+00</v></row>
    <row><t>1324962600</t><v>1.0000000000e+02</v><v>0.0000000000e+00</v></row>
    <row><t>1324962900</t><v>1.0000000000e+02</v><v>0.0000000000e+00</v></row>
    <row><t>1324963200</t><v>1.0000000000e+02</v><v>0.0000000000e+00</v></row>
    <row><t>1324963500</t><v>1.0000000000e+02</v><v>0.0000000000e+00</v></row>
    <row><t>1324963800</t><v>1.0000000000e+02</v><v>0.0000000000e+00</v></row>
    <row><t>1324964100</t><v>1.0000000000e+02</v><v>0.0000000000e+00</v></row>
    <row><t>1324964400</t><v>1.0000000000e+02</v><v>0.0000000000e+00</v></row>
    <row><t>1324964700</t><v>1.0000000000e+02</v><v>1.4210854715e-14</v></row>
    <row><t>1324965000</t><v>1.0000000000e+02</v><v>0.0000000000e+00</v></row>
    <row><t>1324965300</t><v>1.0000000000e+02</v><v>-1.4210854715e-14</v></row>
    <row><t>1324965600</t><v>1.0000000000e+02</v><v>0.0000000000e+00</v></row>
    <row><t>1324965900</t><v>1.0000000000e+02</v><v>-1.4210854715e-14</v></row>
    <row><t>1324966200</t><v>1.0000000000e+02</v><v>-1.4210854715e-14</v></row>
    <row><t>1324966500</t><v>1.0000000000e+02</v><v>0.0000000000e+00</v></row>
    <row><t>1324966800</t><v>1.0000000000e+02</v><v>0.0000000000e+00</v></row>
    <row><t>1324967100</t><v>1.0000000000e+02</v><v>0.0000000000e+00</v></row>
    <row><t>1324967400</t><v>1.0000000000e+02</v><v>0.0000000000e+00</v></row>
    <row><t>1324967700</t><v>1.0000000000e+02</v><v>-1.4210854715e-14</v></row>
    <row><t>1324968000</t><v>1.0000000000e+02</v><v>1.4210854715e-14</v></row>
    <row><t>1324968300</t><v>1.0000000000e+02</v><v>-1.4210854715e-14</v></row>
    <row><t>1324968600</t><v>1.0000000000e+02</v><v>0.0000000000e+00</v></row>
    <row><t>1324968900</t><v>1.0000000000e+02</v><v>1.4210854715e-14</v></row>
    <row><t>1324969200</t><v>1.0000000000e+02</v><v>0.0000000000e+00</v></row>
    <row><t>1324969500</t><v>1.0000000000e+02</v><v>0.0000000000e+00</v></row>
    <row><t>1324969800</t><v>1.0000000000e+02</v><v>0.0000000000e+00</v></row>
    <row><t>1324970100</t><v>1.0000000000e+02</v><v>1.4210854715e-14</v></row>
    <row><t>1324970400</t><v>1.0000000000e+02</v><v>0.0000000000e+00</v></row>
 > From: alex at vandenbogaerdt.nl
> To: tjefferson2001 at hotmail.com; rrd-users at lists.oetiker.ch
> Subject: Re: [rrd-users] Getting NaN in CDEF with LIMIT but the DEF has a validnumber
> Date: Wed, 28 Dec 2011 04:39:21 +0100
> 
> Just guessing here: maybe somehow some numbers are bigger than 100 but smaller than 1.00000000005e+02
> 
> I think you can test this by subtracting 100 in a CDEF and print the outcome.
> 
> 
> 
> ----- Original Message ----- 
> From: "Tom Jefferson" <tjefferson2001 at hotmail.com>
> To: <rrd-users at lists.oetiker.ch>
> Sent: Wednesday, December 28, 2011 3:55 AM
> Subject: [rrd-users] Getting NaN in CDEF with LIMIT but the DEF has a validnumber
> 
> 
> 
> 
> 
> 
> I have spent a number of days re-reading the docs, searching the web, and searching old email archives but I can't find the answer to this. I have been using RRD for a long time but this issue has me stumped. I have an rrd that records a percent value from 0 - 100. When I use a CDEF with LIMIT 0,100 I get a number of NaNs but I can't figure out why. The data shows the DEF value as 100 for those periods. Any thoughts?     I ran an XPORT to see the original DEF calue and the CDEF, here is what I am seeing: rrdtool xport DEF:ds450=450.rrd:450:AVERAGE CDEF:limit450=ds450,0,100,LIMIT XPORT:ds450:"source" XPORT:limit450:"mod"
> <?xml version="1.0" encoding="ISO-8859-1"?><xport>
>   <meta>
>     <start>1324954500</start>
>     <step>300</step>
>     <end>1325040900</end>
>     <rows>289</rows>
>     <columns>2</columns>
>     <legend>
>       <entry>source</entry>
>       <entry>mod</entry>
>     </legend>
>   </meta>
>   <data>
>     <row><t>1324954500</t><v>1.0000000000e+02</v><v>1.0000000000e+02</v></row>
>     <row><t>1324954800</t><v>1.0000000000e+02</v><v>1.0000000000e+02</v></row>
>     <row><t>1324955100</t><v>1.0000000000e+02</v><v>1.0000000000e+02</v></row>
>     <row><t>1324955400</t><v>1.0000000000e+02</v><v>1.0000000000e+02</v></row>
>     <row><t>1324955700</t><v>1.0000000000e+02</v><v>NaN</v></row>
>     <row><t>1324956000</t><v>1.0000000000e+02</v><v>1.0000000000e+02</v></row>
>     <row><t>1324956300</t><v>1.0000000000e+02</v><v>1.0000000000e+02</v></row>
>     <row><t>1324956600</t><v>1.0000000000e+02</v><v>1.0000000000e+02</v></row>
>     <row><t>1324956900</t><v>1.0000000000e+02</v><v>NaN</v></row>
>     <row><t>1324957200</t><v>1.0000000000e+02</v><v>1.0000000000e+02</v></row>
>     <row><t>1324957500</t><v>1.0000000000e+02</v><v>NaN</v></row>
>     <row><t>1324957800</t><v>1.0000000000e+02</v><v>1.0000000000e+02</v></row>
>     <row><t>1324958100</t><v>1.0000000000e+02</v><v>1.0000000000e+02</v></row>
>     <row><t>1324958400</t><v>1.0000000000e+02</v><v>1.0000000000e+02</v></row>
>     <row><t>1324958700</t><v>1.0000000000e+02</v><v>1.0000000000e+02</v></row>
>     <row><t>1324959000</t><v>1.0000000000e+02</v><v>1.0000000000e+02</v></row>
>     <row><t>1324959300</t><v>1.0000000000e+02</v><v>1.0000000000e+02</v></row>
>     <row><t>1324959600</t><v>1.0000000000e+02</v><v>1.0000000000e+02</v></row>
>     <row><t>1324959900</t><v>1.0000000000e+02</v><v>1.0000000000e+02</v></row>
>     <row><t>1324960200</t><v>1.0000000000e+02</v><v>1.0000000000e+02</v></row>
>     <row><t>1324960500</t><v>1.0000000000e+02</v><v>1.0000000000e+02</v></row>
>     <row><t>1324960800</t><v>1.0000000000e+02</v><v>NaN</v></row>
>     <row><t>1324961100</t><v>1.0000000000e+02</v><v>NaN</v></row>
>     <row><t>1324961400</t><v>1.0000000000e+02</v><v>NaN</v></row>
>     <row><t>1324961700</t><v>1.0000000000e+02</v><v>1.0000000000e+02</v></row>
>     <row><t>1324962000</t><v>1.0000000000e+02</v><v>1.0000000000e+02</v></row>
>     <row><t>1324962300</t><v>1.0000000000e+02</v><v>1.0000000000e+02</v></row>
>     <row><t>1324962600</t><v>1.0000000000e+02</v><v>1.0000000000e+02</v></row>
>     <row><t>1324962900</t><v>1.0000000000e+02</v><v>1.0000000000e+02</v></row>  Thanks,   Tim    
> 
> 
> --------------------------------------------------------------------------------
> 
> 
> > _______________________________________________
> > rrd-users mailing list
> > rrd-users at lists.oetiker.ch
> > https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users
> >
> 
> 
 		 	   		  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.oetiker.ch/pipermail/rrd-users/attachments/20111227/a18bf32e/attachment-0001.htm 


More information about the rrd-users mailing list