[rrd-users] Big trouble with resize rrd file

Mario Jr. mario.provedor at viareal.com.br
Thu Sep 16 20:55:24 CEST 2010


Hi,

I'll try explain my situation:

I created a RRD file using this command:

rrdtool create test1.rrd --step 300 \
DS:bitsIn:DERIVE:600:0:U \
DS:bitsOut:DERIVE:600:0:U \
RRA:AVERAGE:0.5:1:800 \
RRA:AVERAGE:0.5:6:800 \
RRA:AVERAGE:0.5:24:800 \
RRA:AVERAGE:0.5:288:800 \
RRA:MAX:0.5:1:800 \
RRA:MAX:0.5:6:800 \
RRA:MAX:0.5:24:800 \
RRA:MAX:0.5:288:800

I have many files in server, one by customer. I have some scripts wich create and update then (is not the case). Since 2 years ago, its work perfectly, showing day, week, month and year graphs.

Howerver, now, i need to keep last 180 days, in 5 minutes resolution, in this files.

I simply run this command:

rrdtool resize test1.rrd 0 GROW 52768

This command, sets 53568 rows for RRA 0.

So the rrd file, is now, have the format:

filename = "test1.rrd"
rrd_version = "0003"
step = 300
last_update = 1284659413
ds[bitsIn].type = "DERIVE"
ds[bitsIn].minimal_heartbeat = 600
ds[bitsIn].min = 0.0000000000e+00
ds[bitsIn].max = NaN
ds[bitsIn].last_ds = "2717969512"
ds[bitsIn].value = 2.9586434783e+05
ds[bitsIn].unknown_sec = 0
ds[bitsOut].type = "DERIVE"
ds[bitsOut].minimal_heartbeat = 600
ds[bitsOut].min = 0.0000000000e+00
ds[bitsOut].max = NaN
ds[bitsOut].last_ds = "20671586016"
ds[bitsOut].value = 2.1730013913e+06
ds[bitsOut].unknown_sec = 0
rra[0].cf = "AVERAGE"
rra[0].rows = 53568
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 = 800
rra[1].pdp_per_row = 6
rra[1].xff = 5.0000000000e-01
[...]


The big problem:

Before the resize, when i run "rrdtool fetch test1.rrd AVERAGE -r 1800 -s -1w", returns:

1284057000: 3.4084031790e+04 2.6132590178e+05
1284058800: 7.6816654190e+04 3.3766027811e+05
1284060600: 5.3355156897e+04 3.2887164485e+05
1284062400: 5.8641710980e+04 2.3696226381e+05
1284064200: 3.8370010026e+04 1.8178822367e+05
[...]

Note that resolution is 1800, wich the diference between the timestamps. Therefore, when i generate the graph, it show correctly.

AFTER RESIZE, when i run "rrdtool fetch test1.rrd AVERAGE -r 1800 -s -1w", returns:

1284056400: nan nan
1284056700: nan nan
1284057000: nan nan
1284057300: nan nan
1284057600: nan nan
[...]

Note that resolution, even forced resolution with "-r 1800" the fetch returns rows with resolution of 300 seconds between rows. Therefore, when i generate the graph, it is shown wrong, only last 2 days.

What may be happening? Help me!

RRDtool 1.2.15


Mário Jr.
Provedor Via Real
Wireless ISP


Ps.: Sorry for my bad english
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.oetiker.ch/pipermail/rrd-users/attachments/20100916/01316838/attachment-0001.htm 


More information about the rrd-users mailing list