Cacti (home)ForumsDocumentation
Cacti: offical forums and support
It is currently Sat Jun 24, 2017 3:50 pm

All times are UTC - 5 hours




Post new topic Reply to topic  [ 5 posts ] 
Author Message
 Post subject: Spine Encountered a Segmentation Fault
PostPosted: Wed Feb 24, 2010 11:48 pm 
Offline

Joined: Wed Feb 24, 2010 11:36 pm
Posts: 22
Location: Thailand
I have problem about spine as below.
-------
SPINE: Poller[0] FATAL: Spine Encountered a Segmentation Fault (Spine thread)
POLLER: Poller[0] Maximum runtime of 298 seconds exceeded. Exiting.

-------
When I restart mysql, log show as below

02/25/2010 11:20:03 AM - SPINE: Poller[0] FATAL: Spine Encountered a Segmentation Fault (Spine thread)
02/25/2010 11:20:00 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"show tables"
02/25/2010 11:20:00 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'2006', SQL:"REPLACE INTO settings (name,value) VALUES ('stats_recache','RecacheTime:0.0 HostsRecached:0')'
02/25/2010 11:20:00 AM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'2006', SQL:"SELECT COUNT(*) FROM poller_command"
02/25/2010 11:20:00 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'2006', SQL:"REPLACE INTO settings (name,value) VALUES ('stats_poller','Time:298.8139 Method:spine Processes:6 Threads:5 Hosts:411 HostsPerProcess:69 DataSources:3119 RRDsProcessed:1462')'
02/25/2010 11:20:00 AM - SYSTEM STATS: Time:298.8139 Method:spine Processes:6 Threads:5 Hosts:411 HostsPerProcess:69 DataSources:3119 RRDsProcessed:1462
02/25/2010 11:20:00 AM - POLLER: Poller[0] Maximum runtime of 298 seconds exceeded. Exiting.
02/25/2010 11:20:00 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', 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) LIMIT 10000"
02/25/2010 11:20:00 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"select poller_id,end_time from poller_time where poller_id=0"
02/25/2010 11:19:59 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', 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) LIMIT 10000"
02/25/2010 11:19:59 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"select poller_id,end_time from poller_time where poller_id=0"
02/25/2010 11:19:58 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', 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) LIMIT 10000"
02/25/2010 11:19:58 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"select poller_id,end_time from poller_time where poller_id=0"
02/25/2010 11:19:57 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', 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) LIMIT 10000"
02/25/2010 11:19:57 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"select poller_id,end_time from poller_time where poller_id=0"
02/25/2010 11:19:56 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', 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) LIMIT 10000"

-------------
Technical Support
General Information
Date Thu, 25 Feb 2010 11:48:14 +0700
Cacti Version 0.8.7e
Cacti OS unix
SNMP Version NET-SNMP version: 5.3.2.2
RRDTool Version RRDTool 1.3.x
Hosts 416
Graphs 1571
Data Sources Script/Command: 5
SNMP Query: 1587
Total: 1592
Poller Information
Interval 300
Type spine
Items Action[0]: 3120
Action[1]: 5
Total: 3125
Concurrent Processes 6
Max Threads 5
PHP Servers 2
Script Timeout 25
Max OID 30
Last Run Statistics Time:299.7655 Method:spine Processes:6 Threads:5 Hosts:412 HostsPerProcess:69 DataSources:3125 RRDsProcessed:1470
PHP Information
PHP Version 5.1.6
PHP OS Linux
PHP uname Linux dragon.localdomain 2.6.18-164.el5xen #1 SMP Thu Sep 3 04:47:32 EDT 2009 i686
PHP SNMP Installed
max_execution_time 30
memory_limit 256M
---------------------------------


Plz suggest to me ASAP.
Thanks.

T_T


Top
 Profile  
 
 Post subject:
PostPosted: Tue Mar 23, 2010 7:09 am 
Offline
Developer
User avatar

Joined: Tue May 14, 2002 5:08 pm
Posts: 14863
Location: MI, USA
Not enough information.

Code:
./spine -R -V 3


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:
PostPosted: Tue Mar 23, 2010 7:10 am 
Offline
Developer
User avatar

Joined: Tue May 14, 2002 5:08 pm
Posts: 14863
Location: MI, USA
Error 2006 is MySQL went away. You likely don't have enough connections to MySQL configured. Also, make sure your maximum error count is higher than the default if this is a recent MySQL version.

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:
PostPosted: Thu Jun 10, 2010 6:35 am 
Offline

Joined: Mon May 17, 2010 1:09 pm
Posts: 3
I have the exact same issue:
from cacti.log:


06/10/2010 03:45:00 PM - SYSTEM STATS: Time:299.7905 Method:spine Processes:4 Threads:20 Hosts:340 HostsPerProcess:85 DataSources:1207 RRDsProcessed:561
06/10/2010 03:45:20 PM - SPINE: Poller[0] FATAL: Spine Encountered a Segmentation Fault (Spine thread)

It was working fine until this morning, suddenly it became like this. And have to say that I haven't changed anything!
I recompiled the spine, but no success..


Top
 Profile  
 
 Post subject:
PostPosted: Thu Jun 10, 2010 7:04 am 
Offline
Developer
User avatar

Joined: Tue May 14, 2002 5:08 pm
Posts: 14863
Location: MI, USA
You don't have enough MySQL connections. You need to increase your connection count to ~ 1000 or more in /etc/my.cnf and restart MySQL.

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  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 5 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