Graphs not working after time snafu

[Jared]

Earlier this week I noticed that the time on my cacti server was ahead by an hour. I went to corret the time but made a bit of a typo and entered that it was July and not June. A few minutes later I noticed the mistake and corrected the time. The graphs kept working for a few hours after that but then stoped graphing any new data. My guess would be that when I set the date forward a month blank info was written to the graph and it probably wont' start graphing again until mid July. It was the only thing I could think of anyway. Equipment that was down while I changed the time still works. Any suggestions on how I might fix this problem would be apreciated.

[egarnel]

I'm guessing that if you check your logs and/or run it from the command line, rrd will complain about timestamps.

this MIGHT help:
http://people.ee.ethz.ch/~oetiker/webto ... te.en.html

N|timestamp:value[:value...]
The data used for updating the RRD was acquired at a certain time. This time can either be defined in seconds since 1970-01-01 or by using the letter 'N', in which case the update time is set to be the current time. Negative time values are subtracted from the current time. An AT_STYLE TIME SPECIFICATION (see the rrdfetch documentation) may also be used by delimiting the end of the time specification with the '@' character instead of a ':'. Getting the timing right to the second is especially important when you are working with data-sources of type COUNTER, DERIVE or

[Jared]

That does look to be the case. The time stamp on the graphs are 27 days ahead. Looking at that page I haven't been able to find a way to fix the problem although it does seem like it will start working in 27 days if I can't find a solution so that's something. Is it possible to remove the what was posted to the graph between the current date and the date that is shown in the last timestamp without loosing historical data?

[TheWitness]

Only other option would be to write a script to dump the files to XML and clear all dates from the XML file in the future and then re-import.

TheWitness

[Jared]

Pardon my ignorance but what commands would I use to dump the data to xml and then re-import it?

[TheWitness]

rrdtool dump rrdfile.rrd > rrdfile.xml

http://people.ee.ethz.ch/~oetiker/webto ... mp.en.html

rrdtool restore rrdfile.xml rrdfile.rrd

http://people.ee.ethz.ch/~oetiker/webto ... re.en.html

[Jared]

Fantastic

Thanks for your help.

[gttommy]

TheWitness: do you mean search and replace all dates from, say, 2010-10-20 00:00:02 to EST 2005-10-20 00:00:02 EST (the latest date) or 1970-10-21 00:00:02 EST (some old date)?

If one of you guys can show me your script for this it would be great - thanks!

[i'll just recreate the datasources for now...actually, I could be less lazy and look into this myself, sorry...but I'd still like to the see the script if its not too inconvenient]