Cacti Cmdphp Poller 0 Error Sql Assoc Failed
Contents |
ERROR: SQL Assoc Failed Moderators: Moderators, Developers cacti mysql password Page 1 of 2 [ 16 posts ] Go to
Mysql Error 2006
page 1, 2 Next Previous topic | Next topic Author Message mistery Post subject: CMDPHP: mysql repair database Poller[0] ERROR: SQL Assoc FailedPosted: Sat Oct 21, 2006 3:45 am Joined: Tue May 02, 2006 1:03 amPosts: 3 Hello, I have upgraded Cacti to
Mysql Repair Table
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 dam
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
the board administrator or webmaster: forums@cactiusers.org Powered by phpBB Forum Software © phpBB Group