There are no items in your poller cache

[klavs]

I'm getting this, after having run "Clear Poller Cache" under utilities:

#su cactiuser -c "/usr/bin/php -d include_path=/home/cactiuser/cacti/ /home/cactiuser/cacti/cmd.php"

There are no items in your poller cache. Make sure you have at least one data source created. If you do, go to 'Utilities', and select 'Clear Poller Cache'.
time: 0

What do I do? I tried using Clear Poller Cache again, but it didn't help

[raX]

Try running the following SQL and see if it helps:

Code: Select all

update host set disabled='';

-Ian

[klavs]

I did that, but it didn't change anything

I can retrieve any information from the DB or whereever you want.

[raX]

After some playing around I noticed the problems you are speaking of. Because this is a critical function, I released 0.8.2a to fix it. Check out my post in the announcements forum for more details.

-Ian

[Martin]

I updated from 0.8.2 to 0.8.2a and my graphs stopped updating.
I cleared the poller cache, but without result. I am getting the same message mentioned above.

Martin

[raX]

Somehow your poller cache table has an incorrect schema. Can you run the following SQL and show me the results?

Code: Select all

describe data_input_data_cache;

-Ian

[martin]

This is the output from 'describe data_input_data_cache;'

Field Type Null Key Default Extra
local_data_id mediumint(8) unsigned PRI 0
host_id mediumint(8) 0
data_input_id mediumint(8) unsigned 0
action tinyint(2) 1
command varchar(255)
management_ip varchar(15)
snmp_community varchar(100)
snmp_version tinyint(1) 0
snmp_username varchar(50)
snmp_password varchar(50)
rrd_name varchar(19) PRI
rrd_path varchar(255)
arg1 varchar(255) YES NULL
arg2 varchar(255) YES NULL
arg3 varchar(255) YES NULL

[martin]

I just saw your release anouncement for cactie 0.8.2a
I didn't run the sql statement .

Code: Select all

ALTER TABLE `data_input_data_cache` ADD `rrd_num` TINYINT( 2 ) UNSIGNED NOT NULL AFTER `rrd_path`;

after this, everything worked again....