Error in cacti.log

[jeroenw]

Hi,

I have a new installation of cacti v 0.8.6h (rpm) and only the local device is being monitored. The graphs are looking fine but I got the following error (incl. Debug) in the cacti.log every cacti-pol:

============
03/22/2006 12:35:01 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select count(*) from poller_item"
03/22/2006 12:35:01 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select id from host where disabled = '' order by id"
03/22/2006 12:35:01 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('path_webroot','/var/www/cacti')"
03/22/2006 12:35:01 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "truncate table poller_time"
03/22/2006 12:35:01 PM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Process [CMD: /usr/bin/php, ARGS: -q /var/www/cacti/cmd.php 0 0]
03/22/2006 12:35:02 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select * from host where (disabled = '' and id >= 0 and id <= 0) ORDER by id"
03/22/2006 12:35:02 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT * from poller_item WHERE (host_id >= 0 and host_id <= 0) ORDER by host_id"
03/22/2006 12:35:02 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "SELECT count(*) from poller_item WHERE (action=2 AND (host_id >= 0 and host_id <= 0))"
03/22/2006 12:35:02 PM - CMDPHP: Poller[0] ERROR: Either there are no items in the cache or polling is disabled
03/22/2006 12:35:02 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_time (poller_id, start_time, end_time) values (0, NOW(), NOW())"
03/22/2006 12:35:02 PM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Process [CMD: /usr/bin/php, ARGS: -q /var/www/cacti/cmd.php 1 1]
03/22/2006 12:35:03 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select * from host where (disabled = '' and id >= 1 and id <= 1) ORDER by id"
03/22/2006 12:35:03 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT * from poller_item WHERE (host_id >= 1 and host_id <= 1) ORDER by host_id"
03/22/2006 12:35:03 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "SELECT count(*) from poller_item WHERE (action=2 AND (host_id >= 1 and host_id <= 1))"
03/22/2006 12:35:03 PM - PHPSVR: Poller[0] DEBUG: SERVER: cmd
03/22/2006 12:35:03 PM - PHPSVR: Poller[0] DEBUG: GETCWD: /var/www/cacti
03/22/2006 12:35:03 PM - PHPSVR: Poller[0] DEBUG: DIRNAM: /var/www/cacti
03/22/2006 12:35:03 PM - PHPSVR: Poller[0] DEBUG: FILENM: /var/www/cacti/script_server.php
03/22/2006 12:35:03 PM - PHPSVR: Poller[0] PHP Script Server has Started - Parent is cmd
03/22/2006 12:35:03 PM - CMDPHP: Poller[0] PHP Script Server Started Properly
03/22/2006 12:35:03 PM - CMDPHP: Poller[0] Host[1] SNMP: Host responded to SNMP
03/22/2006 12:35:03 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "update host set status = '3', status_event_count = '0', status_fail_date = '0000-00-00 00:00:00', status_rec_date = '0000-00-00 00:00:00', status_last_error = '', min_time = '9.99999', max_time = '36.42000', cur_time = '35.15', avg_time = '34.539454', total_polls = '20', failed_polls = '0', availability = '100' where hostname = '127.0.0.1'"
03/22/2006 12:35:03 PM - 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=1"
03/22/2006 12:35:03 PM - CMDPHP: Poller[0] Host[1] RECACHE: Processing 3 items in the auto reindex cache for '127.0.0.1'.
============

Does anybody knows how to solve this error?

Thnx,
Jeroen

[gandalf]

Please try to rebuild the poller table using

Code: Select all

php rebuild_poller_cache.php

and check again
Reinhard

[jeroenw]

Please try to rebuild the poller table using

Code: Select all

php rebuild_poller_cache.php

and check again
Reinhard

Many Thanks!!!! This worked.

Jeroen

[phasenjager]

I also get the message about 'Either there are no items in the cache or polling is disabled.' I have tried rebuilding the poller cache numerous times with no success. Does anyone have another suggestion?

--------------------
12/18/2006 10:18:18 AM - SYSTEM STATS: Time:4.0870 Method:cmd.php Processes:5 Threads:N/A Hosts:2 HostsPerProcess:1 DataSources:21 RRDsProcessed:12
12/18/2006 10:18:18 AM - CMDPHP: Poller[0] Time: 2.3928 s, Theads: N/A, Hosts: 1
12/18/2006 10:18:18 AM - CMDPHP: Poller[0] Host[3] DS[20] SNMP: v1: 172.25.1.1, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.1, output: 2176202189
12/18/2006 10:18:18 AM - CMDPHP: Poller[0] Host[3] DS[20] SNMP: v1: 172.25.1.1, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.1, output: 2621887082
12/18/2006 10:18:17 AM - CMDPHP: Poller[0] Host[3] DS[19] SNMP: v1: 172.25.1.1, dsname: vol_freeable, oid: .1.3.6.1.4.1.23.2.28.2.14.1.5.6, output: 17832
12/18/2006 10:18:17 AM - CMDPHP: Poller[0] Host[3] DS[19] SNMP: v1: 172.25.1.1, dsname: vol_free, oid: .1.3.6.1.4.1.23.2.28.2.14.1.4.6, output: 13785828
12/18/2006 10:18:17 AM - CMDPHP: Poller[0] Host[3] DS[19] SNMP: v1: 172.25.1.1, dsname: vol_total, oid: .1.3.6.1.4.1.23.2.28.2.14.1.3.6, output: 41943040
12/18/2006 10:18:17 AM - CMDPHP: Poller[0] Host[3] DS[18] SNMP: v1: 172.25.1.1, dsname: vol_freeable, oid: .1.3.6.1.4.1.23.2.28.2.14.1.5.5, output: 0
12/18/2006 10:18:17 AM - CMDPHP: Poller[0] Host[3] DS[18] SNMP: v1: 172.25.1.1, dsname: vol_free, oid: .1.3.6.1.4.1.23.2.28.2.14.1.4.5, output: 17069432
12/18/2006 10:18:17 AM - CMDPHP: Poller[0] Host[3] DS[18] SNMP: v1: 172.25.1.1, dsname: vol_total, oid: .1.3.6.1.4.1.23.2.28.2.14.1.3.5, output: 26214400
12/18/2006 10:18:17 AM - CMDPHP: Poller[0] Host[3] DS[17] SNMP: v1: 172.25.1.1, dsname: vol_freeable, oid: .1.3.6.1.4.1.23.2.28.2.14.1.5.4, output: 0
12/18/2006 10:18:17 AM - CMDPHP: Poller[0] Host[3] DS[17] SNMP: v1: 172.25.1.1, dsname: vol_free, oid: .1.3.6.1.4.1.23.2.28.2.14.1.4.4, output: 45363284
12/18/2006 10:18:17 AM - CMDPHP: Poller[0] Host[3] DS[17] SNMP: v1: 172.25.1.1, dsname: vol_total, oid: .1.3.6.1.4.1.23.2.28.2.14.1.3.4, output: 56665960
12/18/2006 10:18:17 AM - CMDPHP: Poller[0] Host[3] DS[16] SNMP: v1: 172.25.1.1, dsname: vol_freeable, oid: .1.3.6.1.4.1.23.2.28.2.14.1.5.1, output: 1240152
12/18/2006 10:18:17 AM - CMDPHP: Poller[0] Host[3] DS[16] SNMP: v1: 172.25.1.1, dsname: vol_free, oid: .1.3.6.1.4.1.23.2.28.2.14.1.4.1, output: 4174972
12/18/2006 10:18:16 AM - CMDPHP: Poller[0] Host[3] DS[16] SNMP: v1: 172.25.1.1, dsname: vol_total, oid: .1.3.6.1.4.1.23.2.28.2.14.1.3.1, output: 10418476
12/18/2006 10:18:16 AM - CMDPHP: Poller[0] Host[3] DS[15] SNMP: v1: 172.25.1.1, dsname: open_files, oid: .1.3.6.1.4.1.23.2.28.2.7.0, output: 15219
12/18/2006 10:18:16 AM - CMDPHP: Poller[0] Host[3] DS[14] SNMP: v1: 172.25.1.1, dsname: total_logins, oid: .1.3.6.1.4.1.23.2.28.3.2.0, output: 5
12/18/2006 10:18:16 AM - CMDPHP: Poller[0] Host[3] DS[13] SNMP: v1: 172.25.1.1, dsname: cache_hits, oid: .1.3.6.1.4.1.23.2.28.2.6.0, output: 552096179
12/18/2006 10:18:16 AM - CMDPHP: Poller[0] Host[3] DS[12] SNMP: v1: 172.25.1.1, dsname: cache_checks, oid: .1.3.6.1.4.1.23.2.28.2.5.0, output: 607531356
12/18/2006 10:18:16 AM - CMDPHP: Poller[0] Host[3] DS[11] SNMP: v1: 172.25.1.1, dsname: fs_writes, oid: .1.3.6.1.4.1.23.2.28.2.2.0, output: 27744046
12/18/2006 10:18:16 AM - CMDPHP: Poller[0] Host[3] DS[10] SNMP: v1: 172.25.1.1, dsname: fs_reads, oid: .1.3.6.1.4.1.23.2.28.2.1.0, output: 71773651
12/18/2006 10:18:16 AM - CMDPHP: Poller[0] Host[3] DS[9] CMD: perl /opt/lampp/htdocs/cacti2/scripts/FZA/gw-gwia.pl 172.25.1.1 9850 ***** ********, output: unkHosts:6 hostsDown:67 relayDenied:69 lookupErr:56 msgsRcvd:18741 msgsSent:1858
12/18/2006 10:18:14 AM - CMDPHP: Poller[0] ERROR: Either there are no items in the cache or polling is disabled
12/18/2006 10:17:48 AM - WEBUI: Cacti Log Cleared from Web Management Interface
--------------------

Thanks,
Pat.[/code]

[gandalf]

Host 3 seems to work fine, isn't it? Which host makes problems?
Reinhard

[phasenjager]

Host 3 was the only host on the system at the time. I am currently in the process of setting up the system.

Pat.

[gandalf]

So I'm at a loss. There is an error message, and there are results from polling. Both do not fit together ...
Reinhard

[phasenjager]

I'm at a loss as well... magically, the error message disappeared. Thanks for trying.

Pat.

[rony]

I don't like magic.... It never explains what is wrong or how it was done.



Yes, I'm trying to be funny...