Ad blocker detected: Our website is made possible by displaying online advertisements to our visitors. Please consider supporting us by disabling your ad blocker on our website.
Due to a typo (and then forgetting the syntax) I accidently set my clock forward to 2022. Then cacti's poller ran. I set my clock back, but by then the last run time in cacti's database was in 2022.
I edited the value in the table, and ran cacti's poller successfully. However, now it seems all of the RRD's are screwed.
ERROR: /var/www/localhost/htdocs/admin/cacti/rra/ext_output_142.rrd: illegal attempt to update using time 1246046483 when last update time is 1662955232 (minimum one second step)
I could wipe out the rrd's and start over, but I have 6 months of history I'd like to keep. Is there any way to delete any data from the RRD's after, say 2015, to repair them and let new data enter?
Linegod wrote:Export your RRDs to XML (man rrddump), replace all entries with times in the future with 'NaN' and then set the lastupdate to '0' (zero).
Restore the RRD files (man rrdrestore) and you should be good to go.
Should be quite simple to wrap this in a script...
Thanks for the reply. I've exported them, and looked through them, and I can't find any data. The only dates in the exports are in 2022, or 2021, or 2020 sometimes. I suspect that since my RRD's were set up in 5 min, hour, daily, weekly, yearly, and 5-year mode (not sure what you call it); that when it saw 2022, it dumped all of this "old" data. Does that seem right?
Sorry about that. Maintaining clock is "essential". This is one of the reasons I fear VM's. It's only a fear, like that of heights, cold water, tomatoes, artichokes, etc.
TheWitness
True understanding begins only when we realize how little we truly understand...
