troubleshooting Question

Cacti SQL Issue

Avatar of cafasdon
cafasdon asked on
NetworkingMySQL ServerNetwork Management
2 Comments1 Solution4592 ViewsLast Modified:
Hey there people!

I'm having a huge problem in my Cacti appliance and don't know how to fix it. I've "googled" a lot already but none of the solutions that were avaliable matched my case. This is a small part of what I'm getting in my error log:

--------------------------------------------------------

01/06/2009 05:03:15 AM - SPINE: Poller[0] ERROR: A database insert failed! Error:'1017', SQL Fragment:'INSERT INTO poller_output (local_data_id, rrd_name, time, output) VALUES (10106,'mem_buffers','2009-01-06 05:03:15','502652'),(10111,'hdd_free','2009-01-06 05:03:15','83739'),(10111,'hdd_used','2009-01-06 05:03:15','12128')'
01/06/2009 05:03:15 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1017', 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"
01/06/2009 05:03:14 AM - PHPSVR: Poller[0] ERROR: Input Expected, Script Server Terminating
01/06/2009 05:03:14 AM - PHPSVR: Poller[0] ERROR: Input Expected, Script Server Terminating
01/06/2009 05:03:14 AM - PHPSVR: Poller[0] ERROR: Input Expected, Script Server Terminating
01/06/2009 05:03:14 AM - PHPSVR: Poller[0] ERROR: Input Expected, Script Server Terminating
01/06/2009 05:03:14 AM - PHPSVR: Poller[0] ERROR: Input Expected, Script Server Terminating
01/06/2009 05:03:14 AM - PHPSVR: Poller[0] ERROR: Input Expected, Script Server Terminating
01/06/2009 05:03:14 AM - PHPSVR: Poller[0] ERROR: Input Expected, Script Server Terminating
01/06/2009 05:03:14 AM - PHPSVR: Poller[0] ERROR: Input Expected, Script Server Terminating
01/06/2009 05:03:14 AM - PHPSVR: Poller[0] ERROR: Input Expected, Script Server Terminating
01/06/2009 05:03:14 AM - PHPSVR: Poller[0] ERROR: Input Expected, Script Server Terminating
01/06/2009 05:03:14 AM - SPINE: Poller[0] FATAL: Connection Failed: Too many connections (Spine thread)
01/06/2009 05:03:14 AM - SPINE: Poller[0] ERROR: A database insert failed! Error:'1017', SQL Fragment:'INSERT INTO poller_output (local_data_id, rrd_name, time, output) VALUES (6923,'traffic_in','2009-01-06 05:03:14','371178316'),(6923,'traffic_out','2009-01-06 05:03:14','1134696462'),(9335,'proc','2009-01-06 05:03:14','103')'
01/06/2009 05:03:14 AM - SPINE: Poller[0] ERROR: A database insert failed! Error:'1017', SQL Fragment:'INSERT INTO poller_output (local_data_id, rrd_name, time, output) VALUES (7338,'traffic_in','2009-01-06 05:03:14','0'),(7338,'traffic_out','2009-01-06 05:03:14','0'),(9621,'users','2009-01-06 05:03:14','2')'
01/06/2009 05:03:14 AM - SPINE: Poller[0] ERROR: A database insert failed! Error:'1017', SQL Fragment:'INSERT INTO poller_output (local_data_id, rrd_name, time, output) VALUES (9570,'proc','2009-01-06 05:03:14','104')'

--------------------------------------------------------

I've already ran a fsck and the built-in "repair_database.sh" script inside /cli folder from Cacti's latest version, as well as a "Rebuild Poller Cache". Poller being used is Spine, not CMDPHP (poller.php).


This is not an upgraded version, its a vmware appliance known as CactiEZ, version 0.8.7b. OS is CentOS 4.6 Final.

Any ideas?

Thanks.
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 2 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros