no poller items after upgrade

[gonecrazy]

I upgraded from 0.8.7 to 0.8.7a and all the graphs stopped updating. I updated the functions.php file that didn't help, and when i run the poller in debug mode it shows:

POLLER: Poller[0] NOTE: There are no items in your poller for this polling cycle!

not sure how to solve this problem, i clicked the rebuild poller cache and that shows no items either.

any ideas?

[BSOD2600]

in cacti's settings-> poller, make sure both cron and poller are set to 5 min. When you manually run cmd.php (only use for debugging!) and cacti's logging level set to debug, what do you see?

[gonecrazy]

I get a lot of:

<b>Notice</b>: Undefined index: snmp_context in <b>/var/www/cacti/lib/functions.php</b> on line <b>326</b><br />

followed by:

POLLER: Poller[0] NOTE: There are no items in your poller for this polling cycle!

as the last line.

and yes they are both set to 5mins

[BSOD2600]

You might try downloading that functions.php file again -- you shouldn't be getting that error.

AS for the other error -- are there devices you've set to poll?

[gonecrazy]

yea all my devices are set to poll.

After searching so more on the forums i think I might have found something. When i do a

show columns from host;

I seem to be missing:

snmp_context | varchar(64) | YES | | NULL | |

even though i went trough the upgrade procedure.

is this a vital field? as in if i add it do i need to populate it with anything for my existing hosts to work? ( i will try looking through the past upgrade scripts and find one that did this upgrade to see the query)

I think that what is happening is the poller is trying to pull the hosts out of the database and since this field is missing is choking on that and just heading to the next host, hence no hosts to poll.[/quote]

[gonecrazy]

ok after running the sql statements that are contained in:

Code: Select all

0_8_6j_to_0_8_7.php:    db_install_execute("0.8.7", "ALTER TABLE `host` ADD COLUMN `snmp_context` VARCHAR(64) default '' AFTER `snmp_priv_protocol`");
0_8_6j_to_0_8_7.php:    db_install_execute("0.8.7", "ALTER TABLE `poller_item` ADD COLUMN `snmp_context` VARCHAR(64) default '' AFTER `snmp_priv_protocol`");

and rebuilding the cache.

Poof my problem goes away and everything is graphing again. don't ask me how i managed to get upgraded to 0.8.7 without that happing, probably had something to do with a beta and a big "DON'T USE THIS IN PRODUCTION STUPID" warning i ignored.

I have one other issue, but i will start a new thread for that.