95th percentile always shows 0

[lunelson]

I can't get the 95th percentile graphing to work. It seems like it should be higher than 0 but shows up at 0 for all of my graphs. Any ideas? I'm running openSuse 10.2, with Cacti 0.8.6j. All other graphs appear to be working just fine. Thanks for the help.

[rony]

Please post the debug for the graph.

[lunelson]

Code: Select all

/usr/bin/rrdtool graph - \
--imgformat=PNG \
--start=-86400 \
--end=-300 \
--title="pfSense Overland Park - Traffic - xl0" \
--rigid \
--base=1000 \
--height=120 \
--width=500 \
--alt-autoscale-max \
--lower-limit=0 \
--vertical-label="bits per second" \
--slope-mode \
--font TITLE:12:/usr/share/fonts/truetype/DejaVuSans.ttf \
--font AXIS:7:/usr/share/fonts/truetype/DejaVuSans.ttf \
--font LEGEND:8:/usr/share/fonts/truetype/DejaVuSans.ttf \
--font UNIT:7:/usr/share/fonts/truetype/DejaVuSans.ttf \
DEF:a="/usr/share/cacti/rra/pfsense_overland_park_traffic_in_64.rrd":traffic_in:AVERAGE \
DEF:b="/usr/share/cacti/rra/pfsense_overland_park_traffic_in_64.rrd":traffic_out:AVERAGE \
CDEF:cdefa=a,8,* \
CDEF:cdefe=b,8,* \
AREA:cdefa#00CF00:"Inbound"  \
GPRINT:cdefa:LAST:" Current\:%8.2lf %s"  \
GPRINT:cdefa:AVERAGE:"Average\:%8.2lf %s"  \
GPRINT:cdefa:MAX:"Maximum\:%8.2lf %s\n"  \
LINE1:cdefe#002A97:"Outbound"  \
GPRINT:cdefe:LAST:"Current\:%8.2lf %s"  \
GPRINT:cdefe:AVERAGE:"Average\:%8.2lf %s"  \
GPRINT:cdefe:MAX:"Maximum\:%8.2lf %s\n"  \
COMMENT:"\n"  \
HRULE:0#FF0000:"95th Percentile"  \
COMMENT:"(0 mbit in+out)" 

Thanks!

[gesalec]

I am having the same issue. It is occuring on a handful of graphs. The rest seem to be working fine. Have you figured out what is causing the problem yet?

[rony]

Version of Cacti which you are running?

[gesalec]

I am currently running 0.8.6j. My graph debugs look similar to the one that was posted above, which is why I didn't feel the need to post another one.

While looking into the problem yesterday I noticed some things. On the device that is having theses problems, one port is actually graphing the 95th percentile correctly while the rest are not. Also, while trying to discover what the issue might be, I noticed that the data source "Output Type ID" was set to In/Out Bytes with Total Bandwidth instead of In/Out Bytes with 95th percentile. Thinking that this might be the cause of the problem I changed it to In/Out Bytes with 95th Percentile. This had no apparent effect on the graph.

[marnues]

As a fix, I have found that if you open up the graph in graph management, save the graph, then force refresh the graph, the 95th percentile should work.
This is not a long term fix and I would love to know why this is happening, but it seems to be a fairly common problem for our 95th graphs.

[wizwareinc]

As soon as I upgraded from 0.8.6h to hopefully solve some total bandwidth calculation problems, I started having this problem. I never had a 95th Percentile calculation problem before the upgrade.

Is there a fix for this yet? I have noticed that a temp fix is indeed opening the graph in graph management, saving it, then refreshing. I don't know how long it will last and it would take a a LONG time to go through each graph to do this. Please help!

[rony]

Um... Happened on an upgrade?

From what version to what version?

[wizwareinc]

Exactly as I stated in my post, from 0.8.6h to 0.8.6j

[rony]

Sorry I missed that...

Can you email me a dump of you database? Please remember to compress it. I want to see if I can write you a query that will resolve your issue.

[wizwareinc]

I have too much sensitive information to be able to do that. Is there something else you can do?