SNMP CACHE

[lwascher]

My SNMP Cache has 7511 items in it? What exactly does it do, and is there a way to clear it?? Also, everytime I hit the "Clear Ploller Cache" button, when I log out then back in, there are still the same number of items in the Poller cache.

[rony]

It's normal for the poller cache to have items in it.

When you clear it, it is accually rebuilding it too.

This is what the poller accually uses to poll the devices.

[skaminski]

I get a timeout when I try to clear my poller cache. I'm thinking a corrupted poller cache is causing me issues with my graphs not updating. Is there a way to manually clear the cache?

[rony]

Run the following query on the cacti database:

Code: Select all

DELETE FROM poller_item;
DELETE FROM poller_output;

Make sure you do this while a polling cycle is not running.

This will clear out the poller_cache, which you should run the Clear Poller Cache again, this will rebuild it.

I added the clearing of the poller_output table, just to make sure. This is where the pollers drop data that the poller.php comes back and writes to the rrd files.

[skaminski]

MYSQL Newbie here...

Can you assist me with how to run that? I went to c:\mysql\bin and ran mysql
I'm trying to open the cacti database so i can run the commands. I've forgotten how to specify the database user

Could you help?

[rony]

Typically, you run:

Code: Select all

mysql -u cactiuser -p

This will prompt your for your password.

Then run the following inside the client.

Code: Select all

USE cacti;
DELETE FROM poller_item;
DELETE FROM poller_output;

When it comes to using mysql on windows, you have a one up on me, you are doing it.

[skaminski]

I figured it out after a bunch of tries. Anyway, I did that and I'll see if it helps.

thanks
Sean

[skaminski]

So, how do i recreate the poller cache now that it has 0 items in it?

[rony]

You run the Clear Poller Cache from the Utilities Section.

[skaminski]

Well, i was hoping that this would fix the problem I'm having with the graphs not working. Unfortunately, it's not. I'm still not able to clear the poller cache from the web page.

Should the numbers of items in my poller cache roughly equal the items in the rra folder?

[rony]

Correct, btw, "Clear Poller Cache" should read "Rebuild Poller Cache". It's named wrong, it clears the table, and then proceeds to rebuild it.

Can you turn your logging up to debug and post your cacti log for one polling cycle?

[skaminski]

I have another thread that shows my log file.

http://forums.cacti.net/viewtopic.php?t=6356

If you need another one, let me know.

thanks!
Sean

[TheWitness]

Hey, spongebob, what version of Cacti are you running? You need to make an alteration and then be patient. Provide you version and I will provide the fix.

TheWitness

[skaminski]

Server Is
DL380G3 (Dual Processor 2.8Ghz with 3GB of RAM)
Windows 2003 Enterprise Edition
Apache
Cacti 0.8.6c
php 4.3.6
MySQL 3.23.58-nt

[TheWitness]

Ski,

Try this version of <webroot>/cacti/utilities.php. Please let me know how it goes.

TheWitness

http://cvs.cacti.net/cgi-bin/viewcvs.cg ... text/plain