Hello, I've been having some trouble getting the desired data from an rrd using xport. I realize that I could use dump, but that spits out too much data... slows things down in another process. Anyway, I appreciate any advice. Here's my problem:
My rrd was created by Cricket. I want all the data from the second RRA (the 1/2 hour readings) dumped or exported to XML. I believe RRDtool will do it for me using the xport command, but I can't seem to get all 600 samples. It always gives me about half of them. For example... below is the structure of the rrd (from rrdtoool info). I'm only interested in the first datasource: > filename = "/opt/cricket/cricket-data/bepc/generation/cwp.rrd" > rrd_version = "0001" > step = 300 > last_update = 1045083365 > ds[ds0].type = "GAUGE" > ds[ds0].minimal_heartbeat = 1800 > ds[ds0].min = 0.0000000000e+00 > ds[ds0].max = NaN > ds[ds0].last_ds = "UNKN" > ds[ds0].value = 0.0000000000e+00 > ds[ds0].unknown_sec = 0 > ds[ds1].type = "GAUGE" > ds[ds1].minimal_heartbeat = 1800 > ds[ds1].min = 0.0000000000e+00 > ds[ds1].max = NaN > ds[ds1].last_ds = "UNKN" > ds[ds1].value = 0.0000000000e+00 > ds[ds1].unknown_sec = 0 > ds[ds2].type = "GAUGE" > ds[ds2].minimal_heartbeat = 1800 > ds[ds2].min = 0.0000000000e+00 > ds[ds2].max = NaN > ds[ds2].last_ds = "UNKN" > ds[ds2].value = 0.0000000000e+00 > ds[ds2].unknown_sec = 0 > ds[ds3].type = "GAUGE" > ds[ds3].minimal_heartbeat = 1800 > ds[ds3].min = 0.0000000000e+00 > ds[ds3].max = NaN > ds[ds3].last_ds = "UNKN" > ds[ds3].value = 0.0000000000e+00 > ds[ds3].unknown_sec = 0 > rra[0].cf = "AVERAGE" > rra[0].rows = 600 > 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 > rra[0].cdp_prep[3].value = NaN > rra[0].cdp_prep[3].unknown_datapoints = 0 > rra[1].cf = "AVERAGE" > rra[1].rows = 600 > rra[1].pdp_per_row = 6 > rra[1].xff = 5.0000000000e-01 > rra[1].cdp_prep[0].value = 1.3655952921e+02 > rra[1].cdp_prep[0].unknown_datapoints = 0 > rra[1].cdp_prep[1].value = 0.0000000000e+00 > rra[1].cdp_prep[1].unknown_datapoints = 0 > rra[1].cdp_prep[2].value = 0.0000000000e+00 > rra[1].cdp_prep[2].unknown_datapoints = 0 > rra[1].cdp_prep[3].value = 0.0000000000e+00 > rra[1].cdp_prep[3].unknown_datapoints = 0 > rra[2].cf = "AVERAGE" > rra[2].rows = 600 > rra[2].pdp_per_row = 24 > rra[2].xff = 5.0000000000e-01 > rra[2].cdp_prep[0].value = 2.3305825580e+02 > rra[2].cdp_prep[0].unknown_datapoints = 0 > rra[2].cdp_prep[1].value = 0.0000000000e+00 > rra[2].cdp_prep[1].unknown_datapoints = 0 > rra[2].cdp_prep[2].value = 0.0000000000e+00 > rra[2].cdp_prep[2].unknown_datapoints = 0 > rra[2].cdp_prep[3].value = 0.0000000000e+00 > rra[2].cdp_prep[3].unknown_datapoints = 0 > rra[3].cf = "MAX" > rra[3].rows = 600 > rra[3].pdp_per_row = 24 > rra[3].xff = 5.0000000000e-01 > rra[3].cdp_prep[0].value = 4.3076666667e+01 > rra[3].cdp_prep[0].unknown_datapoints = 0 > rra[3].cdp_prep[1].value = 0.0000000000e+00 > rra[3].cdp_prep[1].unknown_datapoints = 0 > rra[3].cdp_prep[2].value = 0.0000000000e+00 > rra[3].cdp_prep[2].unknown_datapoints = 0 > rra[3].cdp_prep[3].value = 0.0000000000e+00 > rra[3].cdp_prep[3].unknown_datapoints = 0 > rra[4].cf = "AVERAGE" > rra[4].rows = 600 > rra[4].pdp_per_row = 288 > rra[4].xff = 5.0000000000e-01 > rra[4].cdp_prep[0].value = 2.9970983237e+02 > rra[4].cdp_prep[0].unknown_datapoints = 234 > rra[4].cdp_prep[1].value = 0.0000000000e+00 > rra[4].cdp_prep[1].unknown_datapoints = 225 > rra[4].cdp_prep[2].value = 0.0000000000e+00 > rra[4].cdp_prep[2].unknown_datapoints = 225 > rra[4].cdp_prep[3].value = 0.0000000000e+00 > rra[4].cdp_prep[3].unknown_datapoints = 225 > rra[5].cf = "MAX" > rra[5].rows = 600 > rra[5].pdp_per_row = 288 > rra[5].xff = 5.0000000000e-01 > rra[5].cdp_prep[0].value = 4.3076666667e+01 > rra[5].cdp_prep[0].unknown_datapoints = 234 > rra[5].cdp_prep[1].value = 0.0000000000e+00 > rra[5].cdp_prep[1].unknown_datapoints = 225 > rra[5].cdp_prep[2].value = 0.0000000000e+00 > rra[5].cdp_prep[2].unknown_datapoints = 225 > rra[5].cdp_prep[3].value = 0.0000000000e+00 > rra[5].cdp_prep[3].unknown_datapoints = 225 Here is how I'm trying to export the data: > /opt/RRDTool/bin/rrdtool xport \ > --start -12.5days --step 1800 \ > DEF:generation=.../cwp.rrd:ds1:AVERAGE \ > XPORT:generation:: And here is what the xport spits out (notice only 242 rows, not 600): > <?xml version="1.0" encoding="ISO-8859-1"?> > > <xport> > <meta> > <start>1044651600</start> > <step>1800</step> > <end>1045085400</end> > <rows>242</rows> <--- why not 600? > <columns>1</columns> > <legend> > <entry></entry> > </legend> > </meta> > <data> > <row><t>1044651600</t><v>0.0000000000e+00</v></row> > <row><t>1044653400</t><v>0.0000000000e+00</v></row> > . . . > </data> > </xport> Any help would be appreciated! Thanks, -- Jason Signalness, Systems Administrator Basin Telecommunications, Inc. -- -- Unsubscribe mailto:[EMAIL PROTECTED] Help mailto:[EMAIL PROTECTED] Archive http://www.ee.ethz.ch/~slist/rrd-users WebAdmin http://www.ee.ethz.ch/~slist/lsg2.cgi
