[SOLVED] Cacti Spine poller issue

Post general support questions here that do not specifically fall into the Linux or Windows categories.

Moderators: Developers, Moderators

Post Reply
maximoramirez
Posts: 8
Joined: Mon Nov 26, 2007 12:33 pm
Location: Miami Shores, Fl

[SOLVED] Cacti Spine poller issue

Post by maximoramirez »

Hello Anyone out there,

I keep getting errors such as this:

11/26/2007 12:34:02 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 (19,'mem_buffers','2007-11-26 12:34:01','473720'),(20,'mem_swap','2007-11-26 12:34:01','779144'),(21,'','2007-11-26 12:34:01','Time:3.2265 Method:spine Processes:1 Threads:50 Hosts:34 HostsPerProcess:34 DataSources:160 RRDsProcessed:84'),(23,'','2007-11-26 12:34:01','1min:0.00 5min:0.04 10min:0.06'),(25,'proc','2007-11-26 12:34:01','81'),(128,'','2007-11-26 12:34:01','total:0 incoming:0')'

I'm also getting this error:

11/26/2007 12:48:02 PM - POLLER: Poller[0] WARNING: Poller Output Table not Empty. Potential Data Source Issues for Data Sources: mem_buffers(DS[19]), mem_swap(DS[20]), (DS[21]), (DS[23]), proc(DS[25]), traffic_in(DS[26]), traffic_out(DS[26]), traffic_in(DS[27]), traffic_out(DS[27]), traffic_in(DS[28]), traffic_out(DS[28]), traffic_in(DS[29]), traffic_out(DS[29]), traffic_in(DS[30]), traffic_out(DS[30]), traffic_in(DS[31]), traffic_out(DS[31]), traffic_in(DS[57]), traffic_out(DS[57]), traffic_in(DS[58]), traffic_out(DS[58]), traffic_in(DS[59]), traffic_out(DS[59]), traffic_in(DS[60]), traffic_out(DS[60]), traffic_in(DS[61]), traffic_out(DS[61]), traffic_in(DS[62]), traffic_out(DS[62]), traffic_in(DS[63]), traffic_out(DS[63]), traffic_in(DS[64]), traffic_out(DS[64]), traffic_in(DS[65]), traffic_out(DS[65]), traffic_in(DS[66]), traffic_out(DS[66]), traffic_in(DS[67]), traffic_out(DS[67]), traffic_in(DS[68]), traffic_out(DS[68]), traffic_in(DS[69]), traffic_out(DS[69]), traffic_in(DS[70]),

I'm using 0.8.7 . .. .. I'm not sure about upgrading to 0.8.7 a since it has not been posted as a stable version...


Please Help!!
Top
User avatar
BSOD2600
Cacti Moderator
Posts: 12171
Joined: Sat May 08, 2004 12:44 pm
Location: USA

Post by BSOD2600 »

Yes, upgrade to 0.8.7a and apply the functions.php patch in the announcement forum first. Also, upgrade your spine version which was just re-released.
Top
maximoramirez
Posts: 8
Joined: Mon Nov 26, 2007 12:33 pm
Location: Miami Shores, Fl

Post by maximoramirez »

Thanks BSOD2600 ... I will try that tomorrow and see how it goes....
Top
maximoramirez
Posts: 8
Joined: Mon Nov 26, 2007 12:33 pm
Location: Miami Shores, Fl

Post by maximoramirez »

Hello BSOD2600 ... .

I've upgraded to 0.8.7a .... download the functions.php file from the announcements forum ... upgraded the spine version ... These is my config now:
Cacti Version - 0.8.7a
Plugin Architecture - 1.4
Poller Type - Cactid v
Server Info - Linux 2.6.9-55.0.6.plus.c4smp
Web Server - Apache/2.0.59 (CentOS)
PHP - 5.1.6
PHP Extensions - libxml, xml, wddx, tokenizer, sysvshm, sysvsem, sysvmsg, standard, SimpleXML, sockets, SPL, shmop, session, Reflection, pspell, posix, mime_magic, iconv, hash, gmp, gettext, ftp, exif, date, curl, ctype, calendar, bz2, zlib, pcre, openssl, apache2handler, gd, mysql, mysqli, PDO, pdo_mysql, pdo_sqlite, snmp, eAccelerator
MySQL - 5.0.48
RRDTool - 1.2.23
SNMP - 5.1.2
Plugins
  • Device Tracking (mactrack - v1.1)
    Global Plugin Settings (settings - v0.2)
    Thresholds (thold - v0.3.6)
    Large Site Performane Booster for Cacti (boost - v1.6)
    Device Monitoring (monitor - v0.8)
    Network Discovery (discovery - v0.7)
    Network Tools (tools - v0.2)
    Syslog Monitoring (syslog - v0.5)
    RRD Cleaner (rrdclean - v1.1)
    Update Checker (update - v0.3)
    FlowView (flowview - v0.3)
    Host Info (hostinfo - v0.1)
    Error Images (errorimage - v0.1)
    PHP Network Weathermap (weathermap - v0.93)
    Create Aggregate Graphs (aggregate - v0.63)
    Documents (docs - v0.1)
    report it! (ReportIt - v0.4.2)
Now i'm getting the following erros:

Fatal error: Call t...

11/27/2007 02:04:03 PM - SPINE: Poller[0] Host[1] DS[128] WARNING: Result from SCRIPT not valid. Partial Result:

11/27/2007 02:04:03 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 (26,'traffic_in','2007-11-27 14:04:02','846317080'),(26,'traffic_out','2007-11-27 14:04:02','2944520437'),(27,'traffic_in','2007-11-27 14:04:02','1995396572'),(27,'traffic_out','2007-11-27 14:04:02','4279703368')'

The last one is the same as before..... please help!!!
Top
maximoramirez
Posts: 8
Joined: Mon Nov 26, 2007 12:33 pm
Location: Miami Shores, Fl

Post by maximoramirez »

OK...I believe those errors stopped........for some reason I had to update a few of the plugins and all the errors dissappeared so far!!!! I like error free!!! thanks!
Top
User avatar
GlueGuy
Cacti User
Posts: 255
Joined: Fri Nov 04, 2005 3:37 pm
Location: Ca US
Contact:
Contact GlueGuy

Post by GlueGuy »

I seem to be getting these too. Mine's on a Cacti-EZ installation, with the 0.8.7a update applied. Is this some sort of known issue with 0.8.7a? Is there something with individual installations or with certain configurations?

Errors look a lot like the ones posted above:

Code: Select all

11/30/2007 10:50:05 AM - SPINE: Poller[0] ERROR: A database insert failed! Error:'1062', SQL Fragment:'INSERT INTO poller_output (...<snip>
---------
The Glue Guy
Top
Steve Ollis
Posts: 26
Joined: Thu Jan 19, 2006 10:07 pm

Post by Steve Ollis »

I only get these with SPINE.. running with just CMD.php seems fine..

my error is..

12/06/2007 12:39:34 PM - SPINE: Poller[0] ERROR: A database insert failed! Error:'2006', SQL Fragment:'insert into poller_time (poller_id, start_time, end_time) values (0, NOW(), NOW())'
12/06/2007 12:39:34 PM - SPINE: Poller[0] ERROR: A database insert failed! Error:'2006', SQL Fragment:'replace into settings (name,value) values ('date',NOW())'
--
Steve Ollis
Manager, Technology Services
Hillsong Church

[quote][b]Cacti Version[/b] - 0.8.7a
[b]Plugin Architecture[/b] - 1.4
[b]Poller Type[/b] - Cactid v
[b]Server Info[/b] - Windows NT 5.2
[b]Web Server[/b] - Microsoft-IIS/6.0
[b]PHP[/b] - 5.2.5

[b]Plugins[/b][list]Network Discovery (discovery - v0.8.2)
Documents (docs - v0.1)
FlowView (flowview - v0.4)
Host Info (hostinfo - v0.2)
Device Tracking (mactrack - v1.1)
Device Monitoring (monitor - v0.8.1)
NTop Viewer (ntop - v0.1)
Global Plugin Settings (settings - v0.3)
Thresholds (thold - v0.3.8)
Network Tools (tools - v0.2)
Update Checker (update - v0.4)[/list][/quote]
Top
mgeni
Cacti User
Posts: 65
Joined: Fri Mar 25, 2005 8:12 am

Post by mgeni »

I am similar issues with update to 0.8.7a from CactiEZ installation? Any help.

12/06/2007 12:18:03 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 (355,'traffic_out','2007-12-06 12:18:03','4417264814'),(355,'traffic_in','2007-12-06 12:18:03','184112474471813'),(354,'traffic_out','2007-12-06 12:18:03','978031282'),(354,'traffic_in','2007-12-06 12:18:03','87386999'),(353,'traffic_out','2007-12-06 12:18:03','113529018546330'),(353,'traffic_in','2007-12-06 12:18:03','301541806515696'),(352,'traffic_out','2007-12-06 12:18:03','72990993741407'),(352,'traffic_in','2007-12-06 12:18:03','201129184527162'),(347,'traffic_in','2007-12-06 12:18:03','48662427996'),(347,'traffic_out','2007-12-06 12:18:03','173596425812'),(348,'traffic_in','2007-12-06 12:18:03','458878344171749'),(348,'traffic_out','2007-12-06 12:18:03','287375547922045'),(349,'traffic_in','2007-12-06 12:18:03','309229672995576'),(349,'traffic_out','2007-12-06 12:18:03','152014451527868'),(350,'traffic_in','2007-12-06 12:18:03','627502533213471'),(350,'traffic_out','2007-12-06 12:18:03','1456029124076693'),(351,'traffic_in','2007'
Top
Post Reply

Return to “Help: General”

Who is online

Users browsing this forum: No registered users and 0 guests