Hi, On Tue, Sep 21, 2010 at 11:56 PM, sean finney <sean...@debian.org> wrote: > some ideas/questions off the top of my head: > * did you get any sql upgrade errors after the package was updated?
There were no sql upgrade scripts from 0.8.7e-4 to 0.8.7g-1. The upgrade says clearly that there are no scripts to run. I've checked manually in the install directory and these two scripts are just changing the cacti vesion in the database: - 0_8_7e_to_0_8_7f.php - 0_8_7f_to_0_8_7g.php > * does the schema seem correct (i.e. a disabled column in the host table)? I don't know anything related to a 'schema', so probably not the issue. If you can tell me what to check, I'll do. > * does it work if you disable the spine poller and use the cmd.php one > instead? Yes, with 'cmd.php' I get the graphs but still at every 5 minutes there are SQL errors reported (see attached). No, with 'spine' I still get the SQL errors but also only NaN on all graphs. > * does it start graphing again if you nuke the rrd files or play around > with rrdtool versions? I'll try to avoid playing around with rrdtool again. I did it for the conversion from 1.2x to 1.3x and this is the main reason I'm using cacti from squeeze on a lenny host. > esp for the first two items, if you suspect the problem is in the SQL, > and have time to help with some QA: i think it would be very helpful to > get a db dump of a fresh install vs the db dump of a almost-as-fresh > install of the previous version upgraded after maybe half an hour of > polling... it could be that there's a bug in the update sql logic. I'll try to do a fresh install, but I don't I'll have the time this week. Thanks
09/22/2010 10:55:34 AM - PHPSVR: Poller[0] Maximum runtime of 60 seconds exceeded for the Script Server. Exiting.
09/22/2010 10:55:33 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 10:55:33 AM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'0', SQL:"SELECT COUNT(*) FROM poller_command"
09/22/2010 10:55:33 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'0', SQL:"REPLACE INTO settings (name,value) VALUES ('stats_poller','Time:0.0022 Method:cmd.php Processes:1 Threads:N/A Hosts:0 HostsPerProcess:0 DataSources:456 RRDsProcessed:0')'
09/22/2010 10:55:33 AM - SYSTEM STATS: Time:0.0022 Method:cmd.php Processes:1 Threads:N/A Hosts:0 HostsPerProcess:0 DataSources:456 RRDsProcessed:0
09/22/2010 10:55:33 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 10:55:33 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 10:55:33 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'0', SQL:"REPLACE INTO settings (name,value) VALUES ('date',NOW())'
09/22/2010 10:55:33 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'0', SQL:"SELECT local_data_id, rrd_name FROM poller_output"
09/22/2010 10:55:33 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'0', SQL:"TRUNCATE TABLE poller_time'
09/22/2010 10:55:33 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 10:55:33 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 10:55:33 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'0', SQL:"SELECT id FROM host WHERE disabled = '' ORDER BY id"
