|

»

Insert OLD data into RRD files

View: New views

3 Messages — Rating Filter: Alert me

	Insert OLD data into RRD files by Alexander Skwar-6 :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message Hello! Is there a way to insert OLD data into RRD files? I tried: $ rrdtool updatev 269.rrd 1241121600:852 return_value = -1 ERROR: 269.rrd: illegal attempt to update using time 1241121600 when last update time is 1245323161 (minimum one second step) Searching the lists, I found a post from 2003 http://osdir.com/ml/db.rrdtool.user/2003-01/msg00128.html which says, that it's not possible to load old data. Is that still true? What would I need to do, to get old data into my RRD file(s)? - Dump contents - Create empty new RRD file - Load data, INCLUDING old data and dumped content Would that be the correct approach? The RRD files have been created by Cacti and I don't have the slightest clue HOW they were created. Given the following rrdtool dumped XML file (where I removed ALL the values in the <database> sections), what would be the command to recreate the RRD file? http://files.getdropbox.com/u/135660/Cacti/269.rrd.blank.xml Thanks a lot, Alexander -- [[ http://zensursula.net ]] [ Soc. => http://twitter.com/alexs77 \| http://www.plurk.com/alexs77 ] [ Mehr => http://zyb.com/alexws77 ] [ Chat => Jabber: alexws77@... \| Google Talk: a.skwar@... ] [ Mehr => AIM: alexws77 ] _______________________________________________ rrd-users mailing list rrd-users@... https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users
	Re: Insert OLD data into RRD files by Andy Riebs :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message Alexander, It's still true that it's difficult to load "old" data, though this is actually desirable in large monitoring operations where an invalid timestamp could skew all manner of results. For an occasional back-dated update, the easiest thing to do is 1. Dump the database 2. Edit the dump file by hand, duplicating a valid XML stanza from immediately before or after the desired update time, and updating it with the missing data, in chronological sequence 3. Restore the database HTH! Andy On Thu, 2009-06-18 at 11:41 +0000, Alexander Skwar wrote: > Hello! > > Is there a way to insert OLD data into RRD files? I tried: > > $ rrdtool updatev 269.rrd 1241121600:852 > return_value = -1 > ERROR: 269.rrd: illegal attempt to update using time 1241121600 when > last update time is 1245323161 (minimum one second step) > > Searching the lists, I found a post from 2003 > http://osdir.com/ml/db.rrdtool.user/2003-01/msg00128.html > which says, that it's not possible to load old data. > > Is that still true? > > What would I need to do, to get old data into my RRD file(s)? > > - Dump contents > - Create empty new RRD file > - Load data, INCLUDING old data and dumped content > > Would that be the correct approach? > > The RRD files have been created by Cacti and I don't have > the slightest clue HOW they were created. Given the following > rrdtool dumped XML file (where I removed ALL the values > in the <database> sections), what would be the command > to recreate the RRD file? > > http://files.getdropbox.com/u/135660/Cacti/269.rrd.blank.xml > > Thanks a lot, > > Alexander > -- > [[ http://zensursula.net ]] > [ Soc. => http://twitter.com/alexs77 \| http://www.plurk.com/alexs77 ] > [ Mehr => http://zyb.com/alexws77 ] > [ Chat => Jabber: alexws77@... \| Google Talk: > a.skwar@... ] > [ Mehr => AIM: alexws77 ] > > -- Progress comes in many flavors! Andy Riebs, HP Scalable Computing and Infrastructure / Catalysts (w) andy.riebs@... Technology for better business outcomes +1.508.467.3002 (In office Tue & Wed, IM or mail other days) (h) andy@... My opinions are not necessarily those of HP _______________________________________________ rrd-users mailing list rrd-users@... https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users
	Re: Insert OLD data into RRD files by Alexander Skwar-6 :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message Okay, understood. Thanks a lot! On Thu, Jun 18, 2009 at 14:38, Andy Riebs <andy.riebs@...> wrote: Alexander, It's still true that it's difficult to load "old" data, though this is actually desirable in large monitoring operations where an invalid timestamp could skew all manner of results. For an occasional back-dated update, the easiest thing to do is 1. Dump the database 2. Edit the dump file by hand, duplicating a valid XML stanza from immediately before or after the desired update time, and updating it with the missing data, in chronological sequence 3. Restore the database HTH! Andy On Thu, 2009-06-18 at 11:41 +0000, Alexander Skwar wrote: > Hello! > > Is there a way to insert OLD data into RRD files? I tried: > > $ rrdtool updatev 269.rrd 1241121600:852 > return_value = -1 > ERROR: 269.rrd: illegal attempt to update using time 1241121600 when > last update time is 1245323161 (minimum one second step) > > Searching the lists, I found a post from 2003 > http://osdir.com/ml/db.rrdtool.user/2003-01/msg00128.html > which says, that it's not possible to load old data. > > Is that still true? > > What would I need to do, to get old data into my RRD file(s)? > > - Dump contents > - Create empty new RRD file > - Load data, INCLUDING old data and dumped content > > Would that be the correct approach? > > The RRD files have been created by Cacti and I don't have > the slightest clue HOW they were created. Given the following > rrdtool dumped XML file (where I removed ALL the values > in the <database> sections), what would be the command > to recreate the RRD file? > > http://files.getdropbox.com/u/135660/Cacti/269.rrd.blank.xml > > Thanks a lot, > > Alexander > -- > [[ http://zensursula.net ]] > [ Soc. => http://twitter.com/alexs77 \| http://www.plurk.com/alexs77 ] > [ Mehr => http://zyb.com/alexws77 ] > [ Chat => Jabber: alexws77@... \| Google Talk: > a.skwar@... ] > [ Mehr => AIM: alexws77 ] > > -- Progress comes in many flavors! Andy Riebs, HP Scalable Computing and Infrastructure / Catalysts (w) andy.riebs@... Technology for better business outcomes +1.508.467.3002 (In office Tue & Wed, IM or mail other days) (h) andy@... My opinions are not necessarily those of HP -- Alexander -- [[ http://zensursula.net ]] [ Soc. => http://twitter.com/alexs77 \| http://www.plurk.com/alexs77 ] [ Mehr => http://zyb.com/alexws77 ] [ Chat => Jabber: alexws77@... \| Google Talk: a.skwar@... ] [ Mehr => AIM: alexws77 ] _______________________________________________ rrd-users mailing list rrd-users@... https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users