system time changed - now cacti wont graph

[xoerez]

hey all,

I run cacti on a production machine and it is used to monitor almost everything in our servers.
today i found out that the machine time has changed to the future,
so i changed it back to the current correct time.

now cacti wont graph with this error:
(when runned from console:
cactiuser$ /usr/bin/php /var/www/html/cacti/poller.php)
ERROR: illegal attempt to update using time 1143480008 when last update time is 1564002003 (minimum one second step)
ERROR: illegal attempt to update using time 1143480008 when last update time is 1564002003 (minimum one second step)
ERROR: illegal attempt to update using time 1143480008 when last update time is 1564002003 (minimum one second step)

is there a way to re-set the timestemps in the database ?

help is very much welcome since the graphing is very important to us.

OS: centos 4.2
php: 4.4.2
cacti: 0.8.6h

thanks,

-- xoerez

[beltran]

once i have the same problem, but it will be ok until the difference time dissapears

[gandalf]

Oh nooooo!
This cannot be cured easily. There's no such thing as "deleting" entries from rrd files (AFAIK, please search http://www.rrdtool.orgs download area). Homebrewed, I'd like to recommend:
- dump each and every rrd db (rrddump)
- edit the XML file to delete the unwanted timestamps (or change the timestamp to those, that would have been correct)
- restore (rrdrestore) those XML files
seems not to be THAT easy task
Reinhard