SQL Fragments and Spine Segmentation faults

Post support questions that relate to the Windows 2003/2000/XP operating systems.

Moderators: Developers, Moderators

Post Reply
User avatar
thisted
Cacti User
Posts: 69
Joined: Fri Apr 15, 2005 10:11 am
Location: Bay City, MI
Contact:

SQL Fragments and Spine Segmentation faults

Post by thisted »

I'm getting some errors in my log like the following:
08/14/2009 02:40:17 PM - SPINE: Poller[0] ERROR: A database insert failed! Error:'1062', SQL Fragment:'INSERT INTO poller_output (local_data_id, rrd_name, time, output) VALUES (821,'hdd_used','2009-08-14 14:40:13','9884053504'),(821,'hdd_total','2009-08-14 14:40:13','15718473728'),(825,'cpu','2009-08-14 14:40:13','0'),(826,'traffic_in','2009-08-14 14:40:13','47092470'),(826,'traffic_out','2009-08-14 14:40:13','8749200')'
08/14/2009 02:40:13 PM - SPINE: Poller[0] ERROR: A database insert failed! Error:'1062', SQL Fragment:'INSERT INTO poller_output (local_data_id, rrd_name, time, output) VALUES (735,'users','2009-08-14 14:40:12','7'),(740,'hdd_used','2009-08-14 14:40:12','1350369280'),(740,'hdd_total','2009-08-14 14:40:12','3488808960'),(741,'cpu','2009-08-14 14:40:12','1'),(742,'cpu','2009-08-14 14:40:12','1'),(745,'traffic_in','2009-08-14 14:40:12','3733958892'),(745,'traffic_out','2009-08-14 14:40:12','2932183338')'
after doing some searches I found where that means the poller is actually running multiple times, and violating primary key constraints.

I tried reducing my threads from 8(the number of processors my machine has) to 1, which cause me to get two segmentation faults two polls in a row, so I switched that back.

Details:
Cacti Version - 0.8.7d
Plugin Architecture - 2.4
Poller Type - Cactid v 8.7a
Server Info - Windows NT 6.0(server 2008)
Web Server - Apache/2.2.11 (Win32) PHP/5.2.8
PHP - 5.2.8
PHP Extensions - bcmath, calendar, com_dotnet, ctype, session, filter, ftp, hash, iconv, json, odbc, pcre, Reflection, date, libxml, standard, tokenizer, zlib, SimpleXML, dom, SPL, wddx, xml, xmlreader, xmlwriter, apache2handler, gd, ldap, mysql, snmp, sockets, sqlsrv
MySQL - 5.1.31-community
RRDTool - 1.2.26
Plugins
  • Global Plugin Settings (settings - v0.5)
    PHP Network Weathermap (weathermap - v0.95b)
    Host Info (hostinfo - v0.2)
    Network Tools (tools - v0.3)
    Login Page Mod (loginmod - v1.0)
    Documents (docs - v0.1)
    Syslog Monitoring (syslog - v0.5.2)
    Update Checker (update - v0.4)
    Router Configs (routerconfigs - v0.1)
    FlowView (flowview - v0.5.2)
I have it scheduled in task scheduler to run every 5 minutes.

Image
Attachments
cacti.JPG
cacti.JPG (149.16 KiB) Viewed 1109 times
User avatar
BSOD2600
Cacti Moderator
Posts: 12171
Joined: Sat May 08, 2004 12:44 pm
Location: USA

Post by BSOD2600 »

Cacti and spine 0.8.7e are the latest, give those a shot.
Post Reply

Who is online

Users browsing this forum: No registered users and 0 guests