Graph Problem

[georgepremier]

For some reason my graphs have stopped being produced.

Here is the output from cacti log and poller log:

Cacti:
02/07/2007 02:05:04 PM - SYSTEM STATS: Time:2.0831 Method:cmd.php Processes:2 Threads:N/A Hosts:30 HostsPerProcess:15 DataSources: RRDsProcessed:0
02/07/2007 02:10:02 PM - CMDPHP: Poller[0] ERROR: SQL Cell Failed "select count(*) from poller_item"
02/07/2007 02:10:02 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed "SELECT * from poller_item WHERE (host_id >= 0 and host_id <= 27) ORDER by host_id"
02/07/2007 02:10:02 PM - CMDPHP: Poller[0] ERROR: SQL Cell Failed "SELECT count(*) from poller_item WHERE (action=2 AND (host_id >= 0 and host_id <= 27))"
02/07/2007 02:10:02 PM - CMDPHP: Poller[0] ERROR: Either there are no items in the cache or polling is disabled
02/07/2007 02:10:03 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed "SELECT * from poller_item WHERE (host_id >= 28 and host_id <= 44) ORDER by host_id"
02/07/2007 02:10:03 PM - CMDPHP: Poller[0] ERROR: SQL Cell Failed "SELECT count(*) from poller_item WHERE (action=2 AND (host_id >= 28 and host_id <= 44))"
02/07/2007 02:10:03 PM - CMDPHP: Poller[0] ERROR: Either there are no items in the cache or polling is disabled
02/07/2007 02:10:04 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed "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)"

Poller:
02/07/2007 01:40:04 PM - SYSTEM STATS: Time:2.1610 Method:cmd.php Processes:2 Threads:N/A Hosts:30 HostsPerProcess:15 DataSources: RRDsProcessed:0
02/07/2007 01:45:04 PM - SYSTEM STATS: Time:2.1225 Method:cmd.php Processes:2 Threads:N/A Hosts:30 HostsPerProcess:15 DataSources: RRDsProcessed:0
02/07/2007 01:50:04 PM - SYSTEM STATS: Time:2.0699 Method:cmd.php Processes:2 Threads:N/A Hosts:30 HostsPerProcess:15 DataSources: RRDsProcessed:0
02/07/2007 01:55:04 PM - SYSTEM STATS: Time:2.0764 Method:cmd.php Processes:2 Threads:N/A Hosts:30 HostsPerProcess:15 DataSources: RRDsProcessed:0
02/07/2007 02:00:05 PM - SYSTEM STATS: Time:2.1909 Method:cmd.php Processes:2 Threads:N/A Hosts:30 HostsPerProcess:15 DataSources: RRDsProcessed:0
02/07/2007 02:05:04 PM - SYSTEM STATS: Time:2.0831 Method:cmd.php Processes:2 Threads:N/A Hosts:30 HostsPerProcess:15 DataSources: RRDsProcessed:0
02/07/2007 02:10:04 PM - SYSTEM STATS: Time:2.1067 Method:cmd.php Processes:2 Threads:N/A Hosts:30 HostsPerProcess:15 DataSources: RRDsProcessed:0
02/07/2007 02:15:05 PM - SYSTEM STATS: Time:2.0800 Method:cmd.php Processes:2 Threads:N/A Hosts:30 HostsPerProcess:15 DataSources: RRDsProcessed:0
02/07/2007 02:20:04 PM - SYSTEM STATS: Time:2.0796 Method:cmd.php Processes:2 Threads:N/A Hosts:30 HostsPerProcess:15 DataSources: RRDsProcessed:0
02/07/2007 02:25:04 PM - SYSTEM STATS: Time:2.0826 Method:cmd.php Processes:2 Threads:N/A Hosts:30 HostsPerProcess:15 DataSources: RRDsProcessed:0

[georgepremier]

anyone got any ideas on this? please!

[gandalf]

Which version? Fully patched?
Reinhard

[mdtkdchick]

I am having the same problem.

My graphs run for a couple of hours and then they stop updating. When I check the logs I see the following errors:

02/14/2007 05:45:02 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed "select id from host where disabled = '' order by id"
02/14/2007 05:45:02 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed "select poller_id,end_time from poller_time where poller_id = 0"
02/14/2007 05:45:02 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed "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) "


Did you guys ever find a solution for this issue?

thanks