mysql poller_output problem

Dude · Post by **Dude** » Fri Aug 13, 2010 1:50 am

the poller output table is really a mess!

my poller is CMD.PHP
version is 0.8.7g

sometimes it says "error:1062 insert into poller output............"

and at other times, "poller output table not empty!"

I have tried every sort of repairs, rebuilding of the db, and dropping and creating poller_output table...

nothing works.

Post by **gandalf** » Sat Aug 14, 2010 1:58 pm

The provided information is not as detailed as required.
Which polling interval are you using?
Are you using multiple polling intervals?
Please see 2nd link of my sig and verify, that the double poller issue does not apply.
R.

Post by **TheWitness** » Sat Aug 14, 2010 4:55 pm

Your poller is overrunning. What is your poller interval and you should so some stat's from your cacti.log as per Gandalf's comment.

Dude · Post by **Dude** » Sun Aug 15, 2010 12:58 pm

the polling interval is 1 minute
cron interval is also 1 minute

the graph data source step value is set to 60 seconds.

yes you people are right it must be a poller overrunning issue...

How to get over it??

Post by **gandalf** » Sun Aug 15, 2010 2:22 pm

Dude wrote:@gandalf: I don't know how to access the 2nd link of your signature.... I'm new to forums... plz guide me

Log in to find it underneath all of my posts
R.

Dude · Post by **Dude** » Mon Aug 16, 2010 2:55 am

I have overcome the problem of error 1062 by increasing the step value to 65 seconds.

but the following error persists:

POLLER: Poller[0] WARNING: There are '1' detected as overrunning a polling process, please investigate

Post by **TheWitness** » Mon Aug 16, 2010 7:04 am

Did you apply all of the recent patches?

TheWitness

Dude · Post by **Dude** » Mon Aug 16, 2010 12:54 pm

nopes.... ok I'll do asap!

Dude · Post by **Dude** » Mon Aug 16, 2010 10:19 pm

all patches applied. No changes seem to occur...

Post by **TheWitness** » Tue Aug 17, 2010 6:01 am

Don't run manually, don't change the step to 65. If you run manually, you will likely get some of these errors.

TheWitness

Dude · Post by **Dude** » Tue Aug 17, 2010 7:37 am

I purged my log, changed the step to 300 and never ran it manually since....

the log is the same ....

Post by **TheWitness** » Tue Aug 17, 2010 7:41 am

Did you repopulate the poller cache? Why is the step 300? This is a test...

TheWitness

Dude · Post by **Dude** » Tue Aug 17, 2010 9:30 am

yes I did rebuild poller cache...
and I made it 300 because it was originally set to 300. thats cacti's default.

Post by **TheWitness** » Tue Aug 17, 2010 10:09 am

And poller interval and cron interval is 5 minutes right?

Dude · Post by **Dude** » Tue Aug 17, 2010 12:31 pm

yes, but I want to make this 1 minute... as well!

Cacti

mysql poller_output problem

mysql poller_output problem

Who is online