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
polling problem?
Moderators: Developers, Moderators
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!
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!
Who is online
Users browsing this forum: No registered users and 6 guests