polling problem?

Post general support questions here that do not specifically fall into the Linux or Windows categories.

Moderators: Developers, Moderators

Post Reply
matcraig
Posts: 6
Joined: Tue Jun 05, 2007 5:32 pm

polling problem?

Post by matcraig »

I have some graphs being polled at 1 min and others at 5 min intervals. I am getting the following in the log file:

06/05/2007 04:36:10 PM - SYSTEM STATS: Time:9.6001 Method:cactid Processes:1 Threads:20 Hosts:32 HostsPerProcess:32 DataSources:6437 RRDsProcessed:2241
06/05/2007 04:36:09 PM - SYSTEM STATS: Time:69.5793 Method:cactid Processes:1 Threads:20 Hosts:32 HostsPerProcess:32 DataSources:6437 RRDsProcessed:4856
06/05/2007 04:35:11 PM - SYSTEM STATS: Time:10.8951 Method:cactid Processes:1 Threads:20 Hosts:32 HostsPerProcess:32 DataSources:6437 RRDsProcessed:2580
06/05/2007 04:34:06 PM - SYSTEM STATS: Time:6.1799 Method:cactid Processes:1 Threads:20 Hosts:32 HostsPerProcess:32 DataSources:6437 RRDsProcessed:2388
06/05/2007 04:33:07 PM - SYSTEM STATS: Time:6.1312 Method:cactid Processes:1 Threads:20 Hosts:32 HostsPerProcess:32 DataSources:6437 RRDsProcessed:2388
06/05/2007 04:32:06 PM - SYSTEM STATS: Time:6.1572 Method:cactid Processes:1 Threads:20 Hosts:32 HostsPerProcess:32 DataSources:6437 RRDsProcessed:2388
06/05/2007 04:31:13 PM - SYSTEM STATS: Time:71.9450 Method:cactid Processes:1 Threads:20 Hosts:32 HostsPerProcess:32 DataSources:6437 RRDsProcessed:4505
06/05/2007 04:31:13 PM - SYSTEM STATS: Time:11.9661 Method:cactid Processes:1 Threads:20 Hosts:32 HostsPerProcess:32 DataSources:6437 RRDsProcessed:2210
06/05/2007 04:31:12 PM - SYSTEM STATS: Time:71.4052 Method:cactid Processes:1 Threads:20 Hosts:32 HostsPerProcess:32 DataSources:6437 RRDsProcessed:4344



As you can see, every 5 minutes multiple polls are run and most of the time they take a large amount of time to complete.

Also, usually (but not always), I get the following error in the log preceding the poller system stats:

06/05/2007 04:35:02 PM - CACTID: Poller[0] ERROR: Problem with MySQL: 'Duplicate entry '1439-traffic_out-2007-06-05 16:35:01' for key 1'
06/05/2007 04:35:02 PM - CACTID: Poller[0] ERROR: Problem with MySQL: 'Duplicate entry '1550-errors_in-2007-06-05 16:35:01' for key 1'
06/05/2007 04:35:01 PM - CACTID: Poller[0] ERROR: Problem with MySQL: 'Duplicate entry '1280-discards_out-2007-06-05 16:35:01' for key 1'
06/05/2007 04:35:01 PM - CACTID: Poller[0] ERROR: Problem with MySQL: 'Duplicate entry '1470-errors_in-2007-06-05 16:35:01' for key 1'


It looks like to me that every 5 minutes the poller runs more than once and tries to update the database, getting a duplicate entry. Is this a problem? I would think that there would only be one poller running every minute
User avatar
gandalf
Developer
Posts: 22383
Joined: Thu Dec 02, 2004 2:46 am
Location: Muenster, Germany
Contact:

Post by gandalf »

See the duplicate poller issue at the second link of my signature
Reinhard
matcraig
Posts: 6
Joined: Tue Jun 05, 2007 5:32 pm

Post by matcraig »

bah... me is noob!

I had two different cronjobs set up on two users for polling. So basically, I had two pollers being executed by different users at the same time, so utilization skyrocketed, and they tried to update the database with the same data. I removed the 2nd cronjob and everything began operating smoothly.

Doh!
User avatar
gandalf
Developer
Posts: 22383
Joined: Thu Dec 02, 2004 2:46 am
Location: Muenster, Germany
Contact:

Post by gandalf »

You're not the first one. RPM installs always bring their own /etc/cron.d/cacti. And if you then fill in /etc/crontab as well ...
Reinhard
Post Reply

Who is online

Users browsing this forum: No registered users and 6 guests