Adding updates but fetch shows NaNs
Issaac B <[email protected]> Mon, 22 Jan 2018 17:01:11 -0800
| Newsgroups | gmane.comp.db.rrdtool.user |
|---|---|
| Message-ID | <CAJFYjkVBRgFF8GS+2WEsHYPNr7PGfUczP2BqgKwQza=LyQ89MQ@mail.gmail.com> |
--===============7261073735076156985== Content-Type: multipart/alternative; boundary="001a113caea02d006a056367156e" --001a113caea02d006a056367156e Content-Type: text/plain; charset="UTF-8" I was hoping someone could help me understand how values are computed in RRD. I got a temp database (create below). I got a loop that adds an update ever ~2 minutes. rrdtool info says the DS got known values for the last two columns (ext_temperature, ext_humidity). Yet when I do a graph/fetch, I'm getting NaNs for the last two columns. Thanks, =============== Create: rrdtool create $HOME/.xdg/data/nest_thermostat.rrd \ --step '200' \ 'DS:temperature:GAUGE:600:0:100' \ 'DS:humidity:GAUGE:600:0:100' \ 'DS:target:GAUGE:600:0:100' \ 'DS:mode:GAUGE:600:0:10' \ 'DS:state:GAUGE:600:0:10' \ 'DS:fan:GAUGE:600:0:1' \ \ 'DS:ext_temperature:GAUGE:1500:0:100' \ 'DS:ext_humidity:GAUGE:1500:0:100' \ \ 'RRA:AVERAGE:0.5:1:2016' \ 'RRA:AVERAGE:0.5:1:4032' \ 'RRA:AVERAGE:0.5:6:1440' \ 'RRA:AVERAGE:0.5:6:4416' \ 'RRA:AVERAGE:0.5:12:4392' \ 'RRA:AVERAGE:0.5:24:4380' \ 'RRA:AVERAGE:0.5:48:4380' Update logs: 2018-01-22 16:54:40.787444: Updating RRD with N:67:50:65:2:0:0:U:U 2018-01-22 16:54:40.788156: Updating RRD with N:U:U:U:U:U:U:56.5:65 2018-01-22 16:56:11.899996: Updating RRD with N:67:50:65:2:0:0:U:U 2018-01-22 16:56:11.900661: Updating RRD with N:U:U:U:U:U:U:56.5:65 rrdtool info: $ rrdtool info nest_thermostat.rrd | grep ext ds[ext_temperature].index = 6 ds[ext_temperature].type = "GAUGE" ds[ext_temperature].minimal_heartbeat = 1500 ds[ext_temperature].min = 0.0000000000e+00 ds[ext_temperature].max = 1.0000000000e+02 ds[ext_temperature].last_ds = "56.5" ds[ext_temperature].value = 3.6216500000e-02 ds[ext_temperature].unknown_sec = 62 ds[ext_humidity].index = 7 ds[ext_humidity].type = "GAUGE" ds[ext_humidity].minimal_heartbeat = 1500 ds[ext_humidity].min = 0.0000000000e+00 ds[ext_humidity].max = 1.0000000000e+02 ds[ext_humidity].last_ds = "65" ds[ext_humidity].value = 4.1665000000e-02 ds[ext_humidity].unknown_sec = 62 Fetch: $ rrdtool fetch nest_thermostat.rrd AVERAGE | tail -n5 1516668600: 6.6830290005e+01 4.9873350750e+01 6.4835355975e+01 1.9949340300e+00 0.0000000000e+00 0.0000000000e+00 -nan -nan 1516668800: 6.6834396100e+01 4.9876415000e+01 6.4839339500e+01 1.9950566000e+00 0.0000000000e+00 0.0000000000e+00 -nan -nan 1516669000: 6.6999548755e+01 4.9999663250e+01 6.4999562225e+01 1.9999865300e+00 0.0000000000e+00 0.0000000000e+00 -nan -nan 1516669200: 6.6910302075e+01 4.9933061250e+01 6.4912979625e+01 1.9973224500e+00 0.0000000000e+00 0.0000000000e+00 -nan -nan 1516669400: -nan -nan -nan -nan -nan -nan -nan -nan --001a113caea02d006a056367156e Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable <div dir=3D"ltr"><div>I was hoping someone could help me understand how val= ues are computed in RRD.</div><div>I got a temp database (create below). I = got a loop that adds an update ever ~2 minutes.</div><div><br></div><div>rr= dtool info says the DS got known values for the last two columns=C2=A0(ext_= temperature,=C2=A0ext_humidity).=C2=A0</div><div>Yet when I do a graph/fetc= h, I'm getting NaNs for the last two columns.<br></div><div><br></div><= div>Thanks,</div><div>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D</div><d= iv><br></div><div>Create:</div><div>rrdtool create $HOME/.xdg/data/nest_the= rmostat.rrd \</div><div>--step '200' \</div><div>'DS:temperatur= e:GAUGE:600:0:100' \</div><div>'DS:humidity:GAUGE:600:0:100' \<= /div><div>'DS:target:GAUGE:600:0:100' \</div><div>'DS:mode:GAUG= E:600:0:10' \</div><div>'DS:state:GAUGE:600:0:10' \</div><div>&= #39;DS:fan:GAUGE:600:0:1' \</div><div>\</div><div>'DS:ext_temperatu= re:GAUGE:1500:0:100' \</div><div>'DS:ext_humidity:GAUGE:1500:0:100&= #39; \</div><div>\</div><div>'RRA:AVERAGE:0.5:1:2016' \</div><div>&= #39;RRA:AVERAGE:0.5:1:4032' \</div><div>'RRA:AVERAGE:0.5:6:1440'= ; \</div><div>'RRA:AVERAGE:0.5:6:4416' \</div><div>'RRA:AVERAGE= :0.5:12:4392' \</div><div>'RRA:AVERAGE:0.5:24:4380' \</div><div= >'RRA:AVERAGE:0.5:48:4380'</div><div><br></div><div>Update logs:</d= iv><div><div>2018-01-22 16:54:40.787444: Updating RRD with N:67:50:65:2:0:0= :U:U</div><div>2018-01-22 16:54:40.788156: Updating RRD with N:U:U:U:U:U:U:= 56.5:65</div><div>2018-01-22 16:56:11.899996: Updating RRD with N:67:50:65:= 2:0:0:U:U</div><div>2018-01-22 16:56:11.900661: Updating RRD with N:U:U:U:U= :U:U:56.5:65</div></div><div><br></div><div>rrdtool info:</div><div><div>$= =C2=A0 rrdtool info nest_thermostat.rrd=C2=A0 | grep ext</div><div>ds[ext_t= emperature].index =3D 6</div><div>ds[ext_temperature].type =3D "GAUGE&= quot;</div><div>ds[ext_temperature].minimal_heartbeat =3D 1500</div><div>ds= [ext_temperature].min =3D 0.0000000000e+00</div><div>ds[ext_temperature].ma= x =3D 1.0000000000e+02</div><div>ds[ext_temperature].last_ds =3D "56.5= "</div><div>ds[ext_temperature].value =3D 3.6216500000e-02</div><div>d= s[ext_temperature].unknown_sec =3D 62</div><div>ds[ext_humidity].index =3D = 7</div><div>ds[ext_humidity].type =3D "GAUGE"</div><div>ds[ext_hu= midity].minimal_heartbeat =3D 1500</div><div>ds[ext_humidity].min =3D 0.000= 0000000e+00</div><div>ds[ext_humidity].max =3D 1.0000000000e+02</div><div>d= s[ext_humidity].last_ds =3D "65"</div><div>ds[ext_humidity].value= =3D 4.1665000000e-02</div><div>ds[ext_humidity].unknown_sec =3D 62</div></= div><div><br></div><div>Fetch:</div><div><div>$=C2=A0 rrdtool fetch nest_th= ermostat.rrd AVERAGE | tail -n5</div><div>1516668600: 6.6830290005e+01 4.98= 73350750e+01 6.4835355975e+01 1.9949340300e+00 0.0000000000e+00 0.000000000= 0e+00 -nan -nan</div><div>1516668800: 6.6834396100e+01 4.9876415000e+01 6.4= 839339500e+01 1.9950566000e+00 0.0000000000e+00 0.0000000000e+00 -nan -nan<= /div><div>1516669000: 6.6999548755e+01 4.9999663250e+01 6.4999562225e+01 1.= 9999865300e+00 0.0000000000e+00 0.0000000000e+00 -nan -nan</div><div>151666= 9200: 6.6910302075e+01 4.9933061250e+01 6.4912979625e+01 1.9973224500e+00 0= .0000000000e+00 0.0000000000e+00 -nan -nan</div><div>1516669400: -nan -nan = -nan -nan -nan -nan -nan -nan</div></div></div> --001a113caea02d006a056367156e-- --===============7261073735076156985== Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Disposition: inline _______________________________________________ rrd-users mailing list [email protected] https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users --===============7261073735076156985==--