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
Cacti Stopped Graphing
Moderators: Developers, Moderators
-
- Posts: 2
- Joined: Wed Oct 10, 2012 3:49 pm
Re: Cacti Stopped Graphing
I have rebooted several times, the poller is running as scheduled.
Re: Cacti Stopped Graphing
Did you google for MySQL error 145? A table is marked as crashed.
Did you check the Cacti technical support page?
Did you check the Cacti technical support page?
| Scripts: Monitor processes | RFC1213 MIB | DOCSIS Stats | Dell PowerEdge | Speedfan | APC UPS | DOCSIS CMTS | 3ware | Motorola Canopy |
| Guides: Windows Install | [HOWTO] Debug Windows NTFS permission problems |
| Tools: Windows All-in-one Installer |
Who is online
Users browsing this forum: No registered users and 6 guests