RRA doesn't update

[vogl]

Hi,

I upgrade cacti to new version on my debian testing (now is version 0.8.7.b). After upgrade my graphs is empty and rras doesn't upgrade too.

I check all logs (poller.log, cacti.log) all seems to working fine.
In MySql is table poller which has new records.

Can you help me ?

Piece of mys cacti.log
02/20/2008 10:25:01 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT * FROM poller_item WHERE rrd_next_step<=0 ORDER by host_id"
02/20/2008 10:25:01 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "SELECT count(*) from poller_item WHERE (action=2 AND rrd_next_step<=0)"
02/20/2008 10:25:01 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select * from host where disabled = '' order by id"
02/20/2008 10:25:01 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "SELECT count(*) from po

poller-error.log is empty

[vogl]

Problem is in the table poller_output. There is about 1000000 records and poller hangs.

[fmangeant]

Hi

can you try to truncate the poller_output table ?

[TheWitness]

Should not be required, as 0.8.7 truncates if it finds that it is non-empty upon poller startup. I am guessing either permissions or something else more dramatic. Should run "php poller.php" as the CRON user and look for nasty messages, like permission denied.

TheWitness

[new]

Hello,

I have upgraded from 0.8.6j to 0.8.7b and have a similar problem. The last 4 weeks of graphs are lost, so all the graphs are there, the permissions are OK, only those 4 weeks are lost for all the graphs! Maybe it has something to do with new rra's of 1 minute average? All the settings are as they were before the upgrade.

Is it possible to avoid the situation?

Many thanks in advance for any help!

[new]

Any ideas? Did somebody have similar problems during the migration?