repeated "select ..." on table poller_output

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

Moderators: Developers, Moderators

Post Reply
Z-Man
Posts: 1
Joined: Sat Jan 14, 2006 2:38 pm

Post by Z-Man »

I have the same error.
I turned on debug mode and what I get is this (the last two entries are repeating every second):

01/14/2006 08:37:54 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select count(*) from poller_item"
01/14/2006 08:37:54 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select id from host where disabled = '' order by id"
01/14/2006 08:37:54 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('path_webroot','/usr/local/share/cacti')"
01/14/2006 08:37:54 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "truncate table poller_time"
01/14/2006 08:37:54 PM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Process [CMD: /usr/bin/php, ARGS: -q /usr/local/share/cacti/cmd.php 0 5]
01/14/2006 08:37:55 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('date',NOW())"
01/14/2006 08:37:55 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
01/14/2006 08:38:38 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
01/14/2006 08:38:38 PM - 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)"
User avatar
gandalf
Developer
Posts: 22383
Joined: Thu Dec 02, 2004 2:46 am
Location: Muenster, Germany
Contact:

Post by gandalf »

Splitted off. New problem
Reinhard
cigamit
Developer
Posts: 3368
Joined: Thu Apr 07, 2005 3:29 pm
Location: B/CS Texas
Contact:

Post by cigamit »

The repeating is because the poller launches processes and then loops to check how many processes are active, so it can launch more if needed. Apparently something is causing the processes to hang, thus the poller just keeps looping waiting for them to exit.

What thread was this split from? What was the original error? Maybe we can find out what is causing them to hang.
Post Reply

Who is online

Users browsing this forum: No registered users and 3 guests