Cacti Poller 0 Error Sql Assoc Failed
[Print] ID Category Severity Reproducibility Date Submitted Last cacti mysql password Update 0002407 [Cacti] Poller (cactid, cmd.php) minor have not mysql error 2006 tried 2013-11-15 05:09 2014-01-05 00:29 Reporter faraziqbal View Status public Assigned To Linegod Priority mysql repair database normal Resolution no change required Platform Status resolved OS Projection none OS Version ETA none Fixed in Version Product Version 0.8.8a mysql repair table Target Version Product Build Summary 0002407: I am getting Error SQL Associ Failed! for short duration and then back on Description I got NaN in graph for 10 min and then it back on. In cacti log I got below error.... Someone please help what is the issue ------------------------------------------------------------------------- 11/15/2013 03:25:08 AM - SYSTEM THOLD STATS: Time:0.0433 Tholds:0 DownHosts:0 11/15/2013 03:25:08 AM - SYSTEM STATS: Time:4.7648 Method:spine Processes:4 Threads:1 Hosts:7 HostsPerProcess:2 DataSources:30 RRDsProcessed:15 11/15/2013 03:25:04 AM - POLLER: Poller[0] WARNING: Poller Output Table not Empty. Issues Found: 30, Data Sources: traffic_in(DS[88]), traffic_out(DS[88]), traffic_in(DS[89]), traffic_out(DS[89]), traffic_in(DS[90]), traffic_out(DS[90]), traffic_in(DS[91]), traffic_out(DS[91]), traffic_in(DS[92]), traffic_out(DS[92]), traffic_in(DS[93]), traffic_out(DS[93]), traffic_in(DS[94]), traffic_out(DS[94]), traffic_in(DS[95]), traffic_out(DS[95]), traffic_in(DS[96]), traffic_out(DS[96]), traffic_in(DS[97]), traffic_out(DS[97]), Additional Issues Remain. Only showing first 20 11/15/2013 03:20:22 AM - 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" 11/15/2013 03:20:22 AM - 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'" 11/15/2013 03:20:22 AM - 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
Graphs were not generated. Then I checked the Cacti Log, and it shows the following error. #tail -f /var/www/html/log/cacti.log Error Log: 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" Then I found that the poller_output table was corrupted Solution: Then I tried to repair the corrupted table, but it was not http://bugs.cacti.net/view.php?id=2407 repaired successfully. So I Truncated that particular table through phpmyadmin and rebuild the poller cache through Cache Admin->System Utilities. TRUNCATE `poller_output` ; Your SQL query has been executed successfully Due to low disk space in the database server, the table poller_output was corrupted for me. FOLLOW US :- http://linuxadmin.melberi.com/2011/09/poller0-error-sql-assoc-failed.html Newer Post Older Post Home 1 comments : AnonymousMay 30, 2013 at 12:28 AMThanks mate, had the same happening to me. Your easy to follow tip just saved my cacti setup.ReplyDeleteAdd commentLoad more... Subscribe to: Post Comments ( Atom ) Popular List Online Tags Installation Procedures GLPI Email notification Setup GLPI installation Procedure Linux Terminal Server Config Roundcube webmail installation procedure Samba PDC with ldap support Trixbox installation Procedure Zabbix Installation Procedure Squid Config Block skype on squid Squid cache Antivirus Update Squid delay Pools squid ntlm auth Squid proxy server download limit squid proxy server upload limit IPTABLES CONFIG Basic Iptables Configuration iptables Configuration for NFS server IPTABLES For ALL Ports Iptables For FTP server iptables for Symantec Backup Exec Iptables NAT Port forwarding Masquerade SSH port Config in iptable About Me Mel Biah View my complete profile Copyright © Linux How to | Powered by Blogger
View active topics View new posts View your posts General technical discussions. Post a reply 16 posts Page 1 of 1 ZiPPy Ultimate Member Posts: 509 Joined: Mon Aug 24, 2009 3:04 pm Certs: CCNA Unable to login to Cacti Fri Nov 18, 2011 12:04 pm I've hit up the Cacti forums, but didn't find any answers on my issue with Cacti. I installed a fresh install of Cacti the other day successfully. I was troubleshooting an issue in Cacti where my graphs are showing blank, and in some cases not at all. But that's an entirely separate issue.I can no longer login to Cacti. I can't remember for the life of me what I did, but now when I attempt to login it just loops for a quick second and back at the login screen. I know my password is correct, as it doesn't throw back any errors.Has anybody encountered this before? I here so many good things about Cacti and I wanted to get it running, but I literally killed it right now.Any thoughts? ristau5741 Post Whore Posts: 10618 Joined: Tue Aug 21, 2007 2:15 pm Certs: Instanity Re: Unable to login to Cacti Fri Nov 18, 2011 12:42 pm if its fresh, reinstall, sure it's not a browser issue? Tips of the day:- The human mind is the ultimate creation invention.- I have so many customers, my customers have customers. - Sausage time- POP, stack, and store ZiPPy Ultimate Member Posts: 509 Joined: Mon Aug 24, 2009 3:04 pm Certs: CCNA Re: Unable to login to Cacti Fri Nov 18, 2011 1:13 pm I'm pretty sure it's not browser related, because after I made a change it kicked me out right away. It was to an admin setting though, and I just can't remember exactly where I did it. damn it! scottsee Post Whore Posts: 1804 Joined: Wed Feb 10, 2010 2:45 am Certs: NA:R&S, NA:Sec Re: Unable to login to Cacti Fri Nov 18, 2011 1:20 pm Try a System Restore.. ZiPPy Ultimate Member Posts: 509 Joined: Mon Aug 24, 2009 3:04 pm Certs: CCNA Re: Unable to login to Cacti Fri Nov 18, 2011 1:26 pm scottsee wrote:Try a System Restore..Running Cacti on Ubuntu. cjutting Post Whore Posts: 1081 Joined: Wed Sep 16, 2009 3:16 pm Re: Unable to login to Cacti Fri Nov 18, 2011 2:05 pm http://www.cacti.net/downloads/docs/htm ... ml#AEN2449Does that help?Edit: Sorry I didn't read the part where you knew your password is correct. It might be worth trying to reset your password anyways see if for some reason it changed Dinger Post Whore Posts: 1397 Joined: Fri Apr 2