[rrd-users] Values not properly stored in RRD database

[Jean-Yves Avenard]

Hi there.

I was attempting to export the data in one of my rrd file... And I'm
puzzled with what I can retrieve..

rrd file was created with:

rrdtool create solarprodX.rrd --start 1252116540 -s 60 \
DS:power:GAUGE:300:0:U \
DS:total:DERIVE:300:0:2.3 \
DS:1:GAUGE:300:0:U \
DS:2:GAUGE:300:0:U \
RRA:AVERAGE:0.5:1:144000 \
RRA:AVERAGE:0.5:5:525600 \
RRA:AVERAGE:0.5:30:87840 \
RRA:AVERAGE:0.5:60:43920 \
RRA:AVERAGE:0.5:120:21960 \
RRA:AVERAGE:0.5:1440:1830 \
RRA:MIN:0.5:60:43920 \
RRA:MAX:0.5:60:43920

so it records 100 day of 1 minute average
5 years of 5 minutes average
5 years of 30 minutes average
5 years of 2 hours average
5 years of daily average
5 years of 1 hour max
5 years of 1 hour min

the last value added was:

1392399660:167:5341523:190:0

so far so good.
Note the DS:1 value: it's 190.

rrdtool lastupdate gives me:

1392399660: 167 5341523 190 0


When I perform a fetch however:

rrdtool fetch data/solarprod1.rrd AVERAGE -s 1392399000 -e 1392399661
                          power               total
1                   2

1392399060: 1.9300000000e+02 5.0000000000e-02 -nan 0.0000000000e+00
1392399120: 2.2100000000e+02 6.6666666667e-02 -nan 0.0000000000e+00
1392399180: 2.5100000000e+02 6.6666666667e-02 -nan 0.0000000000e+00
1392399240: 2.7000000000e+02 8.3333333333e-02 -nan 0.0000000000e+00
1392399300: 2.7300000000e+02 6.6666666667e-02 -nan 0.0000000000e+00
1392399360: 2.6600000000e+02 8.3333333333e-02 -nan 0.0000000000e+00
1392399420: 2.5700000000e+02 6.6666666667e-02 -nan 0.0000000000e+00
1392399480: 2.2500000000e+02 6.6666666667e-02 -nan 0.0000000000e+00
1392399540: 2.2300000000e+02 6.6666666667e-02 -nan 0.0000000000e+00
1392399600: 1.9300000000e+02 5.0000000000e-02 -nan 0.0000000000e+00
1392399660: 1.6700000000e+02 5.0000000000e-02 -nan 0.0000000000e+00

As you can see, DS:1 only contains nan... All other DS are fine and
contains the value I've fed so far...

Any ideas why that particular column would only contais NaN ?

It's like that since the start of the rrd file, so I guess there's not
much I can do from past data, but I'd like not to have the problem
continuing ad vitam eternam.

Thanks
JY