Cactiusers.org


It is currently Tue Mar 09, 2010 11:41 pm




Post new topic Reply to topic  [ 3 posts ] 
 No more graphs 
Author Message
New User

Joined: Mon Feb 16, 2009 5:47 am
Posts: 3
Post No more graphs
hello ,

the graphs stopped last week and I don't know why.

My log files I have:
02/16/2009 12:00:13 PM - SYSTEM STATS: Time:11.1899 Method:cmd.php Processes:1 Threads:N/A Hosts:33 HostsPerProcess:33 DataSources:903 RRDsProcessed:0
02/16/2009 12:00:13 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'130', 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) "
02/16/2009 12:00:12 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'130', SQL:"insert into poller_output (local_data_id, rrd_name, time, output) values (962, 'proc', '2009-02-16 12:00:12', '52')'
02/16/2009 12:00:12 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'130', SQL:"insert into poller_output (local_data_id, rrd_name, time, output) values (961, '', '2009-02-16 12:00:12', '1min:0.03 5min:0.14 10min:0.08')'

and poller_output don't know the file format....

can you help me please.


Mon Feb 16, 2009 5:52 am
Site Admin

Joined: Thu Nov 11, 2004 11:12 am
Posts: 1979
Post Re: No more graphs
You running boost?

Also, double check that your HD hasn't filled up.


Mon Feb 16, 2009 5:13 pm
New User

Joined: Fri Jul 03, 2009 7:10 am
Posts: 1
Post Re: No more graphs
try to recreate table poller_output on the cacti databases.
Code:
DROP TABLE IF EXISTS `poller_output`;
CREATE TABLE `poller_output` (
  `local_data_id` mediumint(8) unsigned NOT NULL default '0',
  `rrd_name` varchar(19) NOT NULL default '',
  `time` datetime NOT NULL default '0000-00-00 00:00:00',
  `output` text NOT NULL,
  PRIMARY KEY  (`local_data_id`,`rrd_name`,`time`)
) TYPE=MyISAM;


Fri Jul 03, 2009 7:14 am
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 3 posts ] 


Who is online

Users browsing this forum: Yahoo [Bot] and 0 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for: