Cacti 1.2.24 - Hourly/Daily graphs showing the same values

[Margylle]

Cacti version: 1.2.24
rrdtool version: 1.7.2
php version: 7.2.24
Mariadb version: 10.3.35
RHEL 8.8


When creating graphs, the Hourly (5 minute average) and Daily (10 minute Average) graphs are showing the same values, until I click on the gear icon for the daily graph. Then the daily graph will show the correct values. Any idea what is causing them to show the same values when looking at them as a list?

Cacti_Graph_same_value_in_list.png (103.56 KiB) Viewed 2402 times

[TheWitness]

When inside the first consolidation level, the number will be the same unless you for some reason are polling two, three times per polling interval. Once your timespan exceeds the first level, they will start to separate.

Post a screen shot of your Data Source Profile (Edit).

[Margylle]

Thank you for taking a look at this. 5 Minute Data Profile:

DataProfile-5mins.PNG (35.46 KiB) Viewed 2241 times

Potential Issue 1: As soon as the hourly graph starts to populate data, the same values show up for Daily as well.

FirstPolls.PNG (131.38 KiB) Viewed 2241 times

Why would Daily show a value before there's enough data to graph? This is after clicking the gear icon for daily.

Daily-after-clicking-the-gear-icon.png (48.63 KiB) Viewed 2241 times

Potential Issue 2: When clicking into Daily/Weekly graph via the gear icon, the values change. For Hourly/Monthly, they continue to show what was seen when looking at the graphs as a list.

ListviewValue_Differs_From_Clicking_Into_Graph.png (366.05 KiB) Viewed 2241 times

monthly-before-after-clicking-gear.png (103.18 KiB) Viewed 2241 times

[TheWitness]

It's a weird layout, but looks good. Post a screen grab of the Graph Template. It looks like you are not using the Default for new installs.

[Margylle]

Why would the values change for graphs depending on whether you are looking at them as a list (Hourly-Yearly), versus the Utility View?

Graph template: Interface - Traffic (bits/sec):

Interface-traffic-bits-sec.PNG (57.4 KiB) Viewed 2227 times

[Osiris]

Because of aggregation. The peaks are not lost, and the default template shows them.

You should read up on how aggregation works in RRDtool

[Margylle]

I am still having this issue.

I have deleted all of the data profiles I was using for testing. I am now solely using the default 5 minute Collection data profile that comes with cacti. If I leave the 5 Minute Collection profile with the default settings, all of the graphs show accurate values. If I change the data retention (rows) for each RRA (Daily, Weekly, Monthly, Yearly) to two times the default value, then delete and recreate the graphs, everything still graphs correctly. I then tried changing the rows values to something closer to what I would want:

6 month data retention (51840 rows) for Daily
6 month data retention (9300 rows) for Weekly
6 month data retention (2400 rows) for Hourly
2 year data retention (797 rows) for Yearly

I made sure to delete all of the graphs again, recreate them, and things go downhill from here. This does not work. The daily graph populates data as expected. The weekly graph starts to show values as soon as the Daily graph starts to populate values (bad), and if I click into the Weekly graph that shows a value, the Utility View for the Weekly graph then shows no value. I don't understand why this is occurring if I've only extended data retention(Rows). Can someone please explain to me what I am doing wrong?

[TheWitness]

You will figure it out I hope. You are likely going in the wrong direction though. If you only want to show a daily value, you don't need so many other RRA's.

[Margylle]

I'm interested in showing a daily, weekly, monthly and yearly value, but I'd like to retain as much of the granularity of the daily graph as possible. Perhaps I'm going about this the wrong way.

Upon closer inspection, it looks like when I extend the rows for daily, weekly, monthly, yearly is that its forcing a different aggregation on weekly/monthly than I have configured. Example: changing the daily (5 minute) graph from 600 rows to say 5000 rows, it then forces 5 minute aggregation on the Weekly graph as well, instead of using 30 minute aggregation for the weekly graph.

[TheWitness]

Correct, you have to organize things the way you want them to work. Cacti will take the MIN/MAX/AVG from the 'correct' RRA. The problem with having so many rows is that by default, Cacti will be 'always' taking the MIN/MAX from the current RRA. But for the current RRA, there are never any MIN/MAX as there has technically been no aggregation from the default RRA. I'm not sure if there is a good way to separate them in the RRDtool syntax. If by studying you find a way, let us know.

[TheWitness]

Well, in RRDtool 1.8, you can define a DEF this way...

DEF:<vname>=<rrdfile>:<ds-name>:<CF>[:step=<step>][:start=<time>][:end=<time>][:reduce=<CF>][:daemon=<address>]

The trick to building in separation would be to define the step=300 for example. I think we can do that programmatically, but you need to log a feature request on GitHub.com.

That's pretty slick.

[TheWitness]

You can see that our DEF's are pretty vanilla.