Graph resolution and poller errors

[harp2812]

The resolution on my graphs seems to have changed suddenly, and I'm not sure what's changed...
Everything looked normal this morning, and now each graph interval covers several hours and my graphs look like this:


I'm also getting numerous errors in my logs:

Code: Select all

10/30/2007 12:00:31 PM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"select value from settings_graphs where name='custom_fonts' and user_id="
10/30/2007 12:00:31 PM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"select value from settings_graphs where name='default_datechar' and user_id="
10/30/2007 12:00:31 PM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"select value from settings_graphs where name='default_date_format' and user_id="

Any suggestions as to what may have happened? I'm at a loss...

cron entry: */5 * * * * cactiuser php /var/www/html/cacti/poller.php > /dev/null 2>&1

Poller interval is set to 5min in the configuration settings, and nothing has been changed that I'm aware of...

[harp2812]

I think I've found the problem... a fellow admin was playing with ntp this morning, which I discovered when I noticed the dates & times on the rrd files are incorrect (most being future dates and times).

My best guess is this is causing problems with cacti / rrdtool's timelines, including scaling issues and creation of new rrd files (which might also very well be due to permissions based on my clumsy attempts to fix it). Rather than try and clean it up, I think I'm just going to do a clean install and count the historical data as lost...