[solved] Cacti stores only the last 5 months in RRAs

[righterch]

Hi

I've got the problem that my RRAs only stores the last 5 month, but they should store 1 year.
It runs on Debian 7.9 with cacti 0.8.8f.

my settings from RRA and data template are attached.

I've also rebuild poller cache.

It was working before. maybe there is a problem with debian update or cacit update

any idea?

[BSOD2600]

run an rrdtool info for the rrd file(s) that are driving the graph(s) in question to confirm the step/row counts.
did you alter the step/row defaults on purpose? per http://docs.cacti.net/manual:088:8_rrdtool they're no longer stock.

[righterch]

Hmm The yearly header in RRA looks different:

Code: Select all

filename = "/var/www/cacti/rra/herkules_traffic_in_538.rrd"
rrd_version = "0003"
step = 60
last_update = 1445322003
header_size = 6080
ds[traffic_in].index = 0
ds[traffic_in].type = "DERIVE"
ds[traffic_in].minimal_heartbeat = 120
ds[traffic_in].min = 0.0000000000e+00
ds[traffic_in].max = 1.0000000000e+09
ds[traffic_in].last_ds = "U"
ds[traffic_in].value = NaN
ds[traffic_in].unknown_sec = 3
ds[traffic_out].index = 1
ds[traffic_out].type = "DERIVE"
ds[traffic_out].minimal_heartbeat = 120
ds[traffic_out].min = 0.0000000000e+00
ds[traffic_out].max = 1.0000000000e+09
ds[traffic_out].last_ds = "1938763667"
ds[traffic_out].value = 2.2909030000e+06
ds[traffic_out].unknown_sec = 0
rra[0].cf = "AVERAGE"
rra[0].rows = 500
rra[0].cur_row = 220
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[1].cf = "AVERAGE"
rra[1].rows = 600
rra[1].cur_row = 406
rra[1].pdp_per_row = 1
rra[1].xff = 5.0000000000e-01
rra[1].cdp_prep[0].value = NaN
rra[1].cdp_prep[0].unknown_datapoints = 0
rra[1].cdp_prep[1].value = NaN
rra[1].cdp_prep[1].unknown_datapoints = 0
rra[2].cf = "AVERAGE"
rra[2].rows = 700
rra[2].cur_row = 687
rra[2].pdp_per_row = 6
rra[2].xff = 5.0000000000e-01
rra[2].cdp_prep[0].value = 0.0000000000e+00
rra[2].cdp_prep[0].unknown_datapoints = 2
rra[2].cdp_prep[1].value = 9.8021562158e+05
rra[2].cdp_prep[1].unknown_datapoints = 0
rra[3].cf = "AVERAGE"
rra[3].rows = 775
rra[3].cur_row = 84
rra[3].pdp_per_row = 24
rra[3].xff = 5.0000000000e-01
rra[3].cdp_prep[0].value = 0.0000000000e+00
rra[3].cdp_prep[0].unknown_datapoints = 20
rra[3].cdp_prep[1].value = 6.0195763754e+06
rra[3].cdp_prep[1].unknown_datapoints = 0
rra[4].cf = "AVERAGE"
rra[4].rows = 797
rra[4].cur_row = 215
rra[4].pdp_per_row = 288
rra[4].xff = 5.0000000000e-01
rra[4].cdp_prep[0].value = 0.0000000000e+00
rra[4].cdp_prep[0].unknown_datapoints = 92
rra[4].cdp_prep[1].value = 3.4554461984e+07
rra[4].cdp_prep[1].unknown_datapoints = 0
rra[5].cf = "MIN"
rra[5].rows = 600
rra[5].cur_row = 215
rra[5].pdp_per_row = 1
rra[5].xff = 5.0000000000e-01
rra[5].cdp_prep[0].value = NaN
rra[5].cdp_prep[0].unknown_datapoints = 0
rra[5].cdp_prep[1].value = NaN
rra[5].cdp_prep[1].unknown_datapoints = 0
rra[6].cf = "MIN"
rra[6].rows = 700
rra[6].cur_row = 312
rra[6].pdp_per_row = 6
rra[6].xff = 5.0000000000e-01
rra[6].cdp_prep[0].value = inf
rra[6].cdp_prep[0].unknown_datapoints = 2
rra[6].cdp_prep[1].value = 2.4264212242e+05
rra[6].cdp_prep[1].unknown_datapoints = 0
rra[7].cf = "MIN"
rra[7].rows = 775
rra[7].cur_row = 460
rra[7].pdp_per_row = 24
rra[7].xff = 5.0000000000e-01
rra[7].cdp_prep[0].value = inf
rra[7].cdp_prep[0].unknown_datapoints = 20
rra[7].cdp_prep[1].value = 9.5469174167e+04
rra[7].cdp_prep[1].unknown_datapoints = 0
rra[8].cf = "MIN"
rra[8].rows = 797
rra[8].cur_row = 60
rra[8].pdp_per_row = 288
rra[8].xff = 5.0000000000e-01
rra[8].cdp_prep[0].value = inf
rra[8].cdp_prep[0].unknown_datapoints = 92
rra[8].cdp_prep[1].value = 9.5469174167e+04
rra[8].cdp_prep[1].unknown_datapoints = 0
rra[9].cf = "MAX"
rra[9].rows = 500
rra[9].cur_row = 379
rra[9].pdp_per_row = 1
rra[9].xff = 5.0000000000e-01
rra[9].cdp_prep[0].value = NaN
rra[9].cdp_prep[0].unknown_datapoints = 0
rra[9].cdp_prep[1].value = NaN
rra[9].cdp_prep[1].unknown_datapoints = 0
rra[10].cf = "MAX"
rra[10].rows = 600
rra[10].cur_row = 124
rra[10].pdp_per_row = 1
rra[10].xff = 5.0000000000e-01
rra[10].cdp_prep[0].value = NaN
rra[10].cdp_prep[0].unknown_datapoints = 0
rra[10].cdp_prep[1].value = NaN
rra[10].cdp_prep[1].unknown_datapoints = 0
rra[11].cf = "MAX"
rra[11].rows = 700
rra[11].cur_row = 419
rra[11].pdp_per_row = 6
rra[11].xff = 5.0000000000e-01
rra[11].cdp_prep[0].value = -inf
rra[11].cdp_prep[0].unknown_datapoints = 2
rra[11].cdp_prep[1].value = 7.3757349917e+05
rra[11].cdp_prep[1].unknown_datapoints = 0
rra[12].cf = "MAX"
rra[12].rows = 775
rra[12].cur_row = 331
rra[12].pdp_per_row = 24
rra[12].xff = 5.0000000000e-01
rra[12].cdp_prep[0].value = -inf
rra[12].cdp_prep[0].unknown_datapoints = 20
rra[12].cdp_prep[1].value = 7.3757349917e+05
rra[12].cdp_prep[1].unknown_datapoints = 0
rra[13].cf = "MAX"
rra[13].rows = 797
rra[13].cur_row = 447
rra[13].pdp_per_row = 288
rra[13].xff = 5.0000000000e-01
rra[13].cdp_prep[0].value = -inf
rra[13].cdp_prep[0].unknown_datapoints = 92
rra[13].cdp_prep[1].value = 9.2499649153e+05
rra[13].cdp_prep[1].unknown_datapoints = 0
rra[14].cf = "LAST"
rra[14].rows = 500
rra[14].cur_row = 90
rra[14].pdp_per_row = 1
rra[14].xff = 5.0000000000e-01
rra[14].cdp_prep[0].value = NaN
rra[14].cdp_prep[0].unknown_datapoints = 0
rra[14].cdp_prep[1].value = NaN
rra[14].cdp_prep[1].unknown_datapoints = 0
rra[15].cf = "LAST"
rra[15].rows = 600
rra[15].cur_row = 571
rra[15].pdp_per_row = 1
rra[15].xff = 5.0000000000e-01
rra[15].cdp_prep[0].value = NaN
rra[15].cdp_prep[0].unknown_datapoints = 0
rra[15].cdp_prep[1].value = NaN
rra[15].cdp_prep[1].unknown_datapoints = 0
rra[16].cf = "LAST"
rra[16].rows = 700
rra[16].cur_row = 247
rra[16].pdp_per_row = 6
rra[16].xff = 5.0000000000e-01
rra[16].cdp_prep[0].value = NaN
rra[16].cdp_prep[0].unknown_datapoints = 2
rra[16].cdp_prep[1].value = 7.3757349917e+05
rra[16].cdp_prep[1].unknown_datapoints = 0
rra[17].cf = "LAST"
rra[17].rows = 775
rra[17].cur_row = 500
rra[17].pdp_per_row = 24
rra[17].xff = 5.0000000000e-01
rra[17].cdp_prep[0].value = NaN
rra[17].cdp_prep[0].unknown_datapoints = 20
rra[17].cdp_prep[1].value = 7.3757349917e+05
rra[17].cdp_prep[1].unknown_datapoints = 0
rra[18].cf = "LAST"
rra[18].rows = 797
rra[18].cur_row = 100
rra[18].pdp_per_row = 288
rra[18].xff = 5.0000000000e-01
rra[18].cdp_prep[0].value = NaN
rra[18].cdp_prep[0].unknown_datapoints = 92
rra[18].cdp_prep[1].value = 7.3757349917e+05
rra[18].cdp_prep[1].unknown_datapoints = 0

and the rrdtol dump:

Code: Select all

	</rra>
	<rra>
		<cf>LAST</cf>
		<pdp_per_row>288</pdp_per_row> <!-- 17280 seconds -->

		<params>
		<xff>5.0000000000e-01</xff>
		</params>
		<cdp_prep>
			<ds>
			<primary_value>NaN</primary_value>
			<secondary_value>NaN</secondary_value>
			<value>NaN</value>
			<unknown_datapoints>92</unknown_datapoints>
			</ds>
			<ds>
			<primary_value>7.2486270564e+05</primary_value>
			<secondary_value>7.2486270564e+05</secondary_value>
			<value>7.3757349917e+05</value>
			<unknown_datapoints>0</unknown_datapoints>
			</ds>
		</cdp_prep>
		<database>

I changed the rows because on a post from merlin, can't remember which one.


The rows should be longer or??

[BSOD2600]

It really depends on how long you want to keep and consolidate the data. http://oss.oetiker.ch/rrdtool/doc/rrdcreate.en.html has all the details.
there are some online calculators which can assist with doing the math too

[righterch]

ok you're right I've changed them, but that has no effect, because the RRD's were cretated with the default values.
so I changed it back to the default as it also shows up int my rrdtool info <>

But why isn't my graph only 5 months instead of one year???

[BSOD2600]

Cacti never modifies existing rrd files. you must do that yourself with the 'rrdtool tune' command (or use one of the various scripts on the Internet).

[righterch]

Hmm I Found the problem
I used the original values with 288 steps, 797 rows and timespan of 33053184.
But with these values it wasn't working.
I had to increase the rows to 1900 to store one year:

/resize.pl -f rra/xa.rrd -s 797 -g 1103 -o .