Status unknown

crishaddad · Post by **crishaddad** » Fri Sep 14, 2007 8:52 am

Hi there,

I'm getting status unknown on all but 4 of my hosts I've set up; they are also not graphing. I've traced everything down to the SQL-related error that is evident in the following debug log. Running an snmpwalk does not show any issues; polling is not disabled on any of the hosts Does anyone know why hosts 5-26 are returning this error ? I have tried deleting and recreating the records.

Code: Select all


09/14/2007 11:44:22 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_time (poller_id, start_time, end_time) values (0, NOW(), NOW())"
09/14/2007 11:44:23 AM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Process [CMD: /usr/bin/php, ARGS: -q /webapps/cacti/cmd.php 5 5]
09/14/2007 11:44:23 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "     SELECT * FROM host     WHERE (disabled = ''     AND id >= 5     AND id <= 5)     ORDER by id"
09/14/2007 11:44:23 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "     SELECT * from poller_item     WHERE (host_id >= 5     AND host_id <= 5)     ORDER by host_id"
09/14/2007 11:44:23 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "    SELECT count(*)    FROM poller_item    WHERE (action=2    AND (host_id >= 5    AND host_id <= 5))"
09/14/2007 11:44:24 AM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Process [CMD: /usr/bin/php, ARGS: -q /webapps/cacti/cmd.php 6 6]
09/14/2007 11:44:24 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "     SELECT * FROM host     WHERE (disabled = ''     AND id >= 6     AND id <= 6)     ORDER by id"
09/14/2007 11:44:24 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "     SELECT * from poller_item     WHERE (host_id >= 6     AND host_id <= 6)     ORDER by host_id"
09/14/2007 11:44:24 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "    SELECT count(*)    FROM poller_item    WHERE (action=2    AND (host_id >= 6    AND host_id <= 6))"
09/14/2007 11:44:24 AM - CMDPHP: Poller[0] ERROR: Either there are no items in the cache or polling is disabled
09/14/2007 11:44:24 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_time (poller_id, start_time, end_time) values (0, NOW(), NOW())"
09/14/2007 11:44:25 AM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Process [CMD: /usr/bin/php, ARGS: -q /webapps/cacti/cmd.php 7 7]
09/14/2007 11:44:25 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "     SELECT * FROM host     WHERE (disabled = ''     AND id >= 7     AND id <= 7)     ORDER by id"
09/14/2007 11:44:25 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "     SELECT * from poller_item     WHERE (host_id >= 7     AND host_id <= 7)     ORDER by host_id"
09/14/2007 11:44:25 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "    SELECT count(*)    FROM poller_item    WHERE (action=2    AND (host_id >= 7    AND host_id <= 7))"
09/14/2007 11:44:25 AM - CMDPHP: Poller[0] ERROR: Either there are no items in the cache or polling is disabled
09/14/2007 11:44:25 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_time (poller_id, start_time, end_time) values (0, NOW(), NOW())"
09/14/2007 11:44:26 AM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Process [CMD: /usr/bin/php, ARGS: -q /webapps/cacti/cmd.php 8 8]
09/14/2007 11:44:26 AM - CMDPHP: Poller[0] Host[5] PING: Host is alive
09/14/2007 11:44:26 AM - CMDPHP: Poller[0] Host[5] SNMP: Host did not respond to SNMP
09/14/2007 11:44:26 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "update host set  status = '3',  status_event_count = '0',  status_fail_date = '2007-09-14 10:23:16',  status_rec_date = '2007-09-11 01:20:03',  status_last_error = 'Host did not respond to SNMP',  min_time = '0.20000',  max_time = '41.01000',  cur_time = '0.62',  avg_time = '5.5977066443595',  total_polls = '1082',  failed_polls = '36',  availability = '96.672828096118'  where hostname = 'Gemini.ts.umist.ac.uk'"
09/14/2007 11:44:26 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select     poller_reindex.data_query_id,     poller_reindex.action,     poller_reindex.op,     poller_reindex.assert_value,     poller_reindex.arg1     from poller_reindex     where poller_reindex.host_id=5"
09/14/2007 11:44:26 AM - CMDPHP: Poller[0] Host[5] RECACHE: Processing 3 items in the auto reindex cache for 'Gemini.ts.umist.ac.uk'.
09/14/2007 11:44:26 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "     SELECT * FROM host     WHERE (disabled = ''     AND id >= 8     AND id <= 8)     ORDER by id"
09/14/2007 11:44:26 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "     SELECT * from poller_item     WHERE (host_id >= 8     AND host_id <= 8)     ORDER by host_id"
09/14/2007 11:44:26 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "    SELECT count(*)    FROM poller_item    WHERE (action=2    AND (host_id >= 8    AND host_id <= 8))"
09/14/2007 11:44:26 AM - CMDPHP: Poller[0] ERROR: Either there are no items in the cache or polling is disabled
09/14/2007 11:44:26 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_time (poller_id, start_time, end_time) values (0, NOW(), NOW())"
09/14/2007 11:44:27 AM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Process [CMD: /usr/bin/php, ARGS: -q /webapps/cacti/cmd.php 9 9]
09/14/2007 11:44:27 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "     SELECT * FROM host     WHERE (disabled = ''     AND id >= 9     AND id <= 9)     ORDER by id"
09/14/2007 11:44:27 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "     SELECT * from poller_item     WHERE (host_id >= 9     AND host_id <= 9)     ORDER by host_id"
09/14/2007 11:44:27 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "    SELECT count(*)    FROM poller_item    WHERE (action=2    AND (host_id >= 9    AND host_id <= 9))"
09/14/2007 11:44:27 AM - CMDPHP: Poller[0] ERROR: Either there are no items in the cache or polling is disabled
09/14/2007 11:44:27 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_time (poller_id, start_time, end_time) values (0, NOW(), NOW())"
09/14/2007 11:44:28 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "update poller_reindex set assert_value='' where host_id='5' and data_query_id='1' and arg1='.1.3.6.1.2.1.1.3.0'"
09/14/2007 11:44:28 AM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Process [CMD: /usr/bin/php, ARGS: -q /webapps/cacti/cmd.php 10 10]
09/14/2007 11:44:28 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "     SELECT * FROM host     WHERE (disabled = ''     AND id >= 10     AND id <= 10)     ORDER by id"
09/14/2007 11:44:28 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "     SELECT * from poller_item     WHERE (host_id >= 10     AND host_id <= 10)     ORDER by host_id"
09/14/2007 11:44:28 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "    SELECT count(*)    FROM poller_item    WHERE (action=2    AND (host_id >= 10    AND host_id <= 10))"
09/14/2007 11:44:28 AM - CMDPHP: Poller[0] ERROR: Either there are no items in the cache or polling is disabled
09/14/2007 11:44:28 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_time (poller_id, start_time, end_time) values (0, NOW(), NOW())"
09/14/2007 11:44:29 AM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Process [CMD: /usr/bin/php, ARGS: -q /webapps/cacti/cmd.php 11 11]
09/14/2007 11:44:29 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "     SELECT * FROM host     WHERE (disabled = ''     AND id >= 11     AND id <= 11)     ORDER by id"
09/14/2007 11:44:29 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "     SELECT * from poller_item     WHERE (host_id >= 11     AND host_id <= 11)     ORDER by host_id"
09/14/2007 11:44:29 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "    SELECT count(*)    FROM poller_item    WHERE (action=2    AND (host_id >= 11    AND host_id <= 11))"
09/14/2007 11:44:29 AM - CMDPHP: Poller[0] ERROR: Either there are no items in the cache or polling is disabled
09/14/2007 11:44:29 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_time (poller_id, start_time, end_time) values (0, NOW(), NOW())"
09/14/2007 11:44:30 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "update poller_reindex set assert_value='' where host_id='5' and data_query_id='8' and arg1='.1.3.6.1.2.1.1.3.0'"
09/14/2007 11:44:30 AM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Process [CMD: /usr/bin/php, ARGS: -q /webapps/cacti/cmd.php 12 12]
09/14/2007 11:44:30 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "     SELECT * FROM host     WHERE (disabled = ''     AND id >= 12     AND id <= 12)     ORDER by id"
09/14/2007 11:44:30 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "     SELECT * from poller_item     WHERE (host_id >= 12     AND host_id <= 12)     ORDER by host_id"
09/14/2007 11:44:30 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "    SELECT count(*)    FROM poller_item    WHERE (action=2    AND (host_id >= 12    AND host_id <= 12))"
09/14/2007 11:44:30 AM - CMDPHP: Poller[0] ERROR: Either there are no items in the cache or polling is disabled
09/14/2007 11:44:30 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_time (poller_id, start_time, end_time) values (0, NOW(), NOW())"
09/14/2007 11:44:31 AM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Process [CMD: /usr/bin/php, ARGS: -q /webapps/cacti/cmd.php 13 13]
09/14/2007 11:44:31 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "     SELECT * FROM host     WHERE (disabled = ''     AND id >= 13     AND id <= 13)     ORDER by id"
09/14/2007 11:44:31 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "     SELECT * from poller_item     WHERE (host_id >= 13     AND host_id <= 13)     ORDER by host_id"
09/14/2007 11:44:31 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "    SELECT count(*)    FROM poller_item    WHERE (action=2    AND (host_id >= 13    AND host_id <= 13))"
09/14/2007 11:44:31 AM - CMDPHP: Poller[0] ERROR: Either there are no items in the cache or polling is disabled
09/14/2007 11:44:31 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_time (poller_id, start_time, end_time) values (0, NOW(), NOW())"
09/14/2007 11:44:32 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "update poller_reindex set assert_value='' where host_id='5' and data_query_id='9' and arg1='.1.3.6.1.2.1.1.3.0'"
09/14/2007 11:44:32 AM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Process [CMD: /usr/bin/php, ARGS: -q /webapps/cacti/cmd.php 14 14]
09/14/2007 11:44:32 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "     SELECT * FROM host     WHERE (disabled = ''     AND id >= 14     AND id <= 14)     ORDER by id"
09/14/2007 11:44:32 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "     SELECT * from poller_item     WHERE (host_id >= 14     AND host_id <= 14)     ORDER by host_id"
09/14/2007 11:44:32 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "    SELECT count(*)    FROM poller_item    WHERE (action=2    AND (host_id >= 14    AND host_id <= 14))"
09/14/2007 11:44:32 AM - CMDPHP: Poller[0] ERROR: Either there are no items in the cache or polling is disabled
09/14/2007 11:44:32 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_time (poller_id, start_time, end_time) values (0, NOW(), NOW())"
09/14/2007 11:44:33 AM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Process [CMD: /usr/bin/php, ARGS: -q /webapps/cacti/cmd.php 16 16]
09/14/2007 11:44:33 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "     SELECT * FROM host     WHERE (disabled = ''     AND id >= 16     AND id <= 16)     ORDER by id"
09/14/2007 11:44:33 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "     SELECT * from poller_item     WHERE (host_id >= 16     AND host_id <= 16)     ORDER by host_id"
09/14/2007 11:44:33 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "    SELECT count(*)    FROM poller_item    WHERE (action=2    AND (host_id >= 16    AND host_id <= 16))"
09/14/2007 11:44:33 AM - CMDPHP: Poller[0] ERROR: Either there are no items in the cache or polling is disabled
09/14/2007 11:44:33 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_time (poller_id, start_time, end_time) values (0, NOW(), NOW())"
09/14/2007 11:44:34 AM - CMDPHP: Poller[0] Host[5] DS[42] WARNING: Result from SNMP not valid.  Partial Result: 
09/14/2007 11:44:34 AM - CMDPHP: Poller[0] Host[5] DS[42] SNMP: v2: Gemini.ts.umist.ac.uk, dsname: proc, oid: .1.3.6.1.2.1.25.1.6.0, output: U
09/14/2007 11:44:34 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (42, 'proc', '2007-09-14 11:44:23', 'U')"
09/14/2007 11:44:34 AM - CMDPHP: Poller[0] Time: 11.0659 s, Theads: N/A, Hosts: 1
09/14/2007 11:44:34 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_time (poller_id, start_time, end_time) values (0, NOW(), NOW())"
09/14/2007 11:44:34 AM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Process [CMD: /usr/bin/php, ARGS: -q /webapps/cacti/cmd.php 17 17]
09/14/2007 11:44:34 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "     SELECT * FROM host     WHERE (disabled = ''     AND id >= 17     AND id <= 17)     ORDER by id"
09/14/2007 11:44:34 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "     SELECT * from poller_item     WHERE (host_id >= 17     AND host_id <= 17)     ORDER by host_id"
09/14/2007 11:44:34 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "    SELECT count(*)    FROM poller_item    WHERE (action=2    AND (host_id >= 17    AND host_id <= 17))"
09/14/2007 11:44:34 AM - CMDPHP: Poller[0] ERROR: Either there are no items in the cache or polling is disabled
09/14/2007 11:44:34 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_time (poller_id, start_time, end_time) values (0, NOW(), NOW())"
09/14/2007 11:44:35 AM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Process [CMD: /usr/bin/php, ARGS: -q /webapps/cacti/cmd.php 18 18]
09/14/2007 11:44:35 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "     SELECT * FROM host     WHERE (disabled = ''     AND id >= 18     AND id <= 18)     ORDER by id"
09/14/2007 11:44:35 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "     SELECT * from poller_item     WHERE (host_id >= 18     AND host_id <= 18)     ORDER by host_id"
09/14/2007 11:44:35 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "    SELECT count(*)    FROM poller_item    WHERE (action=2    AND (host_id >= 18    AND host_id <= 18))"
09/14/2007 11:44:35 AM - CMDPHP: Poller[0] ERROR: Either there are no items in the cache or polling is disabled
09/14/2007 11:44:35 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_time (poller_id, start_time, end_time) values (0, NOW(), NOW())"
09/14/2007 11:44:36 AM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Process [CMD: /usr/bin/php, ARGS: -q /webapps/cacti/cmd.php 19 19]
09/14/2007 11:44:36 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "     SELECT * FROM host     WHERE (disabled = ''     AND id >= 19     AND id <= 19)     ORDER by id"
09/14/2007 11:44:36 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "     SELECT * from poller_item     WHERE (host_id >= 19     AND host_id <= 19)     ORDER by host_id"
09/14/2007 11:44:36 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "    SELECT count(*)    FROM poller_item    WHERE (action=2    AND (host_id >= 19    AND host_id <= 19))"
09/14/2007 11:44:36 AM - CMDPHP: Poller[0] ERROR: Either there are no items in the cache or polling is disabled
09/14/2007 11:44:36 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_time (poller_id, start_time, end_time) values (0, NOW(), NOW())"
09/14/2007 11:44:37 AM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Process [CMD: /usr/bin/php, ARGS: -q /webapps/cacti/cmd.php 20 20]
09/14/2007 11:44:37 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "     SELECT * FROM host     WHERE (disabled = ''     AND id >= 20     AND id <= 20)     ORDER by id"
09/14/2007 11:44:37 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "     SELECT * from poller_item     WHERE (host_id >= 20     AND host_id <= 20)     ORDER by host_id"
09/14/2007 11:44:37 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "    SELECT count(*)    FROM poller_item    WHERE (action=2    AND (host_id >= 20    AND host_id <= 20))"
09/14/2007 11:44:37 AM - CMDPHP: Poller[0] ERROR: Either there are no items in the cache or polling is disabled
09/14/2007 11:44:37 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_time (poller_id, start_time, end_time) values (0, NOW(), NOW())"
09/14/2007 11:44:38 AM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Process [CMD: /usr/bin/php, ARGS: -q /webapps/cacti/cmd.php 21 21]
09/14/2007 11:44:38 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "     SELECT * FROM host     WHERE (disabled = ''     AND id >= 21     AND id <= 21)     ORDER by id"
09/14/2007 11:44:38 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "     SELECT * from poller_item     WHERE (host_id >= 21     AND host_id <= 21)     ORDER by host_id"
09/14/2007 11:44:38 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "    SELECT count(*)    FROM poller_item    WHERE (action=2    AND (host_id >= 21    AND host_id <= 21))"
09/14/2007 11:44:38 AM - CMDPHP: Poller[0] ERROR: Either there are no items in the cache or polling is disabled
09/14/2007 11:44:38 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_time (poller_id, start_time, end_time) values (0, NOW(), NOW())"
09/14/2007 11:44:39 AM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Process [CMD: /usr/bin/php, ARGS: -q /webapps/cacti/cmd.php 22 22]
09/14/2007 11:44:39 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "     SELECT * FROM host     WHERE (disabled = ''     AND id >= 22     AND id <= 22)     ORDER by id"
09/14/2007 11:44:39 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "     SELECT * from poller_item     WHERE (host_id >= 22     AND host_id <= 22)     ORDER by host_id"
09/14/2007 11:44:39 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "    SELECT count(*)    FROM poller_item    WHERE (action=2    AND (host_id >= 22    AND host_id <= 22))"
09/14/2007 11:44:39 AM - CMDPHP: Poller[0] ERROR: Either there are no items in the cache or polling is disabled
09/14/2007 11:44:39 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_time (poller_id, start_time, end_time) values (0, NOW(), NOW())"
09/14/2007 11:44:40 AM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Process [CMD: /usr/bin/php, ARGS: -q /webapps/cacti/cmd.php 23 23]
09/14/2007 11:44:40 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "     SELECT * FROM host     WHERE (disabled = ''     AND id >= 23     AND id <= 23)     ORDER by id"
09/14/2007 11:44:40 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "     SELECT * from poller_item     WHERE (host_id >= 23     AND host_id <= 23)     ORDER by host_id"
09/14/2007 11:44:40 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "    SELECT count(*)    FROM poller_item    WHERE (action=2    AND (host_id >= 23    AND host_id <= 23))"
09/14/2007 11:44:40 AM - CMDPHP: Poller[0] ERROR: Either there are no items in the cache or polling is disabled
09/14/2007 11:44:40 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_time (poller_id, start_time, end_time) values (0, NOW(), NOW())"
09/14/2007 11:44:41 AM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Process [CMD: /usr/bin/php, ARGS: -q /webapps/cacti/cmd.php 24 24]
09/14/2007 11:44:41 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "     SELECT * FROM host     WHERE (disabled = ''     AND id >= 24     AND id <= 24)     ORDER by id"
09/14/2007 11:44:41 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "     SELECT * from poller_item     WHERE (host_id >= 24     AND host_id <= 24)     ORDER by host_id"
09/14/2007 11:44:41 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "    SELECT count(*)    FROM poller_item    WHERE (action=2    AND (host_id >= 24    AND host_id <= 24))"
09/14/2007 11:44:41 AM - CMDPHP: Poller[0] ERROR: Either there are no items in the cache or polling is disabled
09/14/2007 11:44:41 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_time (poller_id, start_time, end_time) values (0, NOW(), NOW())"
09/14/2007 11:44:42 AM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Process [CMD: /usr/bin/php, ARGS: -q /webapps/cacti/cmd.php 25 25]
09/14/2007 11:44:42 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "     SELECT * FROM host     WHERE (disabled = ''     AND id >= 25     AND id <= 25)     ORDER by id"
09/14/2007 11:44:42 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "     SELECT * from poller_item     WHERE (host_id >= 25     AND host_id <= 25)     ORDER by host_id"
09/14/2007 11:44:42 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "    SELECT count(*)    FROM poller_item    WHERE (action=2    AND (host_id >= 25    AND host_id <= 25))"
09/14/2007 11:44:42 AM - CMDPHP: Poller[0] ERROR: Either there are no items in the cache or polling is disabled
09/14/2007 11:44:42 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_time (poller_id, start_time, end_time) values (0, NOW(), NOW())"
09/14/2007 11:44:43 AM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Process [CMD: /usr/bin/php, ARGS: -q /webapps/cacti/cmd.php 26 26]
09/14/2007 11:44:43 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "     SELECT * FROM host     WHERE (disabled = ''     AND id >= 26     AND id <= 26)     ORDER by id"
09/14/2007 11:44:43 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "     SELECT * from poller_item     WHERE (host_id >= 26     AND host_id <= 26)     ORDER by host_id"
09/14/2007 11:44:43 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "    SELECT count(*)    FROM poller_item    WHERE (action=2    AND (host_id >= 26    AND host_id <= 26))"
09/14/2007 11:44:43 AM - CMDPHP: Poller[0] ERROR: Either there are no items in the cache or polling is disabled
09/14/2007 11:44:43 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_time (poller_id, start_time, end_time) values (0, NOW(), NOW())"
09/14/2007 11:44:44 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('date',NOW())"
09/14/2007 11:44:44 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
09/14/2007 11:44:44 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)  "
09/14/2007 11:44:44 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select     data_template_rrd.data_source_name,     data_input_fields.data_name     from (data_template_rrd,data_input_fields)     where data_template_rrd.data_input_field_id=data_input_fields.id     and data_template_rrd.local_data_id=5"

Post by **gandalf** » Fri Sep 14, 2007 9:04 am

crishaddad wrote:

Code: Select all

09/14/2007 11:44:37 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "     SELECT * FROM host     WHERE (disabled = ''     AND id >= 20     AND id <= 20)     ORDER by id"
09/14/2007 11:44:37 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "     SELECT * from poller_item     WHERE (host_id >= 20     AND host_id <= 20)     ORDER by host_id"
09/14/2007 11:44:37 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "    SELECT count(*)    FROM poller_item    WHERE (action=2    AND (host_id >= 20    AND host_id <= 20))"
09/14/2007 11:44:37 AM - CMDPHP: Poller[0] ERROR: Either there are no items in the cache or polling is disabled

Please run those SQL commands from mysql command line and post the results.
Did you already try to

Code: Select all

php -q rebuild_poller_Cache.php

?
What are the Settings->Poller entries? Number of processes and stuff?
Reinhard

crishaddad · Post by **crishaddad** » Fri Sep 14, 2007 9:46 am

Hi Reinhard, thanks for the quick reply.

I just did a rebuild of the poller cache as you suggested and this has not fixed the issue.
SQL :

Code: Select all

SELECT * FROM host     WHERE (disabled = ''     AND id >= 20     AND id <= 20)     ORDER by id

... does exactly what it should and selects the row for device #20, Windows server "beefix"; nothing interesting to note except that "disabled" column is blank.

The other two commands :

Code: Select all

SELECT * from poller_item     WHERE (host_id >= 20     AND host_id <= 20)     ORDER by host_id

returns an empty set

Code: Select all

SELECT count(*)    FROM poller_item    WHERE (action=2    AND (host_id >= 20    AND host_id <= 20))

returns a set with one row: "0"

I just tried select * from poller_item and it returned rows for the servers which are being successfully polled but none for the servers which aren't.

Settings > Poller

status= Enabled
poller type=cmd.php
Max concurrent=100
Max Threads = 100
PHP script servers=10
Script timeout=25
Max OIds= 10
Detection=snmp
pingtype=icmp
ping timeoput=400
ping retry=3
failure count=2
recovery count=3

crishaddad · Post by **crishaddad** » Fri Sep 14, 2007 10:07 am

data_local also only has rows with information for the servers that are polling properly.

Post by **gandalf** » Fri Sep 14, 2007 11:23 am

crishaddad wrote:
Code: Select all
SELECT count(*)    FROM poller_item    WHERE (action=2    AND (host_id >= 20    AND host_id <= 20))
returns a set with one row: "0"

I just tried select * from poller_item and it returned rows for the servers which are being successfully polled but none for the servers which aren't.

This is why cacti states

Either there are no items in the cache or polling is disabled

The first one holds in your case: there are no items to be polled. Let's try to find out, why. I was assuming that poller item table was not filled correctly so I asked you to run it from cli, but, as you said, to no avail. But you surely have requested Graphs for that very hosts (Create Graphs for this Host)?!? Please visit "Data Sources", filter for a failing device ans post a screenshot

Settings > Poller

status= Enabled
poller type=cmd.php
Max concurrent=100
Max Threads = 100
PHP script servers=10
Script timeout=25
Max OIds= 10
Detection=snmp
pingtype=icmp
ping timeoput=400
ping retry=3
failure count=2
recovery count=3

This is quite insane. Concurrent processes should be set to 1-2 times the number of available CPU cores. Threads are valid only when using cactid and a start would be a number between 10-15. The rest is fine.
Reinhard

Cacti

Status unknown

Status unknown

Re: Status unknown

Who is online