SQL 1064 Errors

Post support questions that directly relate to Linux/Unix operating systems.

Moderators: Developers, Moderators

Post Reply
brownd1124
Posts: 1
Joined: Fri Dec 05, 2014 3:36 pm

SQL 1064 Errors

Post by brownd1124 »

I recently had some hardware die and had to rebuild my cacti install on some new hardware. I am getting the below error in the logs.

12/05/2014 03:39:09 PM - SPINE: Poller[0] ERROR: SQL Failed! Error:'1064', Message:'You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'outside' interface' WHERE host_id='405' AND data_query_id='1' and arg1='.1.3.6.1' at line 1', SQL Fragment:'UPDATE poller_reindex SET assert_value='Adaptive Security Appliance 'outside' interface' WHERE host_id='405' AND data_query_id='1' and arg1='.1.3.6.1.2.1.2.2.1.2.2''

I have visited http://bugs.cacti.net/view.php?id=2268 an tried applying the patch provided. When I do I my server stops graphing and I get this over and over.

09/23/2008 10:05:01 PM - POLLER: Poller[0] Maximum runtime of 58 seconds exceeded. Exiting.

I see it mentioned on the bugs site that the patch should apply against spine089 as well as 088. Any suggestions?

Date Fri, 05 Dec 2014 15:44:59 -0500
Cacti Version 0.8.8a
Cacti OS unix
SNMP Version NET-SNMP version: 5.5
RRDTool Version RRDTool 1.3.x
Hosts 365
Graphs 42446
Data Sources Script/Command: 5
SNMP: 1062
SNMP Query: 56357
Total: 57424
Poller Information
Interval 60
Type SPINE 0.8.8a Copyright 2002-2012 by The Cacti Group
Items Action[0]: 142607
Action[1]: 5
Total: 142612
Concurrent Processes 2
Max Threads 80
PHP Servers 10
Script Timeout 35
Max OID 30
Last Run Statistics Time:26.4563 Method:spine Processes:2 Threads:80 Hosts:366 HostsPerProcess:183 DataSources:142608 RRDsProcessed:0
PHP Information
PHP Version 5.3.3
PHP OS Linux
PHP uname Linux kopprdnsapp11.gsiccorp.net 2.6.32-504.el6.x86_64 #1 SMP Wed Oct 15 04:27:16 UTC 2014 x86_64
PHP SNMP Installed
max_execution_time 120
memory_limit 1024M
Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest