Cacti (home)ForumsDocumentation
Cacti: offical forums and support
It is currently Thu Jun 29, 2017 9:12 am

All times are UTC - 5 hours




Post new topic Reply to topic  [ 3 posts ] 
Author Message
 Post subject: Graphs are being updated without data
PostPosted: Thu Jun 24, 2010 1:13 pm 
Offline

Joined: Thu Jun 24, 2010 11:16 am
Posts: 2
Location: Buenos Aires, Argentina
I've been struggling with my Cacti installation for a while.

I'm using Cacti/Spine 0.8.7g with the spine.c patch and PA 0.8.7g too.

My HW is a Dell PowerEdge 2950 With 2 Quad Core Intel(R) Xeon(R) CPU E5310 @ 1.60GHz and 8gb RAM. Kernel is 2.6.26-2-amd64 #1 SMP Tue Jan 12 22:12:20 UTC 2010 x86_64 GNU/Linux and the php version is the following:

Code:
mrelms02-horus# php -v
PHP 5.2.6-1+lenny8 with Suhosin-Patch 0.9.6.2 (cli) (built: Mar 14 2010 09:07:33)
Copyright (c) 1997-2008 The PHP Group
Zend Engine v2.2.0, Copyright (c) 1998-2008 Zend Technologies


I've got the boost plugin enabled and I'm running the log in DEVEL level and found this:
Code:
06/24/2010 03:05:31 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'0', SQL:"show tables from `horus_cacti`"
06/24/2010 03:05:31 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'0', SQL:"SELECT 1 AS id, ph.name, ph.file, ph.function FROM plugin_hooks AS ph LEFT JOIN plugin_config AS pc ON pc.directory=ph.name WHERE ph.status = 1 AND hook = 'poller_bottom' AND ph.name IN ('settings', 'boost', 'dsstats') UNION SELECT pc.id, ph.name, ph.file, ph.function FROM plugin_hooks AS ph LEFT JOIN plugin_config AS pc ON pc.directory=ph.name WHERE ph.status = 1 AND hook = 'poller_bottom' AND ph.name NOT IN ('settings', 'boost', 'dsstats') ORDER BY id ASC"
06/24/2010 03:05:31 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'0', SQL:"REPLACE INTO settings (name,value) VALUES ('stats_recache','RecacheTime:0.0 HostsRecached:0')'
06/24/2010 03:05:31 PM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'0', SQL:"SELECT COUNT(*) FROM poller_command"
06/24/2010 03:05:31 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'0', SQL:"REPLACE INTO settings (name,value) VALUES ('stats_poller','Time:0.0031 Method:spine Processes:4 Threads:15 Hosts:0 HostsPerProcess:0 DataSources:155 RRDsProcessed:0')'
06/24/2010 03:05:31 PM - SYSTEM STATS: Time:0.0031 Method:spine Processes:4 Threads:15 Hosts:0 HostsPerProcess:0 DataSources:155 RRDsProcessed:0
06/24/2010 03:05:31 PM - 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) "
06/24/2010 03:05:31 PM - 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'"
06/24/2010 03:05:31 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'0', SQL:"REPLACE INTO settings (name,value) VALUES ('date',NOW())'
06/24/2010 03:05:31 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'0', SQL:"SELECT 1 AS id, ph.name, ph.file, ph.function FROM plugin_hooks AS ph LEFT JOIN plugin_config AS pc ON pc.directory=ph.name WHERE ph.status = 1 AND hook = 'poller_command_args' AND ph.name IN ('settings', 'boost', 'dsstats') UNION SELECT pc.id, ph.name, ph.file, ph.function FROM plugin_hooks AS ph LEFT JOIN plugin_config AS pc ON pc.directory=ph.name WHERE ph.status = 1 AND hook = 'poller_command_args' AND ph.name NOT IN ('settings', 'boost', 'dsstats') ORDER BY id ASC"
06/24/2010 03:05:31 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'0', SQL:"SELECT local_data_id, rrd_name FROM poller_output"
06/24/2010 03:05:31 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'0', SQL:"TRUNCATE TABLE poller_time'
06/24/2010 03:05:31 PM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'0', SQL:"SELECT count(*) FROM poller_time WHERE end_time='0000-00-00 00:00:00'"
06/24/2010 03:05:31 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'0', SQL:"REPLACE INTO settings (name,value) VALUES ('path_webroot','/usr/local/tanga')'
06/24/2010 03:05:31 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'0', SQL:"SELECT id FROM host WHERE disabled = '' ORDER BY id"
06/24/2010 03:05:31 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'0', SQL:"SELECT 1 AS id, ph.name, ph.file, ph.function FROM plugin_hooks AS ph LEFT JOIN plugin_config AS pc ON pc.directory=ph.name WHERE ph.status = 1 AND hook = 'poller_top' AND ph.name IN ('settings', 'boost', 'dsstats') UNION SELECT pc.id, ph.name, ph.file, ph.function FROM plugin_hooks AS ph LEFT JOIN plugin_config AS pc ON pc.directory=ph.name WHERE ph.status = 1 AND hook = 'poller_top' AND ph.name NOT IN ('settings', 'boost', 'dsstats') ORDER BY id ASC"


I get to run these queries manually if I want.. without any errors (by the way, error '0'?) I don't understand why there are entries with CMDPHP if I'm using spine.....

And here's the output of my Technical Support page:

Code:
Date     Thu, 24 Jun 2010 15:09:49 -0300
Cacti Version    0.8.7g
Cacti OS    unix
SNMP Version    NET-SNMP version: 5.4.1
RRDTool Version    RRDTool 1.4.x
Hosts    240
Graphs    1291
Data Sources    Script/Command: 50
SNMP: 332
SNMP Query: 1044
Script Query: 3
Script - Script Server (PHP): 124
Script Query - Script Server: 4
Total: 1557
Poller Information
Interval    30
Type    spine
Items    Action[0]: 1437
Action[1]: 55
Action[2]: 14
Total: 1506
Concurrent Processes    4
Max Threads    15
PHP Servers    10
Script Timeout    45
Max OID    20
Last Run Statistics    Time:25.7525 Method:spine Processes:4 Threads:15 Hosts:100 HostsPerProcess:25 DataSources:155 RRDsProcessed:0
PHP Information
PHP Version    5.2.6-1+lenny8
PHP OS    Linux
PHP uname    Linux mrelms02 2.6.26-2-amd64 #1 SMP Tue Jan 12 22:12:20 UTC 2010 x86_64
PHP SNMP    Not Installed
max_execution_time    30
memory_limit    1G


My setup is using 4 processes with 15 threads each one to try to get everything polled before the 300s timeout. I'm not having a CPU bottleneck (my server runs with a load average lower than 2 and CPU usage is around 11% when polling)

Anyone know how to go through this?
[/code]


Top
 Profile  
 
 Post subject:
PostPosted: Fri Jun 25, 2010 10:53 am 
Offline
Developer
User avatar

Joined: Tue May 14, 2002 5:08 pm
Posts: 14863
Location: MI, USA
Send PM requesting online session.

TheWitness

_________________
True understanding begins only when we realize how little we truly understand...

Life is an adventure, let yours begin with Cacti!

Author of MacTrack, Boost, CLog, SpikeKill, Platform RTM, DSStats, maintainer of Spine, lot's of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
Gandalfs Official Debugging Help
Central Plugin Repository
Central Templates Repository


Top
 Profile  
 
 Post subject: Re: Graphs are being updated without data
PostPosted: Tue Oct 26, 2010 8:23 am 
Offline
Developer
User avatar

Joined: Tue May 14, 2002 5:08 pm
Posts: 14863
Location: MI, USA
This issue was resolved in cacti 0.8.7g patches.

_________________
True understanding begins only when we realize how little we truly understand...

Life is an adventure, let yours begin with Cacti!

Author of MacTrack, Boost, CLog, SpikeKill, Platform RTM, DSStats, maintainer of Spine, lot's of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
Gandalfs Official Debugging Help
Central Plugin Repository
Central Templates Repository


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 3 posts ] 

All times are UTC - 5 hours


Who is online

Users browsing this forum: No registered users and 1 guest


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:
Jump to:  

Protected by Anti-Spam ACP Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group