Hi,
On Wed, Sep 22, 2010 at 10:57 AM, Teodor MICU <mteo...@gmail.com> wrote:
> Yes, with 'cmd.php' I get the graphs but still at every 5 minutes
> there are SQL errors reported (see attached).
Ok, the last test reveals that with 'cmd.php' used directly after
upgrade the same SQL errors will appear after the first 5 minutes
cycle (see attached file). See that the 'select' queries in the
database are good with some notes:
- there is a missing " in the log at 11:35:34 regarding SQL:"REPLACE INTO;
- I've executed only the 'select' queries.
Another problem seems that 'cmp.php' poller is executes more than 60
seconds which leads to overlapping:
09/22/2010 11:35:01 AM - POLLER: Poller[0] WARNING: There are '1'
detected as overrunning a polling process, please investigate
Shall I open a new bug report for this?
I'll revert to 0.8.7e-4 and test a fresh 'cacti=0.8.7g-1' install on a
virtual machine.
Thanks
09/22/2010 11:35:00 AM - SYSTEM STATS: Time:26.1492 Method:cmd.php Processes:1 Threads:N/A Hosts:42 HostsPerProcess:42 DataSources:464 RRDsProcessed:69
09/22/2010 11:35:01 AM - POLLER: Poller[0] WARNING: There are '1' detected as overrunning a polling process, please investigate
09/22/2010 11:35:01 AM - POLLER: Poller[0] WARNING: Poller Output Table not Empty. Issues Found: 4, Data Sources: cpu_user(DS[562]), load_1min(DS[563]), load_15min(DS[564]), load_5min(DS[565])
09/22/2010 11:35:05 AM - CMDPHP: Poller[0] Host[3] DS[33] WARNING: Result from SNMP not valid. Partial Result: U
09/22/2010 11:35:05 AM - CMDPHP: Poller[0] Host[3] DS[33] WARNING: Result from SNMP not valid. Partial Result: U
09/22/2010 11:35:34 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'0', SQL:"SELECT id FROM host WHERE disabled = '' ORDER BY id"
09/22/2010 11:35:34 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'0', SQL:"REPLACE INTO settings (name,value) VALUES ('path_webroot','/usr/share/cacti/site')'
09/22/2010 11:35:34 AM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'0', SQL:"SELECT count(*) FROM poller_time WHERE end_time='0000-00-00 00:00:00'"
09/22/2010 11:35:34 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'0', SQL:"TRUNCATE TABLE poller_time'
09/22/2010 11:35:34 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'0', SQL:"SELECT local_data_id, rrd_name FROM poller_output"
09/22/2010 11:35:34 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'0', SQL:"REPLACE INTO settings (name,value) VALUES ('date',NOW())'
09/22/2010 11:35:34 AM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'0', SQL:"SELECT count(*) FROM poller_time WHERE poller_id=0 AND end_time>'0000-00-00 00:00:00'"
09/22/2010 11:35:34 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'0', 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) "
09/22/2010 11:35:34 AM - SYSTEM STATS: Time:0.0023 Method:cmd.php Processes:1 Threads:N/A Hosts:0 HostsPerProcess:0 DataSources:464 RRDsProcessed:0
09/22/2010 11:35:34 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'0', SQL:"REPLACE INTO settings (name,value) VALUES ('stats_poller','Time:0.0023 Method:cmd.php Processes:1 Threads:N/A Hosts:0 HostsPerProcess:0 DataSources:464 RRDsProcessed:0')'
09/22/2010 11:35:34 AM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'0', SQL:"SELECT COUNT(*) FROM poller_command"
09/22/2010 11:35:34 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'0', SQL:"REPLACE INTO settings (name,value) VALUES ('stats_recache','RecacheTime:0.0 HostsRecached:0')'
09/22/2010 11:35:35 AM - PHPSVR: Poller[0] Maximum runtime of 60 seconds exceeded for the Script Server. Exiting.
