Looking at the debug output, it seems like the poller is looping on the SQLs below until it times out:
11/06/2009 06:20:21 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id=0"
11/06/2009 06:20:21 PM - 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) LIMIT 10000"
I have tried running mysqlcheck and repair_database.php but it does not seem to make a difference. Help!
System info:
Cacti Version - 0.8.7b Plugin Architecture - 2.1 Poller Type - CMD.php Server Info - Windows NT 5.1 Web Server - Apache/2.0.55 (Win32) PHP/5.1.4 PHP - 5.1.4 PHP Extensions - bcmath, calendar, com_dotnet, ctype, date, ftp, hash, iconv, odbc, pcre, Reflection, session, libxml, standard, tokenizer, zlib, SimpleXML, dom, SPL, wddx, xml, xmlreader, xmlwriter, apache2handler, eAccelerator, mysql, snmp, sockets MySQL - 5.0.45-community-nt RRDTool - 1.2.27 SNMP - snmpwalk [OPTIONS] AGENT [OID] Version: 5.4.1 Web: http://www.net-snmp.org/ Email: net-snmp-coders@lists.sourceforge.net Plugins
- Global Plugin Settings (settings - v0.5) Thresholds (thold - v0.3.9) Host Info (hostinfo - v0.2) Device Monitoring (monitor - v0.8.2) Update Checker (update - v0.4)
