Missing historical graphs

[hsmade]

Hi All,

When I click on one of a set of graphs that I created (ie. not all graphs have this issue), I don't get the historical graphs. If I select a different time period in the graph overview, I do see data.
The RRD is filled by an external script. It's definition is:

rrd_version = "0003"
step = 60
last_update = 1327317903
header_size = 1216
ds[busy].index = 0
ds[busy].type = "GAUGE"
ds[busy].minimal_heartbeat = 120
ds[busy].min = 0.0000000000e+00
ds[busy].max = NaN
ds[busy].last_ds = "9"
ds[busy].value = 3.3317433000e+01
ds[busy].unknown_sec = 0
ds[queue].index = 1
ds[queue].type = "GAUGE"
ds[queue].minimal_heartbeat = 120
ds[queue].min = 0.0000000000e+00
ds[queue].max = NaN
ds[queue].last_ds = "0"
ds[queue].value = 0.0000000000e+00
ds[queue].unknown_sec = 0
ds[nodes].index = 2
ds[nodes].type = "GAUGE"
ds[nodes].minimal_heartbeat = 120
ds[nodes].min = 0.0000000000e+00
ds[nodes].max = NaN
ds[nodes].last_ds = "147"
ds[nodes].value = 5.4418473900e+02
ds[nodes].unknown_sec = 0
rra[0].cf = "LAST"
rra[0].rows = 5256000
rra[0].cur_row = 1011496
rra[0].pdp_per_row = 1
rra[0].xff = 5.0000000000e-01
rra[0].cdp_prep[0].value = NaN
rra[0].cdp_prep[0].unknown_datapoints = 0
rra[0].cdp_prep[1].value = NaN
rra[0].cdp_prep[1].unknown_datapoints = 0
rra[0].cdp_prep[2].value = NaN
rra[0].cdp_prep[2].unknown_datapoints = 0

So I have a step of 60, heartbeat of 120 and 5256000 datapoints in the RRA, which is 'LAST'.
What do I need to do to get the historical graphs? Add another RRA with more pdp's per row? If so, how many?

[gandalf]

Wow, this effectively deactivates all consolidation, which is one of the most important features of rrdtool.
You can do that, yes.
But that RRA will only span 5256000 * 60 sec. I don't know if that is fine for you
R.

[hsmade]

;o) I know.. the request in this case was to have 10 years of data with the same detail with a frequency of 1 minute. I know, it's insane..
But how do I get cacti to show me the weekly, monthly and yearly graphs? The strange thing is that I can go back in time with cacti, but it doesn't automatically display the graphs in the overview.

[gandalf]

This should be possible. But due to the insane amount of data that has to be read for a simple 600 pixel graph, it may happen that this takes time.

Goto Graph Management, select failing graph and switch to DEBUG mode. Use the rrdtool graph command from cli (pipe output to foo.png) to see, what plain rrdtool does
R.

[hsmade]

Hmmm I think you understood me wrong. The graphs are not failing, they are just not there..
Here's a graph page that misses the historic graphs:

And here's one that does:


How do I get the first page to display the historic graphs as well? The graph debug only shows me the command line for the main graph on that page.

[gandalf]

Ah, now I understand better.
Display of "historical data" is governed by the RRA settings of the associated Data Temnplate(s). In case only one RRA definition is present, only one graph will be shown.
R.

[hsmade]

Thats what I thought, but:

Or do you mean the RRAs present in the rrd file itself?
Hmmm I guess you mean I'll have to create those mentioned RRAs in the rrd file ;o) I haven't done that because I seem to remember that one other 'strange' rrd file with 5 minute samples and the same RRA (10 years, 1pdp per RRA line), does work.

[gandalf]

Thats what I thought, but:

Yep. But the graph you have shown does not reflect the traffic graph from previous post. In fact, the related RRAs refer to some timespan that will be used to draw "historical graphs".
R.