[rrd-users] Not a simple unsigned integer

[Tobias Oetiker]

Hi Paul,

Today Paul Watson wrote:

> The same update is called everytime,
>
> rrdtool update ${STUBDIR}/stats_${ID}.rrd
> ${EPOCH}:${SELECT}:${INSERT}:${UPDATE}:${DELETE}:${BREAD}:${BWRITE}:${DREAD}
> :${DWRITE}:${RATIO}:${SEQSCANS}
>
> All the data values come from the database where the columns are defined as
> int8 (8 byte ints).  Their values can go negative if we wrap past the int8
> max, if the database is restarted then the values start again from zero
>
> The rrd is defined as
>
> rrdtool create ${FNAME}            \
>             --start ${EPOCH}               \
>             DS:select:COUNTER:600:U:U      \
>             DS:insert:COUNTER:600:U:U      \
>             DS:update:COUNTER:600:U:U      \
>             DS:delete:COUNTER:600:U:U      \
>             DS:bread:COUNTER:600:U:U       \
>             DS:bwrite:COUNTER:600:U:U      \
>             DS:dread:COUNTER:600:U:U       \
>             DS:dwrite:COUNTER:600:U:U      \
>             DS:ratio:COUNTER:600:U:U       \
>             DS:seqscans:COUNTER:600:U:U    \
>             RRA:AVERAGE:0.5:1:600          \
>             RRA:AVERAGE:0.5:6:700          \
>             RRA:AVERAGE:0.5:24:775         \
>             RRA:AVERAGE:0.5:288:797
>
> They are 4 distinct rrd templates but they all follow the above 'style'. I
> have around 70K rrds defined at the moment, of which maybe 2-300 show
> 'problems'

so add some print statements to your code to create an output of the

* the rrdtool create sequence to cretate one of the problem rrds
* the rrdtool update sequence necessary to reproduce the problem

pack it all in a shell script and let me have it ...

thanks
tobi



>
> Cheers
> Paul
>
>
> -----Original Message-----
> From: Tobias Oetiker [mailto:tobi at oetiker.ch]
> Sent: Friday, April 20, 2012 10:27 AM
> To: Paul Watson
> Cc: rrd-users at lists.oetiker.ch
> Subject: RE: [rrd-users] Not a simple unsigned integer
>
> Hi Paul,
>
> Today Paul Watson wrote:
>
> > True but .....
> >
> > Having reset ALL the rrds and then ran the raw data through successfully
> > with rrdtool 1.3.8 I then reset again and ran with rrdtool 1.4.7 and got
> the
> > following
> >
> > stats_00093.rrd: not a simple unsigned integer: '-4997672'
> > stats_00095.rrd: not a simple unsigned integer: '-6556514'
> > stats_00109.rrd: not a simple unsigned integer: '-5429246'
> > stats_00166.rrd: not a simple unsigned integer: '-1904720'
> > stats_00167.rrd: not a simple unsigned integer: '-6629670'
> > stats_00172.rrd: not a simple unsigned integer: '-3321973'
> > stats_00178.rrd: not a simple unsigned integer: '-5320095'
> > stats_00179.rrd: not a simple unsigned integer: '-7117550'
> > stats_00253.rrd: not a simple unsigned integer: '-3944869'
> > stats_00300.rrd: not a simple unsigned integer: '-6854738'
> >
> > Note the rrds are number sequentially and the problem only affects  some
> > rrds, all are defined that same. I am NOT passing in negative data, and
> ALL
> > the data is taken from a database where the columns are defined as integer
> > (8 bytes).
>
> then which rrdtool update calls are causing this error to appear ?
>
> cheers
> tobi
>
>

-- 
Tobi Oetiker, OETIKER+PARTNER AG, Aarweg 15 CH-4600 Olten, Switzerland
http://it.oetiker.ch tobi at oetiker.ch ++41 62 775 9902 / sb: -9900