after doing some searches I found where that means the poller is actually running multiple times, and violating primary key constraints.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')'
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:
I have it scheduled in task scheduler to run every 5 minutes.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)