Error Sql Assoc Failed Cacti
Contents |
ERROR: SQL Assoc Failed Moderators: Moderators, Developers Page 1 of 2 [ 16 posts ] Go to page mysql error 2006 1, 2 Next Previous topic | Next topic Author Message mistery
Mysql Repair Database
Post subject: CMDPHP: Poller[0] ERROR: SQL Assoc FailedPosted: Sat Oct 21, 2006 3:45 am Joined: Tue May 02, 2006 mysql repair table 1:03 amPosts: 3 Hello, I have upgraded Cacti to 0.8.6i and now when I run the rebuild poller cache script I get the following error in the log: 10/21/2006 10:41:14 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed "select snmp_query_graph_rrd.snmp_field_name, data_template_rrd.id as data_template_rrd_id from (snmp_query_graph_rrd,data_template_rrd) where snmp_query_graph_rrd.data_template_rrd_id=data_template_rrd.local_data_template_rrd_id and snmp_query_graph_rrd.snmp_query_graph_id= and snmp_query_graph_rrd.data_template_id=41 and data_template_rrd.local_data_id=90" Does anyone know how to fix this issue ? Thanks A. Top TheWitness Post subject: Posted: Sat Oct 21, 2006 2:00 pm Developer Joined: Tue May 14, 2002 5:08 pmPosts: 14862Location: MI, USA Can you verify you MySQL version please? 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 DocumentationGandalfs Official Debugging HelpCentral Plugin RepositoryCentral Templates Repository Top mistery Post subject: Posted: Sun Oct 22, 2006 1:06 am Joined: Tue May 02, 2006 1:03 amPosts: 3 TheWitness wrote:Can you verify you MySQL version please?TheWitness # rpm -q mysql mysql-4.1.20-1.RHEL4.1 Thanks A. Top TheWitness Post subject: Posted: Sun Oct 22, 2006 7:03 pm Developer Joined: Tue May 14, 2002 5:08 pmPosts: 14862Location: MI, USA I suspect a damaged database. 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 DocumentationGandalfs Official Debugging HelpCentral Plugin RepositoryCentral Templates Repository Top trattos Post subject: Posted: Wed Oct 25, 2006 4:48 am Joined:
RTM; ELIM instance; "Enter a value for this filter" ; REGEXP; RLIKE; regular expression Technote (troubleshooting) Problem(Abstract) There are error messages in cacti.log like below, " 05/01/2014 05:05:05 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1139', http://forums.cacti.net/about16947.html SQL:"SELECT distinct host.id,host.hostname FROM host LEFT JOIN grid_clusters ON grid_clusters.clusterid=host.clusterid INNER JOIN grid_hostgroups ON grid_hostgroups.clusterid=host.clusterid AND grid_hostgroups.host=host.hostname WHERE grid_clusters.disabled='' AND grid_clusters.clusterid=5 AND (grid_hostgroups.groupName RLIKE '*')" " Symptom ELIM graph cannot be generated. Cause The operand of REGEXP/RLIKE http://www.ibm.com/support/docview.wss?uid=isg3T1020779 is not a valid regular expression. Resolving the problem Resolve this issue by the following procedure, 1 On Platform RTM WEB GUI navigate to Console -> ELIMs. 2 Edit the ELIM instance in question. 3 Modify field "Enter a value for this filter" to a valid regular expression. Cross reference information Segment Product Component Platform Version Edition IBM Spectrum Computing IBM Spectrum LSF RTM Server Document information More support for: Platform RTM Software version: 9.1.2 Operating system(s): Platform Independent Reference #: T1020779 Modified date: 2014-05-14 Site availability Site assistance Contact and feedback Need support? Submit feedback to IBM Support 1-800-IBM-7378 (USA) Directory of worldwide contacts Contact Privacy Terms of use Accessibility