Re: Upgrading to 0.8.8b

Gandalf <[email protected]>
Newsgroups gmane.network.cacti.user
Message-ID <[email protected]> 
That very likely shows, that two pollers are running in parallel. Please search
all your crontabs
R.

On 27.08.2013 23:46, James Bensley wrote:
> After upgrading my Cacti to 0.8.8b everything seems to working OK,
> thanks Reinhard!
> 
> I have this being logged many times per second though in my cacti.log,
> which is churning through some disk space, roughly 1GB per hour, so
> something must be wrong!
> 
> Anyone got any idea what's going on?
> 
> Cheers,
> James.
> 
> 08/27/2013 10:42:49 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!,
> Error:'2006', SQL:"select  poller_output.output,  poller_output.time,
> UNIX_TIMESTAMP(poller_output.time) as unix_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"
> 08/27/2013 10:42:49 PM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!,
> Error:'2006', SQL:"SELECT count(*) FROM poller_time WHERE poller_id=0
> AND end_time>'0000-00-00 00:00:00'"
> 08/27/2013 10:42:49 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!,
> Error:'2006', SQL:"select  poller_output.output,  poller_output.time,
> UNIX_TIMESTAMP(poller_output.time) as unix_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"
> 08/27/2013 10:42:49 PM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!,
> Error:'2006', SQL:"SELECT count(*) FROM poller_time WHERE poller_id=0
> AND end_time>'0000-00-00 00:00:00'"
> 08/27/2013 10:42:49 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!,
> Error:'2006', SQL:"select  poller_output.output,  poller_output.time,
> UNIX_TIMESTAMP(poller_output.time) as unix_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"
> 08/27/2013 10:42:49 PM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!,
> Error:'2006', SQL:"SELECT count(*) FROM poller_time WHERE poller_id=0
> AND end_time>'0000-00-00 00:00:00'"
> 08/27/2013 10:42:49 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!,
> Error:'2006', SQL:"select  poller_output.output,  poller_output.time,
> UNIX_TIMESTAMP(poller_output.time) as unix_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"
> 08/27/2013 10:42:49 PM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!,
> Error:'2006', SQL:"SELECT count(*) FROM poller_time WHERE poller_id=0
> AND end_time>'0000-00-00 00:00:00'"
> 08/27/2013 10:42:49 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!,
> Error:'2006', SQL:"select  poller_output.output,  poller_output.time,
> UNIX_TIMESTAMP(poller_output.time) as unix_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"
> 08/27/2013 10:42:49 PM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!,
> Error:'2006', SQL:"SELECT count(*) FROM poller_time WHERE poller_id=0
> AND end_time>'0000-00-00 00:00:00'"
> 08/27/2013 10:42:49 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!,
> Error:'2006', SQL:"select  poller_output.output,  poller_output.time,
> UNIX_TIMESTAMP(poller_output.time) as unix_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"
> 08/27/2013 10:42:49 PM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!,
> Error:'2006', SQL:"SELECT count(*) FROM poller_time WHERE poller_id=0
> AND end_time>'0000-00-00 00:00:00'"
> 
> ------------------------------------------------------------------------------
> Learn the latest--Visual Studio 2012, SharePoint 2013, SQL 2012, more!
> Discover the easy way to master current and previous Microsoft technologies
> and advance your career. Get an incredible 1,500+ hours of step-by-step
> tutorial videos with LearnDevNow. Subscribe today and save!
> http://pubads.g.doubleclick.net/gampad/clk?id=58040911&iu=/4140/ostg.clktrk
> _______________________________________________
> cacti-user mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/cacti-user
> 

------------------------------------------------------------------------------
Learn the latest--Visual Studio 2012, SharePoint 2013, SQL 2012, more!
Discover the easy way to master current and previous Microsoft technologies
and advance your career. Get an incredible 1,500+ hours of step-by-step
tutorial videos with LearnDevNow. Subscribe today and save!
http://pubads.g.doubleclick.net/gampad/clk?id=58040911&iu=/4140/ostg.clktrk
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.