spine 30sec polling: does not show graph properly

[rootfive]

Hi,

I have installed spine 0.87a with 30 sec polling interval. I have the following graphs. hourly (1 minute average), Daily (5 Minute Average), Weekly (30 Minute Average), Monthly (2 Hour Average) and Yearly (1 Day Average). All the graphs are fine except Weekly (30 Minute Average), which show jiggle graph instead of smoth graph.



Can anybody guide me how to fix it?
Thanks
r.five

[gandalf]

...which show jiggle graph instead of smoth graph.

Please clarify what you mean by that. Perhaps a second screenshot of a good one? And please attach those images to the post instead of using external resources that may be deleted at some time
Reinhard

[rootfive]

Thanks for the reply. I have attached both smooth and stepping like graph. Smooth graph was using cacti poller with 5 minutes polling before upgrading to spine. Stepping like graph is with spine. Both are Weekly 30 minutes graph.

Regards,
r.five

[gandalf]

Please visit both Data Source Definitions in turn. Select DEBUG and post both results, please
Reinhard

[rootfive]

Thanks for the reply, below are the debug data source output
smooth graph

Code: Select all

/usr/bin/rrdtool create \
/var/www/html/cacti/rra/bracc2950hq1_traffic_in_123.rrd \
--step 300  \
DS:traffic_in:COUNTER:600:0:100000000 \
DS:traffic_out:COUNTER:600:0:100000000 \
RRA:AVERAGE:0.5:1:600 \
RRA:AVERAGE:0.5:6:700 \
RRA:AVERAGE:0.5:24:775 \
RRA:AVERAGE:0.5:288:797 \
RRA:MIN:0.5:1:600 \
RRA:MIN:0.5:6:700 \
RRA:MIN:0.5:24:775 \
RRA:MIN:0.5:288:797 \
RRA:MAX:0.5:1:600 \
RRA:MAX:0.5:6:700 \
RRA:MAX:0.5:24:775 \
RRA:MAX:0.5:288:797 \
RRA:LAST:0.5:1:600 \
RRA:LAST:0.5:6:700 \
RRA:LAST:0.5:24:775 \
RRA:LAST:0.5:288:797 \

stepping graph

Code: Select all

/usr/bin/rrdtool create \
/var/www/html/spine/rra/2950_-_1_traffic_in_86.rrd \
--step 30  \
DS:traffic_in:COUNTER:60:0:100000000 \
DS:traffic_out:COUNTER:60:0:100000000 \
RRA:AVERAGE:0.5:1:500 \
RRA:AVERAGE:0.5:1:600 \
RRA:AVERAGE:0.5:6:700 \
RRA:AVERAGE:0.5:24:775 \
RRA:AVERAGE:0.5:288:797 \
RRA:MIN:0.5:1:500 \
RRA:MIN:0.5:1:600 \
RRA:MIN:0.5:6:700 \
RRA:MIN:0.5:24:775 \
RRA:MIN:0.5:288:797 \
RRA:MAX:0.5:1:500 \
RRA:MAX:0.5:1:600 \
RRA:MAX:0.5:6:700 \
RRA:MAX:0.5:24:775 \
RRA:MAX:0.5:288:797 \
RRA:LAST:0.5:1:500 \
RRA:LAST:0.5:1:600 \
RRA:LAST:0.5:6:700 \
RRA:LAST:0.5:24:775 \
RRA:LAST:0.5:288:797 \

Regards,
r.five

[gandalf]

I feared that. You saw the difference?

RRA:AVERAGE:0.5:1:500 \
RRA:AVERAGE:0.5:1:600 \

defines two RRAs with same consolidation level. That's insane. Cacti 087 leads users to make this very mistake, I'm sorry. This is because our 1min polling support is not implemented very good.
Please delete the first rra. You will want to visit the Data Template and un-select that rra as well, because all new rrd files will have that problem.
Reinhard
PS.: Be aware, that rrdtool tune does not support deleting aa RRA definition. So you will have to start this file from scratch, or use a "dump, edit, restore" cycle to remove it
Reinhard

[rootfive]

Thanks for your reply. I have over 200 graphs with that problem. What is the best way to do without data loss? If I need to manually edit which file should edit. Thanks in advance for your help.

Regards,
r.five

[gandalf]

In your example, it would be

/var/www/html/spine/rra/2950_-_1_traffic_in_86.rrd

. If you can afford data loss, simple correct the data template and delete all rrd files that are failing. Cacti will re-create them based on the correct template.
Otherwise, you should search the rrdtool contrib directory for a utility that supports "removing" an unwanted rra.
In each case, try first with a single file. It is not said, that my assumptions are correct
Reinhard

[rootfive]

Thanks for your helpful reply. Sorry I am a bit dump. Where does cacti store template? I try to vi rrd files and it is not editable.

Regards,
r.five

[gandalf]

Please find some few words on templates and stuff at the first link of my signature. And it is described, where to find a Data Template
Reinhard