Waiting on 1/1 pollers.

Post support questions that directly relate to Linux/Unix operating systems.

Moderators: Developers, Moderators

Post Reply
msv_magnusm
Posts: 3
Joined: Tue Sep 25, 2007 4:09 am

Waiting on 1/1 pollers.

Post by msv_magnusm »

Hi, I can't get my poller to work in cacti. The install is completely fresh, I did the install, corrected the paths, switched to the right rrdtool version and tried to run the poller. So my only device is localhost.

The poller says like this:
/usr/local/bin/php /usr/local/apache2/htdocs/docroot/cacti/poller.php
09/25/2007 09:08:11 AM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Process [CMD: /usr/local/apache2/htdocs/cactid, ARGS: 0 1]
Waiting on 1/1 pollers.
Waiting on 1/1 pollers.
..
and does so for a few minutes.

My log says:
09/25/2007 09:08:11 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select count(*) from poller_item"
09/25/2007 09:08:11 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select id from host where disabled = '' order by id"
09/25/2007 09:08:11 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('path_webroot','/usr/local/apache2/htdocs/cacti-0.8.6j')"
09/25/2007 09:08:11 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "truncate table poller_time"
09/25/2007 09:08:11 AM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Process [CMD: /usr/local/apache2/htdocs/cactid, ARGS: 0 1]
09/25/2007 09:08:12 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('date',NOW())"
09/25/2007 09:08:12 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
09/25/2007 09:08:12 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_output.output, poller_output.time, poller_output.local_data_id, poller_item.rrd_path, poller_item.rrd_name, poller_item.rrd_num from (poller_output,poller_item) where (poller_output.local_data_id=poller_item.local_data_id and poller_output.rrd_name=poller_item.rrd_name) LIMIT 10000"
09/25/2007 09:08:13 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
09/25/2007 09:08:13 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_output.output, poller_output.time, poller_output.local_data_id, poller_item.rrd_path, poller_item.rrd_name, poller_item.rrd_num from (poller_output,poller_item) where (poller_output.local_data_id=poller_item.local_data_id and poller_output.rrd_name=poller_item.rrd_name) LIMIT 10000"

And the last two rows are repeated all the time.


I have made a few other cacti installations without any problem with the same host distribution and the same version of cacti, but this one is twisting my nerves.

My system is a Redhat 5 x86 where I have compiled apache and php myself. Mysql is a binary install (4.1.23).
Top
atiyehk
Posts: 5
Joined: Mon Sep 24, 2007 4:22 pm

I am having the same problem and no resolution

Post by atiyehk »

I have the same issue even when switching the poller to cactid,


09/25/2007 07:54:11 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
09/25/2007 07:54:11 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_output.output, poller_output.time, poller_output.local_data_id, poller_item.rrd_path, poller_item.rrd_name, poller_item.rrd_num from (poller_output,poller_item) where (poller_output.local_data_id=poller_item.local_data_id and poller_output.rrd_name=poller_item.rrd_name) LIMIT 10000"
09/25/2007 07:54:12 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
09/25/2007 07:54:12 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_output.output, poller_output.time, poller_output.local_data_id, poller_item.rrd_path, poller_item.rrd_name, poller_item.rrd_num from (poller_output,poller_item) where (poller_output.local_data_id=poller_item.local_data_id and poller_output.rrd_name=poller_item.rrd_name) LIMIT 10000"
09/25/2007 07:54:13 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
09/25/2007 07:54:13 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_output.output, poller_output.time, poller_output.local_data_id, poller_item.rrd_path, poller_item.rrd_name, poller_item.rrd_num from (poller_output,poller_item) where (poller_output.local_data_id=poller_item.local_data_id and poller_output.rrd_name=poller_item.rrd_name) LIMIT 10000"
09/25/2007 07:54:14 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
09/25/2007 07:54:14 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_output.output, poller_output.time, poller_output.local_data_id, poller_item.rrd_path, poller_item.rrd_name, poller_item.rrd_num from (poller_output,poller_item) where (poller_output.local_data_id=poller_item.local_data_id and poller_output.rrd_name=poller_item.rrd_name) LIMIT 10000"
09/25/2007 07:54:15 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
09/25/2007 07:54:15 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_output.output, poller_output.time, poller_output.local_data_id, poller_item.rrd_path, poller_item.rrd_name, poller_item.rrd_num from (poller_output,poller_item) where (poller_output.local_data_id=poller_item.local_data_id and poller_output.rrd_name=poller_item.rrd_name) LIMIT 10000"






Waiting on 1/1 pollers.
Waiting on 1/1 pollers.
Waiting on 1/1 pollers.
Waiting on 1/1 pollers.
Waiting on 1/1 pollers.
Waiting on 1/1 pollers.
Waiting on 1/1 pollers.
Waiting on 1/1 pollers.
Waiting on 1/1 pollers.
Waiting on 1/1 pollers.
Waiting on 1/1 pollers.
Waiting on 1/1 pollers.
Waiting on 1/1 pollers.
Waiting on 1/1 pollers.
Waiting on 1/1 pollers.
Waiting on 1/1 pollers.
Waiting on 1/1 pollers.
Waiting on 1/1 pollers.
Waiting on 1/1 pollers.
Waiting on 1/1 pollers.
Waiting on 1/1 pollers.
Waiting on 1/1 pollers.
Top
atiyehk
Posts: 5
Joined: Mon Sep 24, 2007 4:22 pm

Post by atiyehk »

I found the fix, change SNMP ping to regular ping (system ping).
Top
msv_magnusm
Posts: 3
Joined: Tue Sep 25, 2007 4:09 am

Post by msv_magnusm »

Thanks, but that wasn't my problem. I just found out that I had forgotten to create cactid.conf. Not sure why I experienced the same problem with cmd.php but I feel satisfied now.

Actually your reply made me go back to the problem and find this, so credits to you. :)
Top
rayvd
Posts: 6
Joined: Mon Apr 18, 2005 6:22 pm
Location: Chico, CA

Post by rayvd »

atiyehk wrote:I found the fix, change SNMP ping to regular ping (system ping).
I had the exact same problem (and fix).

Developers, is this a bug? Shouldn't the SNMP ping work correctly? In what scenario would it result in the never-terminating and looping SQL queries?

Mine is 0.8.6j
Top
logre
Posts: 7
Joined: Wed Feb 28, 2007 5:03 am

Post by logre »

I've got exactly same problem, fixed turning "SNMP -Reliable" into "PING - Faster option with risk"

I got this problem just after upgrading from 0.8.6c to 0.8.6j, any idea from the origin of this bug ?
Top
Post Reply

Return to “Help: Linux/Unix Specific”

Who is online

Users browsing this forum: No registered users and 0 guests