Cacti Stopped Graphing

Post support questions that relate to the Windows 2003/2000/XP operating systems.

Moderators: Developers, Moderators

Post Reply
Doulos24x7
Posts: 2
Joined: Wed Oct 10, 2012 3:49 pm

Cacti Stopped Graphing

Post by Doulos24x7 »

Here is the Technical Support information:

Date Wed, 10 Oct 2012 16:03:14 -0500
Cacti Version 0.8.7g
Cacti OS win32
SNMP Version NET-SNMP version: 5.5
RRDTool Version RRDTool 1.2.x
Hosts 19
Graphs 557
Data Sources Script/Command: 5
SNMP: 28
SNMP Query: 485
Script Query - Script Server: 52
Total: 570
Poller Information
Interval 300
Type cmd.php
Items Action[0]: 998
Action[2]: 81
Total: 1079
Concurrent Processes 1
Max Threads 1
PHP Servers 1
Script Timeout 25
Max OID 10
Last Run Statistics Time:1.2295 Method:cmd.php Processes:1 Threads:N/A Hosts:20 HostsPerProcess:20 DataSources: RRDsProcessed:0
PHP Information
PHP Version 5.2.14
PHP OS WINNT
PHP uname Windows NT ITNETADMIN 5.1 build 2600
PHP SNMP Installed
max_execution_time 300
memory_limit 128M

It stopped graphing a few days ago...the console responds, but the graphs are completely blank. Here a sample of the error in the log file:

10/06/2012 09:40:14 PM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'145', SQL:"SELECT COUNT(*) FROM poller_item WHERE rrd_next_step<=0"
10/06/2012 09:40:14 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'145', SQL:"SELECT host_id, COUNT(*) AS data_sources FROM poller_item WHERE rrd_next_step<=0 GROUP BY host_id ORDER BY host_id"
10/06/2012 09:40:14 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'145', SQL:"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"
10/06/2012 09:40:14 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'145', SQL:"SELECT * FROM poller_item WHERE (host_id >= 0 AND host_id <= 53 AND rrd_next_step <= 0) ORDER by host_id"
10/06/2012 09:40:14 PM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'145', SQL:"SELECT count(*) FROM poller_item WHERE (action=2 AND host_id >= 0 AND host_id <= 53 AND rrd_next_step <= 0)"
10/06/2012 09:40:14 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'145', SQL:"UPDATE poller_item SET rrd_next_step = rrd_next_step - 300 WHERE (host_id >= 0 AND host_id <= 53)'
10/06/2012 09:40:14 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'145', SQL:"UPDATE poller_item SET rrd_next_step = rrd_step - 300 WHERE (rrd_next_step < 0 AND host_id >= 0 AND host_id <= 53)'
10/06/2012 09:40:15 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'145', SQL:"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) "
10/06/2012 09:40:15 PM - SYSTEM STATS: Time:1.1646 Method:cmd.php Processes:1 Threads:N/A Hosts:20 HostsPerProcess:20 DataSources: RRDsProcessed:0
Doulos24x7
Posts: 2
Joined: Wed Oct 10, 2012 3:49 pm

Re: Cacti Stopped Graphing

Post by Doulos24x7 »

I have rebooted several times, the poller is running as scheduled.
User avatar
BSOD2600
Cacti Moderator
Posts: 12171
Joined: Sat May 08, 2004 12:44 pm
Location: USA

Re: Cacti Stopped Graphing

Post by BSOD2600 »

Did you google for MySQL error 145? A table is marked as crashed.
Did you check the Cacti technical support page?
Post Reply

Who is online

Users browsing this forum: No registered users and 6 guests